Ready to get started?

Learn more about Greenplum Connectivity Solutions

Learn More

Greenplum Integration Guides and Tutorials

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

CData Software connectivity tools provide access to live Greenplum 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 Greenplum 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 Greenplum in Alteryx Designer
Amazon QuickSightCloud HubBuild Interactive Dashboards from Greenplum in Amazon QuickSight
Aqua Data StudioJDBCConnect to Greenplum in Aqua Data Studio
BirstJDBCBuild Visualizations of Greenplum in Birst
BIRTJDBCDesign BIRT Reports on Greenplum
Clear AnalyticsODBCBuild Charts with Greenplum in Clear Analytics
Microsoft ExcelExcelExcel Spreadsheet Automation with the QUERY Formula
DBxtraODBCBuild Dashboards with Greenplum in DBxtra
DomoODBCCreate Datasets from Greenplum in Domo Workbench
Dundas BIODBCBuild Dashboards with Greenplum in Dundas BI
FineReportJDBCFeed Greenplum into FineReport
Google Data StudioCloud HubCreate Reports from Greenplum in Google Data Studio
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Greenplum
JasperServerJDBCCreate Greenplum Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Greenplum in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Greenplum in JReport Designer
KlipfolioCloud HubCreate Greenplum-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Greenplum JDBC Driver in KNIME
LINQPadADO.NETWorking with Greenplum in LINQPad
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Greenplum
Power BI OnlineCloud HubVisualize Live Greenplum in the Power BI Service
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Greenplum
MicroStrategyJDBCUse the CData JDBC Driver for Greenplum in MicroStrategy
OBIEEJDBCGreenplum Reporting in OBIEE with the Greenplum JDBC Driver
pandasPythonUse pandas to Visualize Greenplum in Python
Pentaho Report DesignerJDBCIntegrate Greenplum in the Pentaho Report Designer
QlikViewODBCConnect to and Query Greenplum in QlikView over ODBC
RJDBCAnalyze Greenplum in R
RapidMiner JDBCConnect to Greenplum in RapidMiner
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Greenplum
SAP Crystal ReportsJDBCPublish Reports with Greenplum in Crystal Reports
SAP LumiraAPI ServerConsume Greenplum OData Feeds in SAP Lumira
SASODBCUse the CData ODBC Driver for Greenplum in SAS for Real-Time Reporting and Analytics
SisenseJDBCVisualize Live Greenplum in Sisense
Spago BIJDBCConnect to Greenplum in SpagoBI
TableauTableauVisualize Greenplum in Tableau Desktop
Tableau OnlineCloud HubBuild Greenplum Visualizations in Tableau Online
Tableau ServerTableauPublish Greenplum-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize Greenplum in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on Greenplum from Spotfire Server
VisioODBCLink Visio Shapes to Greenplum

Back to top

ETL & Replication


ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous Greenplum Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous Greenplum Replication to Amazon S3
Apache CamelJDBCIntegrate with Greenplum using Apache Camel
Apache CassandraCData SyncAutomated Continuous Greenplum Replication to Apache Cassandra
Apache NiFiJDBCBridge Greenplum Connectivity with Apache NiFi
AWS GlueJDBCConnect to Greenplum in AWS Glue Jobs Using JDBC
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Greenplum to SQL Server
CloverDXJDBCConnect to Greenplum in CloverDX (formerly CloverETL)
CSVCData SyncAutomated Continuous Greenplum Replication to Local Delimited Files
IBM DB2CData SyncAutomated Continuous Greenplum Replication to IBM DB2
FoxProODBCWork with Greenplum in FoxPro
Google BigQueryCData SyncAutomated Continuous Greenplum Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous Greenplum Replication to Google Cloud SQL
Google Data FusionJDBCBuild Greenplum-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate Greenplum for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to Greenplum in HULFT Integrate
Informatica CloudJDBCIntegrate Greenplum in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Greenplum
Jaspersoft ETLJDBCConnect to Greenplum in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous Greenplum Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous Greenplum Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to Greenplum
MongoDBCData SyncAutomated Continuous Greenplum Replication to MongoDB
MySQLCData SyncAutomated Continuous Greenplum Replication to MySQL
Oracle Data IntegratorJDBCETL Greenplum in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous Greenplum Replication to Oracle
petlPythonExtract, Transform, and Load Greenplum in Python
PostgreSQLCData SyncAutomated Continuous Greenplum Replication to PostgreSQL
Replicate to CSVPowerShellReplicate Greenplum to MySQL with PowerShell
SnowflakeCData SyncAutomated Continuous Greenplum Replication to Snowflake
SQL ServerCData SyncAutomated Continuous Greenplum Replication to SQL Server
SQLiteCData SyncAutomated Continuous Greenplum Replication to SQLite
TalendJDBCConnect to Greenplum and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Greenplum in UiPath Studio

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to Greenplum
.NET QueryBuilderODBCRapidly Develop Greenplum-Driven Apps with Active Query Builder
Angular JSAPI ServerUsing AngularJS to Build Dynamic Web Pages with Greenplum
Apache SparkJDBCWork with Greenplum in Apache Spark Using SQL
AppSheetCloud HubCreate Greenplum-Connected Business Apps in AppSheet
Microsoft Azure Logic AppsAPI ServerTrigger Greenplum IFTTT Flows in Azure App Service
ColdFusionJDBCQuery Greenplum in ColdFusion
DashPythonUse Dash & Python to Build Web Apps on Greenplum
DevExpressADO.NETDataBind Greenplum to the DevExpress Data Grid
EF - Code FirstADO.NETAccess Greenplum with Entity Framework 6
EF - LINQADO.NETLINQ to Greenplum
EF - MVCADO.NETBuild MVC Applications with Connectivity to Greenplum
Filemaker ProJDBCBidirectional Access to Greenplum from FileMaker Pro
GoODBCWrite a Simple Go Application to work with Greenplum on Linux
Google Apps ScriptCloud HubConnect to Greenplum in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with Greenplum Entities in Java
IntelliJJDBCConnect to Greenplum in IntelliJ
JBossJDBCConnect to Greenplum from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for Greenplum using JDBI
JRubyJDBCConnect to Greenplum in JRuby
NodeJSAPI ServerQuery Greenplum from Node.js
NodeJSCloud HubQuery Greenplum as a MySQL Database in Node.js
NodeJSJDBCQuery Greenplum through ODBC in Node.js
PHPCloud HubAccess Greenplum in PHP through the Cloud Hub
PHPODBCNatively Connect to Greenplum in PHP
PowerShellPowerShellPipe Greenplum to CSV in PowerShell
PowerBuilderADO.NETConnect to Greenplum from PowerBuilder
PyCharmODBCUsing the CData ODBC Driver for Greenplum in PyCharm
PythonODBCConnect to Greenplum in Python on Linux/UNIX
RubyODBCConnect to Greenplum in Ruby
SAP UI5API ServerIntegrate Real-Time Access to Greenplum in SAPUI5 MVC Apps
ServoyJDBCBuild Greenplum-Connected Apps in Servoy
SQLAlchemyPythonUse SQLAlchemy ORMs to Access Greenplum in Python
TomcatJDBCConfigure the CData JDBC Driver for Greenplum in a Connection Pool in Tomcat
VCL App (RAD Studio)FireDACBuild a Simple VCL Application for Greenplum
WebLogicJDBCConnect to Greenplum from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top