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

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

Part 2: Using Postman Runner with Identity Cloud Service

Introduction In the last article, Part 1: Automate getting an Identity Cloud Service Access Token in Postman, I explained how using a Pre-request Script can automate getting an access token so when a request is sent to Identity Cloud Service it just works, a big time saver. In this article I am going build on […]

Part 1: Automate getting an Identity Cloud Service Access Token in Postman

Introduction If you have spent enough time working with web services you have probably heard of Postman. If not, then let me say it is a great tool to test REST APIs against Identity Cloud Service (IDCS) among other things. When using Postman with web services you quickly learn an OAuth2 Access Token is required […]

Oracle GoldenGate: Monitoring via Restful API

Introduction Oracle GoldenGate version 12.1 introduced the ability to monitor on-premises and GoldenGate Cloud Service instances via a Restful API interface. In this article we will show how to enable monitoring and how to obtain information via Restful API for Oracle GoldenGate on-premises instances running version 12.1 or 12.2 and GoldenGate Cloud Service running version 12.2. Main Article Before […]

Using the Oracle SCM Cloud R12 REST API

Overview Starting with Release 12, Oracle SCM Cloud provides a REST API – which is easier to use in a lot of cases than the SOAP API and also offers some additional capabilities like the access to the WorkOrder service. Also it can be very easily used by the Oracle IoT Cloud Service and Oracle […]

Uploading a file to Oracle storage cloud service using REST API

Introduction This is the second part of a two part article which demonstrates how to upload data in near-real time from an on-premise oracle database to Oracle Storage Cloud Service. In the previous article of this series, we demonstrated Oracle GoldenGate functionality to write to a flat file using Apache Flume File Roll Sink. If you would […]

Extracting Data from Oracle Business Intelligence 12c Using the BI Publisher REST API

Introduction This post details a method of extracting data from an Oracle Business Intelligence Enterprise Edition (OBIEE) environment that is integrated with Oracle Business Intelligence Publisher (BIP) 12c. The environment may either be Cloud-Based or On-Premise. The method utilizes the BI Publisher REST API to extract data from a BIP report. It also uses BIP […]

Integrating with Documents Cloud using a Text Editor as an example

Introduction Oracle Documents Cloud Service provides a powerful REST API and embed tools allowing integrate with almost anything today. This section will cover a web text editor reading and sending html/text content to the Documents Cloud using basic javascript and JQuery. The first example covers the basic action to load a text area and send […]

Loading Data in Oracle Database Cloud Service

Oracle Database Cloud Service – Schema (a.k.a Database Schema Service) is an Oracle Platform Cloud Service offering that provides a single Oracle Database schema which is fully managed by Oracle. It also includes Oracle Application Express (APEX), which is a rapid browser-based database application development system. In addition to allowing you to rapidly build database-based […]