Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Master Data Services (MDS) Rss

Search for any content tagged master data services (mds)

   Items 1 to 8 of 8   
 

Installing Master Data Services in an AlwaysOn Environment

This article describes a solution for Master Data Service (MDS) hosted on AlwaysOn Availability Group configuration. The article describes how to install and configure SQL 2016 Master Data Services on a SQL 2016 AlwaysOn Availability group (AG). The main purpose of this solution is to improve high availability and disaster recovery of MDS backend data hosted on a SQL Server database.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,863 reads

How to version a SQL Server Master Data Services model

In SQL Server Master Data Services all the entities are organized in a model. Once a model is ready to be released to subscribers, it should be frozen and marked as ready for subscribers. Until a model is marked as ready, a model is typically deemed as work in progress. In this article, Siddarth Mehta covers the standard process that's required to release a completed version of the model to subscribers.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,456 reads

Exporting Master Data from Master Data Services

This white paper describes how to export master data from Microsoft SQL Server Master Data Services (MDS) using a subscription view, and how to import the master data into an external system using SQL Server Integration Services (SSIS). The white paper provides a step-by-step sample for creating a subscription view and an SSIS package.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,950 reads

Getting Started with Master Data Services (MDS) In SQL Server 2012

MDS allows you to create a centralized hub for creating and managing enterprise master data. Arshad Ali discusses how to install and configure Master Data Services in SQL Server 2012, and a method to deploy sample models.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,326 reads

How to Import, Browse And Export Master Data Services' Data

Learn how to import data to Master Data Services (MDS) using Master Data Manager Portal UI to enter data manually or how to automate the import process by staging data into three different MDS staging tables.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,506 reads

Introduction to Master Data Services in SQL Server 2008

There are numerous databases housing the same information and it's getting quite difficult to keep everything in line. I've heard from a number of departments who want a more centralized approach to handling customer data, but I don't know where to begin. Can you steer me in the right direction?   Read more...
Rating:  Rate this |   Briefcase | 4,475 reads

An overview of Master Data Services - MDS in SQL Server 2008 R2

With Master Data Services, IT organizations can centrally manage critical data assets companywide.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,428 reads

Master Data Services - SSIS MDM Load

The article will provide an overview of Master Data Services and a sample SSIS Package.  Read more...
Rating: |  Discuss |   Briefcase | 7,600 reads
   Items 1 to 8 of 8