Details on Amazon Redshift Connection

This dialog is used to configure a connection to data in the Amazon Redshift cloud data warehouse.

Note that you need to install a driver on your computer to access the Amazon Redshift connector. See the system requirements at http://spotfi.re/sr/connectors to find the correct driver.

For instructions on how to access your Amazon Redshift data in Spotfire, see the following topic:

Accessing Data from Amazon Redshift

To reach this dialog:

Click Files and data .
In the Files and data flyout, click Connect to.
In the list of connectors, click Amazon Redshift.
In the Amazon Redshift flyout, click New connection.

Option	Description
Server	The name of the server where your data is located. To include a port number, add it directly after the name preceded by colon. Example with port number: MyDatabaseServer:5439
Authentication method	The authentication method you want to use to log in to Amazon Redshift. Select from the following options: Username and password Log in to Amazon Redshift with username and password. Sometimes referred to as standard authentication in Amazon Redshift. AWS Profile Log in to Amazon Redshift with IAM credentials that you have stored as a profile in your AWS credentials file. Note: When you select AWS Profile, the Username field controls the connection setting Dbuser. Note: An AWS credentials file must be available and configured on all computers running Spotfire clients where you want to use the connection. If you use Kerberos authentication in your Spotfire Environment, you might have to configure an AWS credentials file per user on computers that run web player services. AWS IAM Credentials Log in to Amazon Redshift with AWS IAM credentials. Enter your AWS IAM credentials with the settings AccessKeyID and SecretAccessKey in the Settings for authentication method table. Note: If you select AWS IAM Credentials and you do not enter AccessKeyID and SecretAccessKey, the Amazon Redshift ODBC driver attempts to connect using the default AWS Profile from your AWS credentials file, if you have one on your computer. AD FS Log in to Amazon Redshift using Active Directory Federation Services. Enter the following information in the Settings for authentication method table: IdP_Host: The address to your AD FS service. Azure AD Log in to Amazon Redshift using Azure AD. Enter the following information in the Settings for authentication method table: IdP_Tenant: The tenant ID of your Azure AD application. Client_ID: The client ID in Azure for your Redshift cluster. Client_Secret: The client secret in Azure for your Redshift cluster. Okta Log in to Amazon Redshift with AWS IAM credentials from Okta. Enter the following information in the Settings for authentication method table: IdP_Host: The address to your Okta service. App_ID: The Application ID in Okta of your Redshift cluster. DbUser: The database user in Amazon Redshift to use. PingFederate Log in to Amazon Redshift with AWS IAM credentials from PingFederate. Enter the following information in the Settings for authentication method table: IdP_Host: The address to your PingFederate service. IdP_Port: The port number for your PingFederate service. DbUser: The database user in Amazon Redshift to use.
Settings for authentication method	Settings for the selected authentication method. Based on what authentication method you select, different settings are added to the table. You can also add other relevant connection settings. To configure a setting, fill in the Value column. Then use the Save checkbox to select if you want the value you entered to be stored in the connection, or if you want the user to fill in their own value when they open the connection. Save the setting value or ask the user to fill it in? In the table, you can choose if you want to save the value that you enter for a setting. By default, Save is not selected. If you do not select Save, the setting value that you enter is not stored in the connection. The setting is treated like a username or password, so when a user opens the connection, Spotfire asks them to enter a value for the setting. Important: In the Data Source Settings dialog, if you select Yes, save credentials with connection data source, all settings are saved with the data source. If you select Save, the setting value that you enter is stored in the connection. When a user opens the connection, the same value is used to connect to the Amazon Redshift cluster. Caution: When you select Save, the value you enter is stored unencrypted in the analysis file. Do not select Save for secret information, such as usernames and passwords. Adding a setting To add a new setting, enter the name of the setting in the Setting column on the final row in the table. Then enter the value in the Value column. When you enter a name and value for a setting, a new row is added where you can add more settings. Deleting a setting To remove a connection property that you have added, click the leftmost cell in the row to select the entire row. Then press the Delete key. Tip: If your keyboard does not have a Delete key, use the corresponding keyboard shortcut instead. On a Mac computer, for example, the keyboard shortcut is Fn + Backspace. What settings can I use? There is no guarantee that any specific connection setting that you add works in Spotfire. For security reasons, some settings are not allowed. Also, you can not add settings that there are already dedicated controls or input fields for.
SSL mode	Specifies whether SSL should be used when connecting to the Amazon Redshift database. disable SSL is not used, and the connection is not encrypted. allow SSL encryption is used only if the server requires it. prefer SSL should be used if the server supports it. require SSL must always be used. verify-ca SSL must be used, and the certificate must be verified. verify-full SSL must be used, and the server certificate and host name must be verified. See the official Amazon Redshift documentation for more information about how to use SSL mode.
Username	The account name you wish to use when logging into the Amazon Redshift database.
Password	The password for the specified account.
Database	The name of the database where your data is located.

Advanced

Option

Description

Use unicode

If this check box is selected, the Amazon Redshift ODBC driver will return CHAR as SQL_WCHAR, VARCHAR as SQL_WVARCHAR, and TEXT as SQL_WLONGVARCHAR.

If this check box is not selected, the Amazon Redshift ODBC driver will return CHAR as SQL_CHAR, VARCHAR as SQL_VARCHAR, and TEXT as SQL_LONGVARCHAR.

Connection timeout (s)

Specifies the maximum number of seconds allowed for a connection to the database to be established.

Note: If you set the connection timeout to zero, it will be interpreted as no timeout. That is, there will be no upper limit for trying to connect. This is generally not recommended.

Command timeout (s)

Specifies the maximum number of seconds allowed for a command to be executed.

Note: If you set the command timeout to zero, it will be interpreted as no timeout. That is, there will be no upper limit for trying to execute the command. This is generally not recommended.

Settings profile

The name of a settings profile to use when you open the connection in a web client or in Automation Services.

A settings profile is a way to store settings from the Settings for authentication method table, without saving the values in the analysis file. Settings profiles are stored in the configuration on Automation Services and web player services.

To learn more, see Settings profiles.

Additional settings

Caution: All the settings and values that you add in the Additional settings table are stored unencrypted in analysis files. Do not add secret information like usernames and passwords. In the Settings for authentication method table on the General tab, you can add settings without storing values in the analysis file.

Add and use additional connection settings.

In the Amazon Redshift ODBC driver, there are many connection settings that there are no controls for in Spotfire. The table enables you to use more of those settings.

To learn about what connection settings are available, see the documentation for the Amazon Redshift ODBC driver.

Adding a setting

In the Additional settings table, each row represents a connection setting. To add a new setting, enter the name of the setting in the Setting column, and enter the value in the Value column.

When you enter a name and value for a setting, a new row is added where you can add more settings.

Deleting a setting

To remove a connection property that you have added, click the leftmost cell in the row to select the entire row. Then press the Delete key.

Tip: If your keyboard does not have a Delete key, use the corresponding keyboard shortcut instead. On a Mac computer, for example, the keyboard shortcut is Fn + Backspace.

What settings can I use?

There is no guarantee that any specific connection setting that you add works in Spotfire.

For security reasons, some settings are not allowed. Also, you can not add settings that there are already dedicated controls or input fields for.