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.


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

Description

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,
Lynn
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.