1. Export Campaign Data in Bulk from Snowflake to Salesforce Marketing Cloud Using GCP Storage
  2. Activate and Run the Recipe

4 Activate and Run the Recipe

After you've configured the connections and other resources, you can activate and run the recipe.

  1. In the project workspace, click Activate. In the Activate project panel, with the default project deployment selected, choose an appropriate tracing option, then click Activate.

    A message confirms that the integration has been activated. Refresh the page to view the updated status of the integration.

  2. Update the integration properties of the integration flow. You can update the integration properties for the integration flow only after activating the recipe.
    1. In the Integrations section of the project workspace, click Actions Actions icon on the Snowflake Salesforce Marketing Cloud Campaign Sync integration flow, then select Update property values.
    2. In the Update property values panel, update the integration properties with appropriate values.
      1. EmailTo: This integration property holds the email address to which run-time exception emails are sent. Enter an email address of your choice.
      2. RetryCount: You can specify the number of retries if any invoke fails at run time. The default value is set 3.
      3. WaitForCampaignCreationRetry: This integration property controls retries and timeouts for confirming the successful creation of campaigns in Salesforce Marketing Cloud. The default value is set to 60 secs.
    3. Click Submit.

      A message confirms that the integration properties have been updated successfully.

  3. Run the recipe.
    1. In the Integrations section of the project workspace, click Actions Actions icon on the Snowflake Salesforce Marketing Cloud Campaign Sync integration flow, then select Run.
    2. On the Configure and run page, click Run.

      You've now successfully submitted the integration for execution.

      Note:

      You can also schedule this integration to run at a date, time, and frequency of your choosing. See Define the Integration Schedule.
  4. Monitor the running of the integration flow in Oracle Integration.
    1. In the project workspace, click Observe. You'll see the integration flow being triggered and running successfully.
    2. To manage errors in your project, see Manage Errors in a Project.
  5. In your Salesforce Marketing Cloud instance check for the campaign objects created.
    1. Log in to Salesforce Marketing Cloud.
    2. On the Home page, click Campaigns.
      You can see the list of campaigns created.

Related Documentation