Create an Oracle Sales Cloud Data Stream (Beta)

Create a data stream to start the flow of data from Oracle Sales Cloud to Data 360.

User Permissions Needed 
To create a connection:Data Cloud Architect

This feature is a Beta Service. Customers may opt to try a Beta Service using their own discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms.
  • Review IP addresses to make sure that the Oracle Sales Cloud connection has the necessary access.

  1. In Data Cloud, on the Data Streams tab, click New.

    You can also use App Launcher to find and select Data Streams.

  2. Under Other Sources, select the Oracle Sales Cloud connection source, and click Next.

  3. Select from the available Oracle Sales Cloud connections.

  4. Select the object that you want to import, and click Next.

    You can select one new object on the Available Objects tab.

  5. Under Object Details, for Category, identify the type of data in the data stream.

  6. For Primary Key, select a unique field to identify a record. If the dropdown doesn’t show a primary key, create one using a formula field.

    1. To create a formula field, click New Formula Field.

    2. For Field Label, enter the data stream field’s display name.

    3. For Field API Name, enter the data stream field’s programmatic reference.

    4. For Formula Return Type, select Text.

    5. In the Transformation Formula text box, enter a UUID() formula.

    6. To validate the formula, click Text.

    7. Click Save.

    8. For Primary Key, select the UUID that you created.

  7. (Optional) Select a record modified field.

    If data is received out of order, the record modified field provides a reference point to determine whether to update the record. The record with the most up-to-date timestamp is loaded.

  8. (Optional) For Organization Unit Identifier, select a business unit to use in a record’s data lineage.

  9. Click Next.

  10. For Data Space, if the default data space isn’t selected, assign the data stream to the appropriate data space.

  11. Click Deploy.

When the Last Run Status displays success, you can see how many records were processed and the total number of records that were loaded.