Integrating Amazon Redshift with an Amazon Partner - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Integrating Amazon Redshift with an Amazon Partner

By working with Amazon Redshift, you can integrate with Amazon Partners from the Cluster details page on the Amazon Redshift console. From the Cluster details page, you can speed up your data onboarding into your Amazon Redshift data warehouse with Amazon Partner applications. You can also join and analyze data from different sources together with existing data in your cluster. Before completing integration with Informatica, you must add the partner's IP addresses to the allowlist of inbound traffic. The following Amazon Partners can integrate with Amazon Redshift:

Amazon Partners can integrate with Amazon Redshift using the Amazon CLI or Amazon Redshift API operations. For more information, see the Amazon CLI Command Reference or the Amazon Redshift API Reference.

Integrating with an Amazon Partner using the Amazon Redshift console

Use the following procedure to integrate a cluster with an Amazon Partner.

To integrate an Amazon Redshift cluster with an Amazon Partner
  1. Sign in to the Amazon Web Services Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshiftv2/.

  2. On the navigation menu, choose Clusters.

  3. Choose the cluster that you want to integrate.

  4. Choose Add partner integration. The Choose partner page opens with details about the available Amazon Partners.

  5. Choose an Amazon Partner, then choose Next.

    More details about the chosen Amazon Partner appear, along with details about the cluster that you are integrating. The Cluster details section includes information that you provide on the Amazon Partner website such as the Cluster identifier, Endpoint, Database name, and User name (which is a database user name). This information is sent to the partner that you chose.

  6. Choose Add partner to open the Amazon Partner's website.

  7. Configure the integration with your Amazon Redshift cluster on the partner's website. On the partner's website, you can select and configure the data sources that are loaded to your Amazon Redshift cluster. You can also define additional extract, load, and transform (ELT) transformations to process your business data, join it with other datasets, and build consolidated views for analysis and reporting.

You can view and manage Amazon Partner integrations from the cluster details Properties tab. The Integrations section lists the Partner name that you can use to link to the Amazon Partner website, the Status of the integration, the Database that receives the data, and the Last successful connection that might have updated the cluster.

The possible status values are as follows:

  • Active – The Amazon Partner can connect to the cluster and complete configured tasks.

  • Inactive – The Amazon Partner integration doesn't exist.

  • Runtime failure – The Amazon Partner can connect to the cluster but can't complete configured tasks.

  • Connection failure – The Amazon Partner can't connect to the cluster.

After you delete an Amazon Partner integration from Amazon Redshift, data continues to flow into your cluster. Complete the delete on the partner's website.

Loading data with Amazon partners

Aside from integrating a partner with an Amazon Redshift cluster, you can also move data from more than 30 sources into your Amazon Redshift cluster using our partner's data loading tools. Before you do so, you must add the partner's IP addresses (found below) to the allowlist of inbound rules. For more information about adding rules to an Amazon EC2 security group, see Authorizing Inbound Traffic for Your Instances in the Amazon EC2 User Guide for Linux Instances. Note that while the Informatica Data Loader tool is free, data ingress charges might apply depending on the data sources and targets you choose.

You can load data from the following partners:

To integrate an Amazon Redshift cluster with Informatica
  1. Sign in to the Amazon Web Services Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshiftv2/.

  2. On the navigation menu, choose Amazon partner integration, then choose the partner you want to integrate your cluster with.

  3. Choose Complete <partner-name> integration. You will be redirected to the partner's integration site.

  4. Enter the necessary details on the partner's site and complete the integration.