Overview
What is Invantive Query Tool?
Invantive's free Query Tool provides users with real-time Operational Intelligence (OI) across their entire enterprise. The free Query Tool provides access to the user’s real-time data warehouse and databases running on MySQL, Oracle, SQL Server, Teradata, IBM DB2/UDB or elsewhere. This…
Leaving a review helps other professionals like you evaluate Business Intelligence (BI) Tools
Be the first one in your network to review Invantive Query Tool, and make your voice heard!
Get StartedPricing
Invantive Query Tool
$0
Invantive Query Tool
$0
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Details
- About
- Tech Details
What is Invantive Query Tool?
Invantive's free Query Tool provides users with real-time Operational Intelligence (OI) across their entire enterprise. The free Query Tool provides access to the user’s real-time data warehouse and databases running on MySQL, Oracle, SQL Server, Teradata, IBM DB2/UDB or elsewhere. This enables users to store, organize and locate their operational data quickly. The optional repository, provided by Invantive Producer, allows users to transfer, assemble, integrate, store and access data from multiple sources. With the Invantive Query tool users will have all their company's operational data available on demand. The Query Tool empowers users to execute queries, capture and analyze data and create business reports. It does not matter where the data has been stored as database administrators will be able to recover, edit, save, import and export the data to Microsoft Excel and XPS, Adobe PDF, SQL and CSV.
Invantive Query Tool Features
BI Platform Features
- Supported: Administration via Windows App
- Supported: Live Connection to External Data
- Supported: Snapshot of External Data
- Supported: In-memory data model
- Supported: OLAP (Pre-processed cube representation)
- Supported: ROLAP (SQL-layer querying)
- Supported: Multi-Data Source Reporting (Blending)
Supported Data Sources Features
- Supported: MS Excel Workbooks
- Supported: Text Files (CSV, etc)
- Supported: Oracle
- Supported: MS SQL Server
- Supported: IBM DB2
- Supported: Postgres
- Supported: MySQL
- Supported: ODBC
- Supported: Cloudera Hadoop
- Supported: Teradata
- Supported: Salesforce
- Supported: SAP
BI Standard Reporting Features
- Supported: Pixel Perfect reports
- Supported: Report Formatting Templates
Ad-hoc Reporting Features
- Supported: Formatting capabilities
- Supported: Report sharing and collaboration
Report Output and Scheduling Features
- Supported: Publish to Web
- Supported: Publish to PDF
- Supported: Output Raw Supporting Data
Access Control and Security Features
- Supported: Multi-User Support (named login)
- Supported: Role-Based Security Model
- Supported: Multiple Access Permission Levels (Create, Read, Delete)
- Supported: Report-Level Access Control
Additional Features
- Supported: Automatic analysis of your business activities, compliance and business rules.
- Supported: Connect real-time to your data warehouse and repository for on and off database reporting.
- Supported: Minimize difficulties generating, validating and executing SQL code with the Query Tool and Invantive Producer.
- Supported: Cleanup, edit, parse and execute SQL queries over web services and multiple databases with one system.
- Supported: Execute SQL queries on IBM DB2/UDB, Teradata, MySQL, Oracle RDBMS, Microsoft SQL Server and other platforms.
- Supported: Open pre-filled scripts optionally directly from the document management system.
- Supported: Access your databases over the Internet (HTTPS access) when used in combination with Invantive Web Service.
Invantive Query Tool Screenshots
Invantive Query Tool Videos
Invantive Query Tool Technical Details
| Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Windows |
| Mobile Application | No |
| Supported Countries | World |
| Supported Languages | English, Dutch, German, French, Italian, Spanish. Portugese, Hindi, Chinese |
