CData Software - Knowledge Base
Recent Articles
-
DataBind Controls to ADP Data in C++Builder
DataBind to ADP data in C++Builder with standard components and controls.
-
Query Snapchat Ads Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Snapchat Ads data from Node.js.
-
Automated Continuous SendPulse Replication to SQL Server
Use CData Sync for automated, continuous, customizable SendPulse replication to SQL Server.
-
Integrate Blackbaud FE NXT with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Blackbaud FE NXT with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Blackbaud FE NXT data.
-
Getting Started with the CData ADO.NET Provider for MySQL
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for MySQL.
-
Connect to and Query PolarTeamPro Data in QlikView over ODBC
Create data visualizations with PolarTeamPro data in QlikView.
-
How to connect to HelloSign Data from Spring Boot
Connect to HelloSign in a Spring Boot Application using the CData API Driver for JDBC
-
Create Dynamic Snapchat Ads Grids Using the Infragistics XamDataGrid
Learn how you can connect Snapchat Ads to Infragistics XamDataGrid to build dynamic grids.
-
Configure the CData JDBC Driver for Omnisend in a Connection Pool in Tomcat
Connect to Omnisend data from a connection pool in Tomcat.
-
Connect to Notion from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Notion data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Active Directory Data in Ruby
Connect to Active Directory data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Deel Data in Sisense
Create an ElastiCube in Sisense app with access to Deel data.
-
Connecting Mastra with CSV Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time CSV data, no replication required.
-
Build Agents in Relevance AI with Access to Live SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Hybris C4C data within intelligent agent workflows.
-
Integrate DocuSign with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate DocuSign with External Services.
-
Connect to Google Search Results through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Search Results using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Google's Antigravity Agent with Live Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Azure Table data using the Model Context Protocol.
-
How to connect to eBay Data in DBVisualizer
Integrate eBay data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Pipelines with Live Grafana Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Grafana from Google Cloud Data Fusion, enabling the integration of live Grafana data into the building and management of effective data pipelines.
-
Connect to Foursquare Data in CloverDX (formerly CloverETL)
Transfer Foursquare data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Sendwithus Replication to Oracle
Use CData Sync for automated, continuous, customizable Sendwithus replication to Oracle.
-
Connect to Oracle SCM Data in Jaspersoft Studio
Execute SQL to remote Oracle SCM data in Jaspersoft Studio.
-
How to Seamlessly Import ZendeskSell Data into IBM SPSS Modeler
Integrate ZendeskSell data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create a Data Access Object for Snowflake Data using JDBI
A brief overview of creating a SQL Object API for Snowflake data in JDBI.
-
Migrating data from Airtable to Snowflake using CData SSIS Components.
Easily push Airtable data to Snowflake using the CData SSIS Tasks for Airtable and Snowflake.
-
Integrating Codex with Attio 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.
-
Create Datasets from iContact in Domo Workbench and Build Visualizations of iContact Data in Domo
Use the CData Software ODBC Driver for iContact to create datasets from iContact data in Domo Workbench and then build visualizations in the Domo service.
-
A PostgreSQL Interface for Printify Data (MySQL Remoting via JDBC)
Use the Remoting features of the Printify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Samanage Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Samanage data and visualize live Samanage data in Infragistics Reveal.
-
How to Easily Query Salesloft Data in OpenOffice Base
Connect to Salesloft data in OpenOffice Base using the CData ODBC Driver for Salesloft and generate reports with live data insights.
-
Build Mailjet Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Mailjet data and build visualizations in Tableau.
-
Connect to Dynamics 365 Data from HeidiSQL
Use CData Connect AI to connect to and query live Dynamics 365 data from HeidiSQL.
-
Build Semantic Layer Views for Power BI XMLA Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Power BI XMLA data.
-
Analyze Acumatica Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Acumatica data and visualize live Acumatica data in Infragistics Reveal.
-
Process & Analyze Front Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Front Data.
-
Visualize VWO Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to VWO data.
-
Build Semantic Layer Views for MarkLogic Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for MarkLogic data.
-
Stream Authorize.Net Data into Apache Kafka Topics
Access and stream Authorize.Net data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SFTP
Provide connectivity to SFTP data through an SAP BusinessObjects universe.
-
How to connect Amazon QuickSight to XML Data
Create a connection to XML data in CData Connect AI and insert XML data into Amazon QuickSight SPICE to build interactive dashboards.
-
Import Basecamp Data Using Azure Data Factory
Use CData Connect AI to connect to Basecamp Data from Azure Data Factory and import live Basecamp data.
-
Import Real-Time Mailgun Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Mailgun data in ColdFusion.
-
A PostgreSQL Interface for Autopilot Data using the CData ODBC Driver
Use the SQL Gateway and Autopilot ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Seamlessly Import SharePoint Excel Services Data into IBM SPSS Modeler
Integrate SharePoint Excel Services data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Work with NASA Data in FoxPro
Load NASA data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Edit and Search External Bitbucket Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Bitbucket data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Bitbucket Data objects that you can access from apps and the dashboard.
-
Enable the Perplexity JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Perplexity data.
-
Connect to ZohoSubscriptions Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZohoSubscriptions as an External Source in Dremio.
-
Connect to SendPulse Data from HeidiSQL
Use CData Connect AI to connect to and query live SendPulse data from HeidiSQL.
-
Access Live Supabase Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Supabase data from your Google Sheets.
-
Use the CData Software ODBC Driver for Optimizely in MicroStrategy Desktop
Connect to Optimizely data in MicroStrategy Desktop using the CData Software ODBC Driver for Optimizely.
-
Query Zendesk Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zendesk data from Node.js.
-
Building Dynamic Web Pages with Reckon Accounts Hosted Data Using AngularJS
Create single-page applications with live connectivity to Reckon Accounts Hosted using the CData API Server.
-
Use the CData Software ODBC Driver for BigQuery in MicroStrategy Web
Connect to BigQuery data in MicroStrategy Web using the CData Software ODBC Driver for BigQuery.
-
Establish a Live Connection with Google Translate Data using Tableau Bridge
The CData ODBC Driver for Google Translate enables you to integrate live Google Translate data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use JayDeBeApi to access PostgreSQL Data in Python
Use standard Python scripting and the development environment of your choice to access live PostgreSQL data.
-
Analyze Onfleet Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Onfleet data with the CData JDBC Driver for Onfleet.
-
Import Real-Time Cloudant Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Cloudant data in ColdFusion.
-
Connect to Vault CRM Data in Jaspersoft Studio
Execute SQL to remote Vault CRM data in Jaspersoft Studio.
-
Connect to SAP Ariba Procurement Data in Ruby
Connect to SAP Ariba Procurement data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Google Spanner Data in Aqua Data Studio
Access Google Spanner data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Viewing LeadDesk Data in RAD Studio Data Explorer
How to view LeadDesk data in RAD Studio Data Explorer using the CData ODBC Driver for LeadDesk.
-
How to Query Freshservice Data in MySQL Workbench
Execute MySQL queries against live Freshservice data from MySQL Workbench.
-
Access Live SAP Data in TIBCO Data Virtualization
Use the SAP Tibco DV Adapter to create a SAP data data source in TIBCO Data Virtualization Studio and gain access to live SAP data from your TDV Server.
-
Automated Continuous Strava Replication to MongoDB
Use CData Sync for automated, continuous, customizable Strava replication to MongoDB.
-
Integrating LangChain with HDFS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on HDFS data within automated workflows.
-
Create Oracle Sales-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Oracle Sales Data from Klipfolio and build custom visualizations using live Oracle Sales data.
-
Integrating Claude Code CLI with Foursquare 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 Facebook from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Facebook data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData Connect AI Python SDK for Blackbaud FE NXT
Install the CData Connect AI Python SDK to read and write live Blackbaud FE NXT data with standard DB-API 2.0 Python code.
-
Use the CData Software JDBC Driver for Browserless in MicroStrategy
Connect to Browserless data in MicroStrategy Developer using the CData Software JDBC Driver for Browserless.
-
Use Dash to Build to Web Apps on Pinecone Data
Create Python applications that use pandas and Dash to build Pinecone-connected web apps.
-
Integrate OpenCode with Live Microsoft OneDrive Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Microsoft OneDrive data from within your AI coding agent.
-
Connect to PayPal Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for PayPal data in Airbyte.
-
Enable the Mailgun JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Mailgun data.
-
Automated Continuous Amazon Athena Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Azure SQL Database.
-
Build Visualizations of Workday Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Workday data in Birst.
-
Build Charts with Cassandra Data in Clear Analytics
Create dynamic charts and perform analytics based on Cassandra data in Clear Analytics.
-
Build a PostgreSQL Interface for Sage 300 Data using the CData JDBC Driver
Use the Remoting features of the Sage 300 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Tableau Connector for MailerLite
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Connect to & Open MailerLite Data in Microsoft Excel
This article uses the CData ODBC driver for MailerLite to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live SparkPost Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SparkPost data from your Excel spreadsheets.
-
Query Mailgun Data in ColdFusion
Write standard ColdFusion data access code to connect to Mailgun data.
-
Connect to Real-Time Procore Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Procore data in Power Apps.
-
Automate Acumatica Data Replication to SAP HANA
Use CData Sync to customize and automate Acumatica data replication to SAP HANA.
-
How to Visualize Certinia Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Certinia data in Python.
-
Import Mailjet Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Mailjet Data and provide access to live Mailjet data for custom reports in the Power BI Service.
-
Automated Continuous ServiceDesk Plus Replication to MongoDB
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to MongoDB.
-
Connect Flowlu Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Flowlu data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect to Microsoft Planner Data with Squirrel SQL client
Connect to Microsoft Planner data and execute queries in the Squirrel SQL Client.
-
Access Helpscout Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Helpscout data from HeidiSQL.
-
Build AI/ML Models with Live Yelp Data using Dataiku
Connect Yelp Data with Dataiku using the CData API Driver for JDBC.
-
MySQL Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to MySQL data through CData Connect AI using different applications and tools.
-
Query CSV Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CSV data from Node.js.
-
How to connect to Paymo Data with Squirrel SQL client
Connect to Paymo data and execute queries in the Squirrel SQL Client.
-
Model, Search, and Visualize Live SendGrid Data in ThoughtSpot
Use CData Connect AI to connect to live SendGrid data for modeling, searching, and visualizing.
-
Integrate Real-Time Access to Instagram in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Instagram data in real time.
-
Query Phoenix Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Phoenix entities in PHP by modeling them as objects.
-
Connect to Qualaroo Data in DBeaver
Use the CData ODBC Driver to connect to Qualaroo data in DBeaver.
-
Automated Continuous ClickUp Replication to Oracle
Use CData Sync for automated, continuous, customizable ClickUp replication to Oracle.