User and Developer Guide

10.4.1
- 10.5
- 10.4.0
- 10.2.2
- 10.2 HotFix 1
- 10.2
- 10.1.1 HotFix 2
- 10.1.1 HotFix 1
- 10.1.1
- 10.1
- 10.0

Back Next

Data Quality Services for Excel Users Overview

You can use Data Quality for Microsoft Excel to add, remove, configure, and run data quality services.

Data quality developers create data quality services. You provide a data quality developer with the business logic that data quality services use. The developer creates data quality services and provides you with URLs or files for the services.

When you add a data quality service, you use the URL or file path provided by a developer to store a link to the service. When you run a data quality service, you select Microsoft Excel data to use as input for the data quality service and set the service output options.

Data Quality Services for Excel Users

Data Quality for Microsoft Excel Ribbon

The Data Quality for Microsoft Excel installer adds an Informatica menu item to Excel. When you select this menu item, the lnformatica ribbon appears.

The following table lists the ribbon commands and the actions you can perform with the commands:

Command	Action
Use	Run a data quality service.
Add	Add a data quality service.
Remove	Remove data quality services.
Settings	Define settings such as default WSDL directory, the number of Excel inputs to send in one batch, service run-time options. You can also import or export Data Quality for Microsoft Excel properties.
Review	Review the results of the last data quality service that you ran.
Help	View online help.

Rename Saved Search

Table of Contents

User and Developer Guide

User and Developer Guide

Data Quality Services for Excel Users Overview

Data Quality for Microsoft Excel Ribbon