CData Software - Knowledge Base
Recent Articles
-
How to create Visio diagrams from eBay Data
Automatically update eBay with the changes you make to Visio master shapes.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live HubSpot 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. 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 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 from HeidiSQL.
-
Deploy the ADO.NET Provider for Kintone on an SSRS Report Server
Connect to Kintone 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.
-
Integrate with BigQuery Data in JReport Designer
Create charts and reports based on Google BigQuery in JReport Designer.
-
Access Microsoft Dataverse Data from MySQL in PHP
Connect to Microsoft Dataverse through the standard MySQL libraries in PHP.
-
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 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 and build automated workflows in Workato.
-
How to Query Live Greenhouse Data in Claude Desktop
Connect to and query live Greenhouse Data in Claude Desktop using CData MCP Server.
-
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 directly from the development environment.
-
Use the CData Software JDBC Driver for Workday in MicroStrategy
Connect to Workday 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 in the Denodo Virtual DataPort Administrator.
-
Access Live Superchat Data in Coginiti Pro
Connect to and query live Superchat 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 in Power BI Desktop.
-
Connect to QuickBooks Online Data from a Connection Pool in JBoss
Integrate QuickBooks Online 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 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 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 through MCP integration.
-
Integrating GitHub Copilot CLI with Microsoft Dataverse (CDS) 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.
-
Automate ClickUp Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ClickUp from PowerShell? This article demonstrates how to utilize the ClickUp Cmdlets for tasks like connecting to ClickUp, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for Dropbox in MicroStrategy Desktop
Connect to Dropbox 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 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 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 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 in MicroStrategy Desktop using the CData Software ODBC Driver for Google Sheets.
-
Design BIRT Reports on SageHR Data
Provide current SageHR to your embedded analytics.
-
How to import Drift Data into Apache Solr
Use the CData Software JDBC Driver for Drift in Data Import Handler and create an automated import of Drift to Apache Solr Enterprise Search platform.
-
Operational Reporting on Quaderno Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Quaderno.
-
Consume eBay OData Feeds in PowerBuilder
This article demonstrates how to consume eBay as OData feeds from PowerBuilder using the API Server.
-
Back Up SAP Fieldglass 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.
-
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.
-
Analyze Google Directory Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Directory and visualize live Google Directory in Infragistics Reveal.
-
Connect to Oracle HCM Cloud in SpagoBI
Create reports featuring live Oracle HCM Cloud in SpagoBI Studio. Host Oracle HCM Cloud reports on SpagoBI Server.
-
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 and build web apps with connectivity to live Onfleet.
-
Connect to Twitter Ads from a Connection Pool in WebLogic
Use the CData JDBC Driver for Twitter Ads to connect to Twitter Ads from Web applications running on WebLogic.
-
Work with Live MailChimp Data in Power Query
Use CData Connect AI to connect to MailChimp and work with live MailChimp 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 in real time.
-
DataBind Charts to Freshsales Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Freshsales 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 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 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.
-
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 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 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 from your Excel spreadsheets.
-
Freshdesk Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Freshdesk through CData Connect AI using different applications and tools.
-
Easily Integrate CloudConvert Data in Lazarus Pascal IDE
Learn how to easily integrate live CloudConvert 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 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.
-
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.
-
Integrate with Planio Data in JReport Designer
Create charts and reports based on Planio in JReport Designer.
-
Access Printful Data from MySQL in Amazon QuickSight
Connect to Printful and build visualizations of Printful using a MySQL Connection in Amazon QuickSight.
-
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 from your AWS Glue jobs.
-
Migrating data from Keap to Databricks using CData SSIS Components.
Easily push Keap 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.
-
Prepare, Blend, and Analyze IBM Informix Data in Alteryx Designer (ODBC)
Build workflows to access live IBM Informix for self-service data analytics.
-
Analyze XML Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze XML Files in Microsoft R Open.
-
Extend Google Sheets with Dynamics 365 Data
Make calls to Dynamics 365 from Google Apps Script via the API Server.
-
How to connect to Exact Online Data from IntelliJ
Integrate connectivity to Exact Online with wizards in IntelliJ.
-
Access Codat Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Codat from your Oracle system.
-
Connect to Real-Time Hugging Face Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Hugging Face in Power Apps.
-
Getting Started with the CData Excel Add-In for Apollo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Apollo.
-
How to connect to Scrapfly Data from IntelliJ
Integrate connectivity to Scrapfly with wizards in IntelliJ.
-
Replicate Multiple QuickBooks Time Accounts
Replicate multiple QuickBooks Time accounts to one or many databases.
-
Excel Spreadsheet Automation on Salesforce CRM Analytics Data with the QUERY Formula
Pull data from Salesforce CRM Analytics, automate spreadsheets, and more with the QUERY formula.
-
Integrate Live Sybase IQ Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Sybase IQ from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Sybase IQ.
-
Connect to BigQuery Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for BigQuery and the SQL Gateway to access Google BigQuery from Google Apps Script.
-
Import Real-Time Attio Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Attio in ColdFusion.
-
Use Databricks Agent Bricks to Talk to Your SAP Ariba Procurement Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Ariba Procurement for you.
-
How to connect to Zoho Recruit Data with Squirrel SQL client
Connect to Zoho Recruit and execute queries in the Squirrel SQL Client.
-
LINQ to Recurly 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 Recurly Data Provider.
-
Use the CData Software ODBC Driver for ScrapingBee in MicroStrategy
Connect to ScrapingBee in MicroStrategy Developer using the CData Software ODBC Driver for ScrapingBee.
-
Integrate Oracle Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Oracle Database from Informatica Cloud.
-
Integrate Theia IDE with Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
A PostgreSQL Interface for Square Data (MySQL Remoting via JDBC)
Use the Remoting features of the Square JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Databricks Agent Bricks to Talk to Your QuickBooks Time Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your QuickBooks Time for you.
-
Automated Continuous Opsgenie Replication to Oracle
Use CData Sync for automated, continuous, customizable Opsgenie replication to Oracle.
-
Access Live Monday.com Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Monday.com in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Building Dynamic Web Pages with Trello Data Using AngularJS
Create single-page applications with live connectivity to Trello using the CData API Server.
-
Automated Continuous Google Analytics Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Analytics replication to IBM DB2.
-
Build Automated Workflows with Live Jira Data in Workato
Use CData Connect AI to connect to live Atlassian Jira and build automated workflows in Workato.
-
Automated Continuous Quickbase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Quickbase replication to Apache Kafka.
-
Migrating data from Hubstaff to Databricks using CData SSIS Components.
Easily push Hubstaff to Databricks using the CData SSIS Tasks for Hubstaff and Databricks.
-
How to connect PolyBase to AfterShip
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live AfterShip.
-
Getting Started with the CData JDBC Driver for Monday.com
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Monday.com.
-
Connect to HubDB Data in Jaspersoft Studio
Execute SQL to remote HubDB in Jaspersoft Studio.