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
 Included in PowerShell Subscriptions: 125+ Cmdlets for real-time data access.

Access SQL Analysis Services data from PowerShell!

The SQL Analysis Services Data Cmdlets provide the easiest way to connect with SQL Server 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 beta