Home Dashboard Directory Help

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


 as Won't Fix Help for as Won't Fix

Sign in
to vote
Type: Suggestion
ID: 773739
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.
Sign in to post a workaround.