As a smaller business organizations and medium are deploying open source operating system platform 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, too can consider the methodology, however, which deserves separate article only for a brief hearing, especially on Java, EJB nuances.

1. Great view MS platform Plains. GP workstation is written in C Shell, named Great Plains Dexterity. It was designed in earlier 1990th, when PP and platform independence of system operation was the paradigm. However, when Microsoft bought Great Plains Software, seven years ago, Microsoft Dexterity was a kind of relief and – GP itself was open for. Net platform and Microsoft Visual Studio C # and VB developers, especially through eConnect. In addition, GP is available on the Microsoft SQL Server PP only. Saying this, Microsoft Great Plains version 10.0 and 9.0 should be regarded as a commitment to Microsoft technologies: SQL Server,. Net, Windows, MS Office: SharePoint, Excel, etc.

2. Cross Platform SQL queries. If it does so from Microsoft SQL Server 2005 or 2000 side, construction is typically used linked server, should first try the ODBC connection to Linux World. If you are on Oracle, then a similar construction allows you to connect MS SQL Server

3. Web Services. eConnect allows you to open objects GP for non-Microsoft developer through XML web services â € "you can use the interface eConnect directly or wrapped in custom Web service interface

4. excursus eConnect. The core of eConnect is a set of MS SQL Server encrypted stored procedures, allowing you to manipulate GP master records and work transactions: SOP Entry, POP Receivings, customers, suppliers, to name a few. eConnect has restrictions of Albaspectrum ad server. eConnect was initially dedicated to software developers e-commerce, so as GP ERP platform for back office accounting e-commerce front end

5. Integration technology. EConnect Here comes again to the scenes. GP Integration Manager, which is rather traditional Great tool integration of the Plains, was recently redesigned in eConnect and partly so the performance of MI was substantially increased. IM can read the information and text files comma delimited, as well as consultations with ODBC compliant databases. When is the integration of programming, be sure to select destination eConnect connector preferred against the deployment of regular destination connector (old-fashioned connectors use physician workstation as OLE server to validate the Great Plains business logic directly on screen in GP, which obviously slows down performance)

About the Author:

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.

Article Source: ArticlesBase.com – Linux & Microsoft Dynamics Gp – Implementation in Cross-platform Environment

Three Minut Mashup – Microsoft Popfly