Salesforce Source

Renta supports data export from Salesforce to following destinations:

  • Snowflake

  • Google BigQuery

  • Amazon S3

  • Clickhouse

  • SQL Server

  • Google Spreadsheets

Integration creating in data warehouse (DWH)

  1. Go to integrations catalog;

  2. Select Salesforce;

  3. Add a Salesforce account that has the necessary data;

  4. Choose the added Salesforce account;

  5. Specify the destination you want to import the data into;

  6. Go to the settings screen and set necessary configuration:

Salesforce objects

Salesforce consists of objects.

Basically Renta creates table that is equal to the Salesforce object, and the columns are Salesforce fields within one specific object.

Renta supports both default and custom fields types of objects.

Integration name

There is an auto generated name for your integration and here you can edit it as much as you like.

Both Cyrillic and Latin are permitted, but not more than 100 symbols.

The integration name is displayed on the Integration List page.

Table name

There is an auto generated name for your table and here you can edit it as much as you like.

Only Latin is permitted, numbers and “_” symbol.

Update time

The specific update time is available for Salesforce integration.

You can choose how often the data in tables will update per day: 15 minutes, 30 minutes, 45 minutes, 1 hour, 3 hours, 6 hours, 12 hours or once per day.

Note: we recommend using update time not less than “once per 6 hours”.

In that case you won’t face problems with Salesforce quotas and limits.

Integration creating in Google Spreadsheets

Take advantage of the free extension available in the Google Workspace Marketplace. In order to do it:

  1. Install the extension Renta Spreadsheets Add-on.

  2. Then go to Google Sheets and in the Tools tab select Renta

  3. Press the Run button.

After that a workspace with integration settings will open in the right sidebar. Detailed instructions for creating an integration are available at this link. Please note that all integrations created in Google Spreadsheets are also available for management in the web version of Renta.