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.
  • Create a new connection.  Note, while you can in theory create multiple connections, only one can be used for OAC Storage.

  • Give the Storage connection a name, and select the ‘OAC External Storage’ checkbox.
  • 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,

    I Followed the Above steps and was able to create a Storage Container in Storage Classic and was able to configure that Storage Container in Fusion SaaS (Oracle Business Intelligence Cloud Connector Console > Configure External Storage) and test was successful.

    The problem I am facing is I can’t see the new External Storage container when I try to run a Extract, can see UCM container only.

    Anyone facing same issue ?

    Thanks,
    Raghu

  2. Andrzej Lupa says:

    Hi Richard,

    I am trying to configure the External Storage as per your instruction (BICCC version 11.13.0.0.0.) , Build OBIACM_11.13.18.10.0PB_GENERIC_181118.1532).

    Unfortunately, the configuration process fails at the step “Test Storage Service Connection” with message related to the field “Container”.

    “Error: A selection is required You must make at least one selection”
    Actions “Refresh” and drop down are not producing any result.

    I have tested Container using Cloud Services -> Storage Classic and was able to upload/download objects using my credentials.

    I would be very grateful for suggesting a solution or workarounds.

    Kind Regards,

    Andrzej Lupa

  3. Hi,

    I am experiencing similar issue – did you find a resolution to this?

    Thanks,

    Rajiv

  4. 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

    • Andrzej Lupa says:

      Hi,

      I have an identical issue and I have escalated it to SR severity 2 with Oracle Support. I will share a solution if I manage to pass this configuration issue.

      Regards,

      Andrzej

      • thanks – please do. I was about to post that the best thing would be to create an SR. If you followed these steps, then there is likely a connectivity issue somewhere. Support / Cloud ops are going to be the best folks to diagnose. I know a number of people have gotten this to work with these instructions, me included.

Add Your Comment