Great,Plains,Integrations,Tool computer Great Plains Integrations Tools: IM, eConnect, Dexterity o
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
In this small publication we would like to review DynamicsGP or Great Plains (as it was previously known) integrating tools andscenarios: 1. Dynamics GP Integration Manager textintegrations. This module is user friendlyand you can easy build CSV or Tab delimited text files integrations. IM has predefined destinations to suchpopular GP objects as Customer, Vendor, Employee, GL Account, plusTransactions: Sales Order Processing (Quote, Invoice, Sales Order), PurchaseOrder Processing (Purchase Order, Receiving Transaction). If you are Payroll outsourcing company you caneasily integrate your customers employee time cards to give you the idea abouttypical industry case 2. Integration Manager Advanced cases. Here you have more challenging scenarios,when you have to pull data from external database. In IM you likely will need to deploy AdvancedODBC queries, based on Microsoft SQL Server Views (which might be heterogeneous:SQL Linked Server to Oracle DB, for example). Plus advanced ODBC query should be considered when you have Text file tobe integrated, which has non-structured format (you have to weed out commentlines, headers, footers and other attribute of human report). Also, consider the case, when you have toproduce document header and lines from single text file Advanced ODBC querywith union construction should be considered 3. eConnect. This SDK has various exposures, however the core of this connector isset of encrypted stored procedures. Great Plains 10.0 installation automatically installs eConnect storedprocs, for earlier versions, such as 9.0 you can install eConnect Runtime manually. We do not recommend eConnect to Great Plainscustomers, who are on version, earlier than 9.0. So, if you are on GP 8.0 or 7.5 you canconsider deploying eConnect, but just the fact of SDK maturity should inclineyou to the idea to upgrade your Great Plains installation to 10.0 or 9.0. eConnect is open for C# or VB.Net MicrosoftVisual Studio programmer, who is also familiar with XML and SQL StoredProcedures concept. Just one warning eConnect doesnt post GP batches, consider Great Plains Auto Posting Server tofill this gap 4. Dexterity. Great Plains Dexterity is the EDI and fundament of GP architecture. Dex is almighty, when you are thinking aboutGreat Plains customization and integration. However Dex requires professional Great Plains Dexterity programmer tobe involved, and it might be not feasible to train your IT internal programmersto begin software development in Dexterity. Dexterity is good fit to program integration, when eConnect doesntprovide functionality good example is GP invoicing module 5. SQL Stored Procedures. As Great Plains, since version 8.0 isavailable exclusively on MS SQL Server DB platform, it is natural temptation totry program integration in SQL stored procedures. The drawback of this method is long learningcurve in understanding the nature of programmed transactions, the disadvantageof competing with eConnect stored procedures, where all the work is already done
Great,Plains,Integrations,Tool