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

MDS Excel add-in multiple entities in one xls file

Hi We have a couple of issues that might be bugs. At least we cannot find any fixes or help on the web. We have an Excel sheet with a sheet per Entity. All data comes from the same MDS. Screenshot of MDS spreadheet First problem When we close the…
buhg
  • 1
0
votes
1 answer

Master Data Business Rules Protecting Column from Edit / Change

I am in need of some help with Microsoft Master Data - specifically the Business Rules. I am inserting data into MDS and then the users will update additional info using the excel plugin. The data Im inserting is used in my join for reporting. I do…
Kyle Jardine
  • 13
  • 1
  • 7
0
votes
0 answers

MDS Application Pool : Incorrect Password

I am trying to create the MDS website and for the Application Pool I am using my Windows 10 Domain\user and password (home computer). I keep getting the following error: "the password supplied is incorrect". I know the password is good as I logged…
user1082748
  • 365
  • 1
  • 7
  • 18
0
votes
1 answer

How to get the Value of a Domain attribute with Master Data Services (MDS) WCF API

To get the grips of the MDS WCF API I started a .Net Core console application. I'm struggling to find detailed documentation on the data structure used in the API. I now have a simple function that uses EntityMembersGet to read the Members (rows) of…
RJD
  • 320
  • 3
  • 11
0
votes
1 answer

how to transfer records from MDS to another table then delete certain records from MDS without deleting them from the transferred table

I'm using Master Data Service (Enterprise version for SQLServer2016) to collect data from different departments, so each group will have one or many attribute groups with update access. To indicate the cycle completion an attribute "Cycle Status" is…
E.IK
  • 11
  • 3
0
votes
1 answer

MDS Error when creating a Entity Sync to an New Target Entity

When I try to create an Entity Sync in Master Data Services 2016, I receive the following error (fyi I chose to create a new target entity). Not sure why this is occurring. Ideas?
PBMe_HikeIt
  • 659
  • 8
  • 24
0
votes
2 answers

Validation Rule: NULL value

My users would like to enter a value in the NAME attribute of an entity in SQL Server Master Data Services. The valid values must contain zero to six characters. NULL is a valid value. I have written a validation rule with a action containing a…
Kaye Cahs
  • 1
  • 1
0
votes
0 answers

SQL Execution - Unable to parse query text

I'm trying to do a bulk load from a CSV into MDS (via SSIS package) but I keep getting this error: Unable to parse query text. Any ideas what's causing this? Screenshot is below: This is all within Visual Studios. The actual package runs but…
Max Lee
  • 1
  • 2
0
votes
0 answers

What is a @mask parameter in SQL Server MDS's mdq.RegexReplace() function?

I can't seem to find a reasonable documentation for this function definition, including its parameters. What is the range of values @mask takes and how do they influence the output? Any help?
Oleg Melnikov
  • 3,080
  • 3
  • 34
  • 65
0
votes
2 answers

MDS 2016: Entity purge - hard delete

When I try to purge my entity with the Master Data Service interface or with the SP mdm.udpDeletedMembersPurge, I get this error: MDSERR200221|Members cannot be purged from the model version. It contains at least one entity that is the target of a…
Gaë
  • 1
  • 2
0
votes
1 answer

Can't set "Equals to" business rules in SQL Server 2016 Master Data Services

This issue with SQL Server 2016 MDS is driving me nuts. I've got two entities set up with a few attributes: Company a. Code b. Name Customer a. Code b. Name c. Company (Domain-based attribute) d. DisplayCompany I'd like to add a business…
Gabor
  • 685
  • 2
  • 11
  • 25
0
votes
1 answer

Master Data Services Transferring data

I'm new to MDS and I am trying to figure out if there is a way to transfer data from the UI to SQL. I saw you can transfer data from sql server using the job MDS_DataBase Name_Sync but I cant find anything that transfers data from MDS. When I check…
Tony Montana
  • 39
  • 8
0
votes
1 answer

Explorer tab is disabled in SQL Server 2016 Master Data Services

I have installed Master Data services in SQL Server 2016. I configured the Master Data Service properly. It can appear in web browser. I have installed Sliverlight and Master Data Services Add-In For Microsoft Excel as well. Still when I open the…
Jay Desai
  • 821
  • 3
  • 15
  • 42
0
votes
2 answers

How to migrate changes in MDS across environments (Dev, Stg, Prd)

We've started using MDF inhouse recently. So far, we've had a single person work on MDS at a time. This allows that person to work on a single ticket at a time, once they're done migrating all of MDS with or without data to STG, and if it passes…
yoelbenyossef
  • 393
  • 1
  • 7
  • 26
0
votes
1 answer

Master data services service Get data using The WCF Service

Hi I am new to MDS i have everything setup webui/ sql db etc and am now looking to write a demo console app to connect via the wcf service and bring back some data. I have searched high and low with no luck or found what i believe to be an older…
user1488692
  • 29
  • 6
1 2 3 4
5
6 7 8