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.
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.
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 transferred by qShift are handled dynamically through Hyper-Q in real-time when the application invokes those views.
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.
Datometry qShift is a SaaS offering that automates the generation of schema for the destination cloud data warehouse instantly and with full accuracy.