Supported Database Platforms
Go Up to Main Page
ER/Studio Data Architect supports the following database platforms:
|
Database |
Version |
|---|---|
|
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, 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 SQL Server |
6.5, 7, 2000, 2005, 2008, 2012, 2014, 2016, 2017, 2019, 2022 |
|
Microsoft Visual FoxPro |
2, 3, 5 |
|
2.6, 3.0, 3.2, 3.4, 3.6, 4.x | |
|
MySQL |
3.x, 4.x, 5.x, 8.0 |
|
Oracle |
7.x, 8.x, 9i, 10g, 11g, 12c, 18c, 19c, 23ai / 23c |
|
ODBC / ANSI SQL |
|
|
PostgreSQL |
8.x, 9.x, 10.x, 11.x, 12.x, 16.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 |
|---|---|---|
|
Google BigQuery |
BigQuery ODBC |
Magnitude Simba |
|
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 Azure SQL DB |
Microsoft SQL Server Native Client 11 Microsoft ODBC 17 |
Microsoft |
|
Microsoft Azure Synapse |
Microsoft SQL Server Native Client 11 Microsoft ODBC 17 |
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.