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 |
| ODBC | 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. |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
