Skip to content

Overview

What is Tracelake?

Tracelake is a specialized platform for validating SAP data replication to modern data warehouses. It helps data engineers and architects ensure that their SAP data is accurately replicated to their data warehouse of choice.

Tracelake architecture

Key Features

  • Automated Validation: Schedule regular validation checks
  • Smart Detection: Efficiently identify data discrepancies
  • Multiple Sources: Supported any SAP running on HANA. Oracle and MSSQL have limited support.
  • Warehouse Support: Works with major data warehouses
  • Detailed Reports: Get precise mismatch locations

How It Works

Tracelake connects directly to your SAP database (HANA) and to your data warehouse. It then runs a series of queries optimized for columnar databases, to find discrepancies between the data in SAP and the data in the data warehouse.

Tracelake doesn’t scan the entire database, but rather only the tables you have selected for validation. Additionaly, you also need to specify which columns to validate, other than the primary key. This is to ensure that the validation is efficient and not too resource intensive.

The result of the validation is a report which shows you any missing, extra or mismatched rows.

Supported Platforms

SAP Systems

  • Any SAP system on HANA

Data Warehouses

  • Snowflake
  • Google BigQuery
  • Amazon Redshift
  • Databricks
  • and more…