Using_Native_or_Direct_Database

Using Native or Direct Database Connections

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. (For information on the client utility versions supported, see “ER/Studio Repository Database Server Requirements” in the ER/Studio Repository Installation and Administration Guide.)

1. On the machine running ER/Studio DA, 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, and 9.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	Corresponding version of SQL Server Client Access
Oracle 7.x, 8.x, 9i, 10g, and 11g	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

2. Provide to your ER/Studio DA 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 SQLNet connection string or an alias if you have defined one in: • Oracle SQLNet Easy Config • Oracle Net8 Easy Config • Oracle Net8 Configuration Assistant
Sybase ASE