Microsoft Abundant Plains Integrations - tips for developer

 31 December 18:00   

    Microsoft Abundant Plains Integrations - tips for developer   by Andrew Karasev

    In this abbreviate FAQ appearance commodity we would like to acquaint you - software developer, programmer, database ambassador into Microsoft Abundant Plains Affiliation accoutrement and options

    Microsoft Abundant Plains is capital Microsoft business Solutions artefact for US mid-market. Historically Abundant Plains software advised Abundant Plains Dynamics and Dynamics C/S+ as multiplatform appliance and the affiliation was accessible via Abundant Plains Ability or Dexterity-based end user tools, such as Acceptation Account and after on via Affiliation Manager. If Microsoft Windows belvedere won the OS bazaar (the endure action was in 1997 with PowerMac) Abundant Plains recommended OLE Server approach: Continuum for VB and Delphi and new Microsoft ablaze programming technology - VBA (Visual Basal for Applications), which was chip into Ability appliance - Abundant Plains Modifier (requires customization website enabler license). Back then Abundant Plains Dynamics/eEnterprise affiliation techniques use Microsoft technologies.

    1.Microsoft SQL Server approach. This affiliation address uses SQL stored procedures and angle to cull data from your bequest or third affair appliance and advance it into Abundant Plains. The nice affair about MS SQL Server - it has affiliated server technology - you can authorize the hotlink to around all ODBC ir OLEDB adjustable databases: Oracle, DB2/Unidata, Sybase, Ingress, Lotus/Domino, Common SQL/Btrieve, Ctree/Faircom, Microsoft Access, Foxpro to name a few. You can agenda your affiliation as aliment job or DTS package. About accumulate in apperception that Abundant Plains tables anatomy is rather circuitous (it has adept records, summaries, historical, work, accessible tables) and you should apparently verify your stored procedures business argumentation with Abundant Plains antecedent cipher (DYNAMICS.DIC with Ability procedures and functions scripts - in approved DYNAMICS.DIC these are bare out - not every MBS accomplice has antecedent cipher cable - so do your alternative work)

    2.Great Plains Ability affiliation with Abundant Plains action server. This is added avant-garde and recommended approach, about it requires avant-garde Ability programming abilities and admission to the antecedent code. The abstraction abaft is simple - you abide alleged triggering custom table and then analysis it from Ability custom appliance every 5 abnormal or so. If the almanac is there - then you action it. Processing is usually Ability antecedent cipher stored action call. Abundant Plains uses agnate argumentation if you column the accumulation and see the cachet in Action Adviser window. If you don t accept antecedent cipher - you can try to do the best assumption with Microsoft Abundant Plains software Development Kit (SDK)

    3.Great Plains Affiliation Manager. This is end user apparatus and is simple to use. About - it uses Abundant Plains as OLE Server and calls Abundant Plains forms abaft the scenes. As the aftereffect - it is actual apathetic - we acclaim using affiliation administrator if you accept up to one thousand affairs per day.

    4.eConnect it is blazon of software Development Kit with samples in VB.Net. Acutely the development ambiance should be Beheld Studio.Net. eConnect will acquiesce you to accommodate adept annal - such as new customers, vendors, employees, etc, additional you can accompany affairs into so alleged Abundant Plains plan tables (eConnect doesn t acquiesce you to accompany accessible or actual annal - you charge to column plan annal in Abundant Plains, the aforementioned limitation applies to Affiliation Administrator above) eConnect is rather for advancing integration. It was initially created for eCommerce appliance affiliation to Abundant Plains.

    Happy integrating! if you wish us to do the job - accord us a alarm 1-866-528-0577! help@albaspectrum.com