You must first have a CloudWorks-to-Salesforce connected app to create a Salesforce integration.

The integration between Anaplan CloudWorks and Salesforce is in the Beta testing phase, and is only available to customers enrolled in this program.

Find out more about Beta testing, Early Access (EA), and learn how to register for an Anaplan EA program.

To create a Salesforce import integration:

  1. Enter a new Integration name. Use a unique name of up to 60 characters that starts and ends with a letter or number. Letters used must be in the Latin alphabet . You can include spaces, hyphens (-), and underscores (_), but no other special characters.
  2.  Select Salesforce from the Connection dropdown.
  3. Select your Workspace from the dropdown. 
  4. Select your Model from the dropdown. 
  5. Select the Action type: Import.
  6. Select the Salesforce Data type, either Object or Report.
  7. Select Import from the Action dropdown.
  8. Select your Data source from the dropdown.
  9. Select Next.
    The Mapping dialog opens.
  10. Map the Fields to the Values and add the Filter condition to relate them.
    See the table below to help you map.
  11. Select Create.

Within your Anaplan module, you must match line item column headers to your Salesforce field names. When these match, the Salesforce object Anaplan line item imports successfully. To identify the Anaplan line item within Salesforce:

  1. Select the gear icon and Setup (setup for current app) from the dropdown.
  2. Beneath Objects and Fields, select Object Manager.
  3. Select this object for which to discover the API names (in this example the name is Account).
  4. Beneath Details select Fields & Relationships.
  5. Select the FIELD NAME. Note that these entries all contain _underscores_.
    In the screenshot below, the example is: Current_Open_Opportunties_c.

Also see: How to configure Salesforce for an integration with CloudWorks .

The Salesforce dialog for Setup and Object Manager, Fields and Relationships.
FiltersInput values
Booleans we support:

> greater than
< less than
>= greater than or equal
<= less than or equal

Use numbers only.

= equals
!= not equal
The values must be true/false.
FLOATUse numbers only.
DATEUse valid date format: YYYY-MM-DD.
DATETIMEUse valid time stamp format: YYYY-MM-DDTHH:MM:SS+HH:MM.
STRINGUse valid string format. Example: ActM7#2X%d&F.
LIKEUse valid wildcard string format.  Examples: Sales%, Sales_.
The dialog for import field mapping. Fields, Filter condition and Value are the three column names.

To create a Salesforce export integration:

  1. Refer to steps 1–4 above.
  2. Select the Action type: Export.
  3. Select your Action from the dropdown.
  4. Select your Data target from the dropdown.
  5. Check the box Make this available on User Experience action cards if you want colleagues to be able to run this export.
  6. Select Next.
    The Mapping dialog opens.
  7. Map the Field Mapping dropdowns to the Salesforce dropdowns.
  8. Select from the Write dropdown.
  9. Select from the Unique Identifier dropdown.
  10. Select Create.
The export mapping dialog. Anaplan and Salesforce are the names of the two columns to be mapped per row.