Sample Header Ad - 728x90

How to query SSAS Datasource ConnectionString Properties

0 votes
0 answers
536 views
I've been asked to audit the Connection strings used by our SSAS OLAP cubes and where they are *sourcing data from*. I can view the properties manually and can even script them: > Provider=SQLNCLI11.1;Data Source=DEV-SERVER;Integrated > Security=SSPI;Initial Catalog=EnviroDataMart But I can't figure out how to query them. Can this be done with SQL or MDX?
Asked by Sir Swears-a-lot (3253 rep)
Oct 30, 2018, 03:15 AM
Last activity: Oct 30, 2018, 03:49 AM