Success Support Communities
Connect and collaborate with Informatica experts and champions
Have a question? Start a Discussion and get immediate answers you are looking for
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Knowledge Center
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Information library of the latest product documents
Best practices and use cases from the Implementation team
Learn
Role-based training programs for the best ROI
Get certified on Informatica products. Free, Foundation, or Professional
Free and unlimited modules based on your expertise level and journey
Self-guided, intuitive experience platform for outcome-focused product capabilities and use cases
Resources
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix statements of Informatica products
Monthly support newsletter
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
End of Life statements of Informatica products
Overview

Review IDMC capabilities for leveraging SQL Server database compute for data integration pipelines.

Pre-Requisites
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.

Expert Session Agenda
  • 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
Deliverables

Expert Guidance Session

Required Roles/Personas
Actions
Add to Favorites
Engagement Details
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

  • Catalog offers Engagements for Informatica Cloud Services on IDMC platform only.  
  • All Engagement Topics in this Catalog 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.