Supported Database Platforms

From ER/Studio Data Architect
Jump to: navigation, search

Go Up to Main Page

ER/Studio Data Architect supports the following database platforms:

  • Firebird® 1.5, 2.x
  • Greenplum 4.2*
  • Hitachi HiRDB*
  • Hadoop Hive 0.12, 0.13
  • IBM® DB2® 5.x - 10.x for LUW and z/OS®* & iSeries V4R5 and V5R2*
  • IBM Informix® OnLine and SE
  • Informix 9.x dynamic server
  • InterBase® 4, 2007, 2009
  • InterBase XE, XE3
  • Microsoft® Access 2.0, 95, 97, 2000
  • Microsoft SQL Server 6.5, 7, 2000, 2005, 2008, 2012, 2014
  • Microsoft Visual FoxPro® 2, 3, 5
  • MongoDB 2.4, 2.6, 3.0
  • MySQL® 3.x, 4.x, 5.x
  • Netezza 4.6, 5.0, 6.0, 7.0*
  • Oracle® 7.3, 8.x, 9i, 10g, 11g, 12c
  • ODBC / ANSI SQL
  • PostgreSQL 8.x, 9.x*
  • Sybase® Adaptive Server® Enterprise (ASE) 11.9.2, 12.x, 12.5, 15.0
  • Sybase Adaptive Server Anywhere (ASA) 5, 6, 7, 8, 9, 10
  • Sybase IQ 12.x, 15.x, 16.x
  • Sybase Watcom SQL
  • Teradata® V2R4, V2R5, V2R6, 12, 13.0, 14.x*


Notepad blue icon 2.pngNote: ER/Studio DA Developer's Edition does not support database platforms marked with a * below.


ER/Studio Data Architect sometimes refers to IBM platforms by their old names:

Name used in ER/Studio DA

Now known as

IBM DB2 AS/400

IBM DB2 iSeries

IBM DB2 UDB

IBM DB2 LUW

IBM DB2 UDB for OS/390

IBM DB2 z/OS


Database Connectivity

The following table describes the necessary client software needed to successfully connect to a target database.

When selecting client software, make sure the DBMS version matches the client software version. In cases where the client libraries are backward compatible, the latest client version is recommended. Please refer to the DBMS vendor for specific client software and the database versions for which it is supported.

Database

Required Client Libraries

Vendor

Hitachi HiRDB

Hitachi ODBC

Hitachi

IBM DB/2 OS/390 / IBM DB2 LUW

IBM DB2 Connect

IBM

IBM AS/400

IBM Client Access for AS/400

IBM

Informix OnLine and SE

Informix-Cli and ODBC

Informix Software, Inc. and Intersolv, Inc.

InterBase

ODBC

Embarcadero Technologies, Inc.

Microsoft Access

Access ODBC

Microsoft

Microsoft SQL Server

SQL Server Client Tools

Microsoft

Microsoft Visual FoxPro

FoxPro ODBC

Microsoft

MySQL

MySQL ODBC

MySQL

Netezza

ODBC

Netezza Corporation

Teradata

Teradata ODBC

Teradata

Oracle

SQL*Net or Net8 with configuration files (hosts, tnsnames.ora)

Oracle

PostgreSQL

PostgreSQL ODBC

Postgre

Sybase ASA

Sybase ASA ODBC

Sybase

Sybase ASE

Sybase Open Client

Sybase

Sybase Adaptive Server IQ

Sybase ASA ODBC

Sybase

Sybase Watcom SQL Anywhere

SQL Anywhere ODBC

Sybase

See Also