Add SQL Server as a data source in Azure Data Lake Analytics

1
votes

I'm doing some tests with Azure Data Lake Analytics and I can’t add a new SQL Server database as a Data Source. When I click on "Add data source", the only two available options are: "Azure Data Lake Storage Gen1" and "Azure Storage".

What I want is to add one SQL Server database so that I can run U-SQL queries against it.

Our SQL Server firewall is correctly configured to allow access to Azure Services, but I am not allowed to add it as a data source.

How can this be done? Is it a matter of other configuration issues?

Any help would be greatly appreciated.

1
azureazure-sql-databaseazure-data-lake
What do you mean by not allowed to add it ? do you seeing any error ? describe it – Jayendran
@Jayendran I mean that there are no errors, just that I have only these two options to choose. So I cannot choose to add a SQL Server instance. – yet_another_programmer

1 Answers

1
votes

Per my research ,there is no other configuration issues for sql server data source in DLA. Based on this official doc, DLA only supports two data sources:Data Lake Store and Azure Storage.

As workaround , I suggest you using Azure Data Factory to transfer data from sql server database to azure storage so that you could run U-SQL script against data source.

Any concern,please let me know.