Community > Blogs > Max-PIT> SQL-Server and PowerShell > November 2008 > Business Intelligence with PowerShell... (check this one)

Business Intelligence with PowerShell... (check this one)

During one of my projects at work I was asked if I can use PowerShell to extract data from our dimension and send it to application in another location. To some extend, I can use T-SQL, but I needed to find out if there were more solution built by someone. Well, I found one, but I'm sure that it for SSAS 2005 and looks promising.

Please check out "Darren Gosbell [MVP]" blog on his "PowerSSAS: a PowerShell provider for Analysis Services"... This is great stuff!

Download PowerSSAS

Posted: 11/29/2008 1:23:31 PM by Global Administrator | with 0 comments

Comments There are no comments on this post.

Title

In this blog section I will provide some valid samples currently use at my workplace. I'll be covering SQL Server version: 2000, 2005, and 2008. Also, I will post some information on SQLPS.exe.

Take a look at the three part series on:
1. Connecting to SQL Server
2. Executing a SQL Command (using "Delete from...")
3. Read/Display Data from SQL Server

l be posting more thing in the near future such as using SMO and doing some SQL admin operations.

Business Intelligence with PowerShell... (check this one)

Title

My favourite websites

Recent posts

Syndication

Post archive