Salesforce Connector for PrecisionLender

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

Data transfer triggers

Saving Opportunity in PrecisionLender triggers a data push to Salesforce to update (or create) and populate all related objects, sub-objects, and fields
Saving Opportunity in Salesforce triggers update to related PrecisionLender Opportunity fields Name, Close Date, and Stage.
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	SF → PL upon saving the Opportunity in Salesforce
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 packages include a connected app which will allow PrecisionLender to pass data into your Salesforce org.

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 have any Salesforce field validation rules on your Opportunity that might be preventing PrecisionLender from saving that Opportunity back in Salesforce

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

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.