Adding Web Service Trusted Certificates to a Wallet in Oracle Database Cloud Service

Introduction This post documents how to add trusted TLS/SSL certificates to an Oracle Database as a Service (DBaaS) wallet. It uses an example of an Oracle Business Intelligence Cloud Service (BICS) REST API call to Delete Cached Data as documented in REST APIs for Oracle BI Cloud Service. This call is issued from PL/SQL and […]

Remounting DBFS Shared Storage in SOACS and MFTCS Clusters

Executive Overview Oracle Database File System (DBFS) is used in providing shared storage mount points within SOACS and MFTCS clusters. DBFS provides a standard file system interface for directories and files on top of database tables[1] . So, by using the database running in the DBCS instance associated with any SOACS or MFTCS instance, DBFS […]

Using SSH for Data Sync Loads to BI Cloud Service (BICS)

For other A-Team articles about BICS and Data Sync, click here Introduction Since this article was written, the ability to create an SSH tunnel has been added as inbuilt functionality to the Data Sync tool.  For more details of how to use that, please see this article.  The method detailed in this article can be […]

Connect ODI to Oracle Database Cloud Service (DBCS)

As describe in the article Integrating Oracle Data Integrator (ODI) On-Premise with Cloud Services, if you are considering connecting to the Cloud and using Oracle DBCS – Oracle Database Cloud Service – one of the good news is that you can use ODI on-premise to do the work. There are 2 ways to connect: either […]

Getting Started with Oracle Database Cloud Service – Virtual Image – Creating a database

Introduction The Oracle Database Cloud Service – Virtual Image option gives great flexibility on how to deploy databases in the Oracle Cloud. It allows customization options in almost all aspects of the database (e.g. file system layout, memory management, etc.). This makes this option very beneficial – for example – in highly customized database deployments […]

Loading Data in Oracle Database Cloud Service

Oracle Database Cloud Service – Schema (a.k.a Database Schema Service) is an Oracle Platform Cloud Service offering that provides a single Oracle Database schema which is fully managed by Oracle. It also includes Oracle Application Express (APEX), which is a rapid browser-based database application development system. In addition to allowing you to rapidly build database-based […]

Extending Oracle Sales Cloud using Oracle Java Cloud Service

Oracle Sales Cloud comes with tools such as Application Composer and Page Composer that allow you to customize and extend the application to suit your business needs. These tools can be used to add new UI elements, add validations, enrich the Sales Cloud data model, and to create interfaces with external applications. Additionally, Application composer […]