This is an index page of specification-related articles. Please use navigation on the left to find what you're looking for.
Windows - All Omniscope Editions can be installed on all 32-bit and 64-bit Windows operating systems from Windows 2000 upwards, on both desktop/laptop and server Windows versions. Windows 8 mobile devices support Java and will run the fully-installed Viewer and activated Desktop Editions as well, ideally on 64-bit tablets with at least 4 GB of RAM depending on 'dashboard' file sizes.
Mac/OSX - The Mac version requires OS X 10.5 upwards. From version 2.8, Omniscope for OS X 10.7 upwards is standalone. There are some minor Safari browser related issues when running on Mac. Contact us for more information.
Linux - The free Viewer runs with full user interface on Linux distributions that support Java, but activated Editions such as Server/Publisher are designed to run 'headless' on Linux servers.
iIOS and Android - iPads and Android tablets/phones do not support Java, and are supported only via their browsers running the Omniscope Mobile HTML5/JavaScript interactive visualisations hosted by Server Edition. Server Editions can support either 50 or unlimited concurrent browser sessions, licensing and hardware permitting.
Requirements will vary with the size of the data sets being refreshed and distributed: a typical 32-bit Windows PC with at least 512 MB RAM and at least a 1 GHz CPU will handle average data sets.
For large files (over about 16-18 million cells), 2 GB RAM or more may be required. Machines running 64-bit Omniscope on a 64-bit operating system with 4 GB of RAM or more will handle much larger files up to the limits imposed by the installed RAM. More information on scaling and performance [1].
Omniscope has modest hard disk requirements. 200 MB free space should be sufficient.
Omniscope Online is a zero-install version of Omniscope Viewer which launches from a Launch button on a web page. Requires Java 5 or later to be installed on the target machine, readily available on all corporate desktops.
Omniscope Viewer is also available as an executable JAR file. This will run on any modern computing platform supporting Java 5 or later, including Unix and Linux.
The following file types are supported by the latest version of Omniscope for import and/or export of cell data.
Also see: Supported databases [2] (includes OLAP) Supported feeds [3]
Extension | Description and notes | Capability |
IOK | Omniscope file containing data, tabs, views, settings, formulae, etc. Can be considered a "project file" or a "report". Unless secured otherwise, can be opened and explored in the free Viewer.
| Open, save |
IOM | As per IOK, but cannot be opened in the free Viewer. Requires a licensed edition of Omniscope Desktop or Server to open.
| Open, save |
CSV, TSV, etc. | Delimited text file, such as comma, semicolon or tab separated. By default, CSV files are imported following the same rules regarding separators, delimiters and special character escaping as Excel. Any text file containing delimited data, regardless of filename extension, can be configured for import.
| Import, export |
TXT, etc. | Fixed-width text file, with columns of data padded with spaces. Any text file containing fixed-width data, regardless of filename extension, can be configured for import.
| Import, export |
XML, etc. | XML text file, with data in the Visokio XML data schema [4]. XML data in other schemas can be converted into the Visokio schema using an appropriate XSL transformation file, which Omniscope can be configured to apply for you, allowing other schemas effectively to be imported directly. XSL translation is only supported for importing. When exporting, only the Visokio XML data schema is supported. Any text file containing XML data in the correct schema, regardless of filename extension, can be configured for import.
| Import, export |
XLS, XLSX, XLSM, XLSB | Microsoft Excel workbook containing multiple worksheets (supporting Excel versions 97 and higher). Omniscope supports importing a single worksheet, or multiple worksheets appended together. Only the displayed values are imported; styles and formulae are not imported.
| Import, export |
MDB, ACCDB | Microsoft Access database file containing multiple tables. Omniscope supports importing either single tables or multiple tables using either an SQL join or by merging multiple Access sources in Omniscope. In Omniscope 2.6, MDB/ACCDB files require Microsoft Access to be installed (version 2007 or greater for ACCDB files), and require Omniscope to be running under the same architecture as Microsoft Access (so if Omniscope is 32-bit, Access must be 32-bit; if Omniscope is 64-bit, Access must be 64-bit). In Omniscope 2.7, MDB and ACCDB files can be imported without any requirement to have Microsoft Access installed, so is available on 32-bit and 64-bit Windows, and Mac. Omniscope treats MDB and ACCDB files as database connections, allowing arbitrary SQL on import, and exporting to a single table using insert/update.
| Import, export (via SQL SELECT, INSERT/UPDATE) |
PST, OST | Microsoft Outlook data file ("Personal Storage Table" / "Off-line Storage Table" / Personal Folder File) containing emails, notes, calendar entries, contacts, etc.
| Import |
QPW | Quattro Pro spreadsheet
| Import, export |
LOG | Web Access log containing a web server's HTTP request access log data, in either the common or extended log formats.
| Import |
The latest version of Omniscope supports the following types of database.
Also see: Supported file types [5] Supported feeds [3]
Database | Versions supported and notes |
Microsoft Access | Versions 2000 and higher. See notes in supported file types [5]. |
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 [6]. 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. |
The latest version of Omniscope imports from the following external data feeds.
Also see: Supported file types [5] Supported databases [2] (includes OLAP)
Feed | Notes |
Coming soon | Coming soon |
Links:
[1] http://kb.visokio.com/kb/omniscope-scaling
[2] http://kb.visokio.com/kb/supported-dbs
[3] http://kb.visokio.com/kb/supported-feeds
[4] http://kb.visokio.com/xmldata
[5] http://kb.visokio.com/kb/filetypes
[6] http://kb.visokio.com/kb/db/dsn-less-odbc