Impala Integration Guides and Tutorials

Prepare, Blend, and Analyze Impala in Alteryx Designer (ODBC)

Alteryx Designer

Work with Live Impala Data in Alteryx Designer (Connect Cloud)

Amazon QuickSight

Build Interactive Dashboards from Impala Data in Amazon QuickSight

Amazon SageMaker

Integrate Live Impala data into Amazon SageMaker Canvas

Aqua Data Studio

Connect to Impala in Aqua Data Studio

AWS Databricks

Process & Analyze Impala Data in Databricks (AWS)

Azure Analysis Services

Model Impala Data Using Azure Analysis Services

Birst

Build Visualizations of Impala in Birst

BIRT

Design BIRT Reports on Impala

Clear Analytics

Build Charts with Impala in Clear Analytics

Cognos Analytics (On-Prem)

Analyze Impala Data in Cognos Analytics

DBxtra

Build Dashboards with Impala in DBxtra

Domo

Create Datasets from Impala in Domo Workbench

Dundas BI

Build Dashboards with Impala in Dundas BI

Excel (on Mac OS)

Work with Impala Data in MS Excel on Mac OS X

FineReport

Feed Impala into FineReport

Google Sheets

Access Live Impala Data in Google Sheets

IBM Cognos BI

Create Data Visualizations in Cognos BI with Impala

Infragistics Reveal

Analyze Impala Data in Infragistics Reval

JasperServer

Create Impala Reports on JasperReports Server

Jaspersoft BI Suite

Connect to Impala in Jaspersoft Studio

JReport Designer

Integrate with Impala in JReport Designer

Klipfolio

Create Impala-Connected Visualizations in Klipfolio

KNIME

Enable the Impala JDBC Driver in KNIME

LINQPad

Working with Impala in LINQPad

Looker

Analyze Impala Data in Looker

Looker Studio

Create Reports from Impala Data in Looker Studio

Metabase

Create Interactive Impala-Connected Metabase Dashboards

Microsoft Excel

Access Live Impala Data in Excel Desktop

Microsoft Excel for the Web

Access Live Impala Data in Excel for the Web

Microsoft SSAS

Build an OLAP Cube in SSAS from Impala

MicroStrategy

Connect to Live Impala Data in MicroStrategy through Connect Cloud

MicroStrategy

Use the CData JDBC Driver for Impala in MicroStrategy

Microstrategy Desktop

Use the CData JDBC Driver for Impala in MicroStrategy Desktop

Microstrategy Web

Use the CData JDBC Driver for Impala in MicroStrategy Web

Mode Analytics

Create Impala-Connected Visualizations in Mode

OBIEE

Impala Reporting in OBIEE with the Impala JDBC Driver

pandas

Use pandas to Visualize Impala in Python

Pentaho Report Designer

Integrate Impala in the Pentaho Report Designer

Power BI Desktop

Power BI

Author Power BI Reports on Real-Time Impala

Power BI Service

Visualize Live Impala Data in the Power BI Service

Power Pivot

Access Impala Data in Microsoft Power Pivot

Power Query

Access Impala Data in Microsoft Power Query

Qlik Cloud

Create Apps from Impala Data in Qlik Sense Cloud

QlikView

Connect to and Query Impala in QlikView over ODBC

Analyze Impala in R (JDBC)

Analyze Impala in R (ODBC)

RapidMiner

Connect to Impala in RapidMiner

Redash

Build Impala-Connected Dashboards in Redash

SAP Analytics Cloud

Analyze Impala Data in SAP Analytics Cloud

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

SAS

Use the CData ODBC Driver for Impala in SAS for Real-Time Reporting and Analytics

SAS JMP

Use the CData ODBC Driver for Impala in SAS JMP

SAS Viya

Analyze Live Impala Data in SAS Viya

Sisense

Visualize Live Impala in Sisense

Spago BI

Connect to Impala in SpagoBI

Tableau

Visualize Impala in Tableau Desktop

Tableau Cloud

Build Impala Visualizations in Tableau Cloud

Tableau Server

Tableau

Publish Impala-Connected Dashboards in Tableau Server

TIBCO Spotfire

Visualize Impala in TIBCO Spotfire through ADO.NET

TIBCO Spotfire

Visualize Impala Data in TIBCO Spotfire

TIBCO Spotfire Server

Operational Reporting on Impala from Spotfire Server

Visio

Link Visio Shapes to Impala

Zoho Analytics

Create Impala-Connected Dashboards in Zoho Analytics

Product	Technology	Article Title
Airbyte	Connect Cloud	Connect to Impala Data in Airbyte ELT Pipelines
Amazon Redshift	CData Sync	Automated Continuous Impala Replication to Amazon Redshift
Amazon S3	CData Sync	Automated Continuous Impala Replication to Amazon S3
Apache Airflow	JDBC	Bridge Impala Connectivity with Apache Airflow
Apache Camel	JDBC	Integrate with Impala using Apache Camel
Apache Cassandra	CData Sync	Automated Continuous Impala Replication to Apache Cassandra
Apache Kafka	CData Sync	Automated Continuous Impala Replication to Apache Kafka
Apache NiFi	JDBC	Bridge Impala Connectivity with Apache NiFi
Apache NiFi Batch Operations	JDBC	Perform Batch Operations with Impala Data in Apache NiFi
AWS Glue	Connect Cloud	Build ETL Jobs with Impala Data in AWS Glue Jobs
Azure Data Factory	Connect Cloud	Import Impala Data Using Azure Data Factory
Azure Data Lake	CData Sync	Automated Continuous Impala Replication to Azure Data Lake
Azure Synapse	CData Sync	Automated Continuous Impala Replication to Azure Synapse
BIML	SSIS	Use Biml to Build SSIS Tasks to Replicate Impala to SQL Server
CloverDX	JDBC	Connect to Impala in CloverDX (formerly CloverETL)
Couchbase	CData Sync	Automated Continuous Impala Replication to Couchbase
CSV	CData Sync	Automated Continuous Impala Replication to Local Delimited Files
Databricks	CData Sync	Automated Continuous Impala Replication to Databricks
FoxPro	ODBC	Work with Impala in FoxPro
Google AlloyDB	CData Sync	Automated Continuous Impala Replication to Google AlloyDB
Google BigQuery	CData Sync	Automated Continuous Impala Replication to Google BigQuery
Google Cloud SQL	CData Sync	Automated Continuous Impala Replication to Google Cloud SQL
Google Data Fusion	JDBC	Build Impala-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce Connect	CData Sync	Replicate Impala for Use in Salesforce Connect
HULFT Integrate	JDBC	Connect to Impala in HULFT Integrate
IBM DB2	CData Sync	Automated Continuous Impala Replication to IBM DB2
Informatica Cloud	JDBC	Integrate Impala in Your Informatica Cloud Instance
Informatica PowerCenter	JDBC	Create Informatica Mappings From/To a JDBC Data Source for Impala
Jaspersoft ETL	JDBC	Connect to Impala in Jaspersoft Studio
Microsoft Access	CData Sync	Automated Continuous Impala Replication to Microsoft Access
Microsoft Azure Tables	CData Sync	Automated Continuous Impala Replication to Azure SQL
Microsoft Excel	Excel	Transfer Data from Excel to Impala
Microsoft Power Automate	Connect Cloud	Build Impala-Connected Automated Tasks with Power Automate (Desktop)
MongoDB	CData Sync	Automated Continuous Impala Replication to MongoDB
MySQL	CData Sync	Automated Continuous Impala Replication to MySQL
Oracle Data Integrator	JDBC	ETL Impala in Oracle Data Integrator
Oracle Database	CData Sync	Automated Continuous Impala Replication to Oracle
petl	Python	Extract, Transform, and Load Impala in Python
PostgreSQL	CData Sync	Automated Continuous Impala Replication to PostgreSQL
Replicate to MySQL	PowerShell	Replicate Impala to MySQL with PowerShell
SAP HANA	CData Sync	Automated Continuous Impala Replication to SAP HANA
SingleStore	CData Sync	Automated Continuous Impala Replication to SingleStore
SnapLogic	JDBC	Integrate Impala with External Services using SnapLogic
Snowflake	CData Sync	Automated Continuous Impala Replication to Snowflake
SQL Server	CData Sync	Automated Continuous Impala Replication to SQL Server
SQL Server Linked Server	Connect Cloud	Connect to Impala Data as a SQL Server Linked Server
SQLite	CData Sync	Automated Continuous Impala Replication to SQLite
Talend	JDBC	Connect to Impala and Transfer Data in Talend
UiPath Studio	ODBC	Create an RPA Flow that Connects to Impala in UiPath Studio
Vertica	CData Sync	Automated Continuous Impala Replication to a Vertica Database

Product

Technology

Article Title

Airbyte

Connect to Impala Data in Airbyte ELT Pipelines

Amazon Redshift

Automated Continuous Impala Replication to Amazon Redshift

Amazon S3

Automated Continuous Impala Replication to Amazon S3

Apache Airflow

Bridge Impala Connectivity with Apache Airflow

Apache Camel

Integrate with Impala using Apache Camel

Apache Cassandra

Automated Continuous Impala Replication to Apache Cassandra

Apache Kafka

Automated Continuous Impala Replication to Apache Kafka

Apache NiFi

Bridge Impala Connectivity with Apache NiFi

Apache NiFi Batch Operations

Perform Batch Operations with Impala Data in Apache NiFi

AWS Glue

Build ETL Jobs with Impala Data in AWS Glue Jobs

Azure Data Factory

Import Impala Data Using Azure Data Factory

Azure Data Lake

Automated Continuous Impala Replication to Azure Data Lake

Azure Synapse

Automated Continuous Impala Replication to Azure Synapse

BIML

SSIS

Use Biml to Build SSIS Tasks to Replicate Impala to SQL Server

CloverDX

Connect to Impala in CloverDX (formerly CloverETL)

Couchbase

Automated Continuous Impala Replication to Couchbase

CSV

Automated Continuous Impala Replication to Local Delimited Files

Databricks

Automated Continuous Impala Replication to Databricks

FoxPro

Work with Impala in FoxPro

Google AlloyDB

Automated Continuous Impala Replication to Google AlloyDB

Google BigQuery

Automated Continuous Impala Replication to Google BigQuery

Google Cloud SQL

Automated Continuous Impala Replication to Google Cloud SQL

Google Data Fusion

Build Impala-Connected ETL Processes in Google Data Fusion

Heroku / Salesforce Connect

Replicate Impala for Use in Salesforce Connect

HULFT Integrate

Connect to Impala in HULFT Integrate

IBM DB2

Automated Continuous Impala Replication to IBM DB2

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

Excel

Transfer Data from Excel to Impala

Microsoft Power Automate

Build Impala-Connected Automated Tasks with Power Automate (Desktop)

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

petl

Extract, Transform, and Load Impala in Python

PostgreSQL

Automated Continuous Impala Replication to PostgreSQL

Replicate to MySQL

PowerShell

Replicate Impala to MySQL with PowerShell

SAP HANA

Automated Continuous Impala Replication to SAP HANA

SingleStore

Automated Continuous Impala Replication to SingleStore

SnapLogic

Integrate Impala with External Services using SnapLogic

Snowflake

Automated Continuous Impala Replication to Snowflake

SQL Server

Automated Continuous Impala Replication to SQL Server

SQL Server Linked Server

Connect to Impala Data as a SQL Server Linked 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

Vertica

Automated Continuous Impala Replication to a Vertica Database

Product	Technology	Article Title
Access Linked Tables	ODBC	Update Impala with a Microsoft Access Linked Table
APOS Live Data Gateway	JDBC	Build Semantic Layer Views for Impala (JDBC)
APOS Live Data Gateway	Connect Cloud	Build Semantic Layer Views for Impala Data (Connect Cloud)
Denodo	JDBC	Create A Data Source for Impala in Denodo Platform
Dremio	JDBC	Connect to Impala as an External Source in Dremio
MySQL Federated Tables	ODBC	Connect to Impala as Federated Tables in MySQL
Oracle Database	ODBC	Access Impala as a Remote Oracle Database
PostgreSQL FDW	JDBC	A PostgreSQL Interface for Impala
Salesforce Connect	Connect Cloud	Edit and Search Impala External Objects in Salesforce Connect
Salesforce Connect	Connect Server	Edit and Search Impala External Objects in Salesforce Connect
SQL Server Linked Servers	ODBC	Connect to Impala as a Linked Server
SQL Server PolyBase	Connect Cloud	Connect to Impala Data using PolyBase with Connect Cloud
SQL Server PolyBase	ODBC	Connect to Impala as an External Data Source using PolyBase
TIBCO Data Virtualization	TIBCO DV	Access Live Impala Data in TIBCO Data Virtualization

Product

Technology

Article Title

Access Linked Tables

Update Impala with a Microsoft Access Linked Table

APOS Live Data Gateway

Build Semantic Layer Views for Impala (JDBC)

APOS Live Data Gateway

Build Semantic Layer Views for Impala Data (Connect Cloud)

Denodo

Create A Data Source for Impala in Denodo Platform

Dremio

Connect to Impala as an External Source in Dremio

MySQL Federated Tables

Connect to Impala as Federated Tables in MySQL

Oracle Database

Access Impala as a Remote Oracle Database

PostgreSQL FDW

A PostgreSQL Interface for Impala

Salesforce Connect

Edit and Search Impala External Objects in Salesforce Connect

Salesforce Connect

Edit and Search Impala External Objects in Salesforce Connect

SQL Server Linked Servers

Connect to Impala as a Linked Server

SQL Server PolyBase

Connect to Impala Data using PolyBase with Connect Cloud

SQL Server PolyBase

Connect to Impala as an External Data Source using PolyBase

TIBCO Data Virtualization

TIBCO DV

Access Live Impala Data in TIBCO Data Virtualization

Product	Technology	Article Title
.NET Charts	ADO.NET	DataBind Charts to Impala
.NET QueryBuilder	ODBC	Rapidly Develop Impala-Driven Apps with Active Query Builder
Angular JS	Connect Server	Using AngularJS to Build Dynamic Web Pages with Impala
Apache Spark	JDBC	Work with Impala in Apache Spark Using SQL
AppSheet	Connect Cloud	Create Impala-Connected Business Apps in AppSheet
Bubble.io	Connect Cloud	Build Impala-Connected Apps in Bubble
C++Builder	ODBC	DataBind Controls to Impala Data in C++Builder
Choreo	Connect Cloud	Build Custom Apps on Impala Data in Choreo
ColdFusion	JDBC	Query Impala in ColdFusion Using JDBC
ColdFusion	ODBC	Query Impala in ColdFusion Using ODBC
Dash	Python	Use Dash & Python to Build Web Apps on Impala
Delphi	ODBC	DataBind Controls to Impala Data in Delphi
DevExpress	ADO.NET	DataBind Impala to the DevExpress Data Grid
EF - Code First	ADO.NET	Access Impala with Entity Framework 6
EF - LINQ	ADO.NET	LINQ to Impala
EF - MVC	ADO.NET	Build MVC Applications with Connectivity to Impala
Filemaker Pro	ODBC	Bidirectional Access to Impala from FileMaker Pro
Filemaker Pro (on Mac)	JDBC	Bidirectional Access to Impala from FileMaker Pro (on Mac)
Go	ODBC	Write a Simple Go Application to work with Impala on Linux
Google Apps Script	Connect Cloud	Connect to Impala Data in Google Apps Script
Hibernate	JDBC	Object-Relational Mapping (ORM) with Impala Entities in Java
IntelliJ	JDBC	Connect to Impala in IntelliJ
JBoss	JDBC	Connect to Impala from a Connection Pool in JBoss
JDBI	JDBC	Create a Data Access Object for Impala using JDBI
JRuby	JDBC	Connect to Impala in JRuby
Mendix	Connect Cloud	Build Impala-Connected Apps in Mendix
Microsoft Power Apps	Connect Cloud	Integrate Live Impala Data into Custom Business Apps Built in Power Apps
NodeJS	Connect Cloud	Query Impala Data in Node.js (via Connect Cloud)
NodeJS	ODBC	Query Impala through ODBC in Node.js
OutSystems	Connect Cloud	Create Impala-Connected Enterprise Applications in OutSystems
PHP	Connect Server	Access Impala in PHP through Connect Server
PHP	ODBC	Natively Connect to Impala in PHP
PowerBuilder	ADO.NET	Connect to Impala from PowerBuilder
PowerShell	PowerShell	Pipe Impala to CSV in PowerShell
PyCharm	ODBC	Using the CData ODBC Driver for Impala in PyCharm
Python	ODBC	Connect to Impala in Python on Linux/UNIX
React	Connect Server	Build Dynamic React Apps with Impala Data
Ruby	ODBC	Connect to Impala in Ruby
RunMyProcess	Connect Cloud	Connect to Impala Data in RunMyProcess
RunMyProcess DSEC	JDBC	Connect to Impala in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5	Connect Server	Integrate Real-Time Access to Impala in SAPUI5 MVC Apps
Servoy	JDBC	Build Impala-Connected Apps in Servoy
Spring Boot	JDBC	Access Live Impala Data in Spring Boot Apps
SQLAlchemy	Python	Use SQLAlchemy ORMs to Access Impala in Python
Tomcat	JDBC	Configure the CData JDBC Driver for Impala in a Connection Pool in Tomcat
Unqork	Connect Cloud	Create Impala-Connected Applications in Unqork
VCL App (RAD Studio)	ODBC	Build a Simple VCL Application for Impala
WebLogic	JDBC	Connect to Impala from a Connection Pool in WebLogic

Product

Technology

Article Title

.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

AppSheet

Create Impala-Connected Business Apps in AppSheet

Bubble.io

Build Impala-Connected Apps in Bubble

C++Builder

DataBind Controls to Impala Data in C++Builder

Choreo

Build Custom Apps on Impala Data in Choreo

ColdFusion

Query Impala in ColdFusion Using JDBC

ColdFusion

Query Impala in ColdFusion Using ODBC

Dash

Use Dash & Python to Build Web Apps on Impala

Delphi

DataBind Controls to Impala Data in Delphi

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

Filemaker Pro (on Mac)

Bidirectional Access to Impala from FileMaker Pro (on Mac)

Write a Simple Go Application to work with Impala on Linux

Google Apps Script

Connect to Impala Data 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

Mendix

Build Impala-Connected Apps in Mendix

Microsoft Power Apps

Integrate Live Impala Data into Custom Business Apps Built in Power Apps

NodeJS

Query Impala Data in Node.js (via Connect Cloud)

NodeJS

Query Impala through ODBC in Node.js

OutSystems

Create Impala-Connected Enterprise Applications in OutSystems

PHP

Access Impala in PHP through Connect Server

PHP

Natively Connect to Impala in PHP

PowerBuilder

Connect to Impala from PowerBuilder

PowerShell

Pipe Impala to CSV in PowerShell

PyCharm

Using the CData ODBC Driver for Impala in PyCharm

Python

Connect to Impala in Python on Linux/UNIX

React

Build Dynamic React Apps with Impala Data

Ruby

Connect to Impala in Ruby

RunMyProcess

Connect to Impala Data in RunMyProcess

RunMyProcess DSEC

Connect to Impala in DigitalSuite Studio through RunMyProcess DSEC

SAP UI5

Integrate Real-Time Access to Impala in SAPUI5 MVC Apps

Servoy

Build Impala-Connected Apps in Servoy

Spring Boot

Access Live Impala Data in Spring Boot Apps

SQLAlchemy

Use SQLAlchemy ORMs to Access Impala in Python

Tomcat

Configure the CData JDBC Driver for Impala in a Connection Pool in Tomcat

Unqork

Create Impala-Connected Applications in Unqork

VCL App (RAD Studio)

Build a Simple VCL Application for Impala

WebLogic

Connect to Impala from a Connection Pool in WebLogic

Product	Technology	Article Title
Apache Solr	JDBC	Import Impala Data into Apache Solr
DB Artisan	JDBC	Manage Impala in DBArtisan as a JDBC Source
DB Artisan	ODBC	Connect to Impala in DBArtisan
DBeaver	JDBC	Connect to Impala in DBeaver
DbVisualizer	JDBC	Connect to Impala in DBVisualizer
Informatica Enterprise Data Catalog	JDBC	Add Impala to Informatica Enterprise Data Catalog
MySQL Workbench	Connect Server	Query Impala Data in MySQL Workbench (Connect Server)
MySQL Workbench	ODBC	Query Impala in MySQL Workbench (ODBC)
QuerySurge	JDBC	Validate Impala Data with QuerySurge
RazorSQL	JDBC	Connect to Impala in RazorSQL
SQuirreL	JDBC	Connect to Impala in Squirrel SQL Client

Product

Technology

Article Title

Apache Solr

Import Impala Data into Apache Solr

DB Artisan

Manage Impala in DBArtisan as a JDBC Source

DB Artisan

Connect to Impala in DBArtisan

DBeaver

Connect to Impala in DBeaver

DbVisualizer

Connect to Impala in DBVisualizer

Informatica Enterprise Data Catalog

Add Impala to Informatica Enterprise Data Catalog

MySQL Workbench

Query Impala Data in MySQL Workbench (Connect Server)

MySQL Workbench

Query Impala in MySQL Workbench (ODBC)

QuerySurge

Validate Impala Data with QuerySurge

RazorSQL

Connect to Impala in RazorSQL

SQuirreL

Connect to Impala in Squirrel SQL Client

Product	Technology	Article Title
MuleSoft Anypoint	JDBC	Access Impala in Anypoint Using SQL
Nintex Workflow Cloud	Connect Cloud	Build Impala-Connected Workflows in Nintex
Power Automate	Connect Cloud	Integrate Impala Data into Power Automate Automated Tasks
SSIS Export	SSIS	Export Data from SQL Server to Impala through SSIS
SSIS Import	SSIS	Import Impala Data into SQL Server using SSIS
SSIS Lookup	SSIS	Insert New or Update Existing Impala Records from SQL Server

Product

Technology

Article Title

MuleSoft Anypoint

Access Impala in Anypoint Using SQL

Nintex Workflow Cloud

Build Impala-Connected Workflows in Nintex

Power Automate