Data Migration is a process of moving required (and most often very large) volumes of data from our clients’ existing systems to new systems. Existing systems can be anything from custom-built IT infrastructures to spreadsheets and standalone databases.
Data conversion can be defined as a process of converting data from one structural form to another to suit the requirements of the system to which it is migrated. It is a process where existing data from the client’s old system is extracted, cleansed, formatted, and installed into a new system. These can be manual or automated. The big difference is that these are One-time only process that requires extensive testing and preparation. They must be executed and performed before a system goes into production.
Interfaces are programs for connection between Two Systems In Order To Synchronize the Data. They can be Manual, Batch or Real-Time. Used Repeatedly and Should Therefore Be Designed and Constructed In the Most Efficient Manner Possible. These can Be Triggered by an Event (Such As Running A Concurrent Program) Or It Can Be Scheduled To Run At A Certain Time. Can Be Very Costly To Construct And Maintain.
Data conversion can be defined as a process of converting data from one structural form to another to suit the requirements of the system to which it is migrated. It is a process where existing data from the client’s old system is extracted, cleansed, formatted, and installed into a new system. These can be manual or automated. The big difference is that these are One-time only process that requires extensive testing and preparation. They must be executed and performed before a system goes into production.
Interfaces are programs for connection between Two Systems In Order To Synchronize the Data. They can be Manual, Batch or Real-Time. Used Repeatedly and Should Therefore Be Designed and Constructed In the Most Efficient Manner Possible. These can Be Triggered by an Event (Such As Running A Concurrent Program) Or It Can Be Scheduled To Run At A Certain Time. Can Be Very Costly To Construct And Maintain.
Inbound Interfaces
An inbound interface receives data from one system (legacy) and inserts into Oracle open interface tables. A typical inbound interface would follow these steps: Extract data from legacy system into a flat file. Use SQL*Loader or equivalent tool to upload information into a temporary table. Write a PL/SQL program to take data from the temp table and insert into the Open Interface Tables. Through the concurrent manager in Oracle Applications, run the standard Oracle Interface program to transform interface tables into Oracle data.
Outbound Interfaces
An outbound interface takes data from Oracle tables and inserts it into an external system (via tables or flat file). A typical outbound interface would follow these steps:- Write a PL/SQL program to extract data from Oracle base tables into a flat file.- Use a custom program to read that data and post it into the legacy system
No comments:
Post a Comment