5 Creating Dashboards, Reports, and Notebooks with Autonomous Transaction Processing

Autonomous Transaction Processing includes built-in support for data analytics using Oracle Machine Learning (OML) a browser-based interactive data analysis environment for data scientists.

About Creating Dashboards, Reports, and Notebooks with Oracle Machine Learning

Oracle Machine Learning provides the following:

Collaborative Interface for real-time analytics:

  • Based on Apache Zeppelin

  • Allows creation of workspaces, projects, and notebooks

  • Provides a browser-based interactive data analysis environment to develop, document, share, and automate analytical methodologies

  • Notebooks execute in Zeppelin Servers and make secure (TCPS) JDBC connections to Autonomous Transaction Processing for data access.

OML Components:

  • OML User Administration Application:

    • Web based administrative UI for managing (list, create, update, delete) Oracle Machine Learning users

    • Oracle Machine Learning users map to Autonomous Transaction Processing database users

    • Access to Oracle Machine Learning User Management is limited to the administrator

    See Create and Update User Accounts for Oracle Machine Learning for more informaiton on OML User Adminsitration.
  • OML Application

    • Web based application for data scientists

    • Allows for creation of workspaces, projects, and notebooks

    • Notebook execution happens in Zeppelin servers

    See Work with Oracle Machine Learning for Data Access, Analysis, and Discovery for information on accessing OML user workspaces, projects, and notebooks.

Work with Oracle Machine Learning for Data Access, Analysis, and Discovery

You can use Oracle Machine Learning to access data and for data discovery, analytics, and notebooks.

To access Oracle Machine Learning:

  • Sign in to your Oracle Cloud Account at cloud.oracle.com.

  • Open the Oracle Cloud Infrastructure console by clicking the navigation icon next to Oracle Cloud.

  • From the Oracle Cloud Infrastructure left navigation list click Autonomous Transaction Processing.

  1. Select an Autonomous Transaction Processing instance and on the details page click Service Console.
  2. Click Development.
  3. On the Development page click OML Notebooks.
  4. Enter your username and password.
    The Administrator creates OML users. See Create and Update User Accounts for Oracle Machine Learning for details.
  5. Click Sign In.

This shows Oracle Machine Learning user application.


Description of dwcs_oml_top.png follows
Description of the illustration dwcs_oml_top.png

Oracle Machine Learning allows you to access your data in Autonomous Transaction Processing and build notebooks with the following:

  • Data Ingestion and Selection

  • Data Viewing and Discovery

  • Data Graphing, Visualization, and Collaboration

  • Data Analysis

You can also create and run SQL statements and create and run SQL scripts that access your data in Autonomous Transaction Processing.

Work with Analytics and Visualization

Using Oracle Analytics Cloud with Autonomous Transaction Processing

You can use Oracle Analytics Cloud with Autonomous Transaction Processing.

Built on a high-performance platform with flexible data storage, Oracle Analytics Cloud provides a complete set of tools for deriving and sharing data insights.

  • Data preparation: Analysts can ingest, profile, and cleanse data using a variety of algorithms.

  • Data flow: Analysts can prepare, transform and aggregate data, and then run machine-learning models at scale.

  • Data discovery: Subject matter experts can easily collaborate with other business users, blending intelligent analysis at scale, machine learning, and statistical modeling.

  • Data visualization: Analysts can visualize any data, on any device, on premises and in the cloud.

  • Data collaboration: Large organizations and small teams can share data more simply, as you don't need to manage or consolidate multiple versions of spreadsheets.

  • Data-driven: Application developers can utilize interfaces that enable them to extend, customize, and embed rich analytic experiences in the application flow.

For information on connecting from Oracle Analytics Cloud to Autonomous Transaction Processing, see Connect with Oracle Analytics Cloud.

You can find out more information on Oracle Analytics Cloud in Visualizing Data and Building Reports in Oracle Analytics Cloud.