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

Closed

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

Type:	Suggestion
ID:	773739
Opened:	12/6/2012 5:36:24 PM
Access Restriction:	Public

Workaround(s)

view

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.

Details (expand)

English

Master Data Services

Allow changing of Connection details in existing Excel tables using MDS. This could work in a similar way to the Excel Pivot Table Tools / Options / Change Data Source button.

Improved Administration

Smooth the SDLC for MDS changes, e.g. Admin changes MDS structure in DEV, user changes MDS spreadsheets connected to DEV, Admin deploys changes to PROD, user changes MDS spreadsheet connections to PROD.

0 attachments

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.

Microsoft