CData Software - Knowledge Base
Recent Articles
-
How to Connect DBeaver to PDFMonkey via a JDBC Driver
Manage PDFMonkey data with visual tools in DBeaver like the query browser.
-
Analyze Trello Data in Cognos Analytics
Use CData Connect AI to connect to Trello Data from Cognos Analytics and analyze live Trello data.
-
Visualize Live Odoo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Odoo data into custom reports in Power BI.
-
How to Easily Query Clockify Data in OpenOffice Base
Connect to Clockify data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Create Power BI Visual Reports with Real-Time HubSpot Data
Use CData Power BI Connectors to visualize HubSpot data in Power BI.
-
Build Greenhouse Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Greenhouse data and build visualizations in Tableau Cloud.
-
Import and Visualize Hive Data in Power View
Create data visualizations based on Hive data in Excel.
-
Access Live Zoho Books Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoho Books data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to import SAP SuccessFactors Data into Apache Solr
Use the CData Software JDBC Driver for SAP SuccessFactors in Data Import Handler and create an automated import of SAP SuccessFactors data to Apache Solr Enterprise Search platform.
-
Import Real-Time LinkedIn Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use LinkedIn data in ColdFusion.
-
Integrate Twilio Data in Pentaho Data Integration
Build ETL pipelines based on Twilio data in the Pentaho Data Integration tool.
-
How to Work with MongoDB Data in ETL Validator JDBC
Connect to MongoDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Automated SendGrid-Connected Workflows in Zapier
Use CData Connect AI to connect to live SendGrid data and build automated workflows in Zapier.
-
Connect to Samanage Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Samanage data from Filemaker Pro on Mac.
-
How to Connect to Live Discord Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Discord data for you.
-
Integrate Eventbrite with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Eventbrite with External Services.
-
How to Easily Query ZohoDesk Data in OpenOffice Base
Connect to ZohoDesk data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Query Azure Analysis Services Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Azure Analysis Services entities in PHP by modeling them as objects.
-
DataBind Charts to Square Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Square 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.
-
Connect to ConvertAPI Data in Jaspersoft Studio
Execute SQL to remote ConvertAPI data in Jaspersoft Studio.
-
Connecting GenSpark with Gmail Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Gmail data without any replication or custom integration required.
-
How to Work with Flowlu Data in ETL Validator JDBC
Connect to Flowlu from ETL Validator jobs using the CData Software JDBC Driver.
-
DataBind iContact Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide iContact data to a chart.
-
Use CData Connect AI to Access SuiteCRM Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SuiteCRM data in the Power Pivot business intelligence tool.
-
Connect to Perplexity Data in Aqua Data Studio
Access Perplexity data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Extract, Transform, and Load Egnyte Data in Informatica PowerCenter
Create a simple Workflow for Egnyte data in Informatica PowerCenter.
-
Configure the CData JDBC Driver for SageHR in a Connection Pool in Tomcat
Connect to SageHR data from a connection pool in Tomcat.
-
Integrating LangChain with Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Box data within automated workflows.
-
Automated Continuous Harvest Replication to Vertica
Use CData Sync for automated, continuous, customizable Harvest replication to Vertica.
-
Connect to iContact Data in Jaspersoft Studio
Execute SQL to remote iContact data in Jaspersoft Studio.
-
Connect to ConvertAPI Data in JRuby
Create a simple JRuby app with access to live ConvertAPI data.
-
Integrating LangGraph with Salesforce Marketing Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Salesforce Marketing data within automated workflows.
-
Getting Started with the CData JDBC Driver for Short.io
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Short.io.
-
Create Amazon DynamoDB-Connected Applications in Appsmith
Connect to Amazon DynamoDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Amazon DynamoDB data.
-
Access Live Workday Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Workday data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Epicor Kinetic Data in ACL Analytics
Connect to Epicor Kinetic data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Epicor Kinetic data.
-
Natively Connect to Aircall Data in PHP
The CData ODBC driver for Aircall enables you to create PHP applications with connectivity to Aircall data. Leverage the native support for ODBC in PHP.
-
Create Aircall Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Aircall from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Google Spanner Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Spanner replication to MongoDB.
-
Automated Continuous SAP Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP replication to SQLite.
-
How to Query Live Apollo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apollo data data in natural language using Python.
-
Working with Discourse Data in LINQPad
Execute LINQ queries to Discourse data in LINQPad.
-
How to work with Brex Data in Apache Spark using SQL
Access and process Brex Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate with Live TaxJar Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to TaxJar from the MuleSoft Anypoint Platform to integrate live TaxJar data into custom reports and dashboards.
-
Connect to Codat Data in RazorSQL
Connect to Codat from wizards and query Codat data from the GUI in the RazorSQL database management tool.
-
Connect to Azure Data Catalog Data in Ruby
Connect to Azure Data Catalog data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connecting GenSpark with Mailgun Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Mailgun data without any replication or custom integration required.
-
How to Access Exact Online Data Using Entity Framework
This article shows how to access Exact Online data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connecting Agentforce with SAP Business Warehouse 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 SAP Business Warehouse data for you.
-
Configure the CData JDBC Driver for Oracle Service Cloud in a Connection Pool in Tomcat
Connect to Oracle Service Cloud data from a connection pool in Tomcat.
-
Connect to Kafka Data from a Connection Pool in Jetty
The Kafka JDBC Driver supports connection pooling: This article shows how to connect faster to Kafka data from Web apps in Jetty.
-
Build Google Drive-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Drive data.
-
Visualize BenchmarkEmail Data in Tableau
The CData ODBC driver for BenchmarkEmail enables you integrate BenchmarkEmail data into Tableau dashboards.
-
Explore Geographical Relationships in Google Contacts Data with Power Map
Create data visualizations with Google Contacts data in Power Map.
-
Build Cvent-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Cvent Data from Zoho Analytics and import live Cvent data.
-
Integrating Gumloop with GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on GitHub data within automated workflows.
-
Enable the LightSpeedRetail JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with LightSpeedRetail data.
-
Connect to Oracle Eloqua Data from PowerBuilder via JDBC
This article demonstrates how to access Oracle Eloqua data from PowerBuilder using the Oracle Eloqua JDBC Driver.
-
Getting Started with the CData SSIS Components for Paylocity
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Paylocity.
-
Automated Continuous Outreach.io Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Outreach.io replication to Apache Kafka.
-
Connect to Salesloft Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Salesloft.
-
DataBind Charts to ScrapingBee Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ScrapingBee 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.
-
Build Tanda-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Tanda data and build web apps with connectivity to live Tanda data.
-
Create Workday-Connected Applications in Appsmith
Connect to Workday Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Workday data.
-
Automated Continuous Salesforce Pardot Replication to MongoDB
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to MongoDB.
-
Integrate Real-Time Access to Sybase IQ in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sybase IQ data in real time.
-
Build a PostgreSQL Interface for SQL Analysis Services Data using the CData JDBC Driver
Use the Remoting features of the SQL Analysis Services JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Query CloudConvert Data in QlikView over ODBC
Create data visualizations with CloudConvert data in QlikView.
-
DataBind Vercel Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Vercel data to a chart.
-
Publish ElevenLabs-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ElevenLabs data.
-
Automated Continuous Cosmos DB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Apache Kafka.
-
How to connect SharePoint with PostgreSQL Data through external lists
Provide PostgreSQL data to SharePoint users as an external list.
-
Connect to Wave Financial from Asprova with CData Software ODBC Driver for Wave Financial
This article shows how to connect faster to Wave Financial data from Asprova.
-
Import Real-Time SAP BusinessObjects BI Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP BusinessObjects BI data in ColdFusion.
-
Use Biml to Build SSIS Tasks to Replicate Google Search Results to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Search results to SQL Server.
-
How to Access Live SAS xpt Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAS xpt enables you to integrate SAS xpt data into workflows built using Microsoft Power Automate Desktop.
-
Access Live HubDB Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live HubDB data through MCP integration.
-
Connect to PingOne Data in NetBeans
Connect to PingOne data in NetBeans with the data source configuration wizard.
-
How to Connect the Power BI Service to Klaviyo: Complete Guide
Connect to the CData Software Power BI Connector for Klaviyo from PowerBI.com to provide real-time Klaviyo data across the organization.
-
Automate RSS Feeds Replication to Couchbase
Use CData Sync to Customize and automate RSS feeds replication to Couchbase.
-
Connect to SQL Server Data from Crystal Reports
Use CData Connect AI to connect to and report on live SQL Server data from Crystal Reports.
-
How to connect Amazon QuickSight to Wistia Data
Create a connection to Wistia data in CData Connect AI and insert Wistia data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Trae with Live ServiceDesk Plus Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ServiceDesk Plus data from within the AI-powered IDE.
-
Automated Continuous ZohoExpense Replication to Databricks
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Databricks.
-
Integrate Elorus with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Elorus with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Elorus data.
-
Automated Continuous PagerDuty Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable PagerDuty data replication to OneLake in Microsoft Fabric.
-
How to create Visio diagrams from Splunk Data
Automatically update Splunk data with the changes you make to Visio master shapes.
-
How to Connect to Live ServiceDesk Plus 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 ServiceDesk Plus data for you.
-
Connect to Live SAP SuccessFactors Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP SuccessFactors in CData Connect AI and connect to your SAP SuccessFactors data from PostgreSQL.
-
Interact with Live SparkPost Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SparkPost data.
-
Access Live Azure DevOps Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Azure DevOps data through MCP integration.
-
Access NASA Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access NASA data from your Oracle system.
-
How to Work with ADP Data in ETL Validator JDBC
Connect to ADP from ETL Validator jobs using the CData Software JDBC Driver.
-
Provide OData Services of Chargebee Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Chargebee data by developing a WCF Service Application.
-
Query Todoist Data in DataGrip
Create a Data Source for Todoist in DataGrip and use SQL to query live Todoist data.
-
How to Connect to & Open Raisers Edge NXT Data in Microsoft Excel
This article uses the CData ODBC driver for Raisers Edge NXT to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live ClickUp Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ClickUp data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automate Billsby Data Replication to Azure Synapse
Use CData Sync to customize and automate Billsby data replication to Azure Synapse.
-
Create Reports with Epicor Kinetic Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Epicor Kinetic data.
-
Visualize Live Oracle Service Cloud Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Oracle Service Cloud data into custom reports in Power BI.