Fusion Data in Oracle AI Data Platform Workbench with BICC

You can connect your Oracle AI Data Platform Workbench directly to raw Fusion data using the Business Intelligence Cloud Connector (BICC).

You can use Oracle Business Intelligence Cloud Connector (BICC) to extract business intelligence and other data in bulk and load it into designated external storage areas. To learn more about creating an extract using BICC, see Creating a Business Intelligence Cloud Extract.

To create a connection with BICC to your Oracle AI Data Platform Workbench, you need the following prerequisites:

Fusion Applications Prerequisites

You need to ensure you have the required permissions for your Fusion Applications instance. The user logging into the Fusion Applications instance must have:

  • Administrator permissions for the instance
  • ORA_ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT role or a role that includes it

Oracle AI Data Platform Workbench Prerequisites

In the OCI compartment where your AI Data Platform Workbench instance resides, you need to have:
  • An Object Storage Bucket
  • Object Storage bucket name
  • Object Storage namespace
  • Object Storage host name
  • OCID value of your AI Data Platform Workbench instance tenancy
  • OCID value of the user with the API key created to access the Object Storage Bucket

Create an Oracle Business Intelligence Cloud Connector Connection to Oracle AI Data Platform Workbench

To use the Oracle Business Intelligence Cloud Connector (BICC) to access your Fusion data directly from your Oracle AI Data Platform Workbench.

  1. Open any browser and enter https://<saas cloud host name>:<saas cloud port number>/biacm to sign into your Fusion Applications instance.
  2. Click Configure External Storage.
  3. Click the OCI Object Storage Connection tab, then click Add.
  4. Enter the required OCI parameters. See the required OCI parameters in Oracle AI Data Platform Workbench Prerequisites.
  5. Click Generate API Signing Key, then click Export Public Key.
  6. Open Oracle Cloud in another window and log in as the user with access to the Object Storage Bucket.
  7. In the top-right, click Profile, then click User Details.
  8. Click API Key and add the exported public API key from BICC.
  9. Return to the BICC window. Click the Console tab, then click Test the Connection.
  10. Click Save.

Add Fusion Data Sources with a BICC Connection

You can use your BICC connection to your Fusion Applications instance to connect data sources to your Oracle AI Data Platform Workbench.

  1. Open any browser and enter https://<saas cloud host name>:<saas cloud port number>/biacm to sign into your Fusion Applications instance.
  2. Click Manage Jobs, then click Add to create a new job.
  3. Select the offerings and required public virtual objects you want to add to your AI Data Platform Workbench. Click Save.
  4. Click Manage Job Schedules, then click Add to create a new schedule.
  5. Set the schedule to run immediately or on a ongoing basis. Click Save.
  6. Once the job has run, check the Object Storage Bucket in OCI to confirm the data is available. Data is exported as zipped CSV files.

Extract Fusion Data from a BICC Connection to a Notebook

Once you have connected Fusion Data to your Oracle AI Data Platform Workbench from a BICC connection, you can extract that data from a notebook.

  1. From your home page, navigate to a notebook.
  2. In your notebook, enter Spark code to extract the data. For example:
    spark.read.format("aidataplatform") \
    .option("type", "FUSION_BICC") \
    .option("fusion.service.url", "https://<saas cloud host name>:<saas cloud port number>") \
    .option("user.name", "john.smith") \
    .option("password", "**password**") \
    .option("schema", "Financial") \
    .option("fusion.external.storage", "FA4IDL") \
    .option("datastore", "CrmAnalyticsAM.GeographiesAnalyticsAM.Geography") \
    .load().show()
  3. Read the data to a data frame and save the data frame as a delta table in a catalog.