Elasticsearch Integration Guides and Tutorials



A list of guides and tutorials for connecting to and working with live Elasticsearch data.

CData Software's connectivity tools enable users to connect directly to live Elasticsearch data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live Elasticsearch data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze Elasticsearch in Alteryx Designer (ODBC)
Alteryx DesignerConnect CloudWork with Live Elasticsearch Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from Elasticsearch Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live Elasticsearch data into Amazon SageMaker Canvas
Aqua Data StudioJDBCConnect to Elasticsearch in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Elasticsearch Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel Elasticsearch Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of Elasticsearch in Birst
BIRTJDBCDesign BIRT Reports on Elasticsearch
Clear AnalyticsODBCBuild Charts with Elasticsearch in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze Elasticsearch Data in Cognos Analytics
DBxtraODBCBuild Dashboards with Elasticsearch in DBxtra
DomoODBCCreate Datasets from Elasticsearch in Domo Workbench
Dundas BIODBCBuild Dashboards with Elasticsearch in Dundas BI
Excel (on Mac OS)ODBCWork with Elasticsearch Data in MS Excel on Mac OS X
FineReportJDBCFeed Elasticsearch into FineReport
Google SheetsConnect CloudAccess Live Elasticsearch Data in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Elasticsearch
Infragistics RevealConnect CloudAnalyze Elasticsearch Data in Infragistics Reval
JasperServerJDBCCreate Elasticsearch Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Elasticsearch in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Elasticsearch in JReport Designer
KlipfolioConnect CloudCreate Elasticsearch-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Elasticsearch JDBC Driver in KNIME
LINQPadADO.NETWorking with Elasticsearch in LINQPad
LookerConnect CloudAnalyze Elasticsearch Data in Looker
Looker StudioConnect CloudCreate Reports from Elasticsearch Data in Looker Studio
MetabaseConnect CloudCreate Interactive Elasticsearch-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live Elasticsearch Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live Elasticsearch Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Elasticsearch
MicroStrategyConnect CloudConnect to Live Elasticsearch Data in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for Elasticsearch in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for Elasticsearch in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Elasticsearch in MicroStrategy Web
Mode AnalyticsConnect CloudCreate Elasticsearch-Connected Visualizations in Mode
OBIEEJDBCElasticsearch Reporting in OBIEE with the Elasticsearch JDBC Driver
pandasPythonUse pandas to Visualize Elasticsearch in Python
Pentaho Report DesignerJDBCIntegrate Elasticsearch in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Elasticsearch
Power BI ServiceConnect CloudVisualize Live Elasticsearch Data in the Power BI Service
Power PivotConnect CloudAccess Elasticsearch Data in Microsoft Power Pivot
Power QueryConnect CloudAccess Elasticsearch Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from Elasticsearch Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query Elasticsearch in QlikView over ODBC
RJDBCAnalyze Elasticsearch in R (JDBC)
RODBCAnalyze Elasticsearch in R (ODBC)
RapidMinerJDBCConnect to Elasticsearch in RapidMiner
RedashConnect CloudQuery, Visualize, and Share live Elasticsearch Data in Redash
SAP Analytics CloudConnect CloudAnalyze Elasticsearch Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Elasticsearch
SAP Crystal ReportsJDBCPublish Reports with Elasticsearch in Crystal Reports (JDBC)
SAP Crystal ReportsConnect CloudPublish Reports with Elasticsearch in Crystal Reports (Connect Cloud)
SASODBCUse the CData ODBC Driver for Elasticsearch in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for Elasticsearch in SAS JMP
SAS ViyaConnect CloudAnalyze Live Elasticsearch Data in SAS Viya
SisenseJDBCVisualize Live Elasticsearch in Sisense
Spago BIJDBCConnect to Elasticsearch in SpagoBI
TableauTableauVisualize Elasticsearch in Tableau Desktop
Tableau CloudConnect CloudBuild Elasticsearch Visualizations in Tableau Cloud
Tableau ServerTableauPublish Elasticsearch-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize Elasticsearch in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize Elasticsearch Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on Elasticsearch from Spotfire Server
VisioODBCLink Visio Shapes to Elasticsearch
Zoho AnalyticsConnect CloudCreate Elasticsearch-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to Elasticsearch Data in Airbyte ELT Pipelines
Amazon RedshiftCData SyncAutomated Continuous Elasticsearch Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous Elasticsearch Replication to Amazon S3
Apache AirflowJDBCBridge Elasticsearch Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with Elasticsearch using Apache Camel
Apache CassandraCData SyncAutomated Continuous Elasticsearch Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous Elasticsearch Replication to Apache Kafka
Apache NiFiJDBCBridge Elasticsearch Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with Elasticsearch Data in Apache NiFi
AWS GlueConnect CloudBuild ETL Jobs with Elasticsearch Data in AWS Glue Jobs
Azure Data FactoryConnect CloudImport Elasticsearch Data Using Azure Data Factory
Azure Data LakeCData SyncAutomated Continuous Elasticsearch Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous Elasticsearch Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Elasticsearch to SQL Server
CloverDXJDBCConnect to Elasticsearch in CloverDX (formerly CloverETL)
CouchbaseCData SyncAutomated Continuous Elasticsearch Replication to Couchbase
CSVCData SyncAutomated Continuous Elasticsearch Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous Elasticsearch Replication to Databricks
ETL ValidatorJDBCHow to Work with Elasticsearch in ETL Validator
FoxProODBCWork with Elasticsearch in FoxPro
Google AlloyDBCData SyncAutomated Continuous Elasticsearch Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous Elasticsearch Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous Elasticsearch Replication to Google Cloud SQL
Google Data FusionJDBCBuild Elasticsearch-Connected ETL Processes in Google Data Fusion
Google Data FusionJDBCBuild Pipelines with Live Elasticsearch Data in Google Cloud Data Fusion (CData Connect Cloud)
Heroku / Salesforce ConnectCData SyncReplicate Elasticsearch for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to Elasticsearch in HULFT Integrate
IBM DB2CData SyncAutomated Continuous Elasticsearch Replication to IBM DB2
Informatica CloudJDBCIntegrate Elasticsearch in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Elasticsearch
Jaspersoft ETLJDBCConnect to Elasticsearch in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous Elasticsearch Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous Elasticsearch Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to Elasticsearch
Microsoft Power AutomateConnect CloudBuild Elasticsearch-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous Elasticsearch Replication to MongoDB
MySQLCData SyncAutomated Continuous Elasticsearch Replication to MySQL
Oracle Data IntegratorJDBCETL Elasticsearch in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous Elasticsearch Replication to Oracle
petlPythonExtract, Transform, and Load Elasticsearch in Python
PostgreSQLCData SyncAutomated Continuous Elasticsearch Replication to PostgreSQL
Replicate to MySQLPowerShellReplicate Elasticsearch to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous Elasticsearch Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous Elasticsearch Replication to SingleStore
SnapLogicJDBCIntegrate Elasticsearch with External Services using SnapLogic (JDBC)
SnapLogicConnect CloudIntegration with Elasticsearch Data in SnapLogic (Connect Cloud)
SnowflakeCData SyncAutomated Continuous Elasticsearch Replication to Snowflake
SQL ServerCData SyncAutomated Continuous Elasticsearch Replication to SQL Server
SQL Server Linked ServerConnect CloudConnect to Elasticsearch Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous Elasticsearch Replication to SQLite
TalendJDBCConnect to Elasticsearch and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Elasticsearch in UiPath Studio
VerticaCData SyncAutomated Continuous Elasticsearch Replication to a Vertica Database

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
AWS LambdaJDBCAccess Live Elasticsearch Data in AWS Lambda
.NET ChartsADO.NETDataBind Charts to Elasticsearch
.NET QueryBuilderODBCRapidly Develop Elasticsearch-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with Elasticsearch
Apache SparkJDBCWork with Elasticsearch in Apache Spark Using SQL
AppSheetConnect CloudCreate Elasticsearch-Connected Business Apps in AppSheet
Bubble.ioConnect CloudBuild Elasticsearch-Connected Apps in Bubble
C++BuilderODBCDataBind Controls to Elasticsearch Data in C++Builder
ChoreoConnect CloudBuild Custom Apps on Elasticsearch Data in Choreo
ColdFusionJDBCQuery Elasticsearch in ColdFusion Using JDBC
ColdFusionODBCQuery Elasticsearch in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on Elasticsearch
DelphiODBCDataBind Controls to Elasticsearch Data in Delphi
DevExpressADO.NETDataBind Elasticsearch to the DevExpress Data Grid
EF - Code FirstADO.NETAccess Elasticsearch with Entity Framework 6
EF - LINQADO.NETLINQ to Elasticsearch
EF - MVCADO.NETBuild MVC Applications with Connectivity to Elasticsearch
Filemaker ProODBCBidirectional Access to Elasticsearch from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to Elasticsearch from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with Elasticsearch on Linux
Google Apps ScriptConnect CloudConnect to Elasticsearch Data in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with Elasticsearch Entities in Java
IntelliJJDBCConnect to Elasticsearch in IntelliJ
JBossJDBCConnect to Elasticsearch from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for Elasticsearch using JDBI
JitterbitConnect CloudIntegrate with Live Elasticsearch Data in Jitterbit
JRubyJDBCConnect to Elasticsearch in JRuby
MendixConnect CloudBuild Elasticsearch-Connected Apps in Mendix
Microsoft Power AppsConnect CloudIntegrate Live Elasticsearch Data into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery Elasticsearch Data in Node.js (via Connect Cloud)
NodeJSODBCQuery Elasticsearch through ODBC in Node.js
OutSystemsConnect CloudCreate Elasticsearch-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess Elasticsearch in PHP through Connect Server
PHPODBCNatively Connect to Elasticsearch in PHP
PowerBuilderADO.NETConnect to Elasticsearch from PowerBuilder
PowerShellPowerShellPipe Elasticsearch to CSV in PowerShell
PyCharmODBCUsing the CData ODBC Driver for Elasticsearch in PyCharm
PythonODBCConnect to Elasticsearch in Python on Linux/UNIX
ReactConnect ServerBuild Dynamic React Apps with Elasticsearch Data
RubyODBCConnect to Elasticsearch in Ruby
RunMyProcessConnect CloudConnect to Elasticsearch Data in RunMyProcess
RunMyProcess DSECJDBCConnect to Elasticsearch in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to Elasticsearch in SAPUI5 MVC Apps
ServoyJDBCBuild Elasticsearch-Connected Apps in Servoy
Spring BootJDBCAccess Live Elasticsearch Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access Elasticsearch in Python
TomcatJDBCConfigure the CData JDBC Driver for Elasticsearch in a Connection Pool in Tomcat
UnqorkConnect CloudCreate Elasticsearch-Connected Applications in Unqork
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for Elasticsearch
WebLogicJDBCConnect to Elasticsearch from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top

Ready to get started?