Database Connection Tool

The Database Connection diagnostic tool is used to test and verify connectivity between SiteScope and an external ODBC or JDBC compatible database. which uses a supplied JDBC or ODBC driver and URL Connection string to test the connection to a database. This diagnostic tool will check to see if:

the supplied database driver can be found and loaded
a connection can be made to the database
an optional SQL query can be executed and the results displayed
the database connection and resources can be closed

If exceptions or errors occur during the test, the information is printed along with suggested actions to help with troubleshooting. This tool can be useful in verifying connection parameter values needed to setup Database monitors, Database Alerts, and database logging.

Complete the form as shown and click the Connect and Execute Query button to run the connection test.

Database Connection URL: Enter the connection URL to the database you want to connect to, for example: jdbc:odbc:orders
Database Driver: Enter the JDBC or ODBC driver that SiteScope should use. The file, .jar file, or library containing the .class file must be installed in the <SiteScope install path>\SiteScope\java\lib\ext directory. SiteScope includes with the jdbc/odbc driver used in the example above. To use another driver, you must install the driver file(s) into the proper directory before SiteScope can use them.
Database User Name: Enter the username required to connect to the database.
Database Password:: Enter the password required to connect to the database.
Query: Enter an optional SQL Query to execute on the database. If you do not supply an SQL query string, the loading of the driver and connection to the database will be tested but no query will be executed.
Results Set Max Columns: If you have entered an SQL Query, enter the maximum number of columns to display in the query result set.
Results Set Max Rows: If you have entered an SQL Query, enter the maximum number of rows to display in the query result set.

The following is an example of the data returned from a successful database connection with a SQL query (limited to one row).

serverName	groupID	frameIndex	frameID	settingName	settingLine	lineChunk	chunkValue
10.0.0.157	master.config	1	_config	_databaseMaxSummary	1	1	200