Ready to get started?

Learn more:

Presto Connectivity Solutions

Presto Integration Guides and Tutorials



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

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

Back to top

ETL & Replication


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

Back to top

Data Virtualization



Back to top

Software Development


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

Back to top

Data Management



Back to top

Workflow Automation



Back to top