Linux & Microsoft Dynamics GP - Implementation In Cross-Platform Atmosphere

As increasingly more small and medium enterprise organizations are implementing working methods and instruments with an open platform, similar to Linux with varied blends and PHP / MySQL, we wish to share our expertise in implementing Microsoft Nice Plains in these mixed OS environments. If you're utilizing Oracle and Unix, it's also possible to take a look at the methodology, but it surely deserves a separate article only for a short overview, particularly about Java, the nuances of EJB.

1. Overview of the MS Nice Plains Platform. The GP Workstation is written in C Shell, referred to as Dexterity of the Nice Plains. It was developed within the early 1990s, when the independence of the DB and OS platform was a paradigm. Nevertheless, when Microsoft bought Nice Plains software program seven years in the past, Microsoft Dexterity was understated, and the GP itself was open to the .Internet platform and to the builders of Microsoft Visible Studio C # and VB, particularly via eConnect. As well as, GP is barely obtainable on the Microsoft SQL Server database platform. Having stated that, Microsoft Nice Plains variations 10.zero and 9.zero ought to be thought of as dedicated to Microsoft applied sciences: SQL Server, .Internet, Home windows, MS Workplace: Sharepoint, Excel, and many others.

2. Cross-platform SQL queries. When you do that on the a part of Microsoft SQL Server 2005 or 2000, you often use Linked Server, the place it is best to first attempt an ODBC reference to Linux World. If you're on Oracle, then this design will let you join MS SQL Server.

3. Internet providers. eConnect permits you to open GP objects for third-party builders through XML net providers - you should use the eConnect interface instantly or wrap it in an internet service person interface

4. eConnect excurs. The eConnect core is a set of encrypted MS SQL Server saved procedures that let you manipulate GP grasp data and work transactions: SOP enter, POP retrieval, shoppers, distributors, and lots of others. EConnect has limitations of the GP structure, one of many typical questions - why can't we publish GP packages to eConnect? Effectively, it is a limitation, however you may break it utilizing Albaspectrum mail server. Initially, eConnect was designed for e-commerce software program builders, which made it attainable to make use of the GP ERP platform as a back-office accounting for e-commerce interface.

5. Integration applied sciences. Right here once more eConnect goes on stage. GP Integration Supervisor, which is kind of a standard Nice Plains integration instrument, was not too long ago partially reworked into eConnect, so IM efficiency has been considerably elevated. IM can learn comma-separated textual content information and commas, in addition to ODBC-compatible queries. If you find yourself programming integration, just remember to select the eConnect goal connector as the popular one, reasonably than deploying the conventional goal connector (legacy connectors use the GP workstation as an OLE server to check the Nice Plains enterprise logic instantly on the GP screens, which clearly slowing efficiency)

0 Response to "Linux & Microsoft Dynamics GP - Implementation In Cross-Platform Atmosphere"

Post a Comment

Contact Us

Name

Email *

Message *