Our Workforce Manage solution is based on Dynamics NAV and our Applicant Tracking solution is based on Dynamics 365 (CRM). Configuring these solutions to exchange data requires several configuration steps.
Dimensions
You can configure which dimensions will be integrated to Applicant Tracking and then from that list, choose which dimensions are mapped to the three predefined CRM dimensions: Program, Center, and Program Area.
To complete the dimensions setup:
- Open the Dimensions page.
- Select the Enable on CRM check box for the dimensions which are to be integrated to Applicant Tracking.
- For each of the three Dimensions you have chosen, please choose a value in the CRM Dimension column for the respective dimension. You can map only one dimension value to a particular CRM Dimension value.
When correctly configured, the dimensions will flow to CRM and populate the Program, Program Area, and Center on Applicant Tracking Job Positions.
Note: Sparkrock consultants will provide assistance if you would like to synchronize additional dimensions.
HR Representative
The relation between the HR Representative and the employee record is needed so that the appropriate HR Representative user can be linked when the position is created in CRM. This guides security and process in Applicant Tracking.
To link the HR Representatives to HR Employees:
- Open the HR Representative page.
- For each HR Representative line, choose an employee from the available list under the Employee No.
Web Services
Integration between the two applications depends on SOAP Web Services. You can run a report that automatically loads the required web services or go through a number of manual steps.
To automatically load the web services, you can run either the EWA Load Standard Page Setup or you can run Load CRM Web Services on the Integration Setup.
To manually add the web services needed:
- Open the Web Services page.
- Click on New.
- Add the following objects one by one to the web services list. Make sure that the Published check box is selected for each entry.
| Object Type | Object ID | Object Name | Service Name | Published |
| Page | 23032856 | HR Request Header CRM WS | HRRequestHeaderCRMWS | Yes |
| Page | 23032857 | HR Request Header CRM WS | HRRequestLineCRMWS | Yes |
| Page | 23032858 | Employees CRM WS | EmployeesCRMWS | Yes |
| Page | 23032859 | Employees Qual. CRM WS | EmployeesQualCRMWS | Yes |
| Page | 23032860 | HR Applicant CRM WS | HRApplicantCRMWS | Yes |
| Page | 23032863 | Qualification CRM WS | QualificationCRMWS | Yes |
Add-ins
To enable the integration, you will need to store and register certain dynamic-link libraries (DLLs). We recommend that these actions are performed by an experienced technical resource or by the Sparkrock IT Team.
Store the Add-ins
If you are doing the configuration yourself, please ask the Sparkrock IT Team to provide you with a package containing the DLLs.
Store the package on the service tier for the application in the following folder: \Program Files\Microsoft Dynamics NAV\90\Service\Add-ins\XRM
Note: The DLLs are the CRM SDK that can be downloaded from Microsoft.
Register the Add-ins
Once the DLLs are stored, they also need to be registered. The registration can take place automatically by running the EWA Load Standard Page Setup or Load CRM Web Services on the Integration Setup, or manually as per below.
- Open the Control Add-ins page.
- Click New to add the following two records.
| Add-in Name | Public Key Token | Category | Description |
| Microsoft.Xrm.Sdk | 31bf3856ad364e35 | DotNet Interoperability | Microsoft XRM SDK |
| Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy | 31bf3856ad364e35 | DotNet Interoperability | Microsoft XRM SDK Client OrganizationServiceProxy |
After the two new lines have been added to Control Add-ins, the NAV instance needs to be restarted.
Integration Setup
This section describes how to configure the connection between Applicant Tracking and Manage Workforce. This step can be done at any point during the configuration process.
To complete the integration setup, add information to the CRM Integration fast tab:
- Open the Integration Setup page and expand the CRM Integration fast tab.
The following table includes the information required for each field on the fast tab.
| Field | Description |
| CRM Service URL | The link to your Applicant Tracking solution. |
| CRM User Name | The user name to log in to your Applicant Tracking solution. The user name should be a service account in CRM with a System Administrator security role. |
| CRM Has Password |
This field is automatically checked if a password has been previously entered. |
| New CRM Password |
This is the field where you need to enter the password for the user specified in the CRM User Name. Once entered the password will be encrypted. |
| CRM Integration Enabled |
Toggles the integration on or off. Integration can be turned off if CRM is not being used. |
From the navigation pane of this page you can perform two additional actions:
- Run Load CRM Web Services. The system will create the web services and the add-ins needed for the integration.
- When all your data is configured, and the integration enabled, you are ready to synchronize the initial data between the two applications, you can run Sync CRM Integration.
Data Migration
The Sync CRM Integration report is used as an initial load of data. It runs through all records that are integrated and syncs with the CRM setup. The report can be run from the navigation pane on the Integration Setup.