CData Software - Knowledge Base
Recent Articles
-
Query GitHub Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume GitHub entities in PHP by modeling them as objects.
-
Connect to Real-Time SageHR Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use SageHR data in Power Apps.
-
Integrating Codex with MailerSend 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.
-
Automated Continuous Qualaroo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Qualaroo replication to Amazon Redshift.
-
Integrate Google Calendar Data in Pentaho Data Integration
Build ETL pipelines based on Google Calendar data in the Pentaho Data Integration tool.
-
Create a Data Access Object for Jira Data using JDBI
A brief overview of creating a SQL Object API for Jira data in JDBI.
-
Connect to Google Campaign Manager 360 Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Campaign Manager 360 data in the Denodo Virtual DataPort Administrator.
-
How to integrate Metabase with BigQuery Data
Use CData Connect AI to connect to live BigQuery data and create an interactive dashboard in Metabase from BigQuery data.
-
Replicate Multiple Instantly Accounts
Replicate multiple Instantly accounts to one or many databases.
-
Build Charts with Simplesat Data in Clear Analytics
Create dynamic charts and perform analytics based on Simplesat data in Clear Analytics.
-
Connect Webflow to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Webflow data using the CData Python MCP Server.
-
Access GitHub Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for GitHub data.
-
Connecting Agentforce with SAP ByDesign 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 SAP ByDesign data for you.
-
How to Access Stripe Data Using Entity Framework
This article shows how to access Stripe data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize WordPress Data in TIBCO Spotfire through ADO.NET
Integrate WordPress data into dashboards in TIBCO Spotfire.
-
Build a Simple VCL Application for Cvent Data
How to build a simple VCL Application to view Cvent data in RAD Studio using the CData ODBC Driver for Cvent.
-
Access Phoenix Data from MySQL in PHP
Connect to Phoenix through the standard MySQL libraries in PHP.
-
Automated Continuous Procore Replication to Databricks
Use CData Sync for automated, continuous, customizable Procore replication to Databricks.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for XML
Provide connectivity to XML data through an SAP BusinessObjects universe.
-
Query Microsoft Planner Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Microsoft Planner entities in PHP by modeling them as objects.
-
Load iContact Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load iContact data to a database.
-
Visualize Live Amazon DynamoDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Amazon DynamoDB data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Provide OData Services of MongoDB Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MongoDB data by developing a WCF Service Application.
-
Automated Continuous GitLab Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable GitLab replication to Apache Kafka.
-
Getting Started with the CData Tableau Connector for Email
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Email.
-
Feed Snowflake Data into FineReport
How to set Snowflake data as a JDBC data source in FineReport.
-
Connect to and Visualize Live PolarTeamPro Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PolarTeamPro data.
-
Write a Simple Go Application to work with Phoenix Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Phoenix data.
-
Connect to XML Data in ACL Analytics
Connect to XML data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to XML data.
-
Getting Started with the CData Excel Add-In for PabblySubscriptions
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PabblySubscriptions.
-
How to Work with Avalara AvaTax Data in ETL Validator JDBC
Connect to Avalara AvaTax from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Python Connector for Telegram
Learn to install and license the CData Python Connector and configure a connection to live Telegram data.
-
Build Voice Agents in ElevenLabs with access to Live Azure Synapse Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Azure Synapse data.
-
Integrating Gumloop with API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on API data within automated workflows.
-
Build Act CRM-Connected Apps in Choreo
Use CData Connect AI to connect to Act CRM Data from Choreo and build custom apps using live Act CRM data.
-
Automated Customer.io Data Replication to Teradata
Use CData Sync to Customize and automate Customer.io data replication to Teradata.
-
Connect to Recurly Data in RazorSQL
Connect to Recurly from wizards and query Recurly data from the GUI in the RazorSQL database management tool.
-
Query Telegram Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Telegram data from Node.js.
-
Integrate Cursor with Live Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Twilio data from within the editor.
-
How to load Unbounce data into Elasticsearch via Logstash
Introducing a simple method to load Unbounce data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate SAP SuccessFactors LMS Data in Pentaho Data Integration
Build ETL pipelines based on SAP SuccessFactors LMS data in the Pentaho Data Integration tool.
-
Visualize Live ZohoInvoice Data in the Power BI Service
Use CData Connect AI to connect to live ZohoInvoice data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Marketo Data in DBeaver
Use the CData ODBC Driver to connect to Marketo data in DBeaver.
-
Use CData Connect AI to Access Salesloft Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Salesloft data in the Power Pivot business intelligence tool.
-
Use Claude to Talk to Your SAP Ariba Procurement 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 Ariba Procurement data for you.
-
Build Dashboards with SendGrid Data in Dundas BI
Create dynamic dashboards and perform analytics based on SendGrid data in Dundas BI.
-
Connect to Real-Time Perigon Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Perigon data in Power Apps.
-
Connect to Snowflake Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Snowflake data.
-
Build AI Agents with Square 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 Square data through CData Connect AI.
-
Create Reports from Snowflake Data in Looker Studio
Use CData Connect AI to gain access to live Snowflake data and create custom reports in Looker Studio.
-
Connect to ElevenLabs Data from a Connection Pool in Jetty
The ElevenLabs JDBC Driver supports connection pooling: This article shows how to connect faster to ElevenLabs data from Web apps in Jetty.
-
Integrate LibreChat with Live GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live GitLab data from within the chat interface.
-
Integrating LangGraph with Wave Financial Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Wave Financial data within automated workflows.
-
Model Odoo Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Odoo, enabling the direct import of real-time Odoo data.
-
Use the CData ODBC Driver for Zoom in Microsoft Power Query
You can use the CData Zoom ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoom data into Microsoft Power Query.
-
Trigger eBay IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for eBay with standard wizards in Logic Apps.
-
Integrate Perplexity Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Perplexity data from Informatica Cloud.
-
Connecting Agentforce with IBM Cloud Object Storage 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 IBM Cloud Object Storage data for you.
-
Analyze Sybase IQ Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sybase IQ data and visualize live Sybase IQ data in Infragistics Reveal.
-
How to connect PolyBase to Excel Online
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Excel Online data.
-
Connect to ZohoMarketingHub Data in Aqua Data Studio
Access ZohoMarketingHub data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Natively Connect to MongoDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MongoDB data. Leverage the native support for ODBC in PHP.
-
Publish Twitter Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Twitter Ads data.
-
Getting Started with the CData JDBC Driver for SQL Analysis Services
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SQL Analysis Services.
-
Query Active Directory Data as a MySQL Database in Node.js
Execute MySQL queries against Active Directory data from Node.js.
-
Build Zendesk Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zendesk data and build visualizations in Tableau Cloud.
-
Build Voice Agents in ElevenLabs with access to Live Odoo Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Odoo data.
-
Connect to Teradata Data in RapidMiner
Integrate Teradata data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Microsoft Exchange Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Microsoft Exchange data and build visualizations in Tableau Cloud.
-
Use Dash to Build Web Apps on Coda Data via CData Connect AI
Build interactive Dash web apps on live Coda data using pandas and the CData Connect AI Python SDK.
-
Create Teradata Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Teradata data access from reports, embedded analytics, and more.
-
Build a Simple VCL Application for SharePoint Excel Services Data
How to build a simple VCL Application to view SharePoint Excel Services data in RAD Studio using the CData ODBC Driver for SharePoint Excel Services.
-
Access Live FreshBooks Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to FreshBooks data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Visualize CockroachDB Data in TIBCO Spotfire through OData
Integrate CockroachDB data into dashboards in TIBCO Spotfire.
-
Presto Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Presto data through CData Connect AI using different applications and tools.
-
How to Connect to Live Xero Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Xero data securely in real time.
-
Query Live Phoenix 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 Phoenix data directly from the development environment.
-
Process & Analyze PingOne Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PingOne Data.
-
How to Connect DBeaver to Google Analytics via a JDBC Driver
Manage Google Analytics data with visual tools in DBeaver like the query browser.
-
Automated Continuous PolarTeamPro Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Google BigQuery.
-
Connect to Accelo Data in CloverDX (formerly CloverETL)
Transfer Accelo data using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData SSIS Components for Webex
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Webex.
-
Use CData Connect AI to Access Suadeo Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Suadeo data in the Power Pivot business intelligence tool.
-
How to Access Close Data Using Entity Framework
This article shows how to access Close data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Working with BambooHR Data in LINQPad
Execute LINQ queries to BambooHR data in LINQPad.
-
Automated Continuous Google Tasks Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Tasks replication to Apache Kafka.
-
Automated Continuous Stack Exchange Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Stack Exchange replication to IBM DB2.
-
Design BIRT Reports on Klipfolio Data
Provide current Klipfolio data to your embedded analytics.
-
A PostgreSQL Interface for Adobe Experience Manager Data (MySQL Remoting via JDBC)
Use the Remoting features of the Adobe Experience Manager JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Datasets from ZohoPeople in Domo Workbench and Build Visualizations of ZohoPeople Data in Domo
Use the CData Software ODBC Driver for ZohoPeople to create datasets from ZohoPeople data in Domo Workbench and then build visualizations in the Domo service.
-
Manage Wave Financial Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Wave Financial.
-
Connect to ElevenLabs Data from PowerBuilder via JDBC
This article demonstrates how to access ElevenLabs data from PowerBuilder using the ElevenLabs JDBC Driver.
-
Stream SAP Fieldglass Data into Apache Kafka Topics
Access and stream SAP Fieldglass data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Teamwork Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Teamwork to connect to Teamwork data and execute queries in PowerBuilder.
-
Publish Reports with Blackbaud FE NXT Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Blackbaud FE NXT data.
-
Connect to Omnisend Data in Aqua Data Studio
Access Omnisend data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to create FreeAgent federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for FreeAgent data in MySQL .
-
Automate Pipeliner CRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Pipeliner CRM data replication to Azure Data Lake.
-
Process & Analyze Discord Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Discord Data.
-
How to import Elorus Data into Apache Solr
Use the CData Software JDBC Driver for Elorus in Data Import Handler and create an automated import of Elorus data to Apache Solr Enterprise Search platform.