Data Tools in Oracle Autonomous Database
Oracle Autonomous Database comes with built-in, easy-to-use self-service data management tools. Business and data analysts can quickly connect to other systems, load data, construct reusable transformation processes, generate performance-optimized business models for use in analytics, and find immediate data insights and anomalies.
Get started with data tools for the Oracle Autonomous Database with free workshops.
Data tools features
Wizard-driven data ingest
Data loading selects data from your local computer, tables in other databases, or cloud storage. It then loads that data into new or existing tables in the Oracle Autonomous Database, links to data held in cloud storage, or continuously feeds the data in from a connected cloud store as it is generated.
Data transformation without coding
An easy-to-use user interface enables you to 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.
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 enables you to create a common semantic model on top of your data identifying hierarchies, dimensions, measures and calculations, which can then be used in a number of analysis applications, with query performance fully optimized by the Oracle Autonomous Database.
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.
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 entities’ data, and the impact that changing the source of an entity may have on other entities.
See what top industry analysts are saying about data tools
Wikibon
Wikibon finds Oracle Autonomous Database ecosystem of database types, models, tools, and applications to be the best.
Read the Wikibon report (PDF)
OMDIA
OMIDIA finds Oracle Autonomous Database enabling data analysts, citizen data scientists, and business users with self-service tools.
Read the OMDIA report (PDF)Autonomous Database data tools
Patrick Wheeler, Vice President Product Management
We've made the database administrator’s life easy with Autonomous Data Warehouse, taking the drudgery out of the job, and freeing up time to do higher value work. But there are other users of the database–data analysts, application developers, and data scientists, too.
Read the complete postFeatured blogs
- December 10, 2021 Oracle Database World '21 now available for replay
- October 4, 2021 How to implement self-service data analytics for finance teams
- March 17, 2021 ADW: New innovations
- March 8, 2021 It’s Independence Day every day with the new Autonomous Data Warehouse Data Tools
Data tools resources
Data Tools documentation
- Autonomous Database for analytics and data warehousing tutorials
Learn how to use Autonomous Database for analytics and data warehousing with hands-on workshops that explain key capabilities. - Free step by-step-workshop
Learn how to create a modern data warehouse, set up a data lake, or experiment with machine learning using a hands-on workshop with step-by-step instructions. - Training Plans
Our training plans provide a wide variety of labs and workshops, enabling you to learn cutting-edge skills Oracle Cloud, live. - Oracle Autonomous Database for analytics and data warehousing demo (3:44)
Newsletters
Information, tips, tricks, and sample code for an autonomous, cloud-driven world.
Related products and solutions
Oracle Autonomous Database for analytics and data warehousing
Data marts, Data Warehouse, and Data Lakes
Oracle Autonomous Database for transaction processing and mixed workloads
Database for all applications
Departmental Data Warehouse
A self-service data analytics solution for business teams
Get started with data tools
Try Oracle Autonomous Database
Oracle Cloud offers a Free Tier with a 30-day free trial and Always Free Services.
Follow us @OracleDatabase
Get the latest Oracle Database news, events, and community resources.
Contact us
Interested in learning more? Contact one of our industry-leading experts.