CData Software - Knowledge Base
Recent Articles
-
Build xBase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live xBase.
-
Build a Simple VCL Application for Lakebase Data
How to build a simple VCL Application to view Lakebase in RAD Studio using the CData ODBC Driver for Lakebase.
-
Build ADP-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for ADP to explore live ADP Data in Gemini Code Assist to assist with building ADP-powered applications.
-
How to Connect to Cloudant Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to IBM Cloudant. Leverage the pyodbc module for ODBC in Python.
-
Connect to Sage Cloud Accounting Data in Google Apps Script via Connect AI
Use CData Connect AI to access Sage Business Cloud Accounting in Google Apps Script.
-
Integrating Box Data in Talend Cloud Data Management Platform
Connect Box Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Box.
-
DataBind Controls to Zendesk Data in C++Builder
DataBind to Zendesk in C++Builder with standard components and controls.
-
Connect to Foursquare Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Foursquare as an External Source in Dremio.
-
Visualize Salesforce Pardot Data in Sisense
Create an ElastiCube in Sisense app with access to Salesforce Pardot.
-
Connect to and Visualize Live Hubstaff Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Hubstaff.
-
Process & Analyze SAP HANA Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP HANA Data.
-
Integrate with Harvest Data in JReport Designer
Create charts and reports based on Harvest in JReport Designer.
-
How to import SuiteCRM Data into Apache Solr
Use the CData Software JDBC Driver for SuiteCRM in Data Import Handler and create an automated import of SuiteCRM to Apache Solr Enterprise Search platform.
-
Build Apps with Live MySQL Data Using the Low-Code Development Platform of Mendix
Connect MySQL with Mendix to build apps using the CData JDBC Driver for MySQL.
-
Automate Google Ads Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google Ads and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Access Live Certinia Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Certinia into the statistical analysis tools available in SAS JMP. This article shows how to use Certinia in the Graph Builder and Query Builder.
-
Provide OData Services of Mode Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Mode by developing a WCF Service Application.
-
Connect to Google Analytics Data in RapidMiner
Integrate Google Analytics with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Google Spanner-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Spanner.
-
Automated Continuous Microsoft Planner Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Azure SQL Database.
-
How to connect SharePoint with PingOne Data through external lists
Provide PingOne to SharePoint users as an external list.
-
Integrating Antigravity CLI with Outreach.io via CData CLI
Connect Outreach.io to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData Software JDBC Driver for Freshdesk in MicroStrategy Desktop
Connect to Freshdesk in MicroStrategy Desktop using the CData Software JDBC Driver for Freshdesk.
-
How to Connect to Live Google Spanner 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 Spanner for you.
-
Integrating LangChain with Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Active Directory within automated workflows.
-
Connect to Klipfolio 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 Klipfolio and work with Klipfolio in your FileMaker application.
-
Connecting Agentforce with Office 365 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 Microsoft Office 365 for you.
-
How to update Amazon DynamoDB from Excel
This article explains how to transfer data from Excel to Amazon DynamoDB using the Excel Add-In for Amazon DynamoDB.
-
Query SurveyMonkey Data as a MySQL Database in Node.js
Execute MySQL queries against SurveyMonkey from Node.js.
-
Build Salesforce CRM Analytics Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Salesforce CRM Analytics and build visualizations in Tableau Cloud.
-
Publish Crystal Reports on Spotify Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Spotify.
-
Monday.com Reporting in OBIEE with the Monday.com JDBC Driver
Deploy the Monday.com JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Publish Reports with Hacker News Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Hacker News.
-
Analyze Live BambooHR Data in SAS Viya
Use CData Connect AI to connect to BambooHR from SAS Viya and deploy self-service analytics using live BambooHR.
-
Integrating Claude Code CLI with Sage Cloud Accounting 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 Dashboards and Visualize Live Exact Online Data in Geckoboard
Use CData Connect AI to connect to live Exact Online and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating OpenCode Terminal with Google Search Results 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.
-
Integrating Codex CLI with Amazon Athena 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.
-
Google Tasks Reporting in OBIEE with the Google Tasks JDBC Driver
Deploy the Google Tasks JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to PhantomBuster from a Connection Pool in WebLogic
Use the CData JDBC Driver for PhantomBuster to connect to PhantomBuster from Web applications running on WebLogic.
-
Create a Data Access Object for Bitbucket Data using JDBI
A brief overview of creating a SQL Object API for Bitbucket in JDBI.
-
Build Apps with Live MailChimp in Adalo using CData Connect AI
Use CData Connect AI to integrate live MailChimp into the Adalo platform and build custom mobile and web applications with real-time MailChimp.
-
Access Live RabbitMQ Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate RabbitMQ into the statistical analysis tools available in SAS JMP. This article shows how to use RabbitMQ in the Graph Builder and Query Builder.
-
Visualize Workday Data in TIBCO Spotfire through OData
Integrate Workday into dashboards in TIBCO Spotfire.
-
Use the CData Software JDBC Driver for BambooHR in MicroStrategy
Connect to BambooHR in MicroStrategy Developer using the CData Software JDBC Driver for BambooHR.
-
Extract, Transform, and Load Excel Online Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Excel Online in Informatica PowerCenter.
-
Connect to Humanity Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Humanity as an External Source in Dremio.
-
Integrate Google Spanner Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Spanner and integrate live Google Spanner into your Power Automate tasks.
-
How to Easily Query Telegram Data in OpenOffice Base
Connect to Telegram data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Marketo Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Marketo.
-
Deploy the ADO.NET Provider for Paylocity on an SSRS Report Server
Connect to Paylocity 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure Synapse
Create an ODBC connection to Azure Synapse in Informatica and browse and transfer Azure Synapse.
-
Replicate HCL Domino Data to Multiple Databases
Replicate HCL Domino to disparate databases with a point-and-click configuration.
-
Build Data Flows from Gumroad to SQL Server using SSIS
Easily back up Gumroad to SQL Server using the SSIS components for Gumroad.
-
Connecting Agentforce with Microsoft Exchange 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 Microsoft Exchange for you.
-
Integrating Kiro CLI with Vercel 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.
-
Automate QuickBooks Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks Desktop and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
LINQ to SageHR 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 SageHR Data Provider.
-
Build Semantic Layer Views for Qualaroo Data in APOS Live Data Gateway
Use the CData Connector for Qualaroo in APOS Live Data Gateway to build Semantic Layer Views for Qualaroo.
-
Replicate ZohoMarketingHub Data from PowerShell
Write a quick PowerShell script to query ZohoMarketingHub. Use connectivity to the live data to replicate ZohoMarketingHub to SQL Server.
-
Automated Continuous Amazon Athena Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Amazon Athena replication to OneLake in Microsoft Fabric.
-
How to Query Live Oracle Eloqua Reporting Data in Perplexity MacOS Desktop
Connect to and query live Oracle Eloqua Reporting Data in Perplexity Desktop using CData MCP Server.
-
Migrating data from GitHub to Databricks using CData SSIS Components.
Easily push GitHub to Databricks using the CData SSIS Tasks for GitHub and Databricks.
-
Create Amazon DynamoDB-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Amazon DynamoDB Data from Klipfolio and build custom visualizations using live Amazon DynamoDB.
-
Getting Started with the CData Excel Add-In for Instagram
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Instagram.
-
How to Work with Paddle Data in ETL Validator JDBC
Connect to Paddle from ETL Validator jobs using the CData Software JDBC Driver.
-
Load Epicor Kinetic Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Epicor Kinetic to a database.
-
Integrating Codex CLI with SAP HANA XS Advanced 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 DBeaver to CapsuleCRM via a JDBC Driver
Manage CapsuleCRM with visual tools in DBeaver like the query browser.
-
DataBind Charts to ServiceDesk Plus Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ServiceDesk Plus 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.
-
Build Automated Klaviyo-Connected Workflows in Zapier
Use CData Connect AI to connect to live Klaviyo and build automated workflows in Zapier.
-
DataBind Charts to Jira Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Atlassian Jira 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.
-
Automate SAP Netweaver Gateway Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP Netweaver Gateway replication to Azure Synapse.
-
How to Connect to Live Spark Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Apache Spark SQL for you.
-
Integrating OpenCode Terminal with GitHub 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 publish and share Invoiced Data dashboards with Tableau Server
The CData ODBC driver for Invoiced enables you integrate Invoiced into Tableau dashboards.
-
Create Office 365 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Office 365 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Dynamics NAV Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft Dynamics NAV from Node.js.
-
Create a Data Access Object for Reckon Data using JDBI
A brief overview of creating a SQL Object API for Reckon in JDBI.
-
Integrate Live SharePoint Excel Services Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SharePoint Excel Services to Blue Prism using the CData ODBC Driver for SharePoint Excel Services to create automated workflows for repetitive business tasks.
-
Integrating GitHub Copilot CLI with Cvent 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 Okta Data in Jaspersoft Studio
Execute SQL to remote Okta in Jaspersoft Studio.
-
How to load PayPal data into Elasticsearch via Logstash
Introducing a simple method to load PayPal data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate ZarMoney with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ZarMoney with External Services.
-
Write a Simple Go Application to work with Access Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Access.
-
Build MVC Applications with Connectivity to Azure Analysis Services Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure Analysis Services from an ASP.NET MVC application.
-
How to use SQLAlchemy ORM to access HDFS Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apache HDFS.
-
Connect to Adobe Analytics Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Adobe Analytics.
-
Provide OData Services of Pushbullet Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Pushbullet by developing a WCF Service Application.
-
Working with Vimeo Data in LINQPad
Execute LINQ queries to Vimeo in LINQPad.
-
Connect to Live Couchbase Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Couchbase in CData Connect AI and connect to your Couchbase from PostgreSQL.
-
Validate Mistral AI Data with QuerySurge
Access and validate Mistral AI in QuerySurge using the CData JDBC Driver.
-
Access Live Excel Online Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Excel Online data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
A PostgreSQL Interface for Vault CRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the Vault CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Validate AdRoll Data with QuerySurge
Access and validate AdRoll in QuerySurge using the CData JDBC Driver.
-
DataBind Charts to Datadog Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Datadog 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.
-
Integrating Claude Code CLI with AdRoll 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.
-
Integrating Gumloop with Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zuora within automated workflows.
-
Stream Gmail Data into Apache Kafka Topics
Access and stream Gmail in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Extract, Transform, and Load Azure Data Lake Storage Data in Informatica PowerCenter
Create a simple Workflow for Azure Data Lake Storage in Informatica PowerCenter.