Extract Fusion Data from a BICC Connection to a Notebook

Once you have connected Fusion Data to your Oracle AI Data Platform 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("datalake") \
       .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.