What is the Dynamics 365 Cloud Connector?
The Dynamics 365 Cloud Connector bridges the gap between PrecisionLender Opportunities and Relationships and their associated Opportunities and Accounts in Dynamics 365. The Connector enables lenders to create Dynamics 365 Opportunities, price them in PrecisionLender and see the details of that priced Opportunity reflected in the Dynamics 365 Opportunity, all without any additional login forms in the middle.
Clients with Relationship Awareness in PrecisionLender and corresponding Accounts in Dynamics 365 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 365 Account for each PrecisionLender Relationship. New PrecisionLender Opportunities created from Dynamics 365 will automatically associate themselves with the respective Relationship, if it appears in both PrecisionLender and Dynamics 365.
Note: The Dynamics CRM On-Prem Connector is a separate integration from the Dynamics 365 Cloud Connector. For more information on the Dynamics CRM Connector, see Dynamics Connector for PrecisionLender.
Overview Diagram
Installation and Authentication
The PrecisionLender Dynamics 365 Connector is installed within your Dynamics 365 instance as a Managed Solution. This solution creates the custom tables and columns that are later populated by the PrecisionLender Application.
The PrecisionLender Dynamics 365 Connector installation process requires an existing Dynamics 365 administrator to authorize the Managed Solution. Users are set up within Dynamics 365 using Active Directory. Dynamics 365 users must also have a corresponding username in PrecisionLender. Once the PrecisionLender solution is installed into Dynamics 365, 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 logged in username, your PrecisionLender Client ID, and the ApiKey. PrecisionLender validates the credentials sent and verifies that the logged in user has permissions to access the application.
Bidirectional data syncing
Data transfer triggers
- Saving an Opportunity in PrecisionLender triggers a data push to Dynamics 365 to update (or create) and populate all related objects, sub-objects, and fields
- Saving an Opportunity in Dynamics 365 triggers an update to the related PrecisionLender Opportunity's Name, Close Date, and Stage fields.
- Uploading Core Relationship data to PrecisionLender triggers a recalculation and data push to the related Dynamics Account custom fields.
Object mappings
|
Dynamics Object
|
Tables
|
PrecisionLender Columns
|
Syncing Direction
|
|---|---|---|---|
| Account |
All Relationship Financial Statement Fields |
Relationship | PL → CRM upon Core Relationship Data Upload to PL |
| Opportunity |
Name Close Date Stage |
Opportunity | CRM → PL upon CRM Opportunity Save |
| Opportunity |
Income Statement Fields |
Opportunity | PL → CRM upon Opportunity 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 365 Connector requires some configuration and setup by our support team to connect it to your Dynamics 365 instance. This is a very 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 365?
- Only Opportunities priced using the "Price in PrecisionLender" button within Dynamics 365 will be linked back to the corresponding Opportunity within PrecisionLender.
- We are currently evaluating options that would allow us to manually link an existing PrecisionLender Opportunity to an existing Dynamics 365 Opportunity.
How does a PrecisionLender Relationship become linked to an Account within Dynamics 365?
- 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 365 system contains this same identifier, then the PrecisionLender Dynamics 365 connector will perform the same hashing function within Dynamics 365 which will then allow the Connector to locate and link to the matching Relationship within PrecisionLender.
What is synced between PrecisionLender Opportunities and Dynamics 365 Opportunities?
- Prospective Opportunity data (new business you are trying to win)
What is synced between PrecisionLender Relationships and Dynamics 365 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.
Why are some updates made to PrecisionLender Opportunities not automatically reflected in Dynamics 365?
- Check to see if you have any Dynamics field validation rules on your Opportunity that may be preventing PrecisionLender from saving that Opportunity back in Dynamics 365.
- Check to make sure that your Dynamics 365 Opportunity stage names match your PrecisionLender Opportunity stage names exactly. The matching on these names are exact and case-sensitive.