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 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.
Note: For SQL Server using TLS 1.2, the ER/Studio Data Architect client machine requires installation of the latest SQL Server native client driver.
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:
|
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 |