Staging and Publishing an Application in Oracle Visual Builder Cloud Service


Options



Before You Begin

In this tutorial, you will learn how to stage and publish an application.

Time to Complete

Approximately 30 minutes.

Background

Oracle Visual Builder Cloud Service is a visual development tool for creating web and mobile applications by simply dragging and dropping UI components onto a page. You can create business objects at the click of a button and add data by importing CSV files to your application. You do not need any programming experience to develop an application.

Scenario

You will stage and publish the Human Resources (HR) application that you created in the Getting Started with Oracle Visual Builder Cloud Service tutorial and updated in the Editing an Application in Oracle Visual Builder Cloud Service tutorial.

In this tutorial, you will learn how to do the following:

  • Stage the HR Application application with development data

  • Edit the HR Application schema to add a new field

  • Import live data to the Staging database

  • Stage the application again

  • Publish the application

You will edit the HR Application schema to include a Manager field in the Department business object as per the following diagram.

HR Schema Diagram
Description of this image

Context

Before you begin this tutorial, make sure that you have created the HR Application application as described in the Getting Started with Oracle Visual Builder Cloud Service tutorial and updated it as described in the Editing an Application in Oracle Visual Builder Cloud Service and Editing Business Objects in Oracle Visual Builder Cloud Service tutorials.

What Do You Need?

  • Access to Oracle Visual Builder Cloud Service

  • A supported browser (see Known Issues for Oracle Application Builder Cloud Service for more information)

Staging the Application

You can use the staged application to have other users test the behavior of the application.

In this section you will learn how to stage the HR Application application.

  1. Log in to Oracle Visual Builder Cloud Service.

  2. In the Home page, click the Action menu icon for HR Application and select Stage.

    Home page action menu
    Description of this image
  3. In the Stage HR Application 1.0 dialog box, select Populate Stage with Development data and click Stage.

    Stage Application dialog
    Description of this image

    The application takes a few minutes to stage.

    Stage Application dialog progress bar
    Description of this image
  4. In the Home page, click the STAGED link. Note the icon of the application has changed.

    Staged application on Home page
    Description of this image

    The staged application opens in a new browser tab or window. The tables are populated with the data from Development. When you are done, you can close this tab or window and return to the Home page.

    Staged application
    Description of this image

Restaging the Application

After you stage or publish the application, if you make any updates to business objects or the schema of the Development or the Staging database, you will need to stage the application again before you publish it.

Updating the Schema

Let's make some changes to the HR Application schema of the Development database and add a Manager field to the Department business object.

  1. In the Home page, click HR Application.

    Staged application on Home page
    Description of this image
  2. If you are not there already, click the Main menu icon and select Page Designer.

    Main menu
    Description of this image
  3. Click the page menu and select Create Department.

  4. Drag and drop a Combo Box component to the Create Department page below the Location field.

    Dragging combo box to page
    Description of this image
  5. Enter the following values in the pop-up box:

    • Label: Manager

    • Business Object: Department (automatically selected)

    • Business Object Field: New (automatically selected)

    • Field Name: ref2Manager (automatically populated)

    • Field Data Type: Reference (automatically selected)

    • Reference Business Object: Employee (automatically selected)

    • Default Displayed Field: Name

    Combo box pop-up dialog
    Description of this image

    Click the OK icon to save the field. The Manager field is also added to the Department business object.

  6. Click the page menu and select Edit Department.

  7. Open the Data palette.

    Data palette
    Description of this image
  8. Drag the Manager field to the Edit Department page below the Location field.

    Dragging field to page
    Description of this image

    The field is automatically added as a drop-down list.

  9. Click the page menu and select Departments.

  10. Select the Departments table and open the Data tab in Table Properties Inspector.

    Departments table Data tab
    Description of this image
  11. Click the Table Columns edit Add Field icon.

  12. In the Select Table Columns dialog box, drag the Manager field to Table Columns and click Done.

    Select Table Columns dialog
    Description of this image
  13. The Manager field is now added to the Departments table.

    Departments table
    Description of this image

Staging the Application Again

After updating the schema, you must stage the application again before you publish the application.

Note: It is not necessary to import data to the Staging database. You may want to import the data if you want to test and view it in the staged application before you publish the application.

  1. Click the Main menu icon and select Stage.

    Main menu
    Description of this image
  2. Select Keep existing data in Stage, then click Stage.

    Stage Application dialog
    Description of this image
  3. Click the Main menu icon and select Home.

  4. On the Home page, click the STAGED link, then click the Departments tab.

    Staged application on Home page
    Description of this image

    The staged application opens with the existing data. The new Manager field has been added.  Close the staged application and return to the Home page.

  5. Because you made a change to the application schema, the new Manager field is empty. Right-click this link and download the HR Application-Stage 2.zip file. The zip file contains CSV files of all business objects of the updated HR Application schema.

  6. In the Home page, click HR Application.

    Staged application on Home page
    Description of this image
  7. Click the Main menu icon and select Data Designer.

    Main menu
    Description of this image
  8. Click the Data Manager tile.

    Data Manager tile
    Description of this image
  9. Click the Database menu and select Staging.

    Database menu
    Description of this image
  10. Click Import from File.

    Import from File tile
    Description of this image
  11. In the Confirm Import Data dialog box, click Upload a File. Select the HR Application-Stage 2.zip file, click Open, and then click Import.

    Confirm Import Data dialog
    Description of this image
  12. In the Import from File dialog box, click OK.

    Import from File dialog
    Description of this image
  13. Click the Main menu in the top-left corner and select Home.

    Main menu
    Description of this image
  14. Click the STAGED link.

    Staged application on Home page
    Description of this image
  15. The staged application now shows the data from the imported files. When you are done, you can close this tab or window.

    Staged application
    Description of this image

Publishing the Application

After you have successfully tested the staged application, you can publish it and make the application live. The live application is visible to users with proper credentials.

  1. Return to the Home page.

  2. Click the Action menu icon of HR Application 1.0 and select Publish.

    Home page action menu
    Description of this image
  3. In the Publish HR Application 1.0 dialog box, select Include data from Stage, then click Publish.

    Publish Application dialog
    Description of this image

    The application takes a short time to publish. After the application is published, notice that the application icon has changed in the Home page.

  4. Click the Live link to open the published application.

    Live application link
    Description of this image

    The schema and the data from the staging database are copied to the live database. You can now share the application's URL with public users.

    Live application on Home page
    Description of this image
  5. If you want to, click the user menu in the top-right corner and select Sign Out from the menu. After you've published an application, you will no longer be able to make changes to it. Instead, you can create a new version of it, and edit that.

Want to Learn More?