With the 2204 release of Oracle Visual Builder, we are adding a major new feature – Bring Your Own Schema. With this feature developers can point Visual Builder to an existing database schema, and use the declarative business objects functionality to expose the tables and views as REST endpoints, add business logic, and create user interfaces with ease. In this blog we’ll show how this works.
To leverage this functionality your Visual Builder instance will need to leverage an external Oracle database instead of the built-in database. It’s quite easy to switch your instance setting to a separate DB. With the new functionality, in addition to managing its own set of schemas for BOs that you create, VB can access the tables that are already defined in the DB in other schemas.
To enable you to leverage another schema’s table in your app, your instance administration needs to add that schema to the list of “Available Schemas” in the tenant settings.
Once this is done, you’ll be able to choose the schema in your application settings->business objects to replace the default schema. Note that an application can either use an external schema or use the default one – so you either use existing DB objects or use the ability of VB to create and manage DB objects. A key difference here is who is responsible for the life cycle of the tables – with existing tables/views you manage the lifecycle outside of VB.
Mapping tables and views
Once your app is set to map to an external schema, when you click to create a new business object, you’ll be prompted to choose which DB table or view you want to base your BO on. When you pick the DB object you can modify the names and titles of fields in the BO. When you click create, VB creates all the REST APIs needed to preform CRUD operations against the table/view. When two objects have a relationship defined in the database (foreign keys), the relationship will also be created between the business objects that represents those DB objects. Read the complete article here.
For regular information become a member in the Developer Partner Community please register here.