Download URL | Author URL | Software URL | Buy Now ($99)
OlapCube is a simple, yet powerful tool to analyze data. OlapCube will let you create local cubes (files with .cub extension) from data stored in any relational database (including MySQL, PostgreSQL, Microsoft Access, SQL aServer, SQL Server Express, Oracle, Oracle Express).
You can explore the resulting cube with our OlapCube Reader. Or you can use Microsoft Excel to create rich and customized reports.
The OLAP cube consists of numeric facts called measures which are categorized by dimensions. An OLAP cube is a data structure that allows fast analysis of data. The arrangement of data into cubes overcomes a limitation of relational databases. Relational databases are not well suited for near instantaneous analysis and display of large amounts of data. Instead, they are better suited for creating records from a series of transactions. Although many report-writing tools exist for relational databases, these are slow when the whole database must be summarized.
OLAP cubes can be though
Horizontally merge two FoxPro tables into one by a common column (field) of data. The two tables are not changed, a new table is created with the results. MS Access 2000 or higher ...
Save MySQL tables as text or CSV files. In the resulting text file, each field (column) is separated by a comma or other specified character(s). Each row is separated by a new line ...
Transfer tables from Paradox to Oracle databases. This program is designed for Paradox 5 databases. Higher versions of Paradox databases can be saved as 5 and used with this progra ...
Next-generation 384 Gigabyte Organizer, opens 12 databases simultaneously. Includes: Word Processor, spellcheck tables search/replace, skinning, drag-drop import/export, hyperlinks ...
Create, administrate, and connect to any relational or flat file database.