CData Software - Knowledge Base
Recent Articles
-
How to work with Zoho CRM Data in Apache Spark using SQL
Access and process Zoho CRM Data in Apache Spark using the CData Software JDBC Driver.
-
How to load Webflow data into Elasticsearch via Logstash
Introducing a simple method to load Webflow data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to import GraphQL Data into Apache Solr
Use the CData Software JDBC Driver for GraphQL in Data Import Handler and create an automated import of GraphQL data to Apache Solr Enterprise Search platform.
-
Stream CloudConvert Data into Apache Kafka Topics
Access and stream CloudConvert data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access MariaDB Data from MySQL in Amazon QuickSight
Connect to MariaDB and build visualizations of MariaDB data using a MySQL Connection in Amazon QuickSight.
-
Connecting Moonlit Workflow with Google Drive 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 Google Drive data in real time.
-
Build Voice Agents in ElevenLabs with access to Live Act-On Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Act-On data.
-
Access Live SAP Ariba Source Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Ariba Source data from your Google Sheets.
-
Rapidly Develop AdRoll-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 AdRoll.
-
Back Up EmailOctopus data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with EmailOctopus data data.
-
Getting Started with the CData ADO.NET Provider for Jira
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Jira.
-
Easily Integrate CSV Data in Lazarus Pascal IDE
Learn how to easily integrate live CSV data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Work with Deel Data in ETL Validator JDBC
Connect to Deel from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Elasticsearch Data in DBeaver
Use the CData ODBC Driver to connect to Elasticsearch data in DBeaver.
-
Analyze PostgreSQL Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PostgreSQL data with the CData JDBC Driver for PostgreSQL.
-
How to import Freshsales Data into Apache Solr
Use the CData Software JDBC Driver for Freshsales in Data Import Handler and create an automated import of Freshsales data to Apache Solr Enterprise Search platform.
-
Integrate with Apollo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apollo data to a JSON file on disk.
-
Analyze Live Redis Data in SAS Viya
Use CData Connect AI to connect to Redis data from SAS Viya and deploy self-service analytics using live Redis data.
-
Visualize MySQL Data in TIBCO Spotfire through ADO.NET
Integrate MySQL data into dashboards in TIBCO Spotfire.
-
Create QuickBooks Online-Connected Nintex Workflows
Use CData Connect AI to connect to QuickBooks Online Data from Nintex Workflow Cloud and build custom workflows using live QuickBooks Online data.
-
Connect Zuora to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Zuora with IBM WebSphere for seamless data integration and connectivity.
-
Model, Search, and Visualize Live Act-On Data in ThoughtSpot
Use CData Connect AI to connect to live Act-On data for modeling, searching, and visualizing.
-
Import Real-Time ZohoDesk Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZohoDesk data in ColdFusion.
-
Query, Visualize, and Share live Facebook Ads Data in Redash
Use CData Connect AI to connect to live Facebook Ads data in Redash for querying, visualizing, and sharing.
-
Integrating LangGraph with RSS Feeds via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on RSS feeds within automated workflows.
-
Visualize Slack Data in Tableau
The CData ODBC driver for Slack enables you integrate Slack data into Tableau dashboards.
-
Query Opsgenie Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Opsgenie data from Node.js.
-
Create Freshteam-Connected Applications in Appsmith
Connect to Freshteam Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Freshteam data.
-
Automate Productboard Data Replication to Azure Data Lake
Use CData Sync to customize and automate Productboard data replication to Azure Data Lake.
-
Connect to SuiteCRM Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SuiteCRM Data and connect to SuiteCRM data in Akorbi Digital RunMyProcess.
-
Build MVC Applications with Connectivity to Google Campaign Manager 360 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Campaign Manager 360 from an ASP.NET MVC application.
-
Publish Crystal Reports on ServiceDesk Plus Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ServiceDesk Plus data.
-
Moving Data from Facebook to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Facebook data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Microsoft Entra ID in SpagoBI
Create reports featuring live Microsoft Entra ID data in SpagoBI Studio. Host Microsoft Entra ID reports on SpagoBI Server.
-
Visualize Beeminder 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 Beeminder data into TIBCO Spotfire.
-
Connect to Reckon from Asprova with CData Software ODBC Driver for Reckon
This article shows how to connect faster to Reckon data from Asprova.
-
Integrate OpenCode with Live Bannerbear Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Bannerbear data from within your AI coding agent.
-
How to connect to Salesforce Marketing Data in DBVisualizer
Integrate Salesforce Marketing data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Visualizations of Zoho Creator Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Creator data in Birst.
-
Excel Spreadsheet Automation on VWO Data with the QUERY Formula
Pull data from VWO, automate spreadsheets, and more with the QUERY formula.
-
Build MVC Applications with Connectivity to Billsby Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Billsby from an ASP.NET MVC application.
-
Publish Reports with Zoho Creator Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Creator data.
-
Build Splunk-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Splunk Data and create custom apps in Bubble.
-
Connect to SAP Business One Data in ACL Analytics
Connect to SAP Business One data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Business One data.
-
Connect to ServiceDesk Plus Data in Jaspersoft Studio
Execute SQL to remote ServiceDesk Plus data in Jaspersoft Studio.
-
Integrate xBase Data in Pentaho Data Integration
Build ETL pipelines based on xBase data in the Pentaho Data Integration tool.
-
Build Databricks-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Databricks Data and create custom apps in Bubble.
-
Query Coda Data as a MySQL Database in Node.js
Execute MySQL queries against Coda data from Node.js.
-
Build Amazon S3-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Amazon S3 Data from Zoho Analytics and import live Amazon S3 data.
-
Integrate Real-Time Access to Phoenix in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Phoenix data in real time.
-
How to Work with GraphQL Data in AWS Glue Jobs Using JDBC
Connect to GraphQL from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Live LinkedIn Ads Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live LinkedIn Ads data into custom reports in Power BI.
-
Connect to and Visualize Live Rebilly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Rebilly data.
-
Connect to ServiceDesk Plus Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ServiceDesk Plus and work with ServiceDesk Plus data in your FileMaker applications.
-
Visualize Live LeadDesk Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LeadDesk data.
-
Query Live FreshBooks Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live FreshBooks data directly from the development environment.
-
Build Agents in Relevance AI with Access to Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on QuickBooks Time data within intelligent agent workflows.
-
Connect SAP Business One to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Business One with IBM WebSphere for seamless data integration and connectivity.
-
Analyze ZohoExpense Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZohoExpense from Power Pivot. You will use the Table Import Wizard to load ZohoExpense data. You can visually build the import query or use any SQL supported by the driver.
-
Create Data Visualizations Based On Snapchat Ads Data in Mode
Use CData Connect AI to connect to Snapchat Ads Data from Mode and build visualizations using live Snapchat Ads data.
-
Integrate Live RabbitMQ Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live RabbitMQ data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating Kiro with PabblySubscriptions 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 BigQuery Data from a Connection Pool in JBoss
Integrate BigQuery data into Java servlets: Use the Management Console in JBoss to install the BigQuery JDBC Driver.
-
How to Build an ETL App for Avro Data in Python with CData
Create ETL applications and real-time data pipelines for Avro data in Python with petl.
-
How to Use a Microsoft Access Database to Update SAP Netweaver Gateway Data in Real Time
Update SAP Netweaver Gateway data by creating a linked table in Microsoft Access with the CData SAP Netweaver Gateway ODBC Driver.
-
Establish a Live Connection with Reply.io Data using Tableau Bridge
The CData ODBC Driver for Reply.io enables you to integrate live Reply.io data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to CapsuleCRM Data from a Connection Pool in JBoss
Integrate CapsuleCRM data into Java servlets: Use the Management Console in JBoss to install the CapsuleCRM JDBC Driver.
-
Integrate Live MailerLite Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MailerLite data and integrate live MailerLite data into apps built in Microsoft Power Apps.
-
How to connect to RSS Feeds in DBVisualizer
Integrate RSS feeds with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Figshare Replication to SQL Server
Use CData Sync for automated, continuous, customizable Figshare replication to SQL Server.
-
How to Query Google Forms Data in MySQL Workbench
Execute MySQL queries against live Google Forms data from MySQL Workbench.
-
Access Live Microsoft Ads Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Ads data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Theia IDE with Live Email 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 Email data from within the development environment.
-
Automated Continuous Impala Replication to Vertica
Use CData Sync for automated, continuous, customizable Impala replication to Vertica.
-
Create MarkLogic-Connected Applications in Appsmith
Connect to MarkLogic Data via CData Connect AI in Appsmith and create custom business applications with real-time access to MarkLogic data.
-
Access Live SAP Ariba Procurement Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Ariba Procurement data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Active Directory from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Active Directory data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Dashboards with Suadeo Data in DBxtra
Create dynamic dashboards and perform analytics based on Suadeo data in DBxtra.
-
Viewing IBM Informix Data in RAD Studio Data Explorer
How to view IBM Informix data in RAD Studio Data Explorer using the CData ODBC Driver for IBM Informix.
-
Use the CData ODBC Driver for Raisers Edge NXT from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Raisers Edge NXT to connect to Raisers Edge NXT data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Raisers Edge NXT data in Excel.
-
Visualize Live MailerLite Data in the Power BI Service
Use CData Connect AI to connect to live MailerLite data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Gmail Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Gmail and the Script function in FileMaker Pro to connect to Gmail and work with Gmail data in your FileMaker application.
-
Connect to Cvent Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Cvent to connect to Cvent data and execute queries in PowerBuilder.
-
Automated JobNimbus Data Replication to Teradata
Use CData Sync to Customize and automate JobNimbus data replication to Teradata.
-
Access Live RSS Feeds in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live RSS feeds from your Excel spreadsheets.
-
Visualize Facebook Ads Data in Sisense
Create an ElastiCube in Sisense app with access to Facebook Ads data.
-
Create ClickTime Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ClickTime from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Dashboards with Factorial Data in Dundas BI
Create dynamic dashboards and perform analytics based on Factorial data in Dundas BI.
-
Integrate with Live ActiveCampaign Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ActiveCampaign from the MuleSoft Anypoint Platform to integrate live ActiveCampaign data into custom reports and dashboards.
-
ETL SFTP in Oracle Data Integrator
This article shows how to transfer SFTP data into a data warehouse using Oracle Data Integrator.
-
Connect to ZohoInvoice Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ZohoInvoice data using standard SQL.
-
Access ConvertAPI Data from MySQL in Amazon QuickSight
Connect to ConvertAPI and build visualizations of ConvertAPI data using a MySQL Connection in Amazon QuickSight.
-
Connect to Deel from Asprova with CData Software ODBC Driver for Deel
This article shows how to connect faster to Deel data from Asprova.
-
Build a PostgreSQL Interface for eBay Data using the CData JDBC Driver
Use the Remoting features of the eBay JDBC Driver to create a PostgreSQL entry-point for data access.
-
ETL Excel Online in Oracle Data Integrator
This article shows how to transfer Excel Online data into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData Power BI Connector for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build AI/ML Models with Live Salesforce Marketing Data using Dataiku
Connect Salesforce Marketing Data with Dataiku using the CData JDBC Driver for Salesforce Marketing.
-
Integrate Cline with Live HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live HCL Domino data from within your IDE.
-
Seamlessly Bring SAP Concur Data into Retool Using CData Connect AI
Integrate SAP Concur data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use Microsoft Copilot Studio to talk to your Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Apollo data for you.