Questions tagged [master-data-services]
The master-data-services tag has no usage guidance.
19
questions
0
votes
1
answer
334
views
SQL Server Master Data Services Permissions for Subscription Views
I have an instance of SQL Server Master Data Services installed, there are users managing the master data via the Excel add-in, now we're ready to integrate the master data into products. We've ...
- 105
0
votes
1
answer
33
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 ...
- 105
1
vote
1
answer
359
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 ...
- 83
0
votes
1
answer
1k
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 ...
- 145
0
votes
1
answer
77
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 ...
- 290
5
votes
2
answers
316
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
0
answers
62
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 ...
3
votes
1
answer
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 ...
- 9,954
-1
votes
1
answer
3k
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 ...
- 129
2
votes
1
answer
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/...
- 129
1
vote
0
answers
378
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 ...
- 571
1
vote
0
answers
71
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 ...
- 5,957
4
votes
1
answer
133
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 ...
- 43
0
votes
1
answer
55
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
1
answer
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 ...
- 503
5
votes
1
answer
1k
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 ...
- 2,173
3
votes
1
answer
135
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 ...
- 545
1
vote
0
answers
243
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 ...
- 11
3
votes
2
answers
445
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 ...
- 259