Integration: Microsoft Great Plains Dynamics GP

Integration: Microsoft Great Plains Dynamics GP – Alba Spectrum

Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577

Please, consider Great Plains Dynamics GP as mid-size of even large scale ERP. This means that data sitting in SQL database if ruled by pretty complex MRP application business logic. The above statement should help you to calm down and take conservative approach to the situation when somebody from IT or software programming and development world tells you that it will “take 10 minutes” to integrate something (your legacy database or retail transactions) with Microsoft Dynamics GP Great Plains company database. Additional complexity here is actually attributed to the fact that GP is Dexterity-driven application, and in turn Dex was designed as DB platform independent IDE (DEX_ROW_ID, DYNAMICS.DIC, DYNAMICS.SET, DEX.INI to name a few dex constructions)

Try End-User Tools first. Again, please calm down and try what Microsoft Business Solutions recommends as user friendly tool: Microsoft Dynamics GP Integration Manager (IM). This tools validates GP business logic and will not allow you to force to GP something that will fail in following data life
SQL Scripting. This is the next step, when IM doesn’t do the job (in some cases you have to take this route, because you do not have enough funds to purchase IM license). Well, if you consider yourself as strong MS SQL Server DBS and at the same time SQL Server developer, you should first review in depth GP tables structure and familiarize yourself with GP check links functionality; be sure that you have backup of your company database prior to all the steps where you do UPDATE statement in SQL (or INSERT statement)
Ctree Faircom/Pervasive SQL Btrieve. If you are on these legacy (no longer supported by MBS) DB platforms, we recommend you to use something like MS Access, where you can link to GP tables via ODBC data source. ODBC SQL scripting doesn’t support all the SQL standards and so is just a subset of functionality available in MS SQL Server, however you may find that it still does the job for you

Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Microsoft Dynamics GP Great Plains customers in USA/Canada nationwide. Local service is available in Dallas and Houston, TX: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village; Chicago, IL: Naperville, Aurora, Bolingbrook, Romeoville, Joliet, Wheaton, Lisle, Downers Grove, Schaumburg, Elk Grove, Lombard, Woodridge, Darien, Westmont, Batavia, St. Charles, Elgin, Crystal Lake.

International: Brazil-English Brasil-Portuguese

We serve large scale Microsoft Dynamics GP Great Plains Customization, Data Conversion/Massage/Migration, version upgrade, custom software development and integration to GP, heterogeneous reporting for GP: SQL Server Reporting Services, Crystal Reports; Visual Studio.Net programming for GP, including eConnect, ADO to GP database; complex GP data repair (when somebody damaged GP data via inaccurate UPDATE SQL statement)