If you expand the Databases folder in the view, you should see the connection profile you just created, and any other connection profiles you've created.
4.  Right-click the connection profile you just created, click 'Connect' (see Figure 13)

If the connection is successful, you should see results similar to the image below. The tables for the SQL Anywhere sample database are located in the GROUPO schema, so expand 'demo' | Schemas' | 'GROUPO' | 'Tables' and you should be able to view all of your tables. You can also expand any table for a list of columns and column-types (see Figure 14).

The Data Source Explorer offers a great deal of functionality in itself. Right-clicking on any object lets you generate DDL for that object. In the image above, generating DDL for the object 'demo' (top of the tree) will generate DDL for the entire database, whereas generating DDL for the table 'Contacts' will just give you the DDL pertinent to that table. This tool can be used to generate a data definition of any data source you can connect to. Right-clicking on a table or view also gives you a 'Data' sub-menu. From this sub-menu, you can choose to edit the information in that table or view, or sample its contents.

Querying the SQL Anywhere Database
First we must open the SQL Results view. This view is a window view that will be populated with data in table format when a query is executed.
1.  Click 'Window' | 'Show View' | 'Other'
2.  Choose 'SQL Development' | 'SQL Results' (see Figure 15)
3.  Click 'OK'

Next we must open a new SQL File, which we can use to create and execute SQL commands.
4.  Click 'File' | 'New' | 'Other'
5.  Choose 'SQL Development' | 'SQL File'
6.  Click 'Next' (see Figure 16)

We must now specify what project this SQL File will belong to and what connection profile it will be executed against.
7.  Fill out the form as show below; be sure to choose the right connection profile and database name. Create a new general project if necessary (see Figure 17).
8.  Click 'Finish'
9.  Enter any SQL statement into your new SQL File
  •   For example - "SELECT * FROM Customers"
10.  Save this file, right-click anywhere in the SQL File window, and choose 'Execute All' (see Figure 18)

If your SQL statement executes successfully, you should see the results of the statement in the Results view that we opened earlier. If the statement was a query, the Results view will display the returned records. If it's not a query, you'll be notified of the statement's success and how many rows were affected. Query results should look like the image below (see Figure 19).

This wraps up the tutorial. You may now close Eclipse and shut down the demo database we started earlier.

Summary
In this tutorial, we learned how to:
  •   Define a driver template
  •   Create a connection profile
  •   Connect to a SQL Anywhere 10 database
  •   Run SQL statements against a SQL Anywhere 10 database from within the Eclipse IDE

The activities we walked through in this tutorial are just an introduction to some of the features available in the DTP framework and tools. We hope it will give you enough familiarity to continue exploring on your own. Since DTP is an open source project, it depends on involvement from the community to a large extent. Please feel free to contribute bug reports, feature requests, and general comments to the DTP project team. Their project home page is located at www.eclipse.org/datatools.