Adding a SQL connection profile for an Oracle database

To add a SQL connection profile:

  1. Select Add Connection Profile in the Connections view.
  2. Type a unique name in the Name field.
  3. Select the Oracle JDBC Driver(DataDirect) from the driver selection list. You can click New Driver if you need to configure a driver. In most cases, however, the driver is installed and configured automatically during installation of Progress DB Navigator. SQL can have multiple JDBC connections. Notice that the format for the selected driver's URL appears in the URL field. If necessary, you can edit the text in the URL field to include the appropriate information for your system.
  4. To edit a URL:
    1. Deselect the Specify URL Details checkbox (by default, this checkbox is selected, preventing you from editing the URL field).
    2. Supply a hostname (use localhost if the host is local to the system).
    3. Type the port number.
    4. Type the database name.
    Note: Since the format of the URL and the required information can vary from driver to driver, see the documentation for your driver if you need more information.
  5. Enter the user name and password.
    Note: You must specify the user ID when creating a SQL connection.
  6. Choose Open on Eclipse startup if you want the connection to open when Eclipse starts (provided the database server is already started).
    Note: You still must enter a valid user ID and password. Also, be aware that this option slows the startup of Eclipse.
  7. Choose Auto-Login on connect to automatically log into the database when connecting.
  8. Type the name of the Host.
  9. Select either Service or Port, and type the correct value.
  10. Type the name of the database in the Database field.
  11. Add any additional JDBC connection properties in the Additional parameters field, delimited by semicolons in the format key1=value; key2=value. (Refer to the documentation for your JDBC driver for a list of supported parameters.)
  12. Click Test Connection to verify connectivity. If the connection succeeds, a Connection succeeded message appears. If the connection does not succeed, an error message appears.
  13. Click OK.
Preliminary Draft
© 2017 Progress Software Corporation and/or one of its subsidiaries or affiliates. All rights reserved.