Ready to get started?

Learn more:

Certinia Connectivity Solutions

Certinia Integration Guides and Tutorials



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

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

Back to top

ETL & Replication


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

Back to top

Data Virtualization



Back to top

Software Development


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

Back to top

Data Management



Back to top

Workflow Automation



Back to top