Support for streaming analytics
Organization Name
Consulting
Description
Oracle DV dashboards need to be refreshed manually which do not serve purpose for streaming use cases. Specially when users are tracking time sensitive events like storms, natural disasters.
This feature is currently supported by PowerBI and many clients would like this functionality.
Use Case and Business Need
Monitor live events and generate key metrics and impacts for streaming sensor data
Original Idea Number: 9a4647df24
Comments
-
Hi Akhil,
Have you checked the Auto Refresh plug-in on the Oracle Analytics Library? It allows you to refresh a DV page every n seconds.
https://www.oracle.com/business-analytics/data-visualization/extensions.html
Kind regards,
Philipp
0 -
Thanks Phillip, I just saw the demo of the plugin.
This somehow addresses the requirement, refer to below link from PowerBI for streaming data sets.
Below is exactly what users are asking for
https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming
0 -
Which aspects are they looking for? There are several features on that page. For example, Philipp pointed to getting your charts updated frequently. This seems like the primary requirement. What else do they want to see?
0 -
Requirement is to support streaming data from Kafka streams and put in a real time update to the reports.
In the PowerBI link I shared, refer to streaming data set portion in there.
Well I do agree, auto refresh plugin does satisfy the requirement (The missing piece is the real time update for specific tiles and report actual streaming update as in data comes not every 5 secs or 1 sec)
0 -
I agree. Currently there is no ready made option available to support streaming service dashboard.
0 -
Have you looked a combining OCI Stream Analytics with OAC?
https://blogs.oracle.com/dataintegration/what-is-oracle-stream-analytics
https://www.oracle.com/middleware/technologies/stream-processing.html
This combined with landing the data or often aggregates in ADW for OAC reports can be a very robust solution -- especially if you also build real-time, machine driven events based on stream based thresholds.
0 -
This use case can also be addressed using Oracle Cloud SQL
0
