CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ADO.NET Provider for Azure Table
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Azure Table.
-
DataBind Freshsales Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Freshsales data to a chart.
-
Build Apps with Live JotForm Data Using the Low-Code Development Platform of Mendix
Connect JotForm data with Mendix to build apps using the CData API Driver for JDBC.
-
Seamlessly Bring LDAP Objects into Retool Using CData Connect AI
Integrate LDAP data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Publish Blackbaud FE NXT-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Blackbaud FE NXT data.
-
Choosing the Best Method to Connect LaunchDarkly to SQL Server: 5 Options Explained
Discover multiple ways to connect and use LaunchDarkly data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Feed CapsuleCRM Data into FineReport
How to set CapsuleCRM data as a JDBC data source in FineReport.
-
Connect to Outlook Data from a Connection Pool in Jetty
The Outlook JDBC Driver supports connection pooling: This article shows how to connect faster to Outlook data from Web apps in Jetty.
-
Connect to HDFS Data in RapidMiner
Integrate HDFS data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automate SAP Hybris C4C Data Replication to SAP HANA
Use CData Sync to customize and automate SAP Hybris C4C data replication to SAP HANA.
-
Access Live Pingdom Data in AWS Lambda
Connect to live Pingdom data in AWS Lambda using the CData JDBC Driver.
-
How to connect to Avaza Data from IntelliJ
Integrate connectivity to Avaza data with wizards in IntelliJ.
-
Integrate Rebilly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Rebilly with External Services.
-
Automated Continuous Calendly Replication to MySQL
Use CData Sync for automated, continuous, customizable Calendly replication to MySQL.
-
Access MailerLite Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MailerLite data from your Oracle system.
-
How to load FormSite data into Elasticsearch via Logstash
Introducing a simple method to load FormSite data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Onfleet Data in AWS Lambda
Connect to live Onfleet data in AWS Lambda using the CData JDBC Driver.
-
Integrate Open WebUI with Live Exa Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Exa data from within the chat interface.
-
LINQ to MongoDB 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 MongoDB Data Provider.
-
Access Live SAP ByDesign 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 SAP ByDesign data through MCP integration.
-
Integrate Active Directory Data into Power Automate Desktop using CData Connect
CData Connect for Active Directory Data enables you to integrate Active Directory data into workflows built using Microsoft Power Automate Desktop.
-
Visualize Codat Data in Tableau
The CData ODBC driver for Codat enables you integrate Codat data into Tableau dashboards.
-
How to connect to Spotify Data in DBVisualizer
Integrate Spotify data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate Pinterest Data Replication to Azure Synapse
Use CData Sync to customize and automate Pinterest data replication to Azure Synapse.
-
Create Oracle-Connected Dashboards in Grafana
Connect to Oracle Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Toggl
Provide connectivity to Toggl data through an SAP BusinessObjects universe.
-
Rapidly Develop Cassandra-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 Cassandra.
-
Build Zoho Projects-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Zoho Projects Data and create custom apps in Bubble.
-
How to update AlloyDB from Excel
This article explains how to transfer data from Excel to AlloyDB using the Excel Add-In for AlloyDB.
-
Integrate QuickBooks Data in the Pentaho Report Designer
Publish reports based on QuickBooks data in the Pentaho BI tool.
-
Analyze SAP Business Warehouse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Business Warehouse data in Microsoft R Open.
-
Use Microsoft Copilot Studio to talk to your Google Contacts 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 Google Contacts data for you.
-
Create Microsoft Dataverse-Connected Dashboards in Grafana
Connect to Microsoft Dataverse Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft Dataverse data.
-
How to work with Tavily Data in Apache Spark using SQL
Access and process Tavily Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect DBeaver to Cvent via a JDBC Driver
Manage Cvent data with visual tools in DBeaver like the query browser.
-
Access Live Adobe Experience Manager Data in AWS Lambda
Connect to live Adobe Experience Manager data in AWS Lambda using the CData JDBC Driver.
-
How to Seamlessly Import CircleCI Data into IBM SPSS Modeler
Integrate CircleCI data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous OData Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable OData replication to delimited files (CSV/TSV).
-
Choosing the Best Method to Connect Azure Table to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Azure Table data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Superchat Data in DBArtisan
Use wizards in DBArtisan to configure Superchat data as a data source.
-
Integrate Live Google Translate Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Translate data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating LangGraph with Confluence Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Confluence data within automated workflows.
-
Explore Geographical Relationships in SAP Concur Data with Power Map
Create data visualizations with SAP Concur data in Power Map.
-
Build MVC Applications with Connectivity to SAP Concur Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Concur from an ASP.NET MVC application.
-
Deploy the ADO.NET Provider for Mailgun on an SSRS Report Server
Connect to Mailgun 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.
-
Use the CData Software ODBC Driver for Outlook in MicroStrategy Desktop
Connect to Outlook data in MicroStrategy Desktop using the CData Software ODBC Driver for Outlook.
-
DataBind Charts to Cassandra Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Cassandra 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.
-
Automate Shopify Data Replication to Azure Synapse
Use CData Sync to customize and automate Shopify data replication to Azure Synapse.
-
Query Discord Data in DataGrip
Create a Data Source for Discord in DataGrip and use SQL to query live Discord data.
-
How to Connect to Live Guru Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Guru data for you.
-
Getting Started with the CData Tableau Connector for Google Ads
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Ads.
-
Visualize Qualaroo Data in TIBCO Spotfire through ADO.NET
Integrate Qualaroo data into dashboards in TIBCO Spotfire.
-
Automate ZohoExpense Data Replication to Azure Synapse
Use CData Sync to customize and automate ZohoExpense data replication to Azure Synapse.
-
Integrating Codex with Auth0 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.
-
Excel Spreadsheet Automation on NetSuite Data with the QUERY Formula
Pull data from NetSuite, automate spreadsheets, and more with the QUERY formula.
-
Build a PostgreSQL Interface for ZarMoney Data using the CData JDBC Driver
Use the Remoting features of the ZarMoney JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Avalara AvaTax-Connected Dashboards in Grafana
Connect to Avalara AvaTax Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Avalara AvaTax data.
-
DataBind Controls to Helpscout Data in Delphi
DataBind to Helpscout data in Delphi with standard data access components and controls.
-
Create Reports with Unbounce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Unbounce data.
-
How to Connect to Live Samanage Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Samanage data through natural language.
-
Create Datasets from Avalara AvaTax in Domo Workbench and Build Visualizations of Avalara AvaTax Data in Domo
Use the CData Software ODBC Driver for Avalara AvaTax to create datasets from Avalara AvaTax data in Domo Workbench and then build visualizations in the Domo service.
-
How to work with PabblySubscriptions Data in Apache Spark using SQL
Access and process PabblySubscriptions Data in Apache Spark using the CData Software JDBC Driver.
-
Automate Basecamp Data Replication to Azure Synapse
Use CData Sync to customize and automate Basecamp data replication to Azure Synapse.
-
How to connect to Sybase Data in DBVisualizer
Integrate Sybase data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Easily Query Reckon Data in OpenOffice Base
Connect to Reckon data in OpenOffice Base using the CData ODBC Driver for Reckon and generate reports with live data insights.
-
Access ZohoMarketingHub Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for ZohoMarketingHub data.
-
How to Access Odoo Data Using Entity Framework
This article shows how to access Odoo data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query Tickspot Data as a MySQL Database in Node.js
Execute MySQL queries against Tickspot data from Node.js.
-
Visualize Dynamics NAV 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 Dynamics NAV data into TIBCO Spotfire.
-
Creating ZohoSubscriptions-Connected Applications in Unqork
You can use CData Connect AI to feed ZohoSubscriptions data to Unqork and build custom business apps.
-
Integrating OpenCode with Airtable 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.
-
Connect to Jira Assets Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Jira Assets data in the Denodo Virtual DataPort Administrator.
-
View Reports on Real-Time SAP Fieldglass Data in Power BI Report Server
Use the CData ODBC Driver for SAP Fieldglass to visualize SAP Fieldglass data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Access Oracle Eloqua Data Using Entity Framework
This article shows how to access Oracle Eloqua data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live Zuora Data in Excel 365 Online (Excel for the web)
Connect to Zuora data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData Software JDBC Driver for Basecamp in MicroStrategy Desktop
Connect to Basecamp data in MicroStrategy Desktop using the CData Software JDBC Driver for Basecamp.
-
How to Create Power BI Visual Reports with Real-Time Redshift Data
Use CData Power BI Connectors to visualize Redshift data in Power BI.
-
Import Real-Time Mode Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Mode data in ColdFusion.
-
Enable the Rebilly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Rebilly data.
-
Back Up Missive data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Missive data data.
-
Integrating Antigravity CLI with Excel Online data via CData CLI
Connect Excel Online data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build a Simple VCL Application for ShipEngine Data
How to build a simple VCL Application to view ShipEngine data in RAD Studio using the CData ODBC Driver for ShipEngine.
-
Visualize Cloudflare Data in TIBCO Spotfire through ADO.NET
Integrate Cloudflare data into dashboards in TIBCO Spotfire.
-
Build Snowflake-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 Snowflake data without replication.
-
Build Microsoft Planner-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Microsoft Planner Data from Zoho Analytics and import live Microsoft Planner data.
-
Getting Started with the CData SSIS Components for Billsby
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Billsby.
-
Prepare, Blend, and Analyze SageHR Data in Alteryx Designer (ODBC)
Build workflows to access live SageHR data for self-service data analytics.
-
Query EnterpriseDB Data as a MySQL Database in Node.js
Execute MySQL queries against EnterpriseDB data from Node.js.
-
Build SAP HANA XS Advanced-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP HANA XS Advanced Data and create custom apps in Bubble.
-
Natively Connect to Adobe Analytics Data in PHP
The CData ODBC driver for Adobe Analytics enables you to create PHP applications with connectivity to Adobe Analytics data. Leverage the native support for ODBC in PHP.
-
Build Instagram Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Instagram data and build visualizations in Tableau Cloud.
-
How to Connect to Live Microsoft OneDrive Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Microsoft OneDrive data without replication.
-
How to Access Live Zoho Creator Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoho Creator enables you to integrate Zoho Creator data into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to Excel Online Data in Delphi
DataBind to Excel Online data in Delphi with standard data access components and controls.
-
Getting Started with the CData ODBC Driver for Jumpseller
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Jumpseller.
-
Work with Tanda Data in FoxPro
Load Tanda data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect to & Open Teradata Data in Microsoft Excel
This article uses the CData ODBC driver for Teradata to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate with Live DB2 Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to DB2 from the MuleSoft Anypoint Platform to integrate live DB2 data into custom reports and dashboards.
-
Migrating data from Raisers Edge NXT to Databricks using CData SSIS Components.
Easily push Raisers Edge NXT data to Databricks using the CData SSIS Tasks for Raisers Edge NXT and Databricks.
-
Integrate Cline with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Azure Synapse data from within your IDE.