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