PowerExchange for Amazon Redshift User Guide

10.5.2
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5
- 10.4.1
- 10.4.0

Back Next

Prerequisites

Before you can use PowerExchange for Amazon Redshift, perform the following tasks:

Verify that the domain has a Data Integration Service and a Model Repository Service.

Verify that you can connect to Amazon Redshift with an SQL client that uses the PostgreSQL driver.

For example, you can use SQL Workbench/J to connect to Amazon Redshift.

To run mappings on Hortonworks, Amazon EMR, and MapR distributions that use non-Kerberos authentication, configure user impersonation.

For information about configuring user impersonation, see the

Data Engineering Integration Guide

To run mappings on MapR secure clusters, configure the MapR secure clusters on all the nodes.

For information about configuring MapR secure clusters, see the

Data Engineering Integration Guide

To run mappings on Spark engine and Blaze engine using a secure domain, you must import the CA certificates available in the Redshift Certificate Authority bundle and the

Baltimore CyberTrust Root

certificate file.

To import the CA certificates available in the Redshift Certificate Authority bundle, perform the following steps:

Download the

redshift-keytool.jar

file.

Run the following command to import the CA certificates available in the Redshift Certificate Authority bundle into the Informatica TrustStore location:

 java -jar redshift-keytool.jar -k <infa_trust_store_location> -p <keystore_password>

Restart the Data Integration Service.

To import the

Baltimore CyberTrust Root

certificate file, perform the following steps:

Download the

Baltimore CyberTrust Root

certificate file.

Provide the read, write, and execute permissions to the certificate file.

Run the following command to import the certificate file into the Informatica TrustStore location:

<INFA_HOME>/java/jre/bin/keytool -keystore <infa_trust_store_location> -importcert -alias <Alias_Name> -file <BaltimoreCyberTrustRoot certificate file path>/<certificate_filename> -storepass <Truststore_Password>

Restart the Data Integration Service.

To enable Metadata Access Service to import metadata from Amazon Redshift, see the following KB article:

https://knowledge.informatica.com/s/article/HOW-TO-Enable-Metadata-Access-Service-to-import-metadata-from-Amazon-S3-and-Amazon-Redshift?language=en_US

Configure Databricks Connection Advanced Properties

Verify that a Databricks connection is created in the domain. If you want to read NULL values from or write NULL values to an Amazon Redshift table, configure the following advanced properties in the Databricks connection:

infaspark.flatfile.reader.nullValue=True

infaspark.flatfile.writer.nullValue=True

For more information about product requirements and supported platforms, see the Product Availability Matrix on Informatica Network: https://network.informatica.com/community/informatica-network/product-availability-matrices

Rename Saved Search

Table of Contents

PowerExchange for Amazon Redshift User Guide

PowerExchange for Amazon Redshift User Guide

Prerequisites

Prerequisites

Configure Databricks Connection Advanced Properties