We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [master-data-services]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
5
votes
2answers
86 views

How can we trim bad data and output clean trimmed data using DQS or MDS?

Until now, we have used stored procedures for data massaging and cleansing but we have now decided to move to using Data Quality Services (DQS) and Master Data Management (MDS) in our data warehouse ...
1
vote
0answers
45 views

Verify which MDS.stg table is related to which MDS model for SSIS data load

I need to load the data into the MDS staging tables by using SSIS. The problem is that there are many MDS models, and every one of them has its own staging tables, but they are not named properly (by ...
2
votes
1answer
1k views

SQL Master Data Services database has huge leaf member staging table - can I purge old records?

One of our SQL instances has a large MDS database, and virtually 100% of the size is due to a 300+ million row table named stg.Stg_Project_Leaf. It recently started blowing up our weekly index ...
-1
votes
1answer
959 views

Problem with MS Excel MDS addon - unable to connect to the web app

I have a new installation of MDS and SQL Server 2016. Installed the Excel plugin too, but unable to connect to the web app. I keep getting this error "there was no endpoint listening at <> that ...
2
votes
1answer
1k views

How to resolve this SQL Server 2016 master data services authentication error on the web application?

I just installed MS SQL server, IIS and Master Data services, 2016 version. Everything seems fine, except the web application doesn't work. I am able to go to the home screen, but there are no models/...
1
vote
0answers
217 views

Can you script the MDS database upgrade after SQL Patch applied

I have recently automated the SQL patching of ~200 development servers. Currently we have 6 servers that run the Microsoft Master Data Services feature. After a SQL patch is applied there is a ...
1
vote
0answers
46 views

Is the source system typically one of the fields used to uniquely identify business key?

One of the key components of designing a data vault is identifying enterprise-wide unique business keys ("business key" AKA "natural key"). It's not enough to use OrderID to identify records in an ...
0
votes
1answer
417 views

MDS Upgrade script fails when upgrading database

Just applied SP1 to SQL Server 2016. Server also has DQS and MDS components installed. When I tried to update the MDS database through MDS configuration, the update script failed on invalid object stg....
4
votes
1answer
51 views

Is there a way to find out what queries are run the most against a particular table?

We have been experiencing issues with slowness regarding our Master Data Services application. So we have looked to see which tables have the highest value of range scans, singleton lookups, page lock ...
0
votes
1answer
44 views

How to create a table in access and automatically fills it with information from a query? [closed]

Is it possible if I create a table that will lookup for a value filtered from a query (consult), in this case is duplicated "Name"s from a Employees registring table and automaticly fills up that ...
2
votes
1answer
3k views

Is Windows 10 compatible with SQL Server 2014 Developer MDS?

I have recently installed SQL Server 2014 Developer edition onto my PN, which has Windows 10 Professional installed. I upgraded from Windows 7 Pro to Windows 10 Pro last year as it was a free update ...
5
votes
1answer
696 views

sp_Blitz says “Page Verification Not Optimal” on MDS database

I've run sp_blitz (version 45) on our test database server. It complains about Database [MDS] has TORN_PAGE_DETECTION for page verification. SQL Server may have a harder time recognizing and ...
3
votes
1answer
119 views

Centralized master data shared among other several DBs

I'm researching and investigating about all possible ways to create a master data database for my portfolio of applications. To give you a quick overview, an example will come in handy: I want to ...
1
vote
0answers
233 views

Issue with MDS data when viewed in Excel addin after connecting to MDS Model

In MDS 2012, while exploring for a entity, I can see the data in Client and Product column are properly assigned as Code and Code {Name} as seen below: but while connecting to the MDS model via Excel ...
3
votes
2answers
356 views

SQL Server Master Data Services database history by snapshots

I'm involved in a project where there is SQL Server 2012 Master Data Services used. There's a requirement to save a version of the database contents in certain point of time, say, every month or a ...