Autonomous Database Data Studio Features

Data loading

Wizard-driven data ingestion

Data loading selects data from your local computer, tables in other databases, or cloud storage. It then loads that data into new or current tables in Oracle Autonomous Database, links to data held in cloud storage, or continuously feeds the data in from a connected cloud store as it’s generated.

Data transformation

Data transformation without coding

An easy-to-use user interface lets you create data transformation flows on data from a wide range of connected systems—without writing any code. Drag and drop the components on the design canvas and connect them to design reusable data flows that clean, join, merge, aggregate, and optimize your data for downstream use.

Data analysis

Smart business models

Create business models to describe related business entities derived from data in an Oracle Autonomous Database schema or other sources. The tool lets you create a common semantic model on top of your data identifying hierarchies, dimensions, measures, and calculations, which then can be used in several analysis applications, with query performance fully optimized by Oracle Autonomous Database.

Data insights

Automated data insights

Quickly gain insights and detect anomalies from your data using built-in algorithms from the business models constructed in the data analysis tool or from base tables.

Data governance

Find and understand your data

Understand data dependencies and the impact of changes. Use the catalog to get information about the entities in the database, such as data sets, data origination, a statistical analysis of each entity’s data, and the impact that changing the source of an entity may have on other entities.

Data sharing

Improve collaboration and decision-making across teams

Share data securely and efficiently across different departments, applications, and organizations. Delta Sharing enables data sharing for internal and external teams that do not use Autonomous Database or Oracle Cloud Infrastructure (OCI). Live Share simplifies optimized and native data sharing between Autonomous Database instances.