Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Powerpivot - Using SQL Server Synonyms Expand / Collapse
Author
Message
Posted Thursday, June 19, 2014 7:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, November 3, 2014 9:24 AM
Points: 291, Visits: 101
Hello,

I have about 50 user views that are consumed by customers via PowerPivot.
They want to completely change the naming convention of the views.
To accomplish that, and prevent the failure of previously created Excel PowerPivot extracts, I thought of using SQL Server Synonyms.

To my surprise, it appears that PowerPivot is unable to consume SQL Server Synonyms.
Upon selecting SQL Server Objects, it would just propose "Select Tables and Views", not showing my synonyms.

Can you tell me if it is possible for PowerPivot to consume Synonyms ?
If not, do you have any other suggestion to change a Naming Convention without breaking anything ?

Thanks,

Vincent
Post #1583837
Posted Monday, June 23, 2014 12:59 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Wednesday, December 24, 2014 6:46 AM
Points: 13,646, Visits: 11,524
You could just define new views on top of the other ones.
(which is not ideal of course)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1584918
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse