CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To a JDBC Data Source for Gong
Create Gong data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Enable the Greenhouse JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Greenhouse data.
-
How to Build an ETL App for Campaigner Data in Python with CData
Create ETL applications and real-time data pipelines for Campaigner data in Python with petl.
-
Create Informatica Mappings From/To a JDBC Data Source for Ontraport
Create Ontraport data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Work with SAP SuccessFactors LMS Data in ETL Validator JDBC
Connect to SAP SuccessFactors LMS from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live Shortcut Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Shortcut data from your Excel spreadsheets.
-
Integrating Gumloop with Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Search results within automated workflows.
-
Integrating Dataiku with FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live FHIR data.
-
Automated Continuous Webex Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Webex replication to Google Cloud SQL.
-
Configure the CData JDBC Driver for Hubstaff in a Connection Pool in Tomcat
Connect to Hubstaff data from a connection pool in Tomcat.
-
Using the CData Software ODBC Driver for Oracle in PyCharm
Connect to Oracle as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle.
-
How to use SQLAlchemy ORM to access Salesforce Pardot Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesforce Pardot data.
-
How to Work with Teamwork Data in ETL Validator JDBC
Connect to Teamwork from ETL Validator jobs using the CData Software JDBC Driver.
-
Replicate Hubstaff Data to Multiple Databases
Replicate Hubstaff data to disparate databases with a point-and-click configuration.
-
How to Query Live SAP HANA XS Advanced Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP HANA XS Advanced data data in natural language using Python.
-
Connect to Impala Data from AWS Glue
Use CData Connect AI to gain access to live Impala data from your AWS Glue jobs.
-
Natively Connect to AlloyDB Data in PHP
The CData ODBC driver for AlloyDB enables you to create PHP applications with connectivity to AlloyDB data. Leverage the native support for ODBC in PHP.
-
Object-Relational Mapping (ORM) with Bugsnag Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Bugsnag data into a Java-based ORM framework, Hibernate.
-
Connecting Moonlit Workflow with ZohoExpense Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your ZohoExpense data in real time.
-
Automated Continuous Wistia Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Wistia replication to IBM DB2.
-
How to integrate Metabase with Bitly Data
Use CData Connect AI to connect to live Bitly data and create an interactive dashboard in Metabase from Bitly data.
-
Choosing the Best Method to Connect Mode to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Mode data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Autopilot Data from MySQL in Amazon QuickSight
Connect to Autopilot and build visualizations of Autopilot data using a MySQL Connection in Amazon QuickSight.
-
Connect to SAP Concur Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Concur data from HeidiSQL.
-
Stream Jira Assets Data into Apache Kafka Topics
Access and stream Jira Assets data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to create Visio diagrams from WordPress Data
Automatically update WordPress data with the changes you make to Visio master shapes.
-
Automated Quickbase Data Replication to Teradata
Use CData Sync to Customize and automate Quickbase data replication to Teradata.
-
Connect to Paylocity Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Paylocity data in the Denodo Virtual DataPort Administrator.
-
How to import Azure DevOps Data into Apache Solr
Use the CData Software JDBC Driver for Azure DevOps in Data Import Handler and create an automated import of Azure DevOps data to Apache Solr Enterprise Search platform.
-
How to integrate EnterpriseDB with Apache Airflow
Access and process EnterpriseDB data in Apache Airflow using the CData JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your HubDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your HubDB data for you.
-
Integrate Browserless Data in the Pentaho Report Designer
Publish reports based on Browserless data in the Pentaho BI tool.
-
How to Seamlessly Import FreeAgent Data into IBM SPSS Modeler
Integrate FreeAgent data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Live HBase Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live HBase data into custom reports in Power BI.
-
Access Live Chargebee Data in AWS Lambda
Connect to live Chargebee data in AWS Lambda using the CData JDBC Driver.
-
Analyze Live Apify Data in SAS Viya
Use CData Connect AI to connect to Apify data from SAS Viya and deploy self-service analytics using live Apify data.
-
Connect to SAP HANA XS Advanced Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP HANA XS Advanced data from Crystal Reports.
-
Load Harvest Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Harvest data to a database.
-
Analyze Monday.com Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Monday.com data with the CData JDBC Driver for Monday.com.
-
Build SharePoint-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SharePoint data.
-
Publish Adobe Experience Manager-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Adobe Experience Manager data.
-
Access OnePageCrm Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live OnePageCrm data from HeidiSQL.
-
Process & Analyze CouchDB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live CouchDB Data.
-
How to use SQLAlchemy ORM to access HubDB Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of HubDB data.
-
How to connect to Timely Data from IntelliJ
Integrate connectivity to Timely data with wizards in IntelliJ.
-
Extract, Transform, and Load Tanda Data in Informatica PowerCenter
Create a simple Workflow for Tanda data in Informatica PowerCenter.
-
Connect to Nethunt Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Nethunt and the SQL Gateway to access Nethunt data from Google Apps Script.
-
Integrating Kiro with SQL Analysis Services Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
A PostgreSQL Interface for SAP ByDesign Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP ByDesign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to MYOB AccountRight Data in DBArtisan
Use wizards in DBArtisan to configure MYOB AccountRight data as a data source.
-
Connect to SendPulse Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to SendPulse and work with SendPulse data in your FileMaker application.
-
Query Salesforce Pardot Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Salesforce Pardot data from Node.js.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP HANA XS Advanced
Create SAP HANA XS Advanced data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Cursor with Redshift Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Connect to GitHub Data from HeidiSQL
Use CData Connect AI to connect to and query live GitHub data from HeidiSQL.
-
Integrate Cline with Live ZohoInvoice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live ZohoInvoice data from within your IDE.
-
Analyze ZohoPeople Data in Cognos Analytics
Use CData Connect AI to connect to ZohoPeople Data from Cognos Analytics and analyze live ZohoPeople data.
-
How to Connect to Live SparkPost Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SparkPost data for you.
-
Integrate Bugsnag Data in Pentaho Data Integration
Build ETL pipelines based on Bugsnag data in the Pentaho Data Integration tool.
-
Integrate Cline with Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Dynamics CRM data from within your IDE.
-
Access Azure Data Catalog Data from MySQL in Amazon QuickSight
Connect to Azure Data Catalog and build visualizations of Azure Data Catalog data using a MySQL Connection in Amazon QuickSight.
-
Query Live SAP Concur Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SAP Concur data directly from the development environment.
-
Build IBM Informix-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live IBM Informix data without replication.
-
Getting Started with the CData Power BI Connector for Gong
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Publish Crystal Reports on Productboard Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Productboard data.
-
Build Sybase IQ-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sybase IQ Data and create custom apps in Mendix.
-
Import Real-Time Tanda Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Tanda data in ColdFusion.
-
A Comparison of Drivers for Elasticsearch
In this article, we compare the read performance and resource usage of the CData Software JDBC Driver for Elasticsearch with the native JDBC Driver.
-
Automated Continuous OnePageCrm Replication to MongoDB
Use CData Sync for automated, continuous, customizable OnePageCrm replication to MongoDB.
-
Use CData Connect AI to Access Quickbase Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Quickbase data in the Power Pivot business intelligence tool.
-
Automate Elorus Data Replication to Azure Synapse
Use CData Sync to customize and automate Elorus data replication to Azure Synapse.
-
Automated Continuous Vertica Replication to MySQL
Use CData Sync for automated, continuous, customizable Vertica replication to MySQL.
-
How to Connect DBeaver to Paddle via a JDBC Driver
Manage Paddle data with visual tools in DBeaver like the query browser.
-
Query Live Google Directory Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Google Directory data directly from the development environment.
-
Connect to Microsoft Planner Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Planner data from HeidiSQL.
-
Use the CData ODBC Driver for ActiveCampaign from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ActiveCampaign to connect to ActiveCampaign data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ActiveCampaign data in Excel.
-
Connect to Gong from Asprova with CData Software ODBC Driver for Gong
This article shows how to connect faster to Gong data from Asprova.
-
Access Live Power BI XMLA Data in Coginiti Pro
Connect to and query live Power BI XMLA data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Publish Crystal Reports on Cvent Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Cvent data.
-
Create Power BI Reports on Real-Time HubDB Data
Use the CData ODBC Driver for HubDB to visualize HubDB data in Power BI Desktop.
-
Visualize Live Mailjet Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Mailjet data.
-
Build Asana Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Asana data and build visualizations in Tableau.
-
Enable the Salesforce Data 360 JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesforce Data 360 data.
-
Integrating Claude Code CLI with Shortcut Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata - all without leaving the terminal.
-
Use Claude to Talk to Your SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SAS xpt data for you.
-
Connect to Google Forms Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Forms data from Crystal Reports.
-
How to load Contentful data into Elasticsearch via Logstash
Introducing a simple method to load Contentful data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Apps with Live Oracle Sales data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle Sales data into the Adalo platform and build custom mobile and web applications with real-time Oracle Sales data.
-
Connect to Apollo Data from PowerBuilder via JDBC
This article demonstrates how to access Apollo data from PowerBuilder using the Apollo JDBC Driver.
-
Integrating Claude Code CLI with Moosend Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata - all without leaving the terminal.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for JobNimbus
Provide connectivity to JobNimbus data through an SAP BusinessObjects universe.
-
Import and Visualize Supabase Data in Power View
Create data visualizations based on Supabase data in Excel.
-
Analyze Couchbase Data in Cognos Analytics
Use CData Connect AI to connect to Couchbase Data from Cognos Analytics and analyze live Couchbase data.
-
How to Seamlessly Import HelloSign Data into IBM SPSS Modeler
Integrate HelloSign data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Bannerbear Data to Multiple Databases via the CData Sync CLI
Replicate Bannerbear data to disparate databases with a single configuration.
-
Build Dashboards with Todoist Data in DBxtra
Create dynamic dashboards and perform analytics based on Todoist data in DBxtra.
-
Object-Relational Mapping (ORM) with FreshBooks Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to FreshBooks data into a Java-based ORM framework, Hibernate.
-
Migrating data from Hacker News to Databricks using CData SSIS Components.
Easily push Hacker News data to Databricks using the CData SSIS Tasks for Hacker News and Databricks.
-
Integrate Live SageHR Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live SageHR data from within the IDE.
-
Connect to and Query ServiceDesk Plus Data in QlikView over ODBC
Create data visualizations with ServiceDesk Plus data in QlikView.