I suppose at this point the real question is: has the Bristlecone Adapter been tested on OBIEE 12c ? Which version of the NW RFC SDK software from SAP should be installed ? The OBIEE is installed on a Windows Server 2012.

Don't know if that can fix your issue, but we did solve our connection problem by using the Cloudera ODBC driver for the Admintool connection but the Merant drivers 7.1.5 on the system running the BI Server (in our case Linux RHEL).

After many attempts, finally I've been able to create a working subject area retrieving data from an Hive2. Your suggestion (to continue to build the Logical and Presentation models anyway) was actually correct. In addition to that, I did have to use the Hortonworks ODBC driver to build the initial physical model BUT to…

OK, I see the point. I'll give it a try. Thanks. GN

Yes. I believe my description was clear enough, but likely it wasn't. I'm just wondering what you mean by: "so that it's not trying to do a "SELECT *..." it's more like something OBIEE would actually run in practice, along the lines of "SELECT FOO, COUNT(*) FROM TRUCKS GROUP BY FOO;". I've reached the point when metadata…

Could be great, but how ? Here's the part of the local log file of interest. BTW: we've been asked to log a SR for this. ********** Task: 1. Running for (mls): 249 ********** Description: Oracle BI Administration Tool GatewayDbGateway Prepare DSN:Connection pool;userName:hdfs SQL:select from daily_data_reading **********…

Hive over OCI ? Who is saying that ? I'm just trying to do the following: OBIEE 11.1.1.9 Now Supports HiveServer2 and Cloudera Impala - Rittman Mead Consulting but main difference is that instead of Cloudera Impala we have HDP Hive2 but logic is the same. So what's strange here ?

Thank you, but that doesn't apply to our scenario. The schema is shown and query is sent. Also, we aren't talking about an Oracle DB.