Simba Amazon Redshift ODBC and JDBC drivers offer direct, industry-standard SQL-92 access to data stored in a Redshift data warehouse.
Simba ODBC and JDBC drivers for Redshift deliver seamless connectivity and enable powerful analytics on all major platforms, without the need for complicated data extraction. Using the Simba Amazon Redshift ODBC and JDBC connectors, you can enjoy scalability, full BI tool functionality, and real-time analytics. The Simba Amazon Redshift ODBC and JDBC connectors are built on the Simba SDK platform, the industry-leading dev environment for ODBC and JDBC connector development.
The Simba ODBC connector for Redshift complies with the latest ODBC 3.80 data standard and adds important functionality such as Unicode and 32- and 64-bit support for high-performance, cloud computing environments. The Simba JDBC connector for Redshift includes support for JDBC 4.2.
Features
- Seamless connection between ODBC/JDBC compliant BI tools and your data in Amazon Redshift
- Configurable Query Processing Modes: Single Row, Bulk Fetch, Concurrent Queries, and Entire Results Set
- Multiplatform support, including Windows, Mac and major Linux distributions
- Encrypted communication with Amazon Redshift over SSL
- Mapping between common data types in Amazon Redshift and ANSI SQL data types
- Supports TCP keepalives to prevent connections from timing out
- Flexible connector level logging and ODBC tracing
Specifications
- ODBC 3.80 Support
- JDBC 4.2 Support
- Unicode Support
- Support for 32- and 64-bit platforms
- Supported on Windows 8, or 8.1, Windows Server 2012, or 2012 R2
- Supported on Red Hat Enterprise Linux 7, CentOS 7, SUSE Enterprise Server 12, Ubuntu & Debian
- Support for iODBC 3.52.7 or later, or unixODBC 2.3.0 or later
- Support for Mac OS X 10.14
- Support for Amazon Redshift Spectrum
- Support Amazon EC2 instance profile