Learn more
 

HarperDB Integration Guides and Tutorials


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

CData Software's connectivity tools enable users to connect directly to live HarperDB 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 HarperDB 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 HarperDB in Alteryx Designer (ODBC)
Amazon QuickSightConnect ServerBuild Interactive Dashboards from HarperDB Data in Amazon QuickSight
Aqua Data StudioJDBCConnect to HarperDB in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze HarperDB Data in Databricks (AWS)
BirstJDBCBuild Visualizations of HarperDB in Birst
BIRTJDBCDesign BIRT Reports on HarperDB
Clear AnalyticsODBCBuild Charts with HarperDB in Clear Analytics
DBxtraODBCBuild Dashboards with HarperDB in DBxtra
DomoODBCCreate Datasets from HarperDB in Domo Workbench
Dundas BIODBCBuild Dashboards with HarperDB in Dundas BI
Excel (on Mac OS)ODBCWork with HarperDB Data in MS Excel on Mac OS X
FineReportJDBCFeed HarperDB into FineReport
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with HarperDB
Infragistics RevealConnect ServerAnalyze HarperDB Data in Infragistics Reval
JasperServerJDBCCreate HarperDB Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to HarperDB in Jaspersoft Studio
JReport DesignerJDBCIntegrate with HarperDB in JReport Designer
KlipfolioConnect ServerCreate HarperDB-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the HarperDB JDBC Driver in KNIME
LINQPadADO.NETWorking with HarperDB in LINQPad
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from HarperDB
MicroStrategyConnect ServerConnect to Live HarperDB Data in MicroStrategy through Connect Server
MicroStrategyJDBCUse the CData JDBC Driver for HarperDB in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for HarperDB in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for HarperDB in MicroStrategy Web
OBIEEJDBCHarperDB Reporting in OBIEE with the HarperDB JDBC Driver
Pentaho Report DesignerJDBCIntegrate HarperDB in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time HarperDB
Power BI ServiceConnect ServerVisualize Live HarperDB Data in the Power BI Service
Power PivotConnect ServerAccess HarperDB Data in Microsoft Power Pivot
Power QueryConnect ServerAccess HarperDB Data in Microsoft Power Query
Qlik CloudConnect ServerCreate Apps from HarperDB Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query HarperDB in QlikView over ODBC
RJDBCAnalyze HarperDB in R (JDBC)
RODBCAnalyze HarperDB in R (ODBC)
RapidMinerJDBCConnect to HarperDB in RapidMiner
RedashConnect ServerQuery, Visualize, and Share live HarperDB Data in Redash
SAP Analytics CloudConnect ServerAnalyze HarperDB Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for HarperDB
SAP Crystal ReportsJDBCPublish Reports with HarperDB in Crystal Reports (JDBC)
SASODBCUse the CData ODBC Driver for HarperDB in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for HarperDB in SAS JMP
SisenseJDBCVisualize Live HarperDB in Sisense
Spago BIJDBCConnect to HarperDB in SpagoBI
TableauTableauVisualize HarperDB in Tableau Desktop
TableauConnect ServerVisualize HarperDB in Tableau Desktop (Connect Server)
Tableau CloudConnect ServerBuild HarperDB Visualizations in Tableau Cloud
Tableau ServerTableauPublish HarperDB-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize HarperDB in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize HarperDB Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on HarperDB from Spotfire Server
VisioODBCLink Visio Shapes to HarperDB

Back to top

ETL & Replication


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

Back to top

Data Virtualization


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

Back to top

Software Development


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

Back to top

Data Management


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

Back to top

Workflow Automation


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

Back to top

Ready to get started?

Learn more:

HarperDB Connectivity Solutions

In this article

Related articles