Salesforce ADO.NET connection guide for Jitterbit App Builder

Overview

This guide describes the system requirements and instructions for connecting App Builder to a Salesforce ADO.NET data source. This connection makes use of an OAuth Security Provider, with the Authorization Code grant type.

System requirements

Database server

Salesforce account with ADO.NET

Client web browser

• Chrome: 84+

• Firefox: 73+

• Safari: 13.0.1+

• Edge: 84+

Connection instructions

The following step is a prerequisite and should be completed in the Salesforce app or sandbox environment.

Create a custom OAuth app in Salesforce

1. Log in to Salesforce.com or your Salesforce sandbox environment

2. From the home page, go to Platform Tools > Apps > App Manager

3. Click the New Connected App button

4. Enter a Name to display to users when they log in to grant permissions to your app, along with a contact Email address

5. Click Enable OAuth Settings

6. Enter a value in the Callback URL field. This should be the URL of your App Builder instance with a Security Provider appended.

   Note

   Case sensitivity is important, so the name for the security provider that we create next must match the case sensitivity on the Callback URL.

7. Selected OAuth Scopes should be set to the scope of permissions the application should request from the user.

   1. Set to "Full access (full)" and "Perform requests at any time (refresh_token,offline_acesss)"

   

8. Click on Manage Consumer Details to view the Client ID and Secret value. Take note of these values in a location that can be easily referenced when configuring from App Builder.

Create an OAuth security provider in App Builder

1. Setup a Security Provider in App Builder by navigating to the IDE > Security Providers

2. Click the + Data Source Authentication button

3. Provide the following details:

   • Name: Identifies the Security Provider and appears in the URL on occasion. Example: Salesforce

   • Type: OAuth

   • Authentication Type: OAuth

   • OAuth Grant: Authorization Code

   • OAuth Client Authentication: Basic

   • OAuth Resource Authentication: Bearer

   • Token Owner: User

   • Redirect on Challenge: True

   

4. Click + Endpoints and configure the following 3 records:

   • Authorization Endpoint: https://login.salesforce.com/services/oauth2/authorize

   • Token Endpoint: https://login.salesforce.com/services/oauth2/token

   • User Info Endpoint: https://login.salesforce.com/services/oauth2/userinfo

5. Click + Credential and create the following record:

   • Type: Client

   • User Name: Client ID from Salesforce

   • Password: Secret from Salesforce

6. Click + Claim and create the following 3 records for user provisioning:

   • Name: preferred_username

   • Name ID: preferred_username

   • E-mail Address: email

Create the Salesforce ADO.NET data source in App Builder

1. Go to the App Builder IDE and click Data Servers

2. Click the + Server button to add a new data source

3. Assign a Server Name. This name must match the Callback URL configured in Salesforce. Example: SalesForce

4. Select the Type as Salesforce ADO.NET

5. Expand the Security Settings and set the Security Provider to the one we created. Example: SalesForce

   

6. Lastly, if you are using a Salesforce sandbox environment, click the Advanced Settings button and configure the OAuth server URL

1. Expand Testing and click the Test Connection button to ensure the configuration is working as expected.

Resources

• https://cdn.cdata.com/help/RFH/ado/pg_oauthcustomappcreate.htm