Database Reference
In-Depth Information
providers: DataMarket providers from the Windows Azure Marketplace, and Direct
Online third party providers. DataMarket providers require that you have a Windows
Azure Marketplace Account ID and subscription to the data set you wish to use. The
Direct Online provider option allows you to point to other third party web services that
support the DQS provider interface.
Using DQS with SSIS
SQL Server 2014 comes with the DQS Cleansing transform for SSIS. This section de-
scribes how to configure and use this transform as part of your SSIS data flow. This
section also contains information on a few open source extensions for DQS, which are
available on CodePlex.
DQS Cleansing Transform
The DQS Cleansing transform is included with SSIS 2014 and can be found in the Data
Flow toolbox (shown in
Figure 5-7
). It will appear under the Other Transforms section
of the toolbox by default.
Figure 5-7
.
The DQS Cleansing transform
After adding the DQS Cleansing transform to your data flow, you can double click
the component to bring up its editor UI. The first thing you need to set in the DQS
Cleansing Transformation Editor is the Data Quality Connection Manager (as shown in
Search WWH ::
Custom Search