Securing Subject Areas in Oracle Analytics Cloud

Introduction This post documents how to secure Oracle Business Intelligence Repository Metadata (RPD) subject areas in Oracle Analytics Cloud (OAC). It uses an example of two subject areas; Financials and Projects. The Projects subject area is secured via application roles and presentation services privileges. Only users with the correct role(s) can view the subject area […]

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 […]

Using the Virtual Image Service Level of Oracle Database Cloud Service

Introduction This post details the procedures needed to create a database using the Virtual Image Service Level of Oracle Database Cloud Service. Also, it provides verification steps for each procedure. It draws extensively from both the A-team post Getting Started with Oracle Database Cloud Service – Virtual Image – Creating a database and Oracle’s documentation […]

Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part III

Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field Service Cloud […]

Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part II

  Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field Service […]

Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part I

Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including support for RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field […]

Loading Data from Oracle Field Service Cloud into Oracle BI Cloud Service using REST

Introduction This post details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into the Oracle Business Intelligence Cloud Service (BICS) using RESTful services. It is a companion to the A-Team post Loading Data from Oracle Field Service Cloud into Oracle BI Cloud Service using SOAP . Both this post and […]

Loading Data from Oracle Identity Cloud Service into Oracle BI Cloud Service using REST

Introduction This post details a method of extracting and loading data from Oracle Identity Cloud Service (IDCS) into the Oracle Business Intelligence Cloud Service (BICS). It builds upon the A-team post IDCS Audit Event REST API which details the REST API calls used. One use case for this method is for analyzing trends regarding audit events. […]

Loading Data from Oracle Field Service Cloud into Oracle BI Cloud Service using SOAP

Introduction This post details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into the Oracle Business Intelligence Cloud Service (BICS). A compelling reason to use such a method is when data is required that is not in the standard daily extract. Such data might be planning (future) data or data […]

Loading Data into Oracle BI Cloud Service using OTBI Analyses and SOAP

Introduction This post details a method of loading data that has been extracted from Oracle Transactional Business Intelligence (OTBI) using SOAP into the Oracle Business Intelligence Cloud Service (BICS). The OTBI instance may either be Cloud-Based or On-Premise. This method may also be used to load data from Oracle Business Intelligence Enterprise Edition (OBIEE). It […]

Loading Data into Oracle BI Cloud Service using BI Publisher Reports and REST Web Services

Introduction This post details a method of loading data that has been extracted from Oracle Business Intelligence Publisher (BIP) into the Oracle Business Intelligence Cloud Service (BICS). The BIP instance may either be Cloud-Based or On-Premise. It builds upon the A-Team post Extracting Data from Oracle Business Intelligence 12c Using the BI Publisher REST API. […]

Loading Data into Oracle BI Cloud Service using BI Publisher Reports and SOAP Web Services

Introduction This post details a method of loading data that has been extracted from Oracle Business Intelligence Publisher (BIP) into the Oracle Business Intelligence Cloud Service (BICS). The BIP instance may either be Cloud-Based or On-Premise. It builds upon the A-Team post Using Oracle BI Publisher to Extract Data from Oracle Sales and ERP Clouds. […]

Extracting Data from Oracle Business Intelligence 12c Using the BI Publisher REST API

Introduction This post details a method of extracting data from an Oracle Business Intelligence Enterprise Edition (OBIEE) environment that is integrated with Oracle Business Intelligence Publisher (BIP) 12c. The environment may either be Cloud-Based or On-Premise. The method utilizes the BI Publisher REST API to extract data from a BIP report. It also uses BIP […]

Recreating an Oracle Middleware Central Inventory in the Oracle Public Cloud

Introduction This post provides a simple solution for recreating an Oracle Middleware software central inventory. One rare use case is when a server is lost and a new server is provisioned. The Middleware home may be on a storage device that can be reattached e.g. /u01. However, the central inventory may have been on a […]

Uploading CSV files to BICS Visual Analyzer and Data Visualization Cloud Service

Introduction This post details a new feature introduced in Version 2.1 of the Oracle BICS Data Sync tool. Currently BICS Visual Analyzer (VA) and Data Visualization Cloud Service (DVCS) users may upload Microsoft Excel Workbooks (.XLSX) but not Comma Separated Values (CSV) files. This is an issue for use cases that use a CSV file […]