Merge Tables and Create Virtual Joins Across Databases

Tutorial··7 min 57 sec

DreamFactory inspects the schema of every database it connects to, which makes it possible to join data that lives in separate systems through a single API call. This tutorial merges tables and builds virtual joins across disparate databases — the practical core of a data mesh approach.

What you’ll learn

  • How automatic schema inspection enables cross-database joins
  • Merging tables that live in different database engines
  • Returning joined data from a single API call