CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Oracle Financials Cloud Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Oracle Financials Cloud data in ColdFusion.
-
Design BIRT Reports on Google Campaign Manager 360 Data
Provide current Google Campaign Manager 360 data to your embedded analytics.
-
How to connect to Lakebase Data in DBVisualizer
Integrate Lakebase data with visual data analysis tools and data connection wizards in DBVisualizer
-
Query Quickbase Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Quickbase entities in PHP by modeling them as objects.
-
Use the CData Software JDBC Driver for SAP Business Warehouse in MicroStrategy Web
Connect to SAP Business Warehouse data in MicroStrategy Web using the CData Software JDBC Driver for SAP Business Warehouse.
-
Import and Visualize Facebook Data in Power View
Create data visualizations based on Facebook data in Excel.
-
Integrating Claude Code with Xero Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Xero data within assisted coding and automated development workflows.
-
Edit and Search External Klaviyo Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Klaviyo data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Klaviyo Data objects that you can access from apps and the dashboard.
-
Connect to LightSpeedRetail 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 LightSpeedRetail and work with LightSpeedRetail data in your FileMaker application.
-
How to Access Live Freshservice Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Freshservice enables you to integrate Freshservice data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Devin with Live Samanage 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 Samanage data.
-
Connect to Omnisend Data in NetBeans
Connect to Omnisend data in NetBeans with the data source configuration wizard.
-
Replicate Multiple Paddle Accounts via the CData Sync CLI
Replicate multiple Paddle accounts to one or many databases.
-
Build Apps with Live Instantly Data Using the Low-Code Development Platform of Mendix
Connect Instantly data with Mendix to build apps using the CData API Driver for JDBC.
-
Query AlloyDB Data in DataGrip
Create a Data Source for AlloyDB in DataGrip and use SQL to query live AlloyDB data.
-
How to Connect to Live Splunk 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 Splunk data for you.
-
How to connect to Microsoft Dataverse Data in DBVisualizer
Integrate Microsoft Dataverse data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate with Live Microsoft Teams Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Teams from the MuleSoft Anypoint Platform to integrate live Microsoft Teams data into custom reports and dashboards.
-
Connect to QuickBooks Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live QuickBooks data.
-
Integrating OpenCode with Nethunt 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 connect to Jumpseller Data from Spring Boot
Connect to Jumpseller in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Exa from Asprova with CData Software ODBC Driver for Exa
This article shows how to connect faster to Exa data from Asprova.
-
Connect to Reckon Accounts Hosted Data in NetBeans
Connect to Reckon Accounts Hosted data in NetBeans with the data source configuration wizard.
-
How to Work with Salesforce Data in ETL Validator JDBC
Connect to Salesforce from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to Certinia Data in DBVisualizer
Integrate Certinia data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate with CouchDB Data in JReport Designer
Create charts and reports based on CouchDB data in JReport Designer.
-
Import Vault CRM Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Vault CRM Data and provide access to live Vault CRM data for custom reports in the Power BI Service.
-
Create Informatica Mappings From/To an ODBC Data Source for Short.io
Create an ODBC connection to Short.io in Informatica and browse and transfer Short.io data.
-
How to Connect to & Open Rebilly Data in Microsoft Excel
This article uses the CData ODBC driver for Rebilly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Salesforce Data 360-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Salesforce Data 360 Data from Klipfolio and build custom visualizations using live Salesforce Data 360 data.
-
Connect to FormSite Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time FormSite data using standard SQL.
-
Build Freshservice-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Freshservice data.
-
Connect to SAP Data in JRuby
Create a simple JRuby app with access to live SAP data.
-
Automated Continuous Square Replication to SingleStore
Use CData Sync for automated, continuous, customizable Square replication to SingleStore.
-
A PostgreSQL Interface for Autopilot Data (MySQL Remoting via JDBC)
Use the Remoting features of the Autopilot JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Outreach.io Data in JReport Designer
Create charts and reports based on Outreach.io data in JReport Designer.
-
Use ChatGPT to Talk to Your WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your WooCommerce data for you.
-
ETL Moosend in Oracle Data Integrator
This article shows how to transfer Moosend data into a data warehouse using Oracle Data Integrator.
-
Connect to Amazon DynamoDB Data from PowerBuilder via JDBC
This article demonstrates how to access Amazon DynamoDB data from PowerBuilder using the Amazon DynamoDB JDBC Driver.
-
Integrate Dify with Live CSV Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live CSV data.
-
Model SAP BusinessObjects BI Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP BusinessObjects BI, enabling the direct import of real-time SAP BusinessObjects BI data.
-
How to Connect to Live Vertica 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 Vertica data for you.
-
Integrate Tanda with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Tanda with External Services.
-
Connect to ZohoExpense from a Connection Pool in WebLogic
Use the CData JDBC Driver for ZohoExpense to connect to ZohoExpense data from Web applications running on WebLogic.
-
Create Active Directory Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Active Directory data access from reports, embedded analytics, and more.
-
Connect to Okta Data in NetBeans
Connect to Okta data in NetBeans with the data source configuration wizard.
-
Integrate Theia IDE with Live SendPulse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SendPulse data from within the development environment.
-
Integrate Live Asana 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 Asana data from within the IDE.
-
How to import Oracle Data into Apache Solr
Use the CData Software JDBC Driver for Oracle in Data Import Handler and create an automated import of Oracle data to Apache Solr Enterprise Search platform.
-
Integrate Google's Antigravity Agent with Live Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Office 365 data using the Model Context Protocol.
-
Create a Data Access Object for CircleCI Data using JDBI
A brief overview of creating a SQL Object API for CircleCI data in JDBI.
-
Build an OLAP Cube in SSAS from Databricks Data
Establish a connection to Databricks data data from SQL Server Analysis Services, and use the Databricks Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect Google Calendar to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Calendar data using the CData Python MCP Server.
-
Import Real-Time Azure DevOps Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Azure DevOps data in ColdFusion.
-
Connect to Landbot Data in RapidMiner
Integrate Landbot data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to SendInBlue Data from a Connection Pool in JBoss
Integrate SendInBlue data into Java servlets: Use the Management Console in JBoss to install the SendInBlue JDBC Driver.
-
Build MVC Applications with Connectivity to Xero Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Xero from an ASP.NET MVC application.
-
Import Real-Time Google Cloud Storage Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Cloud Storage data in ColdFusion.
-
Getting Started with the CData Python Connector for Tickspot
Learn to install and license the CData Python Connector and configure a connection to live Tickspot data.
-
How to Connect the Power BI Service to QuickBooks Time: Complete Guide
Connect to the CData Software Power BI Connector for QuickBooks Time from PowerBI.com to provide real-time QuickBooks Time data across the organization.
-
Connect to ScrapingBee Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ScrapingBee and the SQL Gateway to access ScrapingBee data from Google Apps Script.
-
How to Connect to Live Tavily 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 Tavily data for you.
-
Connect Exact Online Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Exact Online data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect Amazon QuickSight to Salesloft Data
Create a connection to Salesloft data in CData Connect AI and insert Salesloft data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Dashboards with Teradata Data in DBxtra
Create dynamic dashboards and perform analytics based on Teradata data in DBxtra.
-
Import and Visualize SAP Business Warehouse Data in Power View
Create data visualizations based on SAP Business Warehouse data in Excel.
-
Automated Continuous Missive Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Missive replication to Apache Cassandra.
-
Create Reports with Attio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Attio data.
-
Connecting Pipedream with Dynamics CRM 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 Dynamics CRM data in real time.
-
Build a PostgreSQL Interface for Perigon Data using the CData JDBC Driver
Use the Remoting features of the Perigon JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Azure AI Foundry to Talk to Your IBM Cloud Object Storage 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 IBM Cloud Object Storage data for you.
-
Connect to Spark Data in DBeaver
Use the CData ODBC Driver to connect to Spark data in DBeaver.
-
Integrate with Avalara AvaTax Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Avalara AvaTax data to a JSON file on disk.
-
Connect to Certinia in SpagoBI
Create reports featuring live Certinia data in SpagoBI Studio. Host Certinia reports on SpagoBI Server.
-
Visualize Google Sheets 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 Google Sheets data into TIBCO Spotfire.
-
How to connect and process ConstantContact data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ConstantContact data.
-
Import Real-Time Salesloft Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Salesloft data in ColdFusion.
-
Create SSAS Tabular Models from Facebook Ads Data
How to build a SQL Server Analysis Service Tabular Model from Facebook Ads data using CData drivers.
-
Build Automated Workflows with Live Vault CRM Data in Workato
Use CData Connect AI to connect to live Vault CRM data and build automated workflows in Workato.
-
Access FreshBooks Data from MySQL in Amazon QuickSight
Connect to FreshBooks and build visualizations of FreshBooks data using a MySQL Connection in Amazon QuickSight.
-
Connect to Google Contacts Data from a Connection Pool in JBoss
Integrate Google Contacts data into Java servlets: Use the Management Console in JBoss to install the Google Contacts JDBC Driver.
-
Integrating Boomi Agentstudio with QuickBooks Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to QuickBooks data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Oracle-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle data.
-
Access Square Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Square data from your Oracle system.
-
Connect to Act-On Data in DBArtisan
Use wizards in DBArtisan to configure Act-On data as a data source.
-
Build Voice Agents in ElevenLabs with access to Live ZohoMarketingHub Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ZohoMarketingHub data.
-
Replicate RabbitMQ Data to Multiple Databases via the CData Sync CLI
Replicate RabbitMQ data to disparate databases with a single configuration.
-
How to Connect to Live HDFS 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 HDFS data for you.
-
Integrating Claude Code CLI with MYOB AccountRight 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.
-
Work with SageHR Data in FoxPro
Load SageHR data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Twitter Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Google BigQuery.
-
Create Jumpseller Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Jumpseller data access from reports, embedded analytics, and more.
-
Build Apps with Live CircleCI Data Using the Low-Code Development Platform of Mendix
Connect CircleCI data with Mendix to build apps using the CData API Driver for JDBC.
-
Build Automated SurveyMonkey-Connected Workflows in Zapier
Use CData Connect AI to connect to live SurveyMonkey data and build automated workflows in Zapier.
-
Automated Continuous JotForm Replication to AlloyDB
Use CData Sync for automated, continuous, customizable JotForm replication to AlloyDB.
-
Integrating Claude Code CLI with Microsoft OneDrive 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.
-
Build MVC Applications with Connectivity to Bitbucket Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Bitbucket from an ASP.NET MVC application.
-
Integrate Live Freshteam Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Freshteam data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Automated Workflows with Live Dynamics 365 Business Central Data in Workato
Use CData Connect AI to connect to live Dynamics 365 Business Central data and build automated workflows in Workato.
-
Write a Simple Go Application to work with MailerSend Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MailerSend data.