Renta automatically imports data from Salesforce to the data warehouse. Currently the following databases are supported:
- Google BigQuery.
- Microsoft SQL Server.
- Azure SQL database.
Integration setup on the example of BigQueryIn this manual the example of Salesforce integration with Google BigQuery is presented. Text transcript is provided below. After a successful authentication in Renta you need to create an integration. To do that, click on the Add button, and after that you will see the list of all possible integrations. Choose Salesforce. Then you need to sign in using the account you need to get data from. You can do that in just a few clicks: Click on the Add button, after that the Salesforce authentication window will open. Enter your login and password. After that the account is available for selection. The third step is to select what objects you need to upload to BigQuery. Each element will be uploaded to a separate table. The list of all available elements as well as their contents can be accessed in the Salesforce Help section. As an example, we specify the following objects: