Relational databases
Files
Business Applications
SaaS
Web Services
Data Stream
No SQL databases
Hadoop
Social Network
Could platforms
Data sources connection
Data Federation
Filtering
Calculation
Aggregation
Transformation
Data Quality
Cache/Staging/MDM
Risk & Compliance systems
Data Warehouse
Reporting Systems
Analytic Application
Self-service BI
Dashboards
Data Fabric
Data Integration
Data integration involves combining heterogeneous data from disparate sources for providing a unified and consistent view of data.
A typical approach is to extract, transform and load data into a specialized database (an Operation Data Store, a Data Warehouse or a DataMart) using an ETL (Extraction Transformation Load).
An innovative approach consists in using data virtualization technologies for connecting data instead of collecting them.
Data Quality
With the massive increase in the amount of data collected and the broadening data sources, data quality management is more essential and more challenging than ever.
Automation of data quality testing and data cleansing has become an imperative.
Data quality features include:
• Data profiling
• Data standardization, matching and cleansing
• Data enrichment
• Data governance and stewardship
