Overview
Review IDMC capabilities for leveraging SQL Server database compute for data integration pipelines.
Pre-Requisites
- Parent Production Organization provisioned, and access verified with at least one customer-side administrator
- At least one runtime environment registered
- Basic understanding of CDI
- At least one connection configured for SQL Server
This engagement provides advisory services only, offering guidance without direct implementation or technical troubleshooting. For technical issues with product, please reach out to Global Customer Support. For assistance with implementation, you may want to consider Informatica Professional Services.
Self-Service Resources
Goals
- Review Advanced Pushdown Optimization (APDO) to push transformation logic to SQL Server:
- Full pushdown
- Source pushdown
- Review configuration steps
- Cross-schema pushdown optimization
- Review rules and guidelines before configuring pushdown optimization
Outcome
As a Developer, understand how to leverage SQL Server computing for ingestion pipelines.
- Discuss APDO types and features
- Review supported functions
- Discuss configuration steps
- Discuss pushing logic to a database with different schemas
- Review rules and guidelines before configuring pushdown optimization
Expert Guidance Session
Required Roles/Personas
- Developer
Engagement Details
Catalog Type
Connect with Architect
Engagement Category
Cloud Integration
Products
Cloud Data Integration
Engagement Type
Solution Advisory
Adoption Stage
Value
Focus Area
Adoption
Use Cases & Tags
Cloud Modernization
Engagement ID
CLD-017
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.