nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Support for streaming analytics

Akhil Tandon

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

Find more posts tagged with

Delivered

Reporting

Status: Delivered

Comments

Philipp Kaufmann-Oracle

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

Akhil Tandon

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

Bret Grinslade - Oracle Analytics-Oracle

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?

Akhil Tandon

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)

M_Kumaran

I agree. Currently there is no ready made option available to support streaming service dashboard.

Bret Grinslade - Oracle Analytics-Oracle

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.

Gabby Rubin-Oracle

This use case can also be addressed using Oracle Cloud SQL