CData Software - Knowledge Base
Recent Articles
-
How to work with SageHR Data in Apache Spark using SQL
Access and process SageHR Data in Apache Spark using the CData Software JDBC Driver.
-
Create Reports with Klaviyo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Klaviyo data.
-
Access Live Email Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Email data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate with Anaplan Data in JReport Designer
Create charts and reports based on Anaplan data in JReport Designer.
-
Integrate MySQL with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MySQL with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MySQL data.
-
Create Data Visualizations Based On ClickUp Data in Mode
Use CData Connect AI to connect to ClickUp Data from Mode and build visualizations using live ClickUp data.
-
Analyze Act CRM Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Act CRM data with the CData JDBC Driver for Act CRM.
-
How to Work with Humanity Data in ETL Validator JDBC
Connect to Humanity from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Dify with Live Twitter Ads Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Twitter Ads data.
-
How to work with ClickTime Data in Apache Spark using SQL
Access and process ClickTime Data in Apache Spark using the CData Software JDBC Driver.
-
Connecting GenSpark with Bullhorn CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Bullhorn CRM data without any replication or custom integration required.
-
Integrating Codex with REST 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 Zoho Inventory
Provide connectivity to Zoho Inventory data through an SAP BusinessObjects universe.
-
Create Reports from ActiveCampaign Data in Looker Studio
Use CData Connect AI to gain access to live ActiveCampaign data and create custom reports in Looker Studio.
-
Replicate Multiple PostgreSQL Accounts
Replicate multiple PostgreSQL accounts to one or many databases.
-
Work with JotForm Data in FoxPro
Load JotForm data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Cursor with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Klaviyo data from within the editor.
-
Automated Continuous LeadDesk Replication to Snowflake
Use CData Sync for automated, continuous, customizable LeadDesk replication to Snowflake.
-
ETL ZohoExpense in Oracle Data Integrator
This article shows how to transfer ZohoExpense data into a data warehouse using Oracle Data Integrator.
-
Rapidly Develop Hacker News-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Hacker News.
-
Analyze IBM Cloud Object Storage Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze IBM Cloud Object Storage data in Microsoft R Open.
-
Automated Continuous ClickTime Replication to MySQL
Use CData Sync for automated, continuous, customizable ClickTime replication to MySQL.
-
Connect to Timely Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Timely data in Airbyte.
-
Integrate Recurly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Recurly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Recurly data.
-
How to connect to Discourse Data from Spring Boot
Connect to Discourse in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous WooCommerce Replication to SingleStore
Use CData Sync for automated, continuous, customizable WooCommerce replication to SingleStore.
-
Natively Connect to Jira Assets Data in PHP
The CData ODBC driver for Jira Assets enables you to create PHP applications with connectivity to Jira Assets data. Leverage the native support for ODBC in PHP.
-
Use Databricks Agent Bricks to Talk to Your OneNote Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your OneNote data for you.
-
Automate Coinbase Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Coinbase data from PowerShell? This article demonstrates how to utilize the Coinbase Cmdlets for tasks like connecting to Coinbase data, automating operations, downloading data, and more.
-
Getting Started with the CData ADO.NET Provider for NASA
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access ShipStation Data from MySQL in PHP
Connect to ShipStation through the standard MySQL libraries in PHP.
-
Build AI/ML Models with Live SAP HANA XS Advanced Data using Dataiku
Connect SAP HANA XS Advanced Data with Dataiku using the CData JDBC Driver for SAP HANA XS Advanced.
-
Query Live SFTP Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live SFTP data through a conversational interface.
-
How to connect SharePoint with MariaDB Data through external lists
Provide MariaDB data to SharePoint users as an external list.
-
Build Apps with Live BambooHR Data Using the Low-Code Development Platform of Mendix
Connect BambooHR data with Mendix to build apps using the CData API Driver for JDBC.
-
How to Build an ETL App for AgileCRM Data in Python with CData
Create ETL applications and real-time data pipelines for AgileCRM data in Python with petl.
-
Interact with Live Zoho CRM Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Zoho CRM data.
-
Use Claude to Talk to Your Quickbase 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 Quickbase data for you.
-
Automated Continuous Google Spanner Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Spanner replication to MySQL.
-
Automated Continuous FHIR Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable FHIR replication to Apache Kafka.
-
Connect to Amazon Marketplace Data in Ruby
Connect to Amazon Marketplace data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software ODBC Driver for FHIR in MicroStrategy Desktop
Connect to FHIR data in MicroStrategy Desktop using the CData Software ODBC Driver for FHIR.
-
Build Dashboards with PingOne Data in DBxtra
Create dynamic dashboards and perform analytics based on PingOne data in DBxtra.
-
Integrating LlamaIndex with Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Act-On data in real time.
-
Integrating Antigravity CLI with Azure Analysis Services data via CData CLI
Connect Azure Analysis Services data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Teamgate Data from a Connection Pool in Jetty
The Teamgate JDBC Driver supports connection pooling: This article shows how to connect faster to Teamgate data from Web apps in Jetty.
-
Build Apps with Live LDAP Objects Using the Low-Code Development Platform of Mendix
Connect LDAP objects with Mendix to build apps using the CData JDBC Driver for LDAP.
-
Analyze SAP Business One Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Business One data in Microsoft R Open.
-
Connect to Quaderno Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Quaderno and the SQL Gateway to access Quaderno data from Google Apps Script.
-
Connect to BambooHR Data in Google Apps Script via Connect AI
Use CData Connect AI to access BambooHR data in Google Apps Script.
-
Connect to GitHub Data from PowerBuilder via JDBC
This article demonstrates how to access GitHub data from PowerBuilder using the GitHub JDBC Driver.
-
Access Live FreshBooks Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live FreshBooks data from your Excel spreadsheets.
-
How to Visualize NetSuite Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live NetSuite data in Python.
-
Automated Continuous Tavily Replication to SingleStore
Use CData Sync for automated, continuous, customizable Tavily replication to SingleStore.
-
Access SAP Fieldglass Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Fieldglass data from HeidiSQL.
-
Integrate Oracle SCM Data in the Pentaho Report Designer
Publish reports based on Oracle SCM data in the Pentaho BI tool.
-
Visualize Factorial Data in Tableau
The CData ODBC driver for Factorial enables you integrate Factorial data into Tableau dashboards.
-
Migrating data from JSON to Databricks using CData SSIS Components.
Easily push JSON services to Databricks using the CData SSIS Tasks for JSON and Databricks.
-
Provide OData Services of Dotmailer Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Dotmailer data by developing a WCF Service Application.
-
Getting Started with the CData Power BI Connector for SFTP
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SFTP.
-
Add SpaceX Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SpaceX with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connecting Moonlit Workflow with eBay Analytics 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 eBay Analytics data in real time.
-
Search External Printify Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Printify data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Printify Data objects that you can access from apps and the dashboard.
-
Integrate with Live Bannerbear Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Bannerbear from the MuleSoft Anypoint Platform to integrate live Bannerbear data into custom reports and dashboards.
-
Use the CData Software JDBC Driver for Customer.io in MicroStrategy
Connect to Customer.io data in MicroStrategy Developer using the CData Software JDBC Driver for Customer.io.
-
Easily Integrate Airtable Data in Lazarus Pascal IDE
Learn how to easily integrate live Airtable data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build MVC Applications with Connectivity to Mixpanel Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Mixpanel from an ASP.NET MVC application.
-
Automated Continuous SharePoint Excel Services Replication to Snowflake
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Snowflake.
-
Analyze Mistral AI Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Mistral AI data with the CData JDBC Driver for Mistral AI.
-
Bridge Ontraport Connectivity with Apache NiFi
Access and process Ontraport data in Apache NiFi using the CData JDBC Driver.
-
Publish Azure Data Lake Storage-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Azure Data Lake Storage data.
-
Visualize Nuclia 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 Nuclia data into TIBCO Spotfire.
-
How to create Microsoft Dataverse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Dataverse data in MySQL .
-
Automated Continuous Splunk Replication to Oracle
Use CData Sync for automated, continuous, customizable Splunk replication to Oracle.
-
Build Automated Workflows with Live Microsoft Planner Data in Workato
Use CData Connect AI to connect to live Microsoft Planner data and build automated workflows in Workato.
-
Build Asana-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 Asana data without replication.
-
Publish Microsoft Planner-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Planner data.
-
Use the CData Software ODBC Driver for CloudConvert in MicroStrategy Desktop
Connect to CloudConvert data in MicroStrategy Desktop using the CData Software ODBC Driver for CloudConvert.
-
Use Microsoft Copilot Studio to talk to your Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Epicor Kinetic data for you.
-
Moving Data from Invoiced to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Invoiced data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Replicate Multiple CircleCI Accounts via the CData Sync CLI
Replicate multiple CircleCI accounts to one or many databases.
-
Build Automated Workflows with Live Gong Data in Workato
Use CData Connect AI to connect to live Gong data and build automated workflows in Workato.
-
Access Live Adobe Analytics Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Adobe Analytics data from your Google Sheets.
-
Access RabbitMQ Data from MySQL in PHP
Connect to RabbitMQ through the standard MySQL libraries in PHP.
-
How to Connect to Pushbullet Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Pushbullet data. Leverage the pyodbc module for ODBC in Python.
-
Connecting Agentforce with MySQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your MySQL data for you.
-
Visualize Live SendPulse Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SendPulse data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Phoenix Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Phoenix replication to Google Cloud SQL.
-
Operational Reporting on Google Calendar Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Calendar data.
-
How to Work with Avalara AvaTax Data in AWS Glue Jobs Using JDBC
Connect to Avalara AvaTax from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Manage Egnyte Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Egnyte.
-
Connect to Opsgenie Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Opsgenie as an External Source in Dremio.
-
Validate PingOne Data with QuerySurge
Access and validate PingOne data in QuerySurge using the CData JDBC Driver.
-
DataBind Controls to Redis Data in C++Builder
DataBind to Redis data in C++Builder with standard components and controls.
-
Load Close Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Close data to a database.
-
Explore Geographical Relationships in Phoenix Data with Power Map
Create data visualizations with Phoenix data in Power Map.
-
Add QuickBooks Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for QuickBooks with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Splunk Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Splunk Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Rootly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Rootly to connect to Rootly data and execute queries in PowerBuilder.
-
Automated Continuous AgileCRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable AgileCRM replication to IBM DB2.