Data integration

Database Design

Lis Sulmont

Curriculum Manager

What is data integration

Data Integration combines data from different sources, formats, technologies to provide users with a translated and unified view of that data.

Database icon representing a unified data model

Three data sources with no connection to the unified data model

Three data sources with no connections to the unified data model and with different formats

Three data sources with different formats unconnected to the unified data model which is a Redshift data warehouse

Three data sources with different formats and from different departments unconnected to the unified data model which is a Redshift data warehouse

The three data sources updating daily

The three data sources updating in real-time

The three data sources updating at different times

The three data sources connect to the unified data model

The three data sources updating daily with a big X over it

The three data sources being transformed to fit the unified data model

Processing the three data sources via ETL to the unified data model

ETL diagram with testing icons at each phase

ETL diagram showing portions of data that should be restricted from its source to destination

ETL diagram with anonymization of credit card data

ETL diagram with a line representing the flow of data from its source to destination

Database Design