Wednesday, May 8, 2019

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

As an increasing number of small and medium enterprise organizations are implementing working programs and instruments with an open platform, corresponding to Linux with numerous 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 also take a look at the methodology, however it 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, known 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. Nonetheless, 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 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 ought to be thought-about as dedicated to Microsoft applied sciences: SQL Server, .Internet, Home windows, MS Workplace: Sharepoint, Excel, and so on.

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

3. Net companies. eConnect permits you to open GP objects for third-party builders by way of XML net companies - you should utilize the eConnect interface instantly or wrap it in an internet service consumer interface

4. eConnect excurs. The eConnect core is a set of encrypted MS SQL Server saved procedures that assist you to manipulate GP grasp data and work transactions: SOP enter, POP retrieval, 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? Nicely, it is a limitation, however you'll be able to break it utilizing Albaspectrum mail server. Initially, eConnect was designed for e-commerce software program builders, which made it doable 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 sort of a standard Nice Plains integration software, was just lately partially reworked into eConnect, so IM efficiency has been considerably elevated. IM can learn comma-separated textual content recordsdata and commas, in addition to ODBC-compatible queries. If you program the mixing, just remember to select the eConnect goal connector as the popular one, moderately than deploying the traditional goal connector (old style connectors use the GP workstation as an OLE server to check the Nice Plains enterprise logic instantly on the GP screens, which is clearly reduces efficiency)

No comments:

Post a Comment

London's Espresso Martini Festival Returns Next Month... And This YearIt's Free

Maire Rose Connor London's Espresso Martini Festival returns next month ... and this year it's free We could all handle a g...