ODBC Driver for Salesforce Marketing Cloud

Connection String Options - SalesforceMC ODBC Driver



The following table describes the options that you can include in the connection string to Salesforce MC, formerly known as ExactTarget:

Option Description

Authentication

Used to specify the authentication type when connecting to Salesforce Marketing Cloud. The available values are:

  • UserandPassword
  • AppClientCenter

The default value - UserandPassword.

Partner IDs

The list of specific partner accounts or business units for retrieve requests.

User and Password Authentication

Option Description

Server

The server address to connect to. Devart ODBC Driver for Salesforce Marketing Cloud can connect to Salesforce Marketing Cloud (formerly known as ExactTarget) CRM servers. The default value is https://webservice.s7.exacttarget.com/Service.asmx.

User ID

Used to supply a unique User ID to connect to a Salesforce Marketing Cloud account.

Password

Used to supply a password to login to Salesforce Marketing Cloud.

App Center Client Authentication

Option Description

Client ID

Used to supply Application Client ID for App Center Client authentication.

Client Secret

Used to supply Application center client secret for App Center Client authentication.

Sandbox

Allows using a production or sandbox account for App Center Client authentication.

Proxy connection options:

Option Description

Proxy Password

If Proxy User authorization is used, specify Proxy user password in this option.

Proxy Port

Specify the Proxy port here. You can learn Proxy Port in the same way as described above for the host.

Proxy Server

If you are using Proxy for connection to your network, specify the Proxy server address in this option. To learn your Proxy server address, open Control Panel->Internet Options->Connections->LAN settings.

Proxy User

If Proxy User authorization is used, specify Proxy user name (ID) in this option.

Advanced Settings

Option Description

Empty strings as NULL

To retrieve metadata, not all parameters according to MSDN can accept a null value. If NULL, the driver should return an error. But some 3rd-party tools pass NULL to the parameters. These options should be enabled for compatibility with such tools.

Allow NULL strings

String Types

Sets the string value types returned by the driver as Default, Ansi or Unicode.

  • Default - the driver defines the string types.
  • Ansi - all string types will be returned as SQL_CHAR, SQL_VARCHAR and SLQ_LONGVARCHAR.
  • Unicode - all string types will be returned as SQL_WCHAR, SQL_WVARCHAR and SLQ_WLONGVARCHAR.

The option value should be changed if any third-party tool supports only Ansi string types or Unicode ones.

RegionalNumberSettings

Enables using local regional settings when converting numbers to string.

RegionalDateTimeSettings

Enables using local regional settings when converting dates and times to string.

ConnectionTimeout

The time to wait while trying to establish a connection before terminating the attempt and generating an error.

QueryTimeout

The time to wait for a query execution result before terminating and generating an error.

SalesforceMC ODBC Connection String sample

DRIVER={Devart ODBC Driver for Salesforce Marketing Cloud};Authentication=UserandPassword;Server=https://webservice.s7.exacttarget.com/Service.asmx;User ID=00932000000ibZf;Password=******

DRIVER={Devart ODBC Driver for Salesforce Marketing Cloud};Authentication=AppCenterClient;AppClientID=8m6chyukyd26sv9858j5hdeq;AppClientSecret=6Jqz8dgxrMJZaPY5zjdfmB7N

© 2015-2018 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback