CData Software - Knowledge Base
Recent Articles
-
LINQ to Azure Table 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 Azure Table Data Provider.
-
How to Connect to MYOB AccountRight Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MYOB AccountRight data. Leverage the pyodbc module for ODBC in Python.
-
Build MVC Applications with Connectivity to SparkPost Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SparkPost from an ASP.NET MVC application.
-
Getting Started with the CData Tableau Connector for Clari
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate Goose with Live Cloudflare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Cloudflare data from within the local AI agent.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Adobe Commerce
Provide connectivity to Adobe Commerce data through an SAP BusinessObjects universe.
-
Connect to Amazon Marketplace Data in HULFT Integrate
Connect to Amazon Marketplace as a JDBC data source in HULFT Integrate
-
Integrate Google's Vertex AI Agent with Live CouchDB 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 CouchDB data within intelligent workflows.
-
Create Mailjet Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Mailjet data access from reports, embedded analytics, and more.
-
Connect to Zuora from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zuora data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Discord Replication to SQL Server
Use CData Sync for automated, continuous, customizable Discord replication to SQL Server.
-
Create Reports from Monday.com Data in Looker Studio
Use CData Connect AI to gain access to live Monday.com data and create custom reports in Looker Studio.
-
Build Sendwithus-Connected Apps in Choreo
Use CData Connect AI to connect to Sendwithus Data from Choreo and build custom apps using live Sendwithus data.
-
Getting Started with the CData Python Connector for Campaigner
Learn to install and license the CData Python Connector and configure a connection to live Campaigner data.
-
DataBind Controls to Clari Data in Delphi
DataBind to Clari data in Delphi with standard data access components and controls.
-
Configure the CData JDBC Driver for Mistral AI in a Connection Pool in Tomcat
Connect to Mistral AI data from a connection pool in Tomcat.
-
Query Live Slack Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Slack data through a conversational interface.
-
Use the CData Software JDBC Driver for BenchmarkEmail in MicroStrategy
Connect to BenchmarkEmail data in MicroStrategy Developer using the CData Software JDBC Driver for BenchmarkEmail.
-
How to connect PolyBase to PabblySubscriptions
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PabblySubscriptions data.
-
Natively Connect to QuickBooks Online Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to QuickBooks Online data. Leverage the native support for ODBC in PHP.
-
Build AI/ML Models with Live Short.io Data using Dataiku
Connect Short.io Data with Dataiku using the CData API Driver for JDBC.
-
Extract, Transform, and Load TaxJar Data in Informatica PowerCenter
Create a simple Workflow for TaxJar data in Informatica PowerCenter.
-
Create GraphQL-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to GraphQL Data from Klipfolio and build custom visualizations using live GraphQL data.
-
Use the CData ODBC Driver for Pipeline CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Pipeline CRM to connect to Pipeline CRM data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Pipeline CRM data in Excel.
-
How to Connect to & Open iContact Data in Microsoft Excel
This article uses the CData ODBC driver for iContact to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous ChargeOver Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ChargeOver data replication to OneLake in Microsoft Fabric.
-
Access Google Analytics Data from MySQL in PHP
Connect to Google Analytics through the standard MySQL libraries in PHP.
-
Visualize Email Data in Tableau
The CData ODBC driver for Email enables you integrate Email data into Tableau dashboards.
-
Create Oracle-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Oracle Data from OutSystems and build custom enterprise apps using live Oracle data.
-
How to Create Power BI Visual Reports with Real-Time Typeform Data
Use CData Power BI Connectors to visualize Typeform data in Power BI.
-
Explore Geographical Relationships in Webflow Data with Power Map
Create data visualizations with Webflow data in Power Map.
-
Seamlessly Bring SAS xpt Data into Retool Using CData Connect AI
Integrate SAS xpt data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous SingleStore Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SingleStore data replication to OneLake in Microsoft Fabric.
-
Connect to Amazon Athena Data in ACL Analytics
Connect to Amazon Athena data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Amazon Athena data.
-
Replicate Multiple Vault CRM Accounts via the CData Sync CLI
Replicate multiple Vault CRM accounts to one or many databases.
-
Build Google Cloud Storage-Connected Apps in Choreo
Use CData Connect AI to connect to Google Cloud Storage Data from Choreo and build custom apps using live Google Cloud Storage data.
-
Access Live SAP ByDesign Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP ByDesign data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Visualizations of Oracle Sales Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle Sales data in Birst.
-
Manage Freshteam Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Freshteam.
-
Integrate with Stack Exchange Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Stack Exchange data to a JSON file on disk.
-
Automated Spark Data Replication to Teradata
Use CData Sync to Customize and automate Spark data replication to Teradata.
-
Integrating GitHub Copilot with Mocean 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 and Visualize Live Coda Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Coda data into the Databricks platform and create visualization dashboards with real-time Coda data.
-
How to Connect to Live SAP Ariba Procurement 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 SAP Ariba Procurement data for you.
-
Build SharePoint-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 SharePoint data without replication.
-
Build Samanage-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Samanage Data from Zoho Analytics and import live Samanage data.
-
Connect to NetSuite SuiteAnalytics Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for NetSuite SuiteAnalytics data in Airbyte.
-
Integrate Google's Antigravity Agent with Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Procore data using the Model Context Protocol.
-
Using the CData Software ODBC Driver for Snowflake in PyCharm
Connect to Snowflake as an ODBC data source in PyCharm using the CData Software ODBC Driver for Snowflake.
-
Connect to IBM Informix Data in Claris FileMaker Pro
Use the CData ODBC Driver for IBM Informix in FileMaker Pro to connect to IBM Informix and work with IBM Informix data in your FileMaker applications.
-
Build AI/ML Models with Live LeadDesk Data using Dataiku
Connect LeadDesk Data with Dataiku using the CData API Driver for JDBC.
-
How to integrate ZohoDesk with Apache Airflow
Access and process ZohoDesk data in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData JDBC Driver for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dynamics NAV.
-
Rapidly Develop Act-On-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 Act-On.
-
Edit and Search External SAP Hybris C4C Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Hybris C4C data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Hybris C4C Data objects that you can access from apps and the dashboard.
-
Automated Continuous Omnisend Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Omnisend replication to IBM DB2.
-
Build MVC Applications with Connectivity to Accelo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Accelo from an ASP.NET MVC application.
-
Write a Simple Go Application to work with Wave Financial Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Wave Financial data.
-
Create Guru-Connected Applications in Appsmith
Connect to Guru Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Guru data.
-
Use Claude to Talk to Your Elasticsearch 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 Elasticsearch data for you.
-
Automated Continuous ShipEngine Replication to SQLite
Use CData Sync for automated, continuous, customizable ShipEngine replication to SQLite.
-
Use Dash to Build to Web Apps on Strava Data
Create Python applications that use pandas and Dash to build Strava-connected web apps.
-
Connect to Attio Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Attio Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Analyze Live MySQL Data in SAS Viya
Use CData Connect AI to connect to MySQL data from SAS Viya and deploy self-service analytics using live MySQL data.
-
Integrating Codex with Harvest 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.
-
Getting Started with the CData ODBC Driver for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for LightSpeedRetail.
-
Query, Visualize, and Share live Twitter Ads Data in Redash
Use CData Connect AI to connect to live Twitter Ads data in Redash for querying, visualizing, and sharing.
-
How to Connect to Live Twilio Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Twilio data for you.
-
How to create Authorize.Net federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Authorize.Net data in MySQL .
-
Explore Geographical Relationships in Power BI XMLA Data with Power Map
Create data visualizations with Power BI XMLA data in Power Map.
-
Automated Continuous Trello Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Trello replication to PostgreSQL.
-
Connect to DocuSign Data in Aqua Data Studio
Access DocuSign data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Sendwithus Data from a Connection Pool in JBoss
Integrate Sendwithus data into Java servlets: Use the Management Console in JBoss to install the Sendwithus JDBC Driver.
-
Query QuickBooks Time Data as a SQL Server Database in Node.js
Execute SQL Server queries against QuickBooks Time data from Node.js.
-
Automated Continuous ZohoSubscriptions Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Apache Cassandra.
-
Access Contentful 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 Contentful data.
-
Integrating Kiro with Databricks 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.
-
Building Dynamic Web Pages with QuickBooks Time Data Using AngularJS
Create single-page applications with live connectivity to QuickBooks Time using the CData API Server.
-
Create MariaDB-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to MariaDB Data from Klipfolio and build custom visualizations using live MariaDB data.
-
How to Connect to Live CapsuleCRM Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live CapsuleCRM data securely in real time.
-
Build Dashboards with Act-On Data in DBxtra
Create dynamic dashboards and perform analytics based on Act-On data in DBxtra.
-
Work with EmailOctopus Data in FoxPro
Load EmailOctopus data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use Grok to Talk to Your Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Cvent data for you.
-
How to Access Live Customer.io Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Customer.io enables you to integrate Customer.io data into workflows built using Microsoft Power Automate Desktop.
-
Query Live HDFS Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live HDFS data through a conversational interface.
-
How to integrate Metabase with SQL Analysis Services Data
Use CData Connect AI to connect to live SQL Analysis Services data and create an interactive dashboard in Metabase from SQL Analysis Services data.
-
Create Wistia-Connected Business Apps in AppSheet
Connect to Wistia Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Wistia data.
-
Use Grok to Talk to Your Bright Data Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Bright Data data for you.
-
Automated Continuous Cohere Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Cohere data replication to OneLake in Microsoft Fabric.
-
Automate Vercel Data Replication to Azure Synapse
Use CData Sync to customize and automate Vercel data replication to Azure Synapse.
-
Connect to Pipeliner CRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Pipeliner CRM as an External Source in Dremio.
-
Analyze Cloudflare Data in Looker
Use CData Connect AI to connect to Cloudflare Data from Looker and build custom apps using live Cloudflare data.
-
How to create Visio diagrams from IBM Informix Data
Automatically update IBM Informix data with the changes you make to Visio master shapes.
-
Use the CData ODBC Driver for OData from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for OData to connect to OData services from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring OData services in Excel.
-
How to integrate SAS Data Sets with Apache Airflow
Access and process SAS Data Sets data in Apache Airflow using the CData JDBC Driver.
-
Rapidly Develop Greenplum-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 Greenplum.
-
How to import Amazon Athena Data into Apache Solr
Use the CData Software JDBC Driver for Amazon Athena in Data Import Handler and create an automated import of Amazon Athena data to Apache Solr Enterprise Search platform.
-
How to Connect Flowise AI Agents to Live SAS Data Sets Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live SAS Data Sets data without replication.
-
How to connect and process Strava data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Strava data.
-
Automated Continuous Coda Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Coda replication to Azure SQL Database.