Data Xtractor combines Visual Xtractor, Query Xtractor and Model Xtractor into one single standalone application. Only in Data Xtractor you may design SQL queries with data visualization graphs.

Only in Data Xtractor you may use the visual SQL query builder for Open-Source databases such as MySQL or PostgreSQL, or Commercial databases like Microsoft SQL Server or Oracle, for a small monthly fee.

Download Data Xtractor


Data Xtractor Features Summary

FeatureDescription
All Model Xtractor Featurescheck them here
All Query Xtractor Featurescheck them here
All Visual Xtractor Featurescheck them here
Lookup Table Data from ER Modelright-click on a table shape in any ER model diagram and select Lookup Table Data, or View Table Data to open a new tab
Visual Query Builder with Chartsinline and regular charts simply extend the basic Query Xtractor visual builder, so you can not only design complex queries, but also generate nice charts from their result data
Query Builder for Any Databaseonly Data Xtractor can use the visual query builder to generate SQL and run queries from Open-Source and Commercial databases (MySQL, PostgreSQL, SQL Server, Oracle etc), for a small monthly fee
All-in-One Applicationeverything from Visual, Query and Model Xtractor can be also found in Data Xtractor, and separate Xtractor application cannot be used simultaneously

Data Xtractor = Model + Query + Visual Xtractor

Model + Query + Visual Xtractor

Data Xtractor can create and open both ER model diagrams (as in Model Xtractor) and designed SQL queries, with extended visual SQL builders.

Query SQL Builder with Charts

Unlike Query Xtractor, Data Xtractor extends its visual SQL query builder to include the Inline Chart and Chart builders. You can design complex SQL queries and assign directly data visualization effects – inline and regular charts – to the result columns.


Design SQL Queries for Open-Source and Commercial Databases

Build Oracle SQL Queries

All our products are FREE for what we call Featured databases: SQLite, Firebird, Microsoft SQL Server CE and Microsoft Access. One single restriction applies to queries for Open-Source and Commercial databases: you need a monthly (annualy paid) subscription to get and run the SQL generated from queries designed with our SQL builders.

Open-Source Databases
monthly (paid annually)
$24
Build SQL Queries without restriction for open-source databases
MySQL Databases
MariaDB Databases
Amazon Aurora
PostgreSQL Databases
Amazon Redshift
Subscribe
Commercial Databases
monthly (paid annually)
$29
Build SQL Queries without restrictions for commercial databases
Microsoft SQL Server/Azure
Oracle Databases
IBM Db2 Databases
Sybase/SAP ASE
Sybase/SAP SQL Anywhere
Subscribe
All Supported Databases
monthly (paid annually)
$39
Build SQL Queries without restriction for all our supported databases
MySQL/MariaDB/Aurora
PostgreSQL/Redshift
SQL Server/Azure
Oracle/IBM Db2
SAP ASE/SQL Anywhere
Subscribe

Lookup Table Data

Lookup Table Data

Only Data Xtractor allows you to instantly check the data stored in a table you visualize in an entity-relationship model diagram. This also applies to views or queries. Just right-click on a shape header and select Lookup Table Data. View Table Data will visualize the same data in a new tab.


Model Xtractor – Your Data Modeling Inspector

data-xtractor-model

Reverse-engineer existing database models. Traditional and enhanced ER data models for dozens of relational database platforms, including SQL Server, Oracle, MySQL, PostgreSQL, Azure and Amazon Redshift, SQLite and Firebird.

Learn More about Model Xtractor


Query Xtractor – Visual SQL Query Builder/Generator/Runner

data-xtractor-query

Create simple to complex read-only SQL SELECT queries without writing one single line of SQL. No prior SQL knowledge necessary. Use this productivity tool to produce complex SQL SELECT queries within seconds, drill-down on results through aggregations and relationships, use our emulated queries to get your data fast.

Learn More about Query Xtractor


Generic Query Emulator – Pivot/Cross Tables for any Platform

data-xtractor-pivot.jpg

We emulate, using SQL, many features with native support on some database systems, but missing on other platforms: pivot/crosstabs, grouping sets (with cube/rollup), intersect and except, sequence generator, data type functions etc. For instance, this is how a pivot/crosstab query is emulated on MariaDB. Column header values are automatically detected and we transparently add relatively complex SUM entries in generated SQL.

pivot-table
This was what a similar pivot query may produce as end results, while still in design mode.

ImportantData Xtractor includes all the functionality of Model Xtractor, Query Xtractor and Visual Xtractor, and much more.

You may extract and enhance ER database models, build visual SQL queries, drill-down on their data, and show beautiful charts.

Download Data Xtractor