Using MDS add-in and DQS integration in an Excel workbook - SQL Server 2012

Question

Hi,

I've installed MDS 2012, the MDS add-in and the DQS 2012 in a my test machine. In the MDS configuration, for my MDS web application I've enabled the DQS integration.

I've created a MDS model, an entity with his attributes and I've feeded this entity with some master data. I've opened a workbook, created a MDS connection, selected the MDS model and the entity to view the master data. In the same workbook, I've put the data to match with the master data. I can see the Combine Data functionality and when I use it in the master data sheet I can see also the matching data as external source. Now, how can I execute the matching operation with the DQS? It seems that any DQS functionalities or menù voices isn't visible in the Master Data tab in Excel.

Any suggests to me, in order to solve this issue, please? Many thanks

Answer 1

Hi, after the combining data operation, I can see the match data button in Excel. It asks about DQS domain, but I've choices some generic options (fe generic string, exact matching) for the running data quality operation.

So, I've solved my issue.

Thanks for your attention.

Bye