Simple and powerful data mining tool. Data Odyssey technology allows you extract and analyze data directly from various types of data sources without OLAP, rollup tables, constructing a data warehouse, or even normalizing your tables.
Version: 2.0.21Simple and powerful data mining tool.
Operating System: Windows
Allows to: Operate data from heterogeneous sources (MS SQL Server, Oracle, MySQL, DBF, VFP DBC, MS Access) using various access technologies (ODBC, IIS+XML+HTTP, RPC, RPC+IIS+XML+HTTP); Create and execute simple queries(missions); Structure Missions on the basis of the uniform interface element up to advanced queries (subqueries, unions, interqueries);
Create simple and compound filter conditions;
Combine adjacent filter condition units (equal fields of different tables, subqueries, unions, a report's other missions) to automatically correct the entire condition generating dialogue (hundreds of fields, multiple pages and scrolling regions) on any value change; Retrieve data from heterogeneous sources (e.g. MS SQL Server and ORACLE, ORACLE and DBF, MySQL and MS Access and MS SQL Server, etc.) in one mission; Group and sum data, apply other aggregates;
Explore data by using the explorer technology; Detail data of certain mission elements retrieved to create submissions for them (getting deeper into space);
Save mission plans to further use as new mission templates, in other missions, cubes, and reports; Create primitive cubes;
Create compound cubes with several update variants from heterogeneous sources with each of the updates having its own data filter conditions and cube modifications and being an analogue of mission of any complexity; Use primitive cubes as replications to collect data from heterogeneous sources in one most suitable; Log cube and replication updates;
Perform batch updating of cubes and replications from the program, command line or another application; Undo update layers of reversible cubes and replications; Make simple end-user reports based on particular missions; Make complex end-user reports, combining results of many missions;
Create any number of modifications of any report form using the VFP expression builder and Excel worksheets; Display on an Excel worksheet several mission result tables ...