Invantive Query Tool Features
BI Platform Features
- Administration via Windows App
- Live Connection to External Data
- Snapshot of External Data
- In-memory data model
- OLAP (Pre-processed cube representation)
- ROLAP (SQL-layer querying)
- Multi-Data Source Reporting (Blending)
Supported Data Sources Features
Data sources that can be consumed by the application.
- MS Excel Workbooks
- Text Files (CSV, etc)
- Oracle
- MS SQL Server
- IBM DB2
- Postgres
- MySQL
- ODBC
- Cloudera Hadoop
- Teradata
- Salesforce
- SAP
BI Standard Reporting Features
Standard reporting means pre-built or canned reports available to users without having to create them.
- Pixel Perfect reports
- Report Formatting Templates
Ad-hoc Reporting Features
Ad-Hoc Reports are reports built by the user to meet highly specific requirements.
- Formatting capabilities
- Report sharing and collaboration
Report Output and Scheduling Features
Ability to schedule and manager report output.
- Publish to Web
- Publish to PDF
- Output Raw Supporting Data
Access Control and Security Features
Access control means being able to determine who has access to which data.
- Multi-User Support (named login)
- Role-Based Security Model
- Multiple Access Permission Levels (Create, Read, Delete)
- Report-Level Access Control
Additional Features
- Automatic analysis of your business activities, compliance and business rules.
- Connect real-time to your data warehouse and repository for on and off database reporting.
- Minimize difficulties generating, validating and executing SQL code with the Query Tool and Invantive Producer.
- Cleanup, edit, parse and execute SQL queries over web services and multiple databases with one system.
- Execute SQL queries on IBM DB2/UDB, Teradata, MySQL, Oracle RDBMS, Microsoft SQL Server and other platforms.
- Open pre-filled scripts optionally directly from the document management system.
- Access your databases over the Internet (HTTPS access) when used in combination with Invantive Web Service.