Data Conversion To Sap Home Business One Particular From Great Plains Dynamics Plus Notes On Odbc Co

By Author: jack jone
Total Articles: 82
Comment this article

SAP B1 is widely used as Small Organization ERP program however we know the situations when multinational business with Dynamics GP in their headquarters decided to deploy Business enterprise One particular in its overseas subsidiaries. And in a matter of a number of years they switched to B1 for headquarters at the same time. Why they decided to accomplish it? Well, you can get affordable benefits in operating accounting on Small business One for the provider operating on international markets. This tiny business ERP is localized practically worldwide and user interface is readily available in such languages as Chinese, Japanese, Mcsa Exams
Korean, Brazilian Portuguese. It might possibly be marketed as compact developing business enterprise MRP, accounting and ERP in spite of this it's not limited in its power to server just a compact business. In this small paper we would prefer to come by way of information migration from such well known packages as Superb Plains Dynamics at the same time as its predecessor Wonderful Plains Accounting for DOS, Windows and Macintosh. Let's start ...
... with data migration tool:

1. Data Transfer Workbench is suggested for initial data import inside the implementation cycle. DTW works with so-called Excel templates, which are really CSV templates. You fill them in and Information Transfer tool moves them with complete home business logic validation in to the B1. Needless to say it can be generally fine idea to help keep data migration project scope to be limited. Could you envision filling up CSV templates for historical Sales Invoices with quite a few millions of lines? This can be most certainly a limitation. But there is the option to do large scale historical information migration in DTW. It can be ODBC data source. It works the following way. You will need to move your historical tables into ODBC compliant database. We advocate you to make use of MS SQL Server data import wizard (SSIS package). When the information sits in SQL custom tables take into account developing SQL view which precisely reproduces the CSV file template. Use Union construction to make the header with column names because the very first row followed by the data rows. ODBC information supply permits you to break via CSV and Excel volume limitations. If you are programmer you might make a comment – properly, it can be apparent for me find out how to fill in CSV files. Even so how do I know my legacy application table structure and how do I connect to its database by way of ODBC? Let's speak about Amazing Plains

two. Table Structure of Good Plains Dynamics. The uncomplicated approach to analysis the structure is to login to user interface and in menu comply with the path Tools -> Resource CCNA Certification Description -> Tables. Try to find the description of such trendy tables as GL20000 (General Ledger open year posted transactions), GL30000 – historical year GL entries. Alternative strategy to investigation the structure is installing Software Development Kit where table diagram is attainable
3. Exporting data. The very first question here is your database platform. Historically GP was out there on Btrieve and its successor Pervasive SQL 2000 too as on Ctree/Faircom and Microsoft SQL Server. We do not really face the questions about exporting information from SQL Server. Btrieve still is a bit more complex to connect by way of ODBC. Btrieve ODBC connection requires so-called Information Definition Files (DDF). To produce these files you have to do some homework. By default DDF generator may possibly not be installed. Use your version installation CD to add this feature to your user workstation. Read administrator manual for detailed procedure. When you've Files, Fields and Indexes DDF files generated you might be ready to connect to Btrieve/Pervasive SQL database. The best results could be achieved in Pervasive SQL Control Center where you can issue SQL Select statements and save them into text file. If you happen to give some thought to yourself as MS Access guru you can connect to GP tables through Linked Table mechanism where you switch to ODBC data supply link. In the past when Mac PowerPC servers were competing with Windows servers Ctree/Faircom platform was well-liked on the Mac hive. In our experience Ctree database performance is a bit lower in comparison to Btrieve. Ctree ODBC driver could be installed from your original GP installation media
4. Wonderful Plains Accounting on DOS. Sometimes we are getting calls from the prospects where they are reporting that they are on Fantastic Plains. This can be true, but their technique is in reality not Dynamics but its predecessor GPA for DOS, Mac or Windows. This archaic ERP application was based in Btrieve database and it also requires DDF files to establish connection through ODBC. Please read ODBC manual which is available in PDF format on your installation CD
5. SAP Company One deployment recommendations for multinational corporation. Important thing here is centralized hosting. By various reasons international facilities are tending to establish their local IT departments with their local Windows and SQL Servers. If you ever succumb to such a trend the result is financial and general control weakening. Better thought is usually to have strong corporate IT policies where you require vital corporate applications to be hosted in the United States based headquarters and exposed to international user via Citrix application server or Microsoft Terminal Services. There's also the option to connect by way of VPN. Current version 8.81 (July 2011 as we write this paper) merged former A and B versions (as it was in 2005A/B and 2007A/B) into one and all the foreign countries could be hosted on the same SQL Server