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 can also extract from these view objects.
BI Apps customers have pre-created ODI mappings, that take the data from view objects, and load that into a pre-created data warehouse model.
For everyone else, there will be a certain amount of 'figuring out' which View Objects house the data you need, and then what are the data types, and the keys to join on.
This short article will walk through the steps to find which View Objects house the data needed.
Setting up an extract with the BI Cloud Connector, requires the name of the View Object.
Most fusion pillars provide an excel spreadsheet download that details the data available in extracts, and how that maps to the view objects.
1. Open a browser, and go to this page, and select the appropriate link in the section 'How to Review View Object Data Lineage Mappings'
2. Follow the link and download the applicable spreadsheet for the release of fusion, typically the latest one, and use that to figure out the view object that you need to use for your data extract(s).
The spreadsheets provide information on Bi View Objects and columns, as well as the Fusion Database Table and Column names.
Use the filters in the columns to narrow down and find the names of the View Object(s) that are required for your extracts. These can then be used in the BI Cloud Connector, or other extract tool, to select and extract the data required for your downstream processes.
This article walked through the steps to identify which View Objects house the data required for Fusion SaaS data extracts.