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 a specific platform. To connect to these databases you must first install the corresponding DBMS client utility software available from your database vendor, in the cases it is needed.

The following table lists the databases platform you can connect to using native or direct connections and the RDMBS client utility, when required.

Database Platform Required RDBMS Client Utility Software
IBM DB2 for z/OS 5.x, 6.x, 7.x, 8.x, 9.x, 10.x, and 11.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, 2016, 2017 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
Azure SQL DB No client utility required
Hive 0.12, 0.13 (on IBM BigSQL, Hortonworks, Cloudera) No client utility required
MongoDB 2.4, 2.6, 2.8, and 3.0 No client utility required

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 Use the server name / IP
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 / IP
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 Use the server name / IP
Azure SQL DB Use the server name / IP
Hive Use the server name / IP
MongoDB Use the server name / IP

See Also

Personal tools
Product Videos