Data Management
Automated Creation of Modern Lakehouse Architectures with Microsoft Fabric
With our Lakehouse Acceleration Platform, we implement largely predefined, scalable and high-performance Lakehouse architectures based on Microsoft Fabric.
Our tried-and-tested framework offers the perfect combination of best practices, automation and adaptability - ideal for business departments and IT.
Application scenarios:
Our lakehouse solutions support you in different phases of your data strategy:
- Greenfield: Building a new lakehouse from scratch
- Modernization: Migration of legacy DWH or data lake structures
- Data Governance & Quality Assurance: Development of standardized, traceable and quality-assured data products
- Integration of heterogeneous systems: Merging SAP, Dynamics, D365, IoT and much more.
Predefined framework - the construction kit for your Fabric Lakehouse
Our solution is based on a modular framework that centrally controls all steps from data import to the consumable data view - our Medallion architecture:
The Silver Layer and Gold Layer are fundamentally provided by the framework on the basis of the structures in the Bronze Layer, including the historization that is already integrated in the Silver Layer. Additional transformations, clean-ups and, above all, the implementation of the business logic in the Gold Layer must be implemented individually within the project scope, as these are specific to each project and customer.
Other core functions:
Metadata-driven operation and customization:
- Tables, source systems, business keys and further configuration options can be controlled via a central repository and enable rapid adaptation to changing requirements
- Individual transformations for selected source objects can be implemented and fit seamlessly into the existing environment.
- Customizing is guaranteed and supported by an open architecture
Fabric-native implementation
- Use of OneLake, lakehouses, warehouses, notebooks, pipelines
- Deployment pipelines for support of dev/test/prod workspaces
- Synapse Real-Time Pipelines & Data Activator can be optionally integrated
Historization & data quality:
We implement standardized SCD2 histories directly in the silver layer and support both full loads and the delta load procedure in the bronze layer.
- Time-accurate traceability of every data change
- Completeness & correctness through configuration of the business key in the metadata on the basis of which the historization is controlled with table accuracy. All attributes next to the business key fields are historicized.
- Implementation of GDPR-compliant governance through masking, pseudonymization & logging is supported and can be implemented individually at project level (based on specifications).