User and Developer Guide

User and Developer Guide

Deploying Data Quality for Excel in an Organization

Deploying Data Quality for Excel in an Organization

To simplify the task of managing data quality services for organization users, you can export Data Quality for Excel settings to an XML file that users can import. You can also store WSDL files in a network location.
After you install and configure Data Quality for Excel, you can export the plug-in settings to an XML file. You send this file to Excel users in the organization. To import the settings, Excel users open the
Settings
window in Data Quality for Excel and use the
Import Settings
button.
You can save data quality services as WSDL files. You can store those files in a network directory accessible by Excel users, and you can update the files in this directory as needed. You can send the WDSL directory location to Excel users, or you can send Excel users an XML settings file that contains the WSDL directory location.
When you update WSDL files in a network location, you must tell Excel users. To update the data quality services from the network location, Excel users open the
Settings
window in Data Quality for Excel and use the
Add
button. The plug-in updates the services using the files in the WSDL directory specified in the Settings window. You