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

As increasingly more small and medium enterprise organizations are implementing working programs and instruments with an open platform, resembling 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, you may as well have a look at the methodology, however it describes a separate article only for a quick 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 by means of eConnect. As well as, GP is just accessible on the Microsoft SQL Server database platform. Having mentioned that, Microsoft Nice Plains variations 10.zero and 9.zero must be thought-about as dedicated to Microsoft applied sciences: SQL Server, .Internet, Home windows, MS Workplace: Sharepoint, Excel, and so on.

Cross-platform SQL queries. Should you do that on the a part of Microsoft SQL Server 2005 or 2000, you normally use Linked Server, the place you must first strive an ODBC reference to Linux World. If you're on Oracle, then this design will can help you join MS SQL Server.

3. Internet companies. eConnect means that you can open GP objects for third-party builders through XML internet companies - you need to use the eConnect interface straight 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 can help you handle GP grasp information and operational transactions: SOP login, POP reception, purchasers, distributors, and plenty of others. EConnect has limitations of the GP structure, one of many typical questions - why can't we publish GP packages to eConnect? Properly, it is a limitation, however you'll be able to take away it utilizing the Albaspectrum mailing server. Initially, eConnect was meant for e-commerce software program builders to allow the GP ERP platform as back-office accounting for e-commerce interfaces.

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

No comments:

Post a Comment

Contact Us

Name

Email *

Message *