DBMS Support and Connectivity Options

From DBArtisan
Jump to: navigation, search

Go Up to Prerequisites and Preliminary Tasks

Dedicated Support Connectivity Options

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

Greenplum

-

IBM DB2 for z/OS

v9.x, v10.x, and v11.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

v9.x, v10.x and v11.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*, and 2016*
(* 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

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, and 12c*
(* Supports only a subset of this database version's features/functions.)

Oracle SQL*Net Client

Oracle JDBC Thin Driver

-

PostgreSQL

9.3 and 9.4
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/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.

IDERA Team Server 2016 Support

DBArtisan can make use of datasource definitions stored on an IDERA Team Server 2016.

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.

Specifically-tested JDBC/ODBC Connectivity Products: Apache Hive/Hadoop

DBArtisan has been successfully tested against Apache Hive/Hadoop datasources using the Hortonworks ODBC driver. Similarly, Cloudera Impala datasources have been tested using the Cloudera JDBC driver. In both cases, SQL querying and a Datasource Navigator/Explorer tree are available.

DBMS Versions no Longer Supported

As of this release, DBArtisan is no longer being tested against Sybase ASE versions before 15.7.
Personal tools
In other languages