To add a data quality service, the service must be a valid Informatica web service that Data Quality for Excel can run. Contact a developer to verify that Data Quality for Excel can run the service.
A data quality service that performs address validation does not write output data.
When you run an address validation service, the server machine loads address validation reference data. Loading this reference data can take a lengthy amount of time because the a reference data set can often be several gigabytes in size.
If the Data Quality for Microsoft Excel plug-in does not receive a response from a data quality service in a timely manner, the plug-in processes the next batch of records without writing output data. If the service does not respond before all record batches are sent, Data Quality for Microsoft Excel does not write any output data.
If an address validation service does not write output data for one or more records, run the service again for those records.
I cannot run a data quality service.
You cannot run a data quality service if any of the following conditions are true:
The computer you are using does not have access to the application service where the data quality service is deployed.
You do not populate a service input field.
You populate an input or output field with a range is not available in an Excel worksheet.
The data quality service has multiple input or output fields and you populate the fields with ranges that contain a different number of cells.