Redshift Integration Guides and Tutorials

Ready to get started?

Learn more:

Redshift Connectivity Solutions

In this article

Related articles


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

CData Software connectivity tools provide access to live Redshift data from popular BI, analytics, ETL, and custom applications, offering our customers access to their data wherever they want. Below you will find a list of guides and tutorials for integrating with live Redshift 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 Redshift in Alteryx Designer
Amazon QuickSightConnect CloudBuild Interactive Dashboards from Redshift in Amazon QuickSight
Aqua Data StudioJDBCConnect to Redshift in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Redshift Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel Redshift Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of Redshift in Birst
BIRTJDBCDesign BIRT Reports on Redshift
Clear AnalyticsODBCBuild Charts with Redshift in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze Redshift Data in Cognos Analytics
DBxtraODBCBuild Dashboards with Redshift in DBxtra
DomoODBCCreate Datasets from Redshift in Domo Workbench
Dundas BIODBCBuild Dashboards with Redshift in Dundas BI
Excel (on Mac OS)ODBCWork with Redshift Data in MS Excel on Mac OS X
FineReportJDBCFeed Redshift into FineReport
Google SheetsConnect CloudAccess Live Redshift in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Redshift
Infragistics RevealConnect CloudAnalyze Redshift Data in Infragistics Reval
JasperServerJDBCCreate Redshift Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Redshift in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Redshift in JReport Designer
KlipfolioConnect CloudCreate Redshift-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Redshift JDBC Driver in KNIME
LINQPadADO.NETWorking with Redshift in LINQPad
LookerConnect CloudAnalyze Redshift in Looker
Looker StudioConnect CloudCreate Reports from Redshift in Looker Studio
MetabaseConnect CloudCreate Interactive Redshift-Connected Metabase Dashboards
Microsoft ExcelExcelExcel Spreadsheet Automation with the QUERY Formula
Microsoft Excel 365Connect CloudAccess Live Redshift Data in Excel 365
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Redshift
MicroStrategyConnect CloudConnect to Live Redshift in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for Redshift in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for Redshift in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Redshift in MicroStrategy Web
Mode AnalyticsConnect CloudCreate Redshift-Connected Visualizations in Mode
OBIEEJDBCRedshift Reporting in OBIEE with the Redshift JDBC Driver
pandasPythonUse pandas to Visualize Redshift in Python
Pentaho Report DesignerJDBCIntegrate Redshift in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Redshift
Power BI ServiceConnect CloudVisualize Live Redshift in the Power BI Service
Qlik CloudConnect CloudCreate Apps from Redshift in Qlik Sense Cloud
QlikViewODBCConnect to and Query Redshift in QlikView over ODBC
RJDBCAnalyze Redshift in R (JDBC)
RODBCAnalyze Redshift in R (ODBC)
RapidMinerJDBCConnect to Redshift in RapidMiner
SAP Analytics CloudConnect CloudAnalyze Redshift in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Redshift
SAP Crystal ReportsJDBCPublish Reports with Redshift in Crystal Reports
SASODBCUse the CData ODBC Driver for Redshift in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for Redshift in SAS JMP
SisenseJDBCVisualize Live Redshift in Sisense
Spago BIJDBCConnect to Redshift in SpagoBI
TableauTableauVisualize Redshift in Tableau Desktop
Tableau CloudConnect CloudBuild Redshift Visualizations in Tableau Cloud
Tableau ServerTableauPublish Redshift-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize Redshift in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on Redshift from Spotfire Server
VisioODBCLink Visio Shapes to Redshift
Zoho AnalyticsConnect CloudCreate Redshift-Connect Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
Apache AirflowJDBCBridge Redshift Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with Redshift using Apache Camel
Apache NiFiJDBCBridge Redshift Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with Redshift Data in Apache NiFi
AWS GlueConnect CloudConnect to Redshift in AWS Glue Jobs
Azure Data FactoryConnect CloudImport Redshift Data Using Azure Data Factory
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Redshift to SQL Server
CloverDXJDBCConnect to Redshift in CloverDX (formerly CloverETL)
FoxProODBCWork with Redshift in FoxPro
Google Data FusionJDBCBuild Redshift-Connected ETL Processes in Google Data Fusion
HULFT IntegrateJDBCConnect to Redshift in HULFT Integrate
Informatica CloudJDBCIntegrate Redshift in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Redshift
Jaspersoft ETLJDBCConnect to Redshift in Jaspersoft Studio
Microsoft ExcelExcelTransfer Data from Excel to Redshift
Microsoft Power AutomateConnect CloudBuild Redshift-Connected Automated Tasks with Power Automate (Desktop)
Oracle Data IntegratorJDBCETL Redshift in Oracle Data Integrator
petlPythonExtract, Transform, and Load Redshift in Python
Replicate to CSVPowerShellReplicate Redshift to MySQL with PowerShell
SnapLogicJDBCIntegrate Redshift with External Services using SnapLogic
SQL Server Linked ServerConnect CloudConnect to Redshift as a SQL Server Linked Server
TalendJDBCConnect to Redshift and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Redshift in UiPath Studio

Back to top

Data Virtualization


ProductTechnologyArticle Title
Access Linked TablesODBCUpdate Redshift with a Microsoft Access Linked Table
APOS Live Data GatewayJDBCBuild Semantic Layer Views for Redshift
DenodoJDBCCreate A Data Source for Redshift in Denodo Platform
DremioJDBCConnect to Redshift as an External Source in Dremio
MySQL Federated TablesODBCConnect to Redshift as Federated Tables in MySQL
Oracle DatabaseODBCAccess Redshift as a Remote Oracle Database
PostgreSQL FDWJDBCA PostgreSQL Interface for Redshift
Salesforce ConnectConnect CloudEdit and Search Redshift External Objects in Salesforce Connect
SQL Server Linked ServersODBCConnect to Redshift as a Linked Server
SQL Server PolyBaseODBCConnect to Redshift as an External Data Source using PolyBase
TIBCO Data VirtualizationTIBCO DVAccess Live Redshift Data in TIBCO Data Virtualization

Back to top

Software Development


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

Back to top

Data Management


ProductTechnologyArticle Title
Apache SolrJDBCImport Redshift Data into Apache Solr
DB ArtisanJDBCManage Redshift in DBArtisan as a JDBC Source
DB ArtisanODBCConnect to Redshift in DBArtisan
DBeaverJDBCConnect to Redshift in DBeaver
DbVisualizerJDBCConnect to Redshift in DBVisualizer
Informatica Enterprise Data CatalogJDBCAdd Redshift to Informatica Enterprise Data Catalog
MySQL WorkbenchODBCQuery Redshift in MySQL Workbench (ODBC)
Power QueryConnect CloudWork with Live Redshift Data in Power Query
QuerySurgeJDBCValidate Redshift Data with QuerySurge
RazorSQLJDBCConnect to Redshift in RazorSQL
SQuirreLJDBCConnect to Redshift in Squirrel SQL Client

Back to top

Workflow Automation


ProductTechnologyArticle Title
MuleSoft AnypointJDBCAccess Redshift in Anypoint Using SQL
Nintex Workflow CloudConnect CloudBuild Redshift-Connected Workflows in Nintex
Power AutomateConnect CloudIntegrate Redshift into Power Automate Automated Tasks
SSIS ExportSSISExport Data from SQL Server to Redshift through SSIS
SSIS ImportSSISImport Redshift Data into SQL Server using SSIS
SSIS LookupSSISInsert New or Update Existing Redshift Records from SQL Server

Back to top