Salesforce integration

This integration allows you to connect and pull data from Salesforce into your data notebooks.

In this guide:

1. Prerequisites
2. Connecting Shopify
3. Pulling data from Shopify 

Prerequisites

To connect Salesforce with your data notebooks you need to have the following:

• Salesforce Classic or Lightning Experience account
• Intersect Labs account and owner access level 

Connecting Salesforce

You can add the Shopify integration from the Dashboard  > Integrations > Add integrations > Add Salesforce.

One-click on the Salesforce box and the connection portal will open. These are the fields that are required for the connection to be successful:

• Integration name
• Username
• Password
• Security token

To access these parameters, you need to have a Salesforce account. Here are more details on how to obtain the required information:

1. The Integration name is your name for the integration in Intersect. Name it as you wish.
2. The Username and Password fields are the same ones you use to login into Salesforce.
3. The Security token is a case-sensitive alphanumeric key that is used in combination with a password to access Salesforce via API. To access this token follow these steps: Click on the User Menu in the top right corner in Salesforce > My Settings > Personal > Reset My Security Token. The system will send an email with your security token to the email address associated with your account in Salesforce. Use that token to connect Salesforce with Intersect.

You can then proceed to fill the connection portal in Intersect. If the connection is successful, you should be able to see your new Shopify integration on your Integrations page. 

Pull data from Salesforce

Open your data notebook where you want to pull data from your newly connected Salesforce account. Then, you can add a Salesforce step from Import data > CRM > Read from Salesforce (Add).

Once you select the integration, a new “Read from Salesforce” step will be added to your data notebook. To successfully pull data you will need to select the store that you've connected (in our case it’s called: My Salesforce integration). Then, in the code block below you can add an SQL query that will source the data in your data notebook.

If the step is successfully configured you will see an output with your sourced data.