Database Connections

This section covers importing data directly into Visokio applications from SQL-compliant relational database tables/views using the Database Connection wizard and standard ODBC or JDBC protocols. Omniscope can import the results of any SQL statement that returns a table using either ODBC (one database, multiple tables) or JDBC (multiple databases, multiple tables) protocols.

Note: Importing and refreshing from source data files in various formats, including data files exported from relational databases, is covered in the section on importing/exporting to/from source data files .

Topics:

Introduction to ODBC & JDBC- two standard ways of connecting to relational databases, these options are sufficient for most solutions

Connecting to Relational Databases- examples of making connections to reporting views from typical relational databases from various vendors

Connecting to analytical databases and OLAP 'cubes'- (in progress)

DSN-less ODBC- method of connecting/refreshing multiple machines on a network without the administrative overhead of configuring the data source on each machine