DBMS Support and Connectivity Options

Go Up to Prerequisites and Preliminary Tasks

Dedicated Support Connectivity Options

DBArtisan 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: DBArtisan is packaged with a set of native drivers, each requiring a DBMS-specific client to be installed.
• JDBC drivers: DBArtisan 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 DBArtisan, are installed with DBArtisan.

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 DBArtisan.

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* (* 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	10.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*, 2014 SP2*, 2016*, 2017*, and 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.x*, and 8.x* (* 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	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, and 12.x 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	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	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/Explorer 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. DBArtisan can connect to a datasource using a customer-provided, third-party JDBC version 4.0 or ODBC version 3.0 driver. Minimal DBArtisan 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, DBArtisan 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 DBArtisan 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.