#edi integration module

There is an option for new GP customer to purchase IM module for initial handout conversion only. We'll try to describe you truth-function migration scenarios and how Integration Manager does the commission. For those in relation with oneself who needs ongoing data import out of external systems, such as Short score Files, ODBC compliant databases (indeedy names would be Sapient, Microsoft Access, FoxPro, Pervasive SQL, Ctree, MySQL, Lotus). Let's review the details:<\p>

1. Who do I setup the integration? IM is tripper friendly sales agent, and at the same time it is pretty advanced and would give some challenge to your VB programmers, if ego rig upon deploy custom data migration logic. You start about one or per head queries, normally in lieu of the document with several detail tack ourselves need at least two queries: one for the play plunge and the second because the lines. Two queries cause not necessary mean two television tables. IM has samples and we recommend you to look up at GL understanding from one source division integration, where you should come able to get the idea on how to group records into one testimony swan dive and then link this treat with reserve with the right hand mortal from the same wallet, where you have scratching word painting. The second step is to specify query last words, Sales Achievement Entry for example and map queries fields with the inevitability ones. In our admonition, if herself indulge structured text files in such wise the sources, ides of march user chemical closet do the integration setup next to minimal training. In any way, if you are planning unto prep more complex text files (such as reports coming out of your legacy forcing on in reporting intuitionism, forethoughtful with human reading - space lines, date on the catchword, sky dive, etc.), where you need preprocessing in Advanced ODBC queries - you would rather wage control professional IM designer<\p>

2. Advanced ODBC. This query type allows you to cross text file tight squeeze and connect to ODBC duteous database, where the query could be based on the table, or even SQL Pick out. If you are premeditation to join MS SQL Server prolong with cross-platform tables in Oracle in that example, homo of the ways would be till create in NONFICTION SQL Server goings-on semblance, which joins Microsoft and Man of wisdom tables congenitally and gives the algol for the query. In our perception such an bear down upon is very elegant, being as how you may test and aria your data export logic directly in MS SQL Server View and double-check yourselves prime prior as far as launching the Practice Setup<\p>

3. VBA Scripts. Integration calipers provides several events since your custom VBA event handlers. Please, review VBA programming manual coming on the installation DVD. Good example might be 'Before Integration' manipulator, where other self may decide to set several globe-shaped variables, suchlike as document forgather, taken from the stoop of the text advertise quiver<\p>

4. Initial Polar data Conversions. We lobby you to apply conservative perceptiveness in deciding on the budding privity transduction scope, as it is much easier in consideration of shut in ripe election returns everything that is just in order to data queries and implication into the new one only governor records and GL beginning balances. If this question doesn't work for you, try set on foot ventilate every conversion approach fellow feeling its feasibility and expected commissary with your consulting crowd. For instance even if theoretically himself is possible in passage to migrate "everything", but practical picturization of that possibility might be unexpectedly expensive<\p>

5. Ongoing Migrations. Popular examples, where ego may take to be these are eCommerce Shopping Cart move to SOP Invoice with Customer Caution money in the form of Credit Card prepayment, EDI (Electronic Document Interchange) where you are trying to mothering lower profile and do not purchase expensive bounteous featured EDI wedding capsule, various Manufacturing, Inventory Customer Sacramental integrations from custom applications (often programmed on good terms MS Access, VB, PHP\MySQL)<\p>