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




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 Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula 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 Data Studio: Create Reports from SQL Analysis Services in Google Data Studio IBM Cognos BI: Create Data Visualizations in Cognos BI with SQL Analysis Services 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 KNIME: Enable the SQL Analysis Services JDBC Driver in KNIME LINQPad: Working with SQL Analysis Services in LINQPad Power BI Desktop: Author Power BI Reports on Real-Time SQL Analysis Services Power BI Online: Visualize Live SQL Analysis Services in the Power BI Service Microsoft SSAS: Build an OLAP Cube in SSAS from SQL Analysis Services 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 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 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 SAP Lumira: Consume SQL Analysis Services OData Feeds in SAP Lumira 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: Visualize SQL Analysis Services in Tableau Tableau Online: Build SQL Analysis Services Visualizations in Tableau Online Tableau Server: Publish and Share SQL Analysis Services Dashboards with Tableau Server TIBCO Spotfire: Visualize SQL Analysis Services in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on SQL Analysis Services from Spotfire Server Visio: Link Visio Shapes to SQL Analysis Services

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 Cassandra: Automated Continuous SQL Analysis Services Replication to Apache Cassandra AWS Glue: Connect to SQL Analysis Services in AWS Glue Jobs Using JDBC BIML: Use Biml to Build SSIS Tasks to Replicate SQL Analysis Services to SQL Server CloverDX: Connect to SQL Analysis Services in CloverDX (formerly CloverETL) CSV: Automated Continuous SQL Analysis Services Replication to Local Delimited Files IBM DB2: Automated Continuous SQL Analysis Services Replication to IBM DB2 FoxPro: Work with SQL Analysis Services in FoxPro 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: Pipe SQL Analysis Services in Google Data Fusion Heroku / Salesforce Connect: Replicate SQL Analysis Services for Use in Salesforce Connect 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 Access: Automated Continuous SQL Analysis Services Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous SQL Analysis Services Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to SQL Analysis Services MongoDB: Automated Continuous SQL Analysis Services Replication to MongoDB MySQL: Automated Continuous SQL Analysis Services Replication to MySQL Oracle Data Integrator: ETL SQL Analysis Services in Oracle Data Integrator Oracle Database: Automated Continuous SQL Analysis Services Replication to Oracle PostgreSQL: Automated Continuous SQL Analysis Services Replication to PostgreSQL Replicate to CSV: PowerShell Scripting to Replicate SQL Analysis Services to MySQL Snowflake: Automated Continuous SQL Analysis Services Replication to Snowflake SQL Server: Automated Continuous SQL Analysis Services Replication to SQL Server SQLite: Automated Continuous SQL Analysis Services Replication to SQLite 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

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 Angular JS: Using AngularJS to Build Dynamic Web Pages with SQL Analysis Services Apache Spark: Work with SQL Analysis Services in Apache Spark Using SQL Microsoft Azure Logic Apps: Trigger SQL Analysis Services IFTTT Flows in Azure App Service 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 NodeJS: Query SQL Analysis Services from Node.js NodeJS: Query SQL Analysis Services as a MySQL Database in Node.js PHP: Access SQL Analysis Services in PHP through the Cloud Hub PHP: Natively Connect to SQL Analysis Services in PHP PowerShell: Pipe SQL Analysis Services to CSV in PowerShell 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 SAP UI5: Integrate Real-Time Access to SQL Analysis Services in SAPUI5 MVC Apps Tomcat: Configure the CData JDBC Driver for SQL Analysis Services in a Connection Pool in Tomcat VCL App (RAD Studio): Build a Simple VCL Application for SQL Analysis Services 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: