Using Native or Direct Database Connections

From ER/Studio Data Architect
Jump to: navigation, search

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

  • 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:

  • Oracle SQL*Net Easy Config
  • Oracle Net8 Easy Config
  • Oracle Net8 Configuration Assistant

Sybase ASE

See Also

Retrieved from "https://docwiki.embarcadero.com/ERStudioDA/XE5/e/index.php?title=Using_Native_or_Direct_Database_Connections&oldid=2876"