Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Azure Active Directory authentication with Sqoop

Azure Active Directory authentication with Sqoop

New Contributor

Hi. We are using Azure HDInsight Spark 2.1 on Linux (HDI 3.6). We have Azure SQL Database (PaaS) to which we connect using contained database users based on Azure Active Directory users as described in https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins, i.e. using CREATE USER [mike@contoso.com] FROM EXTERNAL PROVIDER to create such users. We are trying to export data from the SQL databases using Sqoop v1.4.6.2.6.2.3-1 that comes out-of-the-box with HDInsight. The issue is that Sqoop is not able to authenticate to Azure Active Directory. We can, however, successfully authenticate when using a contained database user that's not associated with an Azure Active Directory principal. After troubleshooting the issue with Microsoft Support, I am starting to think that Sqoop doesn't support Azure Active Directory altogether or that we are using the wrong JDBC driver for Azure Active Directory (which doesn't use Kerberos/LDAP). Is there any way we can get Sqoop to connect to Azure SQL Database?

3 REPLIES 3

Re: Azure Active Directory authentication with Sqoop

New Contributor

Hi @Georgi, where you able to get this to work?

Re: Azure Active Directory authentication with Sqoop

New Contributor

Hi Sumaiya. No, we got confirmation from Hortonworks that Azure Active Directory authentication is not supported.

Re: Azure Active Directory authentication with Sqoop

New Contributor

Thanks @Georgi