Creating MDS Subscription View
Question
Answers
-
Hi Itachiara,
After created subscription view in Master Data Services, we now can connect to the MDS database using SQL Server Management Studio, you will see the newly created view in the database. Of course, you will need to have sufficient permissions directly in the database to connect and see the views.
Note that you may need to refresh the list of views if you already had the list open in Management Studio when you generated the new subscription view in MDS.
http://sqlblog.com/blogs/mds_team/archive/2010/03/03/publishing-master-data-with-subscription-views-part-1-the-basics.aspx
https://msdn.microsoft.com/en-us/library/jj819795(v=sql.120).aspxIf the issue persists, please provide use more detail information, so that we can make further analysis.
Regards,
Charlie Liao
TechNet Community Support
- Marked as answer by Itachiara Thursday, August 13, 2015 4:38 PM
All replies
-
Hi Itachiara,
After created subscription view in Master Data Services, we now can connect to the MDS database using SQL Server Management Studio, you will see the newly created view in the database. Of course, you will need to have sufficient permissions directly in the database to connect and see the views.
Note that you may need to refresh the list of views if you already had the list open in Management Studio when you generated the new subscription view in MDS.
http://sqlblog.com/blogs/mds_team/archive/2010/03/03/publishing-master-data-with-subscription-views-part-1-the-basics.aspx
https://msdn.microsoft.com/en-us/library/jj819795(v=sql.120).aspxIf the issue persists, please provide use more detail information, so that we can make further analysis.
Regards,
Charlie Liao
TechNet Community Support- Marked as answer by Itachiara Thursday, August 13, 2015 4:38 PM
