This project has moved and is read-only. For the latest updates, please go here.

get relational DataSource for MDCatalog

Jan 24, 2012 at 3: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 8: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