Read the blog
 
Certinia
 

Connect to live Certinia data from reporting tools, databases, and custom applications through standards-based drivers.


Integrate with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


"Excellent stuff. I am finally getting the hang of this and it is brilliant may I add!"

- Mark Couvaras, General Manager, Databarracks



Connect to Certinia Data from Anywhere!

Easily access live Certinia data from BI, Analytics, Reporting, ETL, & Custom Apps.







Certinia Integration Guides and Tutorials

BI & Analytics


Our drivers offer the fastest and easiest way to connect real-time Certinia data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Certinia data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations


Alteryx Designer: Prepare, Blend, and Analyze Certinia in Alteryx Designer (ODBC) Amazon QuickSight: Build Interactive Dashboards from Certinia in Amazon QuickSight Aqua Data Studio: Connect to Certinia in Aqua Data Studio AWS Databricks: Process & Analyze Certinia Data in Databricks (AWS) Birst: Build Visualizations of Certinia in Birst BIRT: Design BIRT Reports on Certinia Clear Analytics: Build Charts with Certinia in Clear Analytics DBxtra: Build Dashboards with Certinia in DBxtra Domo: Create Datasets from Certinia in Domo Workbench Dundas BI: Build Dashboards with Certinia in Dundas BI Excel (on Mac OS): Work with Certinia Data in MS Excel on Mac OS X FineReport: Feed Certinia into FineReport IBM Cognos BI: Create Data Visualizations in Cognos BI with Certinia Infragistics Reveal: Analyze Certinia Data in Infragistics Reval JasperServer: Create Certinia Reports on JasperReports Server Jaspersoft BI Suite: Connect to Certinia in Jaspersoft Studio JReport Designer: Integrate with Certinia in JReport Designer Klipfolio: Create Certinia-Connected Visualizations in Klipfolio KNIME: Enable the Certinia JDBC Driver in KNIME LINQPad: Working with Certinia in LINQPad Microsoft SSAS: Build an OLAP Cube in SSAS from Certinia MicroStrategy: Connect to Live Certinia in MicroStrategy through Connect Server MicroStrategy: Use the CData JDBC Driver for Certinia in MicroStrategy Microstrategy Desktop: Use the CData JDBC Driver for Certinia in MicroStrategy Desktop Microstrategy Web: Use the CData JDBC Driver for Certinia in MicroStrategy Web OBIEE: Certinia Reporting in OBIEE with the Certinia JDBC Driver pandas: Use pandas to Visualize Certinia in Python Pentaho Report Designer: Integrate Certinia in the Pentaho Report Designer Power BI Desktop: Author Power BI Reports on Real-Time Certinia Power BI Service: Visualize Live Certinia in the Power BI Service Power Pivot: Access Certinia Data in Microsoft Power Pivot Power Query: Access Certinia Data in Microsoft Power Query QlikView: Connect to and Query Certinia in QlikView over ODBC R: Analyze Certinia in R (JDBC) R: Analyze Certinia in R (ODBC) RapidMiner: Connect to Certinia in RapidMiner Redash: Build Certinia-Connected Dashboards in Redash SAP Analytics Cloud: Analyze Certinia in SAP Analytics Cloud SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Certinia SAP Crystal Reports: Publish Reports with Certinia in Crystal Reports SAS: Use the CData ODBC Driver for Certinia in SAS for Real-Time Reporting and Analytics SAS JMP: Use the CData ODBC Driver for Certinia in SAS JMP Sisense: Visualize Live Certinia in Sisense Spago BI: Connect to Certinia in SpagoBI Tableau: Visualize Certinia in Tableau Desktop Tableau Cloud: Build Certinia Visualizations in Tableau Cloud Tableau Server: Publish Certinia-Connected Dashboards in Tableau Server TIBCO Spotfire: Visualize Certinia in TIBCO Spotfire through ADO.NET TIBCO Spotfire: Visualize Certinia Data in TIBCO Spotfire TIBCO Spotfire Server: Operational Reporting on Certinia from Spotfire Server Visio: Link Visio Shapes to Certinia

ETL, Replication, & Warehousing


From drivers and adapters that extend your favorite ETL tools with Certinia connectivity to ETL/ELT tools for replication — our Certinia integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with Certinia to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.


Popular Data Warehousing Integrations


Amazon Redshift: Automated Continuous Certinia Replication to Amazon Redshift Amazon S3: Automated Continuous Certinia Replication to Amazon S3 Apache Airflow: Bridge Certinia Connectivity with Apache Airflow Apache Camel: Integrate with Certinia using Apache Camel Apache Cassandra: Automated Continuous Certinia Replication to Apache Cassandra Apache Kafka: Automated Continuous Certinia Replication to Apache Kafka Apache NiFi: Bridge Certinia Connectivity with Apache NiFi Apache NiFi Batch Operations: Perform Batch Operations with Certinia Data in Apache NiFi AWS Glue: Build ETL Jobs with Certinia Data in AWS Glue Studio Azure Data Lake: Automated Continuous Certinia Replication to Azure Data Lake Azure Synapse: Automated Continuous Certinia Replication to Azure Synapse BIML: Use Biml to Build SSIS Tasks to Replicate Certinia to SQL Server CloverDX: Connect to Certinia in CloverDX (formerly CloverETL) Couchbase: Automated Continuous Certinia Replication to Couchbase CSV: Automated Continuous Certinia Replication to Local Delimited Files Databricks: Automated Continuous Certinia Replication to Databricks FoxPro: Work with Certinia in FoxPro Google AlloyDB: Automated Continuous Certinia Replication to Google AlloyDB Google BigQuery: Automated Continuous Certinia Replication to Google BigQuery Google Cloud SQL: Automated Continuous Certinia Replication to Google Cloud SQL Google Data Fusion: Build Certinia-Connected ETL Processes in Google Data Fusion Heroku / Salesforce Connect: Replicate Certinia for Use in Salesforce Connect HULFT Integrate: Connect to Certinia in HULFT Integrate IBM DB2: Automated Continuous Certinia Replication to IBM DB2 Informatica Cloud: Integrate Certinia in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Certinia Jaspersoft ETL: Connect to Certinia in Jaspersoft Studio Microsoft Access: Automated Continuous Certinia Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous Certinia Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to Certinia Microsoft Power Automate: Build Certinia-Connected Automated Tasks with Power Automate (Desktop) MongoDB: Automated Continuous Certinia Replication to MongoDB MySQL: Automated Continuous Certinia Replication to MySQL Oracle Data Integrator: ETL Certinia in Oracle Data Integrator Oracle Database: Automated Continuous Certinia Replication to Oracle petl: Extract, Transform, and Load Certinia in Python PostgreSQL: Automated Continuous Certinia Replication to PostgreSQL Replicate to CSV: Replicate Certinia to MySQL with PowerShell SAP HANA: Automated Continuous Certinia Replication to SAP HANA SingleStore: Automated Continuous Certinia Replication to SingleStore SnapLogic: Integrate Certinia with External Services using SnapLogic Snowflake: Automated Continuous Certinia Replication to Snowflake SQL Server: Automated Continuous Certinia Replication to SQL Server SQL Server Linked Server: Connect to Certinia as a SQL Server Linked Server SQLite: Automated Continuous Certinia Replication to SQLite Talend: Connect to Certinia and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to Certinia in UiPath Studio Vertica: Automated Continuous Certinia Replication to a Vertica Database

Workflow & Automation Tools


Connect to Certinia from popular data migration, ESB, iPaaS, and BPM tools.

Our drivers and adapters provide straightforward access to Certinia data from popular applications like BizTalk, MuleSoft, SQL SSIS, Microsoft Flow, Power Apps, Talend, and many more.

Popular Workflow & Automation Tool Integrations


MuleSoft Anypoint: Access Certinia in Anypoint Using SQL Power Automate: Integrate Certinia into Power Automate Automated Tasks SSIS Export: Export Data from SQL Server to Certinia through SSIS SSIS Import: Import Certinia Data into SQL Server using SSIS SSIS Lookup: Insert New or Update Existing Certinia Records from SQL Server

Developer Tools & Technologies


The easiest way to integrate with Certinia from anywhere. Our Certinia drivers offer a data-centric model for Certinia that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:



Popular Developer Integrations


.NET Charts: DataBind Charts to Certinia .NET QueryBuilder: Rapidly Develop Certinia-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with Certinia Apache Spark: Work with Certinia in Apache Spark Using SQL AppSheet: Create Certinia-Connected Business Apps in AppSheet C++Builder: DataBind Controls to Certinia Data in C++Builder ColdFusion: Query Certinia in ColdFusion Using JDBC ColdFusion: Query Certinia in ColdFusion Using ODBC Dash: Use Dash & Python to Build Web Apps on Certinia Delphi: DataBind Controls to Certinia Data in Delphi DevExpress: DataBind Certinia to the DevExpress Data Grid EF - Code First: Access Certinia with Entity Framework 6 EF - LINQ: LINQ to Certinia EF - MVC: Build MVC Applications with Connectivity to Certinia Filemaker Pro: Bidirectional Access to Certinia from FileMaker Pro Filemaker Pro (on Mac): Bidirectional Access to Certinia from FileMaker Pro (on Mac) Go: Write a Simple Go Application to work with Certinia on Linux Google Apps Script: Connect to Certinia in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with Certinia Entities in Java IntelliJ: Connect to Certinia in IntelliJ JBoss: Connect to Certinia from a Connection Pool in JBoss JDBI: Create a Data Access Object for Certinia using JDBI JRuby: Connect to Certinia in JRuby Microsoft Power Apps: Integrate Live Certinia into Custom Business Apps Built in Power Apps NodeJS: Query Certinia in Node.js (via Connect Server) NodeJS: Query Certinia through ODBC in Node.js PHP: Access Certinia in PHP through the Cloud Hub PHP: Natively Connect to Certinia in PHP PowerBuilder: Connect to Certinia from PowerBuilder PowerShell: Pipe Certinia to CSV in PowerShell PyCharm: Using the CData ODBC Driver for Certinia in PyCharm Python: Connect to Certinia in Python on Linux/UNIX React: Build Dynamic React Apps with Certinia Data Ruby: Connect to Certinia in Ruby RunMyProcess: Connect to Certinia in RunMyProcess RunMyProcess DSEC: Connect to Certinia in DigitalSuite Studio through RunMyProcess DSEC SAP UI5: Integrate Real-Time Access to Certinia in SAPUI5 MVC Apps Servoy: Build Certinia-Connected Apps in Servoy Spring Boot: Access Live Certinia Data in Spring Boot Apps SQLAlchemy: Use SQLAlchemy ORMs to Access Certinia in Python Tomcat: Configure the CData JDBC Driver for Certinia in a Connection Pool in Tomcat Unqork: Create Certinia-Connected Applications in Unqork VCL App (RAD Studio): Build a Simple VCL Application for Certinia WebLogic: Connect to Certinia from a Connection Pool in WebLogic


When Only the Best Certinia Drivers Will Do

See what customers have to say about our products and support.





Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below:

Using the Certinia Drivers