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
2
votes
2 answers

Master data services deployment

What is the best approach to keep Production,dev and test enviroments in sync? We have Master Data Services database in our development, Test and Production environments. Data is been entered into Production and we need to keep our test and…
Durga
  • 33
  • 5
2
votes
1 answer

Changing the language of Master Data Services

Yesterday, I installed and configured Master Data Services (after installing IIS and other required components). At no point during the installation did I get the option to pick a language (and if I did, I might have overlooked it). When checking…
SchmitzIT
  • 9,227
  • 9
  • 65
  • 92
2
votes
2 answers

Troubleshooting Master Data Services (MDS) Permission Authorization

I have been testing Master Data Services for future project. A few days ago MDS stopped authenticating with clients without any known reason. I am using SQL SERVER 2012 BI edition. In general, I can access MDS page on the server using…
BI Dude
  • 1,842
  • 5
  • 37
  • 67
2
votes
1 answer

Architectural flow diagram ? MVC4 with EF & mds services

We gonna deal with a application which can be consumed from various devices . I what the flow diagram from which layer to which layer like that .. I tried one if i am wrong correct me and any clarity comment i will try to be elobarative VIEW <--->…
user2061595
  • 29
  • 7
2
votes
2 answers

Data matching/ deduplication Sql server 2008 R2

What are the options for making a data cleansing process (deduplication/matching) when dealing with MS SQL Server 2008 R2? Or better yet how can I weight scores on a matching process on columns of a row? The situation is the following: I have a…
MariaMadalina
  • 479
  • 6
  • 20
2
votes
2 answers

Can Domain-based attributes span across models

If models in Master Data Services are representations of subject areas (such as customer, product, etc.), is it possible to have a domain-based attribute that uses a different model as it's source? For example, if creating a customer model and…
Simon Worth
  • 95
  • 7
2
votes
3 answers

MDS business rule

I am new with MDS, and I have a question about one to many relation mapping in MDS I have a product, contains descriptions in multiple languages. I have created two entities with derived hierarchy structure: product (P_ID, P_name)and Addtional…
Coconuts
  • 25
  • 5
2
votes
0 answers

master data services url

I've included the Master Data Services Silverlight frontend in SharePoint using an iframe. I wan't to link to specific entities and such in this frontend. I know I can link directly to entities, and even filter on specific parameters using the EID…
Søren Sparsø
  • 73
  • 8
1
vote
0 answers

Master Data Services 2019 - Derived Hierarchy issue

I've been facing an issue with a Master Data Services (MDS) derived hierarchies. At first the hierarchy worked fine but after some time (do not know how long) I am not able to load the MDS data via Excel with MDS 2019 Add-in. I am receiving an error…
PetrSto
  • 11
  • 2
1
vote
1 answer

Change Collation on Master Data Services

I have a SQL Server 2017 Master Data Services installed on SQL Server 2017. During installation it was setup to use the default server collation. We now have been using MDS via the excel plugin and the users wish to clean the text. However, when…
KrazzyNefarious
  • 3,202
  • 3
  • 20
  • 32
1
vote
1 answer

Configure The MDS web front end on a different server to the database

The current server set up is that IIS is installed on one server and the SQL Databases are on another server. I need to install MDS where the Database is on server 1 and the web front end (IIS) is on server 2.
Keag1
  • 141
  • 1
  • 11
1
vote
1 answer

create a changeset during staging ETL to Microsoft MDS for approval

In MDS, if i manually make changes, I can create a changeset for approval. Is there a way to force approvals for changes that come in via the staging tables? if so, How? thanks
arcee123
  • 101
  • 9
  • 41
  • 118
1
vote
1 answer

MDS import data queue

I am following this guidance: https://www.mssqltips.com/sqlservertutorial/3806/sql-server-master-data-services-importing-data/ The instructions say after we load data into the staging tables, we go into the MDS integration screen and select "START…
arcee123
  • 101
  • 9
  • 41
  • 118
1
vote
0 answers

MDS - how to ensure that all fields contain a value?

we're using MDS to insert some records but sometimes we have users that insert empty values by mistake which results in some issues. Since we want to verify and validate all fields to ensure that none of them are null we have tried to look at the…
R.G.B
  • 11
  • 2
1
vote
1 answer

is there a way in Master Data Service to freeze a record (like make it disable) once a certain attribute is equal to Yes?

I'm using Master Data Service to collect data from different departments. So each group will have one or many attribute groups with update access. I've an attribute that indicates the cycle completion as Yes or No value, once the value is set to…
E.IK
  • 11
  • 3
1
2
3 4 5 6 7 8