CData Software - Knowledge Base
Recent Articles
-
Create Power BI Reports on Real-Time Aircall Data
Use the CData ODBC Driver for Aircall to visualize Aircall data in Power BI Desktop.
-
Integrate Trae with Live Email Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Email data from within the AI-powered IDE.
-
Use the CData Software ODBC Driver for Excel Online in MicroStrategy Desktop
Connect to Excel Online data in MicroStrategy Desktop using the CData Software ODBC Driver for Excel Online.
-
Automated Continuous Gong Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Gong replication to Google Cloud SQL.
-
Automated Continuous Excel Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Excel replication to Azure SQL Database.
-
Use Claude to Talk to Your SAP Netweaver Gateway 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 Netweaver Gateway data for you.
-
Automated Continuous Pinterest Replication to Oracle
Use CData Sync for automated, continuous, customizable Pinterest replication to Oracle.
-
Build TaxJar-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live TaxJar data.
-
Automated Continuous Pushbullet Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Pushbullet replication to Google BigQuery.
-
Integrate OpenCode with Live Oracle SCM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Oracle SCM data from within your AI coding agent.
-
Getting Started with the CData Connect AI Python SDK for Omnisend
Install the CData Connect AI Python SDK to read live Omnisend data with standard DB-API 2.0 Python code.
-
Connect to Neo4J Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Neo4J as an External Source in Dremio.
-
Build Mailjet-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Mailjet data.
-
Automated Continuous Bugsnag Replication to SQL Server
Use CData Sync for automated, continuous, customizable Bugsnag replication to SQL Server.
-
Seamlessly Bring Sage Intacct Data into Retool Using CData Connect AI
Integrate Sage Intacct data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Live JDBC-ODBC Bridge Data in TIBCO Data Virtualization
Use the JDBC-ODBC Bridge Tibco DV Adapter to create a JDBC-ODBC Bridge data data source in TIBCO Data Virtualization Studio and gain access to live JDBC-ODBC Bridge data from your TDV Server.
-
New SharePoint Views: Sites, AllLists, AllFiles
This article reviews the newly added views to the CData SharePoint Drivers, Sites, AllLists, and AllFiles, and explores example queries using the new views.
-
Connect to Tavily Data from PowerBuilder via JDBC
This article demonstrates how to access Tavily data from PowerBuilder using the Tavily JDBC Driver.
-
Rapidly Develop Kintone-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 Kintone.
-
How to integrate Basecamp with Apache Airflow
Access and process Basecamp data in Apache Airflow using the CData JDBC Driver.
-
Analyze Instantly Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Instantly data with the CData JDBC Driver for Instantly.
-
Publish Reports with Zoho Projects Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Projects data.
-
Automated Continuous Apify Replication to Databricks
Use CData Sync for automated, continuous, customizable Apify replication to Databricks.
-
Build Dashboards with Mistral AI Data in DBxtra
Create dynamic dashboards and perform analytics based on Mistral AI data in DBxtra.
-
Visualize Live Sage 300 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sage 300 data into custom reports in Power BI.
-
Connect to Microsoft Entra ID Data from a Connection Pool in JBoss
Integrate Microsoft Entra ID data into Java servlets: Use the Management Console in JBoss to install the Microsoft Entra ID JDBC Driver.
-
Access Live Dynamics 365 Business Central 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 Dynamics 365 Business Central data through MCP integration.
-
Connect Oracle SCM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle SCM with IBM WebSphere for seamless data integration and connectivity.
-
Integrate LibreChat with Live Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Cloudant data from within the chat interface.
-
Build an OLAP Cube in SSAS from Sendwithus Data
Establish a connection to Sendwithus data data from SQL Server Analysis Services, and use the Sendwithus Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Vimeo Data in Jaspersoft Studio
Execute SQL to remote Vimeo data in Jaspersoft Studio.
-
Work with Factorial Data in FoxPro
Load Factorial data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Mixpanel Data in Jaspersoft Studio
Execute SQL to remote Mixpanel data in Jaspersoft Studio.
-
How to Query SFTP Data in MySQL Workbench
Execute MySQL queries against live SFTP data from MySQL Workbench.
-
How to Query Live Quickbase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Quickbase data data in natural language using Python.
-
Connect to LightSpeedRetail Data in CloverDX (formerly CloverETL)
Transfer LightSpeedRetail data using the visual workflow in the CloverDX data integration tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Unbounce
Create an ODBC connection to Unbounce in Informatica and browse and transfer Unbounce data.
-
Replicate Multiple TaxJar Accounts
Replicate multiple TaxJar accounts to one or many databases.
-
Integrate Dify with Live ZohoMarketingHub Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live ZohoMarketingHub data.
-
Build Automated IBM Informix-Connected Workflows in Zapier
Use CData Connect AI to connect to live IBM Informix data and build automated workflows in Zapier.
-
How to Connect to Live iContact Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your iContact data for you.
-
Build Agents in Relevance AI with Access to Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Phoenix data within intelligent agent workflows.
-
Connect to Figshare Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Figshare and work with Figshare data in your FileMaker application.
-
How to Connect to Live Authorize.Net 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 Authorize.Net data for you.
-
Connect to Dynamics CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Dynamics CRM data in the Denodo Virtual DataPort Administrator.
-
Use the CData ODBC Driver for Elorus from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Elorus to connect to Elorus data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Elorus data in Excel.
-
Connect to Shortcut Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Shortcut as an External Source in Dremio.
-
DataBind Charts to Workable Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Workable data 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.
-
Manage Figshare Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Figshare.
-
Working with Zoom Data in LINQPad
Execute LINQ queries to Zoom data in LINQPad.
-
How to Seamlessly Import Blackbaud FE NXT Data into IBM SPSS Modeler
Integrate Blackbaud FE NXT data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Cline with Live WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live WordPress data from within your IDE.
-
A PostgreSQL Interface for Procore Data using the CData ODBC Driver
Use the SQL Gateway and Procore ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live Azure Analysis Services Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Azure Analysis Services data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create RSS-Connected Applications in Appsmith
Connect to RSS Feeds via CData Connect AI in Appsmith and create custom business applications with real-time access to RSS feeds.
-
How to Visualize BigCommerce Data in Python with pandas
Use pandas and other modules to analyze and visualize live BigCommerce data in Python.
-
Build Semantic Layer Views for Amazon Marketplace Data in APOS Live Data Gateway
Use the CData Connector for Amazon Marketplace in APOS Live Data Gateway to build Semantic Layer Views for Amazon Marketplace data.
-
Prepare, Blend, and Analyze Cassandra Data in Alteryx Designer (ODBC)
Build workflows to access live Cassandra data for self-service data analytics.
-
Visualize Sage 200 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 Sage 200 data into TIBCO Spotfire.
-
Build Microsoft Entra ID-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Entra ID data.
-
Visualize Live Impala Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Impala data.
-
Build a Simple VCL Application for ChartMogul Data
How to build a simple VCL Application to view ChartMogul data in RAD Studio using the CData ODBC Driver for ChartMogul.
-
Viewing Azure DevOps Data in RAD Studio Data Explorer
How to view Azure DevOps data in RAD Studio Data Explorer using the CData ODBC Driver for Azure DevOps.
-
Automated Continuous Unbounce Replication to MongoDB
Use CData Sync for automated, continuous, customizable Unbounce replication to MongoDB.
-
Integrate Live Microsoft Teams Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Teams data to Blue Prism using the CData ODBC Driver for Microsoft Teams to create automated workflows for repetitive business tasks.
-
Publish Reports with Perigon Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Perigon data.
-
Use the CData Software JDBC Driver for ZendeskSell in MicroStrategy Desktop
Connect to ZendeskSell data in MicroStrategy Desktop using the CData Software JDBC Driver for ZendeskSell.
-
Access Access Data from MySQL in PHP
Connect to Access through the standard MySQL libraries in PHP.
-
Connect to Rootly Data in HULFT Integrate
Connect to Rootly as a JDBC data source in HULFT Integrate
-
Deploy the ADO.NET Provider for Microsoft Teams on an SSRS Report Server
Connect to Microsoft Teams data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to Optimizely Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Optimizely Data and connect to Optimizely data in Akorbi Digital RunMyProcess.
-
Integrate Insightly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Insightly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Insightly data.
-
Integrating Cursor with Zendesk 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 Paylocity Data from MySQL in Amazon QuickSight
Connect to Paylocity and build visualizations of Paylocity data using a MySQL Connection in Amazon QuickSight.
-
Link Onfleet with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Onfleet data in Filemaker Pro for Mac or Windows.
-
Create SSAS Tabular Models from ServiceNow Data
How to build a SQL Server Analysis Service Tabular Model from ServiceNow data using CData drivers.
-
How to Create Power BI Visual Reports with Real-Time Oracle Eloqua Reporting Data
Use CData Power BI Connectors to visualize Oracle Eloqua Reporting data in Power BI.
-
Build a PostgreSQL Interface for LDAP Objects using the CData JDBC Driver
Use the Remoting features of the LDAP JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Manus AI to Talk to Your CouchDB 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 CouchDB data.
-
LINQ to Productboard Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Productboard Data Provider.
-
Getting Started with the CData Python Connector for Jira
Learn to install and license the CData Python Connector and configure a connection to live Jira data.
-
Integrate Open WebUI with Live Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Cosmos DB data from within the chat interface.
-
How to create an RPA flow for Figshare Data in UiPath Studio
Use the Figshare ODBC Driver to create workflows that access real-time Figshare data without any coding.
-
Build Apps with Live Act-On Data Using the Low-Code Development Platform of Mendix
Connect Act-On data with Mendix to build apps using the CData JDBC Driver for Act-On.
-
Use Azure AI Foundry to Talk to Your ServiceDesk Plus 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 ServiceDesk Plus data for you.
-
Automated Continuous Templated Replication to SQLite
Use CData Sync for automated, continuous, customizable Templated replication to SQLite.
-
Connect to and Query Paddle Data in QlikView over ODBC
Create data visualizations with Paddle data in QlikView.
-
Integrate Supabase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Supabase with External Services.
-
Use the CData ODBC Driver for Zoho Projects from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoho Projects to connect to Zoho Projects data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoho Projects data in Excel.
-
Enable the Planio JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Planio data.
-
ETL Dotmailer in Oracle Data Integrator
This article shows how to transfer Dotmailer data into a data warehouse using Oracle Data Integrator.
-
Connect Auth0 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Auth0 data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating Boomi Agentstudio with Shortcut Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Shortcut data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Xero Replication to SQL Server
Use CData Sync for automated, continuous, customizable Xero replication to SQL Server.
-
Configure the CData JDBC Driver for Hacker News in a Connection Pool in Tomcat
Connect to Hacker News data from a connection pool in Tomcat.
-
Moving Data from Azure Synapse to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Azure Synapse data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Authorize.Net Data in Claris FileMaker Pro
Use the CData ODBC Driver for Authorize.Net in FileMaker Pro to connect to Authorize.Net and work with Authorize.Net data in your FileMaker applications.
-
Integrate with Productboard Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Productboard data to a JSON file on disk.
-
How to Connect to Live NetSuite SuiteAnalytics Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your NetSuite SuiteAnalytics data for you.
-
Connect to Procore Data from PowerBuilder via ADO.NET
This article demonstrates how to access Procore data from Appeon PowerBuilder using the CData API Driver for ADO.NET.