Connecting to MySQL 5.1+ using JDBC

Using the latest JDBC driver

You will need to have downloaded and installed the latest database driver Connector/J 5.1 includes support for the latest JDBC functionality.

Open the Omniscope Database Connection wizard under File > Connect to database. Choose the generic "JDBC data source (advanced)" option on the first page.

• For Driver jar path, enter "C:\Program Files\MySQL\mysql-connector-java-5.1.8\mysql-connector-java-5.1.8-bin.jar" or similar (depending on your installation).
• For Driver class, enter "com.mysql.jdbc.Driver".
• For JDBC URL, enter "jdbc:mysql://host:3306/databaseName" (for example; see the MySQL Connector/J documentation for help).

Follow through the rest of the Database Connection wizard as usual, specifying a username and password, choosing a table, and optionally customising the SQL query.