| > | | | | 3. Some disadvantages of native integration tools |
| If you deploy one of the mid-market Retail applications | | | | described in paragraphs one and two. Both |
| and Microsoft Dynamics GP as your Corporate ERP | | | | integrations should be initiated by user and could not be |
| system - we would like to review integration between | | | | scheduled (without complex programming) to run |
| the two. All three are hosted in Microsoft SQL | | | | automatically. Second issue - both are for importing |
| Server. Earlier versions of Great Plains Dynamics | | | | into specific Great Plains company and you have to |
| were also available on Pervasive SQL 2000 or Ctree, | | | | log off current company and login new company to |
| but these versions are really legacy now and we will | | | | send transactions there |
| concentrate on MS SQL Server based versions. If | | | | 4. Alba Spectrum Microsoft RMS to Dynamics GP |
| you have old version of Great Plains, you still can | | | | integration. Here you have automatic scheduled |
| deploy text file import via Integration Manager, and text | | | | integration, many to many (RMS Stored to Dynamics |
| file could be produced from Counterpoint or Microsoft | | | | GP companies), integration in Sales Order Processing |
| Dynamics RMS via SQL Query: | | | | transaction level (or Accounts Receivable docs, where |
| 1. Counterpoint export to Dynamics GP. Here you | | | | you can track integration on GL precise distribution |
| have predefined MS SQL Server DTS packages, | | | | level). This integration is "Solution", meaning that Alba |
| exporting GL (usually daily sales)and Accounts | | | | Spectrum technical consultants have to install and tune |
| Payable (inventory replenishment) transactions. DTS | | | | it for you |
| is now considered as legacy application in Microsoft | | | | 5. Advanced Counterpoint Integration to Great Plains. |
| SQL Server 2005 or 2008 and you can either upgrade | | | | We recommend you to consider the option to pull |
| your DTS packages or use Microsoft SQL Server | | | | Counterpoint documents directly in Dynamics GP |
| 2000 Enterprise Manager to work with DTS files | | | | Integration Manager via Advanced ODBC queries |
| settings (typically when you have to modify predefined | | | | 6. Bonus topic. Counterpoint or Microsoft RMS |
| DTS package and include user defined fields into your | | | | integration with SAP Business One. Here you have |
| text file export). When you got text files, the next | | | | two options. First one is to deploy SAP B1 Data |
| step is importing them into GP via Integration Manager | | | | Transfer Workbench (where in Advanced ODBC |
| (this is why we mentioned above that Legacy GP | | | | query from DTW side you imitate SB1 DTW CSV |
| version is not a big problem, as IM was available since | | | | templates). Second option - you pull records from |
| really historical times) | | | | SQL Counterpoint or GP databases via SAP Business |
| 2. Microsoft RMS export to Great Plains. Here you | | | | One SDK. This integration is probably not for small |
| also have Dexterity add-on, which moves your GL and | | | | companies, as programming budget should be close to |
| AP transactions | | | | hundred hours. |