CData Software - Knowledge Base
Recent Articles
-
Bridge Close Connectivity with Apache NiFi
Access and process Close in Apache NiFi using the CData JDBC Driver.
-
Integrate Live ChartMogul Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ChartMogul to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Feed DB2 Data into FineReport
How to set IBM DB2 as a JDBC data source in FineReport.
-
Build Apps with Live Campaigner Data Using the Low-Code Development Platform of Mendix
Connect Campaigner with Mendix to build apps using the CData API Driver for JDBC.
-
Create Dynamic SharePoint Excel Services Grids Using the Infragistics XamDataGrid
Learn how you can connect SharePoint Excel Services to Infragistics XamDataGrid to build dynamic grids.
-
Build Pipelines with Live Presto Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Presto from Google Cloud Data Fusion, enabling the integration of live Presto into the building and management of effective data pipelines.
-
Use the CData Software JDBC Driver for AdRoll in MicroStrategy Desktop
Connect to AdRoll in MicroStrategy Desktop using the CData Software JDBC Driver for AdRoll.
-
Integrate FormSite with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate FormSite with External Services.
-
Connect to Copper 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 Copper and work with Copper in your FileMaker application.
-
Rapidly Develop Klaviyo-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Klaviyo.
-
How to connect to Vercel Data from IntelliJ
Integrate connectivity to Vercel with wizards in IntelliJ.
-
Transfer data from Excel to QuickBooks using the CData Excel Add-In
This article explains how to transfer data from Excel to QuickBooks using the CData Excel Add-In for QuickBooks. For this example, we will use the Customers table;however, the same process will work for any table that can be retrieved by the Excel Add-In.
-
Build AI/ML Models with Live Printful Data using Dataiku
Connect Printful Data with Dataiku using the CData API Driver for JDBC.
-
Build Xero-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Xero to explore live Xero Data in Claude Code to assist with building Xero-powered applications.
-
Build Voice Agents in ElevenLabs with access to Live Google Sheets Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Sheets.
-
Integrating Cursor CLI with Microsoft Planner 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 Pipeliner CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Pipeliner CRM from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous Codat Replication to Snowflake
Use CData Sync for automated, continuous, customizable Codat replication to Snowflake.
-
Integrate Zoho Inventory Data into Power Automate Desktop using CData Connect
CData Connect for Zoho Inventory Data enables you to integrate Zoho Inventory into workflows built using Microsoft Power Automate Desktop.
-
Operational Reporting on ServiceNow Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ServiceNow.
-
Natively Connect to Cassandra Data in PHP
The CData ODBC driver for Cassandra enables you to create PHP applications with connectivity to Apache Cassandra. Leverage the native support for ODBC in PHP.
-
How to Connect to Live FTP 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 FTP Servers for you.
-
Connect to XML Data from PowerBuilder via JDBC
This article demonstrates how to access XML Files from PowerBuilder using the XML JDBC Driver.
-
How to Query Miro Data in MySQL Workbench
Execute MySQL queries against live Miro from MySQL Workbench.
-
Consume Adobe Analytics OData Feeds in PowerBuilder
This article demonstrates how to consume Adobe Analytics as OData feeds from PowerBuilder using the API Server.
-
Query Gmail Data as a MySQL Database in Node.js
Execute MySQL queries against Gmail from Node.js.
-
Use Agno to Talk to Your Microsoft Dataverse 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 Microsoft Dataverse (CDS) for you.
-
Integrate with SparkPost Data in JReport Designer
Create charts and reports based on SparkPost in JReport Designer.
-
Build an OLAP Cube in SSAS from Bannerbear Data
Establish a connection to Bannerbear data from SQL Server Analysis Services, and use the Bannerbear Data Provider to build OLAP cubes for use in analytics and reporting.
-
Provide OData Services of Pipedrive Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Pipedrive by developing a WCF Service Application.
-
Automated Continuous Power BI XMLA Replication to Databricks
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Databricks.
-
Create CockroachDB-Connected Business Apps in AppSheet
Connect to CockroachDB Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to CockroachDB.
-
How to connect to Bright Data Data in DBVisualizer
Integrate Bright Data with visual data analysis tools and data connection wizards in DBVisualizer
-
Establish a Live Connection with WordPress Data using Tableau Bridge
The CData ODBC Driver for WordPress enables you to integrate live WordPress into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Easily Query Moosend Data in OpenOffice Base
Connect to Moosend data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to SendInBlue Data from PowerBuilder via ADO.NET
This article demonstrates how to access SendInBlue from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to connect PolyBase to Bright Data
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Bright Data.
-
Extract, Transform, and Load FreeAgent Data in Informatica PowerCenter
Create a simple Workflow for FreeAgent in Informatica PowerCenter.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP Ariba Procurement
Provide connectivity to SAP Ariba Procurement through an SAP BusinessObjects universe.
-
Build a Singer.io Tap for SAP SuccessFactors With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP SuccessFactors data using
-
Create ZohoDesk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZohoDesk data access from reports, embedded analytics, and more.
-
Getting Started with the CData Power BI Connector for Pinecone
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use the CData SSIS Components to Insert New or Update Existing Box Records from SQL Server
Easily push SQL Server data to Box using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Box or update existing records with data from a SQL Server database.
-
Seamlessly Bring Oracle SCM Data into Retool Using CData Connect AI
Integrate Oracle SCM data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Raisers Edge NXT Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Raisers Edge NXT.
-
Create Dynamic Exa Grids Using the Infragistics XamDataGrid
Learn how you can connect Exa to Infragistics XamDataGrid to build dynamic grids.
-
Publish Reports with NASA Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date NASA.
-
Integrating Antigravity CLI with Codat via CData CLI
Connect Codat to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Work with Dynamics CRM Data in FoxPro
Load Microsoft Dynamics CRM into a FoxPro database. This article includes full code and a walk-through of the process.
-
Viewing Reply.io Data in RAD Studio Data Explorer
How to view Reply.io in RAD Studio Data Explorer using the CData ODBC Driver for Reply.io.
-
Automated Continuous Outreach.io Replication to SQLite
Use CData Sync for automated, continuous, customizable Outreach.io replication to SQLite.
-
Analyze Google Sheets Data in Cognos Analytics
Use CData Connect AI to connect to Google Sheets Data from Cognos Analytics and analyze live Google Sheets.
-
Connect to Real-Time HelloSign Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use HelloSign in Power Apps.
-
Create WordPress Dataflows on PowerBI.com
Connect to the CData Power BI Connector for WordPress from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Query Google Drive Data in MySQL Workbench
Execute MySQL queries against live Google Drive from MySQL Workbench.
-
Use JayDeBeApi to access SAP Hybris C4C Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP Hybris C4C.
-
Prepare, Blend, and Analyze Anaplan Data in Alteryx Designer (ODBC)
Build workflows to access live Anaplan for self-service data analytics.
-
Connecting Mastra with HBase 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 Apache HBase, no replication required.
-
A PostgreSQL Interface for Coinbase Data (MySQL Remoting via JDBC)
Use the Remoting features of the Coinbase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Add Samanage Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Samanage with the Informatica Enterprise Data Catalog to classify and organize data.
-
Analyze ScrapingBee Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ScrapingBee from Power Pivot. You will use the Table Import Wizard to load ScrapingBee. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Microsoft Teams Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Teams in the Denodo Virtual DataPort Administrator.
-
Access Factorial Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Factorial from your Oracle system.
-
How to Connect to Live Sage Cloud Accounting 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 Sage Business Cloud Accounting for you.
-
Integrating LlamaIndex with SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft SharePoint in real time.
-
Connect to Okta Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Okta.
-
Object-Relational Mapping (ORM) with GitLab Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to GitLab into a Java-based ORM framework, Hibernate.
-
Add Discord Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Discord with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous VWO Replication to Snowflake
Use CData Sync for automated, continuous, customizable VWO replication to Snowflake.
-
Integrating Cursor CLI with Close 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 OData Services in RapidMiner
Integrate OData with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Dashboards with Superchat Data in DBxtra
Create dynamic dashboards and perform analytics based on Superchat in DBxtra.
-
Connect to Apollo Data in DBArtisan
Use wizards in DBArtisan to configure Apollo as a data source.
-
Connect to SendGrid Data in ACL Analytics
Connect to SendGrid via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SendGrid.
-
Connect Intercom Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Intercom using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query Google Sheets Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Sheets from Node.js.
-
Build Semantic Layer Views for Google Sheets Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Sheets.
-
Connect to DB2 Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect Amazon QuickSight to ServiceNow Data
Create a connection to ServiceNow in CData Connect AI and insert ServiceNow into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Cloudflare Data in RazorSQL
Connect to Cloudflare from wizards and query Cloudflare from the GUI in the RazorSQL database management tool.
-
How to connect to Jodoo Data from Spring Boot
Connect to Jodoo in a Spring Boot Application using the CData API Driver for JDBC
-
Create ServiceNow Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ServiceNow from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Oracle Data from PowerBuilder via JDBC
This article demonstrates how to access Oracle Database from PowerBuilder using the Oracle JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Guru
Provide connectivity to Guru through an SAP BusinessObjects universe.
-
Migrating data from IBM Informix to Databricks using CData SSIS Components.
Easily push IBM Informix to Databricks using the CData SSIS Tasks for IBM Informix and Databricks.
-
Automated Continuous ChargeOver Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ChargeOver replication to AlloyDB.
-
Connect to Jumpseller Data from PowerBuilder via JDBC
This article demonstrates how to access Jumpseller from PowerBuilder using the Jumpseller JDBC Driver.
-
How to integrate Metabase with Freshdesk Data
Use CData Connect AI to connect to live Freshdesk and create an interactive dashboard in Metabase from Freshdesk.
-
Connect to and Query OData Services in QlikView over ODBC
Create data visualizations with OData in QlikView.
-
Use Grok to Talk to Your Oracle SCM 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 Oracle SCM for you.
-
Use Dash to Build to Web Apps on Supabase Data
Create Python applications that use pandas and Dash to build Supabase-connected web apps.
-
Use JayDeBeApi to access ZohoDesk Data in Python
Use standard Python scripting and the development environment of your choice to access live ZohoDesk.
-
Consume SAP HANA OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP HANA feeds that reflect any changes in SAP Lumira.
-
DataBind Aweber Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Aweber to a chart.
-
Create Dynamic Front Grids Using the Infragistics XamDataGrid
Learn how you can connect Front to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software ODBC Driver for BambooHR in MicroStrategy Desktop
Connect to BambooHR in MicroStrategy Desktop using the CData Software ODBC Driver for BambooHR.
-
Enable the Adobe Analytics JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Adobe Analytics.
-
How to Easily Query Notion Data in OpenOffice Base
Connect to Notion data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Replicate Multiple Phoenix Accounts
Replicate multiple Phoenix accounts to one or many databases.
-
How to import Basecamp Data into Apache Solr
Use the CData Software JDBC Driver for Basecamp in Data Import Handler and create an automated import of Basecamp to Apache Solr Enterprise Search platform.