Software informational articles

Microsoft great plains integration with bequest systems ? overview for developer - software


Looks like Microsoft Great Plains becomes more and more popular, moderately for the reason that of Microsoft muscles at the back it. Now it is besieged to the whole spectrum of horizontal and vertical marketplace clientele. Small companies use Small Affair Executive (which is based on the same knowledge - Great Plains Agility glossary and runtime), Great Plains Banner on MSDE is for small to midsize clients, and then Great Plains serves the rest of the advertise up to big corporations.

If you are developer who is asked: how do we apply Great Plains integration/interface with your heritage or other coordination - read this and you will have the clues on where to look further.

1. Great Plains Integration Boss - this is moderately end-user tool - it is very intuitive, it validates 100% of affair logic, brings in/updates master report (accounts, employees, customers, vendors. etc. ) brings in transactions into work tables. The limitation of Integration Boss - it does use GP windows after the scenes not including performance them - so it is moderately slow - you can bring 100 proceedings - but when you are chatting about thousands - it is not a good option. By the way you can curriculum Integration Director with VBA.

2. eConnect - it is type of Software Education Kit with samples in VB. Net. Clearly the advancement background ought to be Visual Studio. Net. eConnect will allow you to integrate master report - such as new customers, vendors, employees, etc. , plus you can bring transactions into so called Great Plains work tables (eConnect doesn't allow you to bring open or past account - you need to post work proceedings in Great Plains, the same limitation applies to Integration Boss above) eConnect is instead for ongoing integration. It was firstly bent for eCommerce appliance integration to Great Plains.

3. SQL Stored Procedures. Evidently you have bottomless charge and potential with SQL queries. You need to know Great Plains tables arrange and data flow. Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the appropriate series. If you are looking for the customers - it must be RM00101 - patron master file. If you need past Sales Order Dealing out credentials - they are in SOP30200 - Sales Annals Footer file, etc. Do not alter offered tables - do not construct new fields, etc. Also you need to appreciate that each GP table has DEX_ROW_ID - distinctiveness column. At times it is good idea to use inbound/outbound XML in the parameters - then you can organize web advantage as a center party connecting two systems.

4. Data Transformation Air force (DTS) - Good tool for importing your third party data into production tables in GP - then you can pull them in using any stored procs of Integration Manager. You can also arrange this tool for EDI export/import.

5. Great Plains Adroitness Custom Screens. Every now and then users choose to have seamlessly integrated into GP boundary custom screens - for parameters settings and initiating integration. Ability is a good option, conversely commit to memory - it is continually change for the better to build new custom check out versus customizing offered one - due to the hope upgrade issues. Also - Ability is in phasing our by Microsoft Commerce Solutions.

6. Modifier/VBA custom buttons on the obtainable screens - another to Adroitness is you are comfortable with VBA and ADO.

7. MS Admittance - if you are doing one time conversion and your bequest has old ODBC biddable platform - you can use MS Admittance to coin connected tables there - or import into MS Access.

8. SQL Connected Servers - you can do aim SQL queries to other ODBC acquiescent platform via SQL Allied Ma?tre d'h?tel (including ORACLE, UNIDATA, Insidious SQL, Ctree, etc) - you may need to disseminate manually with OPENROWSET appreciation in Conduct SQL. This is also good decision if you need cross-platform Rock Article - pulling data from SQL Ma?tre d'h?tel and third party databases on the same report.

9. Warning - do not place obtainable GP tables into Replication! - you will have upgrade issues.

Happy integrating! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum. com

Andrew Karasev is Chief Knowledge Executive in Alba Spectrum Technologies - USA all over the country Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, San Diego, Los Angeles, Houston, Atlanta, New York, and Miami and having locations in many states and worldwide (www. albaspectrum. com), he is Dexterity, SQL, VB/C#. Net, Gemstone Intelligence and Microsoft CRM SDK developer.

Developed by:
home | site map © 2018