Great,Plains,Reseller,Integrat computer Great Plains Reseller: Integration Manager Advanced Techniqu
----------------------------------------------------------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 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
The techniques, described in this article were actually available for old Integration Manager connectors, however they were not practical, until eConnect virtually resolved integration speed and performance. With eConnect integrations you can move up to ten transactions per second, as eConnect is calling encrypted SQL Stored Procedures, comparing to validating GP logic in OLE driven Great Plains Dexterity forms in old versions of IM. Lets consider scenario, when you have to convert the whole year of GL records for large company with several thousand transactions per week. Here is what you do:1. Export data in tab or comma delimited text format and import it into Microsoft SQL Server in the form of staging tables. Then massage the data in the tables: remove quote marks, for example, where you have Debit and Credit fields. Next step consider creating SQL views, which will be the base for Advanced ODBC queries in the next paragraph2. Advanced ODBC queries, based on SQL ODBC driver. You can use Dynamics GP DSN for elegancy. If you already tried to group, aggregate data in ODBC queries, based on Text Driver, you probably had very disappointing experience. You should be surprised in the case of Dynamics GP DSN you do not see those annoying error messages, attributed to poor Text Driver3. GL Header Source. Select transaction number only, plus alternatively use MAX construction to add Transaction date and group by transaction number4. GL Lines Source. Simply use select star statement from your SQL view. Then link two sources by transaction number field and potentially preview both sources to be sure you are on the right side of the road5. Save and Run Integration. Please, note here, that eConnect integration connector doesnt require you to close all GP windows (as you remember OLE connector required). If you are moving huge volume of transactions, you can look at them showing up in GP while integration is in progress6. Now you should be at the point, where IM helps you do what you were doing in the past with low level insert scripts and obviously were fighting with data integrity. As you know IM validates business logic and doesnt let inconsistent records move in
Great,Plains,Reseller,Integrat