Hi Gurus,

We are facing an issue to connect from OBIEE12c ( Linux Server) to Cloudera ODBC driver for impala using Kerberos connectivity.

Issue Details :

cloudera odbc 10380 unable to establish a connection with data source. Missing settings: {[HOST] [Port]}

[Cloudera] [ODBC] (10210) Attribute identifier invalid or not supported: 1063

We are following the below configuration;

• We are able to generate the MIT kerberos  ticket in windows client machine.
• On linux server, we have installed cloudera odbc driver.
• We have configured all the required parameters in obis.properties,odbc.ini and .bash file.

ODBC.ini details are as below

[ODBC Data Sources]

CLOUDERA_IMPALA=Cloudera ODBC Driver for Impala 64-bit

[CLOUDERA_IMPALA]

Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so

Description=Cloudera ODBC Driver for Impala 64-bit

HostName= XXXXXX

PortNumber=21050

AuthMech=1

KrbFQDN= XXXXXXX

KrbRealm=XXXXX

KrbServiceName=impala

UseSASL=0

Username=

Password=

ArraySize=16384

Database=sama_soa

DefaultLongDataBuffLen=1024

DefaultOrderByLimit=-1

EnableDescribeParam=0

LoginTimeout=30

MaxVarcharSize=2000

RemoveColumnQualifiers=0

StringDescribeType=12

TransactionMode=0

UseCurrentSchema=0

WireProtocolVersion=2

Could you please help me to resolve this issue.

Best Regards,

Ritesh