Follow these steps to setup a new database connection and connect to it.
-
Select the 'Connection' item from the main menu bar then select 'New' from the menu drop down. This
will bring up the Connection Configuration screen.
-
Enter a 'Connection Alias' in the first text field. The connection alias is used
to identify the database connection that you are setting up so make sure to enter a name
that has meaning to you; for example, 'Customers - Development' or 'Finance - Production'.
-
Select the 'JDBC Driver' in the drop down that matches the database you are setting the
connection up for. If you do not see your database listed then refer to the
'Installing JDBC Drivers' section of this document.
-
Enter the connection information for your database in the 'Driver parameters' section. If you are familiar
with JDBC driver set up you can select the 'Advanced' option to enter the JDBC URL directly.
-
Enter the 'Username' and 'Password' to use for the connection in the 'Logon Credentials' section. If you
would prefer to be prompted for the username and password when you open the connection the select the
'Prompt for Username and/or password' checkbox.
-
Click the 'Test' button to make sure the connection is set up correctly. If you see a dialog that says
'Connection opened successfully' everything is working. Click the 'OK' button to dismiss the dialog and
then press the 'OK' button on the Connection Configuration screen to compelete the set up. If the
connection test indicated an error then review that everything was entered correctly.
-
Select the 'Connection' item from the main menu bar then select 'Open' from the menu drop down. Select the
connection alias name that you just set up and press 'OK'. You now have an open connection to your database.
