1. Documentation
2. 10.1 (Latest)10.09.109.99.89.79.69.59.49.39.29.19.08.28.18.07.6
3. Studio
4. How to
5. Cloud connectivity
6. Using Salesforce

Using the Salesforce Connector

The Salesforce Connector allows you to connect to Salesforce directly from RapidMiner Studio. It supports all CRUD operations (Create,Read,Update, and删除). This document will walk you through how to:

• Connect to Salesforce
• Read from Salesforce
• Write to Salesforce
• Reset the security token

Connect to Salesforce

Before you can use the Salesforce connector, you have to configure a new Salesforce connection. You will need the connection details of your account (username, password, security token, URL) to set up the connection.

1. Open theManage Connectiondialog viaTools > Manage Connections.

2. Click onAdd Connectionin the lower left:

   

3. Give the new connection a name and forConnection Type选择Salesforce Connection.

4. Fill in the connection details of your Salesforce configuration:

   

   The username and password are the same credentials you use for the Salesforce website. Your Salesforce account includes a security token that RapidMiner needs to make a connection. You can get the security token from your Salesforce registration mail. If you do not have the registration email, you canresetthe security token.

   While not required, we recommend testing your new Salesforce connection by clicking theTestbutton at the bottom of theManage Connectionswindow:

5. Click保存所有更改to save the connection and close theManage Connectionswindow.

You're ready to start using the Salesforce operators!

Read from Salesforce

TheRead Salesforceoperator allows you to read data from Salesforce. Let us start with reading some demo data:

1. Open a new processin RapidMiner Studio. Drag theRead Salesforceoperator into theProcessview, and connect its output port to the result port of the process:

   

2. Select your Salesforce connection from theconnectiondrop down menu in theParametersview.

3. Click on theBuild Salesforce Querybutton to open the query editor. This dialog allows you to create a Salesforce SOQL query.Simplemode (tab at the left of the window) provides you with an interface to build your query;Advancedmode allows you to write your own query.

   

4. Runthe process! In the Result Perspective, you should see the result of your query:

   

Write to Salesforce

Writing an example set to Salesforce is straightforward: Load the example set and pass it to theWrite Salesforceoperator. The following example illustrates how to write an excel sheet with demo data to Salesforce.

1. Create an Excel sheet with the following data:

   

2. Open a new processin RapidMiner Studio.

3. Read the created Excel sheet by using theRead Exceloperator. Add aWrite Salesforceoperator to the process and connect the operators accordingly. Select your configured Salesforce connection and configure the properties as shown on the screen shot:

   

4. Runthe process! In theResultsperspective, you should see the written entity:

   

Reset the security token

You can reset your Salesforce security token from the Salesforce website. This is a useful feature if you've lost your existing token or you want to disconnect from all applications using the token.

1. Make sure you are logged in to the Salesforce website.

2. Click on your account name and selectSettings:

   

3. Open thePersonalgroup and click onReset My Security Token:

   

4. Finally, click onReset Security Tokento get a new token via email.

Note that by resetting your token, applications will no longer be able to connect to your account until you re-enter the new security token.