Sign in
 
Announcement: 4

SQL Server Master Data Services announcement

  • Link
    SQL16 CTP2.3 is available for download
    Sherry_Li

    We are excited to share the new features which shipped in SQL CTP2.3 public release.  You can download the product here:http://www.microsoft.com/en-us/download/details.aspx?id=48726, and Excel add-in here: http://www.microsoft.com/en-us/download/details.aspx?id=47343

    In this monthly release, we added a few highly asked features.  Please give it try and look forward to hearing your feedback.

    Manage Business Rules (MDS Add-in for Excel)

    In the Master Data Services Add-in for Excel you can manage Business Rules, such as creating and editing business rules. Business rules are used to validate data. For more information, see Manage Business Rules (MDS Add-in for Excel).

    Many-to-Many Relationships in Derived Hierarchies

    You can now create a Derived Hierarchy that displays  many-to-many relationships. A many-to-many relationship between two entities may be modeled through the use of a third entity that provides a mapping between them. The mapping entity is an entity that has two or more domain-based attributes referencing other entities.

    For example, entity M has a domain-based attribute that references A and a domain-based attribute that references B. You can create a hierarchy from A to B using the mapping entity.

    For more information, see Show Many-to-Many Relationships in Derived Hierarchies (Master Data Services)

    Merge Conflicts

    If you try to publish data that has been changed by another user, the publish will fail with a conflict error. To resolve this error, you can perform merge conflicts and republish the changes. For more information, see Merge Conflicts (Master Data Services) and Merge Conflicts (MDS Add-in for Excel). 

     SQL Master Data Services Team

  • Link
    Master Data Services SQL2016 CTP2.2(July) Release is public available
    Sherry_Li

    Please give it a try and let us know your feedback!

    SQL Server 2016 Community Technology Preview 2.2 is publicly released and the latest bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

    In CTP2.2 MDS introduced following changes:

    1. Custom Indexes

    You can create a non-clustered index on one attribute (single index) or on a list of attributes (composite index), in an entity, to help improve the query performance. For more information, see Custom Index (Master Data Services).

    2. Entity Sync Relationship

    You can share entity data between different models by creating an entity sync relationship. For more information, see Entity Sync Relationship (Master Data Services).

    3. Member Revision History

    A member revision history is recorded when a member is changed. You can rollback a revision history, as well as view and annotate revisions. Using the Log Retention Days property, you can specify how long historical data is retained. For more information, see Member Revision History (Master Data Services).

  • Link
    New release on MDS Excel add-in available for download
    Sherry_Li

    Hi, we are pleasured to announce the release of MDS Excel add-in. You can download it here:

    http://www.microsoft.com/en-us/download/details.aspx?id=42298

    This release includes a number of performance improvements – most users will see a 4x improvement when loading data from an MDS server, without any additional server or environment changes. For an additional performance increase (2-4x), you can enable Dynamic Content Compression in IIS.

    It works with both SQL12 or SQL14.  The installation will be in place upgrade so the users don't need to uninstall previous installation.  All the MDS connections will be preserved through the installation. 

    Please download the new version of Excel add-in.  Your feedback is welcome!

    Thanks,

    SQL MDS Team

  • Link
    Please Indicate "Mark as Answer" if a Post has Answered the Question
    edhickey

    While reading a reply to your question, you will notice a button with an icon that says "Mark as Answer."   Please select this button when a reply answers your question.

     

    There are several reasons to do this:

     

    • Our search engine weights Answered questions more highly. By marking Answers you increase the chances that others searching this forum will find the answer directly rather than re-posting the question.
    • You give credit to the hard working folks who answer your questions. This is peer to peer support, so recognition is our only reward. (Check out the Top Answerers in 30 Days chart at the bottom of the thread list to see who is currently answering questions.)
    • You help Microsoft to track the health of this forum. Our forum gets 'measured' based on how many unanswered questions are in it at any time and we work hard to keep those numbers to as low a level as possible. By marking answers, others get a more accurate understanding of how well (or badly) things are going on the forum.

     

    You can also vote "Yes" or "No" if the reply was helpful.

     

    Thank you!

     

    Ed Hickey

Announcement: 4

SQL Server Master Data Services announcement

  • Link
    SQL16 CTP2.3 is available for download
    Sherry_Li

    We are excited to share the new features which shipped in SQL CTP2.3 public release.  You can download the product here:http://www.microsoft.com/en-us/download/details.aspx?id=48726, and Excel add-in here: http://www.microsoft.com/en-us/download/details.aspx?id=47343

    In this monthly release, we added a few highly asked features.  Please give it try and look forward to hearing your feedback.

    Manage Business Rules (MDS Add-in for Excel)

    In the Master Data Services Add-in for Excel you can manage Business Rules, such as creating and editing business rules. Business rules are used to validate data. For more information, see Manage Business Rules (MDS Add-in for Excel).

    Many-to-Many Relationships in Derived Hierarchies

    You can now create a Derived Hierarchy that displays  many-to-many relationships. A many-to-many relationship between two entities may be modeled through the use of a third entity that provides a mapping between them. The mapping entity is an entity that has two or more domain-based attributes referencing other entities.

    For example, entity M has a domain-based attribute that references A and a domain-based attribute that references B. You can create a hierarchy from A to B using the mapping entity.

    For more information, see Show Many-to-Many Relationships in Derived Hierarchies (Master Data Services)

    Merge Conflicts

    If you try to publish data that has been changed by another user, the publish will fail with a conflict error. To resolve this error, you can perform merge conflicts and republish the changes. For more information, see Merge Conflicts (Master Data Services) and Merge Conflicts (MDS Add-in for Excel). 

     SQL Master Data Services Team

  • Link
    Master Data Services SQL2016 CTP2.2(July) Release is public available
    Sherry_Li

    Please give it a try and let us know your feedback!

    SQL Server 2016 Community Technology Preview 2.2 is publicly released and the latest bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

    In CTP2.2 MDS introduced following changes:

    1. Custom Indexes

    You can create a non-clustered index on one attribute (single index) or on a list of attributes (composite index), in an entity, to help improve the query performance. For more information, see Custom Index (Master Data Services).

    2. Entity Sync Relationship

    You can share entity data between different models by creating an entity sync relationship. For more information, see Entity Sync Relationship (Master Data Services).

    3. Member Revision History

    A member revision history is recorded when a member is changed. You can rollback a revision history, as well as view and annotate revisions. Using the Log Retention Days property, you can specify how long historical data is retained. For more information, see Member Revision History (Master Data Services).

  • Link
    New release on MDS Excel add-in available for download
    Sherry_Li

    Hi, we are pleasured to announce the release of MDS Excel add-in. You can download it here:

    http://www.microsoft.com/en-us/download/details.aspx?id=42298

    This release includes a number of performance improvements – most users will see a 4x improvement when loading data from an MDS server, without any additional server or environment changes. For an additional performance increase (2-4x), you can enable Dynamic Content Compression in IIS.

    It works with both SQL12 or SQL14.  The installation will be in place upgrade so the users don't need to uninstall previous installation.  All the MDS connections will be preserved through the installation. 

    Please download the new version of Excel add-in.  Your feedback is welcome!

    Thanks,

    SQL MDS Team

  • Link
    Please Indicate "Mark as Answer" if a Post has Answered the Question
    edhickey

    While reading a reply to your question, you will notice a button with an icon that says "Mark as Answer."   Please select this button when a reply answers your question.

     

    There are several reasons to do this:

     

    • Our search engine weights Answered questions more highly. By marking Answers you increase the chances that others searching this forum will find the answer directly rather than re-posting the question.
    • You give credit to the hard working folks who answer your questions. This is peer to peer support, so recognition is our only reward. (Check out the Top Answerers in 30 Days chart at the bottom of the thread list to see who is currently answering questions.)
    • You help Microsoft to track the health of this forum. Our forum gets 'measured' based on how many unanswered questions are in it at any time and we work hard to keep those numbers to as low a level as possible. By marking answers, others get a more accurate understanding of how well (or badly) things are going on the forum.

     

    You can also vote "Yes" or "No" if the reply was helpful.

     

    Thank you!

     

    Ed Hickey