Oracle Fusion Data Intelligence

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

Autonomous Data Warehouse significance for OAC

Received Response
124
Views
10
Comments
Ashraf Bilal.R
Ashraf Bilal.R Rank 1 - Community Starter
edited Aug 13, 2024 7:27PM in Oracle Fusion Data Intelligence

Hi,

We are looking for assistance to understand the importance of Autonomous data warehouse with regards to OAC.

What benefit or feature it adds to the analytic tool OAC.

Regards

Ashraf Bilal

Answers

  • RanaAshutosh-Oracle
    RanaAshutosh-Oracle Rank 6 - Analytics Lead

    OAC and ADW are both cloud-based platforms that incorporate advanced artificial intelligence and natural learning capabilities. They offer robust capabilities for data analysis and visualization.

    OAC leverages ADW to empower users with data visualizations, semantic analysis, and predictive analytics. This integration enables enterprises to effectively identify key performance indicators (KPIs), manage data integration, and plan their data and analytics strategy for the future.

    A modern data warehouse, such as ADW, operates autonomously, ensuring security and significantly reducing administration costs. This automation also reduces administration workload, enabling business units to operate independently without extensive reliance on support.

    The integration between OAC and ADW is seamless, allowing users to load data into ADW directly from OAC without requiring expertise as a database administrator or coding skills.

    OAC is designed for natural and intuitive interactions, enhancing user experience. Both OAC and ADW represent significant advancements in optimizing data analytics. Self-service Cloud Analytics provided by OAC and ADW address business needs effectively, as data-driven analytics offer deeper insights into organizational operations and individual business units. Analytics also promote accountability, transparency, strategic decision-making, continuous improvement, and increased productivity.

    They fulfill the demand for cloud-based analytics and data warehousing, providing flexible, self-service tools that boost the productivity of developers, analysts, and data scientists.

    ADW boasts an autonomous warehousing environment, ensuring rapid query performance. Meanwhile, OAC offers scalability and security, equipped with a comprehensive suite of features to facilitate collaborative analytics across individuals, business units, and enterprises. Additionally, users benefit from flexible service options.

    Please check :

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

    @Ashraf Bilal.R

    The integration between OAC and ADW is seamless, enabling you to effortlessly load data into ADW through OAC without requiring expertise as a DBA or coding skills.

    ADW provides an autonomous warehousing environment, ensuring swift query performance. Meanwhile, OAC offers scalability and robust security alongside a comprehensive suite of features for collaborative analytics, catering to your needs, your business unit, and your enterprise.

    Additionally, you benefit from flexible service management features, including rapid setup, simple scaling and patching, and automated lifecycle management.

    Also, with ADW you can use OAC features like Data replications to load data from Fusion source.

  • Ashraf Bilal.R
    Ashraf Bilal.R Rank 1 - Community Starter

    The update was informative but I have one simple question.

    OAC will be using ADW or ADW is going to use OAC.

    At one place you are saying ADW would facilitate non experts, performance and reducing the administration cost and other place you say data would by pulled into ADW directly by OAC.

    These statements are confusing hope you understand my concern.

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

    @Ashraf Bilal.R - OAC will be using ADW. OAC is the analytical tool and ADW would be it's source for data.

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

    @Ashraf Bilal.R - Hope we helped answer your queries, if there are no more concerns please do accept the answer provided, so that it helps other users having similar concerns. Thanks.

  • Ashraf Bilal.R
    Ashraf Bilal.R Rank 1 - Community Starter

    So how will the ADW would have data for OAC to use

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

    @Ashraf Bilal.R - If you're utilizing FAW/FDI, ADW retrieves data from source Fusion Applications via a pipeline. Alternatively, for other source applications, ADW acquires data through ETL tools or processes, particularly if it's designated as the target warehouse.

  • Ashraf Bilal.R
    Ashraf Bilal.R Rank 1 - Community Starter

    Is there OIC in picture anywhere around

  • RanaAshutosh-Oracle
    RanaAshutosh-Oracle Rank 6 - Analytics Lead

    You can also Create a Connection to Oracle Autonomous Data Warehouse directly : https://docs.oracle.com/en/cloud/paas/analytics-cloud/tutorial-create-connection-to-oawd/#before_you_begin