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

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

Performance of MFT Cloud Service (MFTCS) with File Storage Service (FSS) using a Hybrid Solution Architecture in Oracle Cloud Infrastructure (OCI)

Executive Overview MFT Cloud Service clusters in Oracle Cloud Infrastructure Classic (OCI-C) are provisioned with database file storage system (DBFS) for shared storage as discussed in one of our earlier blogs[1]. In Oracle Cloud Infrastructure (OCI), customers also have the option of using File Storage Service (FSS) for shared storage. FSS can be used for […]

Oracle GoldenGate: Monitoring “Things” That Affect Replication Stability

Introduction There have been a lot of escalations to A-Team where Oracle GoldenGate outages could have been avoided if System and Database Administrators had been properly monitoring their environments. In this article we’re going to discuss various areas that should be monitored regularly to avoid degradations in performance and unscheduled outages. The concepts, scripts, and information […]

Best practices to model prospects, customers, suppliers, partners in an Oracle Fusion cloud implementation

Introduction Three major entities of every business/enterprise in most industries, are Customers, Suppliers and Products. In reality, customer, supplier and product data is required to be stored in all applications and each application might have different data model and data structure requirements. If customer data and product data are not consistently stored in all applications […]

MFTCS: Production and DR in the Cloud

  Introduction Oracle Managed File Transfer (MFT) Cloud Service is a Platform as a Service (PaaS) computing platform solution for running a high performance, standards-based, end-to-end managed file gateway in the cloud. It features design, deployment, and monitoring of file transfers using a lightweight web-based design-time console that includes transfer prioritization, file encryption, scheduling, and embedded […]

Cloud Security: User Provisioning to Fusion Applications Cloud

Introduction The notion of a user is the most common reason for misunderstanding and confusion. When we mention a user, we often think of the person who is allowed to use an application. However, nearly every application has a different user structure implemented. The challenge is to find a common ground for these differing user […]

Connecting Data Visualization Desktop Version 5 to the Autonomous Data Warehouse

Introduction This post details the steps required in Data Visualization Desktop (DVD) version 5 (12.2.5+) to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data connections. For DVD Version 4 ADW Connections refer to Creating a Connection in Data Visualization Desktop Version 4 to the Autonomous Data Warehouse Cloud For additional details on ADW, visit the […]

Mobile App Development with OAuth 2.0 and IDCS: A High Level Approach

Introduction IDCS is used by enterprises and organizations to allow secure access to their applications.  IDCS uses various open standards such as OAuth 2.0, SAML etc. to protect these applications.  One of the many features of IDCS is to facilitate client applications accessing backend (REST) APIs using OAuth 2.0 (https://tools.ietf.org/html/rfc6749).  Client applications come in different […]

Set up Fusion SaaS BI Cloud Connector (BICC) to use Cloud Storage

For other A-Team articles by Richard, click here Introduction This article walks through the steps to set up a Cloud Storage Container, for use with the Fusion SaaS BI Cloud Connector. This may be of particular interest to Oracle Analytics Cloud customers, wanting to use the new Data Replication functionality from Fusion SaaS (for more details, […]

Creating a VPN Connection for Oracle Analytics Cloud on Oracle Cloud Infrastructure – Classic

Introduction This post details the steps required to create a Virtual Private Network (VPN) connection for Oracle Analytics Cloud (OAC) Data Visualization (DV) using Oracle’s VPN as a Service (VPNaaS). VPNaaS is deployed on Oracle Cloud Infrastructure – Classic (OCI-C). VPN is not available on Oracle Cloud Infrastructure (OCI) for Autonomous OAC yet. The specific use […]

Connecting Oracle Analytics Cloud Version 5 to the Autonomous Data Warehouse

Introduction This post details the steps required in OAC version 5 (18.3+) to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data, replication and console connections. The wallets are used for Data Visualization (DV) data sets, DV Replications, Metadata (RPD) connection pools, and Thin Client Modeler (TCM) models. Data connections are used for […]

Content and Experience Cloud ContentSDK: npm package

The 18.3.5 release of Content and Experience Cloud includes full support for the Delivery REST API. The REST API is documented. Next to the REST API is a lightweight JavaScript wrapper around this API released. This wrapper is delivered as a minified JavaScript file as well as an NPM package. This package is not available […]

Hybrid DNS in OCI

It’s a common scenario to have DNS name resolution between FQDNs in OCI and your on-prem… or between multiple OCI VCNs.  How do we make this happen today?  By using a hybrid DNS solution, of course! What is a hybrid DNS solution?  It’s essentially a DNS overlay on top of the built-in OCI VCN DNS.  […]

SaaS Data Replication in Oracle Analytics Cloud (OAC, and OAAC)

For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was added.  This allows Oracle Analytics Cloud (OAC and OAAC), to replicate data, on a schedule, from a number of Oracle’s SaaS offerings.   For many use cases, this will mean that a separate […]

Achieving DR in the cloud using Oracle Dyn

Recently a colleague of mine (Kumar) and myself were facing a scenario where we needed to provide a solution providing disaster recovery (DR) functionality between two OCI regions.  It is a fairly common requirement to support some sort of disaster recovery (DR) between different geographical locations.  It has been a common practice in traditional enterprise […]

Fusion SaaS – Finding The View Object You Need for Data Extracts

For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work directly against. The recommended approach to extract data for most use cases, is through the BI Cloud Connector tool.  This pulls data from ‘View Objects’ in the Business Intelligence layer […]

Part 3: Automate Requests against Identity Cloud Service using Newman

Introduction In Part 1: Automate getting an Identity Cloud Service Access Token in Postman I covered using a Pre-request script to automate getting an Access Token from Identity Cloud Service in order to successfully be authorized to send REST API requests. Then in Part 2: Using Postman Runner with Identity Cloud Service I built on […]