ETL Salesforce data to ClickHouse

Salesforce is a cloud-based platform that offers powerful CRM service and a complementary suite of enterprise applications focused on customer service, marketing automation, analytics, and app development.

From small businesses to huge corporations — Salesforce helps their 150,000+ clients grow by offering scalable solutions and managing infrastructure, code base, and security behind the scenes.

Renta collects data from Salesforce and safely transfers it to ClickHouse with no code required from your side.

Simple integration configuration

The integration configuration requires 4 steps:

  1. Select Salesforce from the list of available integrations
  2. Add your Salesforce account
  3. Choose objects for export
  4. Add your data warehouse

No code required, 4 clicks and you’re done!

Data structure of the Salesforce API

Renta supports standard methods of exporting statistics from an advertising account.

Below are some supported report types.


Represents an individual account, which is an organization or person involved with your business (such as customers, competitors, and partners).


Represents a prospect or lead.


Represents an opportunity, which is a sale or pending deal.


Represents a calendar. This can be a default user calendar, public calendar, resource calendar, or holiday calendar.


Represents and tracks a marketing campaign, such as a direct mail promotion, webinar, or trade show.


Represents a contact, which is a person associated with an account.


Represents an order associated with a contract or an account.


Represents a single event where the customer creates a payment. 


Represents a product that your org sells.


Represents a business activity such as making a phone call or other to-do items.


Represents a user in your organization.