Autonomous AI Database Data Studio Features

Try Oracle Autonomous AI Database for free

Key features

Data loading

Quick loading, linking, or feeding of data into Autonomous AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 catalog

Search, discover, and access all data

Gain a unified view of all your enterprise data across clouds and on premises with Catalog, including support for Apache Iceberg tables. Discover, access, and analyze data across databases, data lakes, and external catalogs—such as Databricks Unity, Snowflake Polaris, and AWS Glue—without complex integration.

Data governance

Use Catalog to understand data dependencies and the impact of changes to your data. Gain detailed information about entities in the database, including data origination, statistical analysis of each entity’s data, and the resulting impact that changing the source of a data 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 directly with internal and external teams that do not use Autonomous AI Database or Oracle Cloud Infrastructure (OCI).

- Live Share simplifies native data sharing between Autonomous AI Database instances.

Create and share data products via Marketplace

Securely create and publish data sets to Marketplace for easy discovery by other teams in your organization—no coding required. Query data directly within Marketplace, or load it into your own Autonomous AI Database instance for analysis.