Basic authentication is the default authentication method.

To configure the driver to use basic 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 Password option to specify your password.
  • Set the Port Number (PortNumber) option to specify the port number of the server listener.
Note: The User Name and Password options are not required to be stored in the data source. They can also 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 Basic.

Connection string

DRIVER=DataDirect 8.0 Amazon Redshift Wire Protocol;Database=Redshift2;
HostName=RedshiftServer;LogonID=John;Password=secret;PortNumber=5439;

odbc.ini

[Amazon Redshift]
Driver=ODBCHOME/lib/ivrsft28.so
...
Description=DataDirect 8.0 Amazon Redshift Wire Protocol
...
Database=Redshift2
...
HostName=RedshiftServer
...
LogonID=John
...
Password=secret
...
PortNumber=5439
...