Adding an Oracle connection

To add a generic Oracle connection:

  1. On the Manage Data Sources page.
  2. Click New and select Oracle as the connection type.
  3. Specify a name for the data source. The name must be unique.
  4. Select Model as the category.
  5. To define the Relational Connection:
    1. Specify the user name of the schema owner.
    2. Specify the password for the administrator user.
    3. Specify the name of the host computer on which the Oracle software is installed.
    4. Specify the name of the Oracle service.
    5. Specify the port number. The default is 1521.
    6. Select the database to connect to the data source. If necessary, click Refresh to update the list of available databases.
    7. Specify the TNS name. This name is required and must be set up in the tnsnames.ora file. The TNS name in the tnsnames.ora file includes the host name, service name, and port number for each TNS name.
    8. Select the appropriate driver.
  6. Click Test Connection.
  7. Click Save.