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.
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.
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.
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.
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.
Share data securely and efficiently across different departments, applications, and organizations. With the Delta Sharing protocol, users can easily grant access to subsets of their data while maintaining full control over who has access and what they can do with it.