For more information, see Administrators (Master Data Services). Unless otherwise noted, all of the following procedures require you to be a model administrator. The following table outlines the key Master Data Services tasks. You can also use business rules to set attribute values. You load data into staging tables, validate the data using business rules, and load the data into MDS tables. Once you've defined a basic structure for your data, you can start adding data records (members) by using the import feature. In the product model for example, you can have a color derived hierarchy that comes from the relationship between the color and product entities. These are domain-based attribute relationships. ĭerived hierarchies come from the relationships between entities in a model. This master list of colors is used as attribute values for the Product entity. And, there is a domain-based attribute for color that contains values that are populated by the color entity members. A domain-based attribute contains values that are populated by members from an entity and can be used as attribute values for other entities.įor example, the product entity might have free-form attributes for cost and weight. There are free-form attributes and domain-based attributes. An attribute contains values that help describe the entity members. Models also contain attributes that are defined within entities. The color entity may contain members for the colors red, silver, and black. An entity is similar to a table.įor example, your online product model may contain entities such as product, color, and style. A model contains one or more entities, and entities contain members that are the data records. You create a model to manage groups of similar data, for example to manage online product data. In Master Data Services, the model is the highest level container in the structure of your master data. For information about the new features in SQL Server, see What's New in Master Data Services (MDS)įor instructions on how to install Master Data Services, set up the database and Website, and deploy the sample models, see Master Data Services Installation and Configuration. With Excel, you can share the master data set with other people in your organization.įor a description of the Master Data Services architecture, see the Master Data Services - The Basics article on. You can organize the data into models, create rules for updating the data, and control who updates the data. Master Data Services enables you to manage a master set of your organization's data. This topic describes the key data organization and management features of Master Data Services. SQL Server (all supported versions) - Windows only
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |