Description
This engagement covers best practices for doing asset migration using the Self-Service Workbench (SSWB) in CDI-PC to convert and modernize PowerCenter assets to the cloud. It guides architects through conversion job, XML Preprocessing file, SQL Conversion and Bulk Metadata Update and data from repository assessment for minimizing manual work.
It also covers usage of CDV for data testing during migration.
Setting up secure agents for managing workloads.
Customer Prerequisites
- Repository assessment completed before conversion.
- POC completed to know about the PC configurations and setup Pre processing file, Conversion Properties & configuration set accordingly.
- CDV Access to IDMC Users.
Self-Service Resources
Goals
- Convert the assets flagged as Auto, Partial in Assessment with minimal manual intervention and know the steps to convert Manual ones to IDMC.
- Learn from POC/initial conversions to utilize XML Preprocessing, SQL Conversion and Bulk Metadata update to maximize automated conversion and minimize manual intervention.
- Effective usage of CDV for data testing.
- Setup secure agent for managing workloads.
Business/Technical Outcomes
- Successfully migrate assets classified as Automated, Partial, or Manual.
- Apply configurations to maximize automated conversion rate and reduce manual rework to successfully migrate the workloads to IDMC. Effective usage of CDV for data testing.
- Walkthrough the POC to understand the differences of configurations not migrated in defaults settings for Auto and Partial Assets.
- Hands-on: Connection Map, Conversion Properties, and SQL conversion configuration, XML Preconfig and CDV.
- Review the improvement in manual activities for conversion and reduce the migration time.
- Expert Guidance on minimizing manual work on Auto and Partial Assets by utilizing Connection Map templates, Conversion Properties, Bulk Update and XML Preprocessing. And Properties comparison between CDIPC and IDMC assets.
- Guide on handling manual assets in IDMC.
- Data validation using CDV.
Required Roles/Personas
- IDMC / CDI-PC Administrators
- IDMC / CDI-PC Developes
Engagement Details
Catalog Type
Connect with Architect
Engagement Category
PowerCenter Modernization
Products
CDI for PC
Cloud Data Integration for PowerCenter
Engagement Type
Best Practices
Adoption Stage
Implement
Focus Area
Adoption
Use Cases & Tags
Analytics and BI
Engagement ID
MOD-015
Disclaimer
- Success Accelerators offers Engagements for Informatica Cloud Services on IDMC platform only.
- All Engagement Topics in the Success Accelerators are intended to be delivered in guidance and advisory mode only. This is implicit and it will not be called out explicitly under each engagement’s scope separately.
- Customers need to include their relevant technical/business team highlighted in each engagement topic to derive the best out of each engagement.
- Customers need to perform any hands-on work by themselves leveraging the guidance from these engagements.
- Customers need to work with Informatica Global Customer Support for any product bugs/issues and troubleshooting.
- Value Accelerator is available only for IDMC Services and this is offered only to eligible customers. Please check with your Customer Success Manager for eligibility before requesting Value Accelerator engagement.