QMetrix ETL FastTrack

QMetrix ETL FastTrack is a prebuilt framework using Microsoft SSIS (Integration Services). ETL FastTrack ensures your data-warehouse (DWH) initiatives get off to a flying start, incorporating functionality such as rollback, workflow management, scheduling, incremental updates, auditing and error handling. ETL FastTrack is deployed free with QMetrix DWH projects and provides the key foundational components of the DWH, so outcomes are delivered sooner and ongoing maintenance of the DWH, once in production, is low.

Your journey to better insights, starts here

CONTACT US

ETL-Fast-Track


Workflow Management & Scheduling

ETL FastTrack uses nested workflows, allowing for logical separation of data loads and the changing of timing or logic around each group of data flow packages. The DWH may execute data loads from flat files as they arrive, while other data loads may be executed on a regular schedule.


Rollback

ETL FastTrack allows for low maintenance by rolling back to the last successful step in the event of problems occurring. If a power or network outage occurs during DWH builds, transactions will be rolled back to the previous consistent state. This allows for the data flow to automatically begin again at the last failed step and continue on, saving time by not re-running the entire process.


Incremental Updates

ETL FastTrack incorporates incremental update logic by only extracting rows which have been inserted, updated or deleted. This reduces the load on the production system and compresses DWH build times.


SSIS Configuration Management

ETL FastTrack’s configuration management capability allows for easy promotion of jobs between environments (eg. Dev, UAT and Prod) without having to manually reconfigure each component to the new environment.


Auditing

ETL FastTrack standardises the audit and logging features in the DWH, with source system identifiers, insertion dates and update flags allowing for tracking of historical changes in enterprise data.


Error Handling

ETL FastTrack ensures errors which occur during execution are captured and logged within the audit table structure. This captures all the details of the error (such as time of occurrence and error message) and can be reported on or reviewed as necessary.