Data Cleansing And Templates Preparation Prior To Migration To Sap Business A Single

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

It is typically decent concept to steer clear of full scale data export and migration into your new Corporate ERP system or in other words to migrate substantial portion of historical invoices, payments as well as other documents. It truly is less difficult and spending budget wise cheaper to keep the old accounting internet for information querying only purposes. Sometimes you have got no way of keeping the old application web based because of subscription model or perhaps another cause. We would prefer to share with you advanced methods of migrating in Information Transfer Workbench. This system doesn't need high priced third party tools. On the other hand it calls for some creativity out of your IT department folks and in particular SQL guru. Let's start:

1. Information Transfer Workbench and CSV templates or also referred as Excel templates. DTW is fairly straightforward tool, which does not have flexibility ccnp exam inside the sense that it needs you to provide documents in CSV template for the document origin. When you have to import high volume of historical transactions ...
... you commonly anticipate this procedure to become completed with numerous or perhaps much better say various iterations. And iteration requires CSV files repopulation in Excel. Plus if you are about to migrate million plus documents and their specifics Excel may well be too slow or perhaps not ready to deal with such a job. The sad news may well be the future understanding that you have already spent the spending budget allocated for data conversion project with no good results. Are we carried out with this consulting team and migration project or should certainly we just appear for second opinion? The answer is probably second opinion is usually a wonderful notion
2. As opposed to filling up CSV templates take into consideration connection for your legacy information via ODBC connection. ODBC connection is the solution and you are able to connect to your legacy database directly. But we figured that greater thought is always to import your legacy ERP tables into MS SQL Server Custom database by way of data import wizard/SSIS. Documentation is fairly restricted and we did our own experiment and figured out that SQL View could be the answer. There's no need to do information cleansing in tables directly because it may be completed directly in SQL View and this View might be changed with every iteration as you might be progressing with migration and information massage. Now we are moving to the discovery itself

3. SQL View and CSV template a practice exams format. It seems like you need to use Union statement and imitate two specifically the identical lines containing template column headers. There is certainly no have to represent all the headers just needed and optional at your discretion. And second Choose statement should certainly offer the rows of data. Please note that SQL View is not limited towards the volume of records. It may reasonably deal with millions when Data Transfer Workbench is great in its performance to move inside your huge information poll into SAP B1. We assume that you just do iterations inside the test copy of one's production enterprise exactly where settings are present and you might be restoring this test firm over and more than once more
4. Cross-Platform View in SQL Server. In the event you really feel that you're comfortable to connect by way of ODBC or native driver to your legacy database then it's feasible to produce SQL View operating with such constructions as Linked Server or Open Row Set. It looks like Microsoft is trying to switch accents and advocate SQL Server Integration Services in SQL Server 2005 and 2008. We also discovered that Linked Server and Open Row Set did not perform as expected on SQL Server 2008 on 64 bit computing platform
five. Exporting information out of your legacy accounting. You can get two favorite procedures. First one is ODBC connection assuming that you just know tables structure. For anybody who is walking away from such favorite accounting systems as Wonderful Plains Dynamics on Pervasive SQL Server, Terrific Plains DOS on Btrieve it is attainable to make ODBC connection depending on so-called Data Definition Files (DDF). For anybody who is exporting data from such compact home business accounting packages as QuickBooks, Peach Tree (on proprietary database not on MS SQL Server), MYOB it is actually in all probability much easier to print reports into text files and begin data cleansing from there. Any time you have to print reports into text files we advise you to import these files into SQL Server custom database and abstract your cleansing in SQL Views. Your custom SQL View should weed out such human interface supporting rows as Report Header, Page Number, Blank Line, Report Footer, Summaries, and so forth.

6. Message to SAP BO customers within the country side location where neighborhood assistance may well be limited and lacking encounter. Information migration projects are not a rocket science and technical consultant or programmer will not need to be present within your country side office to accomplish the job. Net sessions, telephone conference and remote desktop connections provide you with a great benefit to invite remote assistance. For anybody who is in the point where you feel that your SB1 implementation project was screwed because of information import limbo feel free to provide us a call or improved email us