Neal Waterstreet

Changing The Case Of An Object in MDS

by Leave a Comment

One question that comes up from time to time is how to change the case of an object once it is created in MDS. This can be done for a variety of reasons and it’s really easy to do.

In this example we’ll change “Sampleattribute” to “SampleAttribute”.

1. Select the attribute and click “Edit”.
2. The “Sampleattribute” is displayed on the right.
3. Simply rename the “Name” and “DisplayName” to something different and click “Save”.
4. Change the “Name” and “DisplayName” to the correct value and click “Save”.
5. Now the attribute has the correct case.

Speaking at SQLSaturday #806 Charlotte 2018!

by Leave a Comment

On Saturday, October 20th, I’m speaking at SQLSaturday #806 Charlotte 2018! I’ll be presenting my session “Master Data Management with SQL Server 2016 MDS”. If you’re able to attend the event, stop by and say hello.

Want to know the position Master Data Management and MDS play in an organization’s overall data strategy? We’ll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We’ll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.

Atlanta Microsoft BI Group – September Meeting

by Leave a Comment

Please note the new meeting location below.

When: Tuesday, September 25, 2018 6:30-8:30 ET

Topic: Mastering data with Microsoft Master Data Services (MDS) for strategic advantage

Overview: Mastering customer, product, employee, job, and recipe data has become increasing important to companies focused on becoming data driven organization:

Mastering Data with Microsoft Master Data Services (MDS):

  • Data Modeling Strategy
  • Hierarchy Strategy and Management
  • Application-level transaction management
  • Bulk data movement
  • Security and Access
  • Microsoft’s MDS Direction

Other Strategies and Consideration for mastering data:

  • User Experience, Governance and Data Stewardship
  • Address, Person, and Email Standardization
  • Matching Records and Survivorship
  • Workflow and Event needs
  • Direct and real-time Application Integration

Speaker:  John Rossiter is a subject-matter expert in Master Data Management with a focus on strategy, governance, and process with twenty years of experience serving clients in multiple industries: high tech, retail, airline/aerospace, government (Federal, State, Municipal), consumer packaged goods, and financial services. John has successfully led large consulting projects, leveraging technology, process improvement, and change management to deliver a wide range of solutions, including Master Data Management, ERP system implementation, Supply Chain Management, and eCommerce.

Sponsor: Profisee is an Atlanta area base Master Data enterprise software company solely focused on master and reference data management with customers in the US, Canada, Europe, and Australia.

RSVP at http://atlantabi.pass.org/

When: Tuesday, September 25, 2018 6:30-8:30 ET

Where: Microsoft Technology Center, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA 30009 (https://binged.it/2KQLAPw)