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,Nike SB Dunk High Heel Rød Sort Hvid, SAP Business One for example,Nike Free Run Sko Gul Grå, and in the headquarters you have custom Oracle database application deployed (CRM, Sales Order Processing, EDI, eCommerce web site,Nike Dunk High Heel Red Black Sneakers, Warehouse Management, Quality Control, etc.),www.timberlandschuheshop.com, then you might be interested in cross platform integration between Dynamics GP and Oracle application. Again,Nike Air Force 1 Kvinder High Metallic Silver Blå, 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,Christian Louboutin peep dame 150mm chaussures nudevente au rabais, 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,Christian Louboutin de sortie Booty simple 100mmvente pas cher, 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,MBT Fora Lace-up-Sneaker, 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,Nike Air Force 1 All Star La Collection Orange, 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,Mbt Sandalen Jawabu, 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 Financials, you can easily export new Dynamics GP GL records via SQL view from GL20000 table 相关的主题文章：
没有评论:
发表评论