New/Update Database Connection

This dialog box is displayed when you attempt to add or edit a database connection for use in an import or export operation. For import operations from a data dictionary, you can connect to an Oracle database or a supported third-party database. For export operations, you can connect to an Oracle Database, for use as the Data Modeler reporting repository (which is explained in Data Modeler Reports).

When you have finished entering the connection information, test the connection, as explained in After Specifying the Connection Information.

Some of the following fields apply only to certain kinds of database connections.

Connection Name: An alias for a connection to the database using the information that you enter. (The connection name is not stored in the database, and the connection is not a database object.) Suggestion: Include the database name (SID) and user name in the connection name. Example: personnel_herman for connecting to the personnel database as user Herman.

User Name: Name of the database user for the connection. This user must have sufficient privileges to perform the tasks that you want perform while connected to the database, such as creating, editing, and deleting tables, views, and other objects.

Password: Password associated with the specified database user.

Save Password: If this option is checked, the password is saved with the connection information, and you will not be prompted for the password on subsequent attempts to connect using this connection.

The remaining fields are grouped under tabs according to the database type. See Oracle tab or Other databases (third-party) tabs.

Oracle tab

The following information applies to a connection to an Oracle database.

Role: The set of privileges to be associated with the connection. For a user that has been granted the SYSDBA system privilege, you can specify a connection that includes the privilege.

Connection Type: Select Basic, TNS, or Advanced. (The display of fields changes to reflect any change in connection type.)

Basic connection type

Host Name: Host system for the Oracle database.

Port: Listener port.

SID: Database name.

Service Name: Network service name of the database (for a remote database connection over a secure connection).

TNS connection type

Network Alias: Oracle Net alias for the database. (The list for selecting a network alias is initially filled from the tnsnames.ora file on your system, if that file exists.)

Connect Identifier: Oracle Net connect identifier.

Advanced connection type

Custom JDBC URL: URL for connecting directly from Java to the database; overrides any other connection type specification. If you are using TNS or a naming service with the OCI driver, you must specify this information: Example:

jdbc:oracle:thin:scott/@localhost:1521:orcl

Note that in this example, the "/" is required, and the user will be prompted to enter the password.

To use a custom JDBC URL, the system on which Data Modeler is running must have an Oracle Client installation that contains the JDBC and orai18n libraries, is present on the path, and is version 10.2 or later.

Other databases (third-party) tabs

The following information applies to a connection to a third-party (non-Oracle) database.

Host Name: Host system for the database.

Port: Listener port.

Database: Database name.

JDBC-ODBC Bridge or Other Third Party Driver (JDBC ODBC Bridge tab): Indicates a JDBC to ODBC bridge driver or another third-party driver.

ODBC Alias (JDBC-ODBC Bridge): Name of an existing ODBC data source.

JDBC URL (Other Third Party Driver): URL for connecting directly from Java to the database; overrides any other connection type specification.

Driver Class (Other Third Party Driver): The name of the driver class that will be used for the connection (for example, com.microsoft.jdbc.sqlserver.SQLServerDriver). This name can be found in the JDBC driver specification (usually shipped with the driver).

After Specifying the Connection Information

To test the connection using the specified information, click Test Connection. A message is displayed indicating the result of the test.

To add the new connection or to complete any edits to an existing connection, click OK.