DBMS Support and Connectivity Options
Go Up to Prerequisites and Preliminary Tasks
Dedicated Support Connectivity Options
Rapid SQL provides dedicated connectivity to a specific version range of Amazon Redshift, IBM DB2 for Linux, Unix, and Windows, IBM DB2 for z/OS, Microsoft SQL Server, MySQL, PostgreSQL, Oracle, Sybase, and Teradata databases. The following connectivity options are provided:
- Native IDERA drivers: Rapid SQL is packaged with a set of native drivers, each requiring a DBMS-specific client to be installed.
- JDBC drivers: Rapid SQL can connect to a datasource more directly using one of the packaged, third-party JDBC drivers. No additional connectivity components need to be installed. One or more third-party drivers, tested against Rapid SQL, are installed with Rapid SQL.
The following table provides a summary of resources/requirements for connectivity to dedicated DBMS platforms. For each platform, it lists supported versions, the client software that must be installed if using native IDERA clients, and the third-party, Type 4 JDBC drivers packaged with Rapid SQL.
DBMS Platform | Supported Versions | Client Required for use with native IDERA drivers | Packaged JDBC Driver | Source & License |
Amazon Redshift |
- |
- |
- |
- |
IBM DB2 for z/OS |
10.x and 11.x* |
DB2 UDB Client for Windows 8.0 or later |
IBM Data Server Driver for JDBC |
- |
IBM DB2 for LUW |
10.x and 11.x* |
IBM DB2 LUW Client for Windows 8.0 or later |
IBM Data Server Driver for JDBC |
- |
Microsoft SQL Server |
2008, 2012, 2014*, 2014 SP2*, 2016*, 2017*, 2019*, and 2022* |
Microsoft SQL Server Client Library |
jTDS Type 4 JDBC Driver for Microsoft SQL Server Microsoft SQL Server JDBC Driver |
|
MySQL |
4.x, 5.x*, and 8.x* |
MySQL Connector/ODBC Driver 5.2.x Driver - MySQL Connector/ODBC Driver 3.51.x Driver |
MySQL Connector/J JDBC Driver |
GPL, source & license |
Oracle |
10g, 11g, 11g R2, 12c, 12c R2, 18c, and 19c |
Oracle SQL*Net Client |
Oracle JDBC Thin Driver |
- |
PostgreSQL |
9.3 - 9.10, 10.7, 11.2, 12.x, and 14.x |
PostgreSQL ODBC Driver (latest version recommended) |
PostgreSQL JDBC Driver |
BSD, license |
Snowflake |
- |
Snowflake ODBC Driver, source |
Snowflake JDBC Driver shipped with product, source |
- |
Sybase ASE |
15.7, and 16.0 |
Sybase Open Client |
jTDS Type 4 JDBC Driver for Microsoft SQL Server |
|
Sybase IQ |
15.4, 16.0, and 16.1 |
SQL Anywhere ODBC drivers for Sybase IQ 12.7 |
Sybase jConnect JDBC Driver for Sybase IQ |
- |
* About Technical Previews - Technical previews are intended to introduce a new DBMS platform only. The available functionality is typically minimal. For example, command Line startup, standard datasource registration and connection features, limited Datasource Navigator tree functionality, a minimal set of object actions, as well as SQL Editor execution and related, common SQL Editor functionality such as Query Options, Paste SQL Syntax, and Paste SQL Statement.
Generic JDBC/ODBC Connectivity
Generic JDBC/ODBC connectivity to non-dedicated DBMS systems or non-database datasources is also provided. Rapid SQL can connect to a datasource using a customer-provided, third-party JDBC version 4.0 or ODBC version 3.0 driver. Minimal Rapid SQL functionality is provided, including a basic Explorer tree and SQL querying.
IBM DB2 for z/OS Stored Procedure Requirements
When working against an IBM DB2 for z/OS data source, Rapid SQL relies on the following stored procedures, provided as an optional installation step in setting up the DB2 subsystem:
DSNWZP
DSNUTILS
ADMIN_COMMAND_DSN
ADMIN_COMMAND_DB2
Prior to using Rapid SQL against an IBM DB2 for z/OS data source, ensure that these components are installed on the server. See IBM DB2 for z/OS documentation for more information.