CODEWITHSUNDEEP
azureazure-sql-databaseazure-blob-storageazure-stream-analytics
S.Bhatia
S.Bhatia

Reputation: 335

How to stream data from Azure SQL to Azure Blob/Event Hubs?

I have a random integer program in python which is posting the random integers into an Azure SQL Database The data in the Azure SQL Database is updating in realtime, and I want to stream this data into Stream Analytics. Unfortunately, this data can only stream every 1 minute which is way to slow. Thus, I am thinking of using a streaming input in Stream Analytics, such as Azure Blob Storage or Event Hubs. Does anyone know how I could transfer and stream my realtime data to one of these 2 sources, so that I could have Stream Analytics collect my random integer data.

I am using Azure SQL Database to store the data in tables, and then using Stream Analytics to serve as a streaming dataset for Power Bi Online.

All services I have mentioned (apart from Power BI) are located in the Azure Portal.

Upvotes: 0

Views: 1630

Answers (1)

silent
silent

Reputation: 16118

You could use a Logic App for that. They have SQL triggers: https://flow.microsoft.com/en-us/blog/introducing-triggers-in-the-sql-connector/

From there you can easily put a message into Event Hubs or Blob.

Upvotes: 1

Related Questions