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.