Oracle,Dynamics,Great,Plains,I computer Oracle to Dynamics GP Great Plains Integration Notes
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
then you might be interested in cross platform integrationbetween Dynamics GP and Oracle application. Again, if you have Great Plains Dynamics implemented, it is ratherlegacy MRP and ERP systems situation, where either Oracle or Great Plains isthe legacy, depending on your corporate IT strategy. In this small publication we would like toreview Oracle integration options to Great Plains Dynamics GP: 1. DynamicsGP SDK. We recommend you to review GPeConnect, as the set of libraries for your integration gateway to programbidirectional integration to and from Dynamics GP. You can deploy eConnect in Microsoft VisualStudio .Net C# or VB project, from where you could also call ODBC gateway toOracle database world. You can eitherschedule eConnect gateway in batch integration scenario, or call it in realtime with parameters of current transaction 2. DynamicsGP Integration Manager. This scenario ismore user friendly , but at the same time less flexible (if you are programmerand seeking for sophisticated custom integration logic). You can also schedule Dynamics GP IM in batchintegration mode (look for generic Windows application macro solutions, whereyou can call EXE application with parameters, or simply purchase IM schedulerfrom Microsoft Business Solutions Dynamics GP reseller) 3. Connectionto Oracle. Here you may think about severaltechnologies. If you are working forOracle shop IT department, you should be already familiar with ODBC options atthe Oracle end. If you are in MicrosoftSQL Server type of circle, consider creating SQL Linked Server (in MS SQLServer 2005 or 2000) to open the door to Oracle databases 4. Textfiles as Data interchange, CSV and Tab Delimited. This approach is feasible if your Oracleresides in Unix or upscale Linux (also consider XML data interchange, which isrelative to the idea of platform independent text file). Text files, exported from Oracle databaseshould be easy to process either in Dynamics GP Integration Manager or eConnectAdd-on. If you have the objective tomove your GL transactions from Dynamics GP General Ledger to Oracle Financials,you can easily export new Dynamics GP GL records via SQL view from GL20000table
Oracle,Dynamics,Great,Plains,I