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 Model Deploy include annotations

It seems that using MDS Model deploy with -includedata does not include history or annotations. Is there a way to achieve this? We are moving to a new production server, and I had planed to set it up fresh. But if I can't move the history and…
PJL75
  • 1
  • 1
0
votes
1 answer

How to delete records on MDS using SQL code?

I am trying to delete records on MDS using the staging table, and although I already updated the records to the ImportType 4 (Delete record): On MDS it appears not only the correct line (Code 29355) but also the other ones that should have been…
igdc
  • 43
  • 1
  • 9
0
votes
0 answers

How to sync the changes between MDS and OLTP database?

I am trying the SQL MDS feature. In the explorer I have created the model, entity and attributes. Then I copied the data from the OLTP database table and pasted into excel to put (import) it into the MDS. Question - When I make a value change to…
variable
  • 8,262
  • 9
  • 95
  • 215
0
votes
0 answers

Master Data Services 2019 Create Model Error

I have installed Master Data Services 2019 and have the Database and Website configured and running, overall everything seems to be setup correctly. But when I try to create a model, I get an error. Hovering over the icon all it says is Error. Has…
Daniel-7776
  • 1
  • 1
0
votes
1 answer

CICD for MDS via Azure Devops

I am trying to implement CICD for MDS via Azure Devops. Below are the steps which I have followed : Created a self hosted agent which has SSDT installed Tried executing the MDS Cmd queries from the VM which I created as a self hosted agent and it…
Nandan
  • 3,939
  • 2
  • 8
  • 21
0
votes
1 answer

Master Data Services Web App: Unauthorized

I have a new install of Master Data Services (MDS) 2016 hosted on IIS 8.5 on Windows 2012. When I browse to the application from IIS on the server with the default bindings the application works fine. But if I edit the bindings and add a DNS…
Adrian S
  • 1,007
  • 4
  • 12
  • 26
0
votes
1 answer

relation between real person and legal person in master data service

I want to create master data for an organization. I have 5 basic data, one of them is persons. I use the master data service (SQL server). I designed models with the named party and some entities. my entities are Person, organization and…
mohammadjavadkh
  • 70
  • 9
0
votes
1 answer

Master Data Services create entity member using The WCF Service

I'm trying to create entity member using WCF service. But the line EntityMembersCreateResponse createResponse = clientProxy.EntityMembersCreate(createRequest); raising the following error: An unhandled exception of type…
Yura NoMatter
  • 1
  • 1
0
votes
1 answer

How to connect by MDS excel add-in using HTTPS?

I've switched MDS access from HTTP into HTTPS. Web interface works ok Excel add-in generates an error during a connection attempt The HTTP request was forbidden with client authentication scheme 'Negotiate'. The remote server returned an error:…
hrabiabw
  • 1
  • 1
0
votes
1 answer

search master data service member by builtin attribute code

I can search member by EntityMembersGetCriteria where SearchTerm containing expressions for custom attributes for exampel SAP Code = 'abc'. var criteria = new EntityMembersGetCriteria { ModelId = new Identifier { Name = Model }, …
beewest
  • 4,486
  • 7
  • 36
  • 63
0
votes
1 answer

MDS Staging with automatic codes creation

everyone! We're using MS SQL Master Data Services to organize our enterprise master data and some of entities, we keep, consists of data, that we load from external sources almost as-is. We regularly update them using jobs or SSIS packages, placing…
Anton Matyushov
  • 1
  • 1
0
votes
1 answer

Create a business rule in MDM 2012 that tests the Sum of attributes of an entity

I have created an entity on MDM 2012 and I like to create a business rule that tests if the SUM of 3 attributes is 100. I didn't find a way on the Action Panel to use arithmetic operators or simply a SUM function.
TunoN
  • 91
  • 1
  • 1
  • 7
0
votes
1 answer

Microsoft Master Data Services 2016 Additonal Domain Atrribute Referencing

Is it possible to reference additional columns apart from the 'Code' and 'Name' columns when using a domain attribute in an entity? E.g. A person entity has a code of '1' and a name of 'Smith' and a Gender of 'Male' In a customer entity there is a…
Paul Ensby
  • 31
  • 3
0
votes
1 answer

Equation query in stored procedure using business rules Master Data Service

I would like to create business rules in master data service for amount column and the rules is column qty * column price. Can I use business rules in MDS ?
Henry
  • 167
  • 1
  • 10
0
votes
1 answer

TSQL list of business rules in MDS

I need help with querying my business rules in SQL! I have created couple of business rules in MDS web service to validate my master data and found out that 2 % of my data is not complying with the rules. Now I have created a SQL subscription view…
Reza Azimi
  • 11
  • 7
1 2 3
4
5 6 7 8