Master Data Services Excel Add-in - allow change of Connection - by Mike Honey - Manga Solutions

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 773739 Comments
Status Closed Workarounds
Type Suggestion Repros 1
Opened 12/6/2012 5:36:24 PM
Access Restriction Public


Using the Master Data Services Excel Add-in, user establishes a connection, creates a table of data from an Entity and saves the Excel file.  If in the future they want to change the Connection (e.g. point to a different MDS server), there is no apparent way to acheive this.
Sign in to post a comment.
Posted by BI Monkey on 8/21/2013 at 7:41 PM
It would be also useful to change the connection to point at a different Version - we have been establishing templates so users can see only certain fields to simplify our complex data entry.

However once we lock down a version these templates are broken as we cannot point at the new version of the data.
Posted by Microsoft on 12/19/2012 at 10:02 PM
Hi Mike,
Thank you for your feedback and suggestion -- we do appreciate it! I am closing this issue as Won't-fix because we will not be able to make the design change in the SQL 2012 version of the MDS Excel add-in, but we will consider it for future work. Regards,
Posted by Megan Brooks on 12/8/2012 at 9:14 AM
Here is one thing you can do, although it is not the same as saving the Excel file itself and it is not at all convenient: You can save a query for the data that you want to see in Excel, and you can then export that query to an XML file. You can then, at a later time, edit the connection information in the XML file, re-import, and execute. When I did this, I created and exported yet another query using the new connection information and then copy/pasted just the connection elements from the new query XML to the old.