Create a Connection String

 

Connection strings are what connect your backend system to Salesforce through Overcast.

You will create two connection strings, one for connecting to your Salesforce instance and the other for your backend system.

 

1. Select Connection Strings tab (1) and select the New button (2).



 

2. Create a new Connection String for your Salesforce instance.

  1. Enter a name for your connection string in Connection String Name. 

  2. Select "Salesforce Job" for Connection Type to connect to your Salesforce instance. 

  3. Enter your Connection String. We recommend using a dedicated System user.

  4. Enter the Sensitive Part.  This will be the password of your System user from step 3. Once saved, the system will hide your password in a series of characters so that is it not visible to other users with access to Connection String records. Description and Named Credential are optional fields.  

  5. Select Save.



If you are connecting through Secure Agent, click here.

 

3. On the connection string record, select the Check button to ensure the connection can be established successfully.


 

A green checked circle will appear once a successful connection is made.
 

If you modify a connection string after running the check, you will need to re-run the check; otherwise, the status may display an previous value.

 

 

Note: If you did not append your Security Token to the Password in Sensitive Part field, you may receive the below error message:
 

To correct this error, navigate to your Settings > My Personal Information > Reset My Security Token and select Reset Security Token. Once you receive an email, append the security token to your password.


 

4. Repeat Steps 1-3 above to set up a connection string for your backend system (i.e. SAP, Oracle, etc.). The information required for each type of Connection String differs between the backend systems. Please see additional documentation on our Help website - Application Help - Connection Strings.

Note: Ensure that the owner of these records is an active user.
 

Connection String via Secure Agent
 

Skip this step when you use a VPN connection between Overcast server and your company network.

Assign the secure agent(s) to a connection string.


1. Go to the Connection Strings tab and select the connection string name that you created for your backend system.


 

2. Scroll down to Secure Agent Links and select New Secure Agent Link.


 

3. Make sure the correct Connection String is displayed (1). Select the Secure Agent that you previously registered (2). Click Save (3).


 

4. You will be navigated to the Secure Agent record page. Go back to the connection string page of your backend system through the Connection Strings tab.


 

5. Scroll down to Secure Agent Links. You should see the Secure Agent is now linked to your Connection String, as indicated by the green icon.


 

6. After assigning the Secure Agent to a connection string, select Check to make sure the connection can be established successfully.


 

7. The Status field under System Information should show a green check icon  if your connection was established through Secure Agent successfully.  If the connection fails, the red "X" icon will appear . You can then look into your logs to see why it failed.