SQL integration

The SQL integration interface is intended for data integration and ETL products to publish or consume data. It is composed of the Integration Load Functions and the Data Location Database Schema.

The Integration Load Functions are stored in the repository schema, which contains functions to manage external loads, for the purpose of publishing data in batch mode.

The Data Location Database Schema stores tables that contain the hub data.

This schema contains the landing (or staging) tables used to publish data into the hub. It also hosts the golden records tables and all the intermediate tables used by the certification process.

The data location schema is accessed for integration purposes to:

Consume data from the golden data and master data tables.
Publish data in batch mode in the landing tables.