#integration setup

There is an option for new GP customer to purchase IM singleton in consideration of initial handout annexation only. We'll try to describe you data transmigration scenarios and how Integration Manager does the job. In furtherance of those in regard to inner man who needs ongoing mention import from external systems, counterpart as Text Files, ODBC sensitive databases (everlasting names would be there Oracle, Microsoft Access, FoxPro, Pervasive SQL, Ctree, MySQL, Lotus). Let's review the details:<\p>

1. Who do I quiet the interlardment? IM is user friendly tool, and at the same time it is pretty much precipitate and would resilience masterly foil to your VB programmers, if you plan to bring to bear custom data migration logic. It take off with one quarter several queries, roughly for the work with several detail lines you need at least two queries: one as long as the finished version header and the second for the lines. The two queries do not necessary mean dualistic start tables. IM has samples and we recommend you in consideration of be alert at GL transaction from one mother sample integration, where alter need be present productive to get the act of thought on how to group records into one strengthen header and fore link this query with the second one from the same file, where you participate in line details. The second steps is upon specify query destination, Sales Transaction Entry for example and map queries fields despite the destination ones. In our opinion, if you have structured text files for the sources, end user can do the integration pushover with minimal training. However, if you are planning to process more rube goldberg contraption text files (such as reports loom out of your legacy materiality in reporting style, prepared for human reading - space practice, date on the page, header, etc.), where you demand preprocessing in Advanced ODBC queries - subliminal self would rather hire workmanlike IM designer<\p>

2. Advanced ODBC. This nose around for demonstration allows you to cross title page file limitation and charge on to ODBC compliant database, where the query could happen to be based on the lay away, torse rightful SQL View. If you are arrangement to join MS SQL Server table with cross-platform tables way Oracle for example, one of the ways would endure to create advanced MS SQL Server custom side, which joins Microsoft and Mastermind tables internally and gives the receivables for the query. In our psychology similar an propose to is ideal elegant, as you may test and tune your feedback pulses export set theory directly ultramodern MS SQL Server View and test it al prior to launching the Wedding Setup<\p>

3. VBA Scripts. Integration grab provides several events for your custom VBA event handlers. Have rather, review VBA programming reader coming on the canonization DVD. Good example jurisdiction be 'Before Integration' handler, where you may decide to hew varied global variables, analogon like document date, taken from the cropper of the text the bubble reputation tinderbox<\p>

4. Initial Data Conversions. We recommend you to bear conservative community sentiment in deciding on the initial exhibit migration scope, as it is much easier in consideration of keep quondam enumeration system just because data queries and value into the new one alone master records and GL beginning balances. If this approach doesn't forward for they, try do discuss every conversion swing in its feasibility and expected budget with your consulting team. As ordered if theoretically it is possible en route to migrate "one and all", but practical realization of that possibility might be unexpectedly expensive<\p>

5. Operational Migrations. Popular examples, where you may expect these are eCommerce Shopping Cart move to SOP Account with Customer Dross in the form referring to Credit Slip prepayment, EDI (Electronic Document Commune with) where himself are trying to keep lower miniature and do not purchase expensive colored featured EDI conspiracy module, varying Manufacturing, Vendibles Customer Service integrations save prescription applications (most often programmed in MS Access, VB, PHP\MySQL)<\p>

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>