Datometry qInsight

Jump-Start your Journey to the Cloud with Unparalleled Insights
into your Database Workloads.

Why Datometry qInsight

Datometry qInsight™ is the only product in the market to summarize the functional, operational, and performance characteristics of data warehouse workloads, assess the compatibility of the workloads with the target cloud data warehouse, prioritize workload hygiene, and provide a feasibility analysis which includes a timeline for implementation.

360° View

Unprecedented insights into concurrency, statement complexity, and schema complexity.

Super Fast Analysis

Analysis of millions of statements per hour.

No Installation

No customer setup, installation, or time investment needed.

100% Automated

Fully automated analysis that does not affect production environments.

Clarity, Confidence, and Certainty Before the Move

Datometry qInsight provides automated and detailed insights into the application workloads when considering replatforming to a cloud data warehouse. Using the comprehensive analysis, data warehouse migration and implementation plans can be created in weeks instead of months.

Which data warehouse workloads can be successfully off-loaded?
What is the associated effort for a data warehouse replatforming?
How do I prioritize data warehouse workloads while replatforming?

qInsight is a SaaS solution that requires no installation in the infrastructure.


Fortune 500 Retailer

.
Datometry qInsight analysis showed us the hidden effort required to replatform via the complete rewrite of the application. We are now able to make a more informed choice regarding data warehouse replatforming.

How It Works

Datometry qInsight processes an application workload as captured by the data warehouse logging facilities—for example, a full week’s worth of SQL statements including queries—assesses the features in use and provides a suitability analysis for running the workload on the new cloud data warehouse.

The accuracy and completeness of insights means moving forward on replatforming with surety, confidence, and transparency that comes with making data-driven decisions.

Frequently Asked Questions

Datometry qInsight gives enterprises an in-depth analysis of existing data warehouse application workloads at unprecedented level of detail.

Datometry qInsight provides a unique and detailed breakdown of all interactions of analytical application with the data warehouse. During the analysis, qInsight parses queries to extract and categorize SQL and database features. The insights provided in the report paint a complete picture of effort and risk associated with a replatforming effort.

The analysis provides unprecedented visibility into all aspects of existing application workloads and provides detailed information on the features used and the contexts in which they are used. This analysis includes information on out-of-the-box coverage of applications, query insights, recommendations for performance tuning and optimization, and a list of database objects referenced by the workload.

Using the intelligence from the qInsight analysis, customers can create database migration and implementation plans in weeks instead of months.
Currently, qInsight supports Microsoft Azure SQL DW, Amazon Redshift, and Pivotal Greenplum Data Warehouse.
The product analyzes application workloads as recorded and logged in database query logs. This includes workloads regardless of the application that submitted the requests. Critically, this includes ad-hoc and analytical queries, query scripts executed by custom applications, as well as third-party BI and ETL solutions.
For its analysis, qInsight needs offline access to schema and metadata information to perform semantically correct translations. The product is designed with ease-of-use in mind: the query logs and schema collection scripts required for analysis can be run with the credentials of regular database users. The analysis is performed in the by qInsight SaaS by ingesting the query and schema logs.
An initial analysis can be usually performed within days. A full analysis is typically available within 2 to 3 weeks.
Contact the Datometry Team at info@datometry.com for a demo and learn more about BI modernization.

Datometry qInsight Analyzes Millions of Statements per Hour.