Aginity Workbench 22.214.171.12478 now supports the native Amazon Redshift ODBC driver. It is recommended to install and use it. This driver provides better support for SSL and various other Amazon Redshift functions like AWS IAM authentication.
To use it, follow the below steps:
- Download and install the driver. Follow the instructions from Amazon here.
- After you install the driver, depending on your version of Windows, select Amazon Redshift (x64) ODBC or Amazon Redshift (x32) ODBC in the driver list, in the lower-left corner of the database connection dialog box.
- (Optional) To specify an authentication type for your connection, click Advanced, select the authentication type, and provide values for the required authentication properties.
Workbench for Redshift 126.96.36.19978