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.
data migration as a service solves the problem of transferring data without taking much time. I had moved a large amount of the data from one system to another one by taking help from the services offered by your data migration service providers.
ReplyDeleteIt offers a quick and easy way to move databases and virtual machines to Microsoft's Azure cloud service from either on-premises servers or other cloud services, such as Amazon Web Services.
ReplyDelete