Set up Fusion SaaS BI Cloud Connector (BICC) to use Cloud Storage

For other A-Team articles by Richard, click here

Introduction

This article walks through the steps to set up a Cloud Storage Container, for use with the Fusion SaaS BI Cloud Connector.

This may be of particular interest to Oracle Analytics Cloud customers, wanting to use the new Data Replication functionality from Fusion SaaS (for more details, see this article).

The process requires the use of Cloud Storage Classic Service.

Existing OAC customers should have Storage Classic as part of their services.  

Autonomous Analytics (OAAC) customers may need to get an additional subscription for this service.

Create a Storage Container

 

  • Connect to your Oracle Cloud and go the the ‘My Services‘ page.
  • Select the ‘Storage Classic‘ service, then open the Service Console.

  • If this is the first time creating a container, the screen will look like this.  Go ahead and ‘Create Container‘.  If other containers have already been created – use the ‘Create Container‘ button on the right side of the page.

  • Give the container an appropriate name.  Note – under the ‘Advanced‘ options, there’s an ‘Enable Encryption‘ selector.  Leave this unchecked.  Analytics Cloud will support encryption in a future release, but for now, do not select this.
  • Click ‘Create‘ to finish the process of creating the storage container.

The final step is to get the details of the Rest Endpoint.  This string will be used within the Fusion BI Cloud Connector storage settings.

  • Click on the ‘Account‘ menu item.

  • Copy and paste the Rest Endpoint details from this section:

This URL will be in the format of:

https://someurl.oraclecloud.com/v1/Storage-somedetails

 

Update BICC Settings

 

  • Go to the Fusion SaaS BIACM environment and select the ‘Configure External Storage‘ menu option from the right menu bar as shown:

You should see 2 tabs – one for ‘Configure External Storage‘, and one for ‘Configure OAC External Storage‘.

Note

In the 18.05 release of the BI Cloud Connector, you need to first ‘Configure External Storage’, and then the ‘Configure OAC External Storage’.   Enter the same details in both tabs.

In subsequent releases you should be able to just enter the details in the ‘Configure OAC External Storage’.

 

  • Be sure to select ‘Cloud Storage Service‘ as the ‘Storage Type’ .  UCM is NOT supported for the OAC Data Replicator.
  • Use HTTPS as the protocol.
  • For the Host, enter the value that corresponds to the ‘someurl.oraclecloud.com‘ from the Rest Endpoint URL above.
  • Use the Storage Admin user credentials
  • For the Service Name, enter the value that corresponds to the ‘Storage-somedetails‘ from the Rest Endpoint URL above.
  • Use the ‘Test Storage Service Connection‘ to confirm the correct values.  Once a successful test has been performed, you can select the storage container you created in the previous step.  In this example the ‘Analytics‘ container is selected.
  • Save‘ the settings with the button in the upper right of the screen, then do the same for the ‘Configure OAC External Storage‘ tab.

That’s it !  When the BI Cloud Connector next runs, it will save the files to the cloud storage container.

 

Summary

This article walked through the steps to set up and configure a Storage Cloud container to be used by the Fusion SaaS BI Cloud Connector.

For other A-Team articles by Richard, click here

 

Comments

  1. Hi Richard,

    thanks for putting this together. I am trying to set up a BICC to OAC Cloud storage just as you have above but on testing the storage service connection, it gives me an error message that I must make at least on selection from the Container drop down list. But there are no values in the container list.
    Do you have an Idea why I am getting this error message?

    Thanks

Add Your Comment