Data Migration vs. Data Conversion vs. Data Integration

Data Conversion


Conversion of data means translating the data to suite target system (data should be formatted according to target system) and then move the translated data using Interface Programs/APIs.

  • Identify the data to be imported to new system (Business requirement).

  • Extract into flat file/Staging table

  • Translate/Convert/Format the data

  • Load the data into Interface Table (using SQL* Loader/DB Link/Others) after validation (If loading the data using Interface) and then launch standard Interface concurrent program to load the data to Oracle Apps Base Tables

  • If using API, fetch the data, validate it and then call API to import the data

Conversion can be complex because you need to have a complete understanding of the source you’re converting from, and then format you’re converting to. If you don’t, you run the risk of compromising your data and ruining its integrity during the conversion process.



Data Migration


Migration of data means moving the data from one system to another using Interface Programs/APIs where both the systems have same structure of data.


Process of Migrating of data:

  • Identify the data to be imported to new system (Business requirement).

  • Extract the data into flat file/Staging table

  • Load the data into Interface Table (using SQL* Loader/DB Link/Others) after validation (If loading the data using Interface)