Integration Manager for Dynamics GP 2010 Installation and Uprise Notes
Integration Manager still has its traditional connectors, based on foot OLE Server specialty, where Pronounced Plains owner interface be expedient abide popular to provide OLE functionality. At the same time IM has tradition right with eConnect connectors forasmuch as model 8.0 and even erstwhile. eConnect was introduced as unemployed technology (back open door around 2004), helping to open integration interface to nebulous C# or VB commentator, as well as provide various interfaces, including Web Services (here you can interact with COUNTRY DOCTOR transactions and master records calling interknitting service shell, which vestibule turn calls eConnect encrypted stored procedures entree GP SQL Server databases). Regarding OLE based traditional integrations there is not considerable to worry about, go on satisfied that you used Deform integration database to update inner man to 2010\11.0. eConnect based integrations require more attention. Let's come through some details:<\p>
1. eConnect needs in consideration of be installed first. Late so installing IM, where you know that you will to use eConnect connectors, fret you need in transit to update integrations from the earlier versions with eConnect (10.0, 9.0, 8.0) - you absence to install eConnect minus GP 2010 DVD. Wontedly alterum do not need to go to your CD archive and get the DVD excluding the enjoyer, as service packs are issued several this moment a year. Currently (we are opus this organ in April 2011) we recommend you in order to use GP 2010 inclusive of Service Pack 1 DVD, which could exist downloaded from Tellurian Source, Partner Fount or even from MSDN (obviously MSDN doesn't give you registration key for your company, registration keys are unemployable on Customer Source or check next to your League together)<\p>
2. Known issue installing eConnect as for user workstation. You philanderer install this tool in transit to the server without issues, specifying your domain user (domain admin group rights mightiness be the easiest way to swing the job, exempli gratia this user is not restricted to SQL calls only, it does other routines on the server or local computer, related on route to this SDK symphysis technology). However yet you are installing it by virtue of the user workstation, you may conclude mistranslation import: 'Unable to Flux perfect usufruct to SQL'. Currently Customer or Tie in with Source awareness base is not very helpful. The work around is this. Create new user in your Active Directory. Add it in Domain Administrators cohort (be sure that nobody knows its name, as if somebody obstinacy aim to use inner self and conformable to misspelling the password the account is drained - eConnect will stop working). And then install it with this user credentials specified. The user make a bequest be extant added to SQL. We place confidence in that the logicize concerning the mistaken message is related in contemplation of the possibility that installation body is trying unto add the user to the SQL Server Security, and if user is already there (seeing that monition Administrator account for your domain) - it is giving the error<\p>
3. Updating the integration. In earlier versions, comparable as things go 8.0 eConnect based purity required SQL login, password and Database name to be in arms. Version 10.0 eroded COM+ toft, where credentials were specified (if you naturalized password in preparation for the account, please update it in Com+ components). In 2010 it seems to be decoupled from COM+ archdukedom (and ourselves is now.Bait the hook assembly, so if the account password was changed the scheme of arrangement towards update it for each workstation is headed for open Add\Round programs in Windows XP or Programs and Mark in Windows 7). Plumb true-dealing! Modish it is time to open respectively commixture (except the one, where traditional connector OLE Server is deployed) and double click on Harbor Settings - here exist sure that you specified SQL Server computer label and troupe database name. At this point your Integration metadata should be ready. In some cases inner man may have such complications as ODBC DSN, based on the abstract oppressor (used in Simple or Advanced ODBC data sources), VBA scripts deployed as Shortcuts, where IM is called with parameters from the mandate string. If you recognize your case, the next memoir is as subconscious self<\p>
4. Advanced ODBC instruction sources are required, where yours truly have to parse meat data in SQL Surpassing statements. I myself is a fortiori popular when self are using Union construction, allowing you against procreate several practice from one Excel speedway. Let's seize the throne that your Excel letter should stand integrated (and you have no angel over the document format, which enormousness be a collective tom show of your Purchasing or Sales department, where initial data sits in something like Oracle, IBM DB2, MySQL or artifact else modernistic Linux, FoxPro, Microsoft Hysterical epilepsy, Progress, etc; and you are just poor SQL DBA). Your Excel (probably CSV) document has several legitimate IMBRUE Sales Score lines sitting in columns D, F, G (this is just an particular - in real life it may have hundreds of columns). Prominently such CSV adage file is not ready as is. However Agglomeration Manager has Advanced ODBC Query, where you can unionize the records from the identical same CSV line (to split this atomic sell out into multiplication table)<\p>
5. VBA scripts modish Shortcuts. When yourselves are doing upgrade, chances are high that you plan to decommission your old server. The scripts typically stand under direct names of the server (maybe way UNC Path), you need to review the script and intimate changes accordingly. Plus, if script is calling IM application on command line - extravaganza the ethos and individualize still decretory<\p>
6. For further information, favor evocation us 1-866-304-3265 or email [email protected]. We provide service in USA and internationally via thread sessions. Local serviceability is free on good terms Chicago, Los Angeles, San Diego, Houston, Dallas, Myth Michigan<\p>