No... Oracle migration tool kit can be use only to populate the CC&B schema from the staging schema.
So, migrating data from legacy systems to staging schema can be done using any ETL tool.
Depending on the legacy systems, capacity of the source system data being migrated and the budget you can select the the migration tool.
For example, data migration from CIS+ systems to CC&B will be fairly less complicated than migrating from totally different legacy system to CC&B.
Common ETL tools in CC&B migrations I've experienced are IBM websphere Datastage and Informatica powercenter.
These tools works well for large scale migration projects.
Once you migrate data into staging schema, you can use the Oracle Migration Tool kit to perform the following.
1. Validate the information in staging tables (Object validation and Referential Integrity Validation)
2. Any tidy balance
3. Balance Control
4. Key gen
5. Insert data to production schema
6. Balance Control in Production
7. Object and FK validation Productio
Subscribe to:
Post Comments (Atom)
Do you have any documentation regarding the format of lagacy data which is required for CC&B 2.2 like field mapping or any other document.
ReplyDeleteplease send me your feedback on
rizwan88@gmail.com
The latest migration we are doing, is from CISPlus to CC&B. Most of the mapping, is less complicated as the simillar entities exist between the source and the target.
ReplyDeleteMainly, the mapping includes,
1. Entity Level Mapping
2. Attributute(Field) Mapping
3. Value level mapping (LOV - Look up of Values)
I can send you a sample document, if you want to follow the format.