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

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*, and 2017*
(* 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, and 12c R2

Oracle SQL*Net Client

Oracle JDBC Thin Driver

-

PostgreSQL

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

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.

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.
Personal tools