Architecture ODS Model

ETL-ODS Model

end-to-end data warehouse system data flow (ETL – Extract, Transform & Load). The first step (Extract) shows the process of extracting data from different data sources and consolidating into one centralized database (ODS). Source x represents same data structure implemented in multiple instances, each local instance holds a different set of data (e.g.:  separated DB for each subsidiary/customer). Source y represents an enterprise OLTP system DB (e.g.: global ERP, CRM, etc.)