Deploying Oracle Remote Data Connector in Tomcat for Oracle Analytics Cloud

Introduction This post describes deploying Oracle Remote Data Connector (RDC) for Tomcat in a Compute instance running on Oracle Cloud Infrastructure (OCI) for use by Oracle Analytics Cloud (OAC). RDC is used primarily in cases where data sources are not accessible using a public IP address. It supplements the official RDC documentation found here and here with […]

Integrating Okta as Identity Provider to IDCS

IDCS (IDentity Cloud Service) is Oracle’s next-gen Identity solution built in the cloud for the cloud. It is fully standards compliant and implements various standards like SAML (Security Assertion Markup Language), OAuth, OIDC (OpenID Connect), etc. Those standards help customers integrate with other products implementing those same standard. One use case that I came across, […]

OAC Remote Data Connector with Jetty

For other A-Team articles by Richard, click here Introduction The Remote Data Connector (RDC) allows the Oracle Analytics Cloud service to connect to on-premise data sources. There are now 2 versions. The initial version required that a web-sever, either weblogic or tomcat, be used on premise for the tool to work.  That version is still available, […]

Direct On-Premise Database Connections for OAC DV via RDC

For other A-Team articles by Richard, click here Introduction The Remote Data Connector (RDC) allows the Oracle Analytics Cloud service to connect to on-premise data sources. In the 5.2 release of Oracle Analytics Cloud, new functionality was added that allowed Data Visualization (DV) to connect directly to on-premise databases, via the Remote Data Connector (RDC) tool, […]

DBFS vs OCI Storage Services for PaaS DR

Introduction Oracle Cloud Infrastructure (OCI) provides highly available and scalable cloud infrastructure and services to enable the Disaster Recovery for the applications to be reliable, secure, and fast. Oracle Cloud Infrastructure is hosted in regions and availability domains. A region is a localized geographic area, and an availability domain is one or more data centers […]

3 Steps to kick-start OCI monitoring in CASB

Introduction Oracle CASB Cloud Service is used for security monitoring the cloud footprint of SaaS, PaaS and IaaS components. CASB, when configured to monitor Oracle Cloud Infrastructure (OCI), can detect risk, anomalies and potential security violations. In OCI, the target of CASB monitoring is a compartment. Once an OCI compartment is configured in CASB, out-of-box […]

IP Address Whitelisting in Oracle Identity Cloud Service

Introduction Oracle IDCS (Identity Cloud Service) supports restricting access to applications based on the user IP address. Such applications can be the IDCS Console or any application registered by customers in IDCS. At first sight, restricting access based on the user IP address may lead to the belief that IDCS can only blacklist a set […]

Integrating Oracle Integration Cloud Integration with UIPath

Introduction Oracle Integration Cloud Integration provides, out of the box, a UIPath adapter for integrating with UIPath Orchestrator via UIPath Queues. Through a recent POC for a customer, we realized that existing documentation was lacking some detailed information on how to achieve data passing between OIC and UIPath using queues. This post aims to fill […]

OIC Integration with Logistics Cloud – Things to Know and Best Practices

Introduction In this blog we will see some common issues that could be faced, the recommended fixes and best practices when integrating with Oracle Logistics Cloud using Oracle Integration Cloud (OIC). Oracle Logistics Cloud comprises of these below components Oracle Transportation Management Cloud(OTM) Oracle Warehouse Management Cloud (WMS) This blog discusses issues encountered during a […]

OAC Connection to On-Premise Essbase via Remote Data Connector

For other A-Team articles by Richard, click here Introduction This article walks through the steps to set up the Remote Data Connector (RDC), for Oracle Analytics Cloud, to connect to an On-Premise Essbase source.   Two methods will be described: A direct connection from the Data Visualization tool without the need to use a repository (RPD) […]

Engagement Cloud – outbound REST using IDCS OAUTH

Introduction   Engagement Cloud 19A introduces the ability to call IDCS oauth protected REST services. This article explains the setup required in IDCS and Engagement Cloud, using Oracle Blockchain as the service provider. Note – details on how to call and parse REST services from Engagement Cloud groovy are covered here: Calling REST services from Oracle […]

Implementing Data Level Security in Oracle Analytics Cloud using Identity Cloud Service

Introduction This post describes implementing Data Level Security in Oracle Analytics Cloud (OAC) using Identity Cloud (IDCS) groups. It focuses on what steps are needed. Links to relevant documentation are provided for details on how to perform the steps. One case for using IDCS satisfies a corporate requirement specifying that the assigning of users to […]

Restricting Access to Oracle Analytics Cloud by IP Range

For other A-Team articles by Richard, click here Introduction Customers may want to restrict access to their Oracle Cloud Services to a set of IP ranges, for instance to only allow connections coming from their corporate office.  That type of restriction is not possible within Oracle Analytics Cloud itself, but it possible to set up using […]

Connecting Oracle Analytics Cloud Essbase to the Autonomous Data Warehouse

Introduction The latest releases of Oracle Analytics Cloud (OAC)-Essbase now support connections to the Autonomous Data Warehouse (ADW). This post is a step-by-step guide to creating the connections. Links to documentation are provided for all steps where possible. Screen shots are provided for the ADW Connection steps. It is the latest addition to the A-Team Chronicles ADW […]

Cloud Integration Patterns Using Oracle PaaS

Introduction Integration is a key aspect in any Cloud implementation. The integration usecases can be presented in many forms such as integrating cloud applications and on-premise applications in real-time or getting a data into an application from a file generated by a data-source or it can exposing APIs to an application which does not  expose […]

Using Catalog Manager with Oracle Analytics Cloud

Introduction The latest releases of Oracle Analytics Cloud (OAC) now support the use of Catalog Manager. Catalog Manager is a tool that lets you perform online and offline management of OAC Catalogs. This post describes how to use Catalog Manager with Oracle Analytics Cloud. It is a step-by-step guide if you wish to perform the steps […]

Creating a Dashboard Landing Navigation Page in Oracle Analytics Cloud (OAC) & Oracle Business Intelligence (OBI/OBIEE)

Background                                                                         Dashboard Landing Navigation Pages (also known as start page, landing page, default page, default dashboard, home page) can be […]

Importing into the Autonomous Data Warehouse using Oracle Data Pump

Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Cloud Infrastructure (OCI). Versions OCI Compute    Oracle-Linux-7.6-2018.11.19-0 Instant Client     18.3.0.0.0 for Linux x86-64 (64-bit) ADW DB            18.0.3.3 SQL Developer 18.3.0.277 Assumptions An Oracle Cloud […]

Connecting Oracle Data Integrator Cloud Service to the Autonomous Data Warehouse

Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) on Oracle Cloud Infrastructure (OCI) to the Autonomous Data Warehouse (ADW). It demonstrates both the Thin and Oracle Call Interface (oci) versions of the Oracle JDBC driver. It is a companion post to Connecting Oracle Data Integrator Studio to the Autonomous Data Warehouse which uses ODI […]

Add a Logout Function to the Default Log Out Menu Item in Oracle Integration Cloud Visual Builder

Introduction Each Visual Builder (VBCS) web application in Oracle OICS (Oracle Integration Cloud Service) comes with a default shell. The default shell displays a simple title, username (as a menu button) and a Log Out menu item. See picture below.   However, if you click the Log Out button, nothing happens. This is because no […]