Content validated on 05/08/2023 with
ADW Version Oracle Database 19c Enterprise Edition Release - Production Version 19.11.0.0.0
Oracle Cloud Application 23B (11.13.23.04.0)
Fusion Analytics Warehouse Application Version 23.R2
Oracle Fusion Analytics provides analytics for Oracle Cloud applications, powered by Autonomous Data Warehouse and Oracle Analytics. More specifically:
Making the right business decisions is intrinsinclty tied to the system of records data accuracy of a company. In many specific use cases, Fusion Analytics data can be complemented with additional data from external source such as On Premise, Legacy applications, Non Fusion SaaS application, OCI source, Third party cloud applications, and so on...
To support these data enrichment and consilidation requirements, Fusion Analytics is introducing a new Connectors to leverage the Fusion Analytics Oracle data pipeline infrastructure to extract data (full and incremental) from these external sources following a defined schedule, potentially reducing custom data extraction code, infrastructure and platform costs.
This blog describes how to utilize Fusion Analytics (FAW) Data Augmentation feature to replicate transaction data from US Bureau of Labor Statics (BLS) into ADW to extend the Data Layer of FAW.
The US Bureau of Labor Statistics publishes the following statistical data sets:
These data sets can provide critical insight when merge with Fusion CX data,for instance, to target campaign, potential customers, to generate new leads and in fine to produce new revenue.
Suggested Prerequisite Reading Material:
* FAW Semantic Model Customization
Overall prerequisites
* Have access to an Fusion Analytics Instance (OAC, ADW) with Administrative privileges
* Have configured SQL level access to Fusion Analytics ADW, as described in Krithika and Gunaranjan blog post here.
FAW Data Augmentation allows customers to leverage the FAW data pipeline to augment reports with datasets created :
The diagram below details the architecture for the Connectors :
Figure 1: FAW Data Augmentation flow with BLS Connector
The high level configuration flow is as follow:
US Bureau of Labor Statistics provides a public data API that can be leveraged by third party consumer. With FAW, the API used does not require registration nor authentication.
FAW Configuration
Enable BLS feature
Create BLS Connection
Test Connection
Refresh metadata for BLS connection
Set Pipeline Settings
Create BLS data augmentations
FAW Data Pipeline processes the data augmentation pipeline jobs, extract the data from BLS tables and load it into ADW, queryable via synonyms starting with DW_BL_X_
Augmented data can be then queried directly using OAC Data set or a SQL client like SQL developer, through the database synonym named after the table name give in the first step
Semantic model can be extended by using semantic model extension or External Application merge feature allow reporting on augmented data extracted in ADW. We will cover the basics here to be able to build a visualization against the extracted BLS Data. External Application merge will be documented a future blog.
Let's watch the video now
Figure 2: BLS and Fusion Analytics Connector configuration
Now that the Data Augmentation have completed, we can create Data Sets and Workbooks
Figure 3: BLS visualization
This concludes the activities in the blog.
Click here to sign up to the RSS feed to receive notifications for when new A-team blogs are published.
This blog described how to utilize Fusion Analytics (FAW) Data Augmentation Connector to replicate transactions data from US Bureau of Labor Statistics into Autonomous Data Warehouse (ADW) to extend the Data Layer of FAW. This blog also detailed the steps to allow customers to answer business questions and gaining business insight with BLS and Fusion Analytics Data.
Bookmark this post to stay up-to-date on changes made to this blog as our products evolve.
The Oracle A-Team is a central, outbound, highly technical team of enterprise architects, solution specialists, and software engineers.
The Oracle A-Team works with external customers and Oracle partners around the globe to provide guidance on implementation best practices, architecture design reviews, troubleshooting, and how to use Oracle products to solve customer business challenges.
I focus on data integration, data warehousing, Big Data, cloud services, and analytics (BI) products. My role included acting as the subject-matter expert on Oracle Data Integration and Analytics products and cloud services such as Oracle Data Integrator (ODI), and Oracle Analytics Cloud (OAC, OA For Fusion Apps, OAX).
Previous Post
Next Post