Skip to end of metadata
Go to start of metadata

You can validate the definition of your data connection to ensure that the connection is correct and that the right data is imported or exported. 

Moment of validation

Validation can take place at the start of the import or export process, it is done automatically, but can also be performed earlier, while defining the connection.

Validation at the start of an import or export is done automatically. For an Excel connection, validation is obligated and is always performed. For a ServiceNow or SQL connection, validation is optional. It is activated by default, but can be deactivated at the connection settings. Validation during definition of the connection needs to be done manually.

When performed at the start of the import or export, a failing validation does not always abort the import or export, but it may result in an incomplete data import or export. So best way of working is already validating a connection and resolving any errors before while defining the connection.

Validation area

When validating at the start of the import or export, the complete connection and its underlying mappings are checked. When validating during definition of the connection, you can also choose to validate a single mapping instead of the complete connection.

Validating a connection is illustrated with an Excel connection, but works the same for ServiceNow and SQL connections.

Manually validating a connection

To manually validate the complete connection, do as follows:

  • In the connection view, select the connection, and then click .



To validate a single mapping in a connection, do as follows:

  • In the mapping diagram, click to open the canvas menu, and then click .


Next, validation is performed.

Validation results

If a manual or automatic validation has completed, the Messages window appears showing the results of the validation. If validation is successful, there are no errors and warnings, indicated in the window.

If validation is not successful, the number of warnings and/or errors is shown. Example:

Examples of validation warnings and errors in the Messages window


Additionally, the warnings and/or errors are indicated in the connection view and mapping diagrams (where applicable). Warnings are indicated with a , errors with a (see the figure below).

Pointing to the symbol will raise a tooltip with details about the warning or error. Resolve the problems and validate the connection again until there are no warnings and errors left.


Examples of validation warnings and errors in an Excel connection

Clearing validation results

If validation has resulted in warnings and/or errors, they will remain visible in the connection, even after you have resolved the issues. Clicking the  control on the border of the connection or in the canvas menu will hide the validation results again.

Clicking this control is also necessary if you want to perform a new validation.

Deactivating automatic validation before import or export

If you decide to deactivate the automatic valuation of a ServiceNow or SQL connection, make sure to have validated and resolved any errors before starting an import or export.

To deactivate automatic validation before import and/or export, follow these steps:

  1. In the connection view, select the connection, and then click  to open the connection properties window.

  2. Depending on which validation you want to deactivate, click the check mark next to Validate before import and/or Validate before export, and close the properties window.