Toll Free 1-877-506-2744
How can we help?

Salesforce Connector for PrecisionLender

Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF

What is the Salesforce Connector?

The Salesforce Connector bridges the gap between PrecisionLender Opportunities and Relationships and their associated Opportunities and Accounts in Salesforce. The Connector enables lenders to create Salesforce Opportunities, price them in PrecisionLender and see the details of that priced Opportunity reflected in the Salesforce Opportunity, all without any additional login forms in the middle. 

Clients with Relationship Awareness in PrecisionLender and corresponding Accounts in Salesforce will also see Strategic Financial Statement information, such as the Strategic Net Income or Percentile ranking of the Relationship in PrecisionLender, in the respective Salesforce Account for each PrecisionLender Relationship. New PrecisionLender Opportunities created from Salesforce will automatically associate themselves with the respective Relationship, if it appears in both PrecisionLender and Salesforce. 

Overview Diagram

Salesforce_Data_Flow.png

 

Data transfer triggers

  1. Saving Opportunity in PrecisionLender triggers a data push to Salesforce to update (or create) and populate all related objects, sub-objects, and fields
  2. Saving Opportunity in Salesforce triggers update to related PrecisionLender Opportunity fields Name, Close Date, and Stage.
  3. Uploading Core Relationship data to PrecisionLender triggers recalculation and data push to related Salesforce Account custom fields

Object mappings

Salesforce Object
Fields
PrecisionLender Object
Syncing Direction
Account
  • All Relationship Financial Statement Fields
Relationship PL → SF upon Core Relationship Data Upload to PL
Opportunity
  • Name
  • Close Date
  • Stage 
Opportunity Bidirectional between PL and SF
Opportunity
  • Income Statement Fields
Opportunity PL → SF upon save in PL
Scenario
  • Scenario Name
  • Income Statement Fields
Scenario PL → SF upon Opportunity save in PL
Loan Account
  • Product Name
  • Income Statement Fields 
Loan Account PL → SF upon Opportunity save in PL
Deposit Account
  • Product Name
  • Income Statement Fields
Deposit Account PL → SF upon Opportunity save in PL
Other Account
  • Product Name
  • Income Statement Fields
Other Account PL → SF upon Opportunity save in PL

 

Installation

Currently the PrecisionLender Salesforce Connector requires some configuration and setup by our support team to get it hooked up to your Salesforce org.  However, this is a fairly simple process and our team is ready to assist you with the setup.

 

Authentication 

Handling the connection authentication between PrecisionLender and Salesforce

The PrecisionLender Salesforce Connector is installed within your Salesforce org as a Connected App. This is a Salesforce Managed Package that creates the custom fields and objects that are later populated by the PrecisionLender Application.

The PrecisionLender Salesforce Connector installation process requires an existing Salesforce administrator to authorize the Connected App. Once the Connected App is authorized, the Force.com API handles the flow of data from PrecisionLender into Salesforce.

Authentication for pushing PrecisionLender data back into Salesforce is handled using the Web Server OAuth 2.0 Authentication Flow. This grants PrecisionLender a revocable token-based access to Salesforce without requiring us to have or store credentials. During installation, the Salesforce Administrator logs into Salesforce and grants the token, which we then store as part of the client settings in PrecisionLender. PrecisionLender only uses that provided OAuth token and OAuth authentication flow to communicate with Salesforce and never has the user credentials.

Here is a link to the Force.com API documentation section on our chosen method of authentication:

  • https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/intro_understanding_web_server_oauth_flow.htm

 

Authenticating Salesforce users into PrecisionLender

When a Salesforce user clicks the "Price in PrecisionLender" button on an Opportunity details page, the user is directed to PrecisionLender and authenticated using a payload containing a username, a unique client identifier, and an API Key for that client. If all three of these pieces of information match the corresponding values within PrecisionLender, the user is automatically authenticated and logged into the PrecisionLender application.

 

Frequently-Asked Questions

How does a PrecisionLender Opportunity become linked to an Opportunity within Salesforce?

Only Opportunities priced using the "Price in PrecisionLender" button within Salesforce will be linked back to the corresponding Opportunity within Salesforce.  Opportunities that were created within PrecisionLender will not be connected to Salesforce in any way.

We are currently evaluating options that would allow us to manually link an existing PrecisionLender Opportunity to an existing Salesforce Opportunity, but this functionality is not yet on our roadmap.

 

How does a PrecisionLender Relationship become linked to an Account within Salesforce?

As part of the Relationship Awareness functionality, your bank provides a periodic data feed to PrecisionLender containing a hashed "Relationship Identifier".  This is typically sourced from a core system, data warehouse, or other system and it is cryptographically hashed before being sent to PrecisionLender's servers.

If your Salesforce system contains this same identifier, the PrecisionLender Salesforce connector will perform the same hashing function within Salesforce to allow the Connector to locate and link to the matching Relationship within PrecisionLender

 

What is synced between PrecisionLender Relationships and Salesforce Accounts?

A summarized roll-up of the existing business for a given relationship that you are feeding to PrecisionLender as part of the Relationship Awareness process (existing business you already have on your books).

 

What is synced between PrecisionLender Opportunities and Salesforce Opportunities?

Prospective Opportunity data for each Relationship within PrecisionLender (new business you are trying to win).

 

Is Relationship syncing required in order to achieve Opportunity syncing?

Nope!  Opportunity syncing and Relationship syncing are two separate functions that sync different types of data.  

 

Troubleshooting

We are noticing that some updates made to PrecisionLender Opportunities are not being automatically reflected in Salesforce

  • Check to see if you don't have any Salesforce field validation rules on your Opportunity that might be preventing PrecisionLender from saving that Opportunity back in Salesforce
  • Check to make sure that your Salesforce Opportunity stage names match your PrecisionLender Opportunity stage names exactly.  The matching on these names are exact and case-sensitive.

 

Was this article helpful?
Have more questions?