get relational DataSource for MDCatalog

Jan 24, 2012 at 2:32 PM

Hi Darren,

Is it possible to get the relational Datasource aka, Server and Database of a multidimensional Catalog? I've been fiddling around with Get-ASConnection but am not so sure it was build for that.



Jan 24, 2012 at 7:40 PM

No, get-ASConnection just returns an AMO connection to SSAS.

You can get the details of the relational data sources with something like the following:

$db = get-asdatabase "localhost\sql08" "Adventure Works DW 2008"
$db.datasources | select name, connectionstring