Connect to Hive on the Alteryx Server and successfully authenticate using kerberos

archana986

Hi ,

I need help to set up Hive connections on the Alteryx Server (VM). This would be a generic DSN and then I want to create connection strings which will override the DSN but will also get authenticated via kerberos using the ALIAS manager. Both My Alteryx Server and Hive Database are authenticated by Kerberos. 

Issues I have: 1. I Cant use in-Db because on the server Share drive, its not secure. 2. I can parse individual user names for individual users as long as the user get authenticated at run-time. 3. I can use a service account but delegation is not an option available at the point. What kind of connection string can I create that will work for a group of users (Service account) having the user names or password? But this needs to be authenticated by Kerberos. 

I don't have a single solution to set up Hive connections which will take care of authentication and Physical DSN setup by one Admin at the same time.

dataMack

I've found that using IN-DB connections with a file work very well for Hive and Impala with Kerberos.  The In-DB connection file is just an XML representation of the connection string, and since it uses Kerberos, no credentials are stored- just generate the ticket for your run-as account.  Then when workflows are published to server, the connection file gets packaged with the workflow- no need to setup DSNs on server- just make sure the driver is installed.