Salesforce Data Cloud

What is Salesforce Data Cloud?

Salesforce Data Cloud is a data platform that unifies all of your company’s customer 360 data on to Salesforce’s Platform.

Monitor & Lineage Support

Integrating Monte Carlo with Salesforce Data Cloud allows you to monitor your data assets through capabilities listed below, which can be created in either the UI wizard and/or programmatically via monitors as code (API/SDK too). Note that Monte Carlo will add the capabilities below over time. Please reach out to your Monte Carlo representative if you have requirements for additional monitors.

CategoryMonitor / Lineage CapabilitiesSupport
Table MonitorFreshness
Table MonitorVolume
Table MonitorSchema Changes
Metric MonitorMetriccoming soon
Metric MonitorComparisoncoming soon
Validation MonitorSQL Custom
Validation MonitorValidation
Job MonitorQuery performance
LineageLineage

Connecting to Salesforce Data Cloud

Now that we know the value connecting Salesforce Data Cloud to Monte Carlo can bring, here are the necessary steps to set up the integration. Connecting to Salesforce Data Cloud requires creating a Salesforce External Client App and using OAuth 2.0 client credentials for authentication.
Follow these step-by-step instructions to create an external client app, configure OAuth, and get the necessary credentials.

Create Salesforce Connected App

  1. Log in to the Salesforce Web UI.

  2. Click the gear icon in upper-right corner and select "Setup".

  3. In the side menu, navigate to PLATFORM TOOLS -> Apps -> External Client Apps -> External Client App Manager

  4. Click the "New External Client App" button in upper right.

  5. Enter required fields in the "Basic Information" section.

    • App Name: Monte Carlo
    • API Name: Monte_Carlo
    • Contact Email
    • Distribution State: Local


  6. Enter required fields in the "API (Enable OAuth Settings)" section.

    • Click checkbox for "Enable OAuth"
    • Callback URL: https://getmontecarlo.com/auth/callback/salesforce
    • OAuth Scopes:
      • "Manage user data via APIs (api)"
      • "Perform ANSI SQL queries on Data Cloud data (cdp_query_api)"
    • Under "Flow Enablement" check "Enable Client Credentials Flow"
  7. Click the "Create" button.

  8. Click the "Edit" button to edit the policies of the new app.

  9. Under OAuth Policies -> OAuth Flows and External Client App Enhancements, check "Enable Client Credentials Flow".

  10. Enter a Salesforce user email (like "[email protected]") for the account that will act as the "execution user". By selecting an execution user, you allow Salesforce to return access tokens on behalf of this user.

  11. Click the "Save" button.

Get the Consumer Key and Secret

  1. Switch to the "Settings" tab (near the top of the current page)

  2. Under "OAuth Settings", click the "Consumer Key and Secret" button.

  3. Copy the values into the appropriate fields in the Monte Carlo UI. You can find the Salesforce Data Cloud setup form under Settings -> Warehouse and lakes, then click on the Salesforce Data Cloud tile.

Get the Domain

  1. In the side menu, navigate to SETTINGS -> Company Settings -> My Domain.

  2. Under "My Domain Details", copy the "Current My Domain URL" value and paste it into the "Domain" field in the Monte Carlo UI. It should look something like: <MyDomainName>.my.salesforce.com.