Using Native or Direct Database Connections
Go Up to Connecting to Database Sources and Targets
Using a native or direct database connection you can reverse engineer all the database objects supported by MS SQL Server, IBM DB2 for z/OS, IBM DB2 for LUW, Oracle, and Sybase ASE. To connect to these databases you must first install the corresponding DBMS client utility software available from your database vendor.
- On the machine running ER/Studio Data Architect, install the RDBMS client utility software that is available from your database vendor.
- The following table lists the databases you can connect to using native or direct connections and the RDMBS client utility software required.
Database |
Required RDBMS Client Utility Software |
---|---|
IBM DB2 for z/OS 5.x, 6.x, 7.x, 8.x, 9.x, and 10.x |
IBM DB2 Connect |
IBM DB2 for LUW 5.x, 6.x, 7.x, 8.x, 9.x, 10.x Server |
Corresponding version of IBM DB2 Client Utilities |
IBM DB2 for AS/400 V4R5 and V5R2 |
Corresponding version of IBM DB2 Client Utilities |
Microsoft SQL Server 4, 6, 7, 2000, 2005, 2008, 2012, 2014 |
Corresponding version of SQL Server Client Access |
Oracle 7.x, 8.x, 9i, 10g, 11g and 12c |
Corresponding version of Oracle Client Utilities |
Sybase ASE 11, 11.5, 11.9, 12..0, 12.5, and 15.x |
Sybase Client Utilities 11.9 or later |
- Provide to your ER/Studio Data Architect users the data source connection strings required for your databases so they can enter them in the Data Source fields of the Reverse Engineer, DDL Generation or Compare and Merge wizards.
Database |
Required Data Source Connection String |
---|---|
IBM DB2 for z/OS |
|
IBM DB2 for LUW |
Use the ODBC data source you have specified in the ODBC Data Source Administrator. |
MS SQL Server |
Use the server name. |
Oracle |
Use the SQL*Net connection string or an alias if you have defined one in:
|
Sybase ASE |