Amazon Athena Integration Guides and Tutorials

Jerod Johnson
Jerod Johnson
Director, Technology Evangelism
A list of guides and tutorials for connecting to and working with live Amazon Athena data.

CData Software's connectivity tools enable users to connect directly to live Amazon Athena 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 Amazon Athena data.

Integration Use-Cases

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

Artificial Intelligence


ProductTechnologyArticle Title
AgentforceConnect AIConnecting Agentforce with Amazon Athena Data
AgnoConnect AIUse Agno to Talk to Your Amazon Athena Data
Sourcegraph AmpConnect AIHow to Connect to Live Amazon Athena Data from Sourcegraph Amp
AntigravityConnect AIIntegrate Google's Antigravity Agent with Live Amazon Athena Data
Boomi AgentStudioConnect AIIntegrating Boomi AgentStudio with Amazon Athena Data
ChatGPTConnect AIConnect Amazon Athena Data to ChatGPT
Claude Agent SDKConnect AIHow to Connect to Live Amazon Athena Data from Claude Agent SDK
Claude CodeConnect AIHow to Query Live Amazon Athena in Claude Code
Claude.aiConnect AIUse Claude.ai to Talk to Your Amazon Athena Data
ClineConnect AIIntegrate Cline with Live Amazon Athena Data
MS Copilot StudioConnect AIConnect Amazon Athena Data to Microsoft Copilot Studio
crewAIConnect AIHow to Connect to Live Amazon Athena Data from crewAI Agents
CursorConnect AIIntegrate Cursor with Live Amazon Athena Data
Databricks Agent BricksConnect AIUse Databricks Agent Bricks to Talk to Amazon Athena Data
DataikuConnect AIIntegrating Dataiku with Amazon Athena Data
DifyConnect AIIntegrate Dify with Live Amazon Athena Data via CData Connect AI
ElevenLabsConnect AIBuild Voice Agents in ElevenLabs with Access to Live Amazon Athena Data
EmergentConnect AIAccess Live Amazon Athena Data in Emergent
FlowiseConnect AIHow to Connect Flowise AI Agents to Live Amazon Athena Data
Azure AI FoundryConnect AIUse Azure AI Foundry to Talk to Your Amazon Athena Data
Gemini EnterpriseConnect AIHow to Connect to Live Amazon Athena Data from Gemini Enterprise
Gemini (CLI)Connect AIHow to Connect to Live Amazon Athena Data from Gemini CLI
GenSparkConnect AIConnecting GenSpark with Amazon Athena Data
Google ADKConnect AIHow to Connect to Live Amazon Athena Data from Google ADK Agents
Google Vertex AIConnect AIIntegrate Google Vertex AI Agents with Live Amazon Athena Data
GooseConnect AIIntegrate Goose with Live Amazon Athena Data via CData Connect AI
GrokConnect AIUse Grok to Talk to Your Amazon Athena Data
GumloopConnect AIIntegrating Gumloop with Amazon Athena Data
IBM watsonx OrchestrateConnect AIBuild AI Agents with Amazon Athena Data in IBM watsonx Orchestrate
LangchainConnect AIIntegrating LangChain with Amazon Athena Data
LangGraphConnect AIIntegrating LangGraph with Amazon Athena Data
LibreChatConnect AIIntegrate LibreChat with Live Amazon Athena Data
LlamaIndexConnect AIIntegrating LlamaIndex with Amazon Athena Data
Manus AIConnect AIUse Manus AI to Talk to Your Amazon Athena Data
MastraConnect AIConnecting Mastra with Amazon Athena Data
Mistral (Le Chat)Connect AIConnect Amazon Athena Data to Mistral
MoonlitConnect AIConnecting Moonlit Workflow with Amazon Athena Data
n8nConnect AIBuild Amazon Athena-Connected Workflows and AI Agents in n8n
OpenAI SDK (Python)Connect AIHow to Connect to Live Amazon Athena Data from OpenAI Python Applications
OpenCodeConnect AIIntegrate OpenCode with Live Amazon Athena Data via CData Connect AI
Open WebUIConnect AIIntegrate Open WebUI with Live Amazon Athena Data
Relevance AIConnect AIBuild Agents in Relevance AI with Access to Live Amazon Athena Data
Roo CodeConnect AIAccess Live Amazon Athena Data in Roo Code
Theia IDEConnect AIIntegrate Theia IDE with Live Amazon Athena Data
WindsurfConnect AIIntegrate Live Amazon Athena Data in the Windsurf IDE
ZedConnect AIQuery Live Amazon Athena Data in Zed Editor
Python MCP ServerPythonConnect Amazon Athena to AI Assistants With the CData Python MCP Server

Back to top

Business Intelligence & Analytics


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

Back to top

ETL & Replication


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

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to Amazon Athena
EF - Code FirstADO.NETAccess Amazon Athena with Entity Framework 6
DevExpressADO.NETDataBind Amazon Athena to the DevExpress Data Grid
EF - LINQADO.NETLINQ to Amazon Athena
EF - MVCADO.NETBuild MVC Applications with Connectivity to Amazon Athena
PowerBuilderADO.NETConnect to Amazon Athena from PowerBuilder
Google Apps ScriptConnect AIConnect to Amazon Athena Data in Google Apps Script
AppSheetConnect AICreate Amazon Athena-Connected Business Apps in AppSheet
AppsmithConnect AICreate Amazon Athena-Connected Applications in Appsmith
AxiosConnect AIBuild Amazon Athena-Connected Web Apps with Axios and CData Connect AI
Bubble.ioConnect AIBuild Amazon Athena-Connected Apps in Bubble
ChoreoConnect AIBuild Custom Apps on Amazon Athena Data in Choreo
Dash (Python)Connect AIUse Dash to Build Web Apps on Live Amazon Athena Data
JitterbitConnect AIIntegrate with Live Amazon Athena Data in Jitterbit
MendixConnect AIBuild Amazon Athena-Connected Apps in Mendix (Connect AI)
NodeJSConnect AIQuery Amazon Athena Data in Node.js (via Connect AI)
OutSystemsConnect AICreate Amazon Athena-Connected Enterprise Applications in OutSystems
pandas (Python)Connect AIHow to Visualize Amazon Athena Data in Python with pandas
Microsoft Power AppsConnect AIIntegrate Live Amazon Athena Data into Custom Business Apps Built in Power Apps
PythonConnect AIGetting Started with the CData Connect AI Python SDK for Amazon Athena
RetoolConnect AIBuild Amazon Athena-Connected Apps in Retool
RunMyProcessConnect AIConnect to Amazon Athena Data in RunMyProcess
UnqorkConnect AICreate Amazon Athena-Connected Applications in Unqork
Apache SparkJDBCWork with Amazon Athena in Apache Spark Using SQL
AWS LambdaJDBCAccess Live Amazon Athena Data in AWS Lambda
ColdFusionJDBCQuery Amazon Athena in ColdFusion Using JDBC
Filemaker Pro (on Mac)JDBCBidirectional Access to Amazon Athena from FileMaker Pro (on Mac)
HibernateJDBCObject-Relational Mapping (ORM) with Amazon Athena Entities in Java
IntelliJJDBCConnect to Amazon Athena in IntelliJ
JBossJDBCConnect to Amazon Athena from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for Amazon Athena using JDBI
JetBrains RubyMineJDBCIntegrate Amazon Athena with JetBrains RubyMine
JRubyJDBCConnect to Amazon Athena in JRuby
MendixJDBCBuild Amazon Athena-Connected Apps in Mendix (JDBC)
RunMyProcess DSECJDBCConnect to Amazon Athena in DigitalSuite Studio through RunMyProcess DSEC
ServoyJDBCBuild Amazon Athena-Connected Apps in Servoy
Spring BootJDBCAccess Live Amazon Athena Data in Spring Boot Apps
TomcatJDBCConfigure the CData JDBC Driver for Amazon Athena in a Connection Pool in Tomcat
WebLogicJDBCConnect to Amazon Athena from a Connection Pool in WebLogic
.NET QueryBuilderODBCRapidly Develop Amazon Athena-Driven Apps with Active Query Builder
ColdFusionODBCQuery Amazon Athena in ColdFusion Using ODBC
C++BuilderODBCDataBind Controls to Amazon Athena Data in C++Builder
DelphiODBCDataBind Controls to Amazon Athena Data in Delphi
Filemaker ProODBCBidirectional Access to Amazon Athena from FileMaker Pro
GoODBCWrite a Simple Go Application to work with Amazon Athena on Linux
Lazarus IDEODBCEasily Integrate Amazon Athena Data in Lazarus Pascal IDE
NodeJSODBCQuery Amazon Athena through ODBC in Node.js
PHPODBCNatively Connect to Amazon Athena in PHP
PyCharmODBCUsing the CData ODBC Driver for Amazon Athena in PyCharm
PythonODBCConnect to Amazon Athena in Python on Linux/UNIX
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for Amazon Athena
RubyODBCConnect to Amazon Athena in Ruby
DashPythonUse Dash & Python to Build Web Apps on Amazon Athena
SQLAlchemyPythonUse SQLAlchemy ORMs to Access Amazon Athena in Python

Back to top

Data Management



Back to top

Workflow Automation



Back to top

Ready to get started?