Questions tagged [master-data-services]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
23 views

Implement AKA in SQL Server Master Data Services

I'm working with a bunch of scientists and we're trying to implement a master data solution for the ingredients they use in formulations. The problem with their historic data is Scientist #1 will use ...
1
vote
1answer
26 views

Running Excel addin for MDS2019 vs MDS2016

We are upgrading master data services (MDS) of SQL2016 to SQL2019.Is there a way to run excel 2019 addin for connecting to SQL 2019 MDS along side(parallely) with excel 2016 addin for connecting to ...
0
votes
0answers
33 views

Master data services(MDS) upgrade from SQL2016 to SQL2019

Team, I have not worked on MDS before and need some advice/inputs. We are doing an doing an in-place upgrade of MDS (master data services) from SQL2016 enterprise to SQL2019 enterprise. i would like ...
0
votes
1answer
376 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
47 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
173 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
56 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
2k 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
2k 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
2k 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
272 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
49 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
57 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
45 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
809 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
237 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
394 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 ...