Article Categories

»	Arts & Entertainment
»	Automotive
»	Business
»	Careers & Jobs
»	Education & Reference
»	Finance
»	Food & Drink
»	Health & Fitness
»	Home & Family
»	Internet & Online Businesses
»	Miscellaneous
»	Self Improvement
»	Shopping
»	Society & News
»	Sports & Recreation
»	Technology
»	Travel & Leisure
»	Writing & Speaking

Reprint Article Code

Category: Articles » Technology » Computer Software » Article » Article Code

Microsoft Great Plains Dynamics GP Integration Manager

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 ... read more

Article Title:

Article Body:

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

Author Bio:

Some other recently published computer software articles

How to Evaluate Survey Software in 3 Steps by Brian Henderson
There's too many companies selling survey software and the industry has branching into several categories without any one category becoming ...

A practical use of Open Source Code Softwares by Roberto Sedycias
As we started the project of our web site, we knew that the proprietary software costs would be too high for our financial resources. Our only option then was to make use ...

Clean up sensitive information in a secure way! by Alexander Rodichev
If you value your privacy or have concerns about security of your sensitive data, you already know that there is no easy way to securely delete a file in ...

Advantages Of Buying A Non Profit Accounting Software by Javier Fuller
Accounting software solutions are meant to serve varied needs. These software could be broadly classified into two categories such as software solutions for profit making enterprises and software solutions for ...

Remove Protection and Recover OpenOffice Documents After Losing a Password by Dmitry Rozenbaum
OpenOffice gains more and more popularity every day. It's a completely free suite of office products that includes almost everything Microsoft Office ...

Microsoft's Windows Vista by Vinay Choubey
Windows Vista is the next version of Windows for clients and servers. With the client version expected in 2006 for businesses and 2007 for consumers and the server version in 2007, Vista adds numerous features, including improved ...

Publisher Guidelines

You may reprint this article electronically in your newsletter or on your website, free of charge.

If you reprint this article from our site, then you must keep everything intact. This includes the articles title, author name, articles body, authors bio / resource box, the links contained within the article, all copyright notices and the link pointing back to our site. All links within the article must also be made active / hyperlinks.