Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

With Autonomous Data Warehouse (ADW), you will simplify the process of gaining insights from data. You can:
• Deploy fully-managed data marts and data warehouses as well as integrate existing data lakes in minutes.
• Use a wide range of built-in self-service tools for extracting, loading, and transforming data.
• Use built-in tools (including Oracle Analytics Cloud) or your favorite applications (like Excel or 3rd party BI tools) to run sophisticated reports.
• Gain deeper insights like predictions and recommendations using machine learning, graph, spatial, text algorithms, and more.

Use the below 5-step “how to” process for setting up your data warehouse and analytics – First, familiarize yourself with the process using a quick overview and demos. Once that’s complete, you can try it using the free Oracle LiveLabs. If you need more information, check out the documentation and reference architectures for each step.

Step 1: How do I create my analytics environment?

Your first step is to create an instance of Autonomous Database and connect your analytics services and tools, such as Oracle Analytics Cloud (OAC) or 3rd party BI tools. Take a quick tour of ADW services and learn how ADW works with OAC.

ADW Services Tour (3:14)

Video demo

ADW and OAC (3:13)

Video demo

ADW Quick Start - How to Connect to Autonomous Database

Deploy ADW tutorial

Connect to Oracle Autonomous Database using a Wallet tutorial

Video tutorial

Step 2: How do I load and transform my data?

Oracle Data Studio comes pre-built with Autonomous Database. Data Studio is a suite of easy-to-use self- service data engineering and management tools. No matter what your role is - business or data analyst, data scientist, or developer - you can quickly connect and integrate data from 3 rd party platforms to load and construct reusable transformation processes. You can load data from any data source or location, including data lakes, open-source platforms, or multiple systems.

play-icon Overview

Introducing Autonomous Data Tools Data Studio

Simplified data integration

Video demo

Data Loading

Video tutorial

Data Transforms

Video demo

Data Catalog

Video tutorial

Integrate data across clouds

Video demo

Load Data from Public Cloud into Autonomous Data Warehouse

Video tutorial

Step 3: How do I quickly get insights using my data?

Running analytics and getting values from your data is simple with Oracle Autonomous Data Warehouse.

As a data engineer and/or database administrator, you can use Data Studio to generate and share performance-optimized business models and find immediate insights and anomalies. You can also use familiar tools such as Excel add-in and SQL Worksheet. As a business analyst, you can use the analytics tools of your choice, including Oracle Analytics Cloud (OAC), Microsoft Excel, and other 3rd party BI tools. For a complete list of supported 3rd party tools, click here.

play-icon Overview

Introducing Autonomous Data Tools

Oracle Data Studio demos:

Data Insights

Video demo

Data Analysis

Video tutorial

ADW and OAC

Video demo

Analyze all data with Oracle SQL

Video tutorial

Step 4: How do I extend my data warehouse with a data lake?

Data lakes have increasingly become a key part of data platforms. With Autonomous Database, you can integrate and query multiple data lakes at scale.

play-icon Overview

Autonomous Database enhances data lake analytics

Extend Autonomous Data Warehouse with Data Lake demos:

Work with Object Store data

Video demo

Analyze the data lake with ADW and OCI Data Catalog demo

Video tutorial

Step 5: How do I build new solutions or add new capabilities?

With Autonomous Data Warehouse (ADW), you can expand your analytics use cases using in-database advanced analytics such as machine learning, spatial analytics, and graph analytics. You can easily add new use cases using all data types stored in ADW.

play-icon Overview

What is a Converged Database?

Additional capability with Oracle Autonomous Data Warehouse demos:

Predict customer churn Personalized recommendation using Machine Learning demo

Video demo

Personalized recommendation engine using Graph demo

Video tutorial

Autonomous Data Warehouse

Get Started Now—Deploy a complete analytic environment and engage with your data

Category List