Key Features of Autonomous Transaction Processing

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

Key Features

  • Managed: Oracle simplifies end-to-end management of the database:

    • Provisioning new databases

    • Growing or shrinking storage and compute resources

    • Patching and upgrades

    • Backup and recovery

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

    • Size the Autonomous Transaction Processing dedicated deployment to the exact compute and storage required

    • Scale the Autonomous Transaction Processing dedicated deployment on demand: Independently scale compute or storage

    • Shut off idle compute to save money

  • Autonomous Transaction Processing supports:

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

    • Connectivity via SQL*Net, JDBC, ODBC

    • Third-party data-integration tools

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

  • High-performance features from the latest version of Oracle Database: For more information, see Latest Autonomous Transaction Processing Database Features.

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

  • Oracle SQL: Autonomous Transaction Processing is compatible with existing applications that support Oracle Database.

  • Database migration utility: Easily migrate from MySQL, PostgreSQL, SQL Server, and other databases.

SQL Developer Autonomous Transaction Processing Support

Using Autonomous Transaction Processing with SQL Developer you can do the following:

  • Connect to an Autonomous Transaction Processing dedicated database

  • Create tables, indexes, and materialized views in an Autonomous Transaction Processing dedicated database

  • Load data into an Autonomous Transaction Processing dedicated database

  • Copy tables to an Autonomous Transaction Processing dedicated database

  • Transfer a schema to an Autonomous Transaction Processing dedicated database

Business Intelligence Tools Support

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

  • Oracle Analytics Cloud

  • Third-party Business Intelligence tools