CData Software - Knowledge Base
Recent Articles
-
Replicate Hive Data to Multiple Databases via the CData Sync CLI
Replicate Hive data to disparate databases with a single configuration.
-
Integrating Antigravity CLI with Omnisend data via CData CLI
Connect Omnisend data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Seamlessly Bring Salesforce Data 360 Data into Retool Using CData Connect AI
Integrate Salesforce Data 360 data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Zoom Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoom replication to Azure SQL Database.
-
Automated Continuous Supabase Replication to Oracle
Use CData Sync for automated, continuous, customizable Supabase replication to Oracle.
-
Connect to Toggl Data from Crystal Reports
Use CData Connect AI to connect to and report on live Toggl data from Crystal Reports.
-
Connect to WooCommerce from a Connection Pool in WebLogic
Use the CData JDBC Driver for WooCommerce to connect to WooCommerce data from Web applications running on WebLogic.
-
Use Dash to Build to Web Apps on Amazon DynamoDB Data
Create Python applications that use pandas and Dash to build Amazon DynamoDB-connected web apps.
-
Integrating Claude Code CLI with iContact 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.
-
Query Recurly Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Recurly data from Node.js.
-
How to Connect to Live Sugar CRM 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 Sugar CRM data for you.
-
How to connect Amazon QuickSight to Zoom Data
Create a connection to Zoom data in CData Connect AI and insert Zoom data into Amazon QuickSight SPICE to build interactive dashboards.
-
Publish Reports with Rootly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Rootly data.
-
Automated Continuous Copper Replication to SQLite
Use CData Sync for automated, continuous, customizable Copper replication to SQLite.
-
Integrating Gumloop with SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAS xpt data within automated workflows.
-
DataBind Phoenix Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Phoenix with the DevExpress Windows Forms and Web controls to provide Phoenix data to a chart.
-
Connect Salesforce Marketing to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Salesforce Marketing data using the CData Python MCP Server.
-
Integrate Devin with Live Twilio Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Twilio data.
-
Connect to AlloyDB Data in RazorSQL
Connect to AlloyDB from wizards and query AlloyDB data from the GUI in the RazorSQL database management tool.
-
Integrating Dataiku with PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live PostgreSQL data.
-
NetSuite SuiteAnalytics Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to NetSuite SuiteAnalytics data through CData Connect AI using different applications and tools.
-
Use CData Connect AI to Access SparkPost Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SparkPost data in the Power Pivot business intelligence tool.
-
Visualize SendPulse Data in Tableau
The CData ODBC driver for SendPulse enables you integrate SendPulse data into Tableau dashboards.
-
Getting Started with the CData JDBC Driver for Intercom
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Intercom.
-
Back Up Browserless 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 Browserless data data.
-
Automated Continuous Workable Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Workable replication to IBM DB2.
-
Consume Okta OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Okta feeds that reflect any changes in SAP Lumira.
-
How to update Zoho Projects from Excel
This article explains how to transfer data from Excel to Zoho Projects using the Excel Add-In for Zoho Projects.
-
Use JayDeBeApi to access Excel Online Data in Python
Use standard Python scripting and the development environment of your choice to access live Excel Online data.
-
How to Connect to Live Highrise 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 Highrise data for you.
-
Publish Reports with Recurly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Recurly data.
-
A Feature Comparison of Drivers for NoSQL
An article comparing the available features and functionality of CData Software Drivers for MongoDB.
-
Getting Started with the CData SSIS Components for Microsoft Dataverse
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Microsoft Dataverse.
-
Connect to Sybase IQ Data from Crystal Reports
Use CData Connect AI to connect to and report on live Sybase IQ data from Crystal Reports.
-
Create Power BI Reports on Real-Time Apify Data
Use the CData ODBC Driver for Apify to visualize Apify data in Power BI Desktop.
-
LINQ to Wave Financial 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 Wave Financial Data Provider.
-
Integrate Cursor with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Pipedrive data from within the editor.
-
Query, Visualize, and Share live Apollo Data in Redash
Use CData Connect AI to connect to live Apollo data in Redash for querying, visualizing, and sharing.
-
Build Cloudflare-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Cloudflare Data and create custom apps in Bubble.
-
How to update XML from Excel
This article explains how to transfer data from Excel to XML using the Excel Add-In for XML.
-
Connect to Pushbullet in SpagoBI
Create reports featuring live Pushbullet data in SpagoBI Studio. Host Pushbullet reports on SpagoBI Server.
-
Visualize Live Google Cloud Storage Data in the Power BI Service
Use CData Connect AI to connect to live Google Cloud Storage data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize MessageBird Data in TIBCO Spotfire through ADO.NET
Integrate MessageBird data into dashboards in TIBCO Spotfire.
-
Build an OLAP Cube in SSAS from Hacker News Data
Establish a connection to Hacker News data data from SQL Server Analysis Services, and use the Hacker News Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use JayDeBeApi to access Dynamics 365 Business Central Data in Python
Use standard Python scripting and the development environment of your choice to access live Dynamics 365 Business Central data.
-
How to Query Live Oracle Sales Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle Sales data data in natural language using Python.
-
Build Agents in Relevance AI with Access to Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft OneDrive data within intelligent agent workflows.
-
Work with Live Snapchat Ads Data in Power Query
Use CData Connect AI to connect to Snapchat Ads data and work with live Snapchat Ads data in Microsoft Power Query.
-
Use Grok to Talk to Your Asana 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 Asana data for you.
-
Connect to Amplitude Data in RapidMiner
Integrate Amplitude data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Data Visualizations in Cognos BI with Redshift Data
Access Redshift data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Prepare, Blend, and Analyze Raisers Edge NXT Data in Alteryx Designer (ODBC)
Build workflows to access live Raisers Edge NXT data for self-service data analytics.
-
DataBind Charts to Google Forms Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Forms 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.
-
Create Apps from Klipfolio Data in Qlik Sense Cloud
Use CData Connect AI to connect to Klipfolio Data and build apps from live Klipfolio data in Qlik Sense Cloud.
-
Automated Continuous SendGrid Replication to Vertica
Use CData Sync for automated, continuous, customizable SendGrid replication to Vertica.
-
Connect to CockroachDB in SpagoBI
Create reports featuring live CockroachDB data in SpagoBI Studio. Host CockroachDB reports on SpagoBI Server.
-
Integrating Claude Code with DocuSign Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on DocuSign data within assisted coding and automated development workflows.
-
Connect to LinkedIn Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live LinkedIn data from Filemaker Pro on Mac.
-
Connect to Pingdom Data in CloverDX (formerly CloverETL)
Transfer Pingdom data using the visual workflow in the CloverDX data integration tool.
-
Access Live Sage Intacct 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 Sage Intacct data through MCP integration.
-
How to publish and share Webex Data dashboards with Tableau Server
The CData ODBC driver for Webex enables you integrate Webex data into Tableau dashboards.
-
Know Your LLMs: Google Gemini
Learn how Google Gemini models support enterprise AI workloads, including multimodality, function calling, security, and integration with CData Connect AI via MCP.
-
DataBind Controls to CouchDB Data in Delphi
DataBind to CouchDB data in Delphi with standard data access components and controls.
-
Extract, Transform, and Load Invoiced Data in Informatica PowerCenter
Create a simple Workflow for Invoiced data in Informatica PowerCenter.
-
Connect to ZohoSubscriptions Data in JRuby
Create a simple JRuby app with access to live ZohoSubscriptions data.
-
Build CSV-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live CSV data.
-
Automated Continuous CircleCI Replication to Databricks
Use CData Sync for automated, continuous, customizable CircleCI replication to Databricks.
-
Manage Monday.com Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Monday.com.
-
Use Dash to Build to Web Apps on ServiceNow Data
Create Python applications that use pandas and Dash to build ServiceNow-connected web apps.
-
Getting Started with the CData Power BI Connector for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP HANA XS Advanced.
-
Automated Continuous Instantly Replication to SQLite
Use CData Sync for automated, continuous, customizable Instantly replication to SQLite.
-
Connecting Pipedream with Databricks Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Databricks data in real time.
-
Connect to Paylocity Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Paylocity and the SQL Gateway to access Paylocity data from Google Apps Script.
-
Access PolarTeamPro Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PolarTeamPro data from HeidiSQL.
-
Model, Search, and Visualize Live Omnisend Data in ThoughtSpot
Use CData Connect AI to connect to live Omnisend data for modeling, searching, and visualizing.
-
Replicate Insightly Data to Multiple Databases
Replicate Insightly data to disparate databases with a point-and-click configuration.
-
Connect to Optimizely Data from HeidiSQL
Use CData Connect AI to connect to and query live Optimizely data from HeidiSQL.
-
Build Automated Workflows with Live WooCommerce Data in Workato
Use CData Connect AI to connect to live WooCommerce data and build automated workflows in Workato.
-
How to connect SharePoint with Zoho CRM Data through external lists
Provide Zoho CRM data to SharePoint users as an external list.
-
Prepare, Blend, and Analyze ZohoPeople Data in Alteryx Designer (Connect AI)
Build workflows to access live ZohoPeople data for self-service data analytics.
-
How to Build an ETL App for ServiceDesk Plus Data in Python with CData
Create ETL applications and real-time data pipelines for ServiceDesk Plus data in Python with petl.
-
Connect to Grafana Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Grafana and work with Grafana data in your FileMaker application.
-
ETL SAP in Oracle Data Integrator
This article shows how to transfer SAP data into a data warehouse using Oracle Data Integrator.
-
Seamlessly Bring RSS Feeds into Retool Using CData Connect AI
Integrate RSS data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Kiro with SAP SuccessFactors LMS 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 create Zoho Recruit federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho Recruit data in MySQL .
-
Automated Continuous Salesloft Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Salesloft replication to Amazon Redshift.
-
Build Smartsheet-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Smartsheet Data and create custom apps in Mendix.
-
Build Apps with Live Ontraport Data Using the Low-Code Development Platform of Mendix
Connect Ontraport data with Mendix to build apps using the CData API Driver for JDBC.
-
Manage SurveyMonkey Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SurveyMonkey.
-
Connect to GraphQL Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for GraphQL to connect to GraphQL data and execute queries in PowerBuilder.
-
Connect to Gmail Data from a Connection Pool in JBoss
Integrate Gmail data into Java servlets: Use the Management Console in JBoss to install the Gmail JDBC Driver.
-
Automated Continuous Recurly Replication to MongoDB
Use CData Sync for automated, continuous, customizable Recurly replication to MongoDB.
-
Feed Ontraport Data into FineReport
How to set Ontraport data as a JDBC data source in FineReport.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZarMoney
Provide connectivity to ZarMoney data through an SAP BusinessObjects universe.
-
Build Automated Workflows with Live IBM Informix Data in Workato
Use CData Connect AI to connect to live IBM Informix data and build automated workflows in Workato.
-
Prepare, Blend, and Analyze Bugsnag Data in Alteryx Designer (ODBC)
Build workflows to access live Bugsnag data for self-service data analytics.
-
Connecting Pipedream with ActiveCampaign Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on ActiveCampaign data in real time.
-
Connect to VWO Data from AWS Glue
Use CData Connect AI to gain access to live VWO data from your AWS Glue jobs.
-
Connect to and Visualize Live Jodoo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Jodoo data.