Data Odyssey Express 2

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.A process of Knowledge-Discovery we associate with flying in data space.

Two types of missions controlled by Gattaca allow to extract data, create more detailed submissions for rows of selected data, create and use later a mission plans, summarize a columns in results, export results into excel and to build an excel charts.

A technology of reports allows to create a completed decisions for end users in which you can unite a results of several mission plans with various relations between mission results. Dataodyssey Express is a simple and powerful means for creating a Knowledge-Discovery solutions in business and other areas of a life.

Features:
Operate data from heterogeneous data sources (Microsoft SQL Server, Oracle, MySQL, Visual FoxPro DBF, Visual FoxPro DBC, Microsoft Access) using various access technologies (ODBC, IIS+XML+HTTP, RPC, RPC+IIS+XML+HTTP);

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.

Create and execute simple queries (missions);

Structure missions on the basis of the uniform interface element up to advanced queries (subqueries, unions, interqueries);

Explore data by using the explorer technology (detailed mission);

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;

Retrieve data from heterogeneous data sources (e.g. Microsoft SQL Server and ORACLE, ORACLE and DBF, MySQL and Microsoft Access and Microsoft SQL Server, etc.) in one mission;

Group and sum data, apply other aggregates (summary missions);

Create primitive cubes
and more.