Salesforce Connection Manager
PreviousNext

SSIS Salesforce Connection Manager can be used with Salesforce Source, Salesforce Destination, Salesforce API Task, JSON Source and XML Source to read/write Salesforce.com data or execute various actions via API calls.

Download SSIS PowerPack

Content

Video Tutorial

Coming soon...

Properties

Property Name Description
ServiceUrl
UseClientCertificate UseClientCertificate
ClientCertificateStorageType CertificateStorageType

Available Options

Option Description
NotSet <Not set>
LocalMachine Stored in LocalMachine Storage Area
CurrentUser Stored in User Storage Area
PfxFile Disk File - PFX (PKCS12) format
ClientCertificateStoreName CertificateStoreName

Available Options

Option Description
NotSet <Not set>
AddressBook AddressBook
AuthRoot AuthRoot
CertificateAuthority CertificateAuthority
Disallowed Disallowed
My My
Root Root
TrustedPeople TrustedPeople
TrustedPublisher TrustedPublisher
ClientCertificateThumbPrint CertificateThumbprint
ClientCertificatePath CertificatePath
ClientCertificatePassword
AllOrNone If true, any failed records in a call cause all changes for the call to be rolled back. Record changes aren't committed unless all records are processed successfully. The default is false. Some records can be processed successfully while others are marked as failed in the call results.
AllowFieldTruncation If true, truncate field values that are too long, which is the behavior in API versions 14.0 and earlier.
Default is false: no change in behavior. If a string or textarea value is too large, the operation fails and the fault code STRING_TOO_LONG is returned.

The following list shows the field types affected by truncation and this header:

anyType, if it represents one of the other datatypes in this list
email
encryptedstring
multipicklist
phone
picklist
string
textarea
AllowSaveOnDuplicates Set to true to save the duplicate record. Set to false to prevent the duplicate record from being saved.
Timeout Request timeout in seconds
UserName
Password
SecurityToken
ProxyType Proxy server type

Available Options

Option Description
None None
Socks4 Socks4
Socks4a Socks4a
Socks5 Socks5
HttpConnect HttpConnect
ProxyHost Proxy Server or IP (e.g. MyProxy01 --or-- 192.168.0.1 --or-- proxy1.mydomain.com)
ProxyPort Proxy server port number
ProxyAuthMode Proxy authentication mode

Available Options

Option Description
Basic Basic
Ntlm Ntlm
Digest Digest
ProxyDomain Domain to submit to the proxy server for authentication.
ConnectionString
RetainSameConnection
UseProxy Enable custom proxy settings (If this is not set then system default proxy will be used. To disable proxy totally uncheck this option and check DoNotUseDefaultProxy option if available)
ProxyUrl Web URL of Proxy server (including port  if necessary). [e.g. http://myproxyserver:8080/]
DoNotUseDefaultProxy Do not use system default proxy (This setting is ignored if UseProxy=true)
ProxyUseCreds Enable passing userid and password to proxy server
ProxyPassword Proxy password
ProxyUserName Proxy username

Screenshots

SSIS Salesforce Connection Manager UI (Used with Salesforce Source, Salesforce Destination, Salesforce API Task, JSON Source and XML Source)
SSIS Salesforce Connection Manager UI (Used with Salesforce Source, Salesforce Destination, Salesforce API Task, JSON Source and XML Source)

SSIS Salesforce Source - Table mode (get data from object)
SSIS Salesforce Source - Table mode (get data from Salesforce.com object)

SSIS Salesforce Destination - Upsert Example (Bulk Insert or Update)
SSIS Salesforce Destination - Upsert Example (Bulk Insert or Update)

SSIS Salesforce API Task - Call REST API Example (i.e JSON API)
SSIS Salesforce API Task - Call REST API Example (i.e JSON API)

SSIS JSON Source - Call Salesforce REST API Example
SSIS JSON Source - Call Salesforce REST API Example

See Also

References


Copyrights reserved. ZappySys LLC.