How to connect Microsoft SQL Server Analysis Services (SSAS) to Pentaho

Discover how to connect Microsoft SQL Server Analysis Services (SSAS) to Pentaho and how to integrate Microsoft SQL Server Analysis Services (SSAS) with other data sources to build an organization-wide data model.

WITH DATA VIRTUALITY PIPES
Replicate Microsoft SQL Server Analysis Services (SSAS) into a target storage and analyze it with Pentaho.
How to connect Microsoft SQL Server Analysis Services (SSAS) to Pentaho with Pipes


About Microsoft SQL Server Analysis Services (SSAS)

Microsoft SQL Server Analysis Services, SSAS, is an OLAP and data mining tool in Microsoft SQL Server. SSAS is used by organizations as a tool to analyze and understand information that may be spread across multiple databases or in different tables or files. Analysis Services provides a group of OLAP and data mining functions.

About Pentaho

Pentaho provides Business Intellingence solutions with a community and an enterprise edition. Users can create reportings and factful dashboards as well as run data mining and extract, transform, load (ETL) processes with Pentaho.

MOVE YOUR DATA WITH PIPES

Pipes allows you to connect to Microsoft SQL Server Analysis Services (SSAS), Pentaho and more than 200 other cloud services and databases. Automate your data workflows with data pipelines.

DATA VIRTUALITY OFFERS TWO PIPES SOLUTIONS

depending on your needs.

Pipes

Easy and reliable data replication in the cloud

Pipes enables you to move data from any data source to your target storage or data warehouse on schedule. Integrate your data with just a few clicks and without any coding.

Pipes Professional

Advanced data replication hosted in the cloud or on-premises

Pipes Professional enables you to transform and model your data with SQL before replication. Customize your data pipelines and build data models across sources in 80% less time.

Pipes Professional features include:

  • SQL Modelling Layer
  • Complex Replication Types
  • Advanced Jobs & Schedules
  • Metadata Repositories
  • Custom Extraction Definitions
  • Job Dependencies
  • Multiple Target Storages
  • Data Federation Features
  • Custom Job Triggers
Your future with automated data workflows is only a few clicks away.