The Xtract Repository Engine is a database which holds smart methods, snippets and tables to deliver quick ETL (Extract Transform Load) builds.
The tool allows you to select tables, columns from the source system and create custom SQL views on fly. These SQL views
Extract only required tables and columns, Transforms the data based on the configuration and Loads data into the downstream
databases. The metadata information of source system is stored in the repository database.
|
|
|
|
|
|
|
A HLD (high level diagram) showing group of tables, allowing auto generation of views, table scripts and column mappings.
Repository database holding table configuration, environment, batch & log status, error log, delta-load and data-filter.
These settings are managed in the extraction manager interface.
Find out what benefits you could get by using this tool ?
|
|
|
|
The ETL environments are monitored using ETL Dashboard.
The daily batch duration, batch trend line, duration per table are some of the user-friendly charts
helps you analyze job run statistics and quickly identify specific bottlenecks in the ETL processes.
|
|
|
|
|
|
|
Setup requirements:
An ETL Server
MS SQL SERVER 2012, 2014, 2016 database engine
MS SSIS / BIML
|
Licensing:
Yearly licence includes:
Initial setup
Indefinite ETL environments
Support
40 hours of development coupons (recurring on yearly bases)
Onsite training (2 days)
Advise on ETL platforms
|
|
|