Supported databases

Supported databases


The latest version of Omniscope supports the following types of database.

Also see:  Supported file types   Supported feeds 


Database Versions supported and notes 
Microsoft Access Versions 2000 and higher.  See notes in supported file types.
Oracle Versions 7 and higher
SQL Server Versions 6.5, 7, 2000, 2005 and 2008
Sybase Versions 10, 11, 12, 15 
PostgreSQL Versions 7.2 and higher 
MySQL Versions 4.1 and higher 

Any database providing an ODBC connection supporting ANSI SQL. You can either configure a named ODBC connection (if on 64-bit, be sure to use the 64-bit ODBC control panel) or can use a DSN-less connection.

However, ODBC connections are not recommended if there is native connector (see above) or a JDBC driver (see below) available. 

JDBC Any database providing a JDBC 3.0 driver supporting ANSI SQL, typically in the form of a downloaded JAR file.  For advanced use in the absence of a native driver (above).
OLAP Any OLAP cube supporting MDX querying via HTTP. Most cube servers support MDX, however you may need to configure HTTP access as this is not always available out of the box. Please speak to your system administrator if you are unsure.