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 single, flat 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 transactional tables or (preferably) reporting views generated by relational databases from various different vendors.

Connecting to analytical data structures and multi-dimensional '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