.

DWH Framework: Master your data integration in a Microsoft environment

Data integrations via predefined, metadata-driven, standardized routines.

Adastra’s DWH Framework maps existing transformation and integration processes or sets up new ones in Microsoft SQL Server or Microsoft Azure Data Platform environments. The tool uses the defining metadata to build, migrate or upgrade your existing Data Warehouse – quickly, efficiently, automated, and with minimal effort from you. 

The DWH Framework = standards + best practices in ETL

DWH Framework unifies and streamlines data flows in your organization. It stops creativity in ETL coding, eliminates unknown data flows, induces individual programmers to follow a uniform style.

Adastra’s DWH Framework converts or sets up all the ETL processes using standardized routines predefined by metadata.

Developers and administrators no longer need to write code; they only set the metadata and configure the process. In doing so, they automatically standardize the code used to set up individual ETL processes. 

When to use Adastra DWH Framework

None

To upgrade existing data warehouse built in Microsoft environment 

None

To migrate existing data warehouse in Microsoft environment (to on-premise and/or cloud) 

None

To develop new data warehouse in Microsoft environment 

Benefits: why use the DWH Framework?

None

ALL-IN-ONE SOLUTION

You get a comprehensive tool to develop and manage ETL processes.

None

HIGHT RELIABILITY

Thanks to the rules you will have highquality ETL processes from the very beginning.

None

RAPID DEPLOYMENT

Within 3 months, you will have a reliable and functional solution without big effort.

None

HIGH ROI

You will save more than 2000 man-days you would spend on mapping ETL processes. 

None

MINIMAL COSTS

You will cut the time required to develop and manage a new solution.

None

GOVERNANCE

On day 1, you will know what the general patterns and specific ETL processes should look like.

Key features of the Adastra DWH Framework

None

Metadata – the key to standardization and efficient development 

None

Workflows and schedules for ETL execution

None

Automated ETL development and delivery in Azure DevOps 

None

Documentation; data lineage 

None

Administration and monitoring 

None

Validations and notifications 

Discover what pitfalls Adastra ETL Framework eliminates 

Přečtěti si, jaká úskalí s Adastra DWH Frameworkem vyřešíte

How DWH Framework helps our clients

None

Kooperativa

Insurance companies Kooperativa and ČPP needed to efficiently migrate hundreds of tables from their legacy system.

After a thorough evaluation of several options that would help them speed up DWH/ETL development on SQL Server, they began using the Adastra DWH Framework. This has significantly accelerated and improved development as well as deployment to production.  

None

The Customs Administration of the Czech Republic 

In the Customs Administration (GDC – General Directorate of Customs) environment, the DWH Framework effectively integrates dozens of systems on a daily and hourly basis. The GDC has one of the first versions of the tool, which we continuously update. Among others, the GDC benefits from ETL transformations defined by metadata, on top of which user documentation is created. 

None

A major logistics company

In a major logistics company, the original ETL approach to data integration, built purely on SSIS, was replaced with the DWH Framework, a metadata driven ETL approach. This facilitated a significant reduction in development time, and thus also in the delivery of required KPIs to business users. The DWH Framework operates in cloud and is integrated with Azure DevOps. This agile project is managed by Continuous Integration and Continuous Deployment (CI/CD) approach. 

None

Melita 

For more than a decade, the Adastra DWH Framework has helped Melita, a leading Maltese telecommunications operator, load data to their data warehouse from multiple sources (CRM, billing system, network usage data). A key benefit of our solution is unified load management and monitoring in the telecom operator’s heterogenous environment.  

Inspiration from our blog

Do you want to take full advantage of the symbiosis offered by Microsoft database technologies (on-premise or cloud) and the Adastra DWH Framework? Please contact us.

Thank you

We will contact you as soon as possible.

David Kaláb

Government, Utility & Insurance Division Director

Michal Ponocný

Senior konzultant & Expert na ETL procesy