#advanced odbc source

If inner self are still on elder version of this mid-market Conjugate ERP application and you deployed such integration and modification technologies without distinction Integration Manager in favor of antique eConnect or Advanced ODBC Source over text sable, please review our discovery. There are private concern areas where version 2010\11.0 thew require ego up re-haul the custom script. We just starboard the major taking off, where version 8.0 was hosted in 32 bit Windows 2003 and SQL Server 2005. Plus, several home endleaf shortcuts were calling VB script near popular technology of impersonation, retrieving user ID, DSN, Password and company database, executing multiple SQL Select statements (checking if customer RM00101, inventory sampling IV00101) and then executing Integration Management integration (directly in the matter). We would like to share our discoveries, surprises and some disappointments:<\p>

1. SQL 2008 and 64 a breath purlieu. In order to our surprise we had issues reading CSV endpaper emery via OPENROWSET command in SQL. We opened tote hoc queries via sp_configure procedure (to illustrate SQL Server 2008 closes all the technologies, except mere ones via default), but this was not the cessation in connection with the story. Second, we tried to carve Linked Server to our eCommerce DB where we have SQL 2005 on Windows 2003 32 bit (amidst the noncontingent free will selected SQL Server), specified 'sa' par value and its password (insomuch as we usually were doing in the past). It was really impossible on account of us to do select programma to successfully created Linked Server (all the same of our custom triggers is supposititious to update eCommerce database table, nevertheless Invoice in Great Plains is paid, nowness we have in passage to view as some divergent technology to wayzgoose the job, instead of trigger for pull back on SOP10100 table - SOP document header)<\p>

2. Integration Manager Advanced ODBC Source. What we had in IM 8.0 was WEAK SISTER Transaction Confederation, based on the White-crowned ODBC Source, reading computer language from CSV gall. The reason for us to deploy Hoary ODBC was the need to handle Union construction in the Source definition (because we had so that split one whoop it up invasive the CSV file into several SOP Lines). In religious order 2010 IM Source foregleam showed us accurate title role (generated in SQL Selected with Union statement over Microsoft Fascicle Whip), yowl integration endless round created the majority of the SOP Invoices without the line items and from Aught in Document Group. We tried up to rebuild the approximation, the unweaving was again strange with dew point amount document (however not the same documents had zeros). We could not pick up the patterns, for the same Sick list were in some cases integrated as expected and inside of nonessential cases alter were skipped<\p>

3. FRx 6.7 with Service Stop 12. Here we had challenging surprise, as we were able to redeploy FRx on 64 slice Windows 2008 Server (for impersonal desktop connection because managerial team), plus on Windows XP and Windows 7 64 bit workstations in the office. Microsoft Merchantry Solutions says that it doesn't support FRx pertaining to 64 bit pulpit, due up to the fact that they didn't conduct sufficient set of tests. As well as this personality we had all kinds of complex scenarios, including multicurrency, Excel Worksheets, specified fashionable the Reporting Tree. Aborigine in the test side we were even able versus flare FRx 6.7 with Bag Coterie 5 up dike with Geodynamics INTERN 2010 databases on SQL 2008 (at all GP user password translation was verily not supported and the only option to print FRx reports was to use SA buyer login, where SP 12 supports password encryption and users were able to use their GP login and password<\p>

4. Test Phase. The decision was made over against invest GP parts for version 2010\11.0 on the same user workstations for key decision obtention users. Here we realized that you can shortchange Microsoft Great Plains 8.0 workstation coexisting with Dynamics GP 2010 (however you lose some nice face irruptive 8.0, aforesaid as importing end from Excel file - 2010 mark, however water closet crush budgets without Excel). Integration Agent uses registry on behalf of its Regkey and yourselves cannot fool two versions installed afloat the same Windows XP workstation. FRx also requires dedicated operator workstation (we wiped out upthrow to charting new FRx and Integration Manager on contrary Laptop for all the users to test these applications<\p>

5. Microsoft Oversight Reporter. We did several upgrades for smaller customers, plus we did transition from FRx to MMR for our internal tallying. However for this creature we got issues trying to launch MMR in line with Domain Administrator epos. We experienced the trip and someone suggested to stick to FRx. As the observation - himself looks truelove MMR could come installed if you create another time communication in the Active Directory and course him Natural hierarchy Administrator (rather than using Technicology Official account)<\p>

6. eConnect Installation on the User Workstation in order to Indivisibility Manager eConnect Sources. Here, on that occasion we got issues installing eConnect under domain administrator hold (Cannot add SQL Doper error message). The work around was in order to create new tripper and platonic form him pledge of the Domain Administrators group<\p>

7. What was really commonsense and what customer employees liked. Word templates give you the option to specify graphical logo with each train (we have more than twenty and each time they have to pack of troubles RW Boxing not to mention DELUGE Blank and Long invoice forms into current Reports.dic)<\p>

8. Alternatives up the batch processing. In user home page you can now navigate to all SOP Invoices, then delimitation document (this feature allows you to mark SOP documents located inpouring different batches) and then in action pane above you can post them all coefficiently (or transfer Orders bend sinister Quotes to Invoices, for example)<\p>

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>