Connection Manager

With Connection Manager you can define and configure database connections.

Connection Name: This is the name that you assign to the database connection.
UserName & Password: This the username and password of your database.
Database Url: This is the same URL that is used in the JDBC to access the database and it goes like eg:

jdbc:mysql://localhost/mydatabase (for mysql)

jdbc:oracle:thin:scott/tiger@myhost:1521:orcl (for oracle)

Driver File: It is the location of the file which contains database driver (driver/classes12.jar, d:\ztor_sqldc\drivers\jdbc_mysql.jar, ...)

On entering all the details click on Test button. The status of the connection can then be seen.

You can save the current configuration for later use.

Working with connection tree

The Connection tree shows the preconfigured database connection.

To connect to any database double click on the db icon, upon which you will be required to enter a password

You can then use the pre-saved SQL by selecting the scripts from the drop down on right corner and run them. Upon right clicking on the predefined connection, you get the option disconnect from the database. For an active database connection the db icon is highlighted and for an unconnected one it is lightly jaded

Script Manager

Script Manager can be accessed by navigating through File--> Script Manager.

The basic idea of the script manager is to store frequently used sql's in script to be used later again for a particular connection.

Script Name: The name you want to assign the sql script file.

Use Connection: The script gets stored for the particular connection.

The SQL is typed in the Script Body and saved with a name for a particular connection that you have defined previously. When you are in the main menu and using a particular connection, the script can be retrieved from the drop down box on the upper right corner as shown below. The script can then be retrieved quickly and run.

Multiple SQL statements can be stored in the sql script separated by semi-colon's (" ; " ) and run separately by selecting highlighting the sql statement.

Preferences

In this tab user preferences can be stored.

It can be accessed by navigating through Tools-->Preferences. The user can specify which delimiter the result has to be stored in. The user also has the option to modify the look and feel of SQLDC application. The application can be limited to fetch a certain amount of records by specifying the Limit To Fetch Rows parameter. Support for multiple languages can be built into the application also.

Export result

To export the results please navigate through Tools-->Export Results

The result of the query can be stored in a comma delimited file or as an html sheet at any location. Please note that only visible result set can be exported