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
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
