CData Software - Knowledge Base
Recent Articles
-
Build Data Flows from AdRoll to SQL Server using SSIS
Easily back up AdRoll to SQL Server using the SSIS components for AdRoll.
-
How to load JobNimbus data into Elasticsearch via Logstash
Introducing a simple method to load JobNimbus data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect Amazon QuickSight to DB2 Data
Create a connection to IBM DB2 in CData Connect AI and insert IBM DB2 into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Work with SAP Ariba Procurement Data in AWS Glue Jobs Using JDBC
Connect to SAP Ariba Procurement from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to Live SAP HANA 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 SAP HANA for you.
-
Build Box-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Box Data from Zoho Analytics and import live Box.
-
Prepare, Blend, and Analyze Microsoft Planner Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Planner for self-service data analytics.
-
Connect to Delighted Data in Jaspersoft Studio
Execute SQL to remote Delighted in Jaspersoft Studio.
-
Visualize Live Azure Analysis Services Data in the Power BI Service
Use CData Connect AI to connect to live Azure Analysis Services and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Controls to JotForm Data in C++Builder
DataBind to JotForm in C++Builder with standard components and controls.
-
Query Live Jira 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 Atlassian Jira directly from the development environment.
-
Easily Integrate Superchat Data in Lazarus Pascal IDE
Learn how to easily integrate live Superchat in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Klaviyo Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Klaviyo from Filemaker Pro on Mac.
-
How to Query Aweber Data in MySQL Workbench
Execute MySQL queries against live Aweber from MySQL Workbench.
-
Choosing the Best Method to Connect ChargeOver to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ChargeOver from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate Email Data to Multiple Databases
Replicate Email to disparate databases with a point-and-click configuration.
-
Connect to SingleStore Data in RapidMiner
Integrate SingleStore with standard components and data source configuration wizards in RapidMiner Studio.
-
Provide OData Services of XML Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for XML Files by developing a WCF Service Application.
-
How to Easily Query ChartMogul Data in OpenOffice Base
Connect to ChartMogul data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Import Real-Time Optimizely Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Optimizely in ColdFusion.
-
Access Live Splunk Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Splunk into the statistical analysis tools available in SAS JMP. This article shows how to use Splunk in the Graph Builder and Query Builder.
-
Connect to SAP HANA XS Advanced Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP HANA XS Advanced in the Denodo Virtual DataPort Administrator.
-
Integrating Cursor CLI with Humanity 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.
-
Rapidly Develop Omnisend-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 Omnisend.
-
Getting Started with the CData ODBC Driver for ZohoMarketingHub
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZohoMarketingHub.
-
Connect to Apollo Data in Google Apps Script via Connect AI
Use CData Connect AI to access Apollo in Google Apps Script.
-
Using the CData Software ODBC Driver for SAP Fieldglass in PyCharm
Connect to SAP Fieldglass as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Fieldglass.
-
How to connect to Testmonitor Data from IntelliJ
Integrate connectivity to Testmonitor with wizards in IntelliJ.
-
How to Connect to Live Microsoft Planner 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 Microsoft Planner for you.
-
Integrate Azure Data Lake Storage Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure Data Lake Storage and integrate live Azure Data Lake Storage into your Power Automate tasks.
-
Automate ZeroBounce Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZeroBounce from PowerShell? This article demonstrates how to utilize the ZeroBounce Cmdlets for tasks like connecting to ZeroBounce, automating operations, downloading data, and more.
-
Moving Data from Webflow to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Webflow data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect and process ZendeskSell from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ZendeskSell.
-
Build AI/ML Models with Live Testmonitor Data using Dataiku
Connect Testmonitor Data with Dataiku using the CData API Driver for JDBC.
-
Connect to JotForm Data in JRuby
Create a simple JRuby app with access to live JotForm.
-
Build Voice Agents in ElevenLabs with access to Live SingleStore Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SingleStore.
-
Integrating Cursor CLI with SurveyMonkey 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.
-
Getting Started with the CData Power BI Connector for Dotmailer
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use the CData Software ODBC Driver for Adobe Commerce in MicroStrategy
Connect to Adobe Commerce in MicroStrategy Developer using the CData Software ODBC Driver for Adobe Commerce.
-
How to Access Live Flowlu Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Flowlu enables you to integrate Flowlu into workflows built using Microsoft Power Automate Desktop.
-
How to load Retently data into Elasticsearch via Logstash
Introducing a simple method to load Retently data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
DataBind Charts to Spotify Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Spotify 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 AI Agents with FTP Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live FTP Servers through CData Connect AI.
-
Import Avro Data Using Azure Data Factory
Use CData Connect AI to connect to Avro Data from Azure Data Factory and import live Apache Avro.
-
Connect to Avalara AvaTax Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Avalara AvaTax from Filemaker Pro on Mac.
-
Import and Visualize ClickTime Data in Power View
Create data visualizations based on ClickTime in Excel.
-
Build Apps with Live Instagram Data Using the Low-Code Development Platform of Mendix
Connect Instagram with Mendix to build apps using the CData JDBC Driver for Instagram.
-
Analyze Microsoft Planner Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft Planner and visualize live Microsoft Planner in Infragistics Reveal.
-
Connect to Jira Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Paddle Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Paddle.
-
Connect to IBM Cloud Object Storage Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for IBM Cloud Object Storage and the Script function in FileMaker Pro to connect to IBM Cloud Object Storage and work with IBM Cloud Object Storage in your FileMaker application.
-
How to import Mixpanel Data into Apache Solr
Use the CData Software JDBC Driver for Mixpanel in Data Import Handler and create an automated import of Mixpanel to Apache Solr Enterprise Search platform.
-
Create Vertica-Connected Applications in Appsmith
Connect to Vertica Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Vertica.
-
Visualize Live Microsoft Ads Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Ads using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Claude to Talk to Your Salesforce 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 Salesforce & Force.com for you.
-
Automate Salesloft Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Salesloft and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Add Tally Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Tally with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Create Power BI Visual Reports with Real-Time Webflow Data
Use CData Power BI Connectors to visualize Webflow in Power BI.
-
How to Work with RSS Feeds in ETL Validator JDBC
Connect to RSS from ETL Validator jobs using the CData Software JDBC Driver.
-
Work with Live Zendesk Data in Power Query
Use CData Connect AI to connect to Zendesk and work with live Zendesk in Microsoft Power Query.
-
Query Google Sheets Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Google Sheets and perform CRUD operations on Google Sheets from Node.js.
-
Connect to Freshservice Data from a Connection Pool in JBoss
Integrate Freshservice into Java servlets: Use the Management Console in JBoss to install the Freshservice JDBC Driver.
-
How to Connect to Live Snowflake 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 Snowflake for you.
-
Analyze Amazon DynamoDB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Amazon DynamoDB and visualize live Amazon DynamoDB in Infragistics Reveal.
-
Connect to Live Smartsheet Data in MicroStrategy through CData Connect AI
Create a live connection to Smartsheet Data in CData Connect AI and connect to your Smartsheet from MicroStrategy.
-
Bridge Freshteam Connectivity with Apache NiFi
Access and process Freshteam in Apache NiFi using the CData JDBC Driver.
-
Connect to Google Ads Data in DBeaver
Use the CData ODBC Driver to connect to Google Ads in DBeaver.
-
How to publish and share Microsoft Teams Data dashboards with Tableau Server
The CData ODBC driver for Microsoft Teams enables you integrate Microsoft Teams into Tableau dashboards.
-
Getting Started with the CData Power BI Connector for Reckon
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Reckon.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Reckon to Power BI dashboards. Simply drag and drop Reckon into data visuals on the Power BI canvas.
-
Unbounce Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Unbounce facts in real time.
-
Create Data Visualizations Based On SAP Concur Data in Mode
Use CData Connect AI to connect to SAP Concur Data from Mode and build visualizations using live
-
Integrating GitHub Copilot CLI with Everhour 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.
-
Access Live Yelp Data in Coginiti Pro
Connect to and query live Yelp from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze Exact Online Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Exact Online and visualize live Exact Online in Infragistics Reveal.
-
Configure the CData JDBC Driver for Freshteam in a Connection Pool in Tomcat
Connect to Freshteam from a connection pool in Tomcat.
-
How to connect Amazon QuickSight to Google Drive Data
Create a connection to Google Drive in CData Connect AI and insert Google Drive into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Airtable-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Airtable to explore live Airtable Data in GitHub Copilot to assist with building Airtable-powered applications.
-
Automated Continuous FormSite Replication to SQL Server
Use CData Sync for automated, continuous, customizable FormSite replication to SQL Server.
-
Create Instantly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Instantly data access from reports, embedded analytics, and more.
-
Feed Auth0 Data into FineReport
How to set Auth0 as a JDBC data source in FineReport.
-
Connect to Salesforce Data in Ruby
Connect to Salesforce & Force.com in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate Drip Data Replication to Azure Data Lake
Use CData Sync to customize and automate Drip replication to Azure Data Lake.
-
Create Tally Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Tally data access from reports, embedded analytics, and more.
-
Connect to Gong Data in CloverDX (formerly CloverETL)
Transfer Gong using the visual workflow in the CloverDX data integration tool.
-
Build Snapchat Ads-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Snapchat Ads to explore live Snapchat Ads Data in GitHub Copilot to assist with building Snapchat Ads-powered applications.
-
Connect and Visualize Live Azure Synapse Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure Synapse into the Databricks platform and create visualization dashboards with real-time Azure Synapse.
-
Bidirectional Access to Hugging Face Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Hugging Face in Filemaker Pro for Mac or Windows.
-
How to Work with NetSuite Data in AWS Glue Jobs Using JDBC
Connect to NetSuite from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Kintone Data in ACL Analytics
Connect to Kintone via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Kintone.
-
Connect to Freshsales Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Freshsales using standard SQL.
-
How to Work with QuickBooks Online Data in ETL Validator JDBC
Connect to QuickBooks Online from ETL Validator jobs using the CData Software JDBC Driver.
-
How to create SingleStore federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SingleStore in MySQL .
-
Query Outlook Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Outlook from Node.js.
-
Automated Continuous Wrike Replication to Snowflake
Use CData Sync for automated, continuous, customizable Wrike replication to Snowflake.
-
Access Live NetSuite Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate NetSuite CRM & ERP into the statistical analysis tools available in SAS JMP. This article shows how to use NetSuite CRM & ERP in the Graph Builder and Query Builder.
-
Connect to Impala Data from HeidiSQL
Use CData Connect AI to connect to and query live Apache Impala from HeidiSQL.
-
Edit and Search External ADP Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ADP to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ADP Data objects that you can access from apps and the dashboard.
-
Connect to Sugar CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sugar CRM from Appeon PowerBuilder using the CData ADO.NET Provider for Sugar CRM.
-
Getting Started with the CData JDBC Driver for ZohoMarketingHub
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ZohoMarketingHub.