Intelligent Data Management Cloud (IDMC) is an on-demand subscription cloud service that provides access to Cloud Data Ingestion and Replication, Data Integration, MDM SaaS, and Reference 360 assets.
Note:
•For the business entities to appear in the data lineage, create a new Informatica Intelligent Cloud Services catalog source and run the job, instead of running the existing catalog source again.
•When you run an Informatica Intelligent Cloud Services catalog source job, you can view lineage for IDMC mappings that read data from and write data to Salesforce source systems.
•You can run an Informatica Intelligent Cloud Services catalog source job to view lineage for IDMC mappings that include custom queries to read data from Amazon Redshift source systems.
You can run connection-aware scans on Informatica Intelligent Cloud Services sources.
Objects extracted
Metadata Command Center extracts the following objects from IDMC:
Data Integration
- Advanced mapping
- Application ingestion and replication task
- Application ingestion and replication task instance
- Calculation
- Database ingestion and replication task
- Database ingestion and replication task instance
- Data synchronization task
- Dynamic mapping task
- Dynamic mapping task instance
- Folder
- Mapping
▪ ELT (Extract Load Transform) Mapping
▪ ETL (Extract Transform Load) Mapping
- Mapping task
- Mapping task instance
- PowerCenter task
- Project
MDM SaaS
- Attribute
- Business entity
A business Entity can be used in mapping tasks as sources or targets.
- Calculation
- Data Quality
- Data Quality Calculation
- Field
- Folder
- Hierarchy Field
- Hierarchy Instance
- Hierarchy Relationship
- Landing Data Set
- Landing Field
- Mapping
▪ ETL (Extract Transform Load) Mapping
- Mapping task
- Mapping task instance
- Match and Survivorship
- Match and Survivorship Calculation
- MDM Hierarchy
- MDM Relationship
- Project
- Relationship Field
- Source Record Data Set
- Source Record Field
- Source System
- Source System Folder
- System field
Reference 360
- Code list
- Crosswalk
- Hierarchy
- Hierarchy data set
- Mapping
▪ ETL (Extract Transform Load) Mapping
- Reference data set
- Mapping task
- Mapping task instance
Metadata Command Center extracts the following types of tasks:
•Mapping task. A mapping task defines reusable data flow logic that is not available in Data Synchronization tasks, such as specific ordering of logic or joining sources from different systems.
•PowerCenter task. The PowerCenter task imports PowerCenter workflows to Informatica Cloud and runs them as Informatica Cloud tasks.
•Data synchronization task. The Data Synchronization task synchronizes data between a source and target.
•Mapping task instance. Instance is an execution of a mapping task.
Note: Metadata Command Center
also extracts these tasks when they are run from taskflows.
You can extract advanced mappings with the following transformation types:
•Mapplet
•MappletInput
•MappletOutput
•Aggregator
•Sorter
•Expression
•Filter
•Joiner
•Lookup
•Normalizer
•Rank
•Router
•Sequence
•Union
•AccessPolicy
To extract advanced mappings, use the following connectors:
•Amazon Redshift V2
•Amazon S3 V2
•Databricks Delta
•Google BigQuery V2
•Google Cloud Storage V2
•Hive Connector
•Microsoft Azure Data Lake Storage Gen2
•Microsoft Azure Synapse SQL
•Microsoft Fabric Data Warehouse
•Microsoft Fabric Lakehouse
•Microsoft Fabric OneLake
•Snowflake Cloud Data Warehouse
You can override the parameters of a task in a mapping task when you use the following connectors:
•Amazon Redshift V2
•Databricks Delta
•Google BigQuery V2
•Microsoft Azure Synapse SQL
•Microsoft Fabric Data Warehouse
•Microsoft Fabric Lakehouse
•Microsoft Fabric OneLake
•Snowflake Cloud Data Warehouse
To extract metadata from Cloud Data Ingestion and Replication application or database tasks, use the following connectors:
•Application Ingestion and Replication task sources:
- Salesforce Mass Ingestion
•Application Ingestion and Replication task targets:
- Amazon S3
- Microsoft SQL Server
- Oracle
- Snowflake
•Database Ingestion and Replication task sources:
- Oracle
- Microsoft SQL Server
•Database Ingestion and Replication task targets:
- Amazon S3
- Microsoft SQL Server
- Oracle
- Snowflake
Data Lineage
The following lineage data is available for IDMC assets (CDI, CDI-E, CDI-R):
•Data set level
•Data element level
•Default column
Data lineage is available for the following MDM SaaS assets when run through Ingress/Egress jobs:
•Data Quality
•Landing Data Set
•Match and Survivorship
•Source Record Data Set
Data lineage is available for the following Reference 360 assets:
•Code list
•Crosswalk
•Hierarchy
For more information about data lineage, see the Asset Discovery help.