CData Software - Knowledge Base
Recent Articles
-
Query SingleStore Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SingleStore entities in PHP by modeling them as objects.
-
Create Data Visualizations Based On Odoo Data in Mode
Use CData Connect AI to connect to Odoo Data from Mode and build visualizations using live Odoo data.
-
Using the CData Software ODBC Driver for Marketo in PyCharm
Connect to Marketo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Marketo.
-
Create Reports from PayPal Data in Looker Studio
Use CData Connect AI to gain access to live PayPal data and create custom reports in Looker Studio.
-
Connect to Greenplum Data from a Connection Pool in JBoss
Integrate Greenplum data into Java servlets: Use the Management Console in JBoss to install the Greenplum JDBC Driver.
-
Connect to Live ZohoMarketingHub Data in PostGresSQL Interface through CData Connect AI
Create a live connection to ZohoMarketingHub in CData Connect AI and connect to your ZohoMarketingHub data from PostgreSQL.
-
Getting Started with the CData SSIS Components for Zoho Books
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoho Books.
-
Analyze DocuSign Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of DocuSign data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to and Visualize Live Deel Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Deel data.
-
Automated Continuous Mistral AI Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Mistral AI replication to Google Cloud SQL.
-
Connect Redis to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Redis with IBM WebSphere for seamless data integration and connectivity.
-
How to integrate Metabase with Timely Data
Use CData Connect AI to connect to live Timely data and create an interactive dashboard in Metabase from Timely data.
-
Integrate Reckon Accounts Hosted Data in the Pentaho Report Designer
Publish reports based on Reckon Accounts Hosted data in the Pentaho BI tool.
-
Mailgun Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Mailgun data through CData Connect AI using different applications and tools.
-
Getting Started with the CData ODBC Driver for Azure Table
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Azure Table.
-
Build AI Agents with MySQL Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live MySQL data through CData Connect AI.
-
How to Easily Query Omnisend Data in OpenOffice Base
Connect to Omnisend data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrating LangGraph with Couchbase Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Couchbase data within automated workflows.
-
Rapidly Develop Printful-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 Printful.
-
Query Anaplan Data as a SQL Server Database in Node.js
Execute SQL Server queries against Anaplan data from Node.js.
-
Publish Reports with OneNote Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OneNote data.
-
Interact with Live Excel Online Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Excel Online data.
-
How to integrate Google Ad Manager with Apache Airflow
Access and process Google Ad Manager data in Apache Airflow using the CData JDBC Driver.
-
Analyze Splunk Data in Cognos Analytics
Use CData Connect AI to connect to Splunk Data from Cognos Analytics and analyze live Splunk data.
-
Connect to FreshBooks Data from HeidiSQL
Use CData Connect AI to connect to and query live FreshBooks data from HeidiSQL.
-
Use the CData Software ODBC Driver for MailChimp in SAS for Real-Time Reporting and Analytics
Connect to real-time MailChimp data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MailChimp.
-
Build Semantic Layer Views for MYOB AccountRight Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for MYOB AccountRight data.
-
Automated Continuous Exa Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Exa replication to Amazon Redshift.
-
Prepare, Blend, and Analyze HBase Data in Alteryx Designer (Connect AI)
Build workflows to access live HBase data for self-service data analytics.
-
Query Live ZohoPeople 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 ZohoPeople data through a conversational interface.
-
Access Gumroad Data from MySQL in Amazon QuickSight
Connect to Gumroad and build visualizations of Gumroad data using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData JDBC Driver for Placid
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Placid.
-
A PostgreSQL Interface for CapsuleCRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the CapsuleCRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Azure Table Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Table data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Adobe Experience Manager Data in Aqua Data Studio
Access Adobe Experience Manager data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
A PostgreSQL Interface for Bullhorn CRM Data using the CData ODBC Driver
Use the SQL Gateway and Bullhorn CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access TaxJar Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live TaxJar data from HeidiSQL.
-
Automated Continuous Azure Data Lake Storage Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage data replication to OneLake in Microsoft Fabric.
-
Automated Continuous DB2 for i Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable DB2 for i replication to delimited files (CSV/TSV).
-
Integrating Boomi Agentstudio with Airtable Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Airtable data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Databricks Data from a Connection Pool in JBoss
Integrate Databricks data into Java servlets: Use the Management Console in JBoss to install the Databricks JDBC Driver.
-
How to publish and share Salesforce Marketing Data dashboards with Tableau Server
The CData ODBC driver for Salesforce Marketing enables you integrate Salesforce Marketing data into Tableau dashboards.
-
Visualize Paddle Data in Tableau
The CData ODBC driver for Paddle enables you integrate Paddle data into Tableau dashboards.
-
Access FTP Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access FTP data from your Oracle system.
-
Integrate Unbounce with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Unbounce with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Unbounce data.
-
How to Connect to Live Zoho Inventory Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Zoho Inventory data through natural language.
-
Integrating GitHub Copilot with Active Directory 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 SAP HANA 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 SAP HANA data for you.
-
Integrating GitHub Copilot with Greenplum 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 Clio Data from a Connection Pool in Jetty
The Clio JDBC Driver supports connection pooling: This article shows how to connect faster to Clio data from Web apps in Jetty.
-
Integrate Google's Antigravity Agent with Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Impala data using the Model Context Protocol.
-
Visualize Dropbox 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 Dropbox data into TIBCO Spotfire.
-
Connecting Pipedream with Authorize.Net Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Authorize.Net data in real time.
-
Write a Simple Go Application to work with BambooHR Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to BambooHR data.
-
Bind Live Azure Data Lake Storage Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure Data Lake Storage data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to connect to Square Data from IntelliJ
Integrate connectivity to Square data with wizards in IntelliJ.
-
Design BIRT Reports on Bitbucket Data
Provide current Bitbucket data to your embedded analytics.
-
Work with RSS Feeds in FoxPro
Load RSS feeds into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Multiple CSV Accounts
Replicate multiple CSV accounts to one or many databases.
-
Connect to Live Zuora Data in MicroStrategy through CData Connect AI
Create a live connection to Zuora Data in CData Connect AI and connect to your Zuora data from MicroStrategy.
-
Connect to Grafana Data from a Connection Pool in Jetty
The Grafana JDBC Driver supports connection pooling: This article shows how to connect faster to Grafana data from Web apps in Jetty.
-
How to load Clockify data into Elasticsearch via Logstash
Introducing a simple method to load Clockify data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build a Singer.io Tap for Onfleet With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Onfleet data using the CData Python Connector.
-
Automated GraphQL Data Replication to Teradata
Use CData Sync to Customize and automate GraphQL data replication to Teradata.
-
Automated Continuous ZendeskSell Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Apache Kafka.
-
Publish SAP Ariba Procurement-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Ariba Procurement data.
-
Connect to Suadeo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Suadeo.
-
How to Access ZohoExpense Data Using Entity Framework
This article shows how to access ZohoExpense data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Codex with Paddle 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.
-
Access Live Confluence Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Confluence data through MCP integration.
-
Integrating OpenCode with Spark 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.
-
Excel Spreadsheet Automation on Splunk Data with the QUERY Formula
Pull data from Splunk, automate spreadsheets, and more with the QUERY formula.
-
Build Apps with Live Bannerbear data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Bannerbear data into the Adalo platform and build custom mobile and web applications with real-time Bannerbear data.
-
Back Up ZohoInvoice data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ZohoInvoice data data.
-
Automated Continuous LeadDesk Replication to IBM DB2
Use CData Sync for automated, continuous, customizable LeadDesk replication to IBM DB2.
-
How to connect to Deel Data from IntelliJ
Integrate connectivity to Deel data with wizards in IntelliJ.
-
Access ConstantContact Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ConstantContact data from your Oracle system.
-
Automated Continuous Pipedrive Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Pipedrive replication to Google Cloud SQL.
-
Integrate Cosmos DB Data into Power Automate Desktop using CData Connect
CData Connect for Cosmos DB Data enables you to integrate Cosmos DB data into workflows built using Microsoft Power Automate Desktop.
-
Build Semantic Layer Views for SurveyMonkey Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SurveyMonkey data.
-
How to Connect the Power BI Service to SAP Hybris C4C: Complete Guide
Connect to the CData Software Power BI Connector for SAP Hybris C4C from PowerBI.com to provide real-time SAP Hybris C4C data across the organization.
-
Query Zoho Creator Data in ColdFusion
Write standard ColdFusion data access code to connect to Zoho Creator data.
-
Work with Live FHIR Data in Power Query
Use CData Connect AI to connect to FHIR data and work with live FHIR data in Microsoft Power Query.
-
Build Semantic Layer Views for Jumpseller Data in APOS Live Data Gateway
Use the CData Connector for Jumpseller in APOS Live Data Gateway to build Semantic Layer Views for Jumpseller data.
-
How to create OnePageCrm federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for OnePageCrm data in MySQL .
-
Connecting Mastra with eBay Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time eBay Analytics data, no replication required.
-
Build an OLAP Cube in SSAS from Oracle Data
Establish a connection to Oracle data data from SQL Server Analysis Services, and use the Oracle Data Provider to build OLAP cubes for use in analytics and reporting.
-
Migrating data from Dropbox to Databricks using CData SSIS Components.
Easily push Dropbox data to Databricks using the CData SSIS Tasks for Dropbox and Databricks.
-
Integrating VWO Data in Talend Cloud Data Management Platform
Connect VWO Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Query Google Ads Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Ads data from Node.js.
-
Connect to Google Forms Data in JRuby
Create a simple JRuby app with access to live Google Forms data.
-
Automated Continuous Zoho CRM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Google Cloud SQL.
-
Automate SendPulse Data Replication to Azure Synapse
Use CData Sync to customize and automate SendPulse data replication to Azure Synapse.
-
Load Apollo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apollo data to a database.
-
Choosing the Best Method to Connect CapsuleCRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use CapsuleCRM data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect Retently to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Retently data using the CData Python MCP Server.
-
How to Work with Google Directory Data in ETL Validator JDBC
Connect to Google Directory from ETL Validator jobs using the CData Software JDBC Driver.
-
How to work with Gmail Data in Apache Spark using SQL
Access and process Gmail Data in Apache Spark using the CData Software JDBC Driver.
-
Create Avro Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Avro data access from reports, embedded analytics, and more.
-
Integrate ShipEngine Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ShipEngine data from Informatica Cloud.