Skip to content

aws/amazon-redshift-odbc-driver

Redshift ODBC Driver

The Amazon ODBC Driver for Redshift database connectivity through the standard ODBC application program interfaces (APIs). The Driver provides access to Redshift from any C/C++ application.

The driver has many Redshift specific features such as,

  • IAM authentication
  • IDP authentication
  • Redshift specific datatypes support
  • External schema support as part of SQLTables() and SQLColumns() ODBC API

Amazon Redshift provides 64-bit ODBC drivers for Linux, and Windows operating systems.

Build Driver

Prerequisites

  • https://git-lfs.com/ (for correctly cloning this repository)
  • Visual Stuido 2022 Community Edition (For Windows)
  • gcc (For Linux)
  • cmake >= 3.12 (For Linux)
  • Dependencies: To see a list of Linux dependencies, please look into src/odbc/rsodbc/CMakeLists.txt (windows: Dependencies are already included).

Build Artifacts

On Windows system run:

build64.bat n.n.n n 
e.g. build64.bat 2.0.1 0

It builds rsodbc.dll file under src\odbc\rsodbc\x64\Release directory.

export DEPENDENCY_DIR= Ensure proper dependencies are provided on Unix systems by configuring the dependency variable: Set the DEPENDENCY_DIR variable in the exports_basic.sh`` file. For further details, consult the BUILD.CMAKE.md` file. Then run:

build64.sh n.n.n n
e.g. build64.sh 2.0.1 0

It builds librsodbc64.so file under src/odbc/rsodbc/Release directory.

Installation and Configuration of Driver

Driver Name: Amazon Redshift ODBC Driver (x64)

Default Installation Directory:

  • C:\Program Files\Amazon Redshift ODBC Driver x64\ (For Windows)
  • /opt/amazon/redshiftodbcx64/ (For Linux)

See Amazon Redshift ODBC Driver Installation and Configuration Guide for more information.

Here are download links for the latest release:

Report Bugs

See CONTRIBUTING for more information.

Contributing Code Development

See CONTRIBUTING for more information.

Changelog Generation

An entry in the changelog is generated upon release using gitchangelog <https://github.com/vaab/gitchangelog>. Please use the configuration file, .gitchangelog.rc when generating the changelog.

Security

See CONTRIBUTING for more information.

License

This project is licensed under the Apache-2.0 License.