The driver supports JWT authentication for Azure apps connecting to Amazon Redshift.

To configure the driver to use JWT authentication:

  • Set the Host Name (HostName) option to specify the IP address endpoint of the Amazon Redshift cluster to which you want to connect.
  • Set the Database Name (Database) option to specify the name of the database to which you want to connect.
  • Set the User Name (LogonID) option to specify your user name.
  • Set the Authentication Method (AuthenticationMethod) option to 39 (JWT).
  • Set the Web Identity Token (WebIdentityToken) option to specify the value of the signed JWT.
  • Set the Port Number (PortNumber) option to specify the port number of the server listener.
Note: The User Name and Web Identity Token options are not required to be stored in the data source. They can be sent separately by the application using the SQLConnect ODBC API. For SQLDriverConnect and SQLBrowseConnect, they will need to be specified in the data source or connection string.

The following examples show the connection information required to establish a connection using JWT authentication.

Connection string

DRIVER=DataDirect 8.0 Amazon Redshift Wire Protocol;AuthenticationMethod=39;
Database=Redshift2;HostName=RedshiftServer;LogonID=John;
WebIdentityToken=jwt-token;PortNumber=5439;

odbc.ini

[Amazon Redshift]
Driver=ODBCHOME/lib/ivrsft28.so
...
AuthenticationMethod=39
...
Description=DataDirect 8.0 Amazon Redshift Wire Protocol
...
Database=Redshift2
...
HostName=RedshiftServer
...
LogonID=John
...
WebIdentityToken=jwt-token
...
PortNumber=5439
...