Easily work with your data using SQL

Invantive Producer makes it possible to edit a real-time data warehouse using SQL while integrity and information security is maintained according to ISO 27002. The Invantive Query program is an addition to Invantive Producer and derived products such as Invantive Vision or Invantive Control.

With the program Invantive Query you can:

• Using Oracle to execute SQL queries and retrieve 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 the help of Oracle PL/SQL.
• Retrieve old queries from a file or from the list in the tab "History".
• Direct connect via Oracle SQL * Net or via web tunneling software so you do not need to install Oracle software on a workstation.
• To provide the Oracle database user when connecting or connect to an already installed Invantive product with its corresponding user codes.
• Retrieve the structure of a table or view.
• Retrieve the output of dbms_output, itgen_output itgen_log of a PL / SQL block.
• Retrieve an execution plan ("query plan" or "explain plan") of an Oracle SQL query.
• Retrieve the track ("Oracle Trace") of a SQL statement.

Availability of Invantive Query-program

The Invantive Query-program is sold separately. In addition all Invantive products include a user license for the Invantive Query-program.