1. Configuring Oracle Analytics Cloud
  2. Advanced Configuration
  3. Replicate Data
  4. Replicate Your Data
  5. Create a Replication Connection For Oracle Fusion Cloud Applications

Create a Replication Connection For Oracle Fusion Cloud Applications

To replicate data from Oracle Fusion Cloud Applications, you set up a data replication connection in Oracle Analytics Cloud.

  1. In Oracle Analytics Cloud, click Create, then Replication Connection.
  2. Click Oracle Fusion Application Storage.
  3. Specify these connection details:
    • Storage Type - Select OCI for Oracle Cloud Infrastructure Object Storage or Classic for Oracle Cloud Infrastructure Object Storage Classic.
    • Storage Region - Specify the region on Oracle Cloud Infrastructure where the storage bucket resides (for example, us-ashburn-1). In the Object Storage API endpoint, the region is specified immediately before oraclecloud.com. For example, https://objectstorage.us-ashburn-1.oraclecloud.com.
    • Storage Tenancy OCID - Specify the Oracle Cloud Identifier (OCID) for the tenancy where the bucket resides.
    • Storage User OCID - Specify the Oracle Cloud Identifier (OCID) for the user that will access the storage bucket.
    • Storage Bucket - Specify the name of the storage bucket.
    • URL - Specify the API endpoint for the Fusion Enterprise Scheduler Web Service. For example, https://<fa-host>/bi/ess/esswebservice or just the hostname <fa-host>.
    • Username - Specify the username of the Oracle Fusion Cloud Applications user with permissions to access BI Cloud Connector.
    • Password - Specify the password of the Oracle Fusion Cloud Applications user with permissions to access BI Cloud Connector.
    • Storage API Key - Click Generate, then click Copy to create an API signing key. Oracle Analytics Cloud Data Replication uses this key to authenticate when it accesses the object storage bucket.
    • Storage Connection - Specify the storage connection in BI Cloud Connector Console to use when writing the extracted data. The BI Cloud Connector storage connection must point to the same bucket as the Oracle Analytics Cloud connection.
  4. In separate browser window or tab, navigate to Oracle Cloud Infrastructure Console and open the navigation menu. Under Identity & Security, click Domains, select the identity domain that Oracle Analytics Cloud uses, and then click Users. Locate and click the name of the user for your replication user account.

    If you don't see the Domains link, click Users.

  5. Under the API Keys section, add these keys:
    • Add the public key for the Data Replication connection that you copied to the clipboard in Step 4.
    • Add the public key that was saved when you created the storage connection in BI Cloud Connector Console on the Configure External Storage page.
  6. Return to the Oracle Analytics Cloud browser window or tab, and on the Oracle Fusion Application Storage dialog click Save. If you've entered the information correctly, the connection is saved.