Learn more
 

Ready to get started?

Learn more:

Redshift Connectivity Solutions

In this article

Related articles

Redshift Integration Guides and Tutorials


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

CData Software's connectivity tools enable users to connect directly to live Redshift 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 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 (ODBC)
Alteryx DesignerConnect CloudWork with Live Redshift Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from Redshift Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live Redshift data into Amazon SageMaker Canvas
AWS DatabricksJDBCProcess & Analyze Redshift Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel Redshift Data Using Azure Analysis Services
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 Data 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 Data in Looker
Looker StudioConnect CloudCreate Reports from Redshift Data in Looker Studio
MetabaseConnect CloudCreate Interactive Redshift-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live Redshift Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live Redshift Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Redshift
MicroStrategyConnect CloudConnect to Live Redshift Data 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 Data in the Power BI Service
Power PivotConnect CloudAccess Redshift Data in Microsoft Power Pivot
Power QueryConnect CloudAccess Redshift Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from Redshift Data 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
RedashConnect ServerBuild Redshift-Connected Dashboards in Redash
SAP Analytics CloudConnect CloudAnalyze Redshift Data 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
SAS ViyaConnect CloudAnalyze Live Redshift Data in SAS Viya
SisenseJDBCVisualize Live Redshift in Sisense
Spago BIJDBCConnect to Redshift in SpagoBI
Tableau CloudConnect CloudBuild Redshift Visualizations in Tableau Cloud
TIBCO SpotfireADO.NETVisualize Redshift in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize Redshift Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on Redshift from Spotfire Server
VisioODBCLink Visio Shapes to Redshift
Zoho AnalyticsConnect CloudCreate Redshift-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to Redshift Data in Airbyte ELT Pipelines
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 CloudBuild ETL Jobs with Redshift Data 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)
CouchbaseCData SyncAutomated Continuous Redshift Replication to Couchbase
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 MySQLPowerShellReplicate Redshift to MySQL with PowerShell
SnapLogicJDBCIntegrate Redshift with External Services using SnapLogic
SQL Server Linked ServerConnect CloudConnect to Redshift Data 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 (JDBC)
APOS Live Data GatewayConnect CloudBuild Semantic Layer Views for Redshift Data (Connect Cloud)
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 PolyBaseConnect CloudConnect to Redshift Data using PolyBase with Connect Cloud
SQL Server PolyBaseODBCConnect to Redshift as an External Data Source using PolyBase

Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to Redshift
.NET QueryBuilderODBCRapidly Develop Redshift-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with Redshift
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
C++BuilderODBCDataBind Controls to Redshift Data in C++Builder
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
DelphiODBCDataBind Controls to Redshift Data in Delphi
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 Data 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 Data into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery Redshift Data in Node.js (via Connect Cloud)
NodeJSODBCQuery Redshift through ODBC in Node.js
OutSystemsConnect CloudCreate Redshift-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess Redshift in PHP through Connect Server
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
ReactConnect ServerBuild Dynamic React Apps with Redshift Data
RubyODBCConnect to Redshift in Ruby
RunMyProcessConnect CloudConnect to Redshift Data in RunMyProcess
RunMyProcess DSECJDBCConnect to Redshift in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to Redshift in SAPUI5 MVC Apps
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)ODBCBuild 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 WorkbenchConnect ServerQuery Redshift Data in MySQL Workbench (Connect Server)
MySQL WorkbenchODBCQuery Redshift in MySQL Workbench (ODBC)
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 Data 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