This query tool helps gather operational intelligence from corporate data warehouse.
Free Real-time Operational Intelligence is a free Query Tool from Invantive. It provides you with real-time Operational Intelligence (OI) across your entire enterprise. You are able to access your real-time data warehouse and databases. These could be running on MySQL, Oracle, SQL Server, Teradata, IBM DB2/UDB or other databases. This tool will let you organize all the operational data you need, store them; organize so that they could be located fast. This will work with an optional repository, provided by Invantive Producer. That allows you to transfer, assemble, integrate, store and access data from multiple sources. Operational data such as project execution, manufacturing, software development and service operations can be organized easily. The Invantive Query Tool helps you build the appropriate queries and run the SQL and Oracle PL/SQL query programs to harvest real-time data that give you the necessary insight into your business operations.
Complex queries to cover all your operational activities could be created. You could check them for compliance and business rules, identify threats and arrive at the right decision in light of those background data. You are able to execute queries, capture and analyze your data and create business reports in real-time. Billable hours, project and process activities, employee leave and attendance, etc. that tell you how exactly the business is going could be derived easily. The DBA types will be able to recover, edit, save, import and export the data to Microsoft Excel and XPS, Adobe PDF, SQL and CSV formats. Document Management System (DMS) available lets you import pre-filled templates direct from an optional module such as Microsoft SharePoint or Invantive Vision. This is a very good tool.