SQL Analysis Services PowerShell Cmdlets

An easy-to-use set of PowerShell Cmdlets offering real-time access to SQL Analysis Services. The Cmdlets allow users to easily connect to live data - just like working with SQL server.

  • Easy-to-use Cmdlets with a simple SQL interface to live SQL Analysis Services data.
  • Connect to SQL Analysis Services report data from PowerShell scripts.
  • Easily pipe data into and out-of flat-files, databases, and other data stores for archival, back-up, and synchronization.

  download beta
SQL Analysis Services PowerShell Cmdlets
 PowerShell Subscriptions: 125+ Cmdlets for data integration.
   
PS C:\> Invoke-SSAS -Connection $conn -Query "SELECT * FROM SSASData" | Export-Csv c:\SSASData.csv

Access SQL Analysis Services data from PowerShell!

The SQL Analysis Services Data Cmdlets provide the easiest way to connect with SQL Analysis Services data from the command-line. The Cmdlets leverage a straightforward design, similar to the Microsoft SQL Server Database Engine Cmdlets, that makes it easy to import, export, backup, analyze, transform, & connect-to your SQL Analysis Services data.

Command-line SQL Analysis Services Data Integration


The SQL Analysis Services Cmdlets offer a simple Transact-SQL interface for connecting with data in real time from Microsoft PowerShell. The SQL Analysis Services Cmdlets make it easy to:

SQL Analysis Services Import/Export

Pipe data from SQL Analysis Services into and out-of flat-files, databases, and other data stores for archival, back-up, and synchronization.

Clean & Normalize Data

Use PowerShell scripting to normalize and/or de-duplicate SQL Analysis Services Data. Easily interact with real-time data.

Automate Integration Tasks

Connect scripts with scheduling Apps (like the windows scheduler) to automate common integration tasks.






Download SQL Analysis Services Cmdlets Now


Ready to get started? Download the a free 30-day trial of the CData Cmdlets for SQL Analysis Services and see how easy it is to connect to SQL Analysis Services from the command-line.



  download beta