OBIEE Apache Hive

Bounded Rationality

OBIEE 12.2.1

Possible to use apache hive -> data source for OBIEE?

Anyone point me at - references - blogs - real world experiences?

Robert Angel

Have you seen; -

https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-F0C95568-34CD-4421-8A80-C5903C689B15.htm#data_direct_hive

https://kirti-bi-solutions.blogspot.com/2016/10/apache-drill-obiee-12c-configuration.html

Learning by experiment: Connecting OBIEE to Spark

Robert Angel

Also, don't know if Oracle's Big Data Discovery is an option for you; -

https://www.rittmanmead.com/blog/2015/11/oracle-openworld-2015-roundup-part-2-data-integration-and-big-data-in-the-cloud…

I was sure when I was in Oracle that there was mooted to be further integration between Big Data Discovery (Endeca as was) and OBIEE, can any of the great and the good on this space confirm?

Joel Acha

You'll need to use the correct datadirect ODBC drivers to connect Apache Hive to OBIEE - https://www.progress.com/odbc/apache-hadoop-hive

OBIEE will connect to anything that provides an ODBC driver.