Configure the Amazon Redshift target

Complete the procedure below to configure the Amazon Redshift target and verify that you can write to the Amazon Redshift database.

• Ensure that the database user you enter in the PI Integrator for Business Analytics publish target configuration has the following minimum permissions on the Amazon Redshift database: SELECT, CREATE, DROP, UPDATE, INSERT, and DELETE.

• Install and configure the Amazon Redshift ODBC driver. For more information, see Install and configure the Amazon Redshift ODBC driver.

• Create the Amazon Redshift target before you configure it. For more information, see Add a publish target.

1. On the Administration page, click the Targets tab. Then select the target in the Publish Targets list.

   Note: If you have already selected your target, skip to the next step.

2. Refer to the following table and enter the required information. Click the buttons as they become enabled.

   Parameter	Description
   ODBC Driver	(Optional) ODBC driver that connects to the Amazon cluster. The default is Amazon Redshift (x64).
   Cluster Name	Amazon cluster node to which data is sent.
   Cluster Database Port	(Optional) Port through which to connect to the cluster database. The default is 5439.
   Cluster Database Name	Cluster database to which data is written.
   Database Username	Database username used to connect to the cluster.
   Password	Password for the database username used to connect to the cluster.

3. Click Verify Writer.

4. Click Save Changes.

5. Give users access to the Amazon Redshift target. For more information, see Grant access to targets.