Learn more
 

Ready to get started?

Learn more:

HubDB Connectivity Solutions

In this article

Related articles

HubDB Integration Guides and Tutorials


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

CData Software's connectivity tools enable users to connect directly to live HubDB 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 HubDB 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 HubDB in Alteryx Designer (ODBC)
Aqua Data StudioJDBCConnect to HubDB in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze HubDB Data in Databricks (AWS)
BirstJDBCBuild Visualizations of HubDB in Birst
BIRTJDBCDesign BIRT Reports on HubDB
Clear AnalyticsODBCBuild Charts with HubDB in Clear Analytics
DBxtraODBCBuild Dashboards with HubDB in DBxtra
DomoODBCCreate Datasets from HubDB in Domo Workbench
Dundas BIODBCBuild Dashboards with HubDB in Dundas BI
Excel (on Mac OS)ODBCWork with HubDB Data in MS Excel on Mac OS X
FineReportJDBCFeed HubDB into FineReport
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with HubDB
JasperServerJDBCCreate HubDB Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to HubDB in Jaspersoft Studio
JReport DesignerJDBCIntegrate with HubDB in JReport Designer
KNIMEJDBCEnable the HubDB JDBC Driver in KNIME
LINQPadADO.NETWorking with HubDB in LINQPad
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from HubDB
MicroStrategyJDBCUse the CData JDBC Driver for HubDB in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for HubDB in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for HubDB in MicroStrategy Web
OBIEEJDBCHubDB Reporting in OBIEE with the HubDB JDBC Driver
pandasPythonUse pandas to Visualize HubDB in Python
Pentaho Report DesignerJDBCIntegrate HubDB in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time HubDB
QlikViewODBCConnect to and Query HubDB in QlikView over ODBC
RJDBCAnalyze HubDB in R (JDBC)
RODBCAnalyze HubDB in R (ODBC)
RapidMinerJDBCConnect to HubDB in RapidMiner
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for HubDB
SAP Crystal ReportsJDBCPublish Reports with HubDB in Crystal Reports
SASODBCUse the CData ODBC Driver for HubDB in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for HubDB in SAS JMP
SisenseJDBCVisualize Live HubDB in Sisense
Spago BIJDBCConnect to HubDB in SpagoBI
TableauTableauVisualize HubDB in Tableau Desktop
Tableau ServerTableauPublish HubDB-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize HubDB in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on HubDB from Spotfire Server
VisioODBCLink Visio Shapes to HubDB

Back to top

ETL & Replication


ProductTechnologyArticle Title
Apache AirflowJDBCBridge HubDB Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with HubDB using Apache Camel
Apache NiFiJDBCBridge HubDB Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with HubDB Data in Apache NiFi
BIMLSSISUse Biml to Build SSIS Tasks to Replicate HubDB to SQL Server
CloverDXJDBCConnect to HubDB in CloverDX (formerly CloverETL)
FoxProODBCWork with HubDB in FoxPro
Google Data FusionJDBCBuild HubDB-Connected ETL Processes in Google Data Fusion
HULFT IntegrateJDBCConnect to HubDB in HULFT Integrate
Informatica CloudJDBCIntegrate HubDB in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for HubDB
Jaspersoft ETLJDBCConnect to HubDB in Jaspersoft Studio
Microsoft ExcelExcelTransfer Data from Excel to HubDB
Oracle Data IntegratorJDBCETL HubDB in Oracle Data Integrator
petlPythonExtract, Transform, and Load HubDB in Python
Replicate to MySQLPowerShellReplicate HubDB to MySQL with PowerShell
SnapLogicJDBCIntegrate HubDB with External Services using SnapLogic
TalendJDBCConnect to HubDB and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to HubDB in UiPath Studio

Back to top

Data Virtualization


ProductTechnologyArticle Title
Access Linked TablesODBCUpdate HubDB with a Microsoft Access Linked Table
APOS Live Data GatewayJDBCBuild Semantic Layer Views for HubDB (JDBC)
DenodoJDBCCreate A Data Source for HubDB in Denodo Platform
DremioJDBCConnect to HubDB as an External Source in Dremio
MySQL Federated TablesODBCConnect to HubDB as Federated Tables in MySQL
Oracle DatabaseODBCAccess HubDB as a Remote Oracle Database
PostgreSQL FDWJDBCA PostgreSQL Interface for HubDB
SQL Server Linked ServersODBCConnect to HubDB as a Linked Server
SQL Server PolyBaseODBCConnect to HubDB as an External Data Source using PolyBase

Back to top

Software Development


ProductTechnologyArticle Title
AWS LambdaJDBCAccess Live HubDB Data in AWS Lambda
.NET ChartsADO.NETDataBind Charts to HubDB
.NET QueryBuilderODBCRapidly Develop HubDB-Driven Apps with Active Query Builder
Apache SparkJDBCWork with HubDB in Apache Spark Using SQL
C++BuilderODBCDataBind Controls to HubDB Data in C++Builder
ColdFusionJDBCQuery HubDB in ColdFusion Using JDBC
ColdFusionODBCQuery HubDB in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on HubDB
DelphiODBCDataBind Controls to HubDB Data in Delphi
DevExpressADO.NETDataBind HubDB to the DevExpress Data Grid
EF - Code FirstADO.NETAccess HubDB with Entity Framework 6
EF - LINQADO.NETLINQ to HubDB
EF - MVCADO.NETBuild MVC Applications with Connectivity to HubDB
Filemaker ProODBCBidirectional Access to HubDB from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to HubDB from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with HubDB on Linux
HibernateJDBCObject-Relational Mapping (ORM) with HubDB Entities in Java
IntelliJJDBCConnect to HubDB in IntelliJ
JBossJDBCConnect to HubDB from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for HubDB using JDBI
JRubyJDBCConnect to HubDB in JRuby
NodeJSODBCQuery HubDB through ODBC in Node.js
PHPODBCNatively Connect to HubDB in PHP
PowerBuilderADO.NETConnect to HubDB from PowerBuilder
PowerShellPowerShellPipe HubDB to CSV in PowerShell
PyCharmODBCUsing the CData ODBC Driver for HubDB in PyCharm
PythonODBCConnect to HubDB in Python on Linux/UNIX
RubyODBCConnect to HubDB in Ruby
RunMyProcess DSECJDBCConnect to HubDB in DigitalSuite Studio through RunMyProcess DSEC
ServoyJDBCBuild HubDB-Connected Apps in Servoy
Spring BootJDBCAccess Live HubDB Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access HubDB in Python
TomcatJDBCConfigure the CData JDBC Driver for HubDB in a Connection Pool in Tomcat
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for HubDB
WebLogicJDBCConnect to HubDB from a Connection Pool in WebLogic

Back to top

Data Management


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

Back to top

Workflow Automation


ProductTechnologyArticle Title
MuleSoft AnypointJDBCAccess HubDB in Anypoint Using SQL
SSIS ExportSSISExport Data from SQL Server to HubDB through SSIS
SSIS ImportSSISImport HubDB Data into SQL Server using SSIS
SSIS LookupSSISInsert New or Update Existing HubDB Records from SQL Server

Back to top