Tags » Master Data Services

Master Data Services in SQL Server 2016 RC2: Significant Improvement

The Master Data Services in SQL Server 2016 RC2 appears to be a significant improvement over what shipped with SQL Server 2014 GA.  There’s obvious UI improvements.   53 more words

SQL Server

How to: Delete records from your MDS Entity table

Here’s an example script which you could use to delete records from your MDS Entity/table:

Here’s the code:


--Start clean:
TRUNCATE TABLE stg.

--Retrieve CodeID's: 93 more words

MDS

MDM setup managing synchronization - part 4

In a previous post we published the entities that you will use in SQL MDS. Now it’s time to sync the data. This involves setting up a sync group and associating the entities. 24 more words

Infrastructure

MDM setup publishing the entities - part 3

In a previous post we setup SQL MDS and configured two instances of AX to connect into MDS. Now we have the basic infrastructure in place you can published the entities to MDS which will form the storage structures for the data.

Cheers

Lachlan

Infrastructure

MDM Setting up the second instance - part 2

In the previous post we did the configuration of SQL Master data services initial configuration and connection to the first AX instance. That was where most of the work is so connecting the second instance is pretty quick .

Cheers

Lachlan

Infrastructure

Setting up AX to connect to SQL Master Data Services

In a previous post I did a basic overview of syncing customers between two AX instances using SQL MDS. I thought I’d got back through the setup of this so you can see how the infrastructure pieces connect. 74 more words

Infrastructure

The use and misuse of Master Data Services (MDS) in SQL Server

After watching the SQL Hangout (Hangout #27 Master Data Management?), something told me to also shed light on other ways to use and misuse MDS. 319 more words

MDS