SQL Analysis Services
 

Connect to SQL Analysis Services data from other reporting tools, databases, and custom applications through standards-based drivers.


Integrate with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


"Excellent stuff. I am finally getting the hang of this and it is brilliant may I add!"

- Mark Couvaras, General Manager, Databarracks



Other Database Technologies

Other Database Drivers



Connect to SQL Analysis Services Data from Anywhere!

Easily access live SQL Analysis Services data from BI, Analytics, Reporting, ETL, & Custom Apps.







SQL Analysis Services Integration Guides and Tutorials

BI & Analytics


Our drivers offer the fastest and easiest way to connect real-time SQL Analysis Services data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to SQL Analysis Services data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations


Alteryx Designer: Prepare, Blend, and Analyze SQL Analysis Services in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from SQL Analysis Services in Amazon QuickSight Aqua Data Studio: Connect to SQL Analysis Services in Aqua Data Studio Birst: Build Visualizations of SQL Analysis Services in Birst BIRT: Design BIRT Reports on SQL Analysis Services Clear Analytics: Build Charts with SQL Analysis Services in Clear Analytics DBxtra: Build Dashboards with SQL Analysis Services in DBxtra Domo: Create Datasets from SQL Analysis Services in Domo Workbench Dundas BI: Build Dashboards with SQL Analysis Services in Dundas BI FineReport: Feed SQL Analysis Services into FineReport Google Sheets: Access Live SQL Analysis Services in Google Sheets IBM Cognos BI: Create Data Visualizations in Cognos BI with SQL Analysis Services Infragistics Reveal: Analyze SQL Analysis Services Data in Infragistics Reval JasperServer: Create SQL Analysis Services Reports on JasperReports Server Jaspersoft BI Suite: Connect to SQL Analysis Services in Jaspersoft Studio JReport Designer: Integrate with SQL Analysis Services in JReport Designer Klipfolio: Create SQL Analysis Services-Connected Visualizations in Klipfolio KNIME: Enable the SQL Analysis Services JDBC Driver in KNIME LINQPad: Working with SQL Analysis Services in LINQPad Looker Studio: Create Reports from SQL Analysis Services in Looker Studio Metabase: Create Interactive SQL Analysis Services-Connected Metabase Dashboards Microsoft SSAS: Build an OLAP Cube in SSAS from SQL Analysis Services MicroStrategy: Connect to Live SQL Analysis Services in MicroStrategy through Connect Server MicroStrategy: Use the CData JDBC Driver for SQL Analysis Services in MicroStrategy OBIEE: SQL Analysis Services Reporting in OBIEE with the SQL Analysis Services JDBC Driver Pentaho Report Designer: Integrate SQL Analysis Services in the Pentaho Report Designer Power BI Service: Visualize Live SQL Analysis Services in the Power BI Service QlikView: Connect to and Query SQL Analysis Services in QlikView over ODBC R: Analyze SQL Analysis Services in R RapidMiner: Connect to SQL Analysis Services in RapidMiner SAP Analytics Cloud: Analyze SQL Analysis Services in SAP Analytics Cloud SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for SQL Analysis Services SAP Crystal Reports: Publish Reports with SQL Analysis Services in Crystal Reports SAS: Use the CData ODBC Driver for SQL Analysis Services in SAS for Real-Time Reporting and Analytics Sisense: Visualize Live SQL Analysis Services in Sisense Spago BI: Connect to SQL Analysis Services in SpagoBI Tableau Cloud: Build SQL Analysis Services Visualizations in Tableau Cloud TIBCO Spotfire Server: Operational Reporting on SQL Analysis Services from Spotfire Server TIBCO Spotfire: Visualize SQL Analysis Services in TIBCO Spotfire through ADO.NET

ETL, Replication, & Warehousing


From drivers and adapters that extend your favorite ETL tools with SQL Analysis Services connectivity to ETL/ELT tools for replication — our SQL Analysis Services integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with SQL Analysis Services to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.


Popular Data Warehousing Integrations


Amazon Redshift: Automated Continuous SQL Analysis Services Replication to Amazon Redshift Amazon S3: Automated Continuous SQL Analysis Services Replication to Amazon S3 Apache Camel: Integrate with SQL Analysis Services using Apache Camel Apache NiFi: Bridge SQL Analysis Services Connectivity with Apache NiFi CloverDX: Connect to SQL Analysis Services in CloverDX (formerly CloverETL) Databricks: Automated Continuous SQL Analysis Services Replication to Databricks FoxPro: Work with SQL Analysis Services in FoxPro Google AlloyDB: Automated Continuous SQL Analysis Services Replication to Google AlloyDB Google BigQuery: Automated Continuous SQL Analysis Services Replication to Google BigQuery Google Cloud SQL: Automated Continuous SQL Analysis Services Replication to Google Cloud SQL Google Data Fusion: Build SQL Analysis Services-Connected ETL Processes in Google Data Fusion HULFT Integrate: Connect to SQL Analysis Services in HULFT Integrate Informatica Cloud: Integrate SQL Analysis Services in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for SQL Analysis Services Jaspersoft ETL: Connect to SQL Analysis Services in Jaspersoft Studio Microsoft Power Automate: Build SQL Analysis Services-Connected Automated Tasks with Power Automate (Desktop) Oracle Data Integrator: ETL SQL Analysis Services in Oracle Data Integrator SingleStore: Automated Continuous SQL Analysis Services Replication to SingleStore SnapLogic: Integrate SQL Analysis Services with External Services using SnapLogic Snowflake: Automated Continuous SQL Analysis Services Replication to Snowflake SQL Server Linked Server: Connect to SQL Analysis Services as a SQL Server Linked Server Talend: Connect to SQL Analysis Services and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to SQL Analysis Services in UiPath Studio Vertica: Automated Continuous SQL Analysis Services Replication to a Vertica Database

Workflow & Automation Tools


Connect to SQL Analysis Services from popular data migration, ESB, iPaaS, and BPM tools.

Our drivers and adapters provide straightforward access to SQL Analysis Services data from popular applications like BizTalk, MuleSoft, SQL SSIS, Microsoft Flow, Power Apps, Talend, and many more.

Popular Workflow & Automation Tool Integrations


MuleSoft Anypoint: Access SQL Analysis Services in Anypoint Using SQL Power Automate: Integrate SQL Analysis Services into Power Automate Automated Tasks

Developer Tools & Technologies


The easiest way to integrate with SQL Analysis Services from anywhere. Our SQL Analysis Services drivers offer a data-centric model for SQL Analysis Services that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:



Popular Developer Integrations


.NET Charts: DataBind Charts to SQL Analysis Services .NET QueryBuilder: Rapidly Develop SQL Analysis Services-Driven Apps with Active Query Builder Apache Spark: Work with SQL Analysis Services in Apache Spark Using SQL AppSheet: Create SQL Analysis Services-Connected Business Apps in AppSheet ColdFusion: Query SQL Analysis Services in ColdFusion DevExpress: DataBind SQL Analysis Services to the DevExpress Data Grid EF - Code First: Access SQL Analysis Services with Entity Framework 6 EF - LINQ: LINQ to SQL Analysis Services EF - MVC: Build MVC Applications with Connectivity to SQL Analysis Services Filemaker Pro: Bidirectional Access to SQL Analysis Services from FileMaker Pro Go: Write a Simple Go Application to work with SQL Analysis Services on Linux Google Apps Script: Connect to SQL Analysis Services in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with SQL Analysis Services Entities in Java IntelliJ: Connect to SQL Analysis Services in IntelliJ JBoss: Connect to SQL Analysis Services from a Connection Pool in JBoss JDBI: Create a Data Access Object for SQL Analysis Services using JDBI JRuby: Connect to SQL Analysis Services in JRuby Microsoft Power Apps: Integrate Live SQL Analysis Services into Custom Business Apps Built in Power Apps NodeJS: Query SQL Analysis Services in Node.js (via Connect Server) NodeJS: Query SQL Analysis Services through ODBC in Node.js PHP: Natively Connect to SQL Analysis Services in PHP PowerBuilder: Connect to SQL Analysis Services from PowerBuilder PyCharm: Using the CData ODBC Driver for SQL Analysis Services in PyCharm Python: Connect to SQL Analysis Services in Python on Linux/UNIX Ruby: Connect to SQL Analysis Services in Ruby RunMyProcess: Connect to SQL Analysis Services in RunMyProcess Servoy: Build SQL Analysis Services-Connected Apps in Servoy Tomcat: Configure the CData JDBC Driver for SQL Analysis Services in a Connection Pool in Tomcat Unqork: Create SQL Analysis Services-Connected Applications in Unqork WebLogic: Connect to SQL Analysis Services from a Connection Pool in WebLogic


When Only the Best SQL Analysis Services Drivers Will Do

See what customers have to say about our products and support.





Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below:

Using the SQL Analysis Services Drivers