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

ETL, Replication, & Warehousing



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

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

Popular Data Management Tool Integrations




Developer Tools & Technologies



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


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