Skip to main content

🔄 Reconciliation Tests

Reconciliation Tests are used to verify that data in a target system matches data in a source system.
They are especially useful in scenarios like:

  • 📤 Data migration between systems
  • 🌐 Cross-environment comparison (e.g., between UAT and Sandbox)

X-AutoMate supports reconciliation testing for all major DWH and database technologies.
You can learn more about supported platforms in the X-AutoMate Introduction.

🧬 Structural Similarity to ETL Tests​

Reconciliation tests are structurally similar to ETL test cases, but with a key difference:

  • 🆚 Reconciliation tests compare data between two sources
  • 🧩 They use multiple specialized keywords
  • 🧪 They are often referred to as the "smaller sibling" of ETL tests

Additionally, reconciliation tests are automatically generated by X-AutoMate.
All you need to do is:

  1. Specify source and target connections
  2. Select objects and filters
  3. Submit — and X-AutoMate will generate a Test Suite containing reconciliation test cases

These cases will appear under /tests/cases.

🚀 Creating a Reconciliation Test​

To create a new reconciliation test:

  1. Open the /reconciliation page

  2. Select:

    • 🔗 Source connection
    • 🔗 Target connection
      (Make sure both connections are added beforehand.)

  3. Select the source and target objects (tables/views)

🧠 If the object list is empty or incomplete, click "Force Metadata Update" to refresh schema information.

📊 Metadata Preview​

If profiling information is available, you’ll see object-level metadata under the Comparison Object Details section:

Metadata Preview

🧙 Advanced Mode​

Switching to the Advanced tab lets you specify objects using SQL syntax (e.g., core.employee).

PLEASE NOTE !

🛑 X-AutoMate does not validate the existence of the object in this mode — use with caution!

📝 Generating the Test​

Once all details are filled:

  • Press the Submit button to generate and execute reconciliation tests.
  • Alternatively, if you only want to generate the test cases, enable the "Generate Only" toggle.

Reconciliation UI