XtractPro Launches Data Xtractor Suite, with Model Xtractor and Query Xtractor

North Vancouver, Canada, September 10, 2016 --(PR.com)-- Combine flexible graphical representations of reverse-engineered data models with complex SQL queries generated with their visual query builder. Design within seconds complex SELECT queries, without even knowing SQL.

Generic vendor-independent interface and universal support for over a dozen database platforms, including Oracle and Microsoft SQL Server, MySQL and PostgreSQL, SQLite and Firebird, cloud databases such as Amazon Redshift and Microsoft SQL Azure Database.

Major Features in Data Xtractor suite 1.0 include:

* One-way reverse engineering of most relational databases.
* Crow’s Foot, IDEF1X and simplified ER notations.
* Enhanced custom or chain relationships, custom table and column aliases.
* Support or emulation of SQL pivot/cross tables and grouping sets.
* Emulation of intersect/except, extended aggregate functions, ALL/ANY etc, when not implemented.
* Extended sort with NULLs first or last in any database.
* Learn SQL from generated demo queries or queries you design from scratch.
* Type less and let us auto-quote identifiers and handle internal SQL aliases.
* Automatic fix of known SQL gotchas, NULL or math problems, vendor-specific inconsistencies.
* Switch from nested subqueries to CTEs, for multiple SQL query views.
* Use complex window functions.
* Auto-detected lookup fields and powerful drill-down on relationships.
* Visual effects, with graphic bar columns, same icons for duplicates, unique value detection etc.

For more details on the new software release, please see the presentation screens (https://data-xtractor.com/data-xtractor/) and the product information (https://data-xtractor.com/product/data-xtractor/).