0

We were not able add Azure SQL Server as external data source in Dremio. We have disabled the firewall to allow all access (at the Azure SQL Server end) to connect to Azure SQL Server, but it was still throwing an error and it was not able to connect from Dremio.

Please let us know if we will need to configure a firewall on route from the Dremio server end to connect to the Azure SQL Server.

Error output:

> Error : Could not connect to intake-dev,   
> check your JDBC connection information and credentials.

Note: We have checked that the credentials passed are accurate, and we were able to connect from SSMS using these.

karel
  • 5,489
  • 46
  • 45
  • 50
Sunil
  • 1
  • 1
  • Az SQL Server connection can be added in Dremio . We had to open the firewall port from src: dremio to connect dest: - az sql server . – Sunil Sep 24 '22 at 15:09
  • Could you please give more info on opening firewall port from source (Dremio)? – idkman Feb 27 '23 at 09:27

1 Answers1

0

Unfortunately, Dremio does not support Azure SQL Server as a source. Check this post on dremio community.

Utkarsh Pal
  • 4,079
  • 1
  • 5
  • 14
  • The response on the post is as of 2019. Is this response still valid? – Gandhi Sep 28 '21 at 11:08
  • I hope so because there is no supported document available from Dremio and Microsoft. There is proper documentation available for Dremio and Azure Data Lake Storage(ADLS) integration, but there is nothing for Azure SQL Server. – Utkarsh Pal Sep 28 '21 at 11:12