1. Administering Oracle Visual Builder in Oracle Integration Generation 2
  2. Configure Tenant Settings
  3. Switch to Your Own Oracle DB Instance
  4. Make Schemas in an Oracle DB Instance Available to Applications

Make Schemas in an Oracle DB Instance Available to Applications

When you connect an Oracle database instance with your Visual Builder instance, application developers can use schemas predefined in the tenant database to create business objects based on existing tables and views for an application. But for developers to access these schemas, you'll first need to make them available to applications.

To make a tenant database's existing schema available to applications:

  1. In the upper-left corner of the Visual Builder title bar, click Navigation Menu Navigation menu icon.
  2. Click Settings in the navigation menu to open Tenant Settings.
  3. Click + New Schema in the Available Schemas panel.
  4. Enter a name for the schema and click the check mark icon.

    Description of available-schemas-add.png follows
    Description of the illustration available-schemas-add.png

    After the schema is added, you can edit its name or delete it entirely, but remember any changes you make might break applications that use the schema.

    Schema that exists in the tenant database and has been added to the list of available schemas will become available for selection in an application's Settings editor (under Schema Selection in the Business Objects tab).