CData Software - Knowledge Base
Recent Articles
-
Integrating GitHub Copilot with TaxJar 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 SSIS Components for Moosend
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Moosend.
-
DataBind GitLab Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide GitLab data to a chart.
-
Connect to Slack Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Slack and the SQL Gateway to access Slack data from Google Apps Script.
-
Connect to CapsuleCRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access CapsuleCRM data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use Biml to Build SSIS Tasks to Replicate iContact Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate iContact data to SQL Server.
-
Integrate OpenCode with Live Square Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Square data from within your AI coding agent.
-
Integrating LlamaIndex with BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on BambooHR data in real time.
-
A PostgreSQL Interface for Coinbase Data using the CData ODBC Driver
Use the SQL Gateway and Coinbase ODBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Reports with Pinterest Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pinterest data.
-
Visualize iContact Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to iContact data.
-
Build Dashboards with Clari Data in DBxtra
Create dynamic dashboards and perform analytics based on Clari data in DBxtra.
-
Access Live Strava Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Strava data into the statistical analysis tools available in SAS JMP. This article shows how to use Strava data in the Graph Builder and Query Builder.
-
Excel Spreadsheet Automation on Instantly Data with the QUERY Formula
Pull data from Instantly, automate spreadsheets, and more with the QUERY formula.
-
Create HCL Domino-Connected Business Apps in AppSheet
Connect to HCL Domino Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to HCL Domino data.
-
Automated Continuous Office 365 Replication to SQL Server
Use CData Sync for automated, continuous, customizable Office 365 replication to SQL Server.
-
Using the CData Software ODBC Driver for Amplitude in PyCharm
Connect to Amplitude as an ODBC data source in PyCharm using the CData Software ODBC Driver for Amplitude.
-
Automate Google Sheets Data Replication to SAP HANA
Use CData Sync to customize and automate Google Sheets data replication to SAP HANA.
-
Visualize Live Azure Table Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Azure Table data.
-
Publish Freshteam-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Freshteam data.
-
Manage Webex Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Webex.
-
Automated Continuous ZendeskSell Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZendeskSell replication to SingleStore.
-
Analyze Live XML Data in SAS Viya
Use CData Connect AI to connect to XML data from SAS Viya and deploy self-service analytics using live XML data.
-
Analyze SendGrid Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SendGrid data with the CData JDBC Driver for SendGrid.
-
Automated Continuous HCL Domino Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable HCL Domino replication to Azure SQL Database.
-
Connect to Browserless Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Browserless as an External Source in Dremio.
-
Use the CData Software ODBC Driver for Authorize.Net in MicroStrategy Web
Connect to Authorize.Net data in MicroStrategy Web using the CData Software ODBC Driver for Authorize.Net.
-
Back Up Oracle Sales data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle Sales. In this article, we will employ an SSIS workflow to populate a database with Oracle Sales data data.
-
LINQ to Azure Data Catalog 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 Data Catalog Data Provider.
-
Replicate Google Contacts Data to Multiple Databases via the CData Sync CLI
Replicate Google Contacts data to disparate databases with a single configuration.
-
Perform Batch Operations with Sugar CRM Data in Apache NiFi
Connect to Sugar CRM data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build Asana-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Asana Data and create custom apps in Bubble.
-
Automated Continuous ZohoInvoice Replication to MongoDB
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to MongoDB.
-
Integrate with CampaignMonitor Data in JReport Designer
Create charts and reports based on CampaignMonitor data in JReport Designer.
-
Build Apps with Live Office 365 Data Using the Low-Code Development Platform of Mendix
Connect Office 365 data with Mendix to build apps using the CData JDBC Driver for Office 365.
-
How to create Notion federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Notion data in MySQL .
-
Visualize LinkedIn Data in Tableau
The CData ODBC driver for LinkedIn enables you integrate LinkedIn data into Tableau dashboards.
-
How to Connect Flowise AI Agents to Live GraphQL 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 GraphQL data without replication.
-
Integrate Live Jumpseller Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Jumpseller data and integrate live Jumpseller data into apps built in Microsoft Power Apps.
-
Build Apps with Live Twitter Ads data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Twitter Ads data into the Adalo platform and build custom mobile and web applications with real-time Twitter Ads data.
-
Create Amazon Marketplace-Connected Business Apps in AppSheet
Connect to Amazon Marketplace Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Amazon Marketplace data.
-
Load ZeroBounce Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZeroBounce data to a database.
-
Access Live PostgreSQL Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live PostgreSQL data from your Excel spreadsheets.
-
Connect to iContact Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with iContact Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Charts with SageHR Data in Clear Analytics
Create dynamic charts and perform analytics based on SageHR data in Clear Analytics.
-
Getting Started with the CData Python Connector for ZohoExpense
Learn to install and license the CData Python Connector and configure a connection to live ZohoExpense data.
-
Connect to Epicor Kinetic Data in Claris FileMaker Pro
Use the CData ODBC Driver for Epicor Kinetic in FileMaker Pro to connect to Epicor Kinetic and work with Epicor Kinetic data in your FileMaker applications.
-
Automate Dynamics 365 Data Replication to Couchbase
Use CData Sync to Customize and automate Dynamics 365 data replication to Couchbase.
-
Build AI/ML Models with Live AgileCRM Data using Dataiku
Connect AgileCRM Data with Dataiku using the CData API Driver for JDBC.
-
Use the CData Software ODBC Driver for Sendwithus in SAS for Real-Time Reporting and Analytics
Connect to real-time Sendwithus data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sendwithus.
-
How to Work with Close Data in AWS Glue Jobs Using JDBC
Connect to Close from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query Coda Data as a SQL Server Database in Node.js
Execute SQL Server queries against Coda data from Node.js.
-
Getting Started with the CData Python Connector for Adobe Analytics
Learn to install and license the CData Python Connector and configure a connection to live Adobe Analytics data.
-
Automated Continuous Hubstaff Replication to MySQL
Use CData Sync for automated, continuous, customizable Hubstaff replication to MySQL.
-
Use Manus AI to Talk to Your Mode Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Mode data.
-
Integrate Real-Time Access to Azure Data Catalog in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure Data Catalog data in real time.
-
Integrate Google Directory Data in the Pentaho Report Designer
Publish reports based on Google Directory data in the Pentaho BI tool.
-
Visualize Freshteam Data in TIBCO Spotfire through ADO.NET
Integrate Freshteam data into dashboards in TIBCO Spotfire.
-
How to work with Jira Assets Data in Apache Spark using SQL
Access and process Jira Assets Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Snowflake Data from Crystal Reports
Use CData Connect AI to connect to and report on live Snowflake data from Crystal Reports.
-
Build Data Flows from Pingdom to SQL Server using SSIS
Easily back up Pingdom data to SQL Server using the SSIS components for Pingdom.
-
How to connect to iContact Data from Spring Boot
Connect to iContact in a Spring Boot Application using the CData API Driver for JDBC
-
How to connect to Snowflake Data in DBVisualizer
Integrate Snowflake data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to LDAP Objects from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LDAP objects using standard SQL.
-
Access Live Snapchat Ads Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Snapchat Ads data into the statistical analysis tools available in SAS JMP. This article shows how to use Snapchat Ads data in the Graph Builder and Query Builder.
-
Integrating GitHub Copilot with Short.io 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.
-
Build Charts with Sentry Data in Clear Analytics
Create dynamic charts and perform analytics based on Sentry data in Clear Analytics.
-
Bridge PingOne Connectivity with Apache NiFi
Access and process PingOne data in Apache NiFi using the CData JDBC Driver.
-
Perform Batch Operations with Oracle Eloqua Data in Apache NiFi
Connect to Oracle Eloqua data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Easily Integrate BambooHR Data in Lazarus Pascal IDE
Learn how to easily integrate live BambooHR data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData ODBC Driver for Authorize.Net in Microsoft Power Query
You can use the CData Authorize.Net ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Authorize.Net data into Microsoft Power Query.
-
Access Google Calendar Data from MySQL in Amazon QuickSight
Connect to Google Calendar and build visualizations of Google Calendar data using a MySQL Connection in Amazon QuickSight.
-
Visualize Guru Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Guru data.
-
How to connect to Sentry Data from IntelliJ
Integrate connectivity to Sentry data with wizards in IntelliJ.
-
Visualize ClickTime Data in Sisense
Create an ElastiCube in Sisense app with access to ClickTime data.
-
Moving Data from Splunk to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Splunk data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous SendPulse Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SendPulse replication to Google Cloud SQL.
-
Connect to Real-Time Attio Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Attio data in Power Apps.
-
Automated Yelp Data Replication to Teradata
Use CData Sync to Customize and automate Yelp data replication to Teradata.
-
Visualize ZeroBounce Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZeroBounce data.
-
Enable the Templated JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Templated data.
-
Create Reports with Oracle Eloqua Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Eloqua data.
-
Create Dashboards and Visualize Live MariaDB Data in Geckoboard
Use CData Connect AI to connect to live MariaDB data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Discord-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Discord Data and create custom apps in Mendix.
-
Operational Reporting on Dynamics CRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Dynamics CRM data.
-
Access Live Freshdesk Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Freshdesk data from your Google Sheets.
-
Import Real-Time Email Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Email data in ColdFusion.
-
How to Connect to Live Testmonitor Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Testmonitor data for you.
-
Automated Continuous Oracle Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Oracle replication to Google Cloud SQL.
-
Build a PostgreSQL Interface for SageHR Data using the CData JDBC Driver
Use the Remoting features of the SageHR JDBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze Samanage Data in Alteryx Designer (Connect AI)
Build workflows to access live Samanage data for self-service data analytics.
-
Use the CData Software ODBC Driver for Salesforce Marketing in MicroStrategy Desktop
Connect to Salesforce Marketing data in MicroStrategy Desktop using the CData Software ODBC Driver for Salesforce Marketing.
-
Connect to Samanage Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Samanage data.
-
Connect to Greenhouse from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Greenhouse data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Publish JotForm-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live JotForm data.
-
Connect to Toggl Data from AWS Glue
Use CData Connect AI to gain access to live Toggl data from your AWS Glue jobs.
-
Analyze MYOB AccountRight Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of MYOB AccountRight data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Live Google Drive Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Google Drive data from within the IDE.
-
Migrating data from Wave Financial to Snowflake using CData SSIS Components.
Easily push Wave Financial data to Snowflake using the CData SSIS Tasks for Wave Financial and Snowflake.
-
Access Live Gmail Data in AWS Lambda
Connect to live Gmail data in AWS Lambda using the CData JDBC Driver.