dremio-oss
dremio-oss copied to clipboard
Add support for OBIEE and ODVD Oracle products
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.
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