Import legacy data to SAP CRM 7.0

Question

Hello I would like some advice, links, etc., on importing legacy data from an external system to SAP CRM 7.0.

We are currently using a different SQL based CRM system and are moving to SAP CRM 7.0. I need to export all the SQL database data and feed it into SAP CRM 7.0. What tools are available to me or what can I do to accomplish this task.

I am very new to SAP CRM 7 and SAP in general. I guess you can assume that the data will be a text file (maybe a CSV). How will I handle 1->many relationships? etc...

Jon

Answer 1

I assume the data will be several CSV files - one per source table. I don't know a lot about CRM, but you might want to take a look at the Legacy System Migration Workbench - a great tool for importing data into SAP R/3 based systems. I assume you already know the docs at http://help.sap.com/crm. There are also some best practices documents available (navigate to Implementation Project --> Data Migration) - but you'll need a SAPnet Service Marketplace user ID (S.....) for this.

Answer 2

Your options may vary depending on what licenses or tools you have at fingertips or what backend is behind your legacy CRM, but generally SAP recommends for interchanging data between CRM and external systems SAP CRM Integration services which has several adapters for different data types.

SAP MDG is a more full-fledged solution, equipped with more tools. Also CRM has industry specific tools, for example, for utilities.

Also check this my answer that was written for MSSQL database, but it is fully relevant for any DB.