CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Toggl Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Toggl data replication to OneLake in Microsoft Fabric.
-
Integrate Google's Antigravity Agent with Live Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Outreach.io data using the Model Context Protocol.
-
Connect to Azure Table from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Azure Table data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to MailChimp Data in Claris FileMaker Pro
Use the CData ODBC Driver for MailChimp in FileMaker Pro to connect to MailChimp and work with MailChimp data in your FileMaker applications.
-
Replicate Multiple Active Directory Accounts
Replicate multiple Active Directory accounts to one or many databases.
-
Build Apps with Live Twilio Data Using the Low-Code Development Platform of Mendix
Connect Twilio data with Mendix to build apps using the CData JDBC Driver for Twilio.
-
Use Azure AI Foundry to Talk to Your Cloudflare 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 Cloudflare data for you.
-
Publish ZohoInvoice-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZohoInvoice data.
-
Integrating Codex with Bright Data 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 LibreChat with Live AgileCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live AgileCRM data from within the chat interface.
-
Visualize Discourse 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 Discourse data into TIBCO Spotfire.
-
Create a Data Access Object for Paylocity Data using JDBI
A brief overview of creating a SQL Object API for Paylocity data in JDBI.
-
Automated Continuous Klipfolio Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Klipfolio replication to Amazon S3.
-
How to Connect DBeaver to GitHub via a JDBC Driver
Manage GitHub data with visual tools in DBeaver like the query browser.
-
A PostgreSQL Interface for SAP Concur Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Concur JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Oracle Financials Cloud Data Replication to SAP HANA
Use CData Sync to customize and automate Oracle Financials Cloud data replication to SAP HANA.
-
Automated Continuous Sage Cloud Accounting Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to AlloyDB.
-
Access Webex Data from MySQL in Amazon QuickSight
Connect to Webex and build visualizations of Webex data using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData Excel Add-In for WooCommerce
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for WooCommerce.
-
Integrating Codex with Yelp 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.
-
Automated Continuous Oracle Sales Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Apache Kafka.
-
Integrate Live Certinia Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Certinia data to Blue Prism using the CData ODBC Driver for Certinia to create automated workflows for repetitive business tasks.
-
Replicate Facebook Data from PowerShell
Write a quick PowerShell script to query Facebook data. Use connectivity to the live data to replicate Facebook data to SQL Server.
-
Query Live Sybase IQ 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 Sybase IQ data through a conversational interface.
-
Integrate Live Eventbrite Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Eventbrite data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous Slack Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Slack replication to IBM DB2.
-
Build Data Flows from Salesforce Data 360 to SQL Server using SSIS
Easily back up Salesforce Data 360 data to SQL Server using the SSIS components for Salesforce Data 360.
-
Automated Continuous Perplexity Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Perplexity replication to Google BigQuery.
-
Build an OLAP Cube in SSAS from ServiceDesk Plus Data
Establish a connection to ServiceDesk Plus data data from SQL Server Analysis Services, and use the ServiceDesk Plus Data Provider to build OLAP cubes for use in analytics and reporting.
-
DataBind Charts to Confluence Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Confluence 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.
-
Integrate QuickBooks Time Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live QuickBooks Time data from Informatica Cloud.
-
Build MVC Applications with Connectivity to Mouseflow Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Mouseflow from an ASP.NET MVC application.
-
Automate Billsby Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Billsby data from PowerShell? This article demonstrates how to utilize the Billsby Cmdlets for tasks like connecting to Billsby data, automating operations, downloading data, and more.
-
Seamlessly Bring Lakebase Data into Retool Using CData Connect AI
Integrate Lakebase data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Seamlessly Bring WordPress Data into Retool Using CData Connect AI
Integrate WordPress data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Changelog: Driver Update 2024.2
Review the driver-specific changes from the 2024.2 CData Driver release.
-
How to Visualize Supabase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Supabase data in Python.
-
Integrating Codex with SAP Fieldglass 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 SSAS Tabular Models from GitLab Data
How to build a SQL Server Analysis Service Tabular Model from GitLab data using CData drivers.
-
Integrating GitHub Copilot with Azure DevOps 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 Cursor with Live FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live FHIR data from within the editor.
-
How to Connect DBeaver to Zoho Projects via a JDBC Driver
Manage Zoho Projects data with visual tools in DBeaver like the query browser.
-
Access Live PolarTeamPro Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PolarTeamPro data from your Google Sheets.
-
Use CData Connect AI to Access Oracle HCM Cloud Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle HCM Cloud data in the Power Pivot business intelligence tool.
-
How to Connect to EnterpriseDB Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to EnterpriseDB data. Leverage the pyodbc module for ODBC in Python.
-
Create ServiceDesk Plus-Connected Dashboards in Grafana
Connect to ServiceDesk Plus Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ServiceDesk Plus data.
-
Visualize Live Bullhorn CRM Data in the Power BI Service
Use CData Connect AI to connect to live Bullhorn CRM data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Load Mode Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Mode data to a database.
-
Create SSAS Tabular Models from Pipeline CRM Data
How to build a SQL Server Analysis Service Tabular Model from Pipeline CRM data using CData drivers.
-
Stream Calendly Data into Apache Kafka Topics
Access and stream Calendly data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build a PostgreSQL Interface for Intercom Data using the CData JDBC Driver
Use the Remoting features of the Intercom JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating OpenCode with Insightly 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 Trello Data from PowerBuilder via ADO.NET
This article demonstrates how to access Trello data from Appeon PowerBuilder using the CData ADO.NET Provider for Trello.
-
DataBind Confluence Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Confluence with the DevExpress Windows Forms and Web controls to provide Confluence data to a chart.
-
DataBind Charts to Authorize.Net Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Authorize.Net 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.
-
Integrate Live Splunk Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Splunk data to Blue Prism using the CData ODBC Driver for Splunk to create automated workflows for repetitive business tasks.
-
How to Connect to Live Guru Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Guru data for you.
-
Access Live ShipStation Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ShipStation data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Analyze Cohere Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Cohere data with the CData JDBC Driver for Cohere.
-
Build a Singer.io Tap for Pipeliner CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Pipeliner CRM data using the CData Python Connector.
-
How to Access Bright Data Data Using Entity Framework
This article shows how to access Bright Data data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData ADO.NET Provider for Short.io
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
ETL ZohoExpense in Oracle Data Integrator
This article shows how to transfer ZohoExpense data into a data warehouse using Oracle Data Integrator.
-
Automate Zoom Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoom data replication to Azure Data Lake.
-
Model, Search, and Visualize Live Zendesk Data in ThoughtSpot
Use CData Connect AI to connect to live Zendesk data for modeling, searching, and visualizing.
-
Analyze SendPulse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SendPulse data in Microsoft R Open.
-
Analyze IBM Cloud Object Storage Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze IBM Cloud Object Storage data in Microsoft R Open.
-
Integrating Antigravity CLI with SAP Ariba Source data via CData CLI
Connect SAP Ariba Source data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Bidirectional Access to Basecamp Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Basecamp data in Filemaker Pro for Mac or Windows.
-
How to create an RPA flow for ClickUp Data in UiPath Studio
Use the ClickUp ODBC Driver to create workflows that access real-time ClickUp data without any coding.
-
Connect Invoiced to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Invoiced with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Google's Vertex AI Agent with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Dataverse data within intelligent workflows.
-
How to Connect to Live Vault CRM 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 Vault CRM data for you.
-
Automated Continuous Perigon Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Perigon replication to Azure SQL Database.
-
Work with ServiceNow Data in FoxPro
Load ServiceNow data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Informatica Mappings From/To a JDBC Data Source for Zoho Books
Create Zoho Books data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect and Visualize Live Office 365 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Office 365 data into the Databricks platform and create visualization dashboards with real-time Office 365 data.
-
Connect to ADP Data in CloverDX (formerly CloverETL)
Transfer ADP data using the visual workflow in the CloverDX data integration tool.
-
Connect to YouTube Analytics Data from PowerBuilder via JDBC
This article demonstrates how to access YouTube Analytics data from PowerBuilder using the YouTube Analytics JDBC Driver.
-
Choosing the Best Method to Connect TaxJar to SQL Server: 5 Options Explained
Discover multiple ways to connect and use TaxJar data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData Power BI Connector for Email
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Email.
-
DataBind Controls to Eventbrite Data in C++Builder
DataBind to Eventbrite data in C++Builder with standard components and controls.
-
Create SSAS Tabular Models from Campaigner Data
How to build a SQL Server Analysis Service Tabular Model from Campaigner data using CData drivers.
-
Integrate Live Zuora 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 Zuora data from within the IDE.
-
Build Dashboards with Parallel Data in DBxtra
Create dynamic dashboards and perform analytics based on Parallel data in DBxtra.
-
Connect to eBay Analytics Data in CloverDX (formerly CloverETL)
Transfer eBay Analytics data using the visual workflow in the CloverDX data integration tool.
-
Query CloudConvert Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CloudConvert data from Node.js.
-
Automated Continuous Google Spanner Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Spanner replication to MySQL.
-
Getting Started with the CData Python Connector for eBay
Learn to install and license the CData Python Connector and configure a connection to live eBay data.
-
Integrating LlamaIndex with Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Act-On data in real time.
-
How to Connect to Live LinkedIn 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 LinkedIn data without replication.
-
Consume Outreach.io OData Feeds in PowerBuilder
This article demonstrates how to consume Outreach.io data as OData feeds from PowerBuilder using the API Server.
-
Access Live Stripe Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Stripe data from your Excel spreadsheets.
-
Connect to BambooHR Data in Google Apps Script via Connect AI
Use CData Connect AI to access BambooHR data in Google Apps Script.
-
Create Dashboards and Visualize Live xBase Data in Geckoboard
Use CData Connect AI to connect to live xBase data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Live Excel Online Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Excel Online data to Blue Prism using the CData ODBC Driver for Excel Online to create automated workflows for repetitive business tasks.
-
Integrate Google's Vertex AI Agent with Live AfterShip Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live AfterShip data within intelligent workflows.
-
Integrating Cursor with Postmark 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.
-
Access Live Elasticsearch Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Elasticsearch data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Replicate Amazon S3 Data to Multiple Databases via the CData Sync CLI
Replicate Amazon S3 data to disparate databases with a single configuration.