You can apply data quality policy rules on import of data into D365 FO with a Connectivity studio message. On the message header, define which types of rules are applied on data import with the message.

For more information, refer to Apply data quality rules on data import with Connectivity studio.


Standard procedure

1. Click Connectivity studio Integration Design.
2. On the Messages tab, in the list, click the link of the desired message.
3. Click the Header tab.
4. Expand the Data quality studio section.
5. On data import, you can apply action rules to set field values in a target field in D365 FO.
  Select Yes in the Action rules field.
6. On data import, you can apply validation rules to check if the data is in line with the defined standards.
  Select Yes in the Validation rules field.
7. On data import, you can apply duplicate check rules to check if the data doesn't already exist in the table.
  Select Yes in the Check duplicates field.
8. Close the page.

Notes

The Data quality studio integration rule options on the message header are only available if:

  • Data quality studio is installed on the same D365 FO environment as Connectivity studio.
  • On the Connectivity studio parameters, on the Data quality studio tab, the Enable data quality integration field is set to Yes.

Provide feedback