Stack Overflow
Stack Overflow

Questions tagged [data-quality-services]

Data Quality Services is a feature first deployed with SQL Server code-named "Denali" for automating data cleansing tasks

From Microsoft's website on DQS:

SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product. DQS enables you to build a knowledge base and use it to perform a variety of critical data quality tasks, including correction, enrichment, standardization, and de-duplication of your data. DQS enables you to perform data cleansing by using cloud-based reference data services provided by reference data providers. DQS also provides you with profiling that is integrated into its data-quality tasks, enabling you to analyze the integrity of your data.

39 questions
3
votes
1 answer

Achieving MasterData deduplication on Azure

I am looking at achieving Master Data deduplication based on match percentages in AzureDB...was looking at something equivalent to Master Data Services/ DQS (Data Quality Services) in SQL…
raghu
  • 339
  • 2
  • 12
2
votes
1 answer

Problems with Data Quality Services Cleansing Activity

I am working my way through MOC 20767c; the last section of modules in preparation for the MCSE Data Management and Analysis certification. I'm doing all the labs and demonstrations; and, I don't understand the reason DQS's behavior. For any of you…
DaddySQL
  • 21
  • 2
2
votes
0 answers

Data quality services connection error

I follow this tutorial https://msdn.microsoft.com/en-us/library/jj819740(v=sql.120).aspx for learning SSDT now when i install first SSDT this setupd "SSDTBI_x86_ENU" then when i open visual studio and perform all setup but i stuck on task 7 i try…
user progam
  • 39
  • 9
2
votes
0 answers

dqs - performance: how many rows in a project can you handle?

This question is strictly DQS-performance related. The ‘customers’ table I need to clean has 40,000,000 rows… I created a matching policy using a subset (no issues there, I just used a top 10,000). Now when I want to do a data quality project… I…
Chicago1988
  • 970
  • 3
  • 14
  • 35
2
votes
1 answer

DQS - Appy ends with rule

I am working one project which is performing data cleansing task ,for which I am using DQS (SQL Server instance) for data cleansing and transformation. I have once excel file as Input. Address ------- 1201 Elm St Ste 4400 140 N Wright St ABC…
Mudassir
  • 187
  • 1
  • 9
2
votes
1 answer

data cleansing icon not in toolbar

I installed SQL Server 2012 - Enterprise Edition with Data Quality Services. Now, I want to use data quality services, data cleansing task from a package in Integration services. The problem is I can't find the task in the toolbar. Do I have to…
Corovei Andrei
  • 1,646
  • 6
  • 28
  • 42
2
votes
1 answer

Matching values NOT in domain values of DQS SQL Server 2012

I am using SQL Server 2012 Data Quality Services. I would like to consider any value that does not exist under domain values as Invalid. For example, if I have the values of 'abc', 'def' listed as correct in my domain values tab under domain…
M_devera
  • 95
  • 1
  • 9
1
vote
1 answer

Does Microsoft Sql Server 2012 Data Quality Services support Oracle?

Does anyone know if Data Quality Services in Sql Server 2012 can be used against Oracle databases to improve their quality? I've had a look around the Sql Server site and can't determine if it can or not. Thanks, Steve.
stevie_c
  • 990
  • 1
  • 8
  • 15
1
vote
2 answers

How do I create a new Data Quality Services project on Denali?

After having a couple of issues getting DQS installed, it appears to be installed, and I can now run the client up; however, after I've chosen to connect to '(LOCAL)', which brings back the dashboard for it, but it is unclear how to create a new…
Rowland Shaw
  • 37,700
  • 14
  • 97
  • 166
1
vote
1 answer

while runing DQSinstaller.exe it fails with following description why?

I have installed sql server 2017 and SSMS 2017 but when i run dqsintaller.exe it fails with errors which are as follows Please help me resolve issue as i am newbie and still learning and working out how things works around [16/03/2020 4:38:38…
ETL - BI
  • 59
  • 9
1
vote
2 answers

Data Quality Services in Azure

Do you know anything about Data Quality Services? When it will be introduced in Microsoft Azure? Or maybe there is some services with same functions and possibilities?
Karol
  • 39
  • 1
  • 6
1
vote
1 answer

Searching the Suppliers.xls file - Data quality Services tutorial

I am trying to find the Suppliers.xls so I can finish this tutorial: https://learn.microsoft.com/en-us/sql/tutorials/task-3-importing-domain-values-from-an-excel-file?view=sql-server-2014 I've searched everywhere and I couldn't find it so I thought…
Jo Olive
  • 57
  • 6
1
vote
0 answers

How to fix Failed installation Data Quality Server

I want to install Data Quality Server In existing Instance SQL Server. After entered Master key I'm getting error like in below log messages My OS Windows 2012 R2 Standard and SQL Server 2012 [8/12/2019 11:58:39 PM] Executing action: Create data…
MKI Developer
  • 11
  • 1
1
vote
2 answers

DQS - Regex to detect invalid country names

I'm creating a domain rule to avoid values in my country domain that won't correspond to country long name/two-letter code/Three-letter code/Numeric code and native title. Could you please help me create a rule to capture native characters like…
Juan David
  • 2,676
  • 4
  • 32
  • 42
1
vote
1 answer

Error SQL Server Data Tools for Visual Studio - DQS - System.NotImplementedException

When I create a Connection to DQS in an SSIS Project I get System.NotImplementedException error after the build. I am using Visual Studio 2017 Running SQL Server Data Tools for Visual Studio 2017 This is the error I get: Severity Code …
Mgcobo Gwampi
  • 11
  • 1
1
2 3