dremio-oss icon indicating copy to clipboard operation
dremio-oss copied to clipboard

Add support for OBIEE and ODVD Oracle products

Open Tagar opened this issue 6 years ago • 1 comments

This PR adds DynamicDBFeatures.INI specific for Dremio.

DynamicDBFeatures.INI is specific for certain Oracle BI products:

  • Oracle Business Intelligence EE (OBIEE)
  • Oracle Data Visualization Desktop (ODVD).

(this might be also used by Oracle BI Publisher, but I'm not sure)

Above Oracle products officially don't support Dremio, so DynamicDBFeatures.INI file is used to list what certain SQL features of a generic ODBC/JDBC datasource are supported. So these Oracle BI products can generate valid SQL queries for those backends. (like if certain subqueries are supported, what analytic functions are available etc).

List of changes I did for Dremio compared against all-defaults "generic-ODBC" data source (taken from OBIEE) can be found here: https://github.com/Tagar/dremio-oss/commit/0c671cf6649fb79526cb52156ec5d63ea8867d2e

I let Anthony Lee and William Kent know that I will be submitting this PR.

Tagar avatar Jun 05 '18 20:06 Tagar

This PR adds DynamicDBFeatures.INI specific for Dremio.

DynamicDBFeatures.INI is specific for certain Oracle BI products:

  • Oracle Business Intelligence EE (OBIEE)
  • Oracle Data Visualization Desktop (ODVD).

(this might be also used by Oracle BI Publisher, but I'm not sure)

Above Oracle products officially don't support Dremio, so DynamicDBFeatures.INI file is used to list what certain SQL features of a generic ODBC/JDBC datasource are supported. So these Oracle BI products can generate valid SQL queries for those backends. (like if certain subqueries are supported, what analytic functions are available etc).

List of changes I did for Dremio compared against all-defaults "generic-ODBC" data source (taken from OBIEE) can be found here: Tagar@0c671cf

I let Anthony Lee and William Kent know that I will be submitting this PR.

Hi Tagar, Can you share how to use this INI file? And how to do the setup on oracle OBIEE and ODV to connect to Dremio ?

Thank you Tanaka M

murinata avatar Sep 19 '19 03:09 murinata