Thursday 29 October 2015

OBIEE 11g integration with Hadoop

OBIEE integration with Hadoop:
Hadoop:
Hadoop is an software framework written in Java for distributed storage and distributed processing of very large data sets on computer clusters built from commodity hardware. The core of Hadoop consists of a storage part (Hadoop Distributed File System (HDFS)) and a processing part (MapReduce).
Data in a Hadoop cluster is broken down into smaller pieces (called blocks) and distributed throughout the cluster. In this way, the map and reduce functions can be executed on smaller subsets of your larger data sets, and this provides the scalability that is needed for big data processing.
Hive:
The Apache Hivedata warehouse software facilitates querying and managing large datasets residing in distributed storage.  It resides on top of Hadoop to summarize Big Data, and makes querying and analyzing easy. Hive provides a mechanism to project structure onto this data and query the data using a SQL-like language called HiveQL.
OBIEE Big data Analytics approach:

Creating Hive ODBC connection:
  1. Create ODBC Connection

Obiee bigdata integration
  1. import metadata using hivedsn
  1. Complete the rpd development based on requirement.
  2. Depoly the repository
  3. Open analytics and create reports

No comments:

Post a Comment