Connect to live Apache Spark from BI, analytics, and reporting tools through bi-directional data drivers. Maps SQL to Spark SQL


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 Spark data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Spark 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 Spark in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from Spark in Amazon QuickSight Aqua Data Studio: Connect to Spark in Aqua Data Studio Birst: Build Visualizations of Spark in Birst BIRT: Design BIRT Reports on Spark Clear Analytics: Build Charts with Spark in Clear Analytics Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula DBxtra: Build Dashboards with Spark in DBxtra Domo: Create Datasets from Spark in Domo Workbench Dundas BI: Build Dashboards with Spark in Dundas BI FineReport: Feed Spark into FineReport Google Data Studio: Create Reports from Spark in Google Data Studio IBM Cognos BI: Create Data Visualizations in Cognos BI with Spark JasperServer: Create Spark Reports on JasperReports Server Jaspersoft BI Suite: Connect to Spark in Jaspersoft Studio JReport Designer: Integrate with Spark in JReport Designer KNIME: Enable the Spark JDBC Driver in KNIME LINQPad: Working with Spark in LINQPad Power BI Desktop: Author Power BI Reports on Real-Time Spark Power BI Online: Visualize Live Spark in the Power BI Service Microsoft SSAS: Build an OLAP Cube in SSAS from Spark MicroStrategy: Use the CData JDBC Driver for Spark in MicroStrategy OBIEE: Spark Reporting in OBIEE with the Spark JDBC Driver Pentaho Report Designer: Integrate Spark in the Pentaho Report Designer QlikView: Connect to and Query Spark in QlikView over ODBC R: Analyze Spark in R RapidMiner : Connect to Spark in RapidMiner SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Spark SAP Crystal Reports: Publish Reports with Spark in Crystal Reports SAP Lumira: Consume Spark OData Feeds in SAP Lumira SAS: Use the CData ODBC Driver for Spark in SAS for Real-Time Reporting and Analytics Sisense: Visualize Live Spark in Sisense Spago BI: Connect to Spark in SpagoBI Tableau: Visualize Spark in Tableau Tableau Online: Build Spark Visualizations in Tableau Online Tableau Server: Publish and Share Spark Dashboards with Tableau Server TIBCO Spotfire: Visualize Spark in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on Spark from Spotfire Server Visio: Link Visio Shapes to Spark

ETL, Replication, & Warehousing



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

Connect your RDBMS or data warehouse with Spark 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 Spark Replication to Amazon Redshift Amazon S3: Automated Continuous Spark Replication to Amazon S3 Apache Cassandra: Automated Continuous Spark Replication to Apache Cassandra AWS Glue: Connect to Spark in AWS Glue Jobs Using JDBC BIML: Use Biml to Build SSIS Tasks to Replicate Spark to SQL Server CloverDX: Connect to Spark in CloverDX (formerly CloverETL) CSV: Automated Continuous Spark Replication to Local Delimited Files IBM DB2: Automated Continuous Spark Replication to IBM DB2 FoxPro: Work with Spark in FoxPro Google BigQuery: Automated Continuous Spark Replication to Google BigQuery Google Cloud SQL: Automated Continuous Spark Replication to Google Cloud SQL Google Data Fusion: Pipe Spark in Google Data Fusion Heroku / Salesforce Connect: Replicate Spark for Use in Salesforce Connect Informatica Cloud: Integrate Spark in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Spark Jaspersoft ETL: Connect to Spark in Jaspersoft Studio Microsoft Access: Automated Continuous Spark Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous Spark Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to Spark MongoDB: Automated Continuous Spark Replication to MongoDB MySQL: Automated Continuous Spark Replication to MySQL Oracle Data Integrator: ETL Spark in Oracle Data Integrator Oracle Database: Automated Continuous Spark Replication to Oracle PostgreSQL: Automated Continuous Spark Replication to PostgreSQL Replicate to CSV: Replicate Spark to MySQL with PowerShell Snowflake: Automated Continuous Spark Replication to Snowflake SQL Server: Automated Continuous Spark Replication to SQL Server SQLite: Automated Continuous Spark Replication to SQLite Talend: Connect to Spark and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to Spark in UiPath Studio

Data Management



By supporting popular database protocols like ODBC, JDBC, and ADO.NET, as well as wire-protocol interfaces for SQL Server and MySQL, it is easy to connect to and manage Spark data from a wide range of database management applications.

Popular Data Management Tool Integrations




Developer Tools & Technologies



The easiest way to integrate with Spark from anywhere. Our Spark drivers offer a data-centric model for Spark 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 Spark .NET QueryBuilder: Rapidly Develop Spark-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with Spark Apache Spark: Work with Spark in Apache Spark Using SQL Microsoft Azure Logic Apps: Trigger Spark IFTTT Flows in Azure App Service ColdFusion: Query Spark in ColdFusion DevExpress: DataBind Spark to the DevExpress Data Grid EF - Code First: Access Spark with Entity Framework 6 EF - LINQ: LINQ to Spark EF - MVC: Build MVC Applications with Connectivity to Spark Filemaker Pro: Bidirectional Access to Spark from FileMaker Pro Go: Write a Simple Go Application to work with Spark on Linux Google Apps Script: Connect to Spark in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with Spark Entities in Java IntelliJ: Connect to Spark in IntelliJ JBoss: Connect to Spark from a Connection Pool in JBoss JDBI: Create a Data Access Object for Spark using JDBI JRuby: Connect to Spark in JRuby NodeJS: Query Spark from Node.js NodeJS: Query Spark as a MySQL Database in Node.js PHP: Access Spark in PHP through the Cloud Hub PHP: Natively Connect to Spark in PHP PowerShell: Pipe Spark to CSV in PowerShell PowerBuilder: Connect to Spark from PowerBuilder PyCharm: Using the CData ODBC Driver for Spark in PyCharm Python: Connect to Spark in Python on Linux/UNIX Ruby: Connect to Spark in Ruby SAP UI5: Integrate Real-Time Access to Spark in SAPUI5 MVC Apps Tomcat: Configure the CData JDBC Driver for Spark in a Connection Pool in Tomcat VCL App (RAD Studio): Build a Simple VCL Application for Spark WebLogic: Connect to Spark from a Connection Pool in WebLogic


When Only the Best Spark 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: