Salesforce Marketing Cloud

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

Authentication methods

Marketing Cloud uses a complicated mix of credentials and keys, depending on which features you use:

OAuth for APIs, SFTP for file transfer with GPG on outbound

OAuth for APIs, SFTP for file transfer

OAuth for APIs, Cloud Storage for file transfer

Inbound Syncs

The following are available as inbound streams:

• Data Extensions (Full Refresh only)

• Journey History (Incremental only, beginning 30 days prior to sync start)

Outbound Syncs

Supported Targets

• Data Extensions

Supported Sync Strategies

• Upsert (performs an AddAndUpdate import operation)

• Update (performs an UpdateButDoNotAdd import operation)

• Create (performs an AddAndDoNotUpdate import operation)

• Replace (performs an Overwrite import operation). Note that although Salesforce does not require a primary key for this operation, Omnata Push still requires one in order to properly track the full life cycle of records over time.

These operations are described here.

Functions

FETCH_DATA_EXTENSIONS

Fetches a list of Data Extensions.

Parameters:

• CONNECTION_SLUG (VARCHAR): The slug of the connection

Examples:

select *
from table(OMNATA_SALESFORCE_MARKETING_CLOUD_PLUGIN.UDFS.FETCH_DATA_EXTENSIONS(
                'my-sfmc-connection'));

FETCH_DATA_EXTENSION_RECORDS

Fetches records from a Data Extension.

Note that currently this function requires a connection method with FTP credentials.

Parameters:

• CONNECTION_SLUG (VARCHAR): The slug of the connection

• DATA_EXTENSION_NAME (VARCHAR): The name of the data extension

Examples:

select *
from table(OMNATA_SALESFORCE_MARKETING_CLOUD_PLUGIN.UDFS.FETCH_DATA_EXTENSION_RECORDS(
                'my-sfmc-connection',
                'My Data Extension'));

FETCH_DATA_EXTRACT_DEFINITION

Fetches an individual data extract definition.

Parameters:

• CONNECTION_SLUG (VARCHAR): The slug of the connection

• DEFINITION_ID (VARCHAR): The ID of the data extract definition

Examples:

select OMNATA_SALESFORCE_MARKETING_CLOUD_PLUGIN.UDFS.FETCH_DATA_EXTRACT_DEFINITION(
                'my-sfmc-connection',
                'a1bcda25-8359-4c32-9876-452c530c196a');

FETCH_DATA_EXTRACT_DEFINITIONS

Fetches all data extract definitions.

Parameters:

• CONNECTION_SLUG (VARCHAR): The slug of the connection

Examples:

select *
from table(OMNATA_SALESFORCE_MARKETING_CLOUD_PLUGIN.UDFS.FETCH_DATA_EXTRACT_DEFINITIONS(
                'my-sfmc-connection'));

FETCH_DATA_EXTRACT_TYPES

Fetches all data extract types.

Parameters:

• CONNECTION_SLUG (VARCHAR): The slug of the connection

Examples:

select *
from table(OMNATA_SALESFORCE_MARKETING_CLOUD_PLUGIN.UDFS.FETCH_DATA_EXTRACT_TYPES(
                'my-sfmc-connection'));