Software informational articles

Microsoft great plains integrations - tips for developer - software


In this short FAQ style condition we would like to bring in you - software developer, programmer, file bureaucrat into Microsoft Great Plains Integration tools and options

Microsoft Great Plains is main Microsoft Affair Solutions creation for US mid-market. Historically Great Plains Software calculated Great Plains Dynamics and Dynamics C/S+ as multiplatform attention and the integration was likely via Great Plains Adroitness or Dexterity-based end user tools, such as Import Convenience and later on via Integration Manager. When Microsoft Windows platform won the OS promote (the last argue was in 1997 with PowerMac) Great Plains not compulsory OLE Attendant approach: Continuum for VB and Delphi and new Microsoft light encoding expertise - VBA (Visual Basic for Applications), which was integrated into Adroitness concentration - Great Plains Modifier (requires customization site enabler license). Since then Great Plains Dynamics/eEnterprise integration techniques use Microsoft technologies.

1. Microsoft SQL Head waiter approach. This integration performance uses SQL stored procedures and views to pull data from your bequest or third party claim and push it into Great Plains. The nice thing about MS SQL Attendant - it has connected ma?tre d' knowledge - you can begin the link to effectively all ODBC ir OLEDB acquiescent databases: Oracle, DB2/Unidata, Sybase, Ingress, Lotus/Domino, Invasive SQL/Btrieve, Ctree/Faircom, Microsoft Access, Foxpro to name a few. You can schedule your integration as maintenance job or DTS package. Nevertheless keep in mind that Great Plains tables arrange is fairly byzantine (it has master records, summaries, historical, work, open tables) and you be supposed to almost certainly verify your stored procedures big business logic with Great Plains find code (DYNAMICS. DIC with Ability procedures and functions scripts - in conventional DYNAMICS. DIC these are stripped out - not every MBS partner has basis code subscription - so do your assortment work)

2. Great Plains Agility integration with Great Plains deal with server. This is more difficult and suggested approach, in spite of this it requires cutting edge Ability encoding skills and contact to the font code. The idea after is clean - you populate so-called triggering custom table and then check it from Ability custom claim every 5 seconds or so. If the album is there - then you administer it. Dealing out is customarily Adroitness basis code stored modus operandi call. Great Plains uses comparable logic when you post the batch and see the class in Course Keep an eye on window. If you don't have cause code - you can try to do the best guess with Microsoft Great Plains Software Education Kit (SDK)

3. Great Plains Integration Manager. This is end user tool and is easy to use. But - it uses Great Plains as OLE Head waiter and calls Great Plains forms after the scenes. As the consequence - it is very slow - we commend using integration executive when you have up to one thousand transactions per day.

4. eConnect - it is type of Software Advancement Kit with samples in VB. Net. Apparently the advancement background ought to be Visual Studio. Net. eConnect will allow you to integrate master proceedings - such as new customers, vendors, employees, etc, plus you can bring transactions into so called Great Plains work tables (eConnect doesn't allow you to bring open or chronological proceedings - you need to post work proceedings in Great Plains, the same limitation applies to Integration Boss above) eConnect is moderately for ongoing integration. It was at first formed for eCommerce claim integration to Great Plains.

Happy integrating! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum. com

About The Author

Andrew Karasev is Chief Know-how Executive in Alba Spectrum Technologies - USA all over the country Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Los Angeles, San Diego, San Francisco, Denver, Houston, Dallas, New York, Boston, Atlanta, Miami, Canada, UK, Australia and having locations in numerous states and globally (www. albaspectrum. com), he is Dexterity, SQL, C#. Net, Gem Information and Microsoft CRM SDK developer; akarasev@albaspectrum. com

Developed by:
home | site map © 2018