Missions the retrieving and analyzing data from Microsoft SQL Server, Oracle, MySQL, DBF, DBC, Microsoft Access databases

 

  Combining data from heterogeneous data sources in one mission.
Data models and saving mission plans.
Cubes and replications
End-user reports
  Special tools for operating data (browsing, exploring, duplicating, etc.)

Documentation

Download (free)

Builds history

FoxPro to NET migration

Contacts

Links

    Dataodyssey Express is an easy to use and rather advanced instrument first for retrieving and analyzing data. The unified query technology employs the theme of associating the data space with the cosmic space and data analyzing with space flights. The process of data retrieval is realized by way of making mission plans and executing missions under the guidance of Gattaca. A mission and its plan are the generic element of the uniform interface as well for simple data retrievals as for building stored plans and cubes (also replications and table duplicating schemes).

Dataodyssey Express 2.0 implemented technologies allow to:

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 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 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);

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;

Create primitive cubes;

Create compound cubes with several update variants from heterogeneous data 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 data 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 Visual FoxPro expression builder and Excel worksheets;

Display on an Excel worksheet several mission result tables with grouping, formulas, color and font highlights ;

Export onscreen data to various data sources and to Excel, fill Excel ranges, build Excel charts;

Write event handlers for missions, reports and cubes;

Use special tools for browsing and exploring tables (explorer), duplicating tables in other data sources, archiving tables (ZIP), packing DBF tables with the feature of damaged header recovery.


www.dataodyssey.com     Contents

Send message to developer ...


Book:

My way from FoxPro to Silverlight