H2L

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.