Key Features of Autonomous Data Warehouse

This section describes key features of Autonomous Data Warehouse, an affordable, feature-rich service in the cloud.

Key Features

  • Managed: Oracle simplifies end-to-end management of the data warehouse:

    • Provisioning new databases

    • Growing or shrinking storage and compute resources

    • Patching and upgrades

    • Backup and recovery

  • Fully Tuned: “Load and go”:

    • Define tables, load data, run queries

    • Provides good performance out of the box

    • Run your queries using any business analytics tool or cloud service

    • Built-in SQL worksheet and notebook also included

  • Fully elastic scaling: Scale compute and storage independently to fit your data warehouse workload with no downtime:

    • Size the Autonomous Data Warehouse to the exact compute and storage required

    • Scale the Autonomous Data Warehouse on demand: Independently scale compute or storage

    • Shut off idle compute to save money

  • Auto scaling: Allows your database to use more CPU and IO resources automatically when the workload requires it:

    • Specify the number of OCPUs for Autonomous Data Warehouse workloads.

    • Auto scaling allows the database to use up to three times more CPU and IO resources depending on workload requirements.

    • Auto scaling is enabled by default when you create an Autonomous Database instance or you can use Scale Up/Down on the Oracle Cloud Infrastructure console to enable or disable auto scaling.

  • Autonomous Data Warehouse supports:

    • Existing applications, running in the cloud or on-premise

    • Connectivity via SQL*Net, JDBC, ODBC

    • Third-party data-integration tools

    • Oracle cloud services: Oracle Analytics Cloud, Oracle GoldenGate Marketplace, Oracle Integration Service, and others

  • High-performance queries and concurrent workloads: Optimized query performance with preconfigured resource profiles for different types of users.

  • Oracle SQL: Autonomous Data Warehouse is compatible with existing applications that support Oracle Database.

  • Built-in web-based data analysis tool: Web-based notebook tool for designing and sharing SQL based data-driven, interactive documents.

  • Database migration utility: Easily migrate from Amazon AWS Redshift, SQL Server, and other databases.

Simple Cloud-based Data Loading

Autonomous Data Warehouse provides:
  • Fast, scalable data-loading from Oracle Object Store, Azure Blob Storage, AWS S3, or on-premise data sources.

SQL Developer Autonomous Data Warehouse Support

Using Autonomous Data Warehouse with SQL Developer you can do the following:

  • Connect to Autonomous Data Warehouse

  • Create tables in Autonomous Data Warehouse

  • Load data into Autonomous Data Warehouse

  • Copy tables to Autonomous Data Warehouse

  • Transfer a schema to Autonomous Data Warehouse

Business Intelligence Tools Support

Autonomous Data Warehouse is compatible with a number of business intelligence and data visualization tools from Oracle and from trusted third parties.

  • Oracle Analytics Cloud

  • Oracle Analytics Desktop

  • Third-party Business Intelligence tools