Data Warehouse Automation Platform
DataMerlin offers support through the whole implementation lifecycle, from data modelling and data mapping, to ETL development, deployment and maintenance.
Built-in best modelling practices
DataMerlin supports various modelling techniques (Kimball, Super-Sub Type, Anchor, Data Vault) and out-of-the-box automation templates which can be fully customisable to tailor to any methodology.
Any source and any target
DataMerlin enables you to quickly and easily map the data from any source to any target. Unlimited number of data staging areas are supported.
ETL/ELT automation
DataMerlin fully supports the ETL process with SQL code generator, auto generated database objects and ETL jobs for leading data integration tools. ETL documentation is auto-generated and always up-to-date.
End-to-end data lineage
DataMerlin helps you understand the origins of data used in reports and analysis.
Sophisticated impact analysis
With DataMerlin you can identify the consequences of new enhancements on current implementation within seconds.
Improved data quality
DataMerlin enables automated technical tests and business rules including the “compare source data against target data” feature.