Setting up relationships based on the Oracle CrowdTwist schema

After configuring the data objects needed to import Oracle CrowdTwist data, you will need to create relationships to link the data between the data objects.

Create the Oracle Audience Segmentation relationships

You will have to complete these steps three times to create the required relationships.

Refer to the Oracle Audience Segmentation relationships details based on the CrowdTwist schema for the specific details to configure.

To create a relationship:

  1. Click the Oracle icon Image of the application navigation button. Use it to access the different parts of Oracle Unity. in the bottom-right corner to open the navigation menu.
  2. Select Data model.
  3. From the list of Data objects, select the object you want to add the relationship to.
    4. An image of the list of data objects in the data model
  4. From the Details section click AddAn image of the add relationship button. Use it to add a relationship to your data object. next to Relationships.

    5. An image of the create relationship icon

  5. Use the drop-down list to select the second data object for the relationship. Refer to Oracle Audience Segmentation relationships details based on the CrowdTwist schema.

    6. An image of the Create relationship dialog

  6. Confirm which data object will be the parent and which will be the child.

    7. An image showing the parent and child relationship of data objects

  7. Click Next.
  8. Review the compatibility check to ensure that both data objects have the correct object IDs. If needed, click the checkbox for Add to data object.

    9. An image showing the compatibility check for a new relationship

  9. Click Save.

Publishing changes

Follow the steps for Publishing changes so that the relationships will be created in the Oracle Audience Segmentation data model.

After successfully publishing changes, you can then follow the steps for Setting up attributes based on the Oracle CrowdTwist schema.

Oracle Audience Segmentation relationships details based on the CrowdTwist schema

You will need to create ther required Oracle Audience Segmentation relationships with the following details.

Parent data object (attribute) Child data object (attribute)
Customer (ID) Loyalty Activity (Customer ID)
Customer (ID) Loyalty Redemption (Customer ID)
Loyalty Reward (ID) Loyalty Redemption (LoyaltyRewardID)

Learn more

Relationships

integrate, integration, crowdtwist, oracle crowdtwist, how to integrate, link, link oracle apps, link oracle crowdtwist, import crowdtwist data, relationship, foreign key