Software informational articles

Microsoft great plains data conversion ? overview for developer - software


Looks like Microsoft Great Plains becomes more and more popular, in part for the reason that of Microsoft muscles at the back of it. Now it is beleaguered to the whole spectrum of horizontal and vertical bazaar clientele. Small companies use Small Affair Boss (which is based on the same expertise - Great Plains Adroitness glossary and runtime), Great Plains Accepted on MSDE is for small to midsize clients, and then Great Plains serves the rest of the marketplace up to big corporations.

If you are developer who is asked: how do we alter our old approach data for first Great Plains setup - read this and you will have the clues on where to look further.

Great Plains Integration Boss - this is instead end-user tool - it is very intuitive, it validates 100% of big business logic, brings in/updates master account (accounts, employees, customers, vendors. etc. ) brings in transactions into work tables. The limitation of Integration Director - it does use GP windows at the back of the scenes lacking viewing them - so it is more or less slow - you can bring 100 proceedings for ongoing integration - for one-time conversion/integration you are almost certainly OK with IM. By the way you can curriculum Integration Boss with VBA.

eConnect - it is type of Software Advancement Kit with samples in VB. Net. Noticeably the advancement ecosystem 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 chronological proceedings - you need to post work report in Great Plains, the same limitation applies to Integration Director above). eConnect is moderately for ongoing integration. It was at the outset fashioned for eCommerce claim integration to Great Plains.

SQL Stored Procedures. Noticeably you have ad lib be in charge of and potential with SQL queries. You need to know Great Plains tables arrangement and data flow. Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the apt series. If you are looking for the customers - it must be RM00101 - consumer master file. If you need chronological Sales Order Dispensation papers - they are in SOP30200 - Sales Annals Description file, etc. Do not alter obtainable tables - do not coin new fields, etc. Also you need to accomplish that each GP table has DEX_ROW_ID - characteristics column. For ongoing integrations - from time to time it is good idea to use inbound/outbound XML in the parameters - then you can arrange web assistance as a center party connecting two systems.

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

Great Plains Ability Conversion Utilities. If your bequest data sits in old Adroitness customization on Ctree/Pervasice. SQL/Btrieve - you can build custom Ability conversion utility, which will read the table in Ctree/Btrieve and will move it to SQL based new custom Adroitness table. In this scenario - you need Ability customization upgrade as well. (Great Plains Adroitness - is encoding expression and expertise of previous Great Plains Software - Microsoft Great Plains is in black and white in Dexterity)

MS Admission - if you are doing one time conversion and your bequest has old ODBC biddable platform - you can use MS Admission to conceive associated tables there - or import into MS Access.

SQL Associated Servers - you can do absolute SQL queries to other ODBC acquiescent platform via SQL Connected Ma?tre d' (including ORACLE, UNIDATA, Invasive SQL, Ctree, etc) - you may need to disseminate by hand with OPENROWSET appreciation in Conduct SQL. This is also good decision if you need cross-platform Gemstone Arrive - pulling data from SQL Ma?tre d' and third party databases on the same report.

MS Excel - yes - a moment or two you can use it for inheritance data manipulation already feeding it into Great Plains.

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

Happy converting! if you want us to do the job - give us a call!

About The Author

Andrew Karasev is Chief Knowledge Executive in Alba Spectrum Technologies - USA countrywide Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Minnesota, Texas, Florida, New York, Washington, Georgia, Canada, UK, Australia and having locations in manifold states and worldwide (www. albaspectrum. com), he is CMA, Great Plains Licensed Master, Dexterity, SQL, C#. Net, Precious stone Information and Microsoft CRM SDK developer. You can call Andrew: andrewk@albaspectrum. com

akarasev@albaspectrum. com


Developed by:
home | site map © 2018