Hadoop has complete tool sets to build and run complete Data Warehouse. Happiest Minds helps building both the platform and solution on top the warehouse.
TRANSFORM
Within Hadoop Ecosystem
MapReduce/Hive/Plg could be used to transform data within HDFS
RDBMS
Data migration is one time activity
Structured Data
Transactional Systems
Tools like SQOOP could be leveraged to load from and HDFS
Tools like Flume could leveraged to load data from and to HDFS
- MIGRATE
- EXTRACT
- EXTRACT
- MapReduce
- Hive
- Plg
HDFS
Hadoop Cluster
Flume or Chukwa or Scribe can be used to pull unstructured log data to Hadoop
Sqoop can be used to pull structured data to Hadoop
Once Structured, the data can be moved to Hadoop environment which in turn is connected to BI tools,analytical tools and providing much more efficient way of accessing the data
- COMPUTATION
- QUERY
- Analytics
- Reporting
