Devart’s Birthday Sale Is On — 20% Off All Products
ends in   {{days}}
Days
{{timeFormat.hours}}
:
{{timeFormat.minutes}}
:
{{timeFormat.seconds}}

ODBC Driver for Amazon Redshift

Devart ODBC Driver for Amazon Redshift is a high-performance connectivity solution with enterprise-level features for accessing Amazon Redshift. It is compatible with 200+ ODBC-compliant reporting, analytics, BI, and ETL tools and works on both 32-bit and 64-bit Windows, macOS, and Linux. The Driver connects directly to Amazon Redshift over TCP/IP, fully supports standard ODBC API functions and data types, and enables straightforward, secure access to live Amazon Redshift data from anywhere.

  • Verified compatibility with multiple BI and ETL tools
  • Simple installation on several computers
  • Easy access to live data from anywhere
  • Fast data transmission
How ODBC Driver for Amazon Redshift works

Direct connection to Amazon Redshift

Our data connector enables various ODBC-aware applications to establish a direct connection to Amazon Redshift via TCP/IP without any additional Amazon Redshift libraries or clients.

A direct connection accelerates data transmission for real-time analytics and streamlines the deployment process, since there is no need to distribute any additional libraries or client tools with the Driver. Direct ODBC connectivity facilitates integrations, reduces the need for data migration, and enables access to up-to-date Amazon Redshift data using familiar tools and workflows.

Key benefits:
  • Direct connection over Redshift's PostgreSQL-compatible protocol (default port 5439)
  • Support for Amazon Redshift provisioned clusters and Amazon Redshift Serverless
  • Secure connections over SSL/TLS, SSH, and HTTP/HTTPS tunneling
  • No need for Redshift client libraries or additional software

Features

Direct connection to Amazon Redshift databases

Direct connection

The Driver enables direct connections to Amazon Redshift over its PostgreSQL-compatible wire protocol (default port 5439) with no Redshift client libraries or additional software.

Flexible authentication options

IAM and SSO authentication

The Driver supports connections using Redshift database credentials, AWS IAM credentials and roles, or browser-based single sign-on, including PingOne.

High-performance access to Amazon Redshift data

High performance

Connection pooling, faster connection opening, and prepared statements make every operation with Redshift significantly faster.

Compatibility with all the popular operating systems

Cross-platform support

The Driver runs on Windows, macOS (including Apple Silicon), and Linux in 32-bit and 64-bit versions with a graphical configurator on all supported platforms.

Full support of ODBC functions, data types, and standards

ODBC conformance

Our ODBC Driver fully supports the ODBC API and data types, allowing any ODBC-aware application to work with Amazon Redshift.

Bidirectional mapping between Amazon Redshift and ODBC data formats

Advanced data conversion

For seamless data exchange, the ODBC Driver enables efficient bidirectional mapping between Amazon Redshift and ODBC data types.

Executing batch SQL operations for large data changes

Bulk updates

With our ODBC Driver, large amounts of data can be modified efficiently by combining SQL statements into batches.

Secure encrypted connections using SSL/TLS, SSH, and HTTP/HTTPS tunnels

Secure connections

Your data is safeguarded with SSL/TLS (including password-protected private keys), SSH tunneling, and HTTP/HTTPS tunneling with Bearer Token support.

How does Devart ODBC Driver stack up against the standard Amazon Redshift driver?

Features
Devart ODBC Driver
Standard Amazon Redshift driver
32-bit and 64-bit application support
Included
64-bit only
Cross-platform availability for Windows, macOS, and Linux (including Ubuntu/DEB)
Included
Partial (no v2.x build for Ubuntu)
SSH tunneling
Included
Not included
HTTP/HTTPS tunneling
Included
Not included
Cross-platform GUI configuration
Included
Partial (DSN GUI mainly on Windows)
Nightly builds with hotfixes
Included
Periodic GitHub releases
Dedicated commercial support team
Included
Partial (AWS Support plans)

Pricing

ODBC Driver for Amazon Redshift

Starts from

$179.95
per year
Try the Driver

Key features:

  • Direct connection to Amazon Redshift over TCP/IP with no need for client software
  • Support for Windows, macOS, and Linux (32- and 64-bit)
  • SSL/TLS, SSH, and HTTP/HTTPS tunneling; PingOne authentication
  • Full support for ODBC 3.52 API, data types, and bulk operations
  • Verified compatibility with 200+ BI and ETL tools

ODBC Drivers Universal Bundle

Starts from

$499.95
per year
Try the Universal Bundle

Key features:

  • Support for all 92 ODBC Drivers
  • Easy access to live data from anywhere
  • Full support for standard ODBC API functions and data types
  • No need for database client libraries
  • Support for ODBC-compliant reporting, analytics, BI, and ETL tools
  • Secure connections via SSL, SSH, and HTTPS tunneling

Verified compatibility with 200+ tools

Devart ODBC Drivers are verified to be compatible with leading analytics and reporting tools, various IDEs and programming languages. Get fast and secure access to your data in any application using our ODBC Drivers!

Tools and solutions for managing and working with databases

Database management solutions

Software solutions for business intelligence and data analytics

Business intelligence and data analytics

Software solutions for working with and managing documents

Document management software

Tools and environments for application development and integration

Application development tools

Roles

IT & data teams

Simplify Redshift integration across your data ecosystem through cross-platform connectivity for ETL/ELT processes, along with enterprise-grade authentication and encryption.

Computer monitor displaying data

Developers

Build data-driven applications, internal tools, and automated reporting on Amazon Redshift using a consistent ODBC interface that simplifies integration with familiar languages and standard SQL.

Colleagues discussing work

ODBC Universal Bundle

Get high-performance ODBC Drivers for 92 databases and cloud services in a single Universal Bundle with a 95% discount

Download the Universal Bundle

Other ODBC Drivers for data warehouses

ODBC Driver for Azure SQL Data Warehouse Azure SQL Data Warehouse ODBC Driver for Azure Synapse Analytics Azure Synapse Analytics ODBC Driver for Google BigQuery Google BigQuery ODBC Driver for QuestDB QuestDB ODBC Driver for Snowflake Snowflake ODBC Driver for SQL Azure SQL Azure

Ready to get started?

Get a 30-day free trial now

Get a free trial now

You can download our ODBC Driver for a free trial. It is a great way to see the Driver in action at your own pace.

Download for free
Enjoy bulk discounts

Enjoy bulk discounts

We offer flexible options to meet your budget in the optimal way. You can get bulk discounts for multiple purchases.

Discover now
Need a hand?

Need a hand?

If you need any help or have questions about our connectivity solutions or purchasing options, feel free to get in touch.

Contact us

FAQ

What is Devart ODBC Driver for Amazon Redshift?

The Amazon Redshift ODBC Driver is a standardized connector that lets any ODBC-aware application read and write live Amazon Redshift data over a direct TCP/IP connection—without AWS client libraries—on 32-bit and 64-bit Windows, macOS, and Linux.

How do I connect to Amazon Redshift using ODBC?

To connect to Amazon Redshift, you can use Devart ODBC Driver for Amazon Redshift. Download the Driver and install it by following the wizard's instructions. Create a DSN using your Redshift server/host, port (default 5439), database, and credentials, then point any ODBC-compliant tool—Power BI, Tableau, Excel, and others—at that DSN.

How is Devart ODBC Driver different from the AWS-provided Amazon Redshift ODBC driver?

Devart ODBC Driver adds 32-bit support (AWS is 64-bit only). Also, it is a cross-platform connector that can be used on Windows, macOS, and Linux (including Ubuntu/DEB). The ODBC Driver by Devart provides SSH and HTTP/HTTPS tunneling, a cross-platform GUI configurator, nightly builds with hotfixes, and dedicated commercial support.

Do I need to install the Amazon Redshift client software?

No. The Driver connects directly over the PostgreSQL-compatible protocol (default port 5439); no Redshift client libraries or additional software are required.

Does the Driver work with both Redshift provisioned clusters and Redshift Serverless?

Yes. Both expose a PostgreSQL-compatible endpoint (default port 5439), and the Driver connects over that protocol—so it works with provisioned clusters and Serverless endpoints alike.

Which authentication and security methods are supported?

The Driver supports authentication with Redshift database credentials, with AWS IAM credentials and an IAM role, or through browser-based single sign-on, including PingOne. The connection is secured with SSL/TLS (including password-protected private keys), SSH tunneling, or HTTP/HTTPS tunneling with bearer token support. DSN passwords are stored encrypted.

Can I configure the Driver with a GUI on macOS and Linux?

Yes—since version 4.0, the Driver includes a graphical configuration tool for macOS and Linux, in addition to the one provided for Windows.

Which operating systems does Devart ODBC Driver for Amazon Redshift support?

The Driver ships in both 32-bit and 64-bit versions for Windows, macOS (including Apple Silicon), and Linux. If you need the Amazon Redshift ODBC Driver for a 64-bit system, choose the appropriate installer on the Download page.