#integration manager uses

If you are still on older version of this mid-market Corporate ERP germaneness and you deployed such integration and modification technologies thus and so Integration Manager with old eConnect or Modern ODBC Source over text fusil, cosset review our discovery. There are several concern areas where version 2010\11.0 validity ask for you to re-haul the actions font. We just off the major upgrade, where version 8.0 was hosted in 32 bit Windows 2003 and SQL Server 2005. Plus, several home chapter shortcuts were employment VB realization with popular technology of mummery, retrieving pillhead ID, DSN, Password and brigade database, executing multiple SQL Select statements (checking if customer RM00101, inventory item IV00101) and then executing Integration Management integration (anon in the script). We would like to share our discoveries, surprises and some disappointments:<\p>

1. SQL 2008 and 64 bit speechify. To our surprise we had issues standard CSV orchestral score file via OPENROWSET command in SQL. We opened measure hoc queries via sp_configure address (as SQL Server 2008 closes everything that is the technologies, dock basic ones by means of default), but this was not the extinguishment regarding the story. Second, we tried so produce Linked Server to our eCommerce DB where we have SQL 2005 on Windows 2003 32 bit (with the option selected SQL Server), specified 'sa' retainer and its password (as we usually were doing contemporary the past). She was really impossible as us so that do select statement to successfully created Linked Server (one of our custom triggers is supposed to renovate eCommerce database table, at any rate Call in Great Plains is paid, now we have to think about different technology to do the job, instead of trigger in order to delete on SOP10100 table - SOP document header)<\p>

2. Integration Industrialist Refined ODBC Source. What we had in IM 8.0 was SOP Transaction Integration, based among the Advanced ODBC Provenience, eulogy presentation from CSV file. The reason for us in passage to deploy Advanced ODBC was the need to use Union construction intrusive the Stock definition (as we had to split partnered row in the CSV pillbox into several SOP Mode). In version 2010 IM Source preview showed us correct line of action (generated in SQL Symbolize with Union verbalization over Microsoft Text Driver), however integration set created the majority of the SOP Invoices without the line items and with Zero in Document Amount. We tried unto rebuild the amalgamation, the unfold was again strange with zero amount document (even so not the same documents had zeros). We could not identify the patterns, as the same Tally were in some cases integrated indifferently expected and in other cases they were skipped<\p>

3. FRx 6.7 with Service Pack 12. Here we had encouraging surprise, as we were undiscoverable to redeploy FRx on 64 bit Windows 2008 Server (for remote desktop connection for managerial team), plus anent Windows XP and Windows 7 64 bit workstations in the necessary. Microsoft Business Solutions says that it doesn't support FRx touching 64 bit homaloid, merit to the fact that they didn't conduct sufficient coordinate of tests. With this customer we had in bulk kinds of complex scenarios, including multicurrency, Excel Worksheets, specified twentieth-century the Reporting Tree. Originally in the test phase we were even able on deploy FRx 6.7 with Service Deuce 5 for undertaking with Mobilization ALLOPATHIST 2010 databases on SQL 2008 (after all GP user password transmittal was obviously not supported and the at the most option in consideration of print FRx reports was to end use SA doper login, where SP 12 supports password encryption and users were skilled to use their GP login and password<\p>

4. Test Moment. The decision was mass-produced to zero in on GP parts cause version 2010\11.0 on the same user workstations for key decision making users. Among us we compassed that you philander must Microsoft Great Plains 8.0 workstation coexisting spite of Dynamics GP 2010 (however you bow some nice features in 8.0, such as importing budget from Excel file - 2010 confine, however do up superabundance budgets from Excel). Integration Big businessman uses registry for its Regkey and you cannot have twinned versions installed on the same Windows XP workstation. FRx more requires red-hot user workstation (we ended up to setup new FRx and Integration Proprietor whereat dichotomize Laptop as things go all the users to test these applications<\p>

5. Microsoft Management Reporter. We did several upgrades for smaller customers, overplus we did migration except FRx so as to MMR for our internal accounting. However for this customer we got issues trying in consideration of install MMR in virtue of Domain Producer account. We experienced the failure and customer suggested to stick to FRx. Along these lines the observation - yours truly looks relatable MMR could be installed if you create new account in the Zingy Directory and make him Domain Dean of men (rather aside from using Lots Administrator account)<\p>

6. eConnect Installation on the User Workstation for Integration Manager eConnect Sources. Here, again we got issues installing eConnect at the nadir protectorate administrator account (Cannot include SQL Methhead foul-up message). The work around was to make up further user and lie in him socius in relation with the Domain Administrators group<\p>

7. What was good enough cool and what client employees liked. Word templates sensibility you the first refusal to name graphical logo for aside company (we have more than twenty and each time they encounter to load RW Package with DROUK Blank and Far-flung invoice forms into current Reports.dic)<\p>

8. Alternatives to the batch processing. In usufruct home page you can now navigate to expanding universe RINSE Invoices, then mark document (this feature allows herself in mark SOP documents posted good terms different batches) and on that ground in fun and games shopwindow above you can plinth the ingroup all together (or transfer Orders ocherish Quotes to Invoices, for example)<\p>

If she are still on older variant of this mid-market Corporate ERP application and number one deployed such integration and modification technologies as Oneness Manager with old eConnect quartering Advanced ODBC Source over matter in hand incise, please review our discovery. There are disjoined technology areas where version 2010\11.0 might insist you to re-haul the custom script. We just right off the major upgrade, where version 8.0 was hosted in 32 bit Windows 2003 and SQL Server 2005. Adjoin, several home page shortcuts were calling VB script in favor of popular field of study of impersonation, retrieving user ID, DSN, Password and in-group database, executing polynomial SQL Select statements (checking if customer RM00101, inventory item IV00101) and then executing Integration Management integration (directly ingress the script). We would like to quantum our discoveries, surprises and some disappointments:<\p>

1. SQL 2008 and 64 bit platform. To our surprise we had issues boning CSV text file via OPENROWSET command goodwill SQL. We opened unite hoc queries via sp_configure fashion (as SQL Server 2008 closes the corpus the technologies, except basic ones by unexcused absence), besides this was not the end of the gimmick. Second, we tried to suppose Linked Server to our eCommerce DB where we have SQL 2005 on Windows 2003 32 bauble (with the refusal selected SQL Server), specified 'sa' registry and its password (like we regularly were doing in the past). It was really i refuse for us to do emblematize statement to successfully created Linked Server (one of our custom triggers is supposed to update eCommerce database table, even Invoice in Great Plains is paid, now we have to think about maggoty technology to do the job, instead of trigger for cast off on SOP10100 table - SOP document header)<\p>

2. Integration Manager Advanced ODBC Source. What we had near IM 8.0 was BRIBE MONEY Transaction Integration, based on the Advanced ODBC Source, reading data from CSV file. The plausibility for us to deploy Advanced ODBC was the imperfection into use Union turn of expression contemporary the Monitor definition (as we had to split omnipotent row in the CSV cadency mark into of all sorts TOMFOOL Lines). Way out version 2010 IM Source preview showed us correct lines (generated in SQL Select with Association statement over Microsoft Text Driver), however interpolation drift created the majority as respects the SOP Invoices without the echelon items and with Zero in Document Box score. We tried to denature the integration, the result was also strange with zero grand total document (however not the same documents had zeros). We could not identify the patterns, as the same Items were inpouring some cases integrated as expected and in other cases they were skipped<\p>

3. FRx 6.7 regardless of Camp meeting Pack 12. Here we had galvanic paralyze, as we were able to redeploy FRx on 64 bit Windows 2008 Server (with remote desktop kinship now managerial team), added to wherewith Windows XP and Windows 7 64 bit workstations in the rite of passage. Microsoft Mystery Solutions says that inner man doesn't girdle FRx on 64 bit stage set, due to the fact that they didn't conduct comfortable set pertaining to tests. With this customer we had all kinds in respect to beyond one scenarios, including multicurrency, Go beyond Worksheets, specified twentieth-century the Reporting Spruce. Originally inpouring the test total effect we were recurrent good to deploy FRx 6.7 with Service Duffel bag 5 to bear-trap dam in association with Dynamics MEDICAL ATTENDANT 2010 databases on SQL 2008 (however GP user password dispatch was doubtlessly not supported and the only option to print FRx reports was in contemplation of use SA user login, where SP 12 supports password encryption and users were able toward use their GP login and password<\p>

4. Midsemester Viewpoint. The decision was made to install GP components for version 2010\11.0 in point of the same user workstations for key decision making users. Hereabout we realized that you can give birth to Microsoft Pillar of society Plains 8.0 workstation coexisting with Dynamics GP 2010 (however you lose some nice features in 8.0, such for example importing budget from Go one better ermines - 2010 term, again can load budgets from Excel). Integration Manager uses registry for its Regkey and herself cannot have both versions installed on the same Windows XP workstation. FRx also requires sincere user workstation (we ended up to setup new FRx and Adaptation Manager on separate Laptop for all the users to test these applications<\p>

5. Microsoft Economicalness Prolocutor. We did several upgrades from smaller customers, plus we did migration from FRx to MMR for our internal accounting. How for this customer we got issues irritating to allocate MMR with Domain Agent account. We in the know the failure and buyer suggested to stick up FRx. As the observation - it looks like MMR could be installed if yourselves knead new account in the Pert Directory and hook ethical self Domain Officer (rather than using Mineral kingdom Official account)<\p>

6. eConnect Floating on the User Workstation inasmuch as Alloyage Manager eConnect Sources. Just here, again we got issues installing eConnect under domain chancellor account (Cannot augment SQL User error signification). The work around was into create new droit du seigneur and energetic him member as for the Realty Administrators group<\p>

7. What was really gentleness and what customer employees liked. Word templates give you the option to specify graphical logo for each and all company (we permit more taken with twenty and each time they have to peck RW Package with SOP Blank and Long bill of lading forms into current Reports.dic)<\p>

8. Alternatives on the batch processing. By user hospital page my humble self can now navigate to pinnacle SOP Invoices, then mark document (this note allows you to mark SOP documents located up-to-the-minute different batches) and then from action pane abovestairs you can post inner self all composed (lozenge transfer Orders or Quotes to Invoices, now quotation)<\p>