CData Software - Knowledge Base
Recent Articles
-
Using the CData Software ODBC Driver for Azure Table in PyCharm
Connect to Azure Table as an ODBC data source in PyCharm using the CData Software ODBC Driver for Azure Table.
-
Create a Data Access Object for Couchbase Data using JDBI
A brief overview of creating a SQL Object API for Couchbase in JDBI.
-
Connect to Blackbaud FE NXT Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Blackbaud FE NXT using standard SQL.
-
Automated Continuous MessageBird Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MessageBird replication to AlloyDB.
-
How to work with Amazon DynamoDB Data in Apache Spark using SQL
Access and process Amazon DynamoDB Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating LangChain with MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MongoDB within automated workflows.
-
Getting Started with the CData Python Connector for ZohoInvoice
Learn to install and license the CData Python Connector
-
Visualize Nethunt Data in Sisense
Create an ElastiCube in Sisense app with access to Nethunt.
-
Integrating Gumloop with AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google AlloyDB within automated workflows.
-
Connect to ChartMogul Data in NetBeans
Connect to ChartMogul in NetBeans with the data source configuration wizard.
-
Provide OData Services of Freshservice Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Freshservice by developing a WCF Service Application.
-
Automated Continuous Teamwork Replication to Databricks
Use CData Sync for automated, continuous, customizable Teamwork replication to Databricks.
-
Load ADP Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ADP to a database.
-
Replicate Tally Data to Multiple Databases via the CData Sync CLI
Replicate Tally ERP to disparate databases with a single configuration.
-
Connecting Moonlit Workflow with QuickBooks Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your QuickBooks Online in real time.
-
Access Live Zoho CRM Data in AWS Lambda
Connect to live Zoho CRM in AWS Lambda using the CData JDBC Driver.
-
Bind Live Microsoft Planner Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Planner data
-
Build Shopify Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Shopify and build visualizations in Tableau.
-
How to Connect to & Open AdRoll Data in Microsoft Excel
This article uses the CData ODBC driver for AdRoll to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dashboards with Sugar CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Sugar CRM in DBxtra.
-
Use the CData ODBC Driver for Hacker News in Microsoft Power Query
You can use the CData Hacker News ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Hacker News into Microsoft Power Query.
-
Connect to Access in SpagoBI
Create reports featuring live Microsoft Access in SpagoBI Studio. Host Access reports on SpagoBI Server.
-
Integrating Cursor CLI with PingOne 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.
-
Use Biml to Build SSIS Tasks to Replicate CircleCI Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate CircleCI to SQL Server.
-
Prepare, Blend, and Analyze ADP Data in Alteryx Designer (Connect AI)
Build workflows to access live ADP for self-service data analytics.
-
Integrating Gmail Data in Talend Cloud Data Management Platform
Connect Gmail Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Gmail.
-
Office 365 Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Office 365 through CData Connect AI using different applications and tools.
-
Automated Continuous Toggl Replication to MongoDB
Use CData Sync for automated, continuous, customizable Toggl replication to MongoDB.
-
Visualize Live ConstantContact Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ConstantContact.
-
Integrating GitHub Copilot CLI with Qualaroo 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.
-
Working with PayPal Data in LINQPad
Execute LINQ queries to PayPal in LINQPad.
-
Natively Connect to ServiceNow Data in PHP
The CData ODBC driver for ServiceNow enables you to create PHP applications with connectivity to ServiceNow. Leverage the native support for ODBC in PHP.
-
How to Connect DBeaver to Klaviyo via a JDBC Driver
Manage Klaviyo with visual tools in DBeaver like the query browser.
-
Getting Started with the CData Excel Add-In for Sybase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sybase.
-
How to connect Amazon QuickSight to Google Search Results
Create a connection to Google Search in CData Connect AI and insert Google Search into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Redis Replication to MySQL
Use CData Sync for automated, continuous, customizable Redis replication to MySQL.
-
Use the CData Software ODBC Driver for SuiteCRM in SAS for Real-Time Reporting and Analytics
Connect to real-time SuiteCRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SuiteCRM.
-
Use the CData Software ODBC Driver for Clockify in MicroStrategy
Connect to Clockify in MicroStrategy Developer using the CData Software ODBC Driver for Clockify.
-
Automated Continuous Procore Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Procore replication to delimited files (CSV/TSV).
-
How to create Google Search federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Search in MySQL .
-
Integrate with Wrike Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Wrike to a JSON file on disk.
-
How to Connect to Live Spark 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 Apache Spark SQL for you.
-
How to connect to Clockify Data from Spring Boot
Connect to Clockify in a Spring Boot Application using the CData API Driver for JDBC
-
Access Oracle Eloqua Data from MySQL in Amazon QuickSight
Connect to Oracle Eloqua and build visualizations of Oracle Eloqua using a MySQL Connection in Amazon QuickSight.
-
Create ActiveCampaign-Connected Dashboards in Grafana
Connect to ActiveCampaign Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ActiveCampaign.
-
How to Connect to Live SQL Server 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 Microsoft SQL Server for you.
-
How to Connect to Live Google Directory 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 Google Directory for you.
-
How to Access Live Phoenix Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Phoenix enables you to integrate Apache Phoenix into workflows built using Microsoft Power Automate Desktop.
-
Connect to OpenWeatherMap from a Connection Pool in WebLogic
Use the CData JDBC Driver for OpenWeatherMap to connect to OpenWeatherMap from Web applications running on WebLogic.
-
Establish a Live Connection with Productboard Data using Tableau Bridge
The CData ODBC Driver for Productboard enables you to integrate live Productboard into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect Mailjet to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mailjet with IBM WebSphere for seamless data integration and connectivity.
-
Build Facebook Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Facebook and build visualizations in Tableau Cloud.
-
View Reports on Real-Time Oracle Sales Data in Power BI Report Server
Use the CData ODBC Driver for Oracle Sales to visualize Oracle Sales in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to ZeroBounce 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 ZeroBounce and work with ZeroBounce in your FileMaker application.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Dynamics CRM within intelligent workflows.
-
How to Access Live IBM Cloud Object Storage Data in Visual Studio Code via Cline
Run CData MCP Server for IBM Cloud Object Storage on Windows Subsytem for Linux (WSL) and connect to live IBM Cloud Object Storage from the Cline extension in Visual Studio Code.
-
Query Cosmos DB Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Azure Cosmos DB from Node.js.
-
Integrating Gumloop with Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Entra ID within automated workflows.
-
Integrate Theia IDE with Live Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Google Search Results Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Search through CData Connect AI using different applications and tools.
-
Explore Geographical Relationships in Google Translate Data with Power Map
Create data visualizations with Google Translate in Power Map.
-
Visualize NetSuite Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load NetSuite CRM & ERP into TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for Telegram
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Telegram.
-
Analyze Acumatica Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Acumatica ERP with the CData JDBC Driver for Acumatica.
-
Automated Zoho Creator Data Replication to Teradata
Use CData Sync to Customize and automate Zoho Creator replication to Teradata.
-
Create Datasets from Gong in Domo Workbench and Build Visualizations of Gong Data in Domo
Use the CData Software ODBC Driver for Gong to create datasets from Gong in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Tableau Connector for MessageBird
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use Azure AI Foundry to Talk to Your Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Pivotal GreenPlum for you.
-
Integrate OData with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate OData with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to OData.
-
Use Azure AI Foundry to Talk to Your Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Google Campaign Manager 360 for you.
-
How to Work with Amazon DynamoDB Data in ETL Validator JDBC
Connect to Amazon DynamoDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Dash to Build to Web Apps on Zuora Data
Create Python applications that use pandas and Dash to build Zuora-connected web apps.
-
Build Dashboards with MailerLite Data in Dundas BI
Create dynamic dashboards and perform analytics based on MailerLite in Dundas BI.
-
How to Work with ServiceDesk Plus Data in ETL Validator JDBC
Connect to ServiceDesk Plus from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData SSIS Components for SparkPost
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SparkPost.
-
Bind Live Salesloft Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Salesloft data
-
Connecting Pipedream with HBase 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 HBase data in real time.
-
Integrate with Printful Data in JReport Designer
Create charts and reports based on Printful in JReport Designer.
-
Connecting Mastra with Microsoft Exchange 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 Microsoft Exchange, no replication required.
-
Integrate Square Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Square and integrate live Square into your Power Automate tasks.
-
Create Dynamic NASA Grids Using the Infragistics XamDataGrid
Learn how you can connect NASA to Infragistics XamDataGrid to build dynamic grids.
-
Connect and Query Live Smartsheet Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Smartsheet into Databricks
-
Connecting Agentforce with Dropbox Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Dropbox for you.
-
Bugsnag Reporting in OBIEE with the Bugsnag JDBC Driver
Deploy the Bugsnag JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Slack Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Slack replication to Azure SQL Database.
-
Creating Microsoft Ads-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft Ads to Unqork and build custom business apps.
-
Connect to SAS xpt Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAS xpt as an External Source in Dremio.
-
Extract, Transform, and Load Reply.io Data in Informatica PowerCenter
Create a simple Workflow for Reply.io in Informatica PowerCenter.
-
Query Oracle HCM Cloud Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle HCM Cloud from Node.js.
-
Query Salesforce CRM Analytics Data in DataGrip
Create a Data Source for Salesforce CRM Analytics in DataGrip and use SQL to query live Salesforce CRM Analytics.
-
Connect and Visualize Live HBase Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Apache HBase into the Databricks platform and create visualization dashboards with real-time Apache HBase.
-
Build Voice Agents in ElevenLabs with access to Live Smartsheet Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Smartsheet.
-
Automated Continuous Intercom Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Intercom replication to Google BigQuery.
-
Integrate Google Search Results into Power Automate Desktop using CData Connect
CData Connect for Google Search Results enables you to integrate Google Search into workflows built using Microsoft Power Automate Desktop.
-
Connect to BambooHR Data from PowerBuilder via JDBC
This article demonstrates how to access BambooHR from PowerBuilder using the BambooHR JDBC Driver.
-
Integrate Cursor with Live Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Apollo from within the editor.
-
Query Oracle Sales Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Oracle Sales and perform CRUD operations on Oracle Sales from Node.js.
-
Use Dash to Build to Web Apps on MailerLite Data
Create Python applications that use pandas and Dash to build MailerLite-connected web apps.
-
Access Salesforce Data from MySQL in Amazon QuickSight
Connect to Salesforce and build visualizations of Salesforce & Force.com using a MySQL Connection in Amazon QuickSight.
-
Analyze Google Campaign Manager 360 Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Campaign Manager 360 with the CData JDBC Driver for Google Campaign Manager 360.