Data Migration - is moving required and large volume of data from client's legacy/custom system to new system.
Data Conversion - is converting data from one structural form to another to suit the requirement of the system to which it is migrated.
Interface - are programs for connection between two systems in order to synchronize the data. These can be batch, real-time or manual. Used repeatedly so should be efficient. Can be triggered by an event to run as concurrent program or scheduled to run at certain time.
Standard Import Programs from Oracle -
1. GL: Journal Import
2. AP: Payables Open Interface
3. AR: Customer Interface
4. AR: Autoinvoice
5. INV: Item Import
Ways to interface data into Oracle Applications -
Simple ways -
1. From Screen manually
2. Oracle Open System Interface
3. Store in database directly
Complex ways -
4. 3rd Party Softwares for direct DB update
5. Taviz (formerly SmartDB) which is a EAI tool.
6. Crossroads
7. See beyond (formerly STC)
8. Vitria
9. Data Loader - They have macro enabled spreadsheet kind of tool.
10.More4Apps
11. EDI - Electronic Data Interchange
Most of these are used for master data migration.
Data Conversion - is converting data from one structural form to another to suit the requirement of the system to which it is migrated.
Interface - are programs for connection between two systems in order to synchronize the data. These can be batch, real-time or manual. Used repeatedly so should be efficient. Can be triggered by an event to run as concurrent program or scheduled to run at certain time.
Standard Import Programs from Oracle -
1. GL: Journal Import
2. AP: Payables Open Interface
3. AR: Customer Interface
4. AR: Autoinvoice
5. INV: Item Import
Ways to interface data into Oracle Applications -
Simple ways -
1. From Screen manually
2. Oracle Open System Interface
3. Store in database directly
Complex ways -
4. 3rd Party Softwares for direct DB update
5. Taviz (formerly SmartDB) which is a EAI tool.
6. Crossroads
7. See beyond (formerly STC)
8. Vitria
9. Data Loader - They have macro enabled spreadsheet kind of tool.
10.More4Apps
11. EDI - Electronic Data Interchange
Most of these are used for master data migration.
