CData Software - Knowledge Base
Recent Articles
-
Integrating GitHub Copilot with LinkedIn Ads 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.
-
Build Automated SAP Ariba Source-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Ariba Source data and build automated workflows in Zapier.
-
Publish Reports with GraphQL Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date GraphQL data.
-
Use the CData Software ODBC Driver for Sybase in SAS for Real-Time Reporting and Analytics
Connect to real-time Sybase data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sybase.
-
Integrate with ZohoDesk Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ZohoDesk data in SnapLogic.
-
Connect to Spark from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Spark data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Email Data in the Pentaho Report Designer
Publish reports based on Email data in the Pentaho BI tool.
-
Integrate Cline with Live xBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live xBase data from within your IDE.
-
Import Azure DevOps Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Azure DevOps Data and provide access to live Azure DevOps data for custom reports in the Power BI Service.
-
Getting Started with the CData SSIS Components for ZendeskSell
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZendeskSell.
-
Connect Workday to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Workday data using the CData Python MCP Server.
-
Connect Timely to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Timely data using the CData Python MCP Server.
-
Visualize Google Forms 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 Google Forms data into TIBCO Spotfire.
-
Creating Avalara AvaTax-Connected Applications in Unqork
You can use CData Connect AI to feed Avalara AvaTax data to Unqork and build custom business apps.
-
How to Connect to Live ZohoPeople 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 ZohoPeople data for you.
-
Create Data Visualizations Based On Bannerbear Data in Mode
Use CData Connect AI to connect to Bannerbear Data from Mode and build visualizations using live Bannerbear data.
-
Automated Continuous Workday Replication to SQLite
Use CData Sync for automated, continuous, customizable Workday replication to SQLite.
-
Process & Analyze Google Tasks Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Tasks Data.
-
Import and Visualize Teamgate Data in Power View
Create data visualizations based on Teamgate data in Excel.
-
Integrating Claude Code CLI with Oracle SCM 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 Power BI Reports on Real-Time SharePoint Excel Services Data
Use the CData ODBC Driver for SharePoint Excel Services to visualize SharePoint Excel Services data in Power BI Desktop.
-
Getting Started with the CData Power BI Connector for BigQuery
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for BigQuery.
-
Create Power BI Reports on Real-Time Exa Data
Use the CData ODBC Driver for Exa to visualize Exa data in Power BI Desktop.
-
Getting Started with the CData SSIS Components for MessageBird
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MessageBird.
-
Integrating Gumloop with Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Neo4J data within automated workflows.
-
Automated Continuous Salesforce Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Salesforce replication to PostgreSQL.
-
How to connect to CampaignMonitor Data from IntelliJ
Integrate connectivity to CampaignMonitor data with wizards in IntelliJ.
-
Use the CData SSIS Components to Insert New or Update Existing SAP Ariba Source Records from SQL Server
Easily push SQL Server data to SAP Ariba Source using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAP Ariba Source or update existing records with data from a SQL Server database.
-
Working with Sugar CRM Data in LINQPad
Execute LINQ queries to Sugar CRM data in LINQPad.
-
Prepare, Blend, and Analyze Microsoft Dataverse Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Dataverse data for self-service data analytics.
-
Access Live ZohoExpense Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ZohoExpense data from your Excel spreadsheets.
-
Access TigerGraph Data from MySQL in Amazon QuickSight
Connect to TigerGraph and build visualizations of TigerGraph data using a MySQL Connection in Amazon QuickSight.
-
Migrating data from Sentry to Google BigQuery using CData SSIS Components.
Easily push Sentry data to Google BigQuery using the CData SSIS Tasks for Sentry and Google BigQuery.
-
Feed ZeroBounce Data into FineReport
How to set ZeroBounce data as a JDBC data source in FineReport.
-
How to connect to Airtable Data in DBVisualizer
Integrate Airtable data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous AdRoll Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable AdRoll replication to Google BigQuery.
-
Access Azure Analysis Services Data from MySQL in Amazon QuickSight
Connect to Azure Analysis Services and build visualizations of Azure Analysis Services data using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData JDBC Driver for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Bullhorn CRM.
-
Connect to Cloudant Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Cloudant Data and connect to Cloudant data in Akorbi Digital RunMyProcess.
-
Working with Recurly Data in LINQPad
Execute LINQ queries to Recurly data in LINQPad.
-
Visualize Live PayPal Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PayPal data.
-
Connecting Mastra with SuiteCRM 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 SuiteCRM data, no replication required.
-
Analyze HubSpot Data in Cognos Analytics
Use CData Connect AI to connect to HubSpot Data from Cognos Analytics and analyze live HubSpot data.
-
Automated Continuous SAP BusinessObjects BI Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Apache Cassandra.
-
Analyze Live Salesforce Pardot Data in SAS Viya
Use CData Connect AI to connect to Salesforce Pardot data from SAS Viya and deploy self-service analytics using live Salesforce Pardot data.
-
Connect to Mistral AI Data from a Connection Pool in JBoss
Integrate Mistral AI data into Java servlets: Use the Management Console in JBoss to install the Mistral AI JDBC Driver.
-
Connect Okta to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Okta with IBM WebSphere for seamless data integration and connectivity.
-
Integrating OpenCode with Google Calendar 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.
-
Analyze Live AfterShip Data in SAS Viya
Use CData Connect AI to connect to AfterShip data from SAS Viya and deploy self-service analytics using live AfterShip data.
-
Use the CData Software JDBC Driver for Quaderno in MicroStrategy
Connect to Quaderno data in MicroStrategy Developer using the CData Software JDBC Driver for Quaderno.
-
How to Query Clio Data in MySQL Workbench
Execute MySQL queries against live Clio data from MySQL Workbench.
-
Connecting Mastra with Gong 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 Gong data, no replication required.
-
Build Semantic Layer Views for CapsuleCRM Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for CapsuleCRM data.
-
Connect to Adobe Target Data from Crystal Reports
Use CData Connect AI to connect to and report on live Adobe Target data from Crystal Reports.
-
How to Connect DBeaver to Rootly via a JDBC Driver
Manage Rootly data with visual tools in DBeaver like the query browser.
-
DataBind Controls to PostgreSQL Data in Delphi
DataBind to PostgreSQL data in Delphi with standard data access components and controls.
-
How to create Visio diagrams from Google Calendar Data
Automatically update Google Calendar data with the changes you make to Visio master shapes.
-
Getting Started with the CData JDBC Driver for WordPress
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for WordPress.
-
Build Workday-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Workday Data and create custom apps in Mendix.
-
Build Visualizations of Kintone Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Kintone data in Birst.
-
Import HDFS Data Using Azure Data Factory
Use CData Connect AI to connect to HDFS Data from Azure Data Factory and import live HDFS data.
-
Work with Kintone Data in FoxPro
Load Kintone data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Live Jumpseller 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 Jumpseller data from within the IDE.
-
Integrating Gumloop with Mailgun Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Mailgun data within automated workflows.
-
How to Query Live BigQuery Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live BigQuery data data in natural language using Python.
-
How to Connect Flowise AI Agents to Live GitHub Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live GitHub data without replication.
-
Rapidly Develop Adobe Target-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 Adobe Target.
-
Viewing SAP ByDesign Data in RAD Studio Data Explorer
How to view SAP ByDesign data in RAD Studio Data Explorer using the CData ODBC Driver for SAP ByDesign.
-
Connect to SAP Netweaver Gateway Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAP Netweaver Gateway Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use the CData Software ODBC Driver for Access in MicroStrategy Web
Connect to Access data in MicroStrategy Web using the CData Software ODBC Driver for Access.
-
Automated Continuous Microsoft Dataverse Replication to Databricks
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Databricks.
-
Integrating Kiro with Optimizely 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 Printful Replication to SQLite
Use CData Sync for automated, continuous, customizable Printful replication to SQLite.
-
Visualize Live Pinterest Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pinterest data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to LightSpeedRetail Data in Jaspersoft Studio
Execute SQL to remote LightSpeedRetail data in Jaspersoft Studio.
-
Access Accelo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Accelo data from HeidiSQL.
-
Natively Connect to Insightly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Insightly data. Leverage the native support for ODBC in PHP.
-
Connect to AlloyDB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for AlloyDB data.
-
Access Live SQL Analysis Services Data in AWS Lambda
Connect to live SQL Analysis Services data in AWS Lambda using the CData JDBC Driver.
-
Connect HubDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HubDB with IBM WebSphere for seamless data integration and connectivity.
-
Integrate with live Slack Data in Jitterbit
Use CData Connect AI to connect to and integrate live Slack data in Jitterbit.
-
Automated Continuous Zendesk Replication to Vertica
Use CData Sync for automated, continuous, customizable Zendesk replication to Vertica.
-
Build Contentful-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Contentful data and build web apps with connectivity to live Contentful data.
-
How to Query Live Google Analytics Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Analytics data data in natural language using Python.
-
Build Voice Agents in ElevenLabs with access to Live HDFS Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live HDFS data.
-
Analyze ZeroBounce Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZeroBounce from Power Pivot. You will use the Table Import Wizard to load ZeroBounce data. You can visually build the import query or use any SQL supported by the driver.
-
Import Greenplum Data Using Azure Data Factory
Use CData Connect AI to connect to Greenplum Data from Azure Data Factory and import live Greenplum data.
-
Natively Connect to JotForm Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to JotForm data. Leverage the native support for ODBC in PHP.
-
Build SAP SuccessFactors-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP SuccessFactors Data and create custom apps in Bubble.
-
Getting Started with the CData Excel Add-In for MessageBird
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MessageBird.
-
Build Dashboards with Odoo Data in DBxtra
Create dynamic dashboards and perform analytics based on Odoo data in DBxtra.
-
Connect to Klaviyo Data in DBeaver
Use the CData ODBC Driver to connect to Klaviyo data in DBeaver.
-
Analyze Live Salesforce Data 360 Data in SAS Viya
Use CData Connect AI to connect to Salesforce Data 360 data from SAS Viya and deploy self-service analytics using live Salesforce Data 360 data.
-
How to connect to Zoho Books Data from IntelliJ
Integrate connectivity to Zoho Books data with wizards in IntelliJ.
-
Connect to Oracle Eloqua Reporting from Asprova with CData Software ODBC Driver for Oracle Eloqua Reporting
This article shows how to connect faster to Oracle Eloqua Reporting data from Asprova.
-
How to Connect to Live Sybase IQ 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 Sybase IQ data through natural language.
-
How to use SQLAlchemy ORM to access Azure Analysis Services Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Analysis Services data.
-
Viewing Snowflake Data in RAD Studio Data Explorer
How to view Snowflake data in RAD Studio Data Explorer using the CData ODBC Driver for Snowflake.
-
Build Semantic Layer Views for Optimizely Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Optimizely data.
-
Create a Data Access Object for SFTP Data using JDBI
A brief overview of creating a SQL Object API for SFTP data in JDBI.