CData Software - Knowledge Base
Recent Articles
-
Model, Search, and Visualize Live Google Contacts Data in ThoughtSpot
Use CData Connect AI to connect to live Google Contacts data for modeling, searching, and visualizing.
-
Moving Data from MySQL to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MySQL data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Automated Workflows with Live Azure Data Lake Storage Data in Workato
Use CData Connect AI to connect to live Azure Data Lake Storage data and build automated workflows in Workato.
-
Access Live Zoho Projects Data in Excel 365 Online (Excel for the web)
Connect to Zoho Projects data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate OpenCode with Live Guru Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Guru data from within your AI coding agent.
-
Query Drip Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Drip data from Node.js.
-
Use CData Connect AI to Access MailChimp Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MailChimp data in the Power Pivot business intelligence tool.
-
Extract, Transform, and Load Greenhouse Data in Informatica PowerCenter
Create a simple Workflow for Greenhouse data in Informatica PowerCenter.
-
Automated Continuous Zoho CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zoho CRM replication to PostgreSQL.
-
How to Seamlessly Import Elorus Data into IBM SPSS Modeler
Integrate Elorus data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Act CRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Act CRM data from Filemaker Pro on Mac.
-
Connect to AlloyDB Data in DBArtisan
Use wizards in DBArtisan to configure AlloyDB data as a data source.
-
Natively Connect to Google Campaign Manager 360 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Campaign Manager 360 data. Leverage the native support for ODBC in PHP.
-
Prepare, Blend, and Analyze JSON Services in Alteryx Designer (ODBC)
Build workflows to access live JSON services for self-service data analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SparkPost
Provide connectivity to SparkPost data through an SAP BusinessObjects universe.
-
Create Redshift-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Redshift Data from OutSystems and build custom enterprise apps using live Redshift data.
-
How to create Visio diagrams from eBay Data
Automatically update eBay data with the changes you make to Visio master shapes.
-
Integrate Google's Vertex AI Agent with Live HubSpot 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 HubSpot data within intelligent workflows.
-
Natively Connect to Zoho CRM Data in PHP
The CData ODBC driver for Zoho CRM enables you to create PHP applications with connectivity to Zoho CRM data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData ODBC Driver for Scrapfly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Scrapfly.
-
Integrate Miro Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Miro data from Informatica Cloud.
-
Automated Continuous Marketo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Marketo replication to Snowflake.
-
Access Google Directory Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Directory data from HeidiSQL.
-
Deploy the ADO.NET Provider for Kintone on an SSRS Report Server
Connect to Kintone 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 NASA Data in JRuby
Create a simple JRuby app with access to live NASA data.
-
Integrate with BigQuery Data in JReport Designer
Create charts and reports based on BigQuery data in JReport Designer.
-
Access Microsoft Dataverse Data from MySQL in PHP
Connect to Microsoft Dataverse through the standard MySQL libraries in PHP.
-
Connect to Bright Data Data from HeidiSQL
Use CData Connect AI to connect to and query live Bright Data data from HeidiSQL.
-
PolarTeamPro Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on PolarTeamPro facts in real time.
-
Create Datasets from Pinecone in Domo Workbench and Build Visualizations of Pinecone Data in Domo
Use the CData Software ODBC Driver for Pinecone to create datasets from Pinecone data in Domo Workbench and then build visualizations in the Domo service.
-
Build Automated Workflows with Live EnterpriseDB Data in Workato
Use CData Connect AI to connect to live EnterpriseDB data and build automated workflows in Workato.
-
Import Salesloft Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Salesloft Data and provide access to live Salesloft data for custom reports in the Power BI Service.
-
How to Connect to Live Shortcut 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 Shortcut data for you.
-
Automated Continuous Datadog Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Datadog replication to Azure SQL Database.
-
Query Live Google Cloud Storage 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 Google Cloud Storage data directly from the development environment.
-
Create Apps from ZohoSubscriptions Data in Qlik Sense Cloud
Use CData Connect AI to connect to ZohoSubscriptions Data and build apps from live ZohoSubscriptions data in Qlik Sense Cloud.
-
Use the CData Software JDBC Driver for Workday in MicroStrategy
Connect to Workday data in MicroStrategy Developer using the CData Software JDBC Driver for Workday.
-
Connect to Keap Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Keap data in the Denodo Virtual DataPort Administrator.
-
Use Microsoft Copilot Studio to talk to your SparkPost 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 SparkPost data for you.
-
Integrate Devin with Live Cosmos DB Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Cosmos DB data.
-
Access Live Superchat Data in Coginiti Pro
Connect to and query live Superchat data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Power BI Reports on Real-Time Trello Data
Use the CData ODBC Driver for Trello to visualize Trello data in Power BI Desktop.
-
Connect to QuickBooks Online Data from a Connection Pool in JBoss
Integrate QuickBooks Online data into Java servlets: Use the Management Console in JBoss to install the QuickBooks Online JDBC Driver.
-
Build MVC Applications with Connectivity to OneNote Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access OneNote from an ASP.NET MVC application.
-
Integrating SAS Data Sets Data in Talend Cloud Data Management Platform
Connect SAS Data Sets Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAS Data Sets.
-
Connect to Zoho Books Data in Aqua Data Studio
Access Zoho Books data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Square-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Square Data and create custom apps in Mendix.
-
Replicate SparkPost Data in Heroku for Use in Salesforce Connect
Replicate SparkPost data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Microsoft Entra ID 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 Microsoft Entra ID data through MCP integration.
-
Integrating GitHub Copilot with Microsoft Dataverse 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 Cohere Replication to MySQL
Use CData Sync for automated, continuous, customizable Cohere replication to MySQL.
-
Integrate Trae with Live Zendesk Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Zendesk data from within the AI-powered IDE.
-
Automate ClickUp Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ClickUp data from PowerShell? This article demonstrates how to utilize the ClickUp Cmdlets for tasks like connecting to ClickUp data, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for Dropbox in MicroStrategy Desktop
Connect to Dropbox data in MicroStrategy Desktop using the CData Software JDBC Driver for Dropbox.
-
Access Live Lakebase Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Lakebase data from your Excel spreadsheets.
-
Access Live Raisers Edge NXT Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Raisers Edge NXT data from your Excel spreadsheets.
-
Getting Started with the CData ADO.NET Provider for SendGrid
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SendGrid.
-
Connect to Instagram Data in Aqua Data Studio
Access Instagram data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software ODBC Driver for Google Sheets in MicroStrategy Desktop
Connect to Google Sheets data in MicroStrategy Desktop using the CData Software ODBC Driver for Google Sheets.
-
Design BIRT Reports on SageHR Data
Provide current SageHR data to your embedded analytics.
-
Operational Reporting on Quaderno Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Quaderno data.
-
Integrate OpenCode with Live Cvent Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Cvent data from within your AI coding agent.
-
Consume eBay OData Feeds in PowerBuilder
This article demonstrates how to consume eBay data as OData feeds from PowerBuilder using the API Server.
-
Back Up SAP Fieldglass data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Fieldglass. In this article, we will employ an SSIS workflow to populate a database with SAP Fieldglass data data.
-
Create MailChimp-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to MailChimp Data from OutSystems and build custom enterprise apps using live MailChimp data.
-
Analyze Google Directory Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Directory data and visualize live Google Directory data in Infragistics Reveal.
-
Connect to Oracle HCM Cloud in SpagoBI
Create reports featuring live Oracle HCM Cloud data in SpagoBI Studio. Host Oracle HCM Cloud reports on SpagoBI Server.
-
Integrate OpenCode with Live HubSpot Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live HubSpot data from within your AI coding agent.
-
Integrate OpenCode with Live YouTube Analytics Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live YouTube Analytics data from within your AI coding agent.
-
Moving Data from Procore to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Procore data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Unbounce Replication to Oracle
Use CData Sync for automated, continuous, customizable Unbounce replication to Oracle.
-
Build Onfleet-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Onfleet data and build web apps with connectivity to live Onfleet data.
-
Connect to Twitter Ads from a Connection Pool in WebLogic
Use the CData JDBC Driver for Twitter Ads to connect to Twitter Ads data from Web applications running on WebLogic.
-
Work with Live MailChimp Data in Power Query
Use CData Connect AI to connect to MailChimp data and work with live MailChimp data in Microsoft Power Query.
-
Integrate Real-Time Access to Google Campaign Manager 360 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Campaign Manager 360 data in real time.
-
DataBind Charts to Freshsales Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Freshsales 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.
-
Integrate with Trello Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Trello data to a JSON file on disk.
-
Build Dashboards with Google Ad Manager Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Ad Manager data in Dundas BI.
-
Integrating Claude Code CLI with Recurly 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.
-
Visualize Live MailChimp Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MailChimp data.
-
Integrate with Live Presto Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Presto from the MuleSoft Anypoint Platform to integrate live Presto data into custom reports and dashboards.
-
Connect to ActiveCampaign Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ActiveCampaign data using standard SQL.
-
Access Live Bullhorn CRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Bullhorn CRM data from your Excel spreadsheets.
-
Freshdesk Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Freshdesk data through CData Connect AI using different applications and tools.
-
Easily Integrate CloudConvert Data in Lazarus Pascal IDE
Learn how to easily integrate live CloudConvert data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate with Mixpanel Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Mixpanel data to a JSON file on disk.
-
Create Dynamic Zendesk Grids Using the Infragistics XamDataGrid
Learn how you can connect Zendesk to Infragistics XamDataGrid to build dynamic grids.
-
Build Voice Agents in ElevenLabs with access to Live SAP Business Warehouse Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP Business Warehouse data.
-
Publish Crystal Reports on Twitter Ads Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Twitter Ads data.
-
Build SAP Business Warehouse-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP Business Warehouse data and build SAP Business Warehouse-connected web apps with Axios.
-
Integrate with Planio Data in JReport Designer
Create charts and reports based on Planio data in JReport Designer.
-
Access Printful Data from MySQL in Amazon QuickSight
Connect to Printful and build visualizations of Printful data using a MySQL Connection in Amazon QuickSight.
-
Analyze Campaigner Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Campaigner data and visualize Campaigner data in SAP Analytics Cloud.
-
Using the CData Software ODBC Driver for OpenWeatherMap in PyCharm
Connect to OpenWeatherMap as an ODBC data source in PyCharm using the CData Software ODBC Driver for OpenWeatherMap.
-
Connect to Microsoft Entra ID Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Entra ID data from your AWS Glue jobs.
-
Migrating data from Keap to Databricks using CData SSIS Components.
Easily push Keap data to Databricks using the CData SSIS Tasks for Keap and Databricks.
-
Create Marketo-Connected Dashboards in Grafana
Connect to Marketo Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Marketo data.
-
Prepare, Blend, and Analyze IBM Informix Data in Alteryx Designer (ODBC)
Build workflows to access live IBM Informix data for self-service data analytics.
-
Analyze XML Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze XML data in Microsoft R Open.
-
How to connect to Exact Online Data from IntelliJ
Integrate connectivity to Exact Online data with wizards in IntelliJ.