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

OGG Extract entry in DBA_APPLY view

Introduction DBAs are often reviewing what items exist in their DBA views.  I was recently asked by a DBA if they could drop the Apply Process  in the DBA_APPLY view since they had no OGG Apply processes running on this particular system.  They only had OGG Capture processes on this particular server.  The short answer […]

Oracle HCM Cloud – Bulk Integration Automation Using SOA Cloud Service

Introduction Oracle Human Capital Management (HCM) Cloud provides a comprehensive set of tools, templates, and pre-packaged integration to cover various scenarios using modern and efficient technologies. One of the patterns is the batch integration to load and extract data to and from the HCM cloud. HCM provides the following bulk integration interfaces and tools: HCM Data […]

Fusion HCM Cloud – Bulk Integration Automation Using Managed File Transfer (MFT) and Node.js

Introduction Fusion HCM Cloud provides a comprehensive set of tools, templates, and pre-packaged integration to cover various scenarios using modern and efficient technologies. One of the patterns is the bulk integration to load and extract data to/from the cloud. The inbound tool is the File Based data loader (FBL) evolving into HCM Data Loaders (HDL). […]

Fusion HCM Cloud Bulk Integration Automation

Introduction Fusion HCM Cloud provides a comprehensive set of tools, templates, and pre-packaged integration to cover various scenarios using modern and efficient technologies. One of the patterns is the bulk integration to load and extract data to/from cloud. The inbound tool is the File Based data loader (FBL) evolving into HCM Data Loaders (HDL). HDL […]

How to force OGG to use ENABLED Invalid or Non-Validated Keys

Introduction If a table has a PK constraint or a Unique Constraint that is Non-Validated or Invalid, Oracle GoldenGate will by default not use those keys to uniquely identify a row.  It will use all columns to uniquely identify a row.  This may become an issue due to the increased space required for both trails […]