|
Using Salesforce MC data access provider with UniDAC in Delphi |
|
|
|
Using Salesforce MC data access provider with UniDAC in Delphi |
|
This article provides a brief overview of the Salesforce MC cloud provider for UniDAC used to access Salesforce MC from Delphi and Lazarus. You will find the description of some useful features and how to get started quickly.
Main features of Salesforce MC cloud provider are:
The full list of Cloud provider features can be found on the UniDAC features page.
Both Professional and Standard Editions of UniDAC include the Salesforce MC cloud provider.
Salesforce MC cloud provider supports Salesforce MC data types and API.
Applications that use the Salesforce MC cloud provider require Devart ODBC Driver for Salesforce MC to be installed on the client computer. The driver is sold and distributed separately from UniDAC.
When an application was built without runtime packages (Link with runtime packages set to False in Project Options), you do not need to deploy any BPL files with it. For more information, see Deployment.
Note that UniDAC Trial requires deployment of additional BPL files regardless of Link with runtime packages.
To connect to Salesforce MC using Devart ODBC Driver and User/Password Authentication, you should configure the driver and set up a DSN. In the TUniConnection component, specify the following parameters:
To connect to Salesforce MC using Devart ODBC Driver and App Center Client Authentication, you should configure the driver and set up a DSN. In the TUniConnection component, specify the following parameters:
To connect to Salesforce MC using Devart ODBC Driver and Server to Server Authentication, you should configure the driver and set up a DSN. In the TUniConnection component, specify the following parameters:
Though UniDAC is components that provide a unified interface to work with various cloud services, it also lets you tune behaviour for each cloud individually. For thin setup of a certain cloud, UniDAC provides specific options. These options can be applied to such components as TUniConnection, TUniQuery, TUniTable, TUniStoredProc, TUniSQL, TUniScript via their SpecificOptions property. SpecificOptions is a sting list.
Below you will find the description of allowed options grouped by components.
| Option name | Description |
|---|---|
| AppClientID | Used to supply Application Client ID for App Center Client authentication. |
| AppClientSecret | Used to supply Application center client secret for App Center Client authentication. |
| AppSandbox | Allows using a production or sandbox account for App Center Client authentication. |
| Authentication |
Specifies the authentication type.
atUserAndPassword
Authentication with a user ID and a password. Specify your Username and Password.
AtAppCenterClient
Authentication as an App Center Client. Specify your AppClientID and AppClientSecret.
atServerToServer
Authentication using the Server to Server option. Specify your ClientID and ClientSecret.
The default option is
atUserAndPassword.
|
| CacheMetadata |
Allows caching and storing metadata in a temporary database. The option settings specify the frequency of resetting cached metadata ranging from 1 hour to 1 month.
False
The metadata caching is disabled.
Hour
Cached metadata is reset once per hour.
Day
Cached metadata is reset once a day (i.e. every 24 hours).
Month
Cached metadata is reset once per month.
True
Metadata caching won't reset until the driver is unloaded.
|
| ClientID | Used to supply application center client ID for Server to Server authentication. |
| ClientSecret | Used to supply application center client secret for Server to Server authentication. |
| ConnectionTimeout | The time to wait for a connection to open before raising an exception. |
| ExtensionObjects |
Allows creating custom objects called Data Extensions. If set to True, the data extension information will be read and processed in the same way as the predefined Salesforce Marketing Cloud objects are. Note: Reading data extension information might take additional time. |
| PartnerIDs | The list of specific partner accounts or business units for retrieve requests. |
| Subdomain | Is used to provide a subdomain (being a 28-character string starting with the letters "mc") for Server to Server authentication. |
| UseUnicode | Enables or disables Unicode support. Affects character data fetched from the server. When set to True, all character data is stored as WideStrings, and TStringField is replaced by TWideStringFiled. |
| UTCDates | Use the UTCDates option to return the datetime values from the data source as UTC values. |
| Option name | Description |
|---|---|
| ProxyPassword | If Proxy User authorization is used, specify Proxy user password in this option. |
| ProxyPort | Specify the Proxy port here. You can learn Proxy Port in the same way as described above for the host. |
| ProxyServer |
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. |
| ProxyUser | If Proxy User authorization is used, specify Proxy user name (ID) in this option. |
| Option name | Description |
|---|---|
| CommandTimeout | The time to wait for a statement to be executed. |
| Option name | Description |
|---|---|
| CommandTimeout | The time to wait for a statement to be executed. |
| ExtendedFieldsInfo | If True, an additional query is performed to get information about the returned fields and tables they belong to. The default value is False. |
| FetchAll |
If True, all records of a query are requested from database server when the dataset is being opened. If False, records are retrieved when a data-aware component or a program requests it. The default value is False. |
| FieldsAsString | If set to True, all non-BLOB fields are handled as strings. The default value is False. |
| UnknownAsString | If set to True, all Salesforce Marketing Cloud data types that are fetched as text and don't have the size limit, are mapped to TStringField with the default size 8192 bytes. If False (default value), such types are mapped to TMemoField. The TEXT data type is always mapped to TMemoField regardless of the value of this option. |
The TUniScript component has no Salesforce MC-specific options.
The TUniLoader component has no Salesforce MC-specific options.
The TUniDump component has no Salesforce MC-specific options.