The configuration to the database depends on the DBMS and the driver being used, that is if an ODBC or JDBC type handler is used.
For connections using JDBC drivers, the files corresponding to the controller must be located in the <O3>/classes/jdbc folder, where <O3> is the installation directory of IdeaSoft O3™ Performance Suite.
For connections using ODBC the corresponding system data source must be defined from the Windows control panel.
Connections are defined through the "Edit Connections" option, in the "Drill Through" entry of O3 Browser "File" menu.
This action displays a new window where we need to choose between local connections or remote connections.
The picture on the right shows this selection.
Once the selection is made, the Connections editor is displayed as shown below
To define a new connection to the database you must follow these steps:
- Right click on the "Connections" label to display the menu.
- Choose the " New Connection" option from the "Add" entry of the menu
- Select the new connection to display the right pane and fill up its properties.
- Try the connection to the database, by pressing the "Verify" button.
The message "Connection established" indicates the connection has been successfully defined. - Save changes with the "Record" button
Field |
ODBC |
JDBC |
|---|---|---|
Name |
It is the name given to the connection. It is referred to from the query definition |
|
User |
Name of the user with query permits on the database |
|
Password |
Password of the user with query permits on the database |
|
Controller |
sun.jdbc.odbc.JdbcOdbcDriver |
Type of controller. It is specified in the documentation of the controller being used |
Type of driver |
SQL |
SQL |
URL |
jdbc:odbc:<DATASOURCE>. Where DATASOURCE is the created ODBC source |
URL to the desired database. It depends on the controller in use and it is stated in its documentation |
Besides adding a new connection in the connections pane, you may modify and / or delete an existing connection.
If you wish to modify an existing connection you have to:
- Select the connection you wish to modify
- Modify the connection properties
- Try the connection to the database pressing the "Verify" button.
The message "Connection established" indicates the connection has been successfully defined. - Save the changes with the "Record" button.
If you wish to delete an existing connection you must:
- Right click on the connection you wish to delete, so as to open the drop down menu.
- Choose the "Delete" option
- Save changes with the "Record" button