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 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
Greenplum				-
IBM DB2 for z/OS	9.x - 10.x, and 11.x* (* Supports only a subset of this database version's features/functions.)	DB2 UDB Client for Windows 8.0 or later	IBM Data Server Driver for JDBC	-
IBM DB2 for LUW	9.x - v10.x, and 11.x* (* Supports only a subset of this database version's features/functions.)	IBM DB2 LUW Client for Windows 8.0 or later	IBM Data Server Driver for JDBC	-
Microsoft SQL Server	2008, 2012, 2014*, 2016*, 2017*, 2019* (* Supports only a subset of this database version's features/functions.)	Microsoft SQL Server Client Library	jTDS Type 4 JDBC Driver for Microsoft SQL Server Microsoft SQL Server JDBC Driver	LGPL source, license
MySQL	4.x, 5.1*, and 5.7.18* (* Supports only a subset of this database version's features/functions. When creating a connection to 5.1 and later, use the 4.x option.)	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	9i, 10g, 11g, 12c, 12c R2, 18c, and 19c	Oracle SQL*Net Client	Oracle JDBC Thin Driver	-
PostgreSQL	9.3, 9.4, 9.6.x, and 11.2 Specifically-supported PostgreSQL-based database products include Greenplum, Pivotal HAWQ, and BigSQL.	PostgreSQL ODBC Driver (latest version recommended)	PostgreSQL JDBC Driver	BSD, license
Sybase ASE	12.5 - 15.7, and 16.0	Sybase Open Client	jTDS Type 4 JDBC Driver for Microsoft SQL Server Sybase jConnect JDBC Driver	LGPL, source, license
Sybase IQ	12.7 - 15.4, and 16.0	SQL Anywhere ODBC drivers for Sybase IQ 12.7 Sybase IQ 32-bit ODBC drivers	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.