DQS missing from Master Data Services Excel Add-in

Question

Hi,

I installed SQL Server 2012 (RTM) on my local machine and have configured both MDS and DQS in addition to installing the MDS Excel Add-in for Excel 2010 (32-bit).  As part of my configuration of the MDS web application I also enabled integration with Data Quality Services.  However when I select the Master Data tab in Excel I do not see the Data Quality buttons on the ribbon.

I understand that the DQS buttons will not display if the MDS database you are connected to is not integrated with DQS but as I said earlier I did click the integrate with DQS option when I setup the website.  Are there additional steps I need to take in order to integrate with DQS?

Thanks for your help

 

Answer 1

Just to confirm, you did install MDS+DQS on the same server?

And you ran the DQSInstaller.exe to set up DQS the first time?

Does Data Quality Client work - can you connect and make a KB or Data Project?

Did you get connected and pull an Entity into the Excel window first?

Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 2

Jason - mine is missing as well. We went through getting DQS working on my server already and MDS is installed on the same server. I have loaded an entity and I have combined data from another sheet in Excel 2010 and I don't see the data quality option to run a matching policy from my DQS that I setup previously. What could I be missing?

Thanks!

---

Brian

Answer 3

In the MDS configuration manager, is the box checked to enable integration between MDS & DQS?

When you check the box, it adds the account into the DQS roles. Can you check the accounts, and the dqs roles.

use [DQS_MAIN]

GO

IF NOT EXISTS (SELECT * FROM SYS.SYSUSERS WHERE NAME = 'MDS_ServiceAccounts') CREATE USER [MDS_ServiceAccounts] FOR LOGIN [DOMAIN\MDS_ServiceAccounts]

exec sp_addrolemember @rolename=N'dqs_administrator',@membername=N'MDS_ServiceAccounts'

-- alter role [dqs_administrator] add member [MDS_ServiceAccounts]

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance