Data Xtractor

Data Xtractor combines Visual Xtractor, Query Xtractor, Model Xtractor and the new Security 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.

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
All Security 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)
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 Suite

  • Data Xtractor – Includes all other Xtractor applications and functionality.
  • Model Xtractor – Free visual data model analysis application.
  • Query Xtractor – Visual SQL query builder.
  • Visual Xtractor – Data visualization app, with inline and regular charts connected directly to SQL queries.
  • Security Xtractor – Extract and inspect – in Objects browser or diagrams – groups of users, roles, access policies with privileges.
  • Metadata Xtractor – Free database metadata importer, included in all packages and supported as-is.
  • Xtractor Templates – Free theme configuration tool, included in all packages and supported as-is.
  • Xtractor Monitor – Free database connection watcher, included in all packages and supported as-is.

Data Xtractor = Model + Query + Visual + Security 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 Supported Databases
per year
$132
Build SQL Queries without restriction for all our supported databases
MySQL/MariaDB/Aurora
PostgreSQL/Redshift/Snowflake
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, Visual Xtractor, Security 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