CData Software - Knowledge Base
Recent Articles
-
Automated Continuous RSS Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable RSS replication to Apache Kafka.
-
Automated Continuous ZohoDesk Replication to SQL Server
Use CData Sync for automated, continuous, customizable ZohoDesk replication to SQL Server.
-
Use JayDeBeApi to access SAP HANA Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP HANA data.
-
Build Semantic Layer Views for FTP Data in APOS Live Data Gateway
Use the CData Connector for FTP in APOS Live Data Gateway to build Semantic Layer Views for FTP data.
-
Access Live CSV Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live CSV data from your Excel spreadsheets.
-
Integrate Open WebUI with Live Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Box data from within the chat interface.
-
How to Seamlessly Import Gmail Data into IBM SPSS Modeler
Integrate Gmail data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to load Gong data into Elasticsearch via Logstash
Introducing a simple method to load Gong data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Google's Antigravity Agent with Live Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Certinia data using the Model Context Protocol.
-
Use the CData Software JDBC Driver for SAP Fieldglass in MicroStrategy
Connect to SAP Fieldglass data in MicroStrategy Developer using the CData Software JDBC Driver for SAP Fieldglass.
-
Integrate with Shippo Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Shippo data in SnapLogic.
-
Use the CData Software ODBC Driver for Sybase in MicroStrategy Desktop
Connect to Sybase data in MicroStrategy Desktop using the CData Software ODBC Driver for Sybase.
-
Build an OLAP Cube in SSAS from Billsby Data
Establish a connection to Billsby data data from SQL Server Analysis Services, and use the Billsby Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect to Live Odoo 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 Odoo data without replication.
-
Moving Data from Templated to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Templated data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to SAP Business One Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP Business One and the SQL Gateway to access SAP Business One data from Google Apps Script.
-
Use Grok to Talk to Your SFTP 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 SFTP data for you.
-
Build PhantomBuster-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PhantomBuster data.
-
Integrate Theia IDE with Live Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Azure DevOps data from within the development environment.
-
DataBind Controls to Sybase Data in C++Builder
DataBind to Sybase data in C++Builder with standard components and controls.
-
Integrate Live Pinterest Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Pinterest data to Blue Prism using the CData ODBC Driver for Pinterest to create automated workflows for repetitive business tasks.
-
Integrating Antigravity CLI with Invoiced data via CData CLI
Connect Invoiced data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Recurly Data in HULFT Integrate
Connect to Recurly as a JDBC data source in HULFT Integrate
-
Build Dashboards with SAS Data Sets Data in DBxtra
Create dynamic dashboards and perform analytics based on SAS Data Sets data in DBxtra.
-
Automated Continuous Splunk Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Splunk replication to delimited files (CSV/TSV).
-
Connect to Oracle SCM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle SCM to connect to Oracle SCM data from Web applications running on WebLogic.
-
Use the CData Software JDBC Driver for Amplitude in MicroStrategy
Connect to Amplitude data in MicroStrategy Developer using the CData Software JDBC Driver for Amplitude.
-
Connect to Raisers Edge NXT Data in Ruby
Connect to Raisers Edge NXT data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Live Avalara AvaTax Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Avalara AvaTax from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Avalara AvaTax data.
-
Use CData Connect AI to Access BigQuery Data in Microsoft Power Pivot
Use CData Connect AI to connect to live BigQuery data in the Power Pivot business intelligence tool.
-
How to Connect to Facebook Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Facebook data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Highrise Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Highrise replication to Azure SQL Database.
-
Automated Continuous CampaignMonitor Replication to MongoDB
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to MongoDB.
-
Operational Reporting on AdRoll Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote AdRoll data.
-
Creating Trello-Connected Applications in Unqork
You can use CData Connect AI to feed Trello data to Unqork and build custom business apps.
-
Connect to Perplexity Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Perplexity to connect to Perplexity data and execute queries in PowerBuilder.
-
How to Connect to Live Workday Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Workday data securely in real time.
-
Getting Started with the CData Power BI Connector for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Dynamics NAV.
-
Analyze Couchbase Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Couchbase data in Microsoft R Open.
-
Enable the Facebook JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Facebook data.
-
Build Dynamics NAV-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Dynamics NAV Data and create custom apps in Bubble.
-
Use the CData Software ODBC Driver for FTP in SAS for Real-Time Reporting and Analytics
Connect to real-time FTP data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for FTP.
-
Integrate with Testmonitor Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Testmonitor data to a JSON file on disk.
-
Analyze Excel Online Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Excel Online from Power Pivot. You will use the Table Import Wizard to load Excel Online data. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect the Power BI Service to Todoist: Complete Guide
Connect to the CData Software Power BI Connector for Todoist from PowerBI.com to provide real-time Todoist data across the organization.
-
Connect to Anaplan Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Anaplan data.
-
Connect and Query Live ZohoPeople Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ZohoPeople data into Databricks and enable direct, live querying and analysis without replication.
-
Work with ZohoDesk Data in FoxPro
Load ZohoDesk data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to update Airtable from Excel
This article explains how to transfer data from Excel to Airtable using the Excel Add-In for Airtable.
-
Connect and Query Live Jira Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Jira data into Databricks and enable direct, live querying and analysis without replication.
-
Integrating Claude Code CLI with ZohoSubscriptions 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.
-
Integrate SAP SuccessFactors Data into Power Automate Desktop using CData Connect
CData Connect for SAP SuccessFactors Data enables you to integrate SAP SuccessFactors data into workflows built using Microsoft Power Automate Desktop.
-
Excel Spreadsheet Automation on Azure Data Lake Storage Data with the QUERY Formula
Pull data from Azure Data Lake Storage, automate spreadsheets, and more with the QUERY formula.
-
Integrate Trae with Live ZohoInvoice Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ZohoInvoice data from within the AI-powered IDE.
-
Integrating Cursor with Email 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.
-
Replicate Multiple Typeform Accounts
Replicate multiple Typeform accounts to one or many databases.
-
Build a Singer.io Tap for Datadog With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Datadog data using the CData Python Connector.
-
Use the CData Software ODBC Driver for Mocean in MicroStrategy Desktop
Connect to Mocean data in MicroStrategy Desktop using the CData Software ODBC Driver for Mocean.
-
Extract, Transform, and Load Azure Synapse Data in Informatica PowerCenter
Create a simple Workflow for Azure Synapse data in Informatica PowerCenter.
-
Creating PolarTeamPro-Connected Applications in Unqork
You can use CData Connect AI to feed PolarTeamPro data to Unqork and build custom business apps.
-
Integrating GitHub Copilot with Azure Data Lake Storage 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.
-
How to Connect to Live ShipStation 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 ShipStation data without replication.
-
Natively Connect to Pushbullet Data in PHP
The CData ODBC driver for Pushbullet enables you to create PHP applications with connectivity to Pushbullet data. Leverage the native support for ODBC in PHP.
-
Create Reports from Salesforce Data 360 Data in Looker Studio
Use CData Connect AI to gain access to live Salesforce Data 360 data and create custom reports in Looker Studio.
-
Build Charts with Keap Data in Clear Analytics
Create dynamic charts and perform analytics based on Keap data in Clear Analytics.
-
Build Apps with Live Kintone data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Kintone data into the Adalo platform and build custom mobile and web applications with real-time Kintone data.
-
Access Live Zuora Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zuora data from your Excel spreadsheets.
-
Query, Visualize, and Share live DB2 Data in Redash
Use CData Connect AI to connect to live DB2 data in Redash for querying, visualizing, and sharing.
-
LINQ to CSV 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 CSV Data Provider.
-
Design BIRT Reports on Mailjet Data
Provide current Mailjet data to your embedded analytics.
-
Query Zoho Projects Data in DataGrip
Create a Data Source for Zoho Projects in DataGrip and use SQL to query live Zoho Projects data.
-
Automated Continuous Zoho Projects Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zoho Projects replication to AlloyDB.
-
Working with Blackbaud FE NXT Data in LINQPad
Execute LINQ queries to Blackbaud FE NXT data in LINQPad.
-
Use the CData Software ODBC Driver for Billsby in SAS for Real-Time Reporting and Analytics
Connect to real-time Billsby data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Billsby.
-
Connect to ZohoMarketingHub Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZohoMarketingHub data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create SSAS Tabular Models from GetResponse Data
How to build a SQL Server Analysis Service Tabular Model from GetResponse data using CData drivers.
-
Connect SparkPost to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SparkPost with IBM WebSphere for seamless data integration and connectivity.
-
Connect and Query Live QuickBooks Online Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live QuickBooks Online data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Slack Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Slack as an External Source in Dremio.
-
Replicate Multiple Workday Accounts via the CData Sync CLI
Replicate multiple Workday accounts to one or many databases.
-
Use the CData Software JDBC Driver for Webex in MicroStrategy Web
Connect to Webex data in MicroStrategy Web using the CData Software JDBC Driver for Webex.
-
Use the CData SSIS Components to Insert New or Update Existing Google Calendar Records from SQL Server
Easily push SQL Server data to Google Calendar using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Calendar or update existing records with data from a SQL Server database.
-
How to connect to WooCommerce Data with Squirrel SQL client
Connect to WooCommerce data and execute queries in the Squirrel SQL Client.
-
Integrate Goose with Live MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live MailChimp data from within the local AI agent.
-
Connect to Google Translate Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Translate data in the Denodo Virtual DataPort Administrator.
-
Integrating Antigravity CLI with Amazon S3 data via CData CLI
Connect Amazon S3 data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Create Power BI Visual Reports with Real-Time ConvertKit Data
Use CData Power BI Connectors to visualize ConvertKit data in Power BI.
-
Migrating data from Shopify to Databricks using CData SSIS Components.
Easily push Shopify data to Databricks using the CData SSIS Tasks for Shopify and Databricks.
-
Create Datasets from Google Tasks in Domo Workbench and Build Visualizations of Google Tasks Data in Domo
Use the CData Software ODBC Driver for Google Tasks to create datasets from Google Tasks data in Domo Workbench and then build visualizations in the Domo service.
-
Add Placid Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Placid with the Informatica Enterprise Data Catalog to classify and organize data.
-
Visualize ClickTime Data in Tableau
The CData ODBC driver for ClickTime enables you integrate ClickTime data into Tableau dashboards.
-
Automated Continuous Pinterest Replication to SingleStore
Use CData Sync for automated, continuous, customizable Pinterest replication to SingleStore.
-
Migrating data from Jira Assets to Snowflake using CData SSIS Components.
Easily push Jira Assets data to Snowflake using the CData SSIS Tasks for Jira Assets and Snowflake.
-
Connect to Twitter Ads Data in RazorSQL
Connect to Twitter Ads from wizards and query Twitter Ads data from the GUI in the RazorSQL database management tool.
-
Deploy the ADO.NET Provider for Todoist on an SSRS Report Server
Connect to Todoist 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.
-
How to Visualize Google Sheets 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 Google Sheets data in Python.
-
Query Live Perplexity 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 Perplexity data through a conversational interface.
-
How to publish and share Elorus Data dashboards with Tableau Server
The CData ODBC driver for Elorus enables you integrate Elorus data into Tableau dashboards.
-
Use Microsoft Copilot Studio to talk to your SendGrid 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 SendGrid data for you.
-
Connect to Eventbrite Data from a Connection Pool in Jetty
The Eventbrite JDBC Driver supports connection pooling: This article shows how to connect faster to Eventbrite data from Web apps in Jetty.