Learn more
 

Ready to get started?

Learn more:

PostgreSQL Connectivity Solutions

In this article

Related articles

PostgreSQL Integration Guides and Tutorials


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

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

Back to top

ETL & Replication


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

Back to top

Data Virtualization


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

Back to top

Software Development


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

Back to top

Data Management


ProductTechnologyArticle Title
Apache SolrJDBCImport PostgreSQL Data into Apache Solr
DB ArtisanJDBCManage PostgreSQL in DBArtisan as a JDBC Source
DB ArtisanODBCConnect to PostgreSQL in DBArtisan
DBeaverJDBCConnect to PostgreSQL in DBeaver
DbVisualizerJDBCConnect to PostgreSQL in DBVisualizer
Informatica Enterprise Data CatalogJDBCAdd PostgreSQL to Informatica Enterprise Data Catalog
MySQL WorkbenchConnect ServerQuery PostgreSQL Data in MySQL Workbench (Connect Server)
MySQL WorkbenchODBCQuery PostgreSQL in MySQL Workbench (ODBC)
QuerySurgeJDBCValidate PostgreSQL Data with QuerySurge
RazorSQLJDBCConnect to PostgreSQL in RazorSQL
SQuirreLJDBCConnect to PostgreSQL in Squirrel SQL Client

Back to top

Workflow Automation


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

Back to top