Staging an Application in Oracle Visual Builder Cloud Service

Before You Begin

This tutorial shows you how to stage an application. This tutorial takes approximately 15 minutes to complete.

This is the first tutorial in the Staging and Publishing an Application module. Read the tutorials sequentially.

Background

Oracle Visual Builder Cloud Service is a visual development tool for creating web and mobile applications by simply dragging and dropping user interface (UI) components onto a page. You can create business objects with the click of a button, and you can add data by importing CSV files or XLS spreadsheets to your application. You don't need any programming experience to develop an application.

In this series of tutorials, you will stage and publish the Human Resources (HR) application that you created in the Create your first application module.

The images in this tutorial sequence show the standalone version of Oracle Visual Builder Cloud Service. If you are using the Oracle Integration Cloud version, you will see an additional menu at the top of each page that lets you switch between Visual Builder and Integration Cloud.

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)

Stage the Application

In this section you will learn how to stage the application, so that other users can test its behavior.

1. Log in to Oracle Visual Builder Cloud Service.
2. In the Home page, click the icon for HR Application and select Stage.

   

3. In the Stage HR Application 1.0 dialog box, select Populate Stage with Development data and click Stage.

   

   The application takes a few minutes to stage.

   

4. In the Home page, click the STAGED link. Note the icon of the application has changed.

   

   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.

   

Update the Schema (optional)

You can update your application, and test it by restaging after you make a change. If you don't want to try this right now, skip this and Step 3, and move to Step 4.

Note: 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.

1. In the Home page, click HR Application.

   

2. If you are not there already, click the icon and select Page Designer.

   

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.

   

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

   

   Click the 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.

   

8. Drag the Manager field to the Edit Department page below the Location field.

   

   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.

    

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

    

13. The Manager field is now added to the Departments table.

    

Restage the Application

Note: You only need to do this step if you have made the changes in Step 2.

1. Click the icon and select Stage.

   

2. Select Keep existing data in Stage, then click Stage.

   

3. Click the icon and select Home.
4. On the Home page, click the STAGED link, then click the Departments tab.

   

   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.

Import Data Into Your Application

1. 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.
2. In the Home page, click HR Application.

   

3. Click the icon and select Data Designer.

   

4. Click the Data Manager tile.

   

5. Click the Database menu and select Staging.

   

6. Click Import from File.

   

7. 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.

   

8. In the Import from File dialog box, click OK. If you skipped Steps 2 and 3, you'll see warnings, but you can ignore them.
   

   

View the Staged Application

1. Click the in the top-left corner and select Home.

   

2. Click the STAGED link.

   

3. The staged application now shows the data from the imported files. When you are done, you can close this tab or window.