CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Klipfolio Replication to Snowflake
Use CData Sync for automated, continuous, customizable Klipfolio replication to Snowflake.
-
How to Work with SageHR Data in ETL Validator JDBC
Connect to SageHR from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Instantly Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Instantly from HeidiSQL.
-
How to publish and share AdRoll Data dashboards with Tableau Server
The CData ODBC driver for AdRoll enables you integrate AdRoll into Tableau dashboards.
-
Use the CData Software JDBC Driver for Drip in MicroStrategy Desktop
Connect to Drip in MicroStrategy Desktop using the CData Software JDBC Driver for Drip.
-
Connect to Box Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Box to connect to Box and execute queries in PowerBuilder.
-
Integrating OpenCode Terminal with Slack 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 PolarTeamPro Data in HULFT Integrate
Connect to PolarTeamPro as a JDBC data source in HULFT Integrate
-
Automated Continuous Pingdom Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Pingdom replication to Google Cloud SQL.
-
Working with Reply.io Data in LINQPad
Execute LINQ queries to Reply.io in LINQPad.
-
Use the CData API Server to Access MarkLogic Data in Microsoft PowerPivot
Use the CData API Server to connect to live MarkLogic in the Power Pivot business intelligence tool.
-
Replicate Multiple SAP ByDesign Accounts via the CData Sync CLI
Replicate multiple SAP ByDesign accounts to one or many databases.
-
Configure the CData JDBC Driver for OData in a Connection Pool in Tomcat
Connect to OData from a connection pool in Tomcat.
-
Automated Continuous LinkedIn Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LinkedIn replication to OneLake in Microsoft Fabric.
-
Access Live Zoho Creator Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoho Creator from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Excel Spreadsheet Automation on Intercom Data with the QUERY Formula
Pull data from Intercom, automate spreadsheets, and more with the QUERY formula.
-
Integrating Claude Code CLI with SAP Business One 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.
-
How to integrate Adobe Target with Apache Airflow
Access and process Adobe Target in Apache Airflow using the CData JDBC Driver.
-
How to connect to Teamgate Data from IntelliJ
Integrate connectivity to Teamgate with wizards in IntelliJ.
-
Publish Phoenix-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apache Phoenix.
-
Connect to Teradata Data from a Connection Pool in JBoss
Integrate Teradata into Java servlets: Use the Management Console in JBoss to install the Teradata JDBC Driver.
-
Integrate with Ontraport Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Ontraport to a JSON file on disk.
-
Model, Search, and Visualize Live Tally Data in ThoughtSpot
Use CData Connect AI to connect to live Tally ERP for modeling, searching, and visualizing.
-
Object-Relational Mapping (ORM) with JobNimbus 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 JobNimbus into a Java-based ORM framework, Hibernate.
-
Stream ZohoPeople Data into Apache Kafka Topics
Access and stream ZohoPeople in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Edit and Search Cassandra External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Apache Cassandra to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Cassandra objects that you can access from apps and the dashboard.
-
How to Build an ETL App for Basecamp Data in Python with CData Connect AI
Build ETL pipelines that read and write live Basecamp in Python with petl and the CData Connect AI Python SDK.
-
How to connect to SharePoint Excel Services Data in DBVisualizer
Integrate SharePoint Excel Services with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software JDBC Driver for HelloSign in MicroStrategy Desktop
Connect to HelloSign in MicroStrategy Desktop using the CData Software JDBC Driver for HelloSign.
-
Easily Integrate Blackbaud FE NXT Data in Lazarus Pascal IDE
Learn how to easily integrate live Blackbaud FE NXT in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous PayPal Replication to AlloyDB
Use CData Sync for automated, continuous, customizable PayPal replication to AlloyDB.
-
Build PostgreSQL-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PostgreSQL and build web apps with connectivity to live PostgreSQL.
-
Automated Continuous LionDesk Replication to Vertica
Use CData Sync for automated, continuous, customizable LionDesk replication to Vertica.
-
Build Pipelines with Live Okta Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Okta from Google Cloud Data Fusion, enabling the integration of live Okta into the building and management of effective data pipelines.
-
Access SAP BusinessObjects BI Data from MySQL in Amazon QuickSight
Connect to SAP BusinessObjects BI and build visualizations of SAP BusinessObjects BI using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Mailjet Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Mailjet replication to Azure SQL Database.
-
Automated Continuous Zoho CRM Replication to Vertica
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Vertica.
-
Integrating GitHub Copilot CLI with Flowlu 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.
-
DataBind SharePoint Excel Services Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SharePoint Excel Services with the DevExpress Windows Forms and Web controls to provide SharePoint Excel Services to a chart.
-
Integrating Rootly Data in Talend Cloud Data Management Platform
Connect Rootly Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Semantic Layer Views for Gorgias Data in APOS Live Data Gateway
Use the CData Connector for Gorgias in APOS Live Data Gateway to build Semantic Layer Views for Gorgias.
-
Integrate Live ServiceNow Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to import ChargeOver Data into Apache Solr
Use the CData Software JDBC Driver for ChargeOver in Data Import Handler and create an automated import of ChargeOver to Apache Solr Enterprise Search platform.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Kintone using the Model Context Protocol.
-
Connect to ConstantContact Data in Aqua Data Studio
Access ConstantContact from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Rootly Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
DataBind ElevenLabs Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ElevenLabs to a chart.
-
Access Aircall Data from MySQL in PHP
Connect to Aircall through the standard MySQL libraries in PHP.
-
Connect to Excel Online Data in Claris FileMaker Pro
Use the CData ODBC Driver for Excel Online in FileMaker Pro to connect to Excel Online and work with Microsoft Excel Online in your FileMaker applications.
-
DataBind Charts to Opsgenie Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Opsgenie from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Automate Tasks in Power Automate Using the CData API Server
Automate WordPress actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Access Live QuickBooks Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate QuickBooks Desktop into the statistical analysis tools available in SAS JMP. This article shows how to use QuickBooks Desktop in the Graph Builder and Query Builder.
-
Automated Continuous AdRoll Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable AdRoll replication to OneLake in Microsoft Fabric.
-
Create QuickBooks Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time QuickBooks data access from reports, embedded analytics, and more.
-
Build Close-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Close.
-
Publish Workday-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Workday.
-
Build Gmail-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Gmail Data and create custom apps in Mendix.
-
Use the CData API Server to Access AlloyDB Data in Microsoft PowerPivot
Use the CData API Server to connect to live Google AlloyDB in the Power Pivot business intelligence tool.
-
Build MVC Applications with Connectivity to Cassandra Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Cassandra from an ASP.NET MVC application.
-
Connect to Google Tasks Data in JRuby
Create a simple JRuby app with access to live Google Tasks.
-
How to import Missive Data into Apache Solr
Use the CData Software JDBC Driver for Missive in Data Import Handler and create an automated import of Missive to Apache Solr Enterprise Search platform.
-
Work with Live Azure DevOps Data in Power Query
Use CData Connect AI to connect to Azure DevOps and work with live Azure DevOps in Microsoft Power Query.
-
Query SAP SuccessFactors LMS Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP SuccessFactors LMS and perform CRUD operations on SAP SuccessFactors LMS from Node.js.
-
Connect to Act CRM Data in RazorSQL
Connect to Act CRM from wizards and query Act CRM from the GUI in the RazorSQL database management tool.
-
How to Connect the Power BI Service to Microsoft Dataverse: Complete Guide
Connect to the CData Software Power BI Connector for Microsoft Dataverse from PowerBI.com to provide real-time Microsoft Dataverse (CDS) across the organization.
-
Consume Sugar CRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sugar CRM feeds that reflect any changes in SAP Lumira.
-
Build Semantic Layer Views for Zoho Books Data in APOS Live Data Gateway
Use the CData Connector for Zoho Books in APOS Live Data Gateway to build Semantic Layer Views for Zoho Books.
-
Import Real-Time Adobe Commerce Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Adobe Commerce in ColdFusion.
-
Query OneNote Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft OneNote.
-
Object-Relational Mapping (ORM) with Telegram 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 Telegram into a Java-based ORM framework, Hibernate.
-
Visualize AdRoll Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load AdRoll into TIBCO Spotfire.
-
Visualize Sybase IQ Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Sybase IQ into TIBCO Spotfire.
-
Connecting GenSpark with BambooHR Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to BambooHR without any replication or custom integration required.
-
How to Access Live CampaignMonitor Data in Power Automate Desktop via ODBC
The CData ODBC Driver for CampaignMonitor enables you to integrate CampaignMonitor into workflows built using Microsoft Power Automate Desktop.
-
Edit and Search Cosmos DB External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Azure Cosmos DB to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Cosmos DB objects that you can access from apps and the dashboard.
-
Visualize Live Google Forms Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Forms.
-
Access SAP ByDesign Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Business ByDesign from your Oracle system.
-
Access Live LinkedIn Ads Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to LinkedIn Ads from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Dashboards and Visualize Live SAP SuccessFactors LMS Data in Geckoboard
Use CData Connect AI to connect to live SAP SuccessFactors LMS and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Spark Replication to Snowflake
Use CData Sync for automated, continuous, customizable Spark replication to Snowflake.
-
Provide OData Services of Testmonitor Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Testmonitor by developing a WCF Service Application.
-
Automated Continuous Jumpseller Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Jumpseller replication to Google Cloud SQL.
-
Choosing the Best Method to Connect DocuSign to SQL Server: 5 Options Explained
Discover multiple ways to connect and use DocuSign from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Configure the CData JDBC Driver for BambooHR in a Connection Pool in Tomcat
Connect to BambooHR from a connection pool in Tomcat.
-
Configure the CData JDBC Driver for Cloudflare in a Connection Pool in Tomcat
Connect to Cloudflare from a connection pool in Tomcat.
-
Connect to and Query Hugging Face Data in QlikView over ODBC
Create data visualizations with Hugging Face in QlikView.
-
Access Adobe Experience Manager Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Adobe Experience Manager from your Oracle system.
-
How to Connect the Power BI Service to CloudConvert: Complete Guide
Connect to the CData Software Power BI Connector for CloudConvert from PowerBI.com to provide real-time CloudConvert across the organization.
-
A PostgreSQL Interface for Suadeo Data (MySQL Remoting via JDBC)
Use the Remoting features of the Suadeo JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect the Power BI Service to Tickspot: Complete Guide
Connect to the CData Software Power BI Connector for Tickspot from PowerBI.com to provide real-time Tickspot across the organization.
-
Integrate Cline with Live LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live LinkedIn Ads from within your IDE.
-
Access Live Adobe Commerce Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Adobe Commerce through MCP integration.
-
Build Apps with Live FTP Data Using the Low-Code Development Platform of Mendix
Connect FTP Servers with Mendix to build apps using the CData JDBC Driver for FTP.
-
Migrating data from NetSuite to Snowflake using CData SSIS Components.
Easily push NetSuite CRM & ERP to Snowflake using the CData SSIS Tasks for NetSuite and Snowflake.
-
Using CData JDBC Drivers from IntelliJ IDEA
CData JDBC Drivers make it easy for Java developers to work with a variety of data sources. In this article we show how to use any CData JDBC Driver to create a JDBC data source in the IntelliJ Java IDE. You will then use the JDBC data source to execute queries in the Table Editor.
-
Getting Started with the CData ADO.NET Provider for GitHub
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for GitHub.
-
Bidirectional Access to Gong Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Gong in Filemaker Pro for Mac or Windows.
-
Building Dynamic Web Pages with Power BI XMLA Data Using AngularJS
Create single-page applications with live connectivity to Power BI XMLA using the CData API Server.
-
Connect to Box Data from AWS Glue
Use CData Connect AI to gain access to live Box from your AWS Glue jobs.
-
Use the CData Software ODBC Driver for Cosmos DB in MicroStrategy
Connect to Azure Cosmos DB in MicroStrategy Developer using the CData Software ODBC Driver for Cosmos DB.