| Microsoft Dynamics GP Integration Manager is often | | | | eConnect new integrations. The signal was received |
| perceived as end user integrating tool only, however if | | | | from Microsoft Business Solutions at the end of 2006, |
| you research and try out Advanced ODBC integration, | | | | however up to now, fall of 2008, IM is still in process of |
| which is capable to cross DB platforms and work with | | | | being rewritten in eConnect, but the trend is clear and |
| heterogeneous SQL query to bring data into Dynamics | | | | we expect couple of more years, until we will see |
| GP Great Plains, then new horizons should open up for | | | | Integration Manager to be finalized in eConnect |
| you, Great Plains Programmer and Add-On software | | | | technology |
| developer. Please note, that GP IM for GP version | | | | |
| 10.0 and newer is built and will be built upon eConnect | | | | 3. Advanced ODBC source query |
| platform, meaning breaking through Integration Manager | | | | flexibility and performance. IM has simple text data |
| performance issues and enabling large scale | | | | source, simple ODBC and Advanced ODBC source, |
| integrations with GP in real time. Let’s try to | | | | where only advanced allows you to deploy advanced |
| organize this small publication in FAQ manner with | | | | SQL queries and constructions, such as Unions, Group |
| bullets: | | | | by, Having and Case clauses. Advanced ODBC |
| | | | | integration may look back and pool data from your |
| 1. What is eConnect. The technology | | | | legacy DB source, where you can pull data using |
| lowest level of this GP SDK is encrypted SQL stored | | | | legacy DB ODBC driver or cross platform query from |
| procedures, which could be called from the stack of | | | | linked SQL server |
| under laying technologies. If you are C# or VB .Net | | | | |
| programmer, then, assuming that you are using MS | | | | 4. Overnight eCommerce integration. |
| Visual Studio – eConnect is open for you in C# .Net | | | | Deploying GP IM, you could schedule overnight |
| projects via eConnect libraries | | | | ecommerce sales orders integration to GP, assuming |
| | | | | that IM looks at ecommerce SQL compliant database |
| 2. Integration Manager in the | | | | and pulls data from there. |
| transformation stage. From OLE old integrations to | | | | |