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

Integrate Amazon Redshift with an Amazon Partner

By working with Amazon Redshift, you can integrate with Amazon Partners 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.

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.