CData Software - Knowledge Base
Recent Articles
-
DataBind Trello Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Trello with the DevExpress Windows Forms and Web controls to provide Trello to a chart.
-
Getting Started with the CData JDBC Driver for Odoo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Odoo.
-
Build Semantic Layer Views for Splunk Data in APOS Live Data Gateway
Use the CData Connector for Splunk in APOS Live Data Gateway to build Semantic Layer Views for Splunk.
-
How to Access Live Vercel Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Vercel enables you to integrate Vercel into workflows built using Microsoft Power Automate Desktop.
-
Automate Delighted Data Replication to Azure Synapse
Use CData Sync to customize and automate Delighted replication to Azure Synapse.
-
Access Live Cassandra Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Apache Cassandra from your Excel spreadsheets.
-
Build an OLAP Cube in SSAS from Dynamics NAV Data
Establish a connection to Microsoft Dynamics NAV data from SQL Server Analysis Services, and use the Dynamics NAV Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect to Webex Data from Spring Boot
Connect to Webex in a Spring Boot Application using the CData API Driver for JDBC
-
Natively Connect to SAP Concur Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP Concur. Leverage the native support for ODBC in PHP.
-
Build SendPulse-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SendPulse.
-
Integrating OpenCode Terminal with Ontraport 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.
-
Integrating LangChain with SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft SharePoint within automated workflows.
-
Build Zuora-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Zuora to explore live Zuora Data in GitHub Copilot to assist with building Zuora-powered applications.
-
Operational Reporting on Authorize.Net Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Authorize.Net.
-
Configure the CData JDBC Driver for Slack in a Connection Pool in Tomcat
Connect to Slack from a connection pool in Tomcat.
-
Integrate with YouTube Analytics Data in SnapLogic
Use CData Connect AI to connect to and integrate with live YouTube Analytics in SnapLogic.
-
Create Suadeo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Suadeo from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to Live Shopify Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Shopify without replication.
-
Integrating GitHub Copilot CLI with xBase 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.
-
Publish Kintone-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Kintone.
-
Integrate Live Dropbox Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connecting Agentforce with Azure DevOps 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 Azure DevOps for you.
-
Integrate Amazon DynamoDB Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Amazon DynamoDB from Informatica Cloud.
-
Edit and Search Tally External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Tally ERP to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Tally objects that you can access from apps and the dashboard.
-
Integrate with live MYOB AccountRight Data in Jitterbit
Use CData Connect AI to connect to and integrate live MYOB AccountRight in Jitterbit.
-
How to Access QuickBooks Time Data Using Entity Framework
This article shows how to access QuickBooks Time using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Provide OData Services of Codat Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Codat by developing a WCF Service Application.
-
Integrating Coda Data in Talend Cloud Data Management Platform
Connect Coda Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Query Live AlloyDB Data in Claude Desktop
Connect to and query live AlloyDB Data in Claude Desktop using CData MCP Server.
-
Use Dash to Build to Web Apps on Anaplan Data
Create Python applications that use pandas and Dash to build Anaplan-connected web apps.
-
Import Act-On Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Act-On Data and provide access to live Act-On for custom reports in the Power BI Service.
-
Access SendInBlue Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SendInBlue from HeidiSQL.
-
Connect to SAP SuccessFactors Data from a Connection Pool in Jetty
The SAP SuccessFactors JDBC Driver supports connection pooling: This article shows how to connect faster to SAP SuccessFactors from Web apps in Jetty.
-
Connect to Intercom Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Intercom using standard SQL.
-
Use Microsoft Copilot Studio to talk to your Raisers Edge NXT 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 Raisers Edge NXT for you.
-
How to integrate Azure Synapse with Apache Airflow
Access and process Azure Synapse in Apache Airflow using the CData JDBC Driver.
-
How to Query Live Azure Synapse Data in Claude Desktop
Connect to and query live Azure Synapse Data in Claude Desktop using CData MCP Server.
-
Use the CData ODBC Driver for ChargeOver in Microsoft Power Query
You can use the CData ChargeOver ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ChargeOver into Microsoft Power Query.
-
Connect to Live Redshift Data in MicroStrategy through CData Connect AI
Create a live connection to Redshift Data in CData Connect AI and connect to your Amazon Redshift from MicroStrategy.
-
Connect to SAP Fieldglass Data in HULFT Integrate
Connect to SAP Fieldglass as a JDBC data source in HULFT Integrate
-
Integrate Theia IDE with Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Access DB2 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access IBM DB2 from your Oracle system.
-
Integrate Oracle Sales Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Oracle Sales and integrate live Oracle Sales into your Power Automate tasks.
-
Connect to Demio Data in Ruby
Connect to Demio in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating Claude Code CLI with Pushbullet 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 Exa in SpagoBI
Create reports featuring live Exa in SpagoBI Studio. Host Exa reports on SpagoBI Server.
-
Import Real-Time ConvertAPI Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ConvertAPI in ColdFusion.
-
Getting Started with the CData Power BI Connector for Google Forms
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Beeminder in SpagoBI
Create reports featuring live Beeminder in SpagoBI Studio. Host Beeminder reports on SpagoBI Server.
-
Getting Started with the CData Power BI Connector for Printful
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Natively Connect to Tickspot Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Tickspot. Leverage the native support for ODBC in PHP.
-
Validate Contentful Data with QuerySurge
Access and validate Contentful in QuerySurge using the CData JDBC Driver.
-
Query Microsoft Entra ID Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Entra ID from Node.js.
-
Configure the CData JDBC Driver for CampaignMonitor in a Connection Pool in Tomcat
Connect to CampaignMonitor from a connection pool in Tomcat.
-
Connect to Monday.com Data from AWS Glue
Use CData Connect AI to gain access to live Monday.com from your AWS Glue jobs.
-
Viewing SAP Business One Data in RAD Studio Data Explorer
How to view SAP Business One in RAD Studio Data Explorer using the CData ODBC Driver for SAP Business One.
-
Create SSAS Tabular Models from Deel Data
How to build a SQL Server Analysis Service Tabular Model from Deel using CData drivers.
-
Access MessageBird Data from MySQL in Amazon QuickSight
Connect to MessageBird and build visualizations of MessageBird using a MySQL Connection in Amazon QuickSight.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Box using the Model Context Protocol.
-
Bridge Avaza Connectivity with Apache NiFi
Access and process Avaza in Apache NiFi using the CData JDBC Driver.
-
Analyze IBM Informix Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze IBM Informix in Microsoft R Open.
-
Query Google Analytics Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Analytics entities in PHP by modeling them as objects.
-
Integrating Antigravity CLI with SAP Business ByDesign via CData CLI
Connect SAP Business ByDesign to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Easily Query ZohoPeople Data in OpenOffice Base
Connect to ZohoPeople data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use Grok to Talk to Your Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Gong for you.
-
Integrating LangChain with Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Zendesk within automated workflows.
-
Access Live Act-On Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Act-On from your Google Sheets.
-
Create Reports with Adobe Analytics Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Analytics.
-
How to connect PolyBase to eBay
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live eBay.
-
Publish Email-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Email.
-
Create Datasets from Superchat in Domo Workbench and Build Visualizations of Superchat Data in Domo
Use the CData Software ODBC Driver for Superchat to create datasets from Superchat in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Procore 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 Procore through MCP integration.
-
How to use SQLAlchemy ORM to access ChartMogul Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ChartMogul.
-
Connect to Reckon Accounts Hosted Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Reckon Accounts Hosted Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Visualize OneNote Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft OneNote in Python.
-
Getting Started with the CData JDBC Driver for PostgreSQL
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for PostgreSQL.
-
Use Azure AI Foundry to Talk to Your Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Outreach.io for you.
-
Automated Continuous Elorus Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Elorus replication to PostgreSQL.
-
Integrate Live Planio Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Planio to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Connect to FreshBooks Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to FreshBooks. Leverage the pyodbc module for ODBC in Python.
-
Create Informatica Mappings From/To a JDBC Data Source for Apollo
Create Apollo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Consume Amazon Athena OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Amazon Athena feeds that reflect any changes in SAP Lumira.
-
Import Real-Time Dropbox Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Dropbox in ColdFusion.
-
Integrating Antigravity CLI with Blackbaud FE NXT via CData CLI
Connect Blackbaud FE NXT to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
DataBind Adobe Experience Manager Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Adobe Experience Manager with the DevExpress Windows Forms and Web controls to provide Adobe Experience Manager to a chart.
-
How to Import Data from EnterpriseDB into Google Sheets
Import EnterpriseDB into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous Greenplum Replication to Databricks
Use CData Sync for automated, continuous, customizable Greenplum replication to Databricks.
-
Create Dynamic SAP SuccessFactors LMS Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP SuccessFactors LMS to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software ODBC Driver for Zoom in SAS for Real-Time Reporting and Analytics
Connect to real-time Zoom in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zoom.
-
Connect to Microsoft Teams Data in Jaspersoft Studio
Execute SQL to remote Microsoft Teams in Jaspersoft Studio.
-
SAP Business Warehouse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Business Warehouse facts in real time.
-
Use the CData Software ODBC Driver for Facebook Ads in MicroStrategy Web
Connect to Facebook Ads in MicroStrategy Web using the CData Software ODBC Driver for Facebook Ads.
-
View Reports on Real-Time Mailgun Data in Power BI Report Server
Use the CData ODBC Driver for Mailgun to visualize Mailgun in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Query Live Azure Data Catalog Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure Data Catalog data in natural language using Python.
-
Connect and Query Live IBM Cloud Object Storage Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live IBM Cloud Object Storage into Databricks
-
Use the CData Software ODBC Driver for Planio in MicroStrategy Web
Connect to Planio in MicroStrategy Web using the CData Software ODBC Driver for Planio.
-
How to Easily Query Twilio Data in OpenOffice Base
Connect to Twilio data in OpenOffice Base using the CData ODBC Driver for Twilio and generate reports with live data insights.
-
Migrating data from Invoiced to Google BigQuery using CData SSIS Components.
Easily push Invoiced to Google BigQuery using the CData SSIS Tasks for Invoiced and Google BigQuery.
-
Getting Started with the CData Excel Add-In for Freshteam
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Freshteam.
-
Publish Rebilly-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Rebilly.