Current Version

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 known issues, you will find it in the release notes even if the connector is not updated in the current release. If a connector does not have …

CDC, Mainframe, and Midrange Systems

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 Microsoft SQL Server or Oracle target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC …

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 Microsoft SQL Server or Oracle target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC …

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 Microsoft SQL Server or Oracle target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC …

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 Microsoft SQL Server or Oracle target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to …

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 connections, …

Oracle CDC Connector

The Data Integration Oracle CDC Connector Guide contains information about how to configure and use the Oracle CDC Connector to update a target with the latest change records from an Oracle source. The Oracle CDC Connector has been deprecated. If you are implementing Oracle CDC for the first time, use the newer Oracle CDC V2 Connector. …

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 Microsoft SQL Server or Oracle target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC connections, …

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 Microsoft SQL Server or Oracle target. The CDC connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC …

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 Microsoft SQL Server or Oracle target. The VSAM CDC Connector works with Cloud Data Integration mappings, mapping tasks, and taskflows. Learn how to configure CDC …

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 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 in Cloud Data Integration. You can also learn how to configure pushdown optimization to a Netezza database using a Netezza ODBC connection.

Snowflake Cloud Data Warehouse V2 Connector

Use Snowflake Cloud Data Warehouse V2 Connector to learn how to read from or write to Snowflake Cloud Data Warehouse. Learn to create a connection, develop and run mass ingestion tasks, mapping tasks, mappings, and elastic mappings in Cloud Data Integration. Learn how to configure pushdown, cross-schema pushdown optimization to a …

Snowflake Connector

Use Snowflake Connector to learn how to read from or write to Snowflake using Cloud Data Integration. Learn to create a connection, develop mappings, and run mapping tasks in Cloud Data Integration. You can also learn how to configure pushdown and cross-schema pushdown optimization to a Snowflake database using a Snowflake 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 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 Connector

Use Amazon DynamoDB Connector to learn how to read from or write to Amazon DynamoDB by using Cloud Data Integration. You can also learn to create an Amazon DynamoDB connection, develop and run synchronization tasks, 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 mass ingestion tasks, mapping tasks, mappings, and elastic mappings in Cloud Data Integration.

Azure Synapse SQL Connector

Use Microsoft Azure SQL Data Warehouse V3 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 mapping tasks, mappings, and elastic mappings. Learn how to configure pushdown optimization to a Microsoft Azure SQL Data Warehouse.

CDM Folders Connector

Use CDM Folders Connector to learn how to read from or write data in the .csv file format to the common data model folder present in the Microsoft Azure Data Lake Storage Gen2 storage by using Cloud Data Integration. It also includes information about how to create an external dataflow on Power BI workspace to access the data from the …

Google Analytics Connector

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

Google BigQuery Connector

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

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 BigQuery V2 Connector

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

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 mappings, and run mapping 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 synchronization 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 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.

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 to Microsoft Azure Blob Storage by using Cloud Data Integration. Learn to create a Microsoft Azure Blob Storage V3 connection, develop and run mappings, mapping tasks, and mass ingestion tasks in Cloud 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 by using Cloud Data Integration. Learn to create a connection, develop mappings, and run mapping tasks in Cloud 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 by using Cloud Data Integration. Learn to create a Microsoft Azure Data Lake Storage Gen2 connection, develop and run mappings, elastic mappings, and mapping task.

Microsoft Azure Data Lake Store V2 Connector

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

Microsoft Azure Data Lake Store V3 Connector

Use Microsoft Azure Data Lake Store V3 Connector to learn how to read from or write to Microsoft Azure Data Lake Store by using Cloud Data Integration. Learn to create a Microsoft Azure Data Lake Store V3 connection, develop and run mappings, mapping tasks, and mass ingestion 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 SQL Data Warehouse V3 Connector

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.

Birst Cloud Connect Connector

Use Birst Cloud Connect Connector to learn how to write to Birst Cloud Connect by using Cloud Data Integration. Learn to create a Birst Cloud Connect connection and run synchronization tasks in Cloud Data Integration.

Box Connector

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

Box Oauth Connector

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

CallidusCloud Badgeville Connector

Use CallidusCloud Badgeville Connector to learn how to write to CallidusCloud Badgeville by using Cloud Data Integration. Learn to create a CallidusCloud Badgeville connection, develop and run synchronization tasks, mappings, and mapping tasks 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

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

Cassandra Connector

Use Cassandra Connector to learn how to read from or write to Cassandra by using Cloud Data Integration. Learn to create a connection, develop mappings, and run mapping tasks in Cloud 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.

Databricks Delta Connector

Use Databricks Delta Connector to learn how to read from or write to Databricks Delta Lake by using Cloud Data Integration. Learn to create a connection and develop and run mass ingestion 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.

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.

Exasol Connector

Use Exasol Connector to connect to Exasol database by using Cloud Data Integration. Learn how to read from and write to Exasol database by using Cloud Data Integration. Learn to create an Exasol 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 and 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 mappings, and run 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.

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 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 mappings, and run 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 Microsoft Dynamics 365 for Sales 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

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 Connector

Use MongoDB Connector to learn how to read from or write to MongoDB by using Cloud Data Integration. Learn to create a connection, develop mappings, and run mapping tasks in Cloud 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.

MVP Plant V2 Connector

Use MVP Plant V2 Connector to learn how to read from or write to MVP Plant by using Cloud Data Integration. Learn to create a connection, develop and run synchronization tasks, mappings, and 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 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.

OrangeHRM Connector

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

Qlik Connector

Use Qlik Connector to learn how to write to a QVX file by using Cloud Data Integration. Learn to create a Qlik connection, develop and run synchronization tasks, 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.

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 Commerce Cloud Connector

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

Salesforce Connector

Use Salesforce Connector to learn how to read from or write to Salesforce by using Cloud Data Integration. Learn to create a Salesforce connection, develop and run synchronization tasks, mappings, mapping tasks, replication tasks, and masking 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 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, and mapping tasks in Cloud Data Integration.

SAP HANA Connector

Use SAP HANA Connector to learn how to read data from SAP HANA database by using Cloud Data Integration. Learn to create an SAP HANA 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 and mapping 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 Connector to 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 and synchronization 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.

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.

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.

Zendesk V2 Connector

Use Zendesk V2 Connector to learn how to read from or write to Zendesk 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 AQuA Connector

Use Zuora AQuA 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 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

Advanced FTPS V2 Connector

Use the Advanced FTPS V2 Connector to learn how to read files from and to write files to an FTPS server by using Cloud Data Integration. Learn to create a connection, develop and run mass ingestion tasks in Cloud Data Integration.

Advanced FTP V2 Connector

Use the Advanced FTP V2 Connector to learn how to read files from and to write files to an FTP server by using Cloud Data Integration. Learn to create a connection, develop and run mass ingestion tasks in Cloud Data Integration.

Advanced SFTP V2 Connector

Use the Advanced SFTP V2 Connector to learn how to read files from and to write files to an SFTP server by using Cloud Data Integration. Learn to create a connection, develop and run mass ingestion tasks in Cloud Data Integration.

AS2 Connector

Use Cloud Data Integration AS2 Connector to learn how to set up and use the AS2 Connector. Learn how business users can use AS2 Connector to send files from the organization to AS2 servers at external partner sties, and how users can configure the Informatica Intelligent Cloud Services File Integration Service to receive files from AS2 …

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.

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.

Relational

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 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 and mapping tasks in Cloud Data Integration.

JDBC V2 Connector

Use JDBC V2 Connector to learn how to use the JDBC V2 connection in at-scale mappings 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, and develop and run elastic mappings in Data Integration.

MemSQL V2 Connector

Use MemSQL V2 Connector to learn how to read from or write to MemSQL database by using Cloud Data Integration. Learn to create a MemSQL V2 connection, develop and run mappings and mapping tasks in Cloud 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 to Microsoft SQL Server by using Cloud Data Integration. Learn to create a connection, develop mappings, and run synchronization, mapping, and replication tasks. You can also learn how to configure pushdown and cross-schema pushdown optimization to a Microsoft SQL …

MySQL Connector

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

ODBC Connector

Use ODBC Connector to learn how to read from or write to ODBC-compliant databases. Learn to create an ODBC connection, develop mappings, and run synchronization and mapping 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, and replication tasks in Cloud Data Integration. You can also learn how to configure pushdown and cross-schema pushdown optimization.

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 tasks in Cloud Data Integration. You can also learn how to configure pushdown optimization using an ODBC connection.

Social Media

Twitter Connector

Use Twitter Connector to learn how to read from or write to Twitter by using Cloud Data Integration. Learn to create a Twitter connection and run synchronization 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 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 Cloud Data Integration. Learn to create a REST V2 connection, develop and run mappings and mapping tasks in Cloud 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.

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 …

Assume Roles for Amazon Resources in Informatica Cloud Data Integration

You can assume an IAM (Identity and Access Management) role in Amazon S3 to generate temporary security credentials. The temporary security credentials give you limited access to Amazon S3 resources for a certain period. This article describes how an IAM user can use an assume role to temporarily gain access to Amazon Web Services (AWS).

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.

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.

Configuring Assume Roles for Amazon Resources in Cloud Data Integration

This article describes how you can configure an assume role to access the Amazon Web Services (AWS) resources from the same or different AWS accounts.

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 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 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 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 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 IAM Authentication for Amazon S3 and Amazon S3 V2 Connectors

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 …

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.

Configuring the Simba Cassandra JDBC Driver Options

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

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.

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.

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 …

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.

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.

Frequently Asked Questions for Google BigQuery Connector

This article describes frequently asked questions about using Google BigQuery 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 V2 Connector to read data from and write data to Google BigQuery.

How to Configure Pushdown Optimization for an Amazon Redshift Task Using an ODBC Connection

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 …

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 …

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

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.

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.

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.

Performance Tuning and Best Practices for Mass Ingestion Tasks

When you run mass ingestion tasks, you can tune multiple factors such as hardware, database, Amazon EC2, Secure Agent, and task parameters that impact the connector performance. This article describes general reference guidelines to help you tune these parameters before you configure mass ingestion tasks in Cloud Data Integration connectors.

Performance Tuning and Best Practices for Snowflake 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 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 …

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 and Sizing Guidelines for Microsoft Azure SQL Data Warehouse V3 Connector

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

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 …

Performance Tuning Guidelines for Full Pushdown Optimization for Microsoft Azure SQL Data Warehouse 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 …

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.

Prerequisites to Create a Microsoft Azure Data Lake Storage Gen2 Connection

You can use PowerExchange® for Microsoft Azure Data Lake Storage Gen2 to connect to Microsoft Azure Data Lake Storage Gen2 from Informatica. This article explains the prerequisite tasks that you must complete before you create a Microsoft Azure Data Lake Storage Gen2 Connection.

Prerequisites to Use CDM Folders Connector

You can use CDM Folders Connector to read data from or write data in the .csv file format to the common data model folder in the Microsoft Azure Data Lake Storage Gen2 (ADLS Gen2) storage. You can also use CDM Folders Connector to create an external dataflow on Power BI workspace to access the data stored in the common data model …

Proxy server configuration for the Secure Agent

You can configure the Informatica Cloud Secure Agent to use proxy server on Windows and Linux machines. This article describes how to use an authenticated or unauthenticated proxy server to connect to the Internet. When you configure the proxy server, the Secure Agent connects to Informatica Intelligent Cloud Services through the proxy server.

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 …

Standard Common Data Model Objects Supported by CDM Folders Connector

You can use CDM Folders Connector to store the data as the standard common data model objects or custom objects when you write data in .csv format to the common data model folder present in the Microsoft Azure Data Lake Storage Gen2 (ADLS Gen2) storage. This article lists all the standard common data model objects that CDM Folders Connector supports.

Switching the Power BI Accounts and Change the Data Source Settings within the Power BI Desktop

When you use CDM Folders Connector to create an external dataflow on Power BI workspace, you can switch the Power BI accounts and change the data source settings within the Power BI Desktop. This article explains the how you can switch the Power BI accounts and change the data source settings within the Power BI Desktop.

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.

Released October 2020

Updated January 2021

Download Documentation Set

Send Feedback

Knowledge Base

Success Portal

Release Information