Operations for the database proceed as follows:
Prepare for the database
Create the database environment
A database server is required. The server side environment for the server used for the database is described here.
Install the JDBC driver
In order to access the database from the workbench, the JDBC driver must be installed.
Connect to the database
Use the following procedures to connect to the database:
Switch perspectives
Switch to the perspective used for database development.
Create connection profile
Create the connection profile for the prepared database environment.
Connect to the database
Use the defined connection profile to connect to the database.
Create a table
Use the following procedure to create a database table:
Switch perspectives
Switch to the perspective for creating the SQL file.
Create a project
Create a project for storing the SQL file.
Create an SQL file
Use the wizard to create the SQL file.
Edit the SQL file
In the SQL file, code the SQL statement that creates a table.
Execute the SQL
Execute the SQL statement that is coded in the SQL file.
Check the table
Switch perspectives
Switch the perspective in order to check the database definition information.
Check the table definitions
Use the Data Source Explorer view to check the definition information of the created table.
Reference the table data
Use the Table Data editor to check the table data.
