Salesforce Marketing Cloud Connector

Back Next

Salesforce Marketing Cloud sources in mappings

To read data from Salesforce Marketing Cloud, configure a Salesforce Marketing Cloud object as the Source transformation in a mapping.

Specify the name and description of the Salesforce Marketing Cloud source. Configure the source, query options, and advanced properties for the source object.

The following table describes the source properties that you can configure for a Salesforce Marketing Cloud source:

Property	Description
Connection	Name of the source connection. You can select an existing connection, create a new connection, or define parameter values for the source connection property. If you want to overwrite the source connection properties at runtime, select the Allow parameter to be overridden at run time option. Specify the parameter file directory and name in the advanced session properties.
Source Type	Type of the source object. Select one of the following source types: Single Object Multiple Objects Parameter Default is Single Object .
Parameter	A parameter file where you define values that you want to update without having to edit the task. Select an existing parameter for the source object or click New Parameter to define a new parameter for the source object. The Parameter property appears only if you select parameter as the source type. If you want to overwrite the parameter at runtime, select the Allow parameter to be overridden at run time option. When the task runs, the Secure Agent uses the parameters from the file that you specify in the advanced session properties.
Object	Name of the Salesforce Marketing Cloud source object based on the source type selected. Select the source object for a single source. When you select the multiple source option, you can add multiple source objects and configure a relationship between them.

The following table describes the query options that you can configure for a Salesforce Marketing Cloud source:

Property	Description
Filter	Filter value in a read operation. Click Configure to add conditions to filter records and reduce the number of rows that the Secure Agent reads from the source. Specify one of the following filter conditions: Not Parameterized. Use a basic filter to specify the object, field, operator, and value to select specific records. Completely Parameterized. Use a parameter to represent the field mapping. Advanced. Not applicable. Default is Not Parameterized .
Sort	Not applicable for Salesforce Marketing Cloud Connector.

Property

Description

Filter

Filter value in a read operation. Click

Configure

to add conditions to filter records and reduce the number of rows that the Secure Agent reads from the source.

Specify one of the following filter conditions:

Not Parameterized. Use a basic filter to specify the object, field, operator, and value to select specific records.

Completely Parameterized. Use a parameter to represent the field mapping.

Advanced. Not applicable.

Default is

Not Parameterized

Sort

Not applicable for Salesforce Marketing Cloud Connector.

The following table describes the advanced source properties that you can configure for a Salesforce Marketing Cloud source:

Property	Description
Batch Size	Minimum number of rows that the Secure Agent reads in a batch. Enter a number greater than 0. Default is 0 .
Read Parameter File	Not applicable.
Tracing Level	Determines the amount of detail that appears in the log file. Select one of the following options: Terse Normal Verbose Initialization Verbose Data Default is Normal .

Rename Saved Search

Table of Contents

Salesforce Marketing Cloud Connector

Salesforce Marketing Cloud Connector

Salesforce Marketing Cloud sources in mappings

Salesforce Marketing Cloud sources in mappings