Connecting to a Database

Once you have established your connection profile, you can connect to your database from the Data Source Explorer view.

This procedure describes how to connect to your database.

 

 

Instructions on how to complete a procedure

To connect to your database:

  1. Open the Database Development perspective by going to Window | Open Perspective | Other | Database Development.

  2. In the Data Source Explorer view, expand the SQL Databases node and right-click your connection profile.
    To edit the properties of the Connection Profile, right-click it and select Properties.

  3. Click Connect.

  4. Once the connection has been established, you can expand the tree underneath your Connection Profile to view the contents of the database.

Data Source Explorer

To see a sample of the data in the tables, right-click one and select Data | Sample Contents.
The SQL Results view will open with a sample list of the data from your table.

SQL Results view

 

For more information on the Data Tools Platform, please see the Data Tools Platform User Documentation .

Note:

Additional user guides can be accessed from inside Zend Studio by going to Help | Help Contents, or from the Eclipse Online Documentation site (http://help.eclipse.org/neon/index.jsp).

 

 

Related Links:

Using the Data Tools Platform

Creating and Executing an SQL Query