Overview of Data Replication

Data replication makes data more readily available for visualization and analysis without repeatedly executing expensive queries or data extracts on the original data source. You can also use data replication to build content packs for Oracle Cloud applications. Data replication is available in Oracle Analytics Cloud Enterprize edition.

Prerequsites for Data Replication

Before you start, make sure you have the correct components required for data replication.

You need the following:

  • Oracle Analytics Cloud Enterprise edition. You'll need data replication permissions (administrator role) for Oracle Analytics Cloud.
  • A supported data source, such as Oracle Fusion Applications or Oracle Service Cloud (RightNow).

  • A supported data target, such as Oracle Database or Oracle Big Data Cloud in which to replicate your data.

  • If you're replicating Oracle Fusion Applications data, you need:
    • BI Cloud Connector:
      • BI Cloud Connector deployed in the Oracle Fusion Applications environment.
      • Access to BI Cloud Connector Console in Fusion Applications.
      • Connection details for the storage instance of Oracle Cloud Infrastructure specified on the Configure External Storage page of BI Cloud Connector Console.
    • Oracle Cloud Infrastructure:
      • Compute permissions in Oracle Cloud Infrastructure to be able to administer object storage.
      • Oracle Cloud Infrastructure storage. You can use either Oracle Cloud Infrastructure Object Storage or Oracle Cloud Infrastructure Object Storage Classic.

        If you already replicate your data from Object Storage Classic, it's easy to switch to Object Storage.

      • Compute permissions in Oracle Cloud Infrastructure for administering object storage.
      • Details of an existing storage bucket in Oracle Cloud Infrastructure, including the storage bucket name, the namespace in which the bucket resides, and the Oracle Cloud Identifier (OCID) for the tenancy where the bucket resides.
      • A user account Oracle Cloud Identifier (OCID) to access the storage bucket from both Oracle Fusion Applications and Oracle Analytics Cloud.

Information You Need for Data Replication

Before you start, make sure you have the required details for data replication.

Oracle BI Cloud Connector

  • The https://{fa_url}/biacm link for your Oracle BI Cloud Connector.

Oracle Fusion Applications

  • The host name and connection details for your Oracle Fusion Applications instance.

Oracle Cloud Infrastructure Storage

  • The host name, storage service name, and container name of your Oracle Cloud Infrastructure storage instance (Oracle Cloud Infrastructure Object Storage or Oracle Cloud Infrastructure Classic Storage). Use this information to configure Oracle BI Cloud Connector to point to your Oracle Storage Cloud storage instance.

  • The REST Endpoint URL for your Oracle Cloud Infrastructure storage instance.

    The first part of the URL is the Storage host and the last part is the Storage Name/Service Name. For example:

    https://uscom-{location}.storage.oraclecloud.com/v1/Storage-mystoragecloudclassic

    To obtain the REST Endpoint URL, go to Oracle Cloud Infrastructure Classic Console, navigate to Storage Classic, click Account and copy the REST Endpoint URL.

  • Details of your object storage bucket in Oracle Cloud Infrastructure, including the name of the storage bucket, the namespace in which the bucket resides, and the Oracle Cloud Identifier (OCID) for the tenancy where the bucket resides.
  • The Oracle Cloud Identifier (OCID) for the user with access to the storage bucket.

What Data Can I Replicate?

You can replicate data from these sources.
  • Oracle Eloqua

  • Oracle Fusion Applications (with either Oracle Cloud Infrastructure Object Storage or Object Storage Classic)

  • Oracle Service Cloud (RightNow)

  • Oracle Talent Acquisition Cloud (Taleo)

What Target Databases Can I Replicate Data Into?

You can replicate data into numerous types of database.
  • Oracle Autonomous Data Warehouse

  • Oracle Big Data Cloud

  • Oracle Database Cloud Service

What Replication Tasks Can I Do?

You can perform numerous data replication tasks.
  • Create data flows to replicate your data (known as replication data flows).

  • Schedule replication data flows to perform regular incremental updates.

  • Limit the data that you replicate using a filter.

What Privileges and Permissions Are Required?

Make sure you have the required privileges and permissions for data replication.

To replicate data, you must have the BI Service Administrator application role or some other role that includes BI Service Administrator.

For Oracle Big Data Cloud, the user requires no special privileges.

For Oracle Database, to replicate into the user’s own schema, the user needs the following privileges :

  • CREATE SESSION

  • CREATE TABLE

For Oracle Database, to replicate data into other schemas within the target database, the user needs all of the following privileges:

  • CREATE ANY TABLE

  • SELECT ANY TABLE

  • ALTER ANY TABLE

  • COMMENT ANY TABLE

  • INSERT ANY TABLE

  • UPDATE ANY TABLE

  • DELETE ANY TABLE

  • DROP ANY TABLE

  • CREATE ANY INDEX

  • ALTER ANY INDEX

  • DROP ANY INDEX

  • ANALYZE ANY

What Options Are Available when Replicating Data from Oracle Fusion Applications Data Sources

When you replicate data from an Oracle Fusion Applications data source, use these options.

Some View Objects record change history (similar to slowly changing dimensions). To replicate the change history, click Include History on the replication setup dialog.

Keep replicated data synchronized with the source data using the Include Deletions option on the replication setup dialog. If you select Include Deletions and a record is deleted from the source data, it’s also deleted from the target database.

To synchronize data, you use the Include Deletions option in incremental data loads (where the Load Type option is Incremental). In full data loads, the target table rows are deleted before the replication starts.

With Custom View Objects, you can replicate data in any custom view using the Add a custom view object option on the replication setup dialog. Enter the full path and name of the view, for example, FscmTopModelAM.TaskDffBIAM.FLEX_BI_TaskDFF, then click Add to add the view to the Replicate Objects list so you can select fields.