- Sync Customer and Campaign Data Between Oracle Unity and Salesforce Marketing Cloud
- Activate and Run the Recipe
4 Activate and Run the Recipe
After you’ve configured the connections and other resources, activate the recipe package and run it.
- In the Configuration Editor, click
Activate in the title bar. In
the Activate Package dialog, click
Activate again.A message confirms that the integration has been activated. Refresh the page to view the updated status of the integration.
- Run the recipe.
- Export a customer segment from Oracle Unity to an FTP server.
- On the Configuration Editor page, select the Oracle Unity FTP MasterCustomer Export integration flow.
- Click Run , then click Submit Now.
- In the dialog that appears, click Confirm.
- Click Submit on the Schedule Parameters page.
The integration gets triggered, and the customer segment records are exported to the FTP server.Note:
You can also schedule this integration to run at a date, time, and frequency of your choosing. See Define the Integration Schedule.
- Import a customer segment from the FTP server to Salesforce Marketing Cloud.
- On the Configuration Editor page, select the Oracle FTP SFMC DataExtension Import integration flow.
- Click Run , then click Submit Now.
- In the dialog that appears, click Confirm.
The Schedule Parameters page is displayed which includes the following parameters:
- continueInstance: This parameter stores the flag to identify a new instance.
Y
indicates continued process from previous instance.N
indicates a new instance and is the default value. - InstanceNo: This parameter stores the count of the running instance. The default value is
1
. - triggerTimeStamp: This parameter stores the created time stamp of the trigger file that started the instance.
- continueInstance: This parameter stores the flag to identify a new instance.
- Click Submit on the Schedule Parameters page.
The integration gets triggered, and the customer segment data is imported to Salesforce Marketing Cloud data extension.Note:
You can also schedule this integration to run at a date, time, and frequency of your choosing. See Define the Integration Schedule.
- Run the Oracle SFMC Automation Setup integration flow to create the initial customization required in Salesforce Marketing Cloud. This is a one-time setup that configures the automation that queries and stores campaign results in a data extension.
- On the Configuration Editor page, select the integration and click Run , then click Test.
The page to test the integration with a sample file is displayed.
- In the Request section of the test page, on the Body tab, provide the following parameters:
Name Description Example customerDataExtensionName Stores the name of the data extension to which customer segments are imported from Oracle Unity to Salesforce Marketing Cloud. Unity_MasterCustomer_DE automationKey Stores the external key of the automation created in Salesforce Marketing Cloud.
Unity_CampaignResults_Automation automationName Stores the name of the automation created in Salesforce Marketing Cloud. Unity_CampaignResults_Automation resultsDataExtensionKey Stores the external key of the data extension with the campaign result events in Salesforce Marketing Cloud. Unity_CampaignResults_DE resultsDataExtensionName Stores the name of the data extension with the campaign result events in Salesforce Marketing Cloud. Unity_CampaignResults_D automationScheduleStartDateTime Stores the DateTimeStamp when the automation schedule starts in CST Time Zone. YYYY-MM-DDT00:00:00 automationScheduleOccurances Stores the number of occurrences of the automation schedule runs. Note:
The automation runs on a daily schedule.1000 automationScheduleInterval Stores the number of days interval between two occurrences of the scheduled run. 1 - Click Test.
- On the Configuration Editor page, select the integration and click Run , then click Test.
- Synchronize campaign results data from Salesforce Marketing Cloud to Oracle Unity.
- On the Configuration Editor page, select the Oracle SFMC Unity CampaignResults Import integration flow.
- Click Run , then click Submit Now.
- In the dialog that appears, click Confirm.
The Schedule Parameters page is displayed which includes the following parameters:
- continueInstance: This parameter stores the flag to identify a new instance.
Y
indicates continued process from previous instance.N
indicates a new instance and is the default value. - InstanceNo: This parameter stores the count of the running instance. The default value is
1
. - continueRequestId: This parameter stores the Request ID of the Salesforce Marketing Cloud request which needs to be continued in upcoming instances.
- continueInstance: This parameter stores the flag to identify a new instance.
- Click Submit on the Schedule Parameters page.
The integration gets triggered, and the email campaign results are imported to Oracle Unity.
Note:
You can also schedule this integration to run at a date, time, and frequency of your choosing. See Define the Integration Schedule.
- Export a customer segment from Oracle Unity to an FTP server.
- Monitor the running of the
integration flow in Oracle Integration.
- On the Configuration Editor page, select an integration flow.
- Click Run , then click Track Instances.
- On the Track Instances page, observe the integration flow of the recipe being triggered and running successfully.
- Log in to Oracle Unity and check for the new campaign results imported.