Creating a Database Connection Profile

Procedure

  1. Click the Data Source Explorer view.
  2. Right-click Database Connections and select New. The New Connection Profile wizard is displayed.
  3. Select the type of database connection you want to create - either Oracle, SQL > Server or DB2 for Linux, UNIX and Windows.
  4. Enter a Name and, optionally, a Description (optional), then click Next. The Specify a Driver and Connection Details page is displayed.
  5. Select an appropriate driver from the Drivers drop-down list. If one does not exist, you must define a new driver. To do this:
    1. Download and install the appropriate JDBC drivers for the type of database you want to use.
    2. Click . The New Driver Definition dialog is displayed.
    3. On the Name/Type tab, select one of the available driver definition templates. This populates the Driver name and Driver type fields.
    4. Click the Jar List tab.
    5. Select any .jar files that are listed and click Remove JAR/Zip to delete them.
    6. Click Add JAR/ZIP. A file selection dialog is displayed.
    7. Browse to the location of your JDBC drivers. Select the appropriate .jar files and click Open. The selected .jar files are displayed on the Jar List tab.
    8. Click OK to return to the New Connection Profile wizard.
  6. The Properties section displays default connection details for the selected driver. Edit these as required with the appropriate information for the database you want to connect to. See Mapping the Result Set.
  7. Click Test Connection to verify that you can connect to the database using the details you entered.
  8. Optionally, select Save password to avoid having to enter the database password each time you connect.
  9. Click Finish.
  10. The new connection profile is added to the list of Databases in the Data Source Explorer view.