1 Reply Latest reply on Nov 28, 2018 3:47 AM by Yuriy Fal

    Amazon RedShift Driver Issue (Linux on AWS)

    Ann Jackson

      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)

       

      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

      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