Invantive Estate

With Invantive Query Tool, working with your data via SQL becomes easy. Invantive Producer makes it possible with the help of SQL to edit a. real-time data warehouse. Maintaining integrity and maintaining information security according to ISO 27002. Invantive Query Tool is an addition to Invantive Producer and derived products such as Invantive Vision, Invantive Estate, Invantive Control for Excel and Invantive Composition for Word.

But it is also possible to use Invantive Query Tool for databases without Invantive Producer!

With Invantive Query Tool you can:

•Execute SQL-queries and request the results in a table.

•Immediately group, filter and sort the results in the table on the screen.

•Print the results or export them to Adobe PDF, Microsoft Excel or Microsoft XPS.

•Automate processes with assistance from Oracle PL/SQL (only in combination with Oracle RDBMS).

•Retrieve old queries from a file or from the list in the tab "History".

•Connect directly through a native connection for the concerned type database (for example Oracle SQL*Net for Oracle) or connect through the Invantive Web Service so that you do not have to install database-specific software on a work location.

•Supply the database user with a connection or connect to an already installed Invantive product with associated user codes.

•Retrieve the structure of a table or view.

•Request the output of dbms_output, itgen_output and itgen_log of an Oracle PL/SQL block (only in combination with Oracle RDBMS).

•Retrieve an execution plan ("query plan" or "explain plan") of an Oracle SQL query. (only in combination with Oracle RDBMS)

•Request the trajectory ("Oracle Trace") of a SQL statement (only in combination with Oracle RDBMS).