Questions tagged [master-data-services]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
14 views

MDS Add-in for Excel Office 365 - Error

I did setup Microsoft SQL Server 2016 Master Data Services (MDS) successfully but hitting an error (bug?) while installing the add-in for Excel - which can download/upload data from/into MDS ...
0
votes
1answer
24 views

Microsoft Master Data Services (MDS) Migration | 2017 to 2019

We're in the process of upgrading our MDS instance, from 2017 to 2019, by means of a migration. I can't find any good documentation online on how to do this in an efficient way. Has anyone performed ...
0
votes
1answer
29 views

Can we generate SQL Server MDS Model from an existing database schema?

I have googled this quite a bit and am surprised to not find an answer. I'm considering using SQL Server MDS to manage our canonical schema, but I certainly don't want to key in my entire database ...
5
votes
2answers
106 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
50 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
1k 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
231 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
47 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 ...
4
votes
1answer
52 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
726 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
235 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
365 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 ...