OBIEE 12c : Configuration And Integration With Teradata Presto
(Doc ID 2258629.1)
Last updated on OCTOBER 11, 2019
Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.0 and later Information in this document applies to any platform.
This document was originally posted by Teradata employees and is re-posted here for the convenience of our customers to find the solution.
Trackback URL: https://community.teradata.com/t5/Applications/Oracle-BI-Enterprise-Edition-OBIEE-Configuration-and-Integration/td-p/68808
Be certain to check the URL for any changes or updates to the document.
Integration testing of OBIEE and Presto was completed using the Teradata certified distribution of Presto version .148t. Older versions of presto were tested for connectivity, but not for feature/functionality. The corresponding version of the Presto ODBC driver was used.
OBIEE 12.2.1 installed on a Windows server was used in the integration testing. Other versions of OBIEE should work with Presto but they have not been rigorously tested.
This applies to OBIEE 18.104.22.168 and higher.
The purpose of this document is to describe to the implementer(s) how to configure and integrate Oracle BI Enterprise Edition (OBIEE) with Presto. This document assumes you have a rudimentary understanding of OBIEE, Presto, Hadoop and database terminology. Contained within this document is information on version compatibility and the steps to integrate OBIEE with Presto to implement an integrated analytic solution. This includes configuring Presto ODBC connectivity from OBIEE and relevant OBIEE feature table settings.
OBIEE can access Presto via QueryGrid™ or by directly connecting with ODBC. This document describes how to set up OBIEE for a direct connection to Presto. There are 2 versions of ODBC drivers available. One version is open source and is available on GitHub and the Presto website at: https://prestodb.io/resources.html#odbc The other version is Teradata certified. It is rigorously tested and only contains stable functionality. It can be downloaded at: http://www.teradata.com/products-and-services/Presto/Presto-Download OBIEE was tested with the Teradata certified drivers and the Teradata Presto for Hortonworks HDP Sandbox.
Conceptually there are three levels of OBIEE and Presto Integration:
OBIEE connected to Teradata which is connected to Presto via query grid
OBIEE connected to Presto directly with ODBC drivers. Customized OBIEE feature table to support presto capabilities. To be used as-is in the field with no formal support from Oracle.
Oracle develops and incorporates Presto as a certified, supported query engine/data source
The initial integration was focused on delivering the basic “custom” level of integration, namely providing OBIEE report, dashboard and ad-hoc generated SQL access to Presto for retrieving data (information) stored in Hadoop HDFS. As with all OBIEE implementations, OBIEE feature settings for Presto can be modified to meet customer specific needs.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!