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

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

Network separation of Production and Non-Production Environments using the Oracle Private Cloud Appliance and Oracle VM

Overview We are currently seeing rapid adoption of Fusion Applications in the SaaS@Customer model. This and the strong Fusion Applications On-Premise installation base have been further secured by establishing strict rules for separation of Production Systems and Non-Productions Systems. Usually the mandate is to separate the network traffic on the logical level as well as […]

Oracle Cloud Infrastructure (OCI) REST call walkthrough with curl

  Introduction This post will walkthrough the elements required, and purpose of each, to make a curl request to Oracle Cloud Infrastructure (OCI) REST services. While there are a variety of tools offered that make this task far easier than manually constructing a curl request, the purpose of this post is to provide an explanation […]

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

Trigger OIC Integration Using OAuth

As businesses move to the cloud there is a high demand for securing/protecting their HTTP resources from unauthorized access. There are several approaches to protecting these resources which include SAML for SOAP service, OAuth for REST services, HTTP basic for both, and sometimes home grown proprietary mechanisms. It may not be widely known yet, but […]

Oracle GoldenGate Services Architecture: Silent Install and Deployment

Introduction In many organizations, users are not permitted to run the graphical user interfaces used to install the Oracle GoldenGate software and create Oracle GoldenGate Microservices Architecture (OGG-SA) Deployments. In this article we shall review the two response files required to silently install the OGG-SA application code and create a new Deployment. The concepts, scripts, and information presented in […]

Oracle GoldenGate Services Architecture: Configure Deployment Via REST API

Introduction The Oracle GoldenGate Microservices Architecture (OGG-SA) REST API may be used to configure Extracts, Replicats, and Distribution Paths, as well as create new parameter files or modify existing ones for a Deployment. In this article we shall use the REST API to configure a replication path and perform common modifications to Deployments; such as changing OGG_HOME after […]

Using the IDCS’ OAuth Device Flow for Fun and Profit

Introduction If you’ve been on the internet recently you’ve probably used OAuth and more specifically the “Authorization Code” grant type (or “AZ Code” if, like The Dude, you are into the whole brevity thing). For example if you’ve ever clicked a “Sign on with Facebook” button or used a Facebook app you’ve used OAuth’s AZ […]

OIC Connectivity Agent Installation Pointers

The connectivity agent has been a feature of Oracle’s integration cloud strategy from the beginning to address the challenge of the cloud/on-premise integration pattern. However, the implementation of the agent differs between Oracle Integration Cloud Service (ICS) and Oracle Integration Cloud (OIC). With both offerings, the pattern for setup remains the same: 1. Create Agent […]

Completing the Migration from Business Intelligence Cloud Service to Oracle Analytics Cloud

Introduction This post is the second in a two-part series and details the tasks required to complete a migration from Business Intelligence Cloud Service (BICS) to Oracle Analytics Cloud (OAC) running on Oracle Cloud Infrastructure (OCI). For details on preparing for the migration to OAC see Preparing to Migrate from Business Intelligence Cloud Service to Oracle Analytics […]

Preparing to Migrate from Business Intelligence Cloud Service to Oracle Analytics Cloud

Introduction This post is the first in a two-part series and details the tasks required to prepare for a migration from Business Intelligence Cloud Service (BICS) to Oracle-Managed Oracle Analytics Cloud (OAC) running on Oracle Cloud Infrastructure (OCI). For details on completing the migration to OAC see Completing the Migration from Business Intelligence Cloud Service to […]

Getting Started Using Terraform with OCI

Introduction Standing up infrastructure requires building networks, servers and storage entailing complex build and configuration management processes. Traditionally done with scripts or even manually, Terraform gives you a new alternative. Using Terraform you can write a declarative description of your infrastructure. Using the Terraform “compiler” the declaration is converted to a build plan and then […]