A-Team Chronicles

About The A-Team and A-Team Chronicles

The A-Team is a central, outbound, highly technical team comprised of Enterprise Architects, Solution Specialists and Software Engineers within the Oracle Product Development Organization. The team works closely with customers and partners, world wide, providing guidance on architecture, best practices, troubleshooting and how best to use Oracle Cloud Services and products to solve customer business needs. They specialize in using Cloud Solutions across IaaS, PaaS, SaaS as well as On-premise and hybrid deployments.

The A-Team provides this type of support by working with Oracle Consulting, Support and Sales – engaging in the toughest of situations, solving the hardest problems and the greatest of challenges.

The A-Team is lead from Oracle Headquarters in Redwood Shores, CA, but A-Team members are located and positioned globally, so that we are better prepared to respond quickly, and within an appropriate timezone for our Global customers.

“If you have a problem, if no one else can help, and if you can find them, maybe you can hire the A-Team”


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

For other A-Team articles by Richard, click here
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 extract and load processes, is no longer required.

In this initial release, the sources that can be replicated are:

– Oracle Fusion Applicatio…

Read more

Advanced HCM data loader (HDL) processing using OIC HCM adapter.

Oracle Integration Cloud (OIC) Integration provides adapter for most popular SaaS applications, including Oracle HCM Cloud.  This post focuses on integrating with HCM data loader (HDL) tool of HCM using OIC HCM adapter, multiple HDL file processing and fault handling. Information in this post is applicable to release 18.3.1 of OIC.
HCM Adapter basics
Refer to documentation here, for more information about HCM adapter. At a high level, HCM adapter makes it easier to integrate with HCM cloud using REST , HDL. HCM Extracts and ATOM feeds. As with all OIC adapters,a connection is first created using  Oracle HCM Cloud adapter with endpoints and credentials to the target HCM cloud environment. This connection is then used as invocation target in integration flows, at which time t…

Read more

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

For other A-Team articles by Richard, click here
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 of Fusion SaaS.  Other tools, the Analytics Cloud Data Replicator, and Analytics Cloud Data Sync tool, can also extract from these view objects.


Read more

Part 3: Automate Requests against Identity Cloud Service using Newman

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 this Pre-request script to enhance the script to get data from a CSV that would play a role in using Collection Runner, and in addition brought in how we could use the Tests script to grab data from the JSON response. Now in this article I am going to show you how we can use all of what we learned with Newman in order to execute a collection similar to Postman Runner from the command line.

What is Newman?
Simply put, Newman is a tool to run a Postma…

Read more

Part 2: Using Postman Runner with Identity Cloud Service

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 using that Pre-request script and add Tests scripts in a way that we can chain requests in a collection and automate all the requests at once using Postman Collection Runner. Spoiler alert, in my final Part 3: Automate Requests against Identity Cloud Service using Newman, I will incorporate Part 1 and 2 to show how we can use everything we learned with Newman to iterate users from a CSV file and execute a bulk request from a command-line. Fantastic, let’s get started.


Read more

Loren Penton

Loren Penton is a Principal Solution Architect in the Data Integration A-Team where he supports the Oracle GoldenGate product line and its integration to Kafka, Hadoop, JMS, and all sorts of databases - starting with Oracle obviously. Loren has 20 years’ experience in the design and testing of Oracle GoldenGate solutions and over 30 years’ experience designing solutions for the banking, aerospace, and healthcare industries.

Mani Krishnan

Mani Krishnan is a Cloud Solutions Architect in the 'A-Team', where he's mainly focused on integration of SaaS applications and cloud-based application integration tools. Mani has over 20 years integrating enterprise applications in various capacities at large enterprises. He is currently based in Pleasanton, California. His skill set includes standards-based application integration, integration platform as a service (iPaaS), SaaS extensions and digital transformation using both with Oracle and other industry leading tools. Mani joined Oracle in 2016 and has since worked successfully with clients around the world.