Key Features and Capabilities

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.