Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

Dataset Storage vs. Database Connection

Accepted answer
23
Views
1
Comments
Matt_B
Matt_B Rank 4 - Community Specialist
in Oracle Fusion Data Intelligence

From the perspective of an FDI end-user concerned with saving their datasets, data flows, and workbooks in an optimal manner for scaling and long-term usage (access/sharing, reusability, space/costs, etc.), can you please explain the difference in Dataset Storage vs. Database Connection?

Any key insights to keep in mind or potential missteps to avoid when delineating Dataset Storage vs. Database Connection would be very helpful. Thank you

Tagged:

Best Answer

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

    @Matt_B -

    Here’s a quick breakdown of the differences between Database Connection and Dataset Storage in OAC to help with your decision:

    Database Connection:

    • Handles large datasets efficiently with optimized queries.
    • Data remains in the external system, making it accessible outside OAC.
    • Always reflects the latest data without requiring manual updates or refreshes.

    Dataset Storage:

    • Stores the dataset directly within OAC (Fusion Data Intelligence) after upload or transformation via a Data Flow.
    • Faster for reporting and analysis since the data is cached in OAC.
    • Limited to OAC users—external database queries are not possible.
    • Requires manual updates when the source data changes unless scheduled refreshes are configured.

    Hope this helps to make a decision based on your requirement!.