2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

DBSync for Salesforce Report API integration is an easy to use integration solution. It is used to have the backup of reports and allows Integration with other DBSync supported applications - like CRM and ERP solutions etc.

DBSync with an With automatic online update, DBSync enables its customers to enjoy all the product updates and features with every new release.

...

  • A license for the DBSync Salesforce Report API connector. That is, a username and password to connect to the DBSync iPaaS platform, and the . And, a user must add Salesforce Report API connector added to his/her account.
  • A valid username and password to connect to Salesforce Report API.

...

  • Make sure the number of records in any particular report is less than 2000 - as Salesforce Report API returns only the first 2000 records.
  • If there are more than 2000 records then, it will only fetch only the first 2000 records.
  • It supports only Tabular reports.

Connector Configurations

A Salesforce Report API connector instance represents a single Salesforce account, including login credentials. If a user wishes to connect to multiple instances of either sandbox/production then, he/she needs to s/he must create a separate connection for each of the instancesinstance.

The parameters required to opening the open a connection to a Salesforce Report API user instance are:

Property

Description

Required

Username

The username to connect to Salesforce Instance.

yesYes

Password

The password to connect to Salesforce Instance.

yesYes

After a connector is created within a project, set up the connector within the process, . DBSync can then map to, and from, virtually any system using the Salesforce Report API connector to retrieve data from, or send data to, databases. 

Frequently Asked Questions

...

A: DBSync is available free for 14 days trial after going through the Signup process.

Q: Is this connector available with on, On-demand or onOn-premise Version, Versions?

A: This profile is available with both on-demand and on-premise Versionthe Versions.

Q: What are the type of Salesforce reports supported by DBSync?

A: Only   You can only sync Tabular reports of Salesforce you can sync with your databases, Google Sheets and many more.

Q: How many records can we can fetch?

A: Only the first 2,000 records we can fetch be fetched at the time of Integration.

...