Salesforce Connector Setup
Salesforce Connector Setup
The Salesforce connector allows you to integrate Salesforce into your data flow by pushing or pulling data from Salesforce. Follow the steps below to connect ArcESB to Salesforce.
Establish a Connection
To allow ArcESB to use data from Salesforce, you must first establish a connection using OAuth login. You can create the connection from either the connector configuration pane or the Connections tab of the Settings page.
- The login process is only required the first time the connection is created.
- Connections to Salesforce can be re-used across multiple Salesforce connectors.
From the Connector Configuration Pane
Drag the Salesforce connector into an ArcESB flow and give it a name.
In the Connector Configuration pane, click + Create next to the Connection drop-down list.
The Add Connection modal appears. Enter a name for the connection.
A new window opens for logging into Salesforce. Enter your credentials and log in.
If prompted, grant permissions for ArcESB to connect to Salesforce. You will then return to ArcESB.
Click Add Connection to finalize the connection.
In the Connection drop-down list of the connector configuration pane, select the newly-created connection.
Click Save Changes.
From the Settings Page
Open the Settings page, and then click the Connections tab.
Click Add to open the Connection Type modal.
Click Salesforce, then click Next.
Continue from step 3 above for Connection Configuration Pane.
Select an Action
After establishing a connection to Salesforce, you must choose the action that the Salesforce connector will perform. The table below outlines each action and where it belongs in an ArcESB flow.
|Action||Description||Position in Flow|
|Upsert||Inserts or updates Salesforce data. By default, if a record already exists in Salesforce, an update is performed on the existing data in Salesforce using the values provided from the input.||End|
|Lookup||Retrieves a value from Salesforce and inserts that value into an already-existing Arc message in the flow.
The Lookup Query determines what value the connector will retrieve from Salesforce. It should be formatted as a SQL query against the Salesforce tables.
|Select||Retrieves data from Salesforce and brings it into ArcESB.
You can use the Filter panel to add filters to the Select. These filters function similarly to WHERE clauses in SQL.
|Execute Stored Procedures||Treats data coming into the connector as input for a stored procedure, and then passes the result down the flow.
You can click the Show Sample Data button to provide sample inputs to the selected Stored Procedure and preview the results.
|Upload||Uploads documents from the flow into Salesforce.||End|
|Download||Downloads documents from Salesforce and passes them down the flow.||Beginning|