Register and Use Oracle Machine Learning Models

You can register and use Oracle machine learning models from Oracle Database or Oracle Autonomous Data Warehouse to score data in Oracle Analytics. Use the data flow editor to apply the machine learning models to your data.

How Can I Use Oracle Machine Learning Models in Oracle Analytics?

Oracle Analytics allows you to register and use Oracle machine leaning models that reside in database data sources.

Using Oracle machine learning models with Oracle Analytics greatly increases the level of predictive analytics that you can perform on data sets because the data and the model reside in the database, the data scoring is performed in the database, and the resulting data set is stored in the database. This allows you to use the Oracle machine learning execution engine to score large data sets.

You can register and use Oracle machine learning models from these database data sources:
  • Oracle Autonomous Data Warehouse
  • Oracle Database

In Oracle Analytics you can register any of the database's Oracle machine learning models in the mining classes Classification, Regression, Clustering, Anomaly, or Feature Extraction that were created using the Oracle Machine Learning for SQL API (OML 4SQL). Your Oracle Analytics user role and database permissions determine the Oracle machine learning models that are available for you to register and use.

You can also create predictive models in Oracle Analytics. See What Are Oracle Analytics Predictive Models?

Typical Workflow to Register and Use Oracle Machine Learning Models

Here are the common tasks for registering Oracle machine learning models, and how to apply the models to data sets and use them in projects.

Task Description More Information
Register the Oracle machine learning model Use an Oracle Database or Oracle Autonomous Data Warehouse connection to find Oracle machine learning models and register them for use with Oracle Analytics. Register Oracle Machine Learning Models in Oracle Analytics
Apply a model to your data using a data flow Create a data flow to apply an Oracle machine learning model to your data and generate a data set that includes the predicted trends and patterns. Apply a Predictive or Oracle Machine Learning Model to a Data Set

Register Oracle Machine Learning Models in Oracle Analytics

The Oracle machine learning models must be registered in Oracle Analytics before you can use them to predict data. You can register and use models that reside in your Oracle Database or Oracle Autonomous Data Warehouse connections.

  1. In the Home page, click Page Menu and select Register ML Model.
    This option is available for users with the BI Service Administrator or DV Content Author role.
  2. In the Register an ML Model dialog, select a connection.
    In the Select a Model to Register dialog, you'll see the database's Oracle machine learning models in the mining classes Classification, Regression, Clustering, Anomaly, or Feature Extraction that were created using the Oracle Machine Learning for SQL API (OML 4SQL).

    If needed, click Create Connection to create a connection to the Oracle Database or Oracle Autonomous Data Warehouse data source containing the Oracle machine learning model that you want to use.

  3. In the Select a Model to Register dialog, click the model that you want to register and review the model's information. For example, the mining class and algorithm used to build the model, the target the model predicts, the columns the model is trained on, model predictions, and parameters.
  4. Click Register.
  5. From the Home page, click Navigator, and then click Machine Learning to confirm that the model was imported successfully.