I am trying to connect Power BI with an Impala Instance via ODBC. Athentication method is Kerberos. I am able to connect to KDC and receive a valid tgt and a service ticket for impala. There is another Kerberos Instance my client mashine is connected to. If I trie to establish a ODBC connection from Power BI using ODBC Connector a get the following error:
```ODBC: ERROR [HY000] [Cloudera][DriverSupport] (1110) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct and confirm if SSL should be enabled for the connection.````
The Driver uses the wrong `NameUserPrincipal` or rather realm in a method `TETSaslClientTransport`. The driver seems to use the wrong realm `REALM_01` instead of correct realm `REALM_02`. For both realms I have valid tickets in my MIT Kerberos. The following lines show the error from the driver log:
```TETSaslClientTransport::SaslLoggingCallback: ::LogUsername: +++++ enter +++++ TETSaslClientTransport::SaslLoggingCallback: ::LogUsername: Username returned by QueryCredentialsAttributes(SECPKG_ATTR_NAMES): user@REALM_01 TETSaslClientTransport::SaslLoggingCallback: ::LogUsername: User name returned by GetUsernameEx(NameUserPrincipal): user@REALM_01 Jan 13 15:11:31.060 DEBUG 12412 TETSaslClientTransport::SaslLoggingCallback: Failed to initialize security context: Das angegebene Ziel ist unbekannt oder nicht erreichbar.```
Any ideas how to solve this issue?
... View more
i try to connect our cdh 5.15.2 impala instance with power bi. Power BI has this nice impala connector, but it seems not to work for us. We are using kerebros for authentication and authorization on our cluster. If i try to connect to our server using port 21050 i get a `[Microsoft][ThriftExtension] (2) Error occured during authentication`. I am not realy sure if it is possible to connect Power BI to a kerberised cdh instance and if yes which credentials to use for authentication. Can anybody help me. Much regards, peter
... View more