Redshift Driver Download

Posted on by admin

I recently stood up Tableau Server Linux on AWS and am working on getting the Amazon RedShift driver to work. Specifically looking at documentation related to appending and modifying the .ini files on the Server box:

(from Driver Download | Tableau Software DS: RedShift OS: Linux)

The location of the JDBC drivers is not affected by this. If you download the archive 'with optional libraries', the libraries will automatically be extracted into the ext subdirectory and you can remove the existing libraries from directory where sqlworkbench.jar is located. Download ODBC Driver for Amazon Redshift. Turn to this handy piece of software in order to make sure your ODBC-based programs can easily and directly access Amazon Redshift.

Afterwards, on all distros, append the following to the /etc/odbcinst.ini file:

[Amazon Redshift (x64)]

Description=Amazon Redshift ODBC Driver(64-bit)

Driver=/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so

Then, modify the following values in the /opt/amazon/redshiftodbc/lib/64/amazon.redshiftodbc.ini file:

From: DriverManagerEncoding=UTF-32 To: DriverManagerEncoding=UTF-16

Aws Redshift Odbc Driver

Sql workbench redshift driver download

Redshift Jdbc41 Driver Download

From: LogPath=[LogPath] To: LogPath=/tmp (optional)

From: ODBCInstLib=libiodbcinst.so To: #ODBCInstLib=libiodbcinst.so

From: #ODBCInstLib=libodbcinst.so To: ODBCInstLib=libodbcinst.so

Question I have: for the .odbcinst.ini file - does there need to be an entry that indicates the driver is installed, there is an entry for PostgreSQL (which we installed successfully):

[ODBC Drivers]
PostgreSQL Unicode=Installed
should this be an entry?------> Amazon Redshift (x64)=Installed
[PostgreSQL Unicode]
Description=ODBC for PostgreSQL
Driver=/opt/tableau/tableau_driver/postgresql-odbc/psqlodbcw.so
FileUsage=1
[Amazon Redshift (x64)]
Description=Amazon Redshift ODBC Driver(64-bit)
Driver=/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so