Data Integration Connectors

What's New

Read What's New to learn about new features, enhancements, and behavior changes in Informatica Intelligent Cloud Services℠ Data Integration for the August 2023 release. You can also learn about upgrade steps that you might need to perform.

Connector Release Notes

Read the Data Integration Connector Release Notes for information about fixed and known issues for Data Integration connectors. Consider the following guidelines for the release notes: If a connector has known issues, you will find it in the release notes even if the connector is not updated in the current release. If a connector …

Release Notes

Read the Data Integration Release Notes to learn about known limitations and third-party limitations for Data Integration. For limitations regarding a connector, see the connector release notes. For information about new features and enhancements, see What's New.

CDC, Mainframe, and Midrange Systems

Adabas CDC Connector Guide

Learn how to use the Adabas CDC Connector to retrieve Adabas change records from a PowerExchange change data capture (CDC) environment and write the changes to a supported target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC connections, mappings, and …

Adabas Connector Guide

Learn how to use the Adabas Connector to retrieve Adabas data from a PowerExchange environment and write the data in batch to a supported target. The connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure connections, mappings, and mapping tasks and to run and monitor mapping tasks.

Datacom CDC Connector

Learn how to use the Datacom CDC Connector to retrieve Datacom change records from a PowerExchange change data capture (CDC) environment and write the changes to a supported target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC connections, mappings, and …

Datacom Connector Guide

Learn how to use the Datacom Connector to retrieve Datacom data from a PowerExchange environment and write the data in bulk to a supported target. The connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure connections, mappings, and mapping tasks and to run and monitor mapping tasks.

Db2 Data Map Connector

Learn how to use the Db2 Data Map Connector to retrieve Db2 records from a PowerExchange environment and write the data to a supported target. The Db2 Data Map Connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure connections, mappings, and mapping tasks and to run and monitor …

Db2 for i CDC Connector

Learn how to use the Db2 for i CDC Connector to retrieve DB2 for i change records from a PowerExchange change data capture (CDC) environment and write the changes to a supported target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC connections, mappings, …

Db2 for i Connector

Learn how to use Db2 for i Connector to retrieve DB2 for i data from a PowerExchange environment and write the data to a supported target, including another Db2 for i system. The connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure connections, mappings, and mapping tasks and …

Db2 for LUW CDC Connector

Learn how to use the Db2 for LUW CDC Connector to retrieve DB2 for LUW change records from a PowerExchange change data capture (CDC) environment and write the changes to a supported target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC connections, …

Db2 for z/OS Bulk Load Connector

Learn how to use the Db2 for z/OS Bulk Unload Connector to retrieve data from a PowerExchange environment and write the data to a supported target. The Db2 for z/OS Bulk Unload connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure connections, mappings, and mapping tasks and to …

Db2 for z/OS CDC Connector

Learn how to use the Db2 for z/OS CDC Connector to retrieve DB2 for z/OS change records from a PowerExchange change data capture (CDC) environment and write the changes to a supported target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC connections, …

Db2 for z/OS Connector

Learn how to use the Db2 for z/OS Connector to retrieve data from a PowerExchange environment and write the data to a supported target. The Db2 for z/OS connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure connections, mappings, and mapping tasks and to run and monitor mapping tasks.

Db2 for z/OS Image Copy Connector

Learn how to use the Db2 for z/OS Image Copy Connector to retrieve data from a PowerExchange environment and write the data to a supported target. The Db2 for z/OS Image Copy connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure connections, mappings, and mapping tasks and to …

Db2 for z/OS Unload File Connector

Learn how to use the Db2 for z/OS Unload File Connector to retrieve data from a PowerExchange environment and write the data to a supported target. The Db2 for z/OS Unload File connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure connections, mappings, and mapping tasks and to …

IDMS CDC Connector

Learn how to use the IDMS CDC Connector to retrieve IDMS records from a PowerExchange environment and write the data to a supported target. The IDMS CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure connections, mappings, and mapping tasks and to run and monitor mapping tasks.

IDMS Connector

Learn how to use the IDMS Connector to retrieve IDMS records from a PowerExchange environment and write the data to a supported target. The IDMS connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure connections, mappings, and mapping tasks and to run and monitor mapping tasks.

IMS CDC Connector Guide

Learn how to use the IMS CDC Connector to retrieve IMS change records from a PowerExchange change data capture (CDC) environment and write the changes to a supported target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC connections, mappings, and mapping …

IMS Connector Guide

Learn how to use the IMS Connector to move IMS data from a PowerExchange environment and write the data to a supported target. The connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure connections, mappings, and mapping tasks and to run and monitor mapping tasks.

Microsoft SQL Server CDC Connector

Learn how to use the Microsoft SQL Server CDC Connector to retrieve Microsoft SQL Server change records from a PowerExchange change data capture (CDC) environment and write the changes to a supported target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC …

MySQL CDC Connector

Learn how to use the MySQL CDC Connector to retrieve MySQL change records from a PowerExchange change data capture (CDC) environment and write the changes to a Microsoft SQL Server or Oracle target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC …

Oracle CDC V2 Connector

Learn how to use the Oracle CDC V2 Connector to retrieve Oracle change records from a PowerExchange change data capture (CDC) environment and write the changes to a supported target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC connections, mappings, and …

PostgreSQL CDC Connector

Learn how to use PostgreSQL CDC Connector to retrieve PostgreSQL change records from a PowerExchange change data capture (CDC) environment and write the changes to a supported target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC connections, mappings, and …

SAP HANA CDC Connector

Learn how to use the SAP HANA CDC Connector to retrieve SAP HANA change records from a PowerExchange change data capture (CDC) environment and write the changes to a supported target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC connections, mappings, …

Sequential File Connector

Learn how to use the Sequential File Connector to retrieve sequential records from a PowerExchange environment and write the data to a supported target. The Sequential File Connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure connections, mappings, and mapping tasks and to run …

VSAM CDC Connector

Learn how to use the VSAM CDC Connector to retrieve VSAM change records from a PowerExchange CICS/VSAM change data capture (CDC) environment and write the changes to a supported target. The VSAM CDC Connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC connections, …

VSAM Connector

Learn how to use the VSAM Connector to retrieve VSAM records from a PowerExchange environment and write the data to a supported target. The VSAM connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure connections, mappings, and mapping tasks and to run and monitor mapping tasks.

Data Warehouse

Greenplum Connector

Use Greenplum Connector to learn how to read from or write to Greenplum by using Cloud Data Integration. Learn to create a connection, develop mappings, and run mapping tasks and dynamic mapping tasks in Cloud Data Integration.

Netezza Connector

Use Netezza Connector to learn how to read from or write to Netezza by using Cloud Data Integration. Learn to create a Netezza connection, develop mappings, and run mapping tasks and dynamic mapping tasks in Cloud Data Integration. You can also learn how to configure pushdown optimization to a Netezza database using a Netezza ODBC connection.

Teradata Connector

Use Teradata Connector to learn how to read from or write to Teradata by using Cloud Data Integration. Learn to create a Teradata connection, develop mappings, and run mapping tasks in Cloud Data Integration. You can also learn how to configure pushdown optimization to a Teradata database using a Teradata ODBC connection.

Ecosystem – Amazon

Amazon Athena Connector

Use Amazon Athena Connector to learn how to read from Amazon Athena by using Cloud Data Integration. Learn to create an Amazon Athena connection and develop and run mapping tasks and mappings in Cloud Data Integration.

Amazon Aurora Connector

Use Amazon Aurora Connector to learn how to read from or write to Amazon Aurora by using Cloud Data Integration. You can also learn to create an Amazon Aurora connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

Amazon DynamoDB V2 Connector

Use Amazon DynamoDB V2 Connector to learn how to read from or write to Amazon DynamoDB tables by using Cloud Data Integration. Learn to create an Amazon DynamoDB V2 connection, develop and run mappings, and mapping tasks in Cloud Data Integration.

Amazon Redshift Connectors

Use Amazon Redshift Connectors to learn about Amazon Redshift and Amazon Redshift V2 Connectors. Use Part I to know the overview and the functionality comparison between Amazon Redshift V2 and Amazon Redshift connectors. Use Part II and Part III to learn about the functionality available for Amazon Redshift Connectors.

Amazon S3 Connector

Use Amazon S3 Connector to learn how to read from or write to Amazon S3 by using Cloud Data Integration. Learn to create an Amazon S3 connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration. Use Amazon S3 Connector primarily for synchronization tasks.

Amazon S3 V2 Connector

Use Amazon S3 V2 Connector to learn how to read from or write to Amazon S3 by using Cloud Data Integration. Learn to create an Amazon S3 V2 connection, develop and run mappings, mapping tasks, dynamic mapping tasks, and data transfer tasks in Cloud Data Integration. Learn how to push down the transformation logic for processing …

Ecosystem – Azure

Microsoft Azure Blob Storage V2 Connector

Use Microsoft Azure Blob Storage V2 Connector to learn how to read from or write to Microsoft Azure Blob Storage by using Cloud Data Integration. Learn to create a Microsoft Azure Blob Storage V2 connection, develop and run mappings, mapping tasks, and mass ingestion tasks in Cloud Data Integration.

Microsoft Azure Blob Storage V3 Connector

Use Microsoft Azure Blob Storage V3 Connector to learn how to read from or write toMicrosoft Azure Blob Storage. Learn to create a connection, develop and run mappings, mapping tasks, and data transfer tasks in Data Integration.

Microsoft Azure Cosmos DB SQL API Connector

Use Microsoft Azure Cosmos DB SQL API Connector to learn how to read from or write to Microsoft Azure Cosmos DB SQL API. Learn to create a connection, develop and run mappings, mapping tasks, and data transfer tasks in Cloud Data Integration.

Microsoft Azure Data Lake Storage Gen1 V2 Connector

Use Microsoft Azure Data Lake Storage Gen1 V2 Connector to learn how to read from or write to Microsoft Azure Data Lake Storage Gen1 by using Cloud Data Integration. Learn to create a Microsoft Azure Data Lake Storage Gen1 V2 connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

Microsoft Azure Data Lake Storage Gen1 V3 Connector

Use Microsoft Azure Data Lake Storage Gen1 V3 Connector to learn how to read from or write to Microsoft Azure Data Lake Storage Gen1 by using Cloud Data Integration. Learn to create a Microsoft Azure Data Lake Storage Gen1 V3 connection, develop and run mappings and mapping tasks in Cloud Data Integration.

Microsoft Azure SQL Data Warehouse V2 Connector

Use Microsoft Azure SQL Data Warehouse V2 Connector to learn how to read from or write to Microsoft Azure SQL Data Warehouse by using Cloud Data Integration. Learn to create a connection, develop and run synchronization tasks, mappings, and mapping tasks. You can also learn how to configure pushdown optimization using an ODBC connection.

Microsoft Azure Synapse SQL Connector

Use Microsoft Azure Synapse SQL Connector to learn how to read from or write to Microsoft Azure Synapse SQL. Learn to create a connection, develop and run mappings, mapping tasks, dynamic mapping tasks, and data transfer tasks in Cloud Data Integration. Learn how to push down the transformation logic for processing to the …

Microsoft CDM Folders V2 Connector

Use Microsoft CDM Folders V2 Connector to learn how to read from or write toCDM folders on Microsoft Azure Data Lake Storage Gen2. Learn to create a connection, develop and run mappings, mapping tasks, and data transfer tasks in Data Integration.

Microsoft Azure Data Lake Storage Gen2 Connector

Use Microsoft Azure Data Lake Storage Gen2 Connector to learn how to read from or write to Microsoft Azure Data Lake Storage Gen2. Learn to create a connection, develop and run mappings, mapping tasks, dynamic mapping tasks, and data transfer tasks in Cloud Data Integration.

Ecosystem – Databricks

Databricks Delta Connector

Use Databricks Delta Connector to learn how to read from or write to Databricks Delta by using Cloud Data Integration. Learn to create a connection and develop mappings, mapping tasks, dynamic mapping tasks, and data transfer tasks in Cloud Data Integration.

Ecosystem – Google

Google Ads Connector

Use Google Ads Connector to learn how to read from Google Ads by using Cloud Data Integration. Learn to create a connection, develop mappings, and run mapping tasks in Cloud Data Integration.

Google Analytics Connector

Use Google Analytics Connector to learn how to read from or write to Google Analytics by using Cloud Data Integration. Learn to create a connection, develop mappings, and run synchronization and mapping tasks in Cloud Data Integration.

Google BigQuery Connectors

Use Google BigQuery Connectors to learn about Google BigQuery and Google BigQuery V2 Connectors. Use Part I to know the overview and the functionality comparison between Google BigQuery V2 and Google BigQuery connectors. Use Part II and Part III to learn about the functionality available for Google BigQuery connectors.

Google Bigtable Connector

Use Google Bigtable Connector to learn how to read from or write to Google Cloud Bigtable by using Cloud Data Integration. Learn to create a connection, develop mappings, and run mapping tasks in Cloud Data Integration.

Google Cloud Spanner Connector

Use Google Cloud Spanner Connector to learn how to read from or write to Google Cloud Spanner by using Cloud Data Integration. Learn to create a Google Cloud Spanner connection, develop and run mappings and mapping tasks in Cloud Data Integration.

Google Cloud Storage Connector

Use Google Cloud Storage Connector to learn how to read from or write to Google Cloud Storage by using Cloud Data Integration. Learn to create a connection, develop mappings, synchronization tasks, and run synchronization and mapping tasks in Cloud Data Integration.

Google Cloud Storage V2 Connector

Use Google Cloud Storage V2 Connector to learn how to read from or write to Google Cloud Storage by using Cloud Data Integration. Learn to create a connection, develop and run mappings, mapping tasks, dynamic mapping tasks, and data transfer tasks in Cloud Data Integration.

Google Drive Connector

Use Google Drive Connector to learn how to read from or write to Google Drive by using Cloud Data Integration. Learn to create a connection, develop mappings, synchronization tasks, and run Data Integration and mapping tasks in Cloud Data Integration.

Google PubSub Connector

Use Google PubSub Connector to learn how to pull message from or publish message to Google PubSub by using Cloud Data Integration. Learn to create a connection, develop mappings and run mapping tasks in Cloud Data Integration.

Google PubSub V2 Connector

Use Google PubSub V2 Connector to learn how to pull message from or publish message to Google PubSub by using Cloud Data Integration. Learn to create a connection, develop mappings and run mapping tasks in Cloud Data Integration.

Google Sheets Connector

Use Google Sheets Connector to learn how to read from or write to Google Sheets by using Cloud Data Integration. Learn to create a connection, develop mappings, synchronization tasks, and run synchronization and mapping tasks in Cloud Data Integration.

Google Sheets V2 Connector

Use Google Sheets V2 Connector to learn how to read from or write to Google Sheets by using Cloud Data Integration. Learn to create a connection, develop mappings, and run mapping tasks in Cloud Data Integration.

Ecosystem - Oracle Cloud Infrastructure

Oracle Cloud Object Storage Connector

Use Oracle Cloud Object Storage Connector to learn how to read from or write to Oracle Cloud Object Storage files by using Cloud Data Integration. Learn to create a Oracle Cloud Object Storage connection, run mappings and tasks in Cloud Data Integration.

Ecosystem – Snowflake

Snowflake Data Cloud Connector

Use Snowflake Data Cloud Connector to learn how to read from or write to Snowflake. Learn to create a connection, develop and run mappings, mapping tasks, dynamic mapping tasks,and data transfer tasks in Data Integration. Learn how to push down the transformation logic for processing to the Snowflake database.

Enterprise Application

Adobe Experience Platform Connector

Use Adobe Experience Platform Connector to learn how to read from or write to Adobe Experience Platform by using Cloud Data Integration. Learn to create an Adobe Experience Platform connection, develop and run mappings and mapping tasks in Cloud Data Integration.

Anaplan V2 Connector

Use Anaplan V2 Connector to learn how to read from or write to Anaplan by using Cloud Data Integration. Learn to create an Anaplan V2 connection and run synchronization tasks in Cloud Data Integration.

Ariba V2 Connector

Use Ariba V2 Connector to learn how to read from or write hierarchical data to Ariba by using Cloud Data Integration. Ariba V2 Connector integrates with Ariba using inbound SOAP web services and Ariba ITK support. Learn to create an Ariba V2 connection, develop and run mappings and mapping tasks in Cloud Data Integration.

Business 360 Connector

Use the Business 360 Connector to learn how to read from or write to Business 360 data store by using Cloud Data Integration. Learn to create a Business 360 connection, develop, and run mappings in Cloud Data Integration.

Business 360 Events Connector

Business 360 FEP Connector

Use the Business 360 FEP Connector to learn how to write data to Business 360 data store by using Cloud Data Integration. Learn to create a Business 360 FEP connection, develop, and run mappings in Cloud Data Integration.

CallidusCloud Commissions Connector

Use CallidusCloud Commissions Connector to learn how to read from or write to CallidusCloud Commissions by using Cloud Data Integration. Learn to create a CallidusCloud Commissions connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

CallidusCloud File Processor Connector

The Data Integration CallidusCloud File Processor Connector Guide contains information about how to set up and use CallidusCloud File Processor Connector. The guide explains how you can use CallidusCloud File Processor Connector to read data from and write data to CallidusCloud File Processor.

Cassandra V2 Connector

Use Cassandra V2 Connector to learn how to read from or write to Cassandra by using Data Integration. Learn to create a Cassandra connection, run mappings in advanced mode and tasks in Data Integration.

Chatter Connector

Use Chatter Connector to learn how to read from or write to Chatter by using Cloud Data Integration. Learn to create a Chatter connection and run synchronization tasks in Cloud Data Integration.

Concur V2 Connector

Use Concur V2 Connector to learn how to read from or write to Concur by using Cloud Data Integration. Learn to create a Concur V2 connection, develop mappings, and run mapping tasks in Cloud Data Integration.

Couchbase Connector

Use Couchbase Connector to learn how to read from or write to Couchbase by using Cloud Data Integration. Learn to create a connection, develop mappings, and run mapping tasks in Cloud Data Integration.

Coupa V2 Connector

Use Coupa V2 Connector to learn how to read from or write to Coupa by using Cloud Data Integration. Learn to create a Coupa V2 connection, develop and run mappings and mapping tasks in Cloud Data Integration.

Cvent Connector

Use Cvent Connector to learn how to read from Cvent by using Cloud Data Integration. Learn to create a connection, develop mappings, run synchronization and mapping tasks in Cloud Data Integration.

Domo Connector

Use Domo Connector to learn how to read from or write to Domo using Cloud Data Integration. Learn to create a Domo connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

Dropbox Connector

Use Dropbox Connector to learn how to read from or write to Dropbox by using Cloud Data Integration. Learn to create a Dropbox Connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

Elasticsearch Connector

Use Elasticsearch Connector to learn how to read from or write to Elasticsearch by using Data Integration. Learn to create an Elasticsearch connection, run mappings in advanced mode and tasks in Data Integration.

Eloqua Bulk API Connector

Use Eloqua Bulk API Connector to learn how to read from or write to the Eloqua application by using Cloud Data Integration. Learn to create a Eloqua Bulk API connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

Eloqua REST Connector

Use Eloqua REST Connector to learn how to read from or write to the Eloqua applications by using Cloud Data Integration. Learn to create a Eloqua REST connection, develop and run mappings, and mapping tasks in Cloud Data Integration.

Hadoop Files V2 Connector

Use the Hadoop Files V2 Connector to learn how to read from or write to Hadoop Distributed File System by using Cloud Data Integration. Learn to create a connection and develop and run mappings, mapping tasks, and dynamic mapping tasks in Cloud Data Integration.

Hive Connector

Use Hive Connector to learn how to read from or write to Hive by using Cloud Data Integration. Learn to create a connection, develop and run mappings, mapping tasks, and dynamic mapping tasks in Cloud Data Integration.

HubSpot Connector

Use HubSpot Connector to learn how to read from or write to HubSpot by using Cloud Data Integration. Learn to create a connection and develop and run mappings in Cloud Data Integration.

IBM MQ Connector

Use IBM MQ Connector to learn how to read or write to IBM MQ by using Data Integration. Learn to create an IBM MQ connection, develop, and run mappings and mapping tasks in Data Integration.

JD Edwards EnterpriseOne Connector

Use JD Edwards EnterpriseOne Connector to learn how to read from or write to JD Edwards EnterpriseOne by using Cloud Data Integration. Learn to create a connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

JIRA Cloud Connector

Use JIRA Cloud Connector to learn how to read from or write to the JIRA web service application by using Cloud Data Integration. Learn to create a connection, develop mappings, and run mapping tasks in Cloud Data Integration.

JIRA Connector

Use JIRA Connector to learn how to read from or write to JIRA by using Cloud Data Integration. Learn to create a connection and run synchronization and mapping tasks in Cloud Data Integration.

Kafka Connector

Use Kafka Connector to learn how to read from or write to Kafka by using Cloud Data Integration. Learn to create a connection, develop and run mappings, and mapping tasks in Cloud Data Integration.

LDAP Connector

Use LDAP Connector to learn how to read from or write to the LDAP directory server by using Cloud Data Integration. Learn to create a connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

Litmos Connector

Use Litmos Connector to learn how to read from or write to Litmos by using Cloud Data Integration. Learn to create a Litmos connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

Marketo V3 Connector

Use Marketo V3 Connector to learn how to read from or write to Marketo by using Cloud Data Integration. Learn to create a connection, develop mappings, and run synchronization and mapping tasks in Cloud Data Integration.

Microsoft Dynamics 365 for Operations Connector

Use Microsoft Dynamics 365 for Operations Connector to learn how to read from or write to Microsoft Dynamics 365 for Operations by using Cloud Data Integration. Learn to create a connection, develop mappings, and run synchronization and mapping tasks in Cloud Data Integration.

Microsoft Dynamics 365 for Sales Connector

Use Microsoft Dynamics 365 for Sales Connector to learn how to read from or write to Microsoft Dynamics 365 for Sales by using Cloud Data Integration. Learn to create a connection, develop mappings, and run synchronization and mapping tasks in Cloud Data Integration.

Microsoft Excel Connector

Use Microsoft Excel Connector to learn how to read from or write to Microsoft Excel by using Cloud Data Integration. Learn to create a connection, develop mappings, and run synchronization and mapping tasks in Cloud Data Integration.

Microsoft SharePoint Connector

Use Microsoft SharePoint Connector to learn how to read from or write to Microsoft SharePoint by using Cloud Data Integration. Learn to create a connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

Microsoft Sharepoint Online Connector

Updated

Use Microsoft Sharepoint Online Connector to learn how to read from or write to Microsoft Sharepoint Online by using Cloud Data Integration. Learn to create a connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

MongoDB V2 Connector

Use MongoDB V2 Connector to learn how to read from or write to MongoDB by using Data Integration. Learn to create a MongoDB V2 connection, run mappings in advanced mode and tasks in Data Integration.

MRI Software Connector

Use MRI Software Connector to learn how to read from MRI Software by using Cloud Data Integration. Learn to create an MRI Software connection, develop mappings, and run mapping tasks in Cloud Data Integration.

NetSuite Connector

Use NetSuite Connector to learn how to read from or write to NetSuite by using Cloud Data Integration. Learn to create a connection, develop mappings, and run synchronization and mapping tasks in Cloud Data Integration.

NICE Satmetrix Connector

Use NICE Satmetrix Connector to learn how to read from or write to Satmetrix. Learn to create a NICE Satmetrix connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

OData V2 Protocol Reader Connector

Use OData V2 Protocol Reader Connector to learn how to read from OData V2 applications by using Cloud Data Integration. Learn to create an OData V2 Protocol Reader connection, run mappings and mapping tasks in Cloud Data Integration.

OData V2 Protocol Writer Connector

Use OData V2 Protocol Writer Connector to learn how to write to OData V2 Applications by using Cloud Data Integration. Learn to create an OData V2 Protocol Writer connection, develop mappings, and run mapping tasks in Cloud Data Integration.

OpenAir Connector

Use Data Integration OpenAir Connector to learn how to set up and use OpenAir Connector. Learn to create an OpenAir connection and run synchronization tasks in Cloud Data Integration.

Oracle Business Intelligence Publisher V1 Connector

Use Oracle Business Intelligence Publisher V1 Connector to learn how to read data from Oracle Business Intelligence Publisher by using Cloud Data Integration. Learn to create an Oracle Business Intelligence Publisher V1 connection and develop and run mappings and mapping tasks in Cloud Data Integration.

Oracle CRM Cloud V1 Connector

Use Oracle CRM Cloud V1 Connector to learn how to read from or write to the Oracle CRM Cloud application by using Cloud Data Integration. Learn to create a connection, develop, and run mappings and mapping tasks in Cloud Data Integration.

Oracle CRM On Demand Connector

Use Data Integration Oracle CRM On Demand Connector to learn how to set up and use Oracle CRM On Demand Connector. Learn how you can use Oracle CRM On Demand Connector to read data from and write data to Oracle CRM On Demand applications.

Oracle E-Business Suite Connector

Use Oracle E-Business Suite Connector to learn how to read from or write to the Oracle E-Business Suite application by using Cloud Data Integration. Learn to create a connection, develop and run synchronization tasks, mappings and mapping tasks in Cloud Data Integration.

Oracle E-Business Suite Interface Connector

Use Oracle E-Business Suite Interface Connector to learn how to read from or write to the Oracle E-Business Suite application by using Cloud Data Integration. Learn to create a connection, develop and run synchronization tasks, mappings and mapping tasks in Cloud Data Integration.

Oracle Financials Cloud Connector

Use the Oracle Financials Cloud Connector to learn how to read from or write to the Oracle Financials Cloud application by using Cloud Data Integration. Learn to create a connection, develop and run mappings and mapping tasks in Cloud Data Integration.

Oracle Financials Cloud V1 Connector

Use Oracle Financials Cloud V1 Connector to learn how to read from or write to the Oracle Financials Cloud application by using Cloud Data Integration. Learn to create an Oracle Financials Cloud V1 connection, develop and run mappings and mapping tasks in Cloud Data Integration.

Oracle HCM Cloud V1 Connector

Use Oracle HCM Cloud V1 Connector to learn how to read from or write to Oracle HCM Cloud application by using Cloud Data Integration. Learn to create an Oracle HCM Cloud V1 connection, develop and run mappings and mapping tasks in Cloud Data Integration.

QuickBooks V2 Connector

Use Quickbooks V2 Connector to learn how to read from or write to Quickbooks by using Cloud Data Integration. Learn to create a Quickbooks V2 connection and run synchronization tasks in Cloud Data Integration.

Redis Connector

Use Redis Connector to learn how to read from or write to Redis by using Data Integration. Learn to create a Redis connection, run mappings in advanced mode and tasks in Data Integration.

Salesforce Analytics Connector

Use Salesforce Analytics Connector to learn how to write to Salesforce Analytics by using Cloud Data Integration. Learn to create a Salesforce Analytics connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

Salesforce Connector

Use Salesforce Connector to learn how to read from or write to Salesforce. Learn to create a Salesforce connection, develop and run synchronization tasks, mappings, mapping tasks, replication tasks, masking tasks, dynamic mapping tasks, and data transfer tasks in Cloud Data Integration.

Salesforce Marketing Cloud Connector

Use Salesforce Marketing Cloud Connector to learn how to read from or write to Salesforce Marketing Cloud by using Cloud Data Integration. Learn to create a Salesforce Marketing Cloud connection and run synchronization tasks in Cloud Data Integration.

SAP BW BEx Query Connector

Use SAP BW BEx Query Connector to learn how to read from SAP BEx queries by using Cloud Data Integration. Learn to create an SAP BW BEx Query connection, develop and run mappings and tasks in Cloud Data Integration.

SAP Connector

Use SAP Connector to learn how to read from or write to SAP by using Cloud Data Integration. Learn to create an SAP connection, develop and run synchronization tasks, mappings, mapping tasks, and data transfer tasks in Cloud Data Integration.

SAP HANA Connector

Use SAP HANA Connector to learn how to read from or write data to SAP HANA database by using Cloud Data Integration. Learn to create an SAP HANA connection, develop mappings, and run mapping tasks and data transfer tasks in Cloud Data Integration.

SAS Connector

Use the SAS Connector to learn how to read from or write to SAS by using Cloud Data Integration. Learn to create a SAS connection and develop and run mappings and mapping tasks in Cloud Data Integration.

Satmetrix Connector

Use Satmetrix Connector to learn how to read from or write to Satmetrix by using Cloud Data Integration. Learn to create a Satmetrix connection and run synchronization tasks in Cloud Data Integration.

ServiceNow Connector

Use ServiceNow Connector to learn how to read from or write to ServiceNow by using Cloud Data Integration. Learn to create a ServiceNow connection, develop mappings, and run synchronization andmapping tasks in Cloud Data Integration.

SuccessFactors LMS Connector

Use Data Integration SuccessFactors LMS Connector to learn how to set up and use SuccessFactors LMS Connector. Learn how organization administrators and business users can use SuccessFactors LMS Connector to read data from SuccessFactors LMS Connector.

SuccessFactors ODATA Connector

Use Data Integration SuccessFactors ODATA Connectorto learn how to read data from or write data to SuccessFactors by using Cloud Data Integration. Learn to create a SuccessFactors ODATA connection, develop mappings, and run mapping tasks, synchronization tasks, and dynamic mapping tasks in Cloud Data Integration.

Tableau V3 Connector

Use Tableau V3 Connector to learn how to read from or write to Tableau by using Cloud Data Integration. Learn to create a connection, develop, and run mappings and mapping tasks in Cloud Data Integration.

UKGPro Connector

Use UKGPro Connector to learn how to read from UKGPro by using Cloud Data Integration. Learn to create an UKGPro connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

UKGPro V2 Connector

Use UKGPro V2 Connector to learn how to read from UKGPro. Learn to create an UKGPro V2 connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

UltiPro Connector

Use UltiPro Connector to learn how to read from UltiPro by using Cloud Data Integration. Learn to create an UltiPro connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

Workday V2 Connector

Use Workday V2 Connector to learn how to configure a Source transformation, Target transformation, or midstream in a Web Services transformation to connect to Workday from Data Integration and interact with the Workday service to perform operations on non-relational hierarchical data. Learn to create an Workday V2 connection, …

Xactly Connector

Use Xactly Connector to learn how to read from or write to Xactly by using Cloud Data Integration. Learn to create an Xactly connection and run synchronization tasks in Cloud Data Integration..

XML Source Connector

Use XML Source Connector to learn how to read from an XML Source by using Cloud Data Integration. Learn to create an XML Source connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

XML Target Connector

Use XML Target Connector to learn how to write to an XML Target by using Cloud Data Integration. Learn to create an XML Target connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

Yellowbrick Data Warehouse Connector

Use Yellowbrick Data Warehouse Connector to learn how to read from or write to Yellowbrick Data Warehouse by using Cloud Data Integration. Learn to create a Yellowbrick Data Warehouse connection, develop and run mappings, and mapping tasks.

Zendesk V2 Connector

Use Zendesk V2 Connector to learn how to read from or write toZendesk by using Data Integration. Learn to create a connection, develop mappings, synchronization tasks, and run synchronization andmapping tasks in Data Integration.

Zuora AQuA Connector

Use Zuora AQuA Connector to read from or write to Zuora by using Cloud Data Integration. You can create a connection, develop mappings, synchronization tasks, and run synchronization and mapping tasks in Cloud Data Integration.

Zuora Multi-Entity Connector

Use Zuora Multi-Entity Connector to learn how to read from or write to Zuora by using Cloud Data Integration. Learn to create a connection, develop mappings, synchronization tasks, and run synchronization and mapping tasks in Cloud Data Integration.

Zuora REST V2 Connector

Use Zuora REST V2 Connector to learn how to read from or write to Zuora by using Cloud Data Integration. Learn to create a connection, develop mappings, synchronization tasks, and run synchronization and mapping tasks in Cloud Data Integration.

File System

File List Connector

Use File List Connector to learn how to read from fixed-width file or write to fixed-width file by using Cloud Data Integration. Use File List Connector to read multiple delimited files. Learn to create a File List connection and run synchronization tasks in Cloud Data Integration.

File Processor Connector

Use File Processor Connector to learn how to read from or write to File Processor by using Cloud Data Integration. Learn how organization administrators and business users can use File Processor Connector to transfer files.

FileIo Connector

Use FileIo Connector to learn how to export Salesforce attachments to a file system and upload files from a local system to Salesforce by using Cloud Data Integration. Learn to create a FileIo connection and run synchronization tasks in Cloud Data Integration.

Relational

DB2 Loader Connector

Use DB2 Loader Connector to learn how to write to DB2 database by using Data Integration. Learn to create a DB2 Loader connection, develop, and run mappings and mapping tasks in Data Integration.

Db2 Warehouse on Cloud Connector

Use Db2 Warehouse on Cloud Connector to learn how to read from or write to Db2 Warehouse on Cloud by using Cloud Data Integration. Learn to create a Db2 Warehouse on Cloud connection, develop mappings, and run mapping, dynamic mapping, and data transfer tasks in Cloud Data Integration.

JDBC Connector

Use JDBC Connector to learn how to read from or write to databases with a JDBC type 4 driver by using Cloud Data Integration. Learn to create a connection, develop mappings, and run synchronization, mapping, and data transfer tasks in Data Integration.

JDBC V2 Connector

Use JDBC V2 Connector to learn how to use the JDBC V2 connection to read from or write to Aurora PostgreSQL and other databases that support the Type 4 JDBC driver by using Data Integration. Learn to create a connection, develop and run mappings, mapping tasks, dynamic mapping tasks, and data transfer tasks in Data Integration.

Microsoft Access Connector

Use Microsoft Access Connector to learn how to read from or write to Microsoft Access by using Cloud Data Integration. Learn to create a connection and run synchronization tasks in Cloud Data Integration.

Microsoft SQL Server Connector

Use Microsoft SQL Server Connector to learn how to read from or write toMicrosoft SQL Server by using Cloud Data Integration. Learn to create a connection, develop mappings, and run synchronization,mapping, dynamic mapping, replication, and data transfer tasks. You can also learn how to configure pushdown optimization and …

MySQL Connector

Use MySQL Connector to learn how to read from or write toMySQL databases by using Cloud Data Integration. Learn to create a MySQL connection, develop mappings, and run synchronization,mapping, dynamic mapping, replication, and data transfer tasks in Cloud Data Integration.

ODBC Connector

Use ODBC Connector to learn how to read from or write toODBC-compliant databases. Learn to create an ODBC connection, develop mappings, and run mapping, synchronization, and data transfer tasks. Learn how to configure pushdown optimization, cross-schema pushdown optimization, and cross-database pushdown optimization using an ODBC connection.

Oracle Connector

Use Oracle Connector to learn how to read from or write to Oracle by using Cloud Data Integration. Learn to create an Oracle connection, develop mappings, and run synchronization,mapping, dynamic mapping, replication,and data transfer tasks in Data Integration. You can also learn how to configure pushdown optimization and …

PostgreSQL Connector

Use PostgreSQL Connector to learn how to read from or write to PostgreSQL by using Cloud Data Integration. Learn to create a PostgreSQL connection, develop mappings, and run mapping, dynamic mapping, and data transfer tasks in Data Integration. You can also learn how to configure pushdown optimization using an ODBC connection.

SAP IQ Connector

Use SAP IQ Connector to learn how to write to SAP IQ database by using Cloud Data Integration. Learn to create an SAP IQ connection, develop mappings, and run mapping tasks.

SingleStore Connector

Use SingleStore Connector to learn how to read from or write to SingleStore by using Cloud Data Integration. You can also learn to create a SingleStore connection, develop and run synchronization tasks, mappings, and mapping tasks in Cloud Data Integration.

Web

JSON Target Connector

Use JSON Target Connector to learn how to read from or write to a REST based web service application by using Cloud Data Integration. Learn to create a connection and run synchronization tasks in Cloud Data Integration.

OData Connector

Use OData Connector to learn how to read from or write to an OData service by using Cloud Data Integration. Learn to create an OData connection, develop mappings, and run mapping and synchronization tasks in Cloud Data Integration.

REST V2 Connector

Use REST V2 Connector to learn how to read from or write to a web service that supports REST API by using Data Integration. Learn to create a REST V2 connection, develop and run mappings and mapping tasks in Data Integration.

Web Service Consumer Connector

Use Web Service Consumer Connector to learn how to read from or write to a web Service that supports SOAP API. Learn to create a connection, develop mappings, and run mapping tasks using Cloud Data Integration.

Updated

What's New in Databricks Delta Connector - July 2023

Learn about the new features and enhancements in the July 2023 release of the Databricks Delta Connector.

Updated

What's New in Google BigQuery V2 Connector - July 2023

Learn about the new features and enhancements in the July 2023 release of the Google BigQuery V2 Connector.

Updated

What's New in Microsoft Azure Synapse SQL Connector - July 2023

Learn about the new features and enhancements in the July 2023 release of the Microsoft Azure Synapse SQL Connector.

Updated

What's New in Snowflake Data Cloud Connector - July 2023

Learn about the new features and enhancements in the July 2023 release of the Snowflake Data Cloud Connector.

What's New in Snowflake Data Cloud Connector: April 2023

Learn about the enhancements and changes from January-April 2023 for the Snowflake Data Cloud Connector.

Writing Struct Data to Amazon DynamoDB V2

Learn how to use an Amazon DynamoDB V2 connection to write data of the struct type to an Amazon DynamoDB V2 target.

Creating an Amazon Redshift V2 Connection

Learn how to create an Amazon Redshift V2 connection in Administrator. You can use the connection in a Cloud Data Integration mapping to read data from and write data to Redshift.

Creating an Amazon S3 V2 Connection

Learn how to create an Amazon S3 V2 connection in Administrator. You can use the connection in a Cloud Data Integration mapping to read data from and write data to Amazon S3.

Creating an AWS RDS MySQL Connection

Learn how to create an Amazon Web Services (AWS) RDS MySQL connection.

Optimizing Cloud Data Warehouse Mapping Performance

Learn how to optimize mapping performance when you load data to a cloud data warehouse.

Optimizing Ecosystem Mapping Performance

Learn how to optimize ecosystem mapping performance using pushdown optimization (PDO).

Creating a Google BigQuery Connection

Learn how to create an ODBC connection to a Google BigQuery source.

Creating a Google BigQuery ODBC Mapping

Learn how to create a Google BigQuery mapping to calculate sales data over a period of time.

Creating a Google BigQuery V2 Connection

Learn how to create a Google BigQuery V2 connection in Administrator. You can use the connection in a Cloud Data Integration mapping to read data from and write data to Google BigQuery tables.

Creating an Optimized Google BigQuery Mapping Task

Learn how to create an optimized Google BigQuery mapping task.

Creating a Google Cloud Storage V2 Connection

Learn how to create a Google Cloud Storage V2 connection in Administrator. You can use the connection in a Cloud Data Integration mapping to read data from or write data to Google Cloud Storage files.

Creating a Kafka Connection

Learn how to create a Kafka connection in Administrator.

Creating a Microsoft Azure Data Lake Storage Gen2 Connection

Learn how to configure a Microsoft ADLS Gen2 connection.

Creating a Microsoft Azure Data Lake Storage Gen2 Elastic Mapping

Learn how to create an elastic mapping with a Microsoft Azure Data Lake Storage Gen2 connector.

Creating a Microsoft Azure Synapse SQL Connection

Learn how to configure a Microsoft Azure Synapse SQL connection.

Connecting to Microsoft SQL Server Hosted on Amazon Web Services

Learn how to create a Microsoft SQL Server connection in Administrator to connect to a SQL Server database hosted on AWS. You can use the connection in a Cloud Data Integration mapping to read data from and write data to SQL Server databases hosted on AWS.

Creating a Microsoft SQL Server Connection

Learn how to create a Microsoft SQL Server connection in Administrator. You can use the connection in a Microsoft SQL Server mapping to read data from or write data to SQL Server.

New

Writing Struct Data to MongoDB

Learn how to use a MongoDB V2 connector to create and run a mapping in advanced mode that writes struct data to a MongoDB V2 target.

Creating a MySQL Connection

Learn how to create a MySQL connection in Informatica Administrator.

Creating an Oracle Connection

Learn how to create an Oracle database connection in Administrator. You can use the connection in a Cloud Data Integration mapping to read data from and write data to Oracle.

Overview of Pushdown Optimization (PDO)

Learn about the features and benefits of pushdown optimization.

Creating a REST V2 Connection

Learn how to create a REST V2 connection in Administrator to access a Box endpoint. You can use the connection in a Cloud Data Integration mapping to read and write data to the Box web services application.

Creating a Salesforce Connection

Learn how to create a Salesforce connection in Administrator, and the two authentication methods you can use to connect to Salesforce. You can use the connection in a Cloud Data Integration mapping to read data from and write data to Salesforce.

Loading SAP Ariba Data to Flat File Targets

Learn how to create an SAP Ariba connection and then map the Ariba source to flat file targets.

Loading ServiceNow Data to Flat File Targets

Learn how to load ServiceNow source data to flat file targets.

Creating a Snowflake V2 Connection

Learn how to configure a Snowflake Cloud Data Warehouse V2 connection using the Standard, KeyPair, and Authorization Code authentication methods.

Optimizing Snowflake Mapping Performance

Learn how to configure pushdown optimization and optimize the Snowflake mapping performance.

Optimizing Mapping Performance from Type 2 SCD Tables to Snowflake

Learn how to optimize mapping performance when you load data from Type 2 Slowly Changing Dimension tables to Snowflake.

How to Configure the SAP Secure Network Communication Protocol in Informatica Cloud Data Integration®

Updated

Secure Network Communication (SNC) is a software layer in the SAP system architecture that integrates third-party security products with SAP. Using the SNC protocol, you can secure communications between SAP and an external system. This article describes how to configure the SNC protocol to secure communications between Cloud Data Integration and SAP.

Ecosystem – Amazon

Amazon Redshift Connector Best Practices

This article contains information about how to configure Amazon Redshift Connector, PowerExchange for Amazon Redshift, and PowerExchange for Amazon Redshift for PowerCenter to get the best performance and efficiency. This document captures the concepts, best practices, and recommendations for tuning Informatica Cloud, Big Data …

Configure single sign-on to Amazon S3 in Informatica Cloud Data Integration

You can configure single sign-on (SSO) to Amazon S3 with corporate credentials in Cloud Data Integration. SSO provides you with a single point of authentication and an enhanced security to access an Amazon Web Services (AWS) environment.

Configure VPC peering between the Amazon Redshift cluster and the serverless runtime environment

This article describes how you can configure VPC peering between the Amazon Redshift cluster and the serverless runtime environment.

Configuring AssumeRole Authentication for Amazon Redshift V2 Connector

You can use the IAM AssumeRole authentication to access Amazon Redshift V2 resources. You can configure the Redshift IAM role ARN with an IAM user or define an EC2 instance to assume a role. This article describes the guidelines to configure Redshift IAM Authentication using AssumeRole to connect to Redshift using Redshift V2 Connector.

Configuring AWS IAM Authentication for Amazon Redshift and Amazon Redshift V2 Connectors

You can use AWS Identity and Access Management (IAM) to control individual and group access to Amazon Redshift resources. You can configure AWS IAM to run tasks on the Secure Agent that is installed on the EC2 system. This article describes the guidelines to configure IAM Authentication for Amazon Redshift and Amazon Redshift V2 Connectors.

Configuring AWS KMS Customer Master Key to Encrypt Files in Amazon S3

You can enable client-side or server-side encryption to encrypt data inserted in Amazon S3 buckets to protect data. You can generate a customer master key in AWS Key Management Service (AWS KMS) and configure the key in Amazon S3 connection properties to encrypt data. This article describes the guidelines and steps to configure AWS KMS …

Configuring IAM Authentication for Amazon S3 and Amazon S3 V2 Connectors

You can use AWS Identity and Access Management (IAM) to control individual and group access to Amazon S3 resources. You can configure AWS IAM to run tasks on the Secure Agent that is installed on the EC2 system. This article describes the guidelines to configure IAM Authentication for Amazon S3 and Amazon S3 V2 Connectors.

Configuring Informatica Encryption for Elastic Mappings in Amazon S3 V2 Connector

This article describes how you can configure Informatica encryption for elastic mappings in Amazon S3 V2 Connector.

Configuring Informatica Encryption for Mappings in Advanced Mode in Amazon S3 V2 Connector

This article describes how you can configure Informatica encryption for mappings in advanced mode in Amazon S3 V2 Connector.

Configuring private communication with Amazon Redshift using the Amazon Redshift V2 Connector

This article describes how you can configure private communication to connect to Amazon Redshift using the Amazon Redshift V2 Connector.

Configuring private communication with Amazon S3 using the Amazon S3 V2 Connector

This article describes how you can configure private communication to connect to Amazon S3 using the Amazon S3 V2 Connector.

Configuring pushdown optimization for Amazon Redshift using the ODBC Connector

This article explains how to configure pushdown optimization for a mapping that uses the ODBC connection type to read from or write to Amazon Redshift. This article also explains the pushdown optimization functions, transformations, operators, and data types that you can push down to Amazon Redshift using the Amazon Redshift ODBC connection type.

Frequently Asked Questions for Amazon S3 V2 Connector

You can use Amazon S3 V2 Connector to read from or write Avro and Parquet files to Amazon S3. This article lists the frequently asked questions about using Amazon S3 V2 Connector to read data from or write data to Amazon S3.

Implementing the upsert operation using Amazon Redshift V2 Connector

This article discusses the solutions to use the upsert operation with Amazon Redshift V2 Connector from Cloud Data Integration.

Performance Tuning and Sizing Guidelines for Amazon Redshift Connector

When you use Amazon Redshift Connector, multiple factors such as data set size, hardware parameters, and mapping parameters, impact the connector performance. You can optimize the performance by analyzing your data set size, using the recommended hardware, and tuning these parameters appropriately. This article describes general …

Reading a JSON File Using an Amazon S3 V2 Connector

You can use Amazon S3 V2 Connector to read a JSON file through a binary port. To read a JSON file, you must use the Hierarchy Parser and Java transformations in the Amazon S3 V2 mapping. Adding the transformations enable the Secure Agent to convert the data of the binary format to the string format. This article explains how to create …

Using Amazon Redshift Serverless with Cloud Data Integration

This article describes how you can use Amazon Redshift Serverless with Cloud Data Integration.

Using an assume role for Amazon S3 resources in Informatica Cloud Data Integration

You can assume an IAM (Identity and Access Management) role in Amazon S3 resources to generate temporary security credentials. The temporary security credentials give you limited access to Amazon resources for a certain period. You can use the IAM role in Amazon Redshift V2 Connector and Amazon S3 V2 Connector to access Amazon S3 …

Writing to and reading from AWS Lake Formation using Amazon S3 V2 and Amazon Athena connectors

This article describes how you can write to and read from AWS Lake Formation using Amazon S3 V2 and Amazon Athena connectors.

Ecosystem – Azure

Configuring Azure Active Directory Authentication for Microsoft Azure SQL Data Warehouse Connector

This article explains how to configure Azure Active Directory (AAD) authentication when you use Microsoft Azure SQL Data Warehouse Connector to connect to Microsoft Azure SQL Data Warehouse. By default, the Microsoft Azure SQL Data Warehouse connection uses Microsoft SQL Server authentication.

Configuring Azure Virtual Network for Microsoft Azure Synapse SQL

You can use a Microsoft Azure Synapse SQL connection to connect to a Microsoft Azure Synapse SQL endpoint that resides in the Azure Virtual Network. This article explains how to configure a virtual network to create a secure and scalable, on-demand Azure infrastructure on Azure cloud.

Configuring pushdown optimization for Microsoft Azure Synapse SQL using ODBC Connector

This article explains how to configure pushdown optimization for a mapping that uses the ODBC connection type to read from or write to Microsoft Azure Synapse SQL. This article also explains the pushdown optimization functions, transformations, and operators that you can push down to Microsoft Azure Synapse SQL using the Microsoft Azure …

Connecting to an Azure storage account using an Azure private endpoint

You can use an Azure private endpoint to securely and privately connect to your Azure storage account on a virtual network. This article explains how to configure an Azure private endpoint in the Azure portal.

Connecting to Microsoft Azure Synapse SQL using an Azure private endpoint

You can use an Azure private endpoint to securely and privately connect to your Microsoft Azure Synapse SQL account on a virtual network. This article explains how to configure an Azure private endpoint in the Azure portal.

Converting Hierarchical Input to Flat Output using Microsoft Azure Cosmos DB SQL API Connector

When you use Microsoft Azure Cosmos DB SQL API Connector to perform extensive query operations on data, you can use the Hierarchical Parser transformation to convert hierarchical input into flat output. The transformation processes XML or JSON input from the upstream transformation and provides flat output to the downstream …

Converting Hierarchical Input to Relational Output using Microsoft Azure Cosmos DB SQL API Connector

When you use Microsoft Azure Cosmos DB SQL API Connector to perform extensive query operations on data, you can use the Hierarchical Parser transformation to convert hierarchical input into relational output. The transformation processes XML or JSON input from the upstream transformation and provides relational output to the downstream …

Converting Relational Input into Hierarchical Output using Microsoft Azure Cosmos DB SQL API Connector

When you want to read data from a relational source and write data to Microsoft Azure Cosmos DB SQL API, you can use the Hierarchical Builder transformation to convert relational input into hierarchical output. The transformation processes a relational input from the upstream transformation and provides JSON output to the downstream …

Converting relational input into hierarchical output using Microsoft Azure Data Lake Storage Gen2 Connector

When you want to read data from a relational source and write data to Microsoft Azure Data Lake Storage Gen2, you can use the Hierarchy Builder transformation to convert relational input into hierarchical output. The transformation processes a relational input from the upstream transformation and provides JSON output to the downstream …

Performance Tuning and Sizing Guidelines for Microsoft Azure Synapse SQL Connector

You can tune the hardware parameters, database parameters, application server parameters, and Informatica mapping parameters to optimize the performance of Microsoft Azure Synapse SQL Connector. This article describes general reference guidelines, best practices, and case studies to help you tune the performance of Microsoft Azure …

Performance Tuning Guidelines for Full Pushdown Optimization for Microsoft Azure SQL Data Warehouse Connector

You can use pushdown optimization to push transformation logic to source databases or target databases. Use pushdown optimization to improve task performance by using the database resources. When you run a task configured for pushdown optimization, the task converts the transformation logic to an SQL query. The task sends the query to …

Performance tuning guidelines for Microsoft Azure Cosmos DB SQL API Connector

You can tune the Informatica mapping parameters to optimize the performance of Microsoft Azure Cosmos DB SQL API Connector. This article describes general reference guidelines to help you tune the performance of Microsoft Azure Cosmos DB SQL API Connector.

Performance Tuning Guidelines for Microsoft Azure Data Lake Storage Gen2 Connector

You can use Microsoft Azure Data Lake Storage Gen2 Connector to read from or write to Microsoft Azure Data Lake Storage Gen2. This article describes general reference guidelines to help you tune the performance of Microsoft Azure Data lake Storage Gen2 Connector in Cloud Data Integration. It also describes the best practices and case …

Prerequisites to create a Microsoft Azure Blob Storage V3 connection

You can use Microsoft Azure Blob Storage V3 Connector to connect to Microsoft Azure Blob Storage from Cloud Data Integration. This article explains the prerequisite tasks that you must complete before you create a Microsoft Azure Blob Storage V3 connection.

Prerequisites to Create a Microsoft Azure Data Lake Storage Gen2 Connection

You can use Microsoft Azure Data Lake Storage Gen2 Connector to connect to Microsoft Azure Data Lake Storage Gen2 from Cloud Data Integration. This article explains the prerequisite tasks that you must complete before you create a Microsoft Azure Data Lake Storage Gen2 Connection.

Prerequisites to create a Microsoft Azure Synapse SQL connection

You can use Microsoft Azure Synapse SQL Connector to connect to Microsoft Azure Synapse SQL from Cloud Data Integration. This article explains the prerequisite tasks that you must complete before you create a Microsoft Azure Synapse SQL connection.

Ecosystem – Databricks

Performance Tuning Guidelines for Databricks Delta Connector

You can use Databricks Delta Connector to connect to Databricks Delta Lake. This article describes general reference guidelines to help you tune the performance of Databricks Delta Connector in Cloud Data Integration. It also describes the best practices required when you run a mass ingestion task to transfer tables from a Databricks Delta …

Ecosystem – Google

Configuring Pushdown Optimization by Using Google BigQuery ODBC Driver

You can use pushdown optimization to push transformation logic to source databases or target databases. Use pushdown optimization when you use database resources to improve the performance of the task. When you run a task configured for pushdown optimization, the task converts the transformation logic to an SQL query. The task sends …

Frequently Asked Questions for Google BigQuery Connector

This article describes frequently asked questions about using Google BigQuery V2 Connector to read data from and write data to Google BigQuery.

Frequently Asked Questions for Google BigQuery V2 Connector

This article describes frequently asked questions about using Google BigQuery Connector to read data from and write data to Google BigQuery.

Informatica Cloud® Google Cloud Storage Connector Frequently Asked Questions

This article describes frequently asked questions about using Google Cloud Storage Connector to read data from and write data to Google BigQuery.

Performance tuning and best practices for Google BigQuery V2 Connector

When you use Google BigQuery V2 Connector to read data from or write data to Google BigQuery, multiple factors such as hardware, Google Compute Engine, Secure Agent, and Informatica mapping parameters impact the connector performance. You can optimize the performance by tuning these parameters appropriately. This article describes …

Performance Tuning and Sizing Guidelines for Google Cloud Spanner Connector

When you use Google Cloud Spanner Connector, multiple factors such as hardware, Secure Agent tuning parameters, bulk read, and batch size impact the connector performance. You can optimize the performance by using the recommended hardware and tuning these parameters appropriately. This article describes general reference guidelines to …

Performance tuning guidelines for pushdown optimization using Google BigQuery V2 Connector

You can configure pushdown optimization in a mapping that reads from or writes to Google BigQuery. This article describes the various pushdown scenarios that you can configure to optimize the performance of Google BigQuery V2 Connector.

Ecosystem – Snowflake

Configuring Okta for Snowflake Data Cloud Connector to access Snowflake

This article provides instructions on how to authenticate to Snowflake using an external OAuth such as Okta in Snowflake Data Cloud Connector from Cloud Data Integration.

Configuring pushdown optimization for Snowflake using the ODBC Connector

This article explains how to configure pushdown optimization for a mapping that uses the ODBC connection type to read from or write to Snowflake. This article also explains the pushdown optimization functions, transformations, operators, and data types that you can push down to Snowflake using the Snowflake ODBC connection type.

Performance Tuning and Best Practices for Snowflake Data Cloud Connector

When you use Snowflake Connector to read data from or write data to Snowflake, multiple factors such as hardware, database, Amazon EC2, Secure Agent, and Informatica mapping parameters impact the connector performance. You can optimize the performance by tuning these parameters appropriately. This article describes general reference …

Performance tuning guidelines for pushdown optimization using Snowflake Data Cloud Connector

You can configure pushdown optimization in a mapping that reads from or writes to Snowflake. This article describes the various pushdown scenarios that you can configure to optimize the performance of Snowflake Cloud Data Warehouse V2 Connector.

Writing data to Snowflake external tables

This article provides instructions on how to write data to external tables in Snowflake from Cloud Data Integration.

Enterprise Application

Configuring a secure connection to the SAP HANA server from Cloud Data Integration

You can use the SSL protocol to configure a secure connection to the SAP HANA server from Cloud Data Integration. This article describes how to configure the Secure Agent for SSL communication with an SAP HANA server.

Configuring a Web Services Transformation in Informatica Cloud Data Integration to Read Data from an SAP BW BEx Query

In Data Integration, you can configure a Web Service transformation that calls the SAP BW BEx Query web service from a mapping task. This article describes the steps to create a Web Service transformation, configure an SAP BW BEx Query business service in the transformation, and connect to the SAP BW BEx Query web service to read data.

Configuring the Simba MongoDB JDBC Driver Options for MongoDB Connector

MongoDB Connector uses the Simba MongoDB JDBC driver to connect to MongoDB. This article provides detailed information about the MongoDB JDBC driver options that you can configure in a MongoDB connection in Data Integration.

Connecting to MongoDB Atlas Database from Cloud Data Integration

MongoDB Connector uses the Simba MongoDB JDBC driver to connect to MongoDB Atlas. This article provides detailed information about the MongoDB Connection properties that you can configure in a MongoDB connection to connect to MongoDB Atlas database using Cloud Data Integration.

Converting Relational Input into Hierarchical Output using Kafka Connector

When you want to read data from a relational source and write data to Apache Kafka, you can use the Hierarchical Builder transformation to convert relational input into hierarchical output. This article describes how to use the Hierarchical Builder transformation with Kafka Connector to convert relational input into hierarchical output.

Frequently Asked Questions for Cloud Data Integration Kafka Connector

This article describes frequently asked questions about using Kafka Connector to read data from and write to Kafka topics.

How to Configure SAP BAPI Connector as a Business Service in Cloud Data Integration

You can configure SAP BAPI Connector as a business service within a mapping or a mapping task for SAP BAPI data integration. To configure SAP BAPI Connector as a business service, you must associate an SAP BAPI connection with the business service, and add the required BAPI operation for the business service. This article describes how …

Performance Tuning Guidelines for MongoDB Connector in Informatica Cloud Data Integration

When you use MongoDB Connector to read data from or write data to MongoDB, you can optimize the performance by tuning the mapping parameters appropriately. This article describes general reference guidelines to help you tune the performance of MongoDB Connector in Cloud Data Integration.

Performance Tuning Guidelines for SAP Table Reader Connector

When you use SAP Table Reader Connector, factors such as packet size and heap size impact the connector performance. You can optimize the performance by tuning these parameters appropriately. This article describes general reference guidelines to help you tune the performance of SAP Table Reader Connector.

Performance Tuning Guidelines for ServiceNow Connector in Informatica Cloud Data Integration

When you use ServiceNow Connector to read data from or write data to ServiceNow, you can optimize the performance by tuning the mapping parameters appropriately. This article describes general reference guidelines to help you tune the performance of ServiceNow Connector in Cloud Data Integration.

Preparing to Use Microsoft Sharepoint Online Connector

You can use Microsoft Sharepoint Online Connector to read data from or write data to Microsoft Sharepoint Online. To use the connector, you must complete certain prerequisite tasks. This article explains the prerequisite tasks that you must complete before you use Microsoft Sharepoint Online Connector.

Transferring data between Kafka topics and MongoDB collections in Cloud Data Integration

This article provides detailed information on how you can configure a mapping to transfer data between Kafka topics and MongoDB collections in Data Integration.

Using Workday V2 Connector in a Process to Get Employee Details from Workday

This article describes how to use Workday V2 Connector to connect to Workday from Informatica Cloud Application Integration and get employee details.

Relational

Configuring SSL for MySQL Connector in Cloud Data Integration

To establish SSL communication for MySQL Connector, you must install the MySQL JDBC and ODBC drivers, version 8.0.12 on the Secure Agent machine. This article explains how to install the MySQL JDBC and ODBC drivers on Windows or Linux systems and configure SSL for a MySQL connection.

Configuring the Oracle Advanced Security Options in an Oracle Connection in Cloud Data Integration

This article describes how to configure the advanced security options for Oracle Connector in Cloud Data Integration to connect to an Oracle database enabled with advanced security encryption.

Connecting to Oracle Database Cloud Service from Cloud Data Integration

You can configure an Oracle connection to connect to Oracle Database Cloud Service from Cloud Data Integration®. This article describes how to configure Oracle connectivity to Oracle Database Cloud Service.

Installing the JDBC and ODBC Drivers for MySQL Connector

To establish a MySQL connection, you must install the JDBC and ODBC drivers on your system. This article explains how to install the JDBC and ODBC drivers based on your Windows or Linux system.

Web

How to Consume ODP-enabled OData Service Using OData Connector

This article describes how to generate an OData service to extract data from ODP-enabled data sources.

Additional Articles

Configuring an ODBC Connection for Google BigQuery

You can configure an ODBC connection to connect to Google BigQuery from Cloud Data Integration. This article explains how to configure an ODBC connection for Google BigQuery in Cloud Data Integration.

Download Documentation Set

Send Feedback

Overview of Connections

Create a Mapping Task

Video: Run a Taskflow as a Service

IICS Product Availability Matrix

Data Integration Connectors Product Availability Matrix

Data Integration Connectors PAM Supplement

Video: Install a Secure Agent

Video: Monitor and Set Up Alerts for Secure Agents

Import and Export Tasks

Secure Agent Architecture in IICS