How to Fetch json from Azure blob storage to on premises SQL Server automatically

Question

How to Fetch json from Azure blob storage to on premises SQL Server automatically

Please help.

Thanks in advance.

Answer 1

@sourav dutta This article describes how to import JSON files into SQL Server. Currently there are lots of JSON documents stored in files. Applications log information in JSON files, sensors generate information that's stored in JSON files, and so forth. It's important to be able to read the JSON data stored in files, load the data into SQL Server, and analyze it.Import JSON documents from Azure Blob Storage

You could use Copy Activity in ADF to transfer data from Azure Blob Storage into SQL DB. There are very detailed guides , How to Copy data from Azure Blob to Azure SQL Database using Azure Data Factory

Azure SQL Database will enable you to directly load files stored in Azure Blob storage by using the following SQL statements: Load files from Azure Blob storage into Azure SQL Database

Import Azure Blob files into SQL Server (CSV/JSON/XML Driver)

There is also similar thread discussion in the SO forum, please refer to the suggestion and let us know the status.

If you still finding any difficulties, We would like to work closer on this issue
Also, let us know which version of SQL are you using?

Additional information: OPENROWSET(BULK) and BULK INSERT T-SQL statements are not yet enabled in Azure SQL Database. You can use them in SQL server on-prem to load files from Azure Blob Storage: https://msdn.microsoft.com/en-us/library/mt805207.aspx
Hope this helps!

Kindly let us know if the above helps or you need further assistance on this issue.

--------------------------------------------------------------------------------------------------------------

Please don’t forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.