Supported Database Platforms
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*
Note: 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 |
- For information on connecting to databases in ER/Studio Data Architect, see Connecting to Database Sources and Targets.