Andrew Karasev

Oracle to Dynamics GP Great Plains Integration Notes

If you work for large organization, which has independent subsidiaries and branches, running various ERP and accounting systems: Microsoft Dynamics GP, SAP Business One for example, and in the headquarters you have custom Oracle database application deployed (CRM, Sales Order Processing, EDI, eCommerce web site, Warehouse Management, Quality Control, etc.),

then you might be interested in cross platform integration between Dynamics GP and Oracle application.  Again, if you have Great Plains Dynamics implemented, it is rather legacy MRP and ERP systems situation, where either Oracle or Great Plains is the legacy, depending on your corporate IT strategy.  In this small publication we would like to review Oracle integration options to Great Plains Dynamics GP:

1.       Dynamics GP SDK.  We recommend you to review GP eConnect, as the set of libraries for your integration gateway to program bidirectional integration to and from Dynamics GP.  You can deploy eConnect in Microsoft Visual Studio .Net C# or VB project, from where you could also call ODBC gateway to Oracle database world.  You can either schedule eConnect gateway in batch integration scenario, or call it in real time with parameters of current transaction

2.       Dynamics GP Integration Manager.  This scenario is more user friendly , but at the same time less flexible (if you are programmer and seeking for sophisticated custom integration logic).  You can also schedule Dynamics GP IM in batch integration mode (look for generic Windows application macro solutions, where you can call EXE application with parameters, or simply purchase IM scheduler from Microsoft Business Solutions Dynamics GP reseller)

3.       Connection to Oracle.  Here you may think about several technologies.  If you are working for Oracle shop IT department, you should be already familiar with ODBC options at the Oracle end.  If you are in Microsoft SQL Server type of circle, consider creating SQL Linked Server (in MS SQL Server 2005 or 2000) to open the door to Oracle databases

4.       Text files as Data interchange, CSV and Tab Delimited.  This approach is feasible if your Oracle resides in Unix or upscale Linux (also consider XML data interchange, which is relative to the idea of platform independent text file).  Text files, exported from Oracle database should be easy to process either in Dynamics GP Integration Manager or eConnect Add-on.  If you have the objective to move your GL transactions from Dynamics GP General Ledger to Oracle Financials, you can easily export new Dynamics GP GL records via SQL view from GL20000 table

Article Tags: Great Plains

Source: Free Articles from ArticlesFactory.com

ABOUT THE AUTHOR