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.
Data Xtractor Features Summary
|All Model Xtractor Features||check them here|
|All Query Xtractor Features||check them here|
|All Visual Xtractor Features||check them here|
|All Security Xtractor Features||check them here|
|Lookup Table Data from ER Model||right-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 Charts||inline 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 Database||only 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 Application||everything from Visual, Query and Model Xtractor can be also found in Data Xtractor, and separate Xtractor application cannot be used simultaneously|
- 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
Data Xtractor can create and open both ER model diagrams (as in Model Xtractor) and designed SQL queries, with extended visual SQL builders.
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
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
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.
Query Xtractor – Visual SQL Query Builder/Generator/Runner
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.
Generic Query Emulator – Pivot/Cross Tables for any Platform
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.
This was what a similar pivot query may produce as end results, while still in design mode.
Data 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.