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

Dynamics CRM Connector for PrecisionLender

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

What is the Dynamics CRM Connector?

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

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

Overview Diagram

Dynamics_Overview.png

 

Authentication

The PrecisionLender Dynamics Connector is installed within your On-Premise CRM Dynamics as a Managed Package. This package creates the custom fields and objects that are later populated by the PrecisionLender Application.
The PrecisionLender Dynamics Connector installation process requires an existing Dynamics administrator to authorize the Managed Package. Users are setup within Dynamics using Active Directory. Dynamics users must also have a corresponding username in PrecisionLender. Once the PrecisionLender is installed into Dynamics, users can be authenticated into PrecisionLender when they click on the Price In PrecisionLender button. Once pushed, a request is sent over SSL containing the username, the clientid, and the apikey for that client. PrecisionLender validates the credentials sent, and verifies that the logged in user has permissions to access the application.

Bidirectional data syncing

Data transfer triggers

  1. Saving Opportunity in PrecisionLender triggers a data push to Dynamics CRM to update (or create) and populate all related objects, sub-objects, and fields
  2. Saving Opportunity in Dynamics CRM 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 Dynamics CRM Account custom fields

Object mappings

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

Installation

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

 

Frequently-Asked Questions

How does a PrecisionLender Opportunity become linked to an Opportunity within Dynamics CRM?

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

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

 

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

The PrecisionLender Relationship Awareness module is a requirement for this to happen.

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

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

 

What is synced between PrecisionLender Opportunities and Dynamics CRM Opportunities?

Prospective Opportunity data (new business you are trying to win)

 

What is synced between PrecisionLender Relationships and Dynamics CRM 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).

 

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.  

 

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

  • Check to see if you don't have any Dynamics CRM field validation rules on your Opportunity that might be preventing PrecisionLender from saving that Opportunity back in Dynamics CRM.
  • Check to make sure that your Dynamics CRM 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?