Connect to any SQL Database - with a JDBC driver

Omniscope Evo has the ability to load data from virtually any SQL-compatible database that comes with a JDBC driver.

In order to connect and extract the data - start with a JDBC driver download from the vendor's website.

Create a new Omniscope project and add a Database block from the Blocks menu, then in the Connection section select "JDBC (Advanced)".

You then need to specify:

• the path to the JDBC driver - typically a JAR file
• the Driver class - typically described by the driver DB vendor.
• the JDBC URL - which is the address to the Database, whether local or remote.

Example to connect to a SQLite database.

Optionally you can configure username, password and some advanced key-value parameters to pass to the driver when connecting to the database.

Once the connection has been established (by clicking on the Connect button), the block will list the tables found on the database. You can decide whether to connect to a single table, use some record filter rules, select the table fields you're interested in or provide a custom SQL statement to execute a custom query to retrieve the data.

Remember, when supported you can connect to your Database in "live query" mode, and link one or more sources directly to a Report block to visualise and explore the database data directly, without having to load the data in Omniscope.

Read more details https://help.visokio.com/support/solutions/articles/42000084020-database-source-querying-data-in-live-query-mode