Supported Database Platforms
Go Up to Main Page
ER/Studio Data Architect supports the following database platforms:
- Amazon Redshift
- Embarcadero InterBase XE, XE3, 2007, 2009
- Firebird 1.5, 2.x
- Greenplum 4.2
- Hadoop Hive 0.12, 0.13
- Hitachi HiRDB
- IBM Db2 Common Server
- IBM Db2 for iSeries V4R5 and V5R2
- IBM Db2 for LUW 5.x - 10.x
- IBM Db2 for z/OS 5.x - 11.x
- IBM Informix Dynamic Server 9.x
- IBM Informix OnLine and SE
- IBM Netezza 4.6, 5.0, 6.0, 7.0
- Microsoft Access 2.0, 95, 97, 2000, 2013
- Microsoft Azure SQL Database
- Microsoft Azure Synapse Analytics
- Microsoft SQL Server 6.5, 7, 2000, 2005, 2008, 2012, 2014, 2016, 2017, 2019
- Microsoft Visual FoxPro 2, 3, 5
- MongoDB 2.6, 3.0, 3.2, 3.4, 3.6
- MySQL 3.x, 4.x, 5.x, 8.0
- Oracle 7.x, 8.x, 9i, 10g, 11g, 12c, 18c, 19c
- ODBC / ANSI SQL
- PostgreSQL 8.x, 9.x, 10.x, 11.x, 12.x
- SAP Adaptive Server Anywhere (ASA) 5, 6, 7, 8, 9, 10
- SAP Adaptive Server Enterprise (ASE) 11.9.2, 12.x, 15.0
- SAP IQ 12.x, 15.x, 16.x
- Snowflake
- Teradata V2R4, V2R5, V2R6, 12, 13.0, 14.x, 15.10
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 |
IDERA, 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.