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
1
vote
1 answer

Which database writer model is optimal?

I have 2 servers. Server 1: (Master Server) - Master Database MariaDB - PHP Service + Reader from Master Database + Writer into Master database Server 2: (Slave Server) - Slave Database from Server 1 - PHP Service + Reader from Slave…
Canh Nguyen
  • 333
  • 1
  • 18
1
vote
1 answer

Cross reference data between two entities in Master Data Service (MDS)

I am doing a POC in MDS wherein i have two tables in two different systems like below: A | B | C ----|-----|---- A1 | B1 | C1 A2 | B2 | C2 A3 | B3 | C3 and X | Y | Z ----|-----|---- X1 | Y1 | Z1 X2 | Y2 | Z2 X3 | Y3 |…
Json Brent
  • 33
  • 6
1
vote
0 answers

Master Data Services - Leaf members Subscription View

In MDS, I set up an entity with a simply hierarchy: MasterGroup -- SubGroup ---- Product There are a few other entities, basically functioning as pick-lists for columns on the Product level. I.e. Sales has their way of looking at products, which…
SchmitzIT
  • 9,227
  • 9
  • 65
  • 92
1
vote
1 answer

How to use REGEX patterns to return day of the week if a date is entered?

I am trying to create something that will populate the day of the week in one cell based on a date entered in another, BUT in Master Data Services. I know I will need to do this in a business rule and apply it to the attributes. I am wondering if…
nation161r
  • 51
  • 1
  • 3
  • 14
1
vote
1 answer

Master Data Services 2016 cross domain users management issue

I have a scenario where MDS admin users and MDS application pool exist in domain A , normal MDS users exist in domain B. While this scenario worked with MDS 2012 after upgrade to MDS 2016 I am not able to navigate to functional area in MDS user…
user170442
1
vote
0 answers

Azure DW + DQS + MDS Architectures

What is a typical architecture if I want to use MDS and DQS for my Azure environment. I've been trying to search for some references and couldn't find a clear solution. Currently what I only know if I want to use DQS and MDS for my Azure DW is that…
mtryingtocode
  • 939
  • 3
  • 13
  • 26
1
vote
0 answers

How to create dynamic .mdsqx query for Master Data Services Excel Add-On?

Is there a way to modify MDS Excel Add-On saved XML query to work dynamically? I'd like to filter results based on other linked entities. I figured out the hardcoding way to change filter parameters for example [Group] IN ('1','2','3') but I can't…
profound_aggression
  • 46
  • 4
1
vote
1 answer

SQL MDS Synchronization

We have following question about the SQL Master Data Service: We have already integrated different client data to MDS with the help MS Excel plugin, now we want to push back updated or new added record to source database. is it possible do using…
user3898722
  • 11
  • 2
1
vote
1 answer

Master Data Services: Unauthorized

I performed an installation of Master Data Services on a new SQL Server (Windows 2012 Standard with SQL Server 2014, Enterprise Edition). Initially I used a non-personal AD account during the installation (same for the DB and the web-application),…
SchmitzIT
  • 9,227
  • 9
  • 65
  • 92
1
vote
0 answers

How to add a new user in SQL Server 2012 Master Data Services if another computer with the same name exists in the same domain?

While adding a new user in User and Group Permissions,I found this issue. If the User Name and any other computer name in the same domain is same while adding a user to MDS, it adds a $ sign to the name and takes that other computer name instead of…
user3868599
  • 11
  • 2
1
vote
1 answer

How to sort members of the entity in master data services(mds) by name?

I want to alphabetically sort members by name of the entity in master data services (mds). I cannot find a straightforward solution. Currently, members are sorted by code (built in mode!?). How to change sort order by name? Please see an example…
BI Dude
  • 1,842
  • 5
  • 37
  • 67
1
vote
1 answer

Master Data Services- Merge members

Can any one tell me how to merge two members in an MDS entity using C# as Codebehind.
user2245257
  • 11
  • 1
1
vote
3 answers

Running multiple instances of Microsoft Master Data Services on the same server

I have an instance of MS SQL Server 2012 with MDS. The MDS instance is used as a production environment. Now, of course, I would like to have a dev/test environment for MDS. Currently I just have one server with one instance running SQL Server 2012…
user1407800
  • 11
  • 3
0
votes
1 answer

Biztalk mapper to work with Master Data Service Web Service

Im having a problem updating Master Data located in Microsoft Master Data Service. Im using Biztalk 2010 and im reading from flat file. The problem is that I cannot find out how to map everything in the mapper and keep getting the same error: Inner…
Ville Loponen
  • 1
0
votes
0 answers

How can grant permission to execute a stored procedure on another database to specific master data services user?

Problem: I need to grant permission to execute a stored procedure on another database to the master data services user that is handling the DML commands whenever I use the Master Data Services Excel add-in. Context: I added a SQL trigger to a master…
John
  • 157
  • 5
  • 13
1 2
3
4 5 6 7 8