Introduction to Oracle Visual Builder for Developers: Gen 3

Learn how to create an Oracle Cloud free trial individual account, verify email and payment, set your Mumbai region, and enable two-factor authentication for quick access.

Provision an Oracle Integration 3 instance in Oracle Cloud, select an edition, and enable features like process automation, B2B, ERP, and Visual Builder; then access design time and runtime URLs.

Enable visual builder in an Oracle Integration 3 instance from the OCI console, then ensure an administrator policy lets the admin group manage it in the compartment.

Provision a standalone Oracle Visual Builder Studio instance on Oracle Cloud, then create a Visual Builder project with a git repository and workspace. Configure the deployment pipeline.

Create your first Oracle Visual Builder application by clicking plus new application, naming it, choosing an empty template, and exploring the designer and artifact editors.

Learn to create your first Visual Builder application with Visual Builder Studio, and follow a walkthrough to set up an environment, a visual application, and scratch or git repository options.

Create a web application in Oracle Visual Builder by organizing pages into flows, reuse header and footer via fragments, and preview the built app.

Explore the visual builder designer to configure web apps, service connections, and backends, manage layouts, components, and the marketplace, and understand action chains, event listeners, and data types.

Learn how the shell page and single-page index.html architecture, powered by the Oracle Jet runtime engine, drive Visual Builder apps with a constant header and footer and dynamic content.

Explore Oracle Visual Builder resources, from official docs and workshops to the Visual Builder cookbook, YouTube, and community forums, to accelerate web and mobile app development.

Learn to build a web app in Oracle Visual Builder Gen 3 by dragging and dropping a bind text component onto a page, exploring structure, slots, and live preview.

Create and assign a string variable in Oracle Visual Builder Gen 3, bind it to a text component, and display hello world.

Explore creating variables and constants in Oracle Visual Builder for Developers Gen 3, using primitive and structured types, any type, and custom types with ADP SDP BDP data providers.

Capture user input with the input text component in Oracle Visual Builder, map it to the hello message variable, and display the updated greeting via bind text.

Learn how curly brace bindings update user input in Oracle Visual Builder and how square bracket bindings create read-only variables.

Explore constants and variables in Oracle Visual Builder Gen 3 by creating constants, binding text to them, and note that constants cannot be overwritten while variables can, with JavaScript concepts.

Discover how to decouple input text from the bind text, using a hello message input variable, update on button click, and define an action chain with an event listener.

Explore lifecycle, variable, component, and custom events in Oracle Visual Builder Gen 3, with application, page, and flow scope, plus action chains that fire events.

Learn to use JavaScript within Oracle Visual Builder for developers to capture user input, call a JavaScript function in an action chain, and display a personalized greeting.

Learn how to create a JavaScript function at the application scope in Oracle Visual Builder, call it from action chains, and reuse across pages with design view and live testing.

Navigate between pages in Oracle Visual Builder by clicking a button or hyperlink, using onClick and an action chain to open a newly created page with a heading.

Explore how to stage an Oracle Visual Builder application to generate a shareable stage URL, preview in live mode, and publish to protect production code from edits.

Publish your application and manage versions with staging and production workflows. Keep a fixed live URL and freeze code after publication.

Develop a calculator web app in Oracle Visual Builder Gen 3 by adding two number inputs and a result output, then stage, publish, and share the live app.

Learn how business objects in Oracle Visual Builder map to database tables, then create a business object, add fields, and explore default columns like id, created by, and last updated.

Add records to a business object in Oracle Visual Builder, validating fields like email. Use the data and code views, and later leverage Rest API endpoints to populate a table.

Export data from a Visual Builder business object to a CSV file, edit or add records, and import the updated file back using replace (or append) options.

Learn how to import a business object from a csv file using the data manager in Oracle Visual Builder, including encoding handling, field recognition, and object creation.

Learn how to create a relationship between business objects, using department and employee objects to illustrate a many-to-one foreign key, and how to update, edit, delete, and duplicate records.

Import a Visual Builder app from a .zip file, preserving business objects and their data by exporting with data, and review relationships among employees, departments, and locations.

Master manual data entry in the employee business object by adding a row, selecting the department, and entering name, email, phone number, and salary using the plus row option.

Create a formula field in the employee business object to calculate monthly salary from annual salary using the Groovy expression builder, and round to two decimal places.

Create an aggregation field in a department business object by counting related employees in a one-to-many relationship, then apply total, average, max, and min calculations to derive department insights.

Create an aggregation field using a go script formula, leveraging groovy functions and an iterator to count employees per department, returning total employee count as an aggregation from related data.

Learn to create a field using a formula with a conditional iterator to count employees meeting salary conditions, using hardcoded values or bind variables, and verify aggregation results by department.

Explore object triggers in Oracle Visual Builder to run actions on events, such as before insert, and apply conditional criteria like salary above 5000 to send emails.

Learn to create and manage field triggers in Oracle Visual Builder for Developers Gen 3. Define salary-based conditions and execute actions, including log messages and groovy scripts.

Create an object validator to enforce object level rules on salary and reject changes when salary exceeds 5000, with the error 'salary is too high'.

Explore field-level validation rules for the salary field, using new and old value, and display an error like salary is too high when salary exceeds 5000.

Discover how the object function encapsulates business logic for a specific object and can be invoked by name from scripts or via REST API once external systems can call it.

Access business objects with rest APIs using endpoints to retrieve metadata for development and fetch employee data. Create records via post and basic authentication, test via postman and visual builder.

Discover Redwood design by creating your first Visual Builder app with the Redwood Starter template, using drag-and-drop components, the Redwood pattern book, and responsive, pre-built pages.

Construct and relate business objects in Redwood Visual Builder: define employee with name, age, and a department relationship. Define department with a name; import the provided resources zip.

Drag and drop a table in Oracle Visual Builder to display employee data via get many endpoints and REST APIs, with columns id, name, age, and department.

Add an input text to the welcome page search slot, bind it to v_search_parameter, and filter the service data provider to fetch a specific employee by id via REST API.

Create, update, delete, and view details for records in a table component using a business object, with quickstart data and filter criteria guiding data display.

Learn to build a master-detail page in Oracle Visual Builder using the item overview template to display a department header and its employees, with item id routing and mapping.

Learn to navigate from a table to an item overview page in Oracle Visual Builder Gen 3 by passing the department ID as a parameter on row selection.

Use the list view in Oracle Visual Builder to display data, populate it via quick start method, and leverage array or service data providers with endpoints like get all employees.

Create an array data provider, define the employee type, call the REST endpoint, and map results to the ADP data to populate a list or table in Visual Builder.

Drop the form layout component to create a flexible form with text, number, date, and time inputs that maps to a search parameter and filters the table.

Explore using the toolbar component in Oracle Visual Builder to organize buttons within a form layout, with icon options, alignment control, and separators, guided by the Oracle Git cookbook.

Center align the toolbar buttons using flex layout and justification from the cookbook. Apply justify content center and treat the toolbar as a flex box with buttons as items.

Explore adding input parameters and configuring primary and secondary buttons on a Redwood page using the welcome page template. Learn about live mode, disabling, icons, and SP primary/secondary action events.

Learn to implement and customize a dialog component in Oracle Visual Builder Gen 3, including drag-and-drop setup, open and close actions, input labels, and prompts during form submission.

Demonstrates the drawer component in Oracle Visual Builder Gen 3, opening from bottom or end and toggling with a boolean draw flag, including internal components and close behavior.

Learn to centralize styling in Oracle Visual Builder Gen 3 by creating and linking an app.css under resources to apply CSS across components, including a 50vh max height.

Create a service connection to call a rest api, define endpoints, test and save response examples, then consume the data in a page table with a scrollable view.

Create a backend and a service connection to manage static endpoint information for a rest countries API, enabling multiple endpoints under one host and dynamic updates across environments.

Learn to call an Oracle integration from Visual Builder using a service connection, map input to the endpoint, and display the returned greeting on a page with basic error handling.

Learn to call Fusion REST APIs from Visual Builder by creating a Fusion backend, selecting the ERP catalog, and consuming APIs with a single Fusion REST service connection.

Learn to build responsive designs in Oracle Visual Builder using a 12-column grid and flex layout with og-flex and og-flex-item to adapt across devices.

Learn to build responsive layouts with flex in Visual Builder using flex container and flex item classes. Use the flex initial class to control growth and shrinking.

Learn to override auto flex in Oracle Visual Builder Gen 3 with oj-size-flex-items, applying flex one for equal-width segments across screen sizes, including pane-specific usage.

Learn to override default flex properties in Oracle Visual Builder by using flex item 1 and 0, applying minimum width, and customizing CSS to control stretching.

Learn to justify content in a flex container using ogsm justify content classes to align items at the start, end, center, or with space around or between.

Learn to align text in flex items using start, end, and center in a flex container with Oracle Visual Builder Gen 3, managing spacing in a flex row.