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 [firstname.lastname@example.org] FROM EXTERNAL PROVIDER to create such users. We are trying to export data from the SQL databases using Sqoop v18.104.22.168.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?
Hi Sumaiya. No, we got confirmation from Hortonworks that Azure Active Directory authentication is not supported.