Define database connection information

The database connection information specifies the JDBC settings that used to connect to a database, such as database name, user name and password.

Select the menu “Settings | Database Connection Information…” to display the “Define Database Connection Information” dialog box.

Click “Add” button to open the “New Connection Information” wizard:

Please enter a descriptive name for the database. The name is used to identify the database and its connection information. Then, click “Next” button to go to “Select JDBC provider” page.

Choose a proper JDBC provider in this page, then click “Next” button.

Assuming that we selected an Oracle JDBC provider, the next page will display Oracle specific information:

Please enter database server name, and Oracle system identifier (SID) for the database. The default server port is 1521. Change it if your database uses a different port. Then, click the “Next” button to enter the remaining information.

Please enter the user name and password. Note that the wizard automatically populates the driver class name, and connection URL fields based on the information in previous page.

For Oracle, DB2, Microsoft SQL server, Sybase, MySQL and PostgreSQL databases, the wizard almost automates everything. For other types of databases, you have to specify these parameters manually in this page. The information should be easily available in the corresponding JDBC driver documents.

Click “Finish” button to save the definition. The wizard will make a test connection to make sure the information is correct. The “Define Database Connection Information” dialog box will be refreshed as following:

You can define connection information for more databases as needed. The following shows connection information defined for DB2, Microsoft SQL server, Sybase SQL Anywhere, Sybase Adaptive Server Enterprise, MySQL and PostgreSQL databases.

The “Database Explorer” in the left pane of the main window lists these databases as tree nodes. Open any database node will display the tables, views and synonyms in the database. For Oracle, DB2, Microsoft SQL Server, Sybase, MySQL and PostgreSQL databases, additional nodes, such as sequences, stored procedures and packages, are also displayed based on whether the database supports these objects.

That’s all to setup SQL Edge®. Now you can move ahead to the Users Guide to review information about how to use it.