OBIEE 12c : Configuration And Integration With Teradata Presto (Doc ID 2258629.1)

Last updated on JULY 11, 2022

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.1.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.

Version Compatibility
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 12.2.1.1 and higher.

Purpose

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.

Scope

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:

Indirect	OBIEE connected to Teradata which is connected to Presto via query grid
Custom	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.
Native	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.