DATA GATEWAY – CLOUDERA CONNECTION - IMPERSONATE

[Anonymous]

I’ve an On Premise Data Gateway active with an ODBC connection for IMPALA and HIVE, the authentication is done by a service_user, in CLOUDERA the option for impersonate accounts is active for that user.

In Power BI Service I success configure that Data Source (Manage Gateways) with the authentication made by that service_user. On the refresh of the information, has expected, that service_user is visible in the logs of the Cloudera (by Navigator).

My company only allow connections where we can view the real username not the service_user. How can I configure the Gateway Data Source so that on the refresh of the information the real username (O365 login) is passed automatically, not the service_user? For example using the option impersonate or some other “comment” on the queries.

This requirement is achieved when the IMPALA Connector in the Data Gateway supports SSO KERBEROS (expected in December 2017, not) but until then how I can pass the real username.

Best regards,

Ricardo

[v-yuezhe-msft]

@Anonymous,

I haven't found any methods that could be used to mask the service_user, but how about you use the impala connector and anonymous authentication?

In addition, regarding the impala SSO Kerberos support, please vote up this idea.

Regards,
Lydia

[Anonymous]

I'm waiting for the SSO Kerberos support and already voted (my team too) in tha ideia.

About the Anonymous Authentication we want to know the user that access/refresh the dataset in the Service, I don't think I can obtain the user in the Cloudera Logs with that Authentication. In the Desktop there's no problem because the authentication is done via Kerberos ou LDAP.

Do you have any example for  Anonymous Authentication in Cloudera Impala?

[v-yuezhe-msft]

---

I don't think I can obtain the user in the Cloudera Logs with that Authentication.

---

@Anonymous,

I agree with you. Please check the following similar thread about using Anonymous authentication to connect to Impala.

https://community.powerbi.com/t5/Integrations-with-Files-and/Impala-issue-This-data-source-cant-be-accessed-by-a-data-gateway/m-p/259006

Regards,
Lydia