Create an Amazon Redshift Connection

Security: Prism: Manage Connection
domain in the Prism Analytics functional area.

You must create an Amazon Redshift connection before using it as a source in a data change task.

Navigate to the

Data Catalog

Select

Create > Connection

Select Amazon Redshift.

Complete the task:

Option	Description
Name	The connection name must be unique in the Data Catalog. Workday displays this name in the Data Catalog and when you select a connection in a data change task.
Description	(Optional) Workday recommends using the description to define the use of the connection and help differentiate between different connections.
Authentication Type	Select how to connect to Amazon Redshift: Basic Auth . Workday connects to Amazon Redshift using the user credentials of the specified Amazon Redshift account. IAM Credentials . Workday connects to Amazon Redshift using the user's AWS Identity and Access Management (IAM) credentials.

(Optional) When you use IAM credentials, complete these fields:

Option	Description
User Name	The Amazon Redshift database user that you are authenticating as.
Access Key ID	The access key of the IAM user. To use an IAM role, the user must be able to assume the IAM role.
Secret Access Key	The secret access key of the IAM user. To use an IAM role, the user must be able to assume the IAM role.
Region	The AWS geographical region of the Redshift cluster.
Role ARN	(Optional) The Amazon Resource Name (ARN) of the IAM role the user assumes when they use dynamically generated temporary security credentials.
Database Groups	(Optional) A comma-separated list of database groups to join the current session.

(Optional) Use the

Test Connection

button to verify that Workday can connect to Amazon Redshift using the connection information you configured.

Workday displays the Amazon Redshift connection on the

Connections

tab of the

Data Catalog

report. You can right-click the connection to view or edit it.