Loading Data from Oracle Identity Cloud Service into Oracle BI Cloud Service using REST

This post details a method of extracting and loading data from Oracle Identity Cloud Service (IDCS) into the Oracle Business Intelligence Cloud Service (BICS). It builds upon the A-team post IDCS Audit Event REST API which details the REST API calls used.
One use case for this method is for analyzing trends regarding audit events.
This post uses REST web services to extract JSON-formatted data responses. It also uses the PL/SQL language to wrap the REST extract, JSON parsing commands, and database table operations in a Stored Procedure. It produces a BICS staging table which can then be transformed into star-schema object(s) for use in modeling. The transformation processes and modeling are not discussed in this post.
Finally, an example of a database job is provided that executes the Stored Procedure on a scheduled basis.

Read more at – Loading Data from Oracle Identity Cloud Service into Oracle BI Cloud Service using REST