Create Database Connection

Use this dialog box to create a database connection.

Connection Name: A descriptive name or alias for the connection. Example: HR_Local

Connection type: Type of database to which to connect: Oracle (JDBC) or JDBC ODBC Bridge.

Username: Name of the database user for the connection. This user must have sufficient privileges to perform the tasks that you want to perform while connected to the database.

Password: Password associated with the specified database user.

Role: Database role (if any) associated with the user.

Save Password: Specify whether to save the password with the connection information. If the password is saved, users of the connection will not be promoted to enter the password.

Oracle (JDBC) Settings

Enter Custom JDBC URL: If you select this option, enter the 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.

Driver: thin (JDBC driver) or oci8 (thick) (if available)

Host Name: Host system for the Oracle database. Example: localhost

JDBC Port: Listener port. Example: 1521

SID: Database name. Example: orcl

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

JDBC-ODBC Bridge Settings

Datasource Name: Name of an existing ODBC data source.

Extra Parameters: Additional parameters for the connection.

Test Connection: Performs a test of the connection, and indicates success or a specific error.