Home
%3CLINGO-SUB%20id%3D%22lingo-sub-989590%22%20slang%3D%22en-US%22%3EIngest%20real%20time%20streaming%20data%20in%20SQL%20Database%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-989590%22%20slang%3D%22en-US%22%3E%3CH1%20id%3D%22toc-hId-2049160769%22%20id%3D%22toc-hId-2049160769%22%3E%3CFONT%20size%3D%225%22%3E%3CSTRONG%3EIngest%20real%20time%20streaming%20data%20in%20SQL%20Database%20tables%20directly%20from%20the%20Azure%20SQL%20Portal%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FH1%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20have%20real%20time%20streaming%20data%20in%20Event%20Hub%20or%20IoT%20Hub%3F%3C%2FP%3E%0A%3CP%3EDo%20you%20want%20to%20ingest%20that%20data%20in%20your%20SQL%20Database%20without%20leaving%20your%20SQL%20Database%3F%3C%2FP%3E%0A%3CP%3EGood%20news!%20You%20can%20now%20stream%20data%20into%20your%20SQL%20Database%20in%20a%20few%20simple%20clicks%20to%20enable%20a%20wide%20variety%20of%20scenarios%20such%20as%20connected%20car%2C%20remote%20monitoring%2C%20fraud%20detection%20and%20many%20more.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EData%20Engineers%20work%20with%20streaming%20data%20in%20SQL%20Database%20daily.%20However%2C%20ingesting%20streaming%20data%20in%20a%20SQL%20DB%20table%20has%20been%20fraught%20with%20complexity.%20Users%20have%20found%20it%20difficult%20to%20easily%20ingest%2C%20process%20and%20view%20real-time%20data%20without%20switching%20back%20and%20forth%20between%20services.%20This%20context%20switching%20makes%20it%20easy%20to%20lose%20track%20of%20one%E2%80%99s%20place%20and%20setting%20up%2Fconfiguration%20is%20prone%20to%20error.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EToday%2C%20we%20are%20happy%20to%20announce%20%3CSPAN%3Ereal%20time%20streaming%20data%20into%20a%20SQL%20Database%20table%20directly%20from%20the%20Azure%20SQL%20Portal.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EUsing%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fstream-analytics-introduction%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%3EAzure%20Stream%20Analytics%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%3E%2C%20you%20can%20now%20ingest%2C%20process%2C%20view%20and%20analyze%20real%20time%20streaming%20data%20into%20a%20SQL%20Database%20table%20directly%20in%20the%20Azure%20SQL%20Portal%2C%20without%20switching%20context%20between%20services!%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F155541iD850E2CEB2B164E7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Picture000.png%22%20title%3D%22Picture000.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH4%20id%3D%22toc-hId--1092536707%22%20id%3D%22toc-hId--1092536707%22%3E%3CFONT%20size%3D%225%22%3EKey%20benefits%3C%2FFONT%3E%3C%2FH4%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%3EMinimum%20context%20switching%3A%20You%20can%20start%20from%20a%20SQL%20Database%20in%20the%20portal%20and%20start%20ingesting%20real-time%20data%20into%20a%20table%20without%20switching%20to%20any%20other%20service.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EReduced%20number%20of%20steps%3A%20The%20context%20of%20your%20database%20and%20table%20is%20used%20to%20pre-configure%20a%20Stream%20Analytics%20job.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EAdditional%20ease%20of%20use%20with%20preview%20data%3A%20Preview%20incoming%20data%20from%20the%20events%20source%20(Event%20Hub%2FIoT%20Hub)%20in%20the%20context%20of%20selected%20table%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CH4%20id%3D%22toc-hId-650273628%22%20id%3D%22toc-hId-650273628%22%3E%26nbsp%3B%3C%2FH4%3E%0A%3CH4%20id%3D%22toc-hId--1901883333%22%20id%3D%22toc-hId--1901883333%22%3E%3CFONT%20size%3D%225%22%3EGet%20started%20today%3C%2FFONT%3E%3C%2FH4%3E%0A%3CP%3E%3CSPAN%3EHere%20are%20the%20%3CSTRONG%3E5%3C%2FSTRONG%3E%20easy%20%3CSTRONG%3Esteps%3C%2FSTRONG%3E%20you%20can%20take%20%3CSTRONG%3Ewithin%3C%2FSTRONG%3E%20%3CSTRONG%3ESQL%20Database%3C%2FSTRONG%3E%20to%20get%20started%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3E%3CSPAN%3EIn%20SQL%20Database%20portal%2C%20select%20the%20database%20where%20you%20want%20to%20ingest%20streaming%20data%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3ESelect%20real%20time%20streaming%20events%20source%20%3C%2FSPAN%3E(Event%20Hub%2FIoT%20Hub)%3C%2FLI%3E%0A%3CLI%3ESelect%2FCreate%20SQL%20table%20where%20you%20want%20to%20store%20your%20transformed%20events%3C%2FLI%3E%0A%3CLI%3EView%20incoming%20events%20and%20write%2Ftest%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fstream-analytics-stream-analytics-query-patterns%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESAQL%20query%3C%2FA%3E%20to%20transform%20events%3C%2FLI%3E%0A%3CLI%3EStart%20the%20stream%20analytics%20job%20which%20will%20start%20ingesting%20data%20from%20Step%202%20to%20step%203%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3ETo%20get%20started%2C%20see%20the%20detailed%20documentation%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fsqldbasa%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F155542i0FE45319FB1FE8B9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Webp.net-gifmaker.gif%22%20title%3D%22Webp.net-gifmaker.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CH4%20id%3D%22toc-hId--159072998%22%20id%3D%22toc-hId--159072998%22%3E%3CFONT%20size%3D%225%22%3EFeedback%20and%20engagement%3C%2FFONT%3E%3C%2FH4%3E%0A%3CP%3EEngage%20with%20us%20and%20get%20early%20glimpses%20of%20new%20features%20by%20following%20us%20on%20Twitter%20at%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FAzureStreaming%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%40AzureStreaming%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3EThe%20Azure%20Stream%20Analytics%20team%20is%20highly%20committed%20to%20listening%20to%20your%20feedback%20and%20letting%20the%20user's%20voice%20influence%20our%20future%20investments.%20We%20welcome%20you%20to%20join%20the%20conversation%20and%20make%20your%20voice%20heard%20via%20our%20%3CA%20href%3D%22https%3A%2F%2Ffeedback.azure.com%2Fforums%2F270577-stream-analytics%2Ffilters%2Ftop%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EUserVoice%20page%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-989590%22%20slang%3D%22en-US%22%3E%3CP%3EDo%20you%20have%20real%20time%20streaming%20data%20in%20Event%20Hub%2FIoT%20Hub%3F%20Do%20you%20want%20to%20ingest%20that%20data%20in%20your%20SQL%20Database%20without%20leaving%20your%20SQL%20Database%3F%20Good%20news!%20You%20can%20now%20stream%20data%20into%20your%20SQL%20Database%20in%20a%20few%20simple%20clicks.%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Microsoft

Ingest real time streaming data in SQL Database tables directly from the Azure SQL Portal

 

Do you have real time streaming data in Event Hub or IoT Hub?

Do you want to ingest that data in your SQL Database without leaving your SQL Database?

Good news! You can now stream data into your SQL Database in a few simple clicks to enable a wide variety of scenarios such as connected car, remote monitoring, fraud detection and many more.

 

Data Engineers work with streaming data in SQL Database daily. However, ingesting streaming data in a SQL DB table has been fraught with complexity. Users have found it difficult to easily ingest, process and view real-time data without switching back and forth between services. This context switching makes it easy to lose track of one’s place and setting up/configuration is prone to error.

 

Today, we are happy to announce real time streaming data into a SQL Database table directly from the Azure SQL Portal. Using Azure Stream Analytics, you can now ingest, process, view and analyze real time streaming data into a SQL Database table directly in the Azure SQL Portal, without switching context between services!

 

Picture000.png

 

Key benefits

  • Minimum context switching: You can start from a SQL Database in the portal and start ingesting real-time data into a table without switching to any other service.
  • Reduced number of steps: The context of your database and table is used to pre-configure a Stream Analytics job.
  • Additional ease of use with preview data: Preview incoming data from the events source (Event Hub/IoT Hub) in the context of selected table

 

Get started today

Here are the 5 easy steps you can take within SQL Database to get started:

  1. In SQL Database portal, select the database where you want to ingest streaming data
  2. Select real time streaming events source (Event Hub/IoT Hub)
  3. Select/Create SQL table where you want to store your transformed events
  4. View incoming events and write/test SAQL query to transform events
  5. Start the stream analytics job which will start ingesting data from Step 2 to step 3

To get started, see the detailed documentation here.

Webp.net-gifmaker.gif

Feedback and engagement

Engage with us and get early glimpses of new features by following us on Twitter at @AzureStreaming.

The Azure Stream Analytics team is highly committed to listening to your feedback and letting the user's voice influence our future investments. We welcome you to join the conversation and make your voice heard via our UserVoice page.