Using Date Based Partitioning for OTBI Extracts with Data Sync to Improve Performance

For other A-Team articles about BICS, OAC, and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into BI Cloud Service (BICS), Oracle Analytics Cloud Service (OAC), and other relational databases. I have previously written about the tool’s ability […]

Configuring Oracle Data Integrator for Oracle Big Data Cloud: Standalone Configuration

Introduction   This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Standalone installation.  ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, and Apache Pig, among others.  ODI supports both distributions of Hadoop:  Hortonworks Data […]

Configuring Oracle Data Integrator for Oracle Big Data Cloud: Environment Configuration

Introduction   This article discusses how to configure the Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) – specifically – how to configure the BDC environment for ODI, so users can design Big Data workloads with ODI and execute them on BDC.  ODI offers out of the box integration with Big Data technologies […]

Configuring Oracle Data Integrator for Oracle Big Data Cloud: Topology Configuration

Introduction   This article discusses how to configure the Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC), specifically – how to configure the ODI Topology.  ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, and Apache Pig, among others.  ODI supports both distributions […]

The Ultimate Apache/OHS11g Tuning Guide for OAM11g WebGate

Introduction OK, maybe “Ultimate” could be stretching it, but it caught your eye so you can be the judge. This post is part of a larger series on Oracle Access Manager 11g called Oracle Access Manager Academy. An index to the entire series with links to each of the separate posts is available here. Though OAM11g is […]

Using Oracle Data Integrator with Big Data Cloud

Introduction   This article presents an overview of how to use Oracle Data Integrator (ODI) with Oracle Big Data Cloud (BDC). ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, and Apache Pig, among others. ODI supports both distributions of Hadoop: Hortonworks Data Platform (HDP), and […]

Identity cloud service : Mobile clients and PKCE support

Introduction OAuth 2.0 has become very popular within the mobile development community mainly because it is simple to implement and the tokens are fairly compact. There are various implementation patterns to choose from and it is very important to choose the right one to make sure that the solution is secure. In this blog post I want to describe how […]

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

GoldenGate Cloud Service (GGCS): Network Connectivity Options for GGCS – On-Premises and Oracle Cloud

Introduction This article will discuss in high-level the different options available for network connectivity between Oracle GoldenGate (OGG) software running on-premises and GoldenGate Cloud Service (GGCS) instance running on the Oracle Cloud. The following topics are not included in the scope of this article: Installation and Configuration of Oracle GoldenGate (OGG) Software Provisioning of GoldenGate […]

BI Cloud Connector – Download Data Extraction Files

Introduction The Oracle Fusion based SaaS offerings provide an interesting tool to extract data and to store them in CSV format on a shared resource like the built-in UCM server or a Storage Cloud: BI Cloud Connector (BICC). The extracted data can be copied from these cloud resources and downloaded to local resources, before post-processing […]

Integration of GGCS with EHCS

  Introduction This document will walk you through how to integrate Oracle GoldenGate Cloud Services (GGCS) with Oracle Event Hub Cloud Services (EHCS). The enterprise edition of GGCS supports Oracle GoldenGate Adapter for Big Data which can be used to stream real time data in to Confluent Kafka, running on EHCS. This document covers provisioning […]

GoldenGate Cloud Service (GGCS): How to provision GGCS in Oracle Public Cloud (OPC) via RESTful API

Introduction This document will walk you through how to provision GoldenGate Cloud Service (GGCS) in Oracle Public Cloud (OPC) via RESTful application programming interface (API). For the purpose of this article, it will be using “cURL” as the RESTful client software to demonstrate the RESTful API calls for provisioning GGCS. For checking the progress of […]

Oracle Database Cloud Service – Near Zero Downtime Migration to the Cloud

Introduction Oracle Database Cloud Service is a great PaaS Service to provide the target platform for migrations of On Premise workloads to the Oracle Cloud. There are a number of migration tools available to support the majority of use cases, however sometimes the focus is on the continuity of service, especially when continuity of service and minimised downtime […]

Decoding JWT using the API Platform Groovy Policy

Introduction With the explosion of APIs; most of the today’s computing challenges are being driven by it and therefore, new standards had to emerge to make sure that APIs can be used securely, while allowing developers to avoid having to reinvent the wheel every time they implement aspects such as authorization. One good example is […]

GoldenGate Cloud Service (GGCS): Applying Patches to GoldenGate

Introduction This document will walk you through how to patch the Oracle GoldenGate (OGG) in the GoldenGate Cloud Services (GGCS). When there is a patch available for install in to your environment, you will see a message similar to one shown in Figure 1, in your GGCS environment. Before proceeding to apply the patch, stop the processes […]

DevOps With Oracle DeveloperCS, Ansible and Docker

This blog shows a sample DevOps cycle using combination of Oracle Developer Cloud Service & Ansible playbook. Scenario: An organization wants to setup DevOps practice with Oracle public cloud for Dev & test. However production still remains on-premise. In such case Oracle Developer cloud service can deploy artifacts(e.g. JAR file) to JCS (Java cloud Service) […]

ICS On-Premise Monitor – Agent Ping

The Integration Cloud Service (ICS) Connectivity Agent is a feature of ICS that helps with the cloud to ground (on-premise) use case that is common to companies who are moving into cloud technologies. The agent provides an ICS subscriber the ability to create ICS integrations that interact with on-premise resources like legacy applications, databases, etc. […]

Build ATG Commerce applications in Oracle Developer Cloud

  Introduction This post will demonstrate how to setup and build an Oracle ATG Commerce application in Oracle Developer Cloud Service (devCS). There are multiple ways to accomplish several steps described in this post. Things will intentionally be shown in a way to help give an understanding of how to accomplish tasks in a variety […]

Configure Oracle Management Cloud (OMC) with ATG Commerce

  Introduction This post will cover the steps required to add Oracle ATG Commerce monitoring to Oracle Management Cloud(OMC). The steps described will be geared towards running ATG with WebLogic server.   Prerequisites In order to follow the steps in this post, you will need to already have an OMC environment. It is also assumed […]

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