Cloudera Tutorials

Optimize your time with detailed tutorials that clearly explain the best way to deploy, use, and manage Cloudera products. Login or register below to access all Cloudera tutorials.

By registering or submitting your data, you acknowledge, understand, and agree to Cloudera's Terms and Conditions, including our Privacy Statement.
By checking this box, you consent to receive marketing and promotional communications about Cloudera’s products and services and/or related offerings from us, or sent on our behalf, in accordance with our Privacy Statement. You may withdraw your consent by using the unsubscribe or opt-out link in our communications.

ClouderaNOW Activate your data, unleash your AI, and scale across any cloud | Dec 9

Register
  • Cloudera Cloudera
  •  

    Introduction

     

    See for yourself how easy it is to create a simple inventory management web application using Cloudera Operational Database and Cloudera AI.

     

     

    Prerequisites

     

     

     

    Watch video

     

    The video below provides a brief overview of what is covered in this tutorial:

     

     

    Download assets

     

    There are two (2) options in getting assets for this tutorial:

    1. Download a ZIP file

    It contains only necessary files used in this tutorial. Remember its location. No need to unzip the file.

    1. Clone our GitHub repository

    It provides assets used in this and other tutorials; organized by tutorial title.

     

     

    Setup operational database

     

    If your environment doesn’t already have a database created, let’s create one.

    Select Operational Database from Cloudera home page:

     

    cdp-homepage-operational-database

     

    Two simple pieces of information are needed to create a database - the Environment name and Database name. For example:

    1. Environment: <your environment name>
    2. Database Name: sample-opdb
    3. Select Create Database

     

    opdb-create-database

     

    Get database connection URL

     

    1. Open your database by selecting its name, sample-opdb.
    2. Select Phoenix Python tab
    3. Copy the Phoenix Python URL
    4. Later in the tutorial, we will use this URL to configure our web application to connect to this database.

     

    opdb-get-connection-url

     

    Set up machine learning

     

    Provision ML workspace

     

    If your environment doesn’t already have a Machine Learning Workspace provisioned, let’s provision it.

    Select Machine Learning from Cloudera home page:

     

    cdp-homepage-machine-learning

     

    In the ML Workspaces section, select Provision Workspace.

    Two simple pieces of information are needed to provision an ML workspace - the Workspace name and the Environment name. For example:

    1. Workspace Name: cml-tutorial
    2. Environment: <your environment name>
    3. Select Provision Workspace

     

    cml-workspace-provision

     

    Create project

     

    Beginning from the ML Workspaces section, open your workspace by selecting its name, cml-tutorial.

    Select New Project

    Complete the New Project form using:

    1. Project Name: opdb-web-application
    2. Project Description:
      Simple inventory management system using Cloudera Operational Database (COD)
    1. Initial Setup: Local Files
      Upload or Drag-Drop tutorial-files.zip you downloaded earlier
    2. Select Create Project

     

    cml-new-project

     

    Application configuration

     

    Beginning from the Projects section, select the project name, opdb-web-application.

    Select New Session and complete the session form:

    1. Session Name: configuration
    2. Editor: Workbench
    3. Kernel: Python 3
    4. Edition: Standard
    5. Resource Profile: 1 vCPU / 2 GiB Memory
    6. Select Start Session

     

    cml-start-new-session

     

    Let’s make a minor configuration change and install the dependencies:

    1. Modify the configuration file, config.ini.template, with the Phoenix Python URL we retrieved earlier and username/password.
      [COD]
      Username=<cdp_workload_username>
      Password=<cdp_workload_password>
      Url=<URL from Phoenix Thin JDBC connection>
      Serialization=PROTOBUF
      Authentication=BASIC
      

      Save the file as config.ini: File > Save As > config.ini

    2. Install the dependencies by issuing the following statement in the command-line:
    3. !pip3 install -r requirements.txt

     

    cml-application-configuration

     

    In the same session (or a new one), let’s create and populate a table that we’ll be using in our application.

    Select file db_setup.py and click on

     

    cml-run-db-setup

     

    Create and run web application

     

    Let’s create our inventory management system web application.

    Beginning from the Applications section, select New Application and fill out the form as follows:

    1. Name: opdb-web-app
    2. Subdomain: opdb-web-app
    3. Description: Simple inventory management system
    4. Script: main.py
    5. Kernel: Python 3
    6. Select Create Application

     

    cml-new-application

     

    After a few moments, the application is up and running. Select the application’s name, opdb-web-app, to open the web application.

     

    cml-run-application

     

    This web application accepts a part number and quantity. It first verifies that the part exists, if it does, it will decrease/increase the quantity on hand. For example:

    A positive quantity value, decreases the quantity on hand.

    A negative quantity value, increases the quantity on hand.

     

    web-application

     

    Summary

     

    Congratulations on completing the tutorial.

    While this was a simple example of a web application, I hope it sparks your imagination and inspires other creative solutions.

     

     

    Further reading

    Other

     

    Ready to Get Started?

    Your form submission has failed.

    This may have been caused by one of the following:

    • Your request timed out
    • A plugin/browser extension blocked the submission. If you have an ad blocking plugin please disable it and close this message to reload the page.