Configure

Before implementing any of the options to load data, configure the following:
  1. An external storage.
  2. A BICC job.
  3. A job schedule for the BICC job.

Configure External Storage

Follow these steps to configure external storage:

  1. To configure the External Storage on BICC go to https://<url-fusion>/biacm:.
  2. Click Configure External Storage.
  3. In the Configure External Storage page, OCI Parameters section, enter the values as an example of using Amazon S3 storage:
    Field Value
    Name BucketS3
    Host objectstorage.us.ashburn-1.oraclecloud.com
    Tenancy OCID ocid1.tenancy.oc1..aaaasjdhgfuysdfsffdgsgsfg
    User OCID ocid1.user.oc1..aaaaxsjdhgfufrgysdfsffdgsgsfg
    Namespace idprie7kdv4
    Bucket BucketS3
  4. In the OCI API Signing Key section, do the following:
    1. Click Generate API Signing Key.
    2. Click Export Public Key.
    3. Add it to the API Signing Key in your OCI profile user.
  5. In the Verification section, click Test Connection.
    If you receive an error, save the connection and wait for one minute before trying again.

Configure BICC Job

You must configure BICC jobs for the Google Cloud Storage and Azure Blob Storage options.

To configure a BICC job, follow these steps:

  1. Navigate to Manage Jobs.
  2. On the Manage Jobs page, in the Jobs table, click the + sign.
  3. Select the list of public view objects (PVOs) for your Snowflake project. On the Oracle Business Intelligence Cloud Connector Console, in the Add Job page, enter the following example values:
    Field Value
    Name BICCSnowflake
    Description List of PVOs for Snowflake Project
    1. In the Data Stores table, in each Business Object row, select the Enabled for Extract checkbox.
    2. Click Save.

Schedule Job

After creating the job, you can now schedule it to run periodically based on your organizations needs.

This example shows how to run the job once Immediate.

To schedule the job, follow these steps:

  1. On the Oracle Business Intelligence Cloud Connector Console, navigate to Manage Job Schedules.
  2. On the Manage Job Schedules page, in the Schedules table, click the + sign.
  3. On the Schedule page, enter the following example values based on the storage you configured:
    Field Value
    Job BICCSnowflake
    Name BICCSnowflake
    Job Type Application Data Extract
    External Storage BucketS3
    1. In the Recurrence section, select Immediate from the list.
      You can choose of these any option on your business needs: Simple, Hourly, Daily, Weekly, Monthly, or Yearly.
    2. In the Notification section, select Use Global Extract Schedule Notification from the list.
    3. In the File Parameters section, select the following:
      Field Value
      Use Global File Prarameters No
      Compression Type Gzip
      Split file size(GB) 1
    4. Click Save.
The job runs immediately. After it completes, the State column value shows Succeeded.