Great,Plains,Data,Import,Dynam computer Great Plains Data Import: Dynamics GP Integration
----------------------------------------------------------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 give you initialhighlights and after getting this help you should be able to find additionalinfo in GP user manuals, Customer Source Knowledge database or request itthrough your Dynamics GP Partner or reseller 1. DynamicsGP Integration Manager. This tool isuser friendly and allows you to import majority of GP master objects: accounts,customers, vendors, employees, addresses; work transactions: sales invoice,purchase order, payroll transaction to give you the idea. In IM you should come through several stepsto design integration: setup source or sources (if more than one you shouldlink them into one set following SQL rules), select destination (like SOP Entry target object) and then tune destination mapping. If you are programmer, you would also like toreview IM VBA scripting chapters in IM manual. IM accepts tab, csv as well as custom character delimited text filesplus via ODBC and Advanced ODBC you can import or integrate everything that isODBC compliant: Microsoft SQL Server, mySQL, Oracle, DB2, SyBase, Lotus NotesDomino, Microsoft Access, Microsoft Excel, FoxPro and so on and so on. ODBC integration should work in most of theEDI (Electronic Document Interchange) scenarios, where you pull data intoDynamics GP 2. eConnect. For those of you who are looking into moretechnically challenging projects: real time, ecommerce, scheduled integration,and if you are comfortable with Microsoft Visual Studio C# or VB .Netprogramming with XML and SQL elements, please consider eConnect. This SDK was initially designed for ecommerceweb programmers to integrate ecommerce website with Dynamics GP back office 3. SQLinsert statements. If you are SQL DBA orvery experienced programmer, we understand the desire to push records directlyto Dynamics GP SQL tables. However, youwill face the challenge of meeting very complex business logic and itsreflection in data flow. Plus all thiswork was already completed by eConnect developers, where end technology is SQLServer encrypted stored procedures. So,this approach of direct SQL scripting might only be recommended if your GPimport task is absolutely simple (when you have to populate one table only, forexample) 4. SQLDTS packages. Here you could consider complexscenarios, when you are exporting data from cross-platform database, callingeConnect based application to move data to GP and then mark the data asimported in your source DB. Call yourDynamics GP technical consultant for further details
Great,Plains,Data,Import,Dynam