Microsoft Great Plains Integration with Legacy Systems - Overview For Developer

It seems that Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now is targeted to the whole spectrum of horizontal and vertical market customers. Small companies use Small Business Manager (which is based on the same technology - the Great Plains and skill dictionary runtime) Great Plains is the standard to msde for small to midsize clients, and then Great Plains serves the rest of the market to large companies. You

if developer is asking: How implement Great Plains integration / interface with your heritage or other system - read this and you will have the clues, we are considering to further.

1. Great Plains Integration Manager - This is rather a tool user - it is very obvious that the true 100% of the trade logic, comes in / updates Master records (accounts, employees, customers and vendors. Etc.) comes in transactions to the work tables. Reduction of integration manager - does use GP windows behind the scenes without showing them - even relatively slow - you can make records 100 - but when you are talking about thousands - not a good choice. By the way you can with the integration program manager vba.

2. Econnect - it is the kind of development programmes in several vb.net with samples. It is clear that the development environment should be visual studio.net. Econnect will allow you to integrate Master records - such as new customers, vendors, employees, etc., plus you can bring transactions to the so-called Great Plains work tables (econnect not allow you to achieve open or historical records - after you work in the records Great Plains, the same limitation applies to Integration Manager above) econnect rather for ongoing integration. Was originally created for the application of e-commerce integration for plains.

3 great. Language queries structural stored procedures. It is clear that you have control of the unlimited possibilities with the language queries structural queries. You need to know Great Plains tables structure and data flow. Launch of the Great Plains and go to Tools - > Resource Description - > tables. Found on the table in the proper series. If you are looking for customers - worth rm00101 - Mr. customer file. If you need historical sales for the processing of documents - they are in sop30200 - sales history file of the head, etc. do not change existing tables - not create new fields, etc. Also you need to realize that each GP table has dex row id - Identity column. It is sometimes a good idea to use the inside / outside in the language of coding are milestones along - then you can publish web service as a compromise between the two party systems.

4. Data transmission services (dts) - a good tool for importing your data to a third party starting in the tables GP - then you can withdraw from using either stored in procs of Integration Manager. You can also disseminate this tool for EDI export/import.

5. Great Plains skill usually screens. Sometimes users prefer to be quite easily integrate GP interface custom screens - for parameters settings and the start of integration. Skill is a good option, but remember - It is always better to create new custom screen and one in exchange for the list - because to raise issues of the future. Also - the skill is in the stages of our business solutions.

6 by Microsoft. Rate / VBA custom buttons on the existing screens - alternative skill is comfortable and VBA ado.

7. Ms. access - if you do once and transfer your old legacy has been compliant with the ODBC Platform - you can use this version to create access linking tables there - or imported into Ms. access.

8. Language queries structural link servers - you can do directly to the language queries structural queries other ODBC-compliant Platform across language queries structural link server (including Oracle, unidata, pervasive language queries structural, ctree, etc.) - may require your openrowset Command dealings in the language queries trend. This is also a good choice if you need Platform across crystal report - withdraw data from the language queries structural third party server databases on the same report.

9. Warning - no place existing GP tables to repeat! -- Will you upgrade issues.

happy integration! If you want us to do work - give us a call 1-866-528-0577! Help@albaspectrum.com

andrew karasev technology is the head officer in Alba Spectrum Technologies - the United States of America at the national level Microsoft CRM, Microsoft Great Plains conditioning company based in Chicago, Boston, San Francisco, San Diego, Los Angeles, Houston, Atlanta and New York, and Miami, and after several locations in the state and at the international level (www.albaspectrum.com), a skill, intelligence structural language, VB / C . Net, Crystal Reports and CRM Microsoft SDK developer. Internet & Businesses.com



Bookmark it: