CData Software - Knowledge Base
Recent Articles
-
Integrating OpenCode with SharePoint 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.
-
Configure the CData JDBC Driver for Oracle Financials Cloud in a Connection Pool in Tomcat
Connect to Oracle Financials Cloud data from a connection pool in Tomcat.
-
DataBind Controls to MYOB AccountRight Data in C++Builder
DataBind to MYOB AccountRight data in C++Builder with standard components and controls.
-
Visualize Rootly Data in TIBCO Spotfire through ADO.NET
Integrate Rootly data into dashboards in TIBCO Spotfire.
-
Use Agno to Talk to Your Shortcut Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Shortcut data for you.
-
Natively Connect to Aweber Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Aweber data. Leverage the native support for ODBC in PHP.
-
How to connect to Helpscout Data from Spring Boot
Connect to Helpscout in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating ADP Data in Talend Cloud Data Management Platform
Connect ADP Data with Talend Cloud Data Management Platform using the CData JDBC Driver for ADP.
-
Integrate Cline with Live ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live ZohoExpense data from within your IDE.
-
Create Adobe Commerce-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Adobe Commerce Data from OutSystems and build custom enterprise apps using live Adobe Commerce data.
-
Getting Started with the CData JDBC Driver for SAP Ariba Source
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Ariba Source.
-
Create Data Visualizations in Cognos BI with VWO Data
Access VWO data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Work with HDFS Data in AWS Glue Jobs Using JDBC
Connect to HDFS from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect ElevenLabs to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ElevenLabs data using the CData Python MCP Server.
-
DataBind CampaignMonitor Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide CampaignMonitor data to a chart.
-
Create a Data Access Object for Printify Data using JDBI
A brief overview of creating a SQL Object API for Printify data in JDBI.
-
How to Visualize Google Directory Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Google Directory data in Python.
-
Access Live Amazon DynamoDB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Amazon DynamoDB data from your Excel spreadsheets.
-
Build Figshare-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Figshare data and build web apps with connectivity to live Figshare data.
-
Create Google Spanner-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Spanner Data from Klipfolio and build custom visualizations using live Google Spanner data.
-
Access EnterpriseDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access EnterpriseDB data from your Oracle system.
-
Connect to CSV Data in RazorSQL
Connect to CSV from wizards and query CSV data from the GUI in the RazorSQL database management tool.
-
Replicate YouTube Analytics Data to Multiple Databases via the CData Sync CLI
Replicate YouTube Analytics data to disparate databases with a single configuration.
-
Rapidly Develop Optimizely-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 Optimizely.
-
Integrate with Live Marketo Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Marketo from the MuleSoft Anypoint Platform to integrate live Marketo data into custom reports and dashboards.
-
Build Google Ad Manager-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Google Ad Manager data without replication.
-
How to integrate Coinbase with Apache Airflow
Access and process Coinbase data in Apache Airflow using the CData JDBC Driver.
-
How to Visualize Freshdesk Data in Python with pandas
Use pandas and other modules to analyze and visualize live Freshdesk data in Python.
-
Bidirectional Access to AlloyDB Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate AlloyDB data in Filemaker Pro for Mac or Windows.
-
Access Live ZohoExpense Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ZohoExpense data from your Google Sheets.
-
Access Nuclia Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Nuclia data from your Oracle system.
-
Choosing the Best Method to Connect Invoiced to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Invoiced data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Easily Query LeadDesk Data in OpenOffice Base
Connect to LeadDesk data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Work with Accelo Data in AWS Glue Jobs Using JDBC
Connect to Accelo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate with live Google Calendar Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Calendar data in Jitterbit.
-
Working with Vault CRM Data in LINQPad
Execute LINQ queries to Vault CRM data in LINQPad.
-
Query Productboard Data in DataGrip
Create a Data Source for Productboard in DataGrip and use SQL to query live Productboard data.
-
Connect to YouTube Analytics Data in CloverDX (formerly CloverETL)
Transfer YouTube Analytics data using the visual workflow in the CloverDX data integration tool.
-
Access Excel Online Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Excel Online data from HeidiSQL.
-
Connect to Square Data in Claris FileMaker Pro
Use the CData ODBC Driver for Square in FileMaker Pro to connect to Square and work with Square data in your FileMaker applications.
-
Automated Continuous AgileCRM Replication to SQLite
Use CData Sync for automated, continuous, customizable AgileCRM replication to SQLite.
-
Build AI/ML Models with Live Suadeo Data using Dataiku
Connect Suadeo Data with Dataiku using the CData JDBC Driver for Suadeo.
-
Import Real-Time CloudConvert Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use CloudConvert data in ColdFusion.
-
Phoenix Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Phoenix facts in real time.
-
Analyze Dynamics CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Dynamics CRM from Power Pivot. You will use the Table Import Wizard to load Dynamics CRM data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Live ClickUp Data in MicroStrategy through CData Connect AI
Create a live connection to ClickUp Data in CData Connect AI and connect to your ClickUp data from MicroStrategy.
-
Publish Reports with PostgreSQL Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PostgreSQL data.
-
View Reports on Real-Time Pushbullet Data in Power BI Report Server
Use the CData ODBC Driver for Pushbullet to visualize Pushbullet data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous XML Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable XML replication to Apache Kafka.
-
Use Biml to Build SSIS Tasks to Replicate Attio Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Attio data to SQL Server.
-
Publish ZohoDesk-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZohoDesk data.
-
Connect to Sybase Data from HeidiSQL
Use CData Connect AI to connect to and query live Sybase data from HeidiSQL.
-
Automated Continuous Airtable Replication to Databricks
Use CData Sync for automated, continuous, customizable Airtable replication to Databricks.
-
Build MVC Applications with Connectivity to PDFMonkey Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access PDFMonkey from an ASP.NET MVC application.
-
Build Agents in Relevance AI with Access to Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Vault CRM data within intelligent agent workflows.
-
Access MarkLogic Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MarkLogic data from your Oracle system.
-
Integrate Real-Time Access to SAP BusinessObjects BI in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP BusinessObjects BI data in real time.
-
Getting Started with the CData JDBC Driver for BigQuery
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for BigQuery.
-
Connect Oracle Service Cloud to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle Service Cloud data using the CData Python MCP Server.
-
Automated Sybase Data Replication to Teradata
Use CData Sync to Customize and automate Sybase data replication to Teradata.
-
How to Connect DBeaver to Pipedrive via a JDBC Driver
Manage Pipedrive data with visual tools in DBeaver like the query browser.
-
How to Query Zoho Books Data in MySQL Workbench
Execute MySQL queries against live Zoho Books data from MySQL Workbench.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics NAV
Provide connectivity to Dynamics NAV data through an SAP BusinessObjects universe.
-
Build Agents in Relevance AI with Access to Live JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on JSON services within intelligent agent workflows.
-
Model ZohoExpense Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ZohoExpense, enabling the direct import of real-time ZohoExpense data.
-
Automate Bitbucket Data Replication to SAP HANA
Use CData Sync to customize and automate Bitbucket data replication to SAP HANA.
-
How to connect to AgileCRM Data in DBVisualizer
Integrate AgileCRM data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to Live Sendwithus 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 Sendwithus data for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Paylocity
Provide connectivity to Paylocity data through an SAP BusinessObjects universe.
-
Helpscout Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Helpscout facts in real time.
-
Bridge Freshservice Connectivity with Apache NiFi
Access and process Freshservice data in Apache NiFi using the CData JDBC Driver.
-
Connect to Real-Time ShipEngine Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ShipEngine data in Power Apps.
-
Provide OData Services of Short.io Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Short.io data by developing a WCF Service Application.
-
Deploy the ADO.NET Provider for MongoDB on an SSRS Report Server
Connect to MongoDB 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.
-
Getting Started with the CData JDBC Driver for Zoho Creator
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zoho Creator.
-
Connect to Live SAP ByDesign Data in MicroStrategy through CData Connect AI
Create a live connection to SAP ByDesign Data in CData Connect AI and connect to your SAP ByDesign data from MicroStrategy.
-
Build Agents in Relevance AI with Access to Live Dynamics NAV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Dynamics NAV data within intelligent agent workflows.
-
Automated Continuous Invoiced Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Invoiced replication to Azure SQL Database.
-
Build Dashboards with BigCommerce Data in Dundas BI
Create dynamic dashboards and perform analytics based on BigCommerce data in Dundas BI.
-
How to Visualize MessageBird Data in Python with pandas
Use pandas and other modules to analyze and visualize live MessageBird data in Python.
-
Access Live SAS Data Sets 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 SAS Data Sets data through MCP integration.
-
Access Zendesk Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zendesk data from HeidiSQL.
-
Configure the CData JDBC Driver for JDBC-ODBC Bridge in a Connection Pool in Tomcat
Connect to JDBC-ODBC Bridge data from a connection pool in Tomcat.
-
Integrate Google's Vertex AI Agent with Live Bitly Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Bitly data within intelligent workflows.
-
Connecting Mastra with Apify 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 Apify data, no replication required.
-
Integrate LDAP Objects in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live LDAP objects from Informatica Cloud.
-
Integrate Float with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Float with External Services.
-
How to Connect to Reply.io Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Reply.io data. Leverage the pyodbc module for ODBC in Python.
-
How to Connect the Power BI Service to Pingdom: Complete Guide
Connect to the CData Software Power BI Connector for Pingdom from PowerBI.com to provide real-time Pingdom data across the organization.
-
Connect to Helpscout Data in CloverDX (formerly CloverETL)
Transfer Helpscout data using the visual workflow in the CloverDX data integration tool.
-
Connect to Acumatica Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Acumatica Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Visualize Live Pipeliner CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Pipeliner CRM data.
-
Connect to Snapchat Ads 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 Snapchat Ads data.
-
Create Reports from ZohoMarketingHub Data in Looker Studio
Use CData Connect AI to gain access to live ZohoMarketingHub data and create custom reports in Looker Studio.
-
Publish Crystal Reports on Presto Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Presto data.
-
Use Databricks Agent Bricks to Talk to Your Dropbox Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Dropbox data for you.
-
Microsoft OneDrive Reporting in OBIEE with the Microsoft OneDrive JDBC Driver
Deploy the Microsoft OneDrive JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Monday.com Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Monday.com replication to Apache Cassandra.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Ads
Provide connectivity to Google Ads data through an SAP BusinessObjects universe.
-
Build Zoho Books-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Zoho Books data and build web apps with connectivity to live Zoho Books data.