Datometry qShift

Reduce Replatforming Time and Risk with Automated Database Schema Generation

Datometry qShift Overview

Datometry qShift automatically converts the legacy or source data warehouse schema into the cloud or modern data warehouse of choice.

qShift takes into account all of the existing objects in the source data warehouse schema and generates the appropriate DDL queries for the destination data warehouse.

qShift is powered by the Datometry Adaptive Data Virtualization technology.

Why Datometry qShift

Faster Data Migration

qShift saves months of specialized manual effort required to convert the schema from the existing data warehouse.

Reduced Cost

qShift is an order of magnitude lower in cost when compared to manual schema migration effort.

De-Risk Data Migration

qShift can significantly reduce the risk of a data migration effort by eliminating the error prone manual schema conversion process.

100% Automated

Unlike other tools in the market, qShift is a full-featured product that converts 100% of the legacy data warehouse schema.


Fortune 500 Retailer

.
With qShift, our enterprise completed a 100TB data migration within days, saved hundreds of thousands of dollars and significantly reduced the risk of replatforming.

While the cost and time savings of qShift was a no-brainer, it was the reduced risk of automated schema mapping that was the deciding factor for our enterprise to replatform with the Datometry Solution.

Datometry qShift Features

Datometry qShift automatically and instantly generates the schema for the destination data warehouse taking into account existing tables and objects in the source data warehouse schema. qShift generates the appropriate DDL queries for the destination data warehouse and creates the empty tables and views.

Updatable Views

Updatable views transferred by qShift are handled dynamically through Hyper-Q in real-time when the application invokes those views.

Datatype Matching

qShift will keep track of the datatype mismatches for Hyper-Q to use during query translation and query transformation.

Stored Procedures and Macros

qShift preserves the original Stored Procedures and Macros for use by Hyper-Q emulation.

Supported Systems: qShift can take schema from Teradata 13 or higher versions and synthesize schema for Azure SQL DW, AWS Redshift or Pivotal Greenplum.

FAQs

Datometry qShift is a SaaS offering that automates the generation of schema for the destination cloud data warehouse instantly and with full accuracy.

What Cloud Data Warehouses are supported?
qShift supports AWS Redshift, Azure SQL Data Warehouse and Greenplum databases. It also supports Azure SQL DB, AWS Aurora Postgres and AWS Spectrum. Please reach out to contact@datometry.com for questions regarding other target data warehouses.
Once qShift does the schema mapping and the data move is done, Hyper-Q handles all of the DDL commands including table/view creation, updates and deletes done using the legacy data warehouse format.
The schema generated by qShift is available for all applications to use. qShift generates schema to make sure Hyper-Q can translate the legacy SQL from existing applications without requiring modifications. The schema is available for DBAs and developers to make changes are required.
Today qShift is part of the Datometry replatforming solution and is not available as a standalone offering. qShift is deployed by the Datometry customer success team to expedite the implementation of Hyper-Q and speed up replatforming.
SAP Business Objects universe is the semantic layer that is essentially a collection of tables and views and other objects within the data warehouse.
qShift takes care of all the objects within the universes during the schema conversion.

Datometry qInsight accelerates data migration and speeds up replatforming to the cloud

Request a demo