In this short FAQ style article we would like to introduce you - software developer, programmer, database administrator into Microsoft Great Plains Integration tools and options
Microsoft Great Plains is main Microsoft Business Solutions product for US mid-market. Historically Great Plains Software designed Great Plains Dynamics and Dynamics C/S+ as multiplatform application and the integration was possible via Great Plains Dexterity or Dexterity-based end user tools, such as Import Utility and later on via Integration Manager. When Microsoft Windows platform won the OS market (the last battle was in 1997 with PowerMac) Great Plains recommended OLE Server approach: Continuum for VB and Delphi and new Microsoft light programming technology - VBA (Visual Basic for Applications), which was integrated into Dexterity application - Great Plains Modifier (requires customization site enabler license). Since then Great Plains Dynamics/eEnterprise integration techniques use Microsoft technologies.
1. Microsoft SQL Server approach. This integration technique uses SQL stored procedures and views to pull data from your legacy or third party application and push it into Great Plains. The nice thing about MS SQL Server - it has linked server technology - you can establish the link to virtually all ODBC ir OLEDB compliant databases: Oracle, DB2/Unidata, Sybase, Ingress, Lotus/Domino, Pervasive SQL/Btrieve, Ctree/Faircom, Microsoft Access, Foxpro to name a few. You can schedule your integration as maintenance job or DTS package. However keep in mind that Great Plains tables structure is rather complex (it has master records, summaries, historical, work, open tables) and you should probably verify your stored procedures business logic with Great Plains source code (DYNAMICS.DIC with Dexterity procedures and functions scripts - in regular DYNAMICS.DIC these are stripped out - not every MBS partner has source code subscription - so do your selection work)
2. Great Plains Dexterity integration with Great Plains process server. This is more advanced and recommended approach, however it requires advanced Dexterity programming skills and access to the source code. The idea behind is simple - you populate so-called triggering custom table and then check it from Dexterity custom application every 5 seconds or so. If the record is there - then you process it. Processing is usually Dexterity source code stored procedure call. Great Plains uses similar logic when you post the batch and see the status in Process Monitor window. If you don't have source code - you can try to do the best guess with Microsoft Great Plains Software Development Kit (SDK)
3. Great Plains Integration Manager. This is end user tool and is easy to use. However - it uses Great Plains as OLE Server and calls Great Plains forms behind the scenes. As the result - it is very slow - we recommend using integration manager when you have up to one thousand transactions per day.
4. 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.
Happy integrating! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com
About The Author
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Los Angeles, San Diego, San Francisco, Denver, Houston, Dallas, New York, Boston, Atlanta, Miami, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer; akarasev@albaspectrum.com
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
In the previous ISDN article, we looked at how and... Read More
IBM Lotus Notes with Domino email server is traditional document... Read More
If you are in a business that passes documents around... Read More
I like my software simple. If it's too complex or... Read More
Customer Relationship Management, abbreviated "CRM," is the term for a... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
With any good luck and a good amount of hard... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
When you think... Read More
Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
Some companies that are in need of fleet management may... Read More
First we had the original Google search that evolved into... Read More
.Net Framework is a platform or development environment to seamlessly... Read More
We all take the computer for granted. I mean, all... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
DBxtra is a powerful query and reporting tool that hides... Read More
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
We would like to give you pluses and minuses of... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
The US House of Representatives has recently passed the "Spy... Read More
Microsoft Business Solutions Great Plains is very generic accounting application... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
Now there are Three Steps To Heaven Just listen and... Read More
So, why should you use any O/R mapping tool? I... Read More
The title of "software engineer" has got to be among... Read More
In part III of this ISDN primer, we learned that... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
Microsoft CRM is new player on the CRM software... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
During the years of our consulting practice, which comes back... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
Microsoft Great Plains is becoming more and more popular and... Read More
When you visit department stores and see that majority of... Read More
Disclaimer: All the thoughts expressed are my views only! Your... Read More
Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
A UNIX Shell is in simplest terms, a command line... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
It is a well known fact that Java as a... Read More
Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
Sometimes your PC will start acting strange for no apparent... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
Considering whether or not your software company should hire a... Read More
When reading an article where some term is used often,... Read More
The stakes are high when considering security, privacy, and savings,... Read More
We are in a transition phase in the Managerial Administration... Read More
The software giants don't do everything and don't always produce... Read More
Since its release in 1987, QuarkXpress had made an immediate... Read More
IntroductionDuring the early years of our modern computer era, very... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
1. With mapping software you can create a report that... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More
It is now common thing when large corporation selects mid-market... Read More
Your computer cost you from hundreds to thousands of dollars,... Read More
This article illustrates the best practices to improve the performance... Read More
RSS (Really Simple Syndication) is a way for a site... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Great Plains, designed back in 1990th as database transferable... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
The US House of Representatives has recently passed the "Spy... Read More
Software |