English
  • Cloud Data Integration Connectors H2L
  • All Products

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.

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

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 …

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.

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 …

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

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

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

Ecosystem – Snowflake

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 …

Enterprise Application

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 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 Cassandra JDBC Driver Options for Cassandra Connector

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.

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 …

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.

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.

Additional Guides

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.

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.

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

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 …

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.

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 …

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

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

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

Ecosystem – Snowflake

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 …

Enterprise Application

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 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 Cassandra JDBC Driver Options for Cassandra Connector

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.

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 …

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.

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.

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.

Released June 2019

Updated July 2019

Download Documentation Set
Send Feedback

Onboard

Overview of Connections

What's New in Data Integration Connections

Create a Mapping Task

Video: Run a Taskflow as a Service

Product Availability Matrix

Configure

Video: Install a Secure Agent

Configure a Proxy Server

Video: Monitor and Set Up Alerts for Secure Agents

Import and Export Tasks

Secure Agent Architecture in IICS

Implement

Parameterization in Mappings

Converting Relational Input into Hierarchical Output

Configure SAML SSO in IICS

Optimize

Pushdown Optimization using an ODBC Connection

Video: Optimize Snowflake Mapping Performance using Pushdown Optimization

Automate Creating Backups of Assets
Explore Informatica Network
Communities
Knowledge Base
Success Portal