CData Software - Knowledge Base
Recent Articles
-
DataBind Controls to Sage Cloud Accounting Data in C++Builder
DataBind to Sage Cloud Accounting data in C++Builder with standard components and controls.
-
Integrating Antigravity CLI with Nuclia data via CData CLI
Connect Nuclia data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Informatica Mappings From/To an ODBC Data Source for ShipStation
Create an ODBC connection to ShipStation in Informatica and browse and transfer ShipStation data.
-
How to Visualize HBase 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 HBase data in Python.
-
Use Azure AI Foundry to Talk to Your Zoho Projects 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 Zoho Projects data for you.
-
Stream Timely Data into Apache Kafka Topics
Access and stream Timely data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Enable the Trello JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Trello data.
-
How to load Elasticsearch data into Elasticsearch via Logstash
Introducing a simple method to load Elasticsearch data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Visualize Google Analytics Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Analytics data in Python.
-
Automated Continuous Close Replication to Oracle
Use CData Sync for automated, continuous, customizable Close replication to Oracle.
-
Automate CampaignMonitor Data Replication to Azure Data Lake
Use CData Sync to customize and automate CampaignMonitor data replication to Azure Data Lake.
-
Query Zoho Books Data in DataGrip
Create a Data Source for Zoho Books in DataGrip and use SQL to query live Zoho Books data.
-
Connect AgileCRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your AgileCRM data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect LinkedIn Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your LinkedIn data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Reports from Bitly Data in Looker Studio
Use CData Connect AI to gain access to live Bitly data and create custom reports in Looker Studio.
-
Create Power BI Reports on Real-Time Humanity Data
Use the CData ODBC Driver for Humanity to visualize Humanity data in Power BI Desktop.
-
Trigger Snapchat Ads IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Snapchat Ads with standard wizards in Logic Apps.
-
Import and Visualize Toggl Data in Power View
Create data visualizations based on Toggl data in Excel.
-
How to create HCL Domino federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for HCL Domino data in MySQL .
-
Connect to Demio Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Demio data using standard SQL.
-
Visualize Live Humanity Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Humanity data.
-
Automated Continuous GitLab Replication to IBM DB2
Use CData Sync for automated, continuous, customizable GitLab replication to IBM DB2.
-
Connect to Azure DevOps Data in Jaspersoft Studio
Execute SQL to remote Azure DevOps data in Jaspersoft Studio.
-
DataBind GraphQL Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for GraphQL with the DevExpress Windows Forms and Web controls to provide GraphQL data to a chart.
-
How to Seamlessly Import Pingdom Data into IBM SPSS Modeler
Integrate Pingdom data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to Live Avalara AvaTax 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 Avalara AvaTax data for you.
-
Integrate Live Salesforce CRM Analytics Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Salesforce CRM Analytics data to Blue Prism using the CData ODBC Driver for Salesforce CRM Analytics to create automated workflows for repetitive business tasks.
-
Automated Continuous Codat Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Codat replication to IBM DB2.
-
Analyze AlloyDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze AlloyDB data in Microsoft R Open.
-
Integrate with Freshservice Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Freshservice data to a JSON file on disk.
-
Automated Continuous Azure Blob Storage Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Google BigQuery.
-
Work with XML Data in FoxPro
Load XML data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Bidirectional Access to OneNote Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate OneNote data in Filemaker Pro for Mac or Windows.
-
Write a Simple Go Application to work with Adobe Target Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Adobe Target data.
-
Automated Continuous PhantomBuster Replication to Snowflake
Use CData Sync for automated, continuous, customizable PhantomBuster replication to Snowflake.
-
How to load PolarTeamPro data into Elasticsearch via Logstash
Introducing a simple method to load PolarTeamPro data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Azure Data Lake Storage Data in Jaspersoft Studio
Execute SQL to remote Azure Data Lake Storage data in Jaspersoft Studio.
-
How to Query Live Excel Online Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Excel Online data data in natural language using Python.
-
Create Elorus Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Elorus data access from reports, embedded analytics, and more.
-
Connect to Azure DevOps Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Azure DevOps data from Filemaker Pro on Mac.
-
Access Live Splunk Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Splunk data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect Flowise AI Agents to Live Google Analytics Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Google Analytics data without replication.
-
Analyze Google Forms Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Forms data with the CData JDBC Driver for Google Forms.
-
Integrating Codex with Confluence 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.
-
Migrating data from ScrapingBee to Google BigQuery using CData SSIS Components.
Easily push ScrapingBee data to Google BigQuery using the CData SSIS Tasks for ScrapingBee and Google BigQuery.
-
Getting Started with the CData JDBC Driver for Shortcut
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Shortcut.
-
Add Datadog Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Datadog with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create SSAS Tabular Models from Nuclia Data
How to build a SQL Server Analysis Service Tabular Model from Nuclia data using CData drivers.
-
How to connect to Highrise Data from Spring Boot
Connect to Highrise in a Spring Boot Application using the CData JDBC Driver for Highrise
-
Integrate Zuora Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zuora data from Informatica Cloud.
-
Operational Reporting on Wave Financial Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Wave Financial data.
-
Replicate Multiple Billsby Accounts
Replicate multiple Billsby accounts to one or many databases.
-
Automated Continuous Mode Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Mode replication to Google BigQuery.
-
Connect to Dynamics NAV Data in DBArtisan
Use wizards in DBArtisan to configure Dynamics NAV data as a data source.
-
Access Live Close Data in AWS Lambda
Connect to live Close data in AWS Lambda using the CData JDBC Driver.
-
Connect to Mailgun Data in Google Apps Script via Connect AI
Use CData Connect AI to access Mailgun data in Google Apps Script.
-
Automated Continuous Copper Replication to Oracle
Use CData Sync for automated, continuous, customizable Copper replication to Oracle.
-
Freshservice Reporting in OBIEE with the Freshservice JDBC Driver
Deploy the Freshservice JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Live Zoho 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 Zoho CRM data for you.
-
Query GetResponse Data as a SQL Server Database in Node.js
Execute SQL Server queries against GetResponse data from Node.js.
-
Back Up Exa 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 Exa data data.
-
Interact with Live Wave Financial Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Wave Financial data.
-
Integrate ZohoPeople Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZohoPeople data from Informatica Cloud.
-
DataBind Hubstaff Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Hubstaff data to a chart.
-
Connect to Jodoo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Jodoo to connect to Jodoo data and execute queries in PowerBuilder.
-
Integrate with Zoho Creator Data in JReport Designer
Create charts and reports based on Zoho Creator data in JReport Designer.
-
Access Live Google Spanner Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Spanner data from your Excel spreadsheets.
-
Access SQL Analysis Services Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SQL Analysis Services data from HeidiSQL.
-
Process & Analyze Reckon Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Reckon Data.
-
Demo: Migrate Data from Salesforce to SharePoint
CData Data Providers offer a wide range of uses, including the ability to migrate data between sources quickly. Download this demo that helps you transfer Salesforce.com data into SharePoint.
-
Access CouchDB Data from MySQL in Amazon QuickSight
Connect to CouchDB and build visualizations of CouchDB data using a MySQL Connection in Amazon QuickSight.
-
Connect to Parquet Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Parquet.
-
Using the CData Software ODBC Driver for Bullhorn CRM in PyCharm
Connect to Bullhorn CRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for Bullhorn CRM.
-
Natively Connect to ClickTime Data in PHP
The CData ODBC driver for ClickTime enables you to create PHP applications with connectivity to ClickTime data. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for QuickBooks Online in SAS for Real-Time Reporting and Analytics
Connect to real-time QuickBooks Online data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for QuickBooks Online.
-
ETL eBay Analytics in Oracle Data Integrator
This article shows how to transfer eBay Analytics data into a data warehouse using Oracle Data Integrator.
-
Connect to GraphQL Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for GraphQL and the Script function in FileMaker Pro to connect to GraphQL and work with GraphQL data in your FileMaker application.
-
Build Semantic Layer Views for SAP SuccessFactors LMS Data in APOS Live Data Gateway
Use the CData Connector for SAP SuccessFactors LMS in APOS Live Data Gateway to build Semantic Layer Views for SAP SuccessFactors LMS data.
-
Build Zoho Books-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zoho Books Data from Zoho Analytics and import live Zoho Books data.
-
DataBind Charts to Drip Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Drip 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.
-
Excel Spreadsheet Automation on ElevenLabs Data with the QUERY Formula
Pull data from ElevenLabs, automate spreadsheets, and more with the QUERY formula.
-
Create Dynamic Google Calendar Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Calendar to Infragistics XamDataGrid to build dynamic grids.
-
Prepare, Blend, and Analyze Workable Data in Alteryx Designer (ODBC)
Build workflows to access live Workable data for self-service data analytics.
-
Visualize Live Coinbase Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Coinbase data.
-
Build Data Flows from Optimizely to SQL Server using SSIS
Easily back up Optimizely data to SQL Server using the SSIS components for Optimizely.
-
Query AlloyDB Data as a MySQL Database in Node.js
Execute MySQL queries against AlloyDB data from Node.js.
-
Automate Sage Cloud Accounting Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sage Cloud Accounting data from PowerShell? This article demonstrates how to utilize the Sage Cloud Accounting Cmdlets for tasks like connecting to Sage Cloud Accounting data, automating operations, downloading data, and more.
-
BigQuery Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on BigQuery facts in real time.
-
Replicate ChartMogul Data to Multiple Databases
Replicate ChartMogul data to disparate databases with a point-and-click configuration.
-
Connect to Mode Data in RazorSQL
Connect to Mode from wizards and query Mode data from the GUI in the RazorSQL database management tool.
-
Create Informatica Mappings From/To a JDBC Data Source for Teradata
Create Teradata data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Adobe Commerce-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Adobe Commerce data.
-
Integrate Devin with Live Cvent 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 Cvent data.
-
Connect to Qualaroo from Asprova with CData Software ODBC Driver for Qualaroo
This article shows how to connect faster to Qualaroo data from Asprova.
-
Integrate with Google Directory Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Directory data in SnapLogic.
-
Connect to SingleStore Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SingleStore Data and connect to SingleStore data in Akorbi Digital RunMyProcess.
-
Build Semantic Layer Views for Timely Data in APOS Live Data Gateway
Use the CData Connector for Timely in APOS Live Data Gateway to build Semantic Layer Views for Timely data.
-
Connect to Excel Data in DBArtisan
Use wizards in DBArtisan to configure Excel data as a data source.
-
Create Amazon Marketplace Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Amazon Marketplace from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Visualize ZohoPeople Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZohoPeople data in Python.