Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Does Oracle Analytics Cloud support real-time streaming dashboards?

Accepted answer
164
Views
3
Comments
Krishna90
Krishna90 Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

I have connected OAC to real-time stream data and enabled the auto-refresh feature for real-time visualization. However, the graph is fluctuating. I used the following pipeline for streaming data to OAC: Kafka -> Goldengate Stream Analytics -> ADW -> OAC. How can I provide Realtime visualization without any fluctuation in the graph? . Please go through the below UI video

Realtime_streaming.mp4
Tagged:

Best Answer

  • KhaderBelgoud-Oracle
    KhaderBelgoud-Oracle Rank 4 - Community Specialist
    Answer ✓

    @@Krishna90 Build your visualization using a dataset that has the Live Data access.

    Live - If you select this option, then the table gets its data directly from the data source.
    When a table is set to Live, the source system manages the table's data source queries.
    This option is useful when the data is stored in a high-performance system such as Oracle
    Autonomous Data Warehouse. It also ensures that the latest data is used.

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Krishna90 - Every time a visualization is refreshed you would see such behavior in OAC. But, what is your use case here and why would you need to refresh the data so extensively, why not after a specific amount of time like after every 2 mins or 5 mins etc.. to workaround this.

  • Krishna90
    Krishna90 Rank 2 - Community Beginner

    @Sumanth V -Oracle Hi Sumanth ,

    I need to provide real-time visualization. In ADW, the data is reaching at real-time speed without any latency. However, without enabling a scheduler or auto-refresh, the graph does not update automatically in OAC. I need a real-time chart in OAC that will update automatically without any external push.