Connecting to a Database

Edit online

About this task

To connect to a database in the Data Source Explorer view, do the following:

To connect to a database in the Data Source Explorer

Procedure

  1. If the Data Source Explorer view is not visible:

    Window > Show View > DataSource Explorer.

  2. In the Data Source Explorer, click The Database Profile iconNew Connection Profile.
  3. In New Connection Profile page, select the Connection Profile Type and click Next.
  4. In Specify Driver and Connection Details, from the Drivers list, select a driver, and then click Next.
  5. In Select a driver from the dropdown, choose the appropriate database driver.
  6. In the URL field, type the URL for the database, including the database name. For example: 
    jdbc:wm:sqlserver://localhost:1433;DatabaseName=Northwind
  7. In the User Name field, type the valid user name for the database.
  8. In the Password field, type the password.
  9. Click Test Connection to test the connection to the database.
  10. Click Finish.
  11. Right-click the node, and click Connect.