Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com - help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canada nationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah, Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale.
As more midsize and small business organizations are deploying open platform operating systems and tools, such as Linux with various blends and PHP/MySQL, we would like to share our experience implementing Microsoft Great Plains in these combined OS environments. If you are using Oracle and Unix, you may also consider the methodology, however it deserves separate article just for brief overview, especially about Java, EJB nuances.
1. MS Great Plains platform overview. GP workstation is written in C Shell, named Great Plains Dexterity. It was designed in earlier 1990th, when DB and OS platform independence was the paradigm. However, when Microsoft acquired Great Plains Software seven years ago, Microsoft Dexterity was kind of de-emphasized and GP itself was open for .Net platform and for Microsoft Visual Studio C# and VB developers, especially via eConnect. Plus, GP is available on Microsoft SQL Server DB platform only. Saying these, Microsoft Great Plains version 10.0 and 9.0 should be considered as committed to Microsoft technologies: SQL Server, .Net, Windows, MS Office: Sharepoint, Excel, etc.
2. Cross Platform SQL Queries. If you do it from Microsoft SQL Server 2005 or 2000 side, the construction you typically use is Linked Server, where you should first try ODBC connection to Linux World. If you are on Oracle, then similar construction will allow you to hook up MS SQL Server
3. Web Services. eConnect allows you to open GP objects for non-Microsoft developer via XML web services – you can either use eConnect interface directly or wrap it in custom web service interface
4. eConnect excurse. The core of eConnect is set of MS SQL Server encrypted stored procedures, allowing you manipulate GP master records and work transactions: SOP Entry, POP Receivings, Customers, Vendors to name a few. eConnect has restrictions of GP architecture, one of the typical FAQ is why we can not post GP batches in eConnect? Well, this is the restriction, but you can break it utilizing Albaspectrum posting server. eConnect was dedicated initially to eCommerce software developers, to enable GP ERP platform as backoffice accounting for e-commerce front end
5. Integration technology. Here again eConnect comes to the scenes. GP Integration Manager, which is rather traditional Great Plains integration tool, was recently redesigned partially in eConnect and so IM performance was substantially increased. IM can read tab and comma delimited text files as well as ODBC compliant queries. When you are programming integration, be sure that you select eConnect destination connector as preferred, versus deploying regular destination connector (old-fashioned connectors use GP workstation as OLE Server to validate Great Plains business logic directly in GP screens, which obviously slows down the performance)
- Related Videos
- Related Articles
- Ask / Related Q&A
- Microsoft Dynamics Gp Great Plains Consultants With Industry Expertise
- Microsoft Dynamics Gp Great Plains East European Options Overview for Consultant
- Microsoft Dynamics Gp Great Plains Integration and Upgrade in Chicago
- Crystal Reports for Microsoft Dynamics Gp Great Plains – Overview & Faq
- Microsoft Dynamics Gp Great Plains Series and Modules Faq
- Microsoft Dynamics Gp Great Plains Custom Logic Programming
- Microsoft Dynamics Gp Great Plains Ecommerce Considerations
- Dynamics GP Great Plains in Russia, please consider instead SAP Business One
How to choose the right contact management software
By: gardnerwilkinson | 07/01/2010At some point a company will find itself looking for effective and affordable Customer Relationship Management (CRM) software.
Technical support for computer installation
By: Nick Gray | 07/01/2010Computer installation is a collaborative term associated with hardware and software installation, which in turns put life in your computer. In this article, we would discuss the installation of important software component.
Export XLS into Outlook Contacts Without Worrying About Duplicate Entries!
By: Sys Tools | 07/01/2010When a person thinks of transferring his Excel contacts from to Outlook and he has duplicate contact entries in Excel; he would obviously don’t want them to appear in duplication in Outlook. SysTools Excel to Outlook software allows de-duplicating of Excel contacts i.e. duplicate Excel entry will appear only once in Outlook contacts after conversion. So, you can export XLS to PST contacts without worrying about duplicate entries. This de-duplication feature is one of the many unique features of
Full-format support, convert DVD or any video with Leawo DVD Converter Suite
By: alex nikle | 07/01/2010Leawo DVD Converter Suite released with enhanced full-format support to convert DVD, video or audio to/between all popular formats easy and fast. Discount is available on the official page.
iPhone to Mac Transfer, backup iPhone, copy music, video, movie, photo, podcast and TV program from iPhone to Mac
By: Susan Lyrics | 07/01/2010iPhone to Mac Transfer is an amazing handy iPhone rip, iPhone backup software that can fast rip, copy, transfer and manage your music, videos, photos, podcasts and TV Shows between iPhone and Mac with ease. Moreover, Joboshare iPhone to Mac Transfer helps you create, edit and delete iPhone playlists.
Technical support for computer installation
By: Nick Gray | 07/01/2010Computer installation is a collaborative term associated with hardware and software installation, which in turns put life in your computer. In this article, we would discuss the installation of important software component.
Technical support for computer installation
By: Nick Gray | 07/01/2010Computer installation is a collaborative term associated with hardware and software installation, which in turns put life in your computer. In this article, we would discuss the installation of important software component.
Export XLS into Outlook Contacts Without Worrying About Duplicate Entries!
By: Sys Tools | 07/01/2010When a person thinks of transferring his Excel contacts from to Outlook and he has duplicate contact entries in Excel; he would obviously don’t want them to appear in duplication in Outlook. SysTools Excel to Outlook software allows de-duplicating of Excel contacts i.e. duplicate Excel entry will appear only once in Outlook contacts after conversion. So, you can export XLS to PST contacts without worrying about duplicate entries. This de-duplication feature is one of the many unique features of
Microsoft Dynamics GP 2010 Payroll Tax Update Notes
By: Andrew Karasev | 05/01/2010 | SoftwareIf your organization processes US Payroll internally in Microsoft Dynamics GP 10, 9.0 or earlier version: GP 8.0, 7.5, Great Plains 7.0, 6.0, 5.5, 5.0, in this small publication we would like to review annual Payroll Tax rates update methods.
Microsoft Dynamics GP: Recovering Failed Implementation Notes
By: Andrew Karasev | 04/01/2010 | SoftwareYour Microsoft Dynamics GP (Microsoft Great Plains, Great Plains Dynamics or Great Plains Accounting for DOS, Windows or Macintosh), not successful implementation story might be not unique. GP is mid-market Corporate ERP application, where industry expertise might be required, plus profound technical exposure for your chosen Dynamics GP Partner. Of course, if you are insisting on coming through quick Sales cycle, there is often a temptation to sell you Dynamics GP software license...
Exporting Data from Dynamics GP Notes for Consultant
By: Andrew Karasev | 03/01/2010 | Information TechnologyThere might be situations, where you need to extract info from Microsoft Dynamics GP (formerly known as Great Plains Dynamics or Microsoft Great Plains) table. In this small publication we will describe you two scenarios. First, when you need one tame data export for following data conversion into future Corporate ERP accounting system (when you are walking away from Dynamics GP to something like SAP Business One, Oracle eBusiness Suite, etc.), and second - when you need ongoing data export
SAP Business One Full Service in Chicago and Atlanta Consulting Notes
By: Andrew Karasev | 02/01/2010 | SoftwareThis small and mid-size business Corporate ERP and MRP application is relatively new on US accounting software market, however it is so flexible and robust (plus it has SAP brand, which is important in the sense of reliability and future commitment), that it provides tough competition to such traditional lower mid-market Corporate ERP applications as Microsoft Dynamics GP (formerly known as Great Plains Dynamics), Microsoft Small Business Financials (this small business corporate ERP...
Great Plains US Payroll Tax Update Service Notes
By: Andrew Karasev | 31/12/2009 | SoftwareFor customers on older versions of Microsoft Dynamics GP, Great Plains Dynamics and eEnteprise, in the case when you are processing Payroll internally (including W2 printout and mailing to your employees) - we would like to let you know that it is possible to update Federal, State and Local Taxes directly in Dynamics GP Payroll tables. We traditionally offer this service at the end of the calendar year, or in January at your convenience.
Microsoft Dynamics GP Applying Service Packs Technology
By: Andrew Karasev | 30/12/2009 | SoftwareIf your organization deploys Microsoft Dynamics GP Corporate ERP, formerly known as Great Plains Dynamics, Microsoft Great Plains, we would like to review new Service Packs applying technology in this small publication, especially after hearing opinions from former Great Plains Consultants, who are now working in Industry IT departments.
Migration to SAP Business One from Great Plains Accounting Notes
By: Andrew Karasev | 30/12/2009 | SoftwareThere are still customers, who are on Great Plains Accounting for DOS, Windows or Macintosh, typically versions 9.5, 9.2, and earlier. When Great Plains Software encouraged its GPA customers to convert to Great Plains Dynamics at the end of 20th Century (as there was a concern of GPA not being year 2000 compliant, plus support for GP Accounting was about to expire those old good days), large number of GPA customers followed the advise and migrated.
Microsoft Dynamics GP 7.5, 9.0 version update notes
By: Andrew Karasev | 27/12/2009 | SoftwareAs recession seems to be over, now it is time to take care about your Corporate ERP application, and if it is Microsoft Dynamics GP (also known as Microsoft Great Plains and Great Plains Dynamics), this small publication might be helpful on introduction level