Setting up the export of data to Salesforce CRM

To set up and run the export of data to Salesforce CRM, you'll need to do the following:

  1. Create a Salesforce CRM destination

  2. Create the Salesforce CRM campaign

  3. Run the campaign job

Create a Salesforce CRM destination

You will need to create the Salesforce CRM destination to configure where the data will be exported to.

To create the Salesforce CRM destination:

  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 Destinations.
  3. In the top-right corner, click Create destination.

Step 1: Define destination details

The job details section allows you to define the type of destination and how it will display in Oracle Unity.

Enter the information for the destination.

An image of the destination details

  • Type: Use the drop-down list to select Salesforce CRM.
  • Name: Enter a name. The name must be 1 or more characters, up to a maximum of 50. Use only letters (a–z and A–Z), numbers (0–9), underscores (_), hyphens (-), and spaces. The first character cannot be a space.

  • Destination ID: The unique system identifier that is auto-populated from the destination name you enter. You can't change this value after you create the destination.

  • Description: Enter a description. This field is optional, but it is highly recommended to add descriptions for any entity created. This helps all other users get additional context when using and navigating Oracle Unity. The description can have a maximum of 512 characters with no restrictions on characters used. You can use characters from all languages supported in the language settings.

Step 2: Configure authentication settings

Enter the information to allow Oracle Unityto access the required data from Salesforce.

An image of the authentication section

  • URL: Enter the base URL of your Salesforce account.
  • Client ID: Enter the Client ID of your Salesforce account.
  • Client Secret: Enter the client secret of your Salesforce account.
  • Security Token: Enter the security token of your Salesforce account.
  • Username: Enter the username of your Salesforce account.
  • Password: Enter the password of your Salesforce account.

Once you enter all the details, click Verify connection to ensure that Oracle Unity can access the server. If there are connection issues, confirm the server path and authentication settings entered are correct.

Field mapping section

This section allow you to configure field mapping between Oracle Unity personalization attributes and Salesforce object fields.

  • You also have the option of configuring field mapping while creating the campaign that uses this destination.

  • You can leave this section without field mapping and configure all field mapping while creating the campaign.

  • Any configurations/updates you make to field mapping in the campaign will override any configurations made in the destination settings.

To configure the field mapping:

  1. Use the drop-down list for Salesforce Object to select the object that has the Salesforce object fields you want to map.

    2. An image of the Salesforce Object list

  2. Click Add An image of the add button.

    3. An image of the add button

  3. Select an External Id Field. This is a unique identifier for the object in Salesforce and is used for UPSERT operations. If the parameter exists, use the insert command. If the parameter doesn't exist, use the update command.

    4. An image of the External Id field list

  4. Under Personalization attribute, enter the exact name of the Unity personalization attribute you want to map.

    5. An image of the Personalization attribute field

  5. Under Salesforce object field, select the object field you want to map to the Unity personalization attribute.

    6. An image of the Salesforce object field list

  6. Click Add An image of the add button.

    7. An image of the add button

  7. Continue creating mappings for the selected Salesforce object.

  8. If needed, configure additional Salesforce objects and corresponding mappings.

Step 3: Save and publish the new destination

When finished defining the destination, scroll to the top of the page and click Save or Save and close.

Once you create the destination, you will need to publish the changes.

Create the Salesforce CRM campaign

After creating and publishing the destination, you can create the campaign and select the segment to export.

To create the campaign:

  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 Campaigns.
  3. In the top-right corner, click Create campaign.

The Create campaign page is displayed.

Step 1: Define campaign details

The campaign details section allows you to define how the campaign will display in Oracle Unity. You will also need to select the segment to export.

To define the campaign details:

  1. Enter the details for the campaign.

    2. An image of the Campaign details section

    • Name: Enter a name. The name must be 1 or more characters, up to a maximum of 30. Use only letters (a–z and A–Z), numbers (0–9), underscores (_), hyphens (-), and spaces. The first character cannot be a space.

    • Campaign ID: The unique system identifier for your campaign. You can't change this value after you create the campaign.

      • If the campaign name uses English characters, the Campaign ID field is auto-populated from the campaign name you enter. You can change this value before the campaign is created.
      • If the campaign name uses characters from another language supported in the language settings, the Campaign ID field will be left blank. You will need to enter a name using English characters.

    • Description: Enter a description. This field is optional, but it is highly recommended to add descriptions for any entity created. This helps all other users get additional context when using and navigating Oracle Unity. The description can have a maximum of 512 characters with no restrictions on characters used. You can use characters from all languages supported in the language settings.

  2. Click Continue.

Step 2: Select destination

You will select the Salesforce CRM destination you created earlier.

To select a destination:

  1. Select the Salesforce CRM destination.
  2. Click Verify connection to ensure that Oracle Unity can access the destination.

    3. An image of the Destinations section

  3. After verifying the connection, click Continue.

Step 3: Select segment

You will select the segment and then map Oracle Unity personalization attributes and Salesforce attributes. You can only map one Salesforce data object for the campaign.

Any mappings you configure in this section will override the mappings configured in the selected destination settings.

To select a segment: 

  1. Open the drop-down list for segments or search by segment name to select the segment.

    2. An image of the Segment section

  2. In the Attributes mapped section, select the data object in Salesforce you want to use for field mapping.

    3. An image of the Data object in Salesforce field

  3. Select the External Id Field. This is a unique identifier for the object in Salesforce and is used for UPSERT operations. If the parameter exists, use the insert command. If the parameter doesn't exist, use the update command.

    4. An image of the External Id Field list

  4. Review the Necessary Salesforce fields that must be mapped.

    5. An image of the necessary Salesforce fields for mapping

  5. Under Personalization attribute, select the Unity attribute you want to map. Under Salesforce object field, select the field you want to map to the Unity attribute.

    6. An image of the fields for mapping Unity attributes and Salesforce object fields

  6. Click Add An image of the add button.

    7. An image of the add button

  7. When done configuring the field mapping, click Continue.

Step 4: Schedule and notify

You will need to configure the schedule and notification settings for the campaign.

An image of the Schedule and notify section

To schedule the campaign and define the notification settings:

  1. Configure the schedule for the campaign:
    • Click Recurring to automatically run the campaign job on a regular schedule.
    • Click On demand to run the campaign job as needed.
  2. If the campaign job is recurring, select the Frequency, Start time, and Days it will run.
  3. In the field for Notify, enter the email addresses of people to be notified when the campaign job runs. Separate multiple emails with a comma.
  4. If you only want a notification if the campaign job fails, click the checkbox Only notify on failure.

Step 5: Save and publish the campaign

After saving the campaign you will need to publish the changes before it can run.

To save and publish the campaign:

  1. Scroll to the top of the page and click Save or Save and close.
  2. Follow the steps for Publishing changes.

Run the campaign job

After the publish job successfully completes, you can run the campaign job, either as a scheduled job or manually from the Data feeds page. You can then monitor its progress from the Jobs dashboard.

Once the campaign job successfully completes, you can view the exported data in the Salesforce CRM application.

integrate, integration, salesforce, how to integrate, salesforce crm, export