In this blog, we are going to show you what is Business Object and how to export data from Business Object and how to export complete Visual Builder Cloud Service (VBCS).
If you want to learn about importing Business Objects check our blog How Import Business Data in Visual Builder Cloud Service (VBCS).
What Is Business Object
A business object represents a data client and can be implemented as an entity. A business object is not a database but is defined in the database schema. It is usually used to represents business entities such as an invoice, transaction, or some details.
You can create custom business objects to store data that is not provided by an external service. You need to specify each of the fields that your application needs. To create and modify business objects you can use the Data Designer to modify the schema of your development DB.
Creating An Export Component In VBCS
In OIC there is no default option for exporting business data so we need to add the export component in our app so that we can export business data in CSV format.
On the main-start page, make sure you have one table already created with data from BO’s so we will be using the export process from this page as it displays all the data and it will be easily comparable in last.
Check Out: Our blog post on Oracle Integration Cloud.
Steps For How To Add An Export Data Component In VBCS
- Go to Components. Click on components, and search for the Export Option and Click on it to Download. And click on Install Component. You Can Export Data in Chrome version.
- Select and add Export Data component and then click on Install Component. Accept the agreement and click on install.
- When the component is successfully installed the button changes to Uninstall Component
- Now back to the main-start page, Scroll down to the bottom in the Components pallet to section Extended Components. Now drag and drop Export data component on the page.
- Click on the export button it will open a set of settings in the property inspector. In the general tab you have many settings that depending upon our requirement we can choose.
- Now switch to data tab and add data source.
- Now we need to add Export Attributes, go to All and go to column attributes.
- Add Attributes. Note: Field name should be the same as it is in the BO or that particular field will not be exported.
- Provide attributes that you want to export,header and the data type. (You can have multiple attributes), After adding the attributes process has been successfully completed click on play button for preview(To test).
- Click on Export.
- Data will be exported into local system and will be exported as csv file
- We can see the data we provided in the application.
Export A Visual Application
You can use the Export action to download the visual application and its resources to your local system. After exporting the archive, you can import it in another VBCS. this archive can also be shared with team members to work on.
When you export the application you have an option to choose if you want the archive to include business data with the application. Although some data like credentials for external REST endpoints are not exported with an application so you need to provide the information after you have successfully exported the application.
To Export A Visual Application:
- On the Visual Applications home page, open the Application Options menu for the application version you want to export and select Export.
If there are multiple versions of an application you must use the Options menu of the version that you want to export.
Alternatively, when a visual application is open, you can choose Export in the application’s options menu in the toolbar. - Select the export option for the application.
You can choose to include the data stored in the application’s custom business objects when exporting the application.
When you choose to export the application with data, the archive file will include a JSON file and a spreadsheet for every custom BO.
The JSON file is used to describe the business object and the spreadsheet contains the business object data. If you choose to export the application without data then the archive file will only contain the JSON file describing the business objects.
Summary
Exporting business objects and VBCS applications is very advantageous when moving an application, business data, or both to some other instance or archive the application.
Frequently Asked Questions
What is Oracle Visual Builder Cloud Service (VBCS)?
Oracle Visual Builder Cloud Service (VBCS) is a visual and declarative cloud-based development environment used to create and host web and mobile applications. It allows users to quickly build, integrate, and deploy applications with minimal coding, utilizing a drag-and-drop interface.
What formats are supported for exporting data in VBCS?
Currently, VBCS supports exporting data in CSV (Comma-Separated Values) format.
Are there any limitations on the amount of data that can be exported in VBCS?
The export feature in VBCS may have limitations based on the size of the data and the performance constraints of the platform. For very large datasets, consider breaking the data into smaller chunks or exporting data in stages to avoid timeouts and ensure successful exports.
Can I automate the export process using REST APIs in VBCS?
Yes, VBCS provides REST APIs that can be used to automate various operations, including exporting data. You can write custom scripts or use Oracle Integration Cloud to automate the export process through these APIs.
How secure is the exported data from VBCS?
The security of exported data largely depends on how it is handled after the export. Ensure that you follow best practices for data security, such as encrypting sensitive data and securely storing exported files.
Related Links:
- To apply for 1z0-1042-23 Oracle cloud platform integration 2023 certified professional
- Step by Step guide to get a FREE Oracle Cloud account.
- Oracle Integration Cloud (OIC) For Beginners Overview
- Create Oracle Integration Cloud Instance: Step by Step
Next Task For You
Do you want to learn more about Oracle and confuse where to start or which certification is right for you? Then, click on the register now button below to register for a Free Masterclass on Oracle Integration Job Oriented Program which will help you better understand and choose the right path and clear the certification exam.
![Microsoft Agentic AI Business Solutions Architect [AB-100] | K21 Academy](https://test.k21academy.com/wp-content/uploads/2025/11/Microsoft-Agentic-AI-Business-Solutions-Architect-AB-100-Exam-Overview1.png)
