Released on: 31, December 1969
, Author: Alba Spectrum Group
, Audience: Computers related
ore midsize and small business organizations are deployingopen platform operating systems and tools, such as Linux with various blends andPHP/MySQL, we would like to share our experience implementing Microsoft Great Plainsin these combined OS environments. If you are using Oracle and Unix, you may alsoconsider the methodology, however it deserves separate article just for briefoverview, especially about Java, EJB nuances.1. MS Great Plains platform overview. GP workstation is written in C Shell, namedGreat Plains Dexterity. It was designed in earlier 1990th, when DB and OS platformindependence was the paradigm. However, when Microsoft acquired Great PlainsSoftware seven years ago, Microsoft Dexterity was kind of de-emphasized and GPitself was open for .Net platform and for Microsoft Visual Studio C# and VBdevelopers, especially via eConnect. Plus, GP is available on Microsoft SQL ServerDB platform only. Saying these, Microsoft Great Plains version 10.0 and 9.0 shouldbe considered as committed to Microsoft technologies: SQL Server, .Net, Windows, MSOffice: Sharepoint, Excel, etc.2. Cross Platform SQL Queries. If you do it from Microsoft SQL Server 2005 or 2000side, the construction you typically use is Linked Server, where you should firsttry ODBC connection to Linux World. If you are on Oracle, then similar constructionwill allow you to hook up MS SQL Server3. Web Services. eConnect allows you to open GP objects for non-Microsoft developervia XML web services you can either use eConnect interface directly or wrap it incustom web service interface4. eConnect excurse. The core of eConnect is set of MS SQL Server encrypted storedprocedures, allowing you manipulate GP master records and work transactions: SOPEntry, POP Receivings, Customers, Vendors to name a few. eConnect has restrictionsof GP architecture, one of the typical FAQ is why we can not post GP batches ineConnect? Well, this is the restriction, but you can break it utilizingAlbaspectrum posting server. eConnect was dedicated initially to eCommerce softwaredevelopers, to enable GP ERP platform as backoffice accounting for e-commerce frontend5. Integration technology. Here again eConnect comes to the scenes. GP IntegrationManager, which is rather traditional Great Plains integration tool, was recentlyredesigned partially in eConnect and so IM performance was substantially increased. IM can read tab and comma delimited text files as well as ODBC compliant queries. When you are programming integration, be sure that you select eConnect destinationconnector as preferred, versus deploying regular destination connector(old-fashioned connectors use GP workstation as OLE Server to validate Great Plainsbusiness logic directly in GP screens, which obviously slows down the performance) Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com -help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canadanationwide: 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, MissionBend, 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.
Source: Express-Press-Release.com
Related downloads
The Prestwood Load Balancer is a cross-web server, cross-platform web request dispatcher that distributes direct HTTP calls to various web servers, based on the total number of pending requests to each server and the average response time.
DEKSI Net Remote is a .Net Cross platform and Cross device communications framework for PC's and PDA's. It allows you to build advanced systems with a basic networking knowledge.
Editize is a cross-browser, cross-platform rich text editor that can be easily integrated into any content management system. Since Editize isn't branded, you can make a profit by offering it to your web development clients.
Integrate everything to Microsoft CRM. Scheduled imports/exports and synchronizations. The only tool you need in your Microsoft CRM Implementation project. Free download and Try!
A cross platform time tracking utility. Time Trek is a super small (and super simple) utility to help you keep track of your freelance or consulting projects. Great for webmasters and graphic designers!
muCommander is a cross-platform file manager with support for many filesystems and archive formats. It is open-source and available in 22 languages.
Oxygen is a cross platform XML Editor,XSLT/XQuery Debugger and Schema Editor. Can validate XML, XSD, RNG, DTD, NRL, Schematron and XSL. Features XSLT transformation and FOP support, code insight,outliner, SVN Client and native XML Databases support.
QuickBuild is a platform supporting all levels of build needs such as continuous integration, nightly build, QA build, and release build. Access control can be applied to these build levels to separate duties among different roles of the team.
The Kinesics Text Editor is an efficient editing tool with native GUI and console versions for Windows and Linux. The interface is geared towards developers who feel frustrated by development environment style text editors.
A full featured graphical File Transfer Program for windows, linux and macintosh desktops. The FTP client is multithreaded allowing you to perform several tasks concurrently. It's available as a free download and does not expire.
