Oracle Fusion Applications using Oracle Business Intelligence Cloud Connector (BICC)
You can extract data from Oracle Fusion Applications in Data Integration by connecting those data sources either with Oracle Business Intelligence Cloud Connector (BICC) or Oracle Business Intelligence Publisher (BIP).
For example, to extract data from an Oracle Fusion ERP or HCM application, you set up an Oracle Fusion Applications data asset as a data source in a Data Integration data flow. When integrating using BICC, Data Integration instructs BICC to unload the data into a predefined Object Storage bucket configured in BICC (external storage location). Policies to use BICC, to access the Object Storage bucket, and network requirements for accessing Oracle Fusion Applications must be in place.
Before You Begin
Using Oracle Fusion Applications data assets in Data Integration requires extra setups and access to other services in Oracle Cloud Infrastructure. Before you create an Oracle Fusion Applications data asset, review this section.
First time using BICC with Data Integration
See the Load and transform data from Oracle Fusion Cloud Applications to build a data lake or data warehouse blog for an end to end walk-through.
- More References
-
- Set up BICC to use Object Storage
- Incrementally extract BICC data using Data Integration, which explains how to build a user-managed incremental extract using BICC.
- Alternatives to using synchronous BIP for extracting data which discusses the pros and cons of using BIP and BICC and why not to use BIP for synchronous data extraction.
Use the task checklist in the following table to ensure that you have the required setup and information you need for creating and using Oracle Fusion Applications data sources.
Task | Requirement |
---|---|
Obtain access to BICC |
This topic assumes you already have the proper credentials to access and use BICC. See Provision Access in Creating a Business Intelligence Cloud Extract. |
Obtain your Fusion Applications connection details |
When you create a Fusion Applications data asset, you need to provide the following:
Instead of providing the password, you can use a secret in Oracle Cloud Infrastructure Vault to store the password, and provide the OCID of that secret. See Vault and secret concept descriptions in Oracle Cloud Infrastructure Vault To copy the secret OCID, see Getting a Secret's Details. |
Verify network configuration to access Oracle Fusion Applications. |
If the Fusion Applications host is accessible from the internet, and the workspace has an attached virtual cloud network (VCN), the VCN must:
See Virtual Networking Quickstart. If the Fusion Applications host is not accessible from the internet, you can use FastConnect to set up a fast and secure connection between Oracle Cloud Infrastructure and the Fusion Applications host. |
Create policies to allow Data Integration to access buckets and objects in Oracle Cloud Infrastructure Object Storage. |
To use an Oracle Fusion Application data asset in a data flow design, you need an OCI Object Storage bucket as the staging location. Object Storage is the only storage type in BICC that you can use as the external storage location for staging extracted data. The following policies are required for staging the extracted data in an Object Storage bucket.
|
Create a bucket in Oracle Cloud Infrastructure Object Storage. |
After creating a bucket, gather the following details, which you need to provide in the BICC application to configure external storage.
|
Set up the external storage location in the BICC application, to reference the Object Storage bucket you created. |
See the Set up BICC to use Object Storage blog for step by step instructions. For a description of the fields, go to the Oracle Fusion Cloud Applications, Creating a Business Intelligence Cloud Extract documentation. Under the Implement chapter, go to Configure Where to Load Data and review the fields in Storage Type - OCI Object Storage Connection. |
Policies required also depend on whether the Object Storage instance and Data Integration instance are in the same tenancy or different tenancies, and whether you create the policies at the compartment level or tenancy level. Review more examples and the blog Policies in Oracle Cloud Infrastructure (OCI) Data Integration to identify the right policies for your needs.
Oracle Fusion Applications Data Asset using BICC Connection
To use a secret for the password, see OCI Vault Secrets and Oracle Wallets.
To create a data asset that connects to a BICC source, complete the following properties and connection details.
Field | Description |
---|---|
Properties | |
Name |
Enter a name for the data asset. |
Identifier |
The identifier is a system-generated value based on the name you specify. You can change the identifier value, but after you create and save the data asset, you can't update the identifier. |
Description |
Add a description. This field is optional. |
Type | The field shows the data source type that you selected in the Select data asset type panel (as described in Creating a Data Asset). Data Integration displays the data asset property fields and default connection fields based on this type. |
Oracle fusion applications host |
Enter the host name. |
Treat NUMBER columns without precision and scale as VARCHAR |
Select this checkbox to treat numbers without precision and scale as VARCHAR to prevent data loss. For example, if you have a numeric data type with a precision value that's greater than 38, or if you have numeric data types without precision and scale properties. |
Retain NUMERIC data type for NUMBER columns without precision |
Retain NUMERIC data type for NUMBER columns without precision. This check box is selected to retain numbers without precision as numeric data type when creating new target entity. For example, if source has a numeric data type without a precision value and if this check box isn't selected, then such numeric fields are converted as string in target system instead of the numeric data type. By default, when the Treat NUMBER columns without precision and scale as VARCHAR check box is selected, this check box is also enabled for Fusion and Oracle Data Assets. The primary purpose of this check box is to facilitate the generation of target columns with numeric data types, specifically designed for forward engineering use cases which have unconstrained numeric columns in source. The actual creation of target columns depends on how the underlying databases handle the creation of columns without scale and precision. |
Default connection information | |
Name | Enter a name for the default connection. |
Identifier | The identifier is a system-generated value based on the name. You can change the identifier value, but after you create and save, you cannot update the identifier. |
Description | (Optional) Add a description. |
Type |
Select Oracle BI Cloud Connector. |
Username | Enter the username that can connect to the Fusion Applications host. |
Use vault secret OCID | If you use a secret in Oracle Cloud Infrastructure Vault to store the BICC application password, select this option. The following field appears:
|
Use password |
If you select this option, enter the password in the Password field. |
Default BICC external storage configuration |
Optionally, select the default external storage location to use for this data asset. This option is the Object Storage bucket that BICC uses for staging the extracted data. You can override the default location when you add the Fusion Applications data asset to a data flow. |
(Optional) Test connection | |
Test connection | After you complete all the required fields, click Test connection to ensure that the data asset details have been entered correctly and the connection can be established. A success message appears if the test is successful. If the test fails with an error message, review the connection settings and try again. |