2022
DBSync's Salesforce connector is a highly customizable connector. It has the ability to connect to any native Salesforce application. Furthermore, it also has the ability to connect with additional applications - like CRM software's, e-Commerce platforms and various other systems. As a Salesforce user, you can use this connector to integrate Salesforce with other On-demand, On-premise or, SaaS-based applications - such as MSCRM, NetSuite, SkuVault, and databases.
The Salesforce connector, when connected to Salesforce application, has the ability to retrieve both standard and custom objects through Trigger/Rule section of DBSync iPaaS. Integrating with Salesforce consists of web service calls using an XML request/response made over an HTTPS connection.
Prerequisites
To establish a connection to Salesforce application via DBSync's Salesforce connector, a user must:
This setup security can be done in one of the following ways in Salesforce:
A Salesforce connection represents a single Salesforce organization, including login credentials. If a user wishes to connect to multiple instances of the either sandbox/production then, s/he must create a separate connection for each and configure the parameters accordingly. Salesforce connector supports OAUTH authentication.The table below represents parameters required for opening the connection to Salesforce user instance.
Property | Description | Required |
---|---|---|
UserName | The username to log into Salesforce account. | Yes |
Password | The password to login to Salesforce account. | Yes |
End-point | Yes | |
Sid | Session ID. | Optional |
Transport.compression | For compression. | Optional |
Proxy Host | If you use a proxy server then put <<proxy ip or host>>. | Optional |
Proxy Port | If you use a proxy server then put <<proxy port>>. | Optional |
Proxy Username | If you use a proxy server then put <<proxy username>>. | Optional |
Proxy Password | If you use a proxy server then put <<proxy password>>. | Optional |
Accept Gzip | As Applicable. | Optional |
Send Gzip | As Applicable. | Optional |
After a connector is created within a project, set up the connector within the project. DBSync can then map to, and from, the systems that are supported by our standard connector list. It can use Salesforce connector to retrieve data from, or send data to, Salesforce application. Click on the following link Connectors List to learn all about connectors DBSync supports.
The Salesforce connector makes it easy to work with Salesforce web service by:
Supported Versions
The DBSync supports almost all major versions of Salesforce:
Frequently Asked Questions
Q: Can I get a trial of DBSync?
A: DBSync is available free for 15 days trial after going through Signup process.
Q: Can this connector be used for bi-Directional sync?
A: Yes. Furthermore, if you so choose, you can also make it uni-directional.
Q: Is this connector available with, On-demand or On-premise, Versions?
A: Yes. This profile is available with both Versions.
Q: How Frequently can we perform Sync?
A: Sync can be performed every 5 minutes.
Q: What are the objects in Salesforce that I can Sync my database with?
A: You can sync almost all objects of Salesforce with your database using DBSync.
Q: Can I also integrate Salesforce custom objects with the database?
A: Yes, DBSync is a completely flexible solution and also supports custom objects of Salesforce.
Q: Can data migration be done Using DBSync and are there any limitations?
A: Data Migration can be done using DBSync and there are no limitations.
Useful hint