Connecting Oracle Autonomous Analytics to the Autonomous Data Warehouse

Introduction This post details the steps required to upload an ADW wallet and create data and console connections in Oracle Autonomous Analytics (OAAC) or Oracle Analytics Cloud (OAC) to the Autonomous Data Warehouse (ADW). The wallet is used for Data Visualization (DV) data sets, Metadata (RPD) connection pools, and Thin Client Modeler (TCM) models. Data connections […]

Oracle GoldenGate Microservices Architecture: Using Self-signed Certificates

Introduction Oracle GoldenGate Microservices Architecture (OGG-MA) provides functionality for securing Rest API calls and communications channels between the Distribution and Receiver Servers over Transport Layer Security (TLS). In order to activate this security protocol a SSL Certificate must be obtained from a Certificate Authority (CA) and installed on the server prior to creating the OGG-MA […]

Restrict Root Compartment Access with Oracle Cloud Infrastructure Policies

The OCI Administrators group grants manage acess to all resources in all compartments including the root compartment.  So, any member of this group is considered a super user.  Is a normal practice to keep Administrators members to a small number of users and create additional groups/policies to restrict access to specific compartments. If there’s a […]

Downloading Autonomous Data Warehouse Credentials

Introduction This post details the steps required to download an Autonomous Data Warehouse (ADW) Client Credentials Zip File. This file is required by all clients connecting to ADW. For additional details on ADW, visit the Autonomous Data Warehouse page. Updates Latest Validation: June 21, 2018 Published on: June 21, 2018 Versions Used Autonomous Data Warehouse 18.1.5 Windows 7 […]

Using SSSD with Kerberos and Active Directory to Terminal into an OCI Linux Machine

Introduction OCI or Oracle Cloud Infrastructure, is Oracle’s latest cloud infrastructure that is replacing the older Oracle Cloud Infrastructure Classic. One feature it has is built-in Identity Management Governance. For example, you can add and manage users to grant who can access OCI resources among other features, please refer to this link for more information https://cloud.oracle.com/governance. […]

Extracting Data from Fusion SaaS via View Objects with Data Sync

For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle Analytics Cloud Service (OAC), Oracle Autonomous Analytics Cloud Service (OAAC), and other oracle relational databases, or into Essbase. In the most recent 2.5 […]

Creating a React Based Conversational Chatbot Client

Built using Oracle Intelligent Bots version 18.2.3 Introduction Oracle Intelligent Bots is an integrated feature of Oracle Autonomous Mobile Cloud Enterprise (AMCe) which allows you to develop Intelligent Chatbots. A Chatbot or Bot is a computer program designed to simulate a conversation with human users, especially over the Internet. End users can easily connect to […]

Oracle GoldenGate Services Architecture: Monitoring Via REST API

Introduction The Oracle GoldenGate (OGG) REST API may be used to configure, manage, and monitor Oracle GoldenGate Microservices Architecture (OGG-MA) services and deployments. In this article we shall use REST API to monitor an existing OGG-MA deployment. The concepts, scripts, and information presented in this article are for educational purposes only. They are not supported by […]

Using Data Sync to Extract and Load Data from Fusion SaaS using the BI Cloud Connector (BICC) and UCM

For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle Analytics Cloud Service (OAC), Oracle Autonomous Analytics Cloud Service (OAAC), and other oracle relational databases, or into Essbase. In the most recent release, […]

Monitoring SaaS Application Performance in EM using RUEI

Introduction Performance and efficiency are essential to having a positive user experience and the diagnosis of click and flow activities can be a complex task in a SaaS environment where access to various log files is limited. Oracle Real User Experience Insight (RUEI) – monitors real user activity, records user session data and provide web […]

Under the hood: Oracle Identity Cloud Service Audits

Introduction Audit events enable organization administrators to review the actions performed by members of your organization using details provided by the Audit logs – who performed the action, performed it, and what the action was.  Before getting into the article I want to mention this blog was written by Abhishek Juneja, a Principal Product Manager of Identity & […]

API Platform Service Callouts using a Groovy Policy

Purpose The purpose of this post is to demonstrate through a practical example how a Developer might enrich an API payload using a Service Callout from within a Groovy Policy.   Background Since the release of Oracle API Platform v17.2.5, there has been a standard Policy entitled Service Callout 2.0 (version 1.0 having been deprecated […]

GoldenGate Cloud Service (GGCS): How to run SSH Socks Proxy Server for Oracle GoldenGate (OGG)

Introduction In this article we shall discuss how to configure and run Secure Shell (SSH) Socks Proxy server needed for Oracle GoldenGate (OGG) replication between On-Premises and GoldenGate Cloud Service (GGCS) in the Oracle Public Cloud (OPC). The SSH Socks Proxy server is required in GoldenGate replication between On-Premises and OPC, only if there’s no […]

Oracle GoldenGate Best Practices: GoldenGate Capture from a DataGuard with Cascaded Redo Logs

  Introduction This paper provides guidance and examples for setting up downstream extraction from an Oracle DataGuard Standby system that has been configured with cascading redo logs. We outline how to configure the cascade log shipping from the standby to the mining database as well has how to configure the extract process on the mining […]

Restrict access to IDCS UI using Sign-On Policies

Introduction The purpose of this blog post is to describe how to use Sign-On Policies to restrict access to the OOTB Oracle Identity Cloud Service UI. One use-case could be that End-Users should not be able to view and update their own profile details using the OOTB UI. All content listed on this page is […]

Connecting DIPC ODI Studio to the Autonomous Data Warehouse Cloud

Introduction This post details the steps required to create connections in the Data Integration Platform Cloud (DIPC) to the Autonomous Data Warehouse Cloud (ADWC). It demonstrates both the Thin and OCI versions of the Oracle JDBC driver. It is a companion post to Connecting Oracle Data Integrator Studio to the Autonomous Data Warehouse Cloud which uses ODI Studio on Windows. […]

BI Cloud Connector – Deletion of Data Extract Files on UCM

Introduction This blog post is the continuation of the formerly shared article about BI Cloud Connector (BICC) Data Extraction File Downloading. In the previous blog post I gave an introduction into BICC and we discussed the options how to download the data extraction files from Storage Cloud or the internal built-in Universal Content Management (UCM) […]

Oracle Data Integration Platform Cloud (DIPC): Configure VPN as a Service (VPNaaS) for On-Premises Connectivity

Introduction This document will walk you through how to configure Virtual Private Network as a Service (VPNaaS) with Oracle Data Integration Platform Cloud (DIPC) for connectivity between On-Premises Oracle database and Oracle Public Cloud (OPC). One major requirement for DIPC to be configured with VPNaaS is; DIPC must be provisioned to use IP Network instead of […]

How to Configure Oracle Identity Manager to use Unicast

As of version 11gR2PS1 (11.1.2.1.0), OIM relies on JGROUPS to implement cache coordination among all it’s cluster nodes.  Out of the box OIM is configured to use Multicast (one to many) for JGroups for cluster messaging.  This could be a showstopper when deploying OIM in datacenter where Multicast is blocked or unsupported, which is the case in […]

Embedding the Oracle OICS Process Workspace Application in an iFrame

Introduction Oracle Process Cloud Workspace is a web application that a user uses to interact with human activities in BPMN processes. It is a stand-alone web application in Oracle Integration Cloud Service (OICS). In some use cases, customers want to embed the Workspace application in an iframe of their own web page. Out of box, […]