| |
Microsoft Great Plains Dynamics GP Integration Manager
By Andrew Karasev
Microsoft Dynamics GP advanced Integration Manager techniques: VBA scripting, advanced ODBC queries, translation
Integration Manager itself is often considered as end-user tool. However it is also powerful in custom integration, and here we would like to give you some directions and highlights. Before coming to technologies, we should tell you that integration manager integration validates GP business logic and so is the most reliable and probably in many cases preferable way. In some cases, IM performance might not be sufficient (when you move to GP thousands of transactions every hour, for example), however as IM will be rewritten in eConnect – its performance should suffuse such challenging data feedings as well
• Text documents. When you need to import report-like text file, containing for instance AP invoices with line items, here you need to design advanced ODBC queries. One query will be providing Invoice header, the second one will be giving Invoice lines or items. ODBC has some restrictions, it is not full-featured SQL environment, however it supports select with such clauses as where, group, etc.
• VBA scripting. Yes, it is still valid for version 9.0 of Dynamics GP. VBA scripting allows you to do such advanced things as make ODBC connection to cross-platform: Oracle DB, IBM DBII, Pervasive SQL, Ctree/Faircomm, Progress, etc, get info from there and apply business logic to incoming data, based on the cross-platform SQL query
• Translation. When you accept source field as incoming data, you may decide to translate incoming value to what it has to be in GP. Look translation feature for the field. Translation values could be even copied from Excel table
• Before Document Script. This scrip will allow you to reject text lines, that are line feed, carriage return, etc. It is helpful when you are importing data from text reports, produced by one of your legacy systems
• Spoke and Hub ERP model. You may have situation, when your headquarters uses GP and subsidiaries non-Microsoft MRP platforms, such as Oracle Financials/eBusiness Suite/Applications, SAP Business One, Microsiga, Peachtree, MYOB, SAGE, MAS 2000, etc. In this case IM may help you with data consolidation. Typically you need GL level consolidation. IM can process IDE type of file or even structured report (with VBA scripting and advanced ODBC queries)
• Beyond Integration Manager. If you are comfortable with .Net, C#, VB, XML Web Services you can program advanced integration with eConnect – feel free to use Microsoft Visual Studio.Net
Please, feel free to call us: 1-866-528-0577, 1-630-961-5918 or email: help@albaspectrum.com , for skype users: albaspectrum
About the Author
Alba Spectrum Group ( http://www.albaspectrum.com http://www.enterlogix.com.br ) is serving customers in Illinois, California, Missouri, Alabama, Texas, Florida, Colorado, Wisconsin, Indiana, Nebraska, Utah, New York, Arizona, Michigan, Georgia, Virginia, Washington, Minnesota, New Mexico, Louisiana, and US Nation-wide and internationally
Article Source: http://www.simplysearch4it.com/article/38680.html
| If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/38680.html" as shown above and make it hyperlinked. |
| Some other articles by Andrew Karasev | SAP Business One Implementation for Multinational Companies with subsidiaries in Brazil
SAP B1 has over 200 installations in Brazil at this time and the number of new customers is growing. In this article we would like to recommend SAP BO as ERP ...
SAP Business One in Illinois: implementation, upgrade, customization, integration
Chicago metropolitan area and downstate Illinois might be characterized as mid-west distribution place. This means that we see large number of ...
SAP Business One Chicago Market Review, plus customization, integration & data conversion
SAP B1 is becoming more popular in the USA, increases number of implementation each year substantially. Originally designed by one of the Israel software development companies, now it is part of ...
Microsoft Dynamics GP Office Stack Integration advances –
Microsoft Great Plains Dynamics GP is on the way of Microsoft Dynamics or former Microsoft Project Green advances. Great Plains ...
eConnect and Microsoft Dexterity: Dynamics GP development tools comparison notes
This article is dedicated to Microsoft Great Plains eCommerce and web software development primarily, plus Microsoft Dynamics GP customization, integration, data conversion and reporting. As software programmer you should know ...
Microsoft Dynamics GP Dexterity Customization
Microsoft Great Plains software development, customizations, reporting. Microsoft Dexterity programming as reliable alternative to newer technologies and platforms, such as .Net, C# and VB MS Visual ...
|
|
| |
|
