In this article, We’ll demonstrate the process of replacing an embedded database with an external database of your choice in Oracle Visual Builder.

Transitioning from an embedded database to an external database in Oracle Visual Builder is essential for leveraging advanced capabilities that enhance application performance and scalability. ATP provides automated management, including scaling, patching, and backup, allowing developers to focus on building applications rather than database maintenance.

Additionally, it supports high concurrency and complex queries, ensuring optimal performance under varying workloads. This shift not only improves reliability and security but also enables organizations to harness machine learning features for real-time insights, ultimately driving better decision-making and operational efficiency.

Prerequisites:

Oracle Visual Builder Instance with valid credentials
Cloud Wallet and wallet password
Database
Database Admin credentials

Following are the steps to complete this use case:

Access the VBCS Instance: Open your Oracle Visual Builder Cloud Service (VBCS) instance and click on the menu icon in the top left corner.
Navigate to Settings: From the menu drawer, select “Settings.”
Select Tenant Database: In the Settings screen, switch to Tenant Database.
Using Different Database : When we switch to Tenant Database we will be navigated to a new page. In the new screen we need to click on Use Different Database button as shown in the following screenshot:
Change Tenancy Database: When we click the Use Different Database button, a dialog box will appear, allowing you to enter the details needed to switch the tenant database, as shown in the following:
We have two ways to change the tenant database. They are :1. By using Oracle Database Connection with JDBC
2. With the help of Oracle Autonomous Transaction Processing Cloud WalletIn this article, We will be using Oracle Autonomous Transaction Processing Cloud Wallet to implement the use case
Select Oracle Autonomous Transaction Processing Cloud Wallet in the connection type as shown in the following screenshot:
When we choose a cloud wallet, a file picker will appear, allowing us to drag and drop our wallet for that instance. The TNS name will be automatically extracted from the uploaded wallet, as shown in the following screenshot:
Provide the wallet password and admin credentials for your Database in the DBA User Name and Password fields and click on the Next button as shown in the following screenshot:
The Credentials which we provide to change the tenancy will be verified and the Confirmation message will be shown if the details provided are valid. Click on the Finish button as shown in the following screenshot:
If you have any application developed before switching the database, then you will be allowed to export all the applications. Export all the applications as required otherwise you will lose all the applications after the embedded database is switched.
Now, return to the General tab, where you’ll find the + New Schema button in the top right corner. Click on it, enter your schema name, and then click the checkmark icon, as shown in the screenshot below:
The layout of creating BO with switched database is only visible when you go to the setting and select which schema you want to use for all BOs. Schema selection would be enabled only when the application is configured with some external Database as shown in the following screenshot: Embedded BOs:
External DB based BOs:
To confirm the transition, you can compare the layouts for both Embedded and Non-Embedded Business Objects. Here are the layouts for both the Embedded and Non-Embedded Business Objects (BOs).External DB based BO Layout:
Embedded BO Layout:

By examining the layout, you can verify that the external database has successfully replaced the embedded one.This is how we can replace Embedded Database with Different Database in Oracle Visual Builder.

If you liked the article, please like, comment, and share.

Please look at our YouTube channel for Oracle Integration-related videos and don’t forget to subscribe to our channel to get regular updates.

Further Readings

Creating a search page using Oracle Visual Builder Redwood

Using Redwood General Overview Page Template in Oracle VBCS

Configuring Simple Create and Edit Page Template | Oracle Redwood

Configure General Drawer Template in Oracle Redwood

How to Customize the Lock Screen in Oracle Visual Builder

Merging two CSV files into a single file in Oracle Integration