Setting up the Salesforce → Google BigQuery pipeline

About

This integration allows replicating of Salesforce data to Google BigQuery. Salesforce offers more than 40 APIs for different Salesforce products. This connector is able to access only Salesforce Platform resources.

The Salesforce connector supports reading both Standard Objects and Custom Objects from Salesforce. Each object is read as a separate stream. See a list of all Salesforce Standard Objects here.

 

Prerequisites

  • Salesforce Account with Enterprise access or API quota purchased
  • Dedicated Salesforce user (optional)
  • Salesforce OAuth credentials

 

Supported sync modes​

The Salesforce source connector supports the following sync modes:

  • Full Refresh - Overwrite
  • Incremental Sync - Append

 

Step-by-step instruction

To set up Salesforce → BigQuery pipeline, you need to follow the steps below:

1. On the OWOX BI main page, click the 'New' button and choose 'Pipeline':

_super_new-01.png

2. As a service provider, select 'Salesforce':

_super_new-02-salesforce1.png

3. Choose pipeline 'Salesforce → Google BigQuery':

_super_new-02-salesforce2.png

And click the 'Create & Setup' button:

_super_new-02-salesforce3.png

4. Pipeline successfully created. And now you can schedule a call with the manager and provide him/her with the required information. 

_super_new-02-salesforce4.png

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.