A Smarter Way to Integrate Your Data into a Modern Data Warehouse

DataMerlin introduces a modern approach to solving complex data integration challenges. It is a platform composed of proven methodology, built-in technical expertise, best practices and tools that automate the ETL / ELT process as much as possible.

Backed by 15 years of experience and more than 150 projects of data warehouse implementations, both domestically and globally and across a wide range of industries, DataMerlin encapsulates everything we've learnt along the way.

10-times faster implementation

10-times lower total cost of ownership

Build a Modern Data Warehouse Effortlessly

By combining the power of automation with a metadata-driven approach, you get exceptional results in comparison to building a data warehouse the traditional way or by yourself.

Not to mention intangible benefits like:

  • Reduced dependence on development resources
  • Higher consistency (ETL error handling, ETL notifications, metadata for data load) and
  • Minimum risk

5-times faster implementation

5-times lower total cost of ownership

Why Automate?

ETL / ELT development takes the largest portion (up to 80%) of the data warehouse development effort. In addition to being time consuming, it can also be very challenging, error prone and difficult to maintain.

Who is DataMerlin For?

DataMerlin is a single solution for many use cases and is therefore the perfect choice for any data-driven company.

NEW

Build a data warehouse, a data mart or a data lake from scratch.

EXPAND

Expand the existing data system with new data sources or analytical areas.

MODERNIZE

Migrate your existing data warehouse to a cloud environment.

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.

Fully documented

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.

Fast-track Snowflake Projects

Migrating your existing on-premises data system to the cloud environment can be a very challenging, risky, time consuming and complex process because you may need to rewrite the code for the ETL processes, reformat the data to fit the target and optimize it for the new platform.

As a Snowflake partner, we have heavily invested in supporting data warehouse migrations from different on-premise technologies to the Snowflake cloud environment.

DataMerlin is a fast and effective solution to migrate data from your current database into the Snowflake instance. It provides native support for Snowflake with SQL code generation and leverages full ETL / ELT automation. This way your organization will be able to:

  • Shorten the time-to-cloud from months or years to only days
  • Automate the data processing flow from any internal or external sources
  • Reduce migration costs by factors
  • Reap the benefits of Snowflake much sooner

IBM Industry Data Warehouse Models

IBM Industry Data Warehouse Models encapsulate IBM's extensive experience and best practices in delivering data warehouse solutions to some of the world's leading companies within each industry.

They provide enterprise-wide specification and data structure designs for the central data warehouse and data marts and a catalogue of industry-specific concepts and terminology.

What IBM Industry Data Warehouse Models lack is the support for ETL. For this reason, DataMerlin is the perfect pairing.

  • It offers full support for IBM Industry Data Warehouse Models, so ETL development time can be cut down by 80%.
  • It supports various modelling techniques such as Super-Sub Type, Anchor modelling, atomic, summary area and dimensional area (Kimball).
  • It provides built-in experience based on numerous IBM Industry Data Warehouse implementations.
  • In addition, all source to target mappings are on the same platform (not in multiple Excel files with no version control), enabling sophisticated data lineage and impact analysis.