27 September 2010

appMIGRATE - a next generation data migration tool for Oracle E-Business Suite R12/11i

appMIGRATE is a powerful tool to extract, transform, validate, cleanse, correct and migrate data from an older version of Oracle E-Business Suite or any legacy system into newer version of Oracle EBS. Upon finalization of requirements the migration of data from legacy/older Oracle EBS systems to newer Oracle 11i/R12 can be accomplished in 2-4 weeks.

Some of the key features includes:
1. Data Extraction from legacy or Oracle EBS Older systems (prior to R12)
2. Pre-built extraction adapters for Oracle 11i data
3. Project / Task Groups - Tasks - capable of handling parallel and serial processing of
data migration
4. Data Consolidation - for Big bang or roll-out approaches
5. Data Cleansing
6. Data Corrections
7. Data Transformation - before validation or after validations
8. Data loads in the background application server
9. Duplicate data filtering
10. Easy mapping tool
11. Seamless integration with appLOAD and appEXTRACT tools.


Projects and Tasks
appMIGRATE provides a flexible framework to create multiple projects and each project can have multiple tasks. Each task can handle appropriate extractions and transformations, validation, cleansing, automated data correction and loading.



Extraction
appMIGRATE provides simple and powerful wizard driven extraction tool. Extraction can be done from tables, views and appEXTRACT adapters. Links between data tables can be also performed.



Mapping
appMIGRATE provides drag and drop mapping tool to map the extracted data into appLOAD.



Scheduler
appMIGRATE can schedule to execute the project and tasks in accordance with a specific timeline. Processes run in parallel and/or in sequence. All processes are executed in the background without any intervention. The completion of processes triggers email notifications to the process owner. The email notifications show detailed checksum information, extraction, loading, error, validation, and log information. This information is stored in the application server for any future auditing purpose.



Transformation
The extracted data can be transformed by a simple condition based action logic. It supports grouping of conditions. Transformation can be applied based on specific field data or another field data of the same record.



Validation
appMIGRATE has pre-seeded validations on all loading templates. The business user/developer can add additional validations as needed. The records which fail validation remain unprocessed. We provide an automated data correction feature (Cleansing Engine). This acts on unprocessed data by applying threshold factors.



Loading
appMIGRATE loads data using appLOAD. Therefore all its features are inherited.



Software as a Service
appMIGRATE is also available to our customers in SaaS managed services and SaaS subscription models. In the SaaS managed services Chain-Sys will perform the migration activity as a service. In the Saas subscription model the customers pay yearly subscription and use the product hosted on our datacenter in Lansing,MI.

1 comment:

Alfred Avina said...

With the latest technology and the new data migration tools it has become easy to transfer the data from one file to another properly. Your company had helped me in fulfilling the data migration task when I had followed all the crucial steps or functions suggested by your company correctly.