Dataodyssey Express Free Download
Dataodyssey Express Free Download.
Simple and powerful data mining tool.
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 ...
Dataodyssey Express keywords: data, mining, tool, report, mission, gattaca, business, discovery, sql, server, oracle, mysql, vfp, database, model, tables, iis, odbc, xml, automation
EMS Data Export for Oracle
EMS Data Export for Oracle is a powerful tool to export Oracle database data quickly to any of 19 available formats, including MS Access, MS Excel, MS Word (RTF), HTML, XML, PDF, TXT, CSV, DBF, ODF and others.
XlsToOra - Import Excel to Oracle easy and quickly. Main features: 1. Automatic match tables and fields. 2. Batch import from multiple sheets at one time. 3. Save configuration and run repeatedly, command line, scheduled task.
Query Tool (using ADO)
Query OLE DB data sources, author SQL scripts and queries, execute multiple SQL scripts or stored procedures simultaneously, and more.
SwisSQL - Data Migration Tool
SwisSQL offers a complete Data Migration Tool that helps the migration of database structures and data across leading databases such as Oracle, IBM DB2, MS-SQL Server, Sybase, SAP DB, PostgreSQL and MySQL.
MS SQL Field Box
MS SQL Field Box is a small tool which allows you to view MS SQL Server database structure and paste table or field names in your favorite editor using mouse or keyboard hotkeys. It is another way of using "IntelliSense" technology :