Dynamics,Partner,Chicago,Data, computer Dynamics GP Partner Chicago Data Migration Notes
----------------------------------------------------------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
We recommend you to review multiple tools and options tomake your own estimation on the data migration scope and expectedcomplexity. This small publication isintended for IT people: 1. IntegrationManager. This tool is preferred, as itvalidates business logic in importing process. Customers, Vendors, Addresses, GL Accounts, and various transactionscould be imported via IM with relatively quick learning curve. If you plan to bring historical GLtransactions, then we recommend you to bring them month by month and post themin GL module, as the only way to import transactions is to import them in Workstatus and you cannot import transactions directly to history via IM. If you are versatile programmer and you wouldlike to probe your skills in advanced IM routines, read about such techniquesas VBA scripts (Before Integration, Before Document Commit, etc.) and AdvancedODBC Sources (where you can base your incoming data on SQL View, or createUnion constructions over tab or comma delimited text files) if you can createSQL View in MS SQL Server Management Studio, including heterogeneous Selects (crossplatform: Oracle, Excel, MS Access, Lotus Notes, Text files, etc.) then youshould be able to import data from these views via Dynamics GP IntegrationManager 2. eConnect. This is for ongoing and often real timeintegration in ecommerce environments. eConnect is Software Development Kit and you can program integration inMicrosoft Visual Studio C#, VB or another programming language. IM is currently under reconstruction todeploy eConnect as its base level 3. DirectSQL data feed. Dynamics GP is MicrosoftSQL Server hosted application, so theoretically you can do direct Insert. We have to warn you here, that direct insertcan easily compromise data integrity, as you do not validate complex businesslogic 4. DataConversion Scope. If you are using IMand your goal is to bring historical transactions in Sales, Purchasing,Inventory you can do it month by month with batches verification and posting. This process might be too time (includingconsulting time) consuming, so in preferred scenario you should consider havingthe old Accounting system available for inquiry only in several yearstransition period and bring masters records (Customers, Vendors, GL accounts,etc.) and GL beginning balances only
Dynamics,Partner,Chicago,Data,