Connecting to Salesforce Marketing Cloud

Salesforce Marketing Cloud (formerly ExactTarget) is a provider of digital marketing automation and analytics software and services.

Data integration: Skyvia supports importing data to and from Salesforce Marketing Cloud, exporting Salesforce Marketing Cloud data to CSV files, replicating Salesforce Marketing Cloud data to relational databases, and synchronizing Salesforce Marketing Cloud data with other cloud apps and relational databases.

Backup: Skyvia Backup supports Salesforce Marketing Cloud backup except for objects with composite primary keys.

Query: Skyvia Query supports Salesforce Marketing Cloud.

Salesforce Marketing Cloud-Specific Features and Limitations

Skyvia has the following limitations for Salesforce Marketing Cloud:

Backup of objects with composite primary key is not supported.
Synchronization and Replication with Incremental Updates enabled are not supported for objects without CreatedDate and ModifiedDate fields. Both fields must be present for this functionality.
Since Salesforce Marketing Cloud Data Extensions have neither autogenerated key fields, nor fields, storing record creation or modification time, Data Extensions cannot be used in:
oSynchronization packages
oReplication packages with Incremental Updates selected
oImport packages with the UPSERT operation as a target.

 

Salesforce Marketing Cloud Connections

When creating a Salesforce Marketing Cloud connection, first, you need to specify the Name for your connection, and then - select the Authentication kind to use.

Skyvia supports two kinds of authentication for Salesforce Marketing Cloud: User Name & Password and App Center Client.

 

User Name & Password Authentication

 

For User Name & Password authentication, you need to specify the url to connect to and the user name and password to login.

exacttarget-connection-editor

 

URL - the url to connect to.
User - the user name to login with.
Password - the password to login with.

 

App Center Client Authentication

For App Center Client authentication, you need to specify the Client ID and Client Secret, which are the parts of Salesforce Marketing Cloud API key, and select the environment to connect to: Production or Sandbox.

See Salesforce Marketing Cloud API documentation to find out how to get an API key.

salesforce-marketing-cloud-connection-appcenterclient

App Center Client Id - Application center сlient ID for App Center Client authentication.
App Center Client Secret - Application center client secret for App Center Client authentication.
Environment - select, whether to use a production or sandbox account for App Center Client authentication.

 

Additional Parameters for Salesforce Marketing Cloud Connections

 

You also may set the following additional parameters for your Salesforce Marketing Cloud connections:

Partner IDs - the list of specific partner accounts or business units for retrieve requests.
Use Extension Objects - determines whether Salesforce Marketing Cloud Data Extensions objects are processed as user-defined Salesforce Marketing Cloud objects, allowing Skyvia to read and edit their data.
Metadata Cache - Determines how often to update cached metadata for the connection. By default, Skyvia caches metadata of available objects for cloud sources. You can configure how often the cache is refreshed automatically or reset in manually on the Connection Details page of the corresponding connection by clicking the Clear link in the Metadata cache parameter in the Parameters pane. The following values are available for this setting:
oDisabled - the metadata cache is not created, and metadata are queried automatically whenever the connection is opened.
oOne Hour - the metadata cache expires after one hour since the previous refresh, and it is refreshed after this when the connection is opened.
oOne Day - the metadata cache expires after one day since the previous refresh, and it is refreshed after this when the connection is opened.
oOne Week - the metadata cache expires after one week since the previous refresh, and it is refreshed after this when the connection is opened.
oOne Month - the metadata cache expires after one month since the previous refresh, and it is refreshed after this when the connection is opened.
oInfinite - the cache is never reset automatically. Default value.