Architectural Guidance: Integrating VBCS with DBCS for Spreadsheet-Based Data Ingestion
Summary:
I am designing a solution in Oracle Visual Builder (VBCS) that requires users to upload a spreadsheet to insert or update records directly into an Oracle Database Cloud Service (DBCS) instance. I am seeking best practices on the following:
- Service Connectivity: What is the recommended approach for establishing a secure and performant connection between VBCS and a DBCS instance? Should this be architecturalized via Oracle Integration Cloud (OIC) or a direct REST encapsulation using Oracle REST Data Services (ORDS)?
- UI Implementation: Which VBCS component is best suited for handling the file selection and binary/multipart upload of spreadsheet files (Excel/CSV)?
Tagged:
1