Autonomous Database Data Studio Features
Data loading
Quick loading, linking, or feeding of data into Autonomous Database
Load data easily from anywhere—local files, spreadsheets, or object stores located across multiple clouds such as Oracle Cloud Infrastructure (OCI), Azure, AWS, or Google Cloud. Autonomous Database's Data Load helps save time by creating a new table where you can either link to or ingest the data altogether into your instance. It will automatically detect the schema, column types, row values, etc.—a process that is typically time-consuming if you’re trying to ingest many data sources.
AI-enhanced data load
Prepare and load data using the power of Autonomous Database’s Table AI Assistant and natural language. Instead of writing SQL statements, you can use natural language to perform complex data engineering tasks such as automatically transforming and cleaning data or adding, renaming, and/or removing columns.
Data transformation
Enterprise-grade data integration
Leverage Data Studio’s Data Transforms, a full-featured, built-in data integration tool for data engineers to design and run data pipelines into Autonomous Database. Connect to more than 100 data sources with prebuilt connectors via an intuitive drag-and-drop UI to extract data fully or incrementally through scheduled jobs. Restructure, prepare, clean, and enhance data for analytics, data science, machine learning, graph, and spatial with a comprehensive library of built-in Data Transforms capabilities.
Generative AI pipeline automation
Generate and store text and image vector embeddings in Autonomous Database using its simple drag-and-drop UI. Seamlessly integrate data pipelines from within the database or from external sources. Create a continuous AI pipeline through scheduled updates.
Data analysis
Smart business models
Develop comprehensive business models to describe related business entities derived from data in an Oracle Autonomous Database schema or from other sources. Create a common semantic model on top of your data for hierarchies, dimensions, measures, and calculations. You can then share that model across multiple analysis applications, with query performance fully optimized by Oracle Autonomous Database.
Data analysis via Microsoft Excel or Google Sheets
A simple add-in enables you to leverage the native Microsoft Excel and Google Sheets capabilities you're familiar with to query and analyze your enterprise data located in Autonomous Database.
Data insights
Automated data insights
Quickly gain insights and detect anomalies from your data using built-in algorithms from the business models you’ve constructed in the data analysis tool or from base tables.
Data governance
Data lineage tracing and impact analysis
Understand data dependencies and the impact of changes. Use the Data Studio Catalog to access details about 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
Improved 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 OCI. Live Share simplifies optimized and native data sharing between Autonomous Database instances. Govern your shares with fine-grained access control and simple access management.