Learn more
 

Ready to get started?

Learn more:

HubSpot Connectivity Solutions

In this article

Related articles

HubSpot Integration Guides and Tutorials


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

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

Back to top

ETL & Replication


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

Back to top

Data Virtualization


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

Back to top

Software Development


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

Back to top

Data Management


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

Back to top

Workflow Automation


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

Back to top