CData Software - Knowledge Base
Recent Articles
-
Work with SAP Business One Data in FoxPro
Load SAP Business One data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating LangChain with Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Act CRM data within automated workflows.
-
Integrate SurveyMonkey Data in the Pentaho Report Designer
Publish reports based on SurveyMonkey data in the Pentaho BI tool.
-
Integrating Kiro with Redis 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 Visualize Invoiced Data in Python with pandas
Use pandas and other modules to analyze and visualize live Invoiced data in Python.
-
Integrate RSS Feeds in Pentaho Data Integration
Build ETL pipelines based on RSS feeds in the Pentaho Data Integration tool.
-
Access Live MySQL Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to MySQL data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Visualize Google Ads Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Ads data in Python.
-
Use Dash to Build to Web Apps on Pushbullet Data
Create Python applications that use pandas and Dash to build Pushbullet-connected web apps.
-
Connecting Agentforce with Samanage 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 Samanage data for you.
-
Import Real-Time Amazon DynamoDB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Amazon DynamoDB data in ColdFusion.
-
Integrate Live HubSpot Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to HubSpot from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live HubSpot data.
-
Automated Continuous ChartMogul Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ChartMogul replication to Google BigQuery.
-
Getting Started with the CData Python Connector for Retently
Learn to install and license the CData Python Connector and configure a connection to live Retently data.
-
Automated Continuous Freshteam Replication to SQLite
Use CData Sync for automated, continuous, customizable Freshteam replication to SQLite.
-
Automate Reckon Data Replication to Couchbase
Use CData Sync to Customize and automate Reckon data replication to Couchbase.
-
Connect to Float Data from a Connection Pool in JBoss
Integrate Float data into Java servlets: Use the Management Console in JBoss to install the Float JDBC Driver.
-
Browserless Reporting in OBIEE with the Browserless JDBC Driver
Deploy the Browserless JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Boomi Agentstudio with QuickBooks Time Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to QuickBooks Time data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Workable Data in Jaspersoft Studio
Execute SQL to remote Workable data in Jaspersoft Studio.
-
Consume PingOne OData Feeds in SAP Lumira
Use the API Server to create data visualizations on PingOne feeds that reflect any changes in SAP Lumira.
-
Connect to Suadeo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Suadeo to connect to Suadeo data from Web applications running on WebLogic.
-
Replicate Office 365 Data from PowerShell
Write a quick PowerShell script to query Office 365 data. Use connectivity to the live data to replicate Office 365 data to SQL Server.
-
Explore Geographical Relationships in Gorgias Data with Power Map
Create data visualizations with Gorgias data in Power Map.
-
Connect and Visualize Live Marketo Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Marketo data into the Databricks platform and create visualization dashboards with real-time Marketo data.
-
Bridge Shortcut Connectivity with Apache NiFi
Access and process Shortcut data in Apache NiFi using the CData JDBC Driver.
-
Build Google Search-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Search Results and create custom apps in Bubble.
-
Build a Singer.io Tap for Redis With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Redis data using the CData Python Connector.
-
Transfer Company File Data using the CData Excel Add-In
This article shows how to use the CData Excel Add-In for QuickBooks to transfer data from one company file to another. You will use the Excel Add-In to manage multiple connections and transfer customer records from one company file to another.
-
Visualize Sendwithus 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 Sendwithus data into TIBCO Spotfire.
-
Connect to PostgreSQL Data in RapidMiner
Integrate PostgreSQL data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect the Power BI Service to Marketo: Complete Guide
Connect to the CData Software Power BI Connector for Marketo from PowerBI.com to provide real-time Marketo data across the organization.
-
Process & Analyze ActiveCampaign Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ActiveCampaign Data.
-
Use Claude to Talk to Your Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Guru data for you.
-
Deploy the ADO.NET Provider for Elorus on an SSRS Report Server
Connect to Elorus data 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.
-
Build Apps with Live Oracle Service Cloud data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle Service Cloud data into the Adalo platform and build custom mobile and web applications with real-time Oracle Service Cloud data.
-
How to Connect to Live Salesforce Marketing 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 Salesforce Marketing data for you.
-
Migrating data from Grafana to Databricks using CData SSIS Components.
Easily push Grafana data to Databricks using the CData SSIS Tasks for Grafana and Databricks.
-
Build a Simple VCL Application for Google Cloud Storage Data
How to build a simple VCL Application to view Google Cloud Storage data in RAD Studio using the CData ODBC Driver for Google Cloud Storage.
-
Create a Data Access Object for VWO Data using JDBI
A brief overview of creating a SQL Object API for VWO data in JDBI.
-
Automate HBase Data Replication to Azure Synapse
Use CData Sync to customize and automate HBase data replication to Azure Synapse.
-
Connect to Front Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Front and the SQL Gateway to access Front data from Google Apps Script.
-
Deploy the ADO.NET Provider for LaunchDarkly on an SSRS Report Server
Connect to LaunchDarkly data 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.
-
Connecting Moonlit Workflow with Printify 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 Printify data in real time.
-
Use Grok to Talk to Your Odoo 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 Odoo data for you.
-
Automated Continuous Azure Data Lake Storage Replication to Vertica
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Vertica.
-
Integrating LangGraph with Act-On Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Act-On data within automated workflows.
-
Search External Mode Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Mode data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Mode Data objects that you can access from apps and the dashboard.
-
How to create an RPA flow for Workday Data in UiPath Studio
Use the Workday ODBC Driver to create workflows that access real-time Workday data without any coding.
-
Manage Cloudflare Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Cloudflare.
-
Connecting Mastra with Zoho Books 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 Zoho Books data, no replication required.
-
Design BIRT Reports on Parquet Data
Provide current Parquet data to your embedded analytics.
-
Use Agno to Talk to Your Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Salesforce data for you.
-
Feed Browserless Data into FineReport
How to set Browserless data as a JDBC data source in FineReport.
-
Build Charts with HBase Data in Clear Analytics
Create dynamic charts and perform analytics based on HBase data in Clear Analytics.
-
Enable the Zoom JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zoom data.
-
Integrate with Live Perplexity Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Perplexity from the MuleSoft Anypoint Platform to integrate live Perplexity data into custom reports and dashboards.
-
Visualize Live Cloudflare Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Cloudflare data.
-
Integrating Claude Code CLI with Coda 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.
-
Provide OData Services of Act CRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Act CRM data by developing a WCF Service Application.
-
Connect to Paymo Data in DBArtisan
Use wizards in DBArtisan to configure Paymo data as a data source.
-
Explore Geographical Relationships in AlloyDB Data with Power Map
Create data visualizations with AlloyDB data in Power Map.
-
Getting Started with the CData Tableau Connector for MailerSend
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Publish Sugar CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sugar CRM data.
-
Prepare, Blend, and Analyze Dynamics 365 Business Central Data in Alteryx Designer (Connect AI)
Build workflows to access live Dynamics 365 Business Central data for self-service data analytics.
-
Connecting GenSpark with Bitbucket Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Bitbucket data without any replication or custom integration required.
-
How to publish and share SageHR Data dashboards with Tableau Server
The CData ODBC driver for SageHR enables you integrate SageHR data into Tableau dashboards.
-
Easily Integrate DB2 Data in Lazarus Pascal IDE
Learn how to easily integrate live DB2 data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Automated Google Calendar-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Calendar data and build automated workflows in Zapier.
-
Automated Continuous ZendeskSell Replication to SQLite
Use CData Sync for automated, continuous, customizable ZendeskSell replication to SQLite.
-
Automated Continuous Redis Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Redis replication to Amazon S3.
-
Connect to GetResponse Data from HeidiSQL
Use CData Connect AI to connect to and query live GetResponse data from HeidiSQL.
-
Integrate with Salesforce Marketing Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Salesforce Marketing data in SnapLogic.
-
Integrate with live Trello Data in Jitterbit
Use CData Connect AI to connect to and integrate live Trello data in Jitterbit.
-
DataBind Stripe Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Stripe with the DevExpress Windows Forms and Web controls to provide Stripe data to a chart.
-
Visualize Live Wave Financial Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Wave Financial data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Manage Adobe Target Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Adobe Target.
-
Publish Crystal Reports on ConvertKit Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ConvertKit data.
-
Automated Continuous Sage Intacct Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sage Intacct replication to delimited files (CSV/TSV).
-
Automated Continuous SAP HANA XS Advanced Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Vertica.
-
How to connect and process Pipedrive data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pipedrive data.
-
Integrate with Vimeo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Vimeo data to a JSON file on disk.
-
Integrate Google's Vertex AI Agent with Live Email 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 Email data within intelligent workflows.
-
Connect Nuclia Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Nuclia data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Instagram Data from MySQL in PHP
Connect to Instagram through the standard MySQL libraries in PHP.
-
Connect to Mailgun Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Mailgun as an External Source in Dremio.
-
Automated Continuous Perplexity Replication to Vertica
Use CData Sync for automated, continuous, customizable Perplexity replication to Vertica.
-
Feed Oracle Data into FineReport
How to set Oracle data as a JDBC data source in FineReport.
-
Integrating Codex with CampaignMonitor 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.
-
Natively Connect to Monday.com Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Monday.com data. Leverage the native support for ODBC in PHP.
-
Connect to Keap Data in Ruby
Connect to Keap data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous CockroachDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable CockroachDB replication to PostgreSQL.
-
Integrate Vault CRM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Vault CRM data from Informatica Cloud.
-
Import Real-Time Toggl Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Toggl data in ColdFusion.
-
Automated Continuous HubSpot Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable HubSpot replication to PostgreSQL.
-
How to Connect Flowise AI Agents to Live Microsoft Exchange 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 Microsoft Exchange data without replication.
-
How to publish and share FormSite Data dashboards with Tableau Server
The CData ODBC driver for FormSite enables you integrate FormSite data into Tableau dashboards.
-
Hacker News Reporting in OBIEE with the Hacker News JDBC Driver
Deploy the Hacker News JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to create an RPA flow for Zoho CRM Data in UiPath Studio
Use the Zoho CRM ODBC Driver to create workflows that access real-time Zoho CRM data without any coding.
-
Create Data Visualizations Based On XML Data in Mode
Use CData Connect AI to connect to XML Data from Mode and build visualizations using live XML data.