[ad_1]
As a lot more midsize and small small business corporations are deploying open platform working systems and equipment, these as Linux with numerous blends and PHP / MySQL, we would like to share our knowledge implementing Microsoft Terrific Plains in these blended OS environments. If you are working with Oracle and Unix, you might also think about the methodology, however it describes different posting just for brief overview, specially about Java, EJB nuances.
1. MS Good Plains platform overview. GP workstation is composed in C Shell, named Fantastic Plains Dexterity. It was developed in early 1990th, when DB and OS platform independence was the paradigm. Nonetheless, when Microsoft obtained Excellent Plains Computer software seven many years in the past, Microsoft Dexterity was sort of de-emphasised and GP by itself was open for .Net system and for Microsoft Visible Studio C # and VB developers, specially via eConnect. Plus, GP is readily available on Microsoft SQL Server DB platform only. Stating these, Microsoft Wonderful Plains version 10. and 9. must be regarded as as fully commited to Microsoft systems: SQL Server, .Internet, Windows, MS Office environment: Sharepoint, Excel, and many others.
2. Cross System SQL Queries. If you do it from Microsoft SQL Server 2005 or 2000 aspect, the construction you typically use is Joined Server, in which you need to very first check out ODBC connection to Linux Planet. If you are on Oracle, then comparable design will allow you to hook up MS SQL Server
3. World-wide-web escort companies in Chicago. eConnect allows you to open up GP objects for non-Microsoft developer by way of XML net escort solutions in Chicago – you can possibly use eConnect interface right or wrap it in custom made web escort provider in Chicago interface
4. eConnect excurse. The core of eConnect is established of MS SQL Server encrypted saved treatments, enabling you to manipulate GP grasp records and operate transactions: SOP Entry, POP Obtaining, Prospects, Vendors to name a handful of. eConnect has restrictions of GP architecture, a single of the regular FAQ is why we can not publish GP batches in eConnect? Nicely, this is the restriction, but you can crack it employing the Albaspectrum publishing server. eConnect was initially focused to eCommerce software program developers, to enable GP ERP platform as backoffice accounting for e-commerce front conclude
5. Integration technologies. Listed here yet again eConnect will come to the scenes. GP Integration Manager, which is instead standard Terrific Plains integration device, was recently redesigned partly in eConnect and so IM functionality was considerably increased. IM can examine tab and comma delimited textual content files as well as ODBC compliant queries. When you are programming integration, be confident that you pick eConnect vacation spot connector as desired, compared to deploying normal spot connector (previous-fashioned connectors use GP workstation as OLE Server to validate Excellent Plains business enterprise logic immediately in GP screens, which naturally slows down the general performance )
[ad_2]
Resource by Andrew Karasev