Stack Overflow
Stack Overflow

Questions tagged [master-data-services]

Master Data Services is Microsoft's Master Data Management solution

Master data management (MDM) describes the efforts made by an organization to discover and define non-transactional lists of data, with the goal of compiling maintainable master lists. An MDM project generally includes an evaluation/restructuring of internal business processes along with the implementation of MDM technology.

After a master list is compiled and business processes are set up to support this list, data analysis is more likely to be accurate and business decisions can be based on reliable information.

118 questions
23
votes
1 answer

Microsoft Master Data Services : How to get/set description of Model/Entity programmatically

I work with MDS 2008 / API to insert/update Models, Entities, Attributes and Members programmatically. I want to get or set the description of one Model or one Entity. If fact on Master Data Manager, we can see this on metadata of one model or…
flow
  • 4,828
  • 6
  • 26
  • 41
21
votes
7 answers

Microsoft Master Data Services - When to utilize?

I'm wondering if anyone is currently utilizing Microsoft's Master Data Services? How you are utilizing it? Whether you find it useful? When you believe it would be useful? Thanks!
Dave Mackey
  • 4,306
  • 21
  • 78
  • 136
6
votes
1 answer

Database Design Patterns/Considerations when leveraging Master Data Services

I'm trying to find a good source of information on the database and/or table design considerations/patterns to be aware of when designing a data warehouse and leveraging MDS/DQS components...things like adding "current flag", "created date", "end…
Bill Anton
  • 2,920
  • 17
  • 23
4
votes
1 answer

Master Data Services with Reverse Proxy

I am having an issue with accessing MDS via a reverse proxy. Below is the simplified network diagram of my infra setup. So, basically I have 2 app servers for ssrs and mds respectively and one web server. Plus there is a load balancer which serves…
Prateek Singh
  • 863
  • 1
  • 8
  • 28
4
votes
2 answers

.svc handler for IIS Server

While configuring the SQL Server 2012 Master Data Services, I am having following problem The required .svc handler mappings are not installed in IIS. What I want to do is that, I want to query my database using a URL so that I can retrieve data…
SPandya
  • 1,161
  • 4
  • 26
  • 63
4
votes
0 answers

Is there a public dataset with the complete i18n list of Countries, states, languages, area codes, cities, postal codes and Timezones?

I am developing an generic application for the global audience and would like to capture this Master Data so that appropriate UI components can be developed to support features such as Autocomplete and dependent picklists. The master data I am…
Chakra Yadavalli
  • 399
  • 1
  • 7
3
votes
2 answers

Master Data Services REST API

I have a Microsoft Master Data Services installation, SQL Server 2014. I need to provide a REST interface to allow an external system to push data into our MDS staging area. MDSS has a WCF API available out of the box but we specifically need to…
user9493536
3
votes
2 answers

Can I use Master Data Services to import data via Excel add-in ? Mainly Measures! (Numbers/Values)

Can I use Master Data Services to import data via Excel add-in mainly Measures (Numbers/Values) Shortversion: Looking for the best way to comfortably input data to an SQl-Server table with immediate feedback for the user. Set-up: We have a…
Patrick B.
  • 157
  • 11
3
votes
1 answer

Is the Master Data Services Metadata model deprecated or not?

In 2012 Microsoft tells us that we should not use the Metadata model within SQL Server Master Data Services as it is a deprecated feature. http://technet.microsoft.com/en-us/library/hh231001.aspx In 2014 it seems to be back with no mention of any…
deebeegee
  • 31
  • 2
3
votes
1 answer

Master Data Services Silverlight error

I've installed MDS on our dev server and I can navigate through(and perform various functionality such as add users or create, add entities). I can't however get into the "Explorer". In here I get two Silverlight…
Chris L
  • 669
  • 2
  • 10
  • 21
3
votes
3 answers

how to insert data in master data services programmatically

I'm trying out Microsoft Master Data Services and I would like to add data to the database programmatically. I'm starting to get the model/entity/member structure but I'm not yet sure. If you have a nice explanation for this structure, please…
hhoud
  • 518
  • 2
  • 6
  • 18
2
votes
1 answer

SQL Server 2019 Master Data Services Filtering on Numeric

I have recently upgraded a MDS 2017 instance to 2019. After the update, users are experiencing an error when trying to filter on a Number Type Attribute within an Entity view on the web interface. I can find no reported instances of this online. …
Doug Olson
  • 21
  • 1
2
votes
0 answers

Changing System Administrator in MDS database

So the consultant who created our MDS database has left but his account is still the system admin. I looked everywhere online on how to change the old admin and it suggested everywhere to do it through udpSecuritySetAdministrator stored procedure…
Wael Morsy
  • 31
  • 2
2
votes
1 answer

Is there any way to move individual entity from one server to another in Master data services?

I have master data model with some entity and it is deployed on production server. Now i have created 2 more new entity in development server and wanted to move only these two entity. If anyone has any idea please share with me. Thanks !
Prayag15
  • 393
  • 3
  • 13
2
votes
1 answer

How to use Master Data Services data then? The MDS lifecycle

So I know that we need to create Master Data Services db to make data clean, right, consistent, etc. We can import some data there, then process it.. and then? We should then export it to another db, is it so? So MDS is like a set of tools to clean…
Lisa Aaron
  • 21
  • 1
1
2 3 4 5 6 7 8