Step 5: Configure Mappings
In order to create, update, and remove records from the internal.password_reset table, you must create mappings. More information about mappings can be found here.
Navigate to Output > Mappings to begin. Because your source data is unique to your organization, we will provide guidelines on how these mappings should be set up, but the particular details will be unique to your situation.
Note
Although each of the mappings detailed below specify a Name property, you are free to name your mappings whatever you want. Renaming them is helpful in case you have more than one mapping of the same type for different types of users. For example, instead of "internal_password_reset_create", you may have "employees_internal_password_reset_create" and "contractors_internal_password_reset_create".
Create Records
This mapping will insert new records into the internal.password_reset table.
Click Add to create a new mapping. In the Add Mapping window, provide the following details and click Save.
System: internal
Target: password_reset
Function: password_reset_create
Name: internal_password_reset_create
In the Table/function dropdown, select the Create filter that you made in Step 3. Next, drag fields from the Items pane onto fields in the Attribute mapping pane. Be aware of the following points:
ExternalID should always be the unique identifier used in your source system. This is what users will enter to look up their account.
Profile should be the name of the password reset profile that you created in Step 4.
The label fields (e.g., MailAddressLabel1, SmsPhoneNumberLabel1) should be set to a value that tells the end user what the associated contact detail is. For example, if you put work email addresses into MailAddress1, then MailAddressLabel1 should be something like "Work Email".
Update Records
This mapping will update existing records in the internal.password_reset table.
Click Add to create a new mapping. In the Add Mapping window, provide the following details and click Save.
System: internal
Target: password_reset
Function: password_reset_update
Name: internal_password_reset_update
In the Table/function dropdown, select the Update filter that you made in Step 3. Next, drag fields from the Items pane onto fields in the Attribute mapping pane. Be aware of the following points:
ID must be mapped to a field from the filter that returns the user's existing internal.password_reset.ID field. This is how NIM targets their existing record for the update operation.
You are free to set any other fields, but we recommend only updating relevant contact details, such as email addresses and phone numbers.
Delete Records
This mapping will remove records from the internal.password_reset table that do not relate back to a record in the source system.
Click Add to create a new mapping. In the Add Mapping window, provide the following details and click Save.
System: internal
Target: password_reset
Function: password_reset_delete
Name: internal_password_reset_delete
In the Table/function dropdown, select the Delete filter that you made in Step 3. Next, drag the ID field from the Items pane onto the matching field in the the Attribute mapping pane. This is the only field that should be mapped here.
Next, add the mappings to jobs.