CData Software - Knowledge Base
Recent Articles
-
Connect to Avro Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apache Avro in the Denodo Virtual DataPort Administrator.
-
Automated Continuous ConvertKit Replication to SingleStore
Use CData Sync for automated, continuous, customizable ConvertKit replication to SingleStore.
-
How to connect to SuiteCRM Data from IntelliJ
Integrate connectivity to SuiteCRM with wizards in IntelliJ.
-
DataBind Controls to PivotalTracker Data in Delphi
DataBind to PivotalTracker in Delphi with standard data access components and controls.
-
Natively Connect to Reckon Accounts Hosted Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Reckon Accounts Hosted. Leverage the native support for ODBC in PHP.
-
Replicate Multiple Humanity Accounts
Replicate multiple Humanity accounts to one or many databases.
-
Integrate Open WebUI with Live BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live BambooHR from within the chat interface.
-
Build Visualizations of Power BI XMLA Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Power BI XMLA in Birst.
-
Feed Close Data into FineReport
How to set Close as a JDBC data source in FineReport.
-
Integrating LangChain with SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SingleStore within automated workflows.
-
Create JSON-Connected Applications in Appsmith
Connect to JSON Services via CData Connect AI in Appsmith and create custom business applications with real-time access to JSON.
-
How to Create Power BI Visual Reports with Real-Time QuickBooks Online Data
Use CData Power BI Connectors to visualize QuickBooks Online in Power BI.
-
Stream Jodoo Data into Apache Kafka Topics
Access and stream Jodoo in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create NetSuite-Connected Dashboards in Grafana
Connect to NetSuite Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to NetSuite CRM & ERP.
-
Integrating Antigravity CLI with Apify via CData CLI
Connect Apify to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Build an ETL App for Outlook Data in Python with CData
Create ETL applications and real-time data pipelines for Outlook in Python with petl.
-
Design BIRT Reports on Bullhorn CRM Data
Provide current Bullhorn CRM to your embedded analytics.
-
Integrating Kiro CLI with OneNote 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.
-
How to Design Redis Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Redis from mobile and tablet Power Apps.
-
Build Apps with Live Zoom in Adalo using CData Connect AI
Use CData Connect AI to integrate live Zoom into the Adalo platform and build custom mobile and web applications with real-time Zoom.
-
Import and Visualize LeadDesk Data in Power View
Create data visualizations based on LeadDesk in Excel.
-
How to Design Amazon Athena Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Amazon Athena from mobile and tablet Power Apps.
-
How to Connect to Live Box Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Box for you.
-
Build Anaplan-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Anaplan and build web apps with connectivity to live Anaplan.
-
Automated Continuous Google Search Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Search replication to Google Cloud SQL.
-
Replicate Multiple AgileCRM Accounts via the CData Sync CLI
Replicate multiple AgileCRM accounts to one or many databases.
-
Import and Visualize Dynamics 365 Data in Power View
Create data visualizations based on Microsoft Dynamics 365 in Excel.
-
Manage Apollo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Apollo.
-
Operational Reporting on Samanage Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Samanage.
-
Connect to and Visualize Live Phoenix Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache Phoenix.
-
How to Connect to Live ADP 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 ADP for you.
-
Extract, Transform, and Load Deel Data in Informatica PowerCenter
Create a simple Workflow for Deel in Informatica PowerCenter.
-
Access Live Zoom 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 Zoom through MCP integration.
-
Enable the Close JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Close.
-
Use the CData API Server to Access EnterpriseDB Data in Microsoft PowerPivot
Use the CData API Server to connect to live EnterpriseDB in the Power Pivot business intelligence tool.
-
Bind Live Sage Cloud Accounting Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Sage Cloud Accounting data
-
Use Manus AI to Talk to Your Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Google Directory.
-
Build AI/ML Models with Live Beeminder Data using Dataiku
Connect Beeminder Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Quaderno Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Quaderno replication to OneLake in Microsoft Fabric.
-
DataBind Charts to Planio Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Planio from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrate Goose with Live MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live MarkLogic from within the local AI agent.
-
Query Live SAP ByDesign 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 SAP Business ByDesign directly from the development environment.
-
Connect to Jumpseller Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Jumpseller as an External Source in Dremio.
-
Connect to Live PayPal Data in MicroStrategy through CData Connect AI
Create a live connection to PayPal Data in CData Connect AI and connect to your PayPal from MicroStrategy.
-
Create SSAS Tabular Models from Pinecone Data
How to build a SQL Server Analysis Service Tabular Model from Pinecone using CData drivers.
-
Build Pipelines with Live MySQL Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to MySQL from Google Cloud Data Fusion, enabling the integration of live MySQL into the building and management of effective data pipelines.
-
Integrating Claude Code CLI with SAP Business Warehouse 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.
-
How to Connect IBM Informix Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live IBM Informix data in real time using natural language.
-
Migrating data from Anaplan to Databricks using CData SSIS Components.
Easily push Anaplan to Databricks using the CData SSIS Tasks for Anaplan and Databricks.
-
Bridge Authorize.Net Connectivity with Apache NiFi
Access and process Authorize.Net in Apache NiFi using the CData JDBC Driver.
-
Connect to Timely Data in DBeaver
Use the CData ODBC Driver to connect to Timely in DBeaver.
-
Analyze Live Monday.com Data in SAS Viya
Use CData Connect AI to connect to Monday.com from SAS Viya and deploy self-service analytics using live Monday.com.
-
Use Microsoft Copilot Studio to talk to your OneNote 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 Microsoft OneNote for you.
-
Access Live ZohoMarketingHub Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ZohoMarketingHub in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software JDBC Driver for Billsby in MicroStrategy Desktop
Connect to Billsby in MicroStrategy Desktop using the CData Software JDBC Driver for Billsby.
-
Integrating OpenCode Terminal with Excel 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.
-
How to Connect the Power BI Service to Drip: Complete Guide
Connect to the CData Software Power BI Connector for Drip from PowerBI.com to provide real-time Drip across the organization.
-
Import and Visualize JotForm Data in Power View
Create data visualizations based on JotForm in Excel.
-
Replicate QuickBooks Data from PowerShell
Write a quick PowerShell script to query QuickBooks Desktop. Use connectivity to the live data to replicate QuickBooks Desktop to SQL Server.
-
Operational Reporting on Zoho CRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zoho CRM.
-
Build QuickBooks Time-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live QuickBooks Time and build QuickBooks Time-connected web apps with Axios.
-
Automated Continuous PagerDuty Replication to Oracle
Use CData Sync for automated, continuous, customizable PagerDuty replication to Oracle.
-
Connect to FTP Data in JRuby
Create a simple JRuby app with access to live FTP Servers.
-
Build Semantic Layer Views for Klipfolio Data in APOS Live Data Gateway
Use the CData Connector for Klipfolio in APOS Live Data Gateway to build Semantic Layer Views for Klipfolio.
-
Visualize Flowlu 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 Flowlu into TIBCO Spotfire.
-
Integrating Kiro CLI with Amazon Athena 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 Clio Data from MySQL in PHP
Connect to Clio through the standard MySQL libraries in PHP.
-
Connect to Excel from Asprova with CData Software ODBC Driver for Excel
This article shows how to connect faster to Excel data from Asprova.
-
Integrate Open WebUI with Live Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Kintone from within the chat interface.
-
Publish Sendwithus-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sendwithus.
-
How to connect to Cvent Data from IntelliJ
Integrate connectivity to Cvent with wizards in IntelliJ.
-
Establish a Live Connection with Parallel Data using Tableau Bridge
The CData ODBC Driver for Parallel enables you to integrate live Parallel into Tableau Cloud dashboards using the Tableau Bridge.
-
Configure the CData JDBC Driver for Outreach.io in a Connection Pool in Tomcat
Connect to Outreach.io from a connection pool in Tomcat.
-
Use the CData API Server to Access Tally Data in Microsoft PowerPivot
Use the CData API Server to connect to live Tally ERP in the Power Pivot business intelligence tool.
-
Use CData Connect AI to Access Dynamics 365 Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Microsoft Dynamics 365 in the Power Pivot business intelligence tool.
-
Build Apps with Live Google Contacts Data Using the Low-Code Development Platform of Mendix
Connect Google Contacts with Mendix to build apps using the CData JDBC Driver for Google Contacts.
-
Visualize iContact Data in Tableau
The CData ODBC driver for iContact enables you integrate iContact into Tableau dashboards.
-
Stream Microsoft Ads Data into Apache Kafka Topics
Access and stream Microsoft Ads in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect to & Open FreeAgent Data in Microsoft Excel
This article uses the CData ODBC driver for FreeAgent to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Google Directory Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Directory using standard SQL.
-
How to connect Amazon QuickSight to Twitter Ads Data
Create a connection to Twitter Ads in CData Connect AI and insert Twitter Ads into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Agents in Relevance AI with Access to Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zuora within intelligent agent workflows.
-
Use the CData ODBC Driver for Oracle from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle to connect to Oracle Database from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle Database in Excel.
-
Analyze Microsoft Teams Data in Cognos Analytics
Use CData Connect AI to connect to Microsoft Teams Data from Cognos Analytics and analyze live Microsoft Teams.
-
Use ChatGPT to Talk to Your Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Oracle Eloqua for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Twitter Ads
Provide connectivity to Twitter Ads through an SAP BusinessObjects universe.
-
Build MVC Applications with Connectivity to SendInBlue Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SendInBlue from an ASP.NET MVC application.
-
Create Recurly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Recurly from PowerBI.com to create Power BI Dataflows with real-time data.
-
Publish Reports with Quickbase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Quickbase.
-
A PostgreSQL Interface for MailChimp Data using the CData ODBC Driver
Use the SQL Gateway and MailChimp ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Google Ad Manager Data Replication to Teradata
Use CData Sync to Customize and automate Google Ad Manager replication to Teradata.
-
Integrate Aircall Data in Pentaho Data Integration
Build ETL pipelines based on Aircall in the Pentaho Data Integration tool.
-
Access Live Confluence Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Atlassian Confluence through MCP integration.
-
Integrate Live Zoho Inventory Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Zoho Inventory and integrate live Zoho Inventory into apps built in Microsoft Power Apps.
-
Replicate SurveyMonkey Data in Heroku for Use in Salesforce Connect
Replicate SurveyMonkey to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating SAP HANA XS Advanced Data in Talend Cloud Data Management Platform
Connect SAP HANA XS Advanced Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP HANA XS Advanced.
-
Getting Started with the CData SSIS Components for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for CapsuleCRM.
-
Connect to Redis Data in Ruby
Connect to Redis in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Copper Reporting in OBIEE with the Copper JDBC Driver
Deploy the Copper JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Pipedrive Data in Jaspersoft Studio
Execute SQL to remote Pipedrive in Jaspersoft Studio.