Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations.
If you are developer who is asked: how do we implement Great Plains integration/interface with your legacy or other system ? read this and you will have the clues on where to look further.
1. Great Plains Integration Manager - this is rather end-user tool - it is very intuitive, it validates 100% of business logic, brings in/updates master records (accounts, employees, customers, vendors. etc.) brings in transactions into work tables. The limitation of Integration Manager - it does use GP windows behind the scenes without showing them - so it is relatively slow - you can bring 100 records - but when you are talking about thousands - it is not a good option. By the way you can program Integration Manager with VBA.
2. eConnect ? it is type of Software Development Kit with samples in VB.Net. Obviously 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 into so called Great Plains work tables (eConnect doesn't allow you to bring open or historical records - you need to post work records in Great Plains, the same limitation applies to Integration Manager above) eConnect is rather for ongoing integration. It was initially created for eCommerce application integration to Great Plains.
3. SQL Stored Procedures. Obviously you have unlimited control and possibilities with SQL queries. You need to know Great Plains tables structure and data flow. Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the proper series. If you are looking for the customers ? it should be RM00101 ? customer master file. If you need historical Sales Order Processing documents ? they are in SOP30200 ? Sales History Header file, etc. Do not change existing tables - do not create new fields, etc. Also you need to realize that each GP table has DEX_ROW_ID - identity column. Sometimes it is good idea to use inbound/outbound XML in the parameters - then you can deploy web service as a middle party between two systems.
4. Data Transformation Services (DTS) ? Good tool for importing your third party data into staging tables in GP - then you can pull them in using either stored procs of Integration Manager. You can also deploy this tool for EDI export/import.
5. Great Plains Dexterity Custom Screens. Sometimes users prefer to have seamlessly integrated into GP interface custom screens - for parameters settings and initiating integration. Dexterity is a good option, however remember - it is always better to create new custom screen versus customizing existing one - due to the future upgrade issues. Also - Dexterity is in phasing our by Microsoft Business Solutions.
6. Modifier/VBA custom buttons on the existing screens - alternative to Dexterity is you are comfortable with VBA and ADO.
7. MS Access ? if you are doing one time conversion and your legacy has old ODBC compliant platform - you can use MS Access to create linked tables there - or import into MS Access.
8. SQL Linked Servers ? you can do direct SQL queries to other ODBC compliant platform via SQL Linked Server (including ORACLE, UNIDATA, Pervasive SQL, Ctree, etc) - you may need to familiarize yourself with OPENROWSET command in Transact SQL. This is also good option if you need cross-platform Crystal Report - pulling data from SQL Server and third party databases on the same report.
9. Warning - do not place existing 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 Technology Officer in Alba Spectrum Technologies ? USA nationwide 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 multiple states and internationally (help@albaspectrum.com ), he is Dexterity, SQL, VB/C#.Net, Crystal Reports and Microsoft CRM SDK developer.
Chicago limo Skokie ..Do you remember that frustrating feeling when you find an... Read More
Are you lost in the mess of documents that get... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
We live in a post-industrial age where information is the... Read More
In the real world a "fire wall" is a fireproof... Read More
NOTE: Please take time to read on - it may... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
With any good luck and a good amount of hard... Read More
Each Industry and market niche has business specific and unique... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
People often ask me: What image file formats will Photoshop... Read More
In this article you will find some background information about... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
We were recently faced with a decision: either to let... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
If you look back to the history, you will see... Read More
Find out why Spyware Removal from computers is important and... Read More
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
We all take the computer for granted. I mean, all... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
We are in a transition phase in the Managerial Administration... Read More
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
The first thing that you will notice about Linux Red... Read More
limo O'Hare Bonfield ..Microsoft Business Solutions Great Plains is very generic accounting application... Read More
Let's first look at your ERP system selection (without Retail... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
The intentions of this short tutorial are not to teach... Read More
When you think... Read More
1. With mapping software you can create a report that... Read More
Looking at all the ads which promise to get rid... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
You probably didn't casually invite, or extend a formal attendance... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
Just imagine: you are walking, say, towards your car, and... Read More
We all take the computer for granted. I mean, all... Read More
The vast majority of us will have, at some point,... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
While Adobe is the most known maker of PDF tools,... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
.Net Framework is a platform or development environment to seamlessly... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
In a previous article, I wrote about OpenOffice... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
Software |