CData Software - Knowledge Base
Recent Articles
-
Replicate Reckon Accounts Hosted Data from PowerShell
Write a quick PowerShell script to query Reckon Accounts Hosted data. Use connectivity to the live data to replicate Reckon Accounts Hosted data to SQL Server.
-
Connect to CloudConvert Data in RapidMiner
Integrate CloudConvert data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for Sybase in MicroStrategy Web
Connect to Sybase data in MicroStrategy Web using the CData Software ODBC Driver for Sybase.
-
Connect to Odoo Data in JRuby
Create a simple JRuby app with access to live Odoo data.
-
Connect to Freshdesk Data in HULFT Integrate
Connect to Freshdesk as a JDBC data source in HULFT Integrate
-
Build MVC Applications with Connectivity to Templated Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Templated from an ASP.NET MVC application.
-
Load Jodoo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Jodoo data to a database.
-
Build Voice Agents in ElevenLabs with access to Live Amazon S3 Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Amazon S3 data.
-
How to import MongoDB Data into Apache Solr
Use the CData Software JDBC Driver for MongoDB in Data Import Handler and create an automated import of MongoDB data to Apache Solr Enterprise Search platform.
-
Getting Started with the CData ODBC Driver for Sage Intacct
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sage Intacct.
-
Prepare, Blend, and Analyze SurveyMonkey Data in Alteryx Designer (Connect AI)
Build workflows to access live SurveyMonkey data for self-service data analytics.
-
Deploy the ADO.NET Provider for Float on an SSRS Report Server
Connect to Float data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to Airtable Data in NetBeans
Connect to Airtable data in NetBeans with the data source configuration wizard.
-
Automate Sage Intacct Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sage Intacct data replication to Azure Data Lake.
-
Extract, Transform, and Load ZeroBounce Data in Informatica PowerCenter
Create a simple Workflow for ZeroBounce data in Informatica PowerCenter.
-
Build Semantic Layer Views for MailerLite Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for MailerLite data.
-
Connecting Pipedream with Slack 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 Slack data in real time.
-
Provide OData Services of Scrapfly Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Scrapfly data by developing a WCF Service Application.
-
Automated Continuous Oracle Eloqua Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Google BigQuery.
-
Getting Started with the CData ADO.NET Provider for Salesloft
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Salesloft.
-
Integrate Elorus Data in Pentaho Data Integration
Build ETL pipelines based on Elorus data in the Pentaho Data Integration tool.
-
Query Google Search Results as a SQL Server Database in Node.js
Execute SQL Server queries against Google Search results from Node.js.
-
Use Dash to Build Web Apps on MailChimp Data via CData Connect AI
Build interactive Dash web apps on live MailChimp data using pandas and the CData Connect AI Python SDK.
-
Integrate Live ZohoDesk Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to ZohoDesk from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live ZohoDesk data.
-
Access Live MySQL Data in Excel 365 Online (Excel for the web)
Connect to MySQL data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Microsoft Exchange Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Microsoft Exchange.
-
Operational Reporting on MessageBird Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote MessageBird data.
-
Connect to ShipStation Data from PowerBuilder via ADO.NET
This article demonstrates how to access ShipStation data from Appeon PowerBuilder using the CData ADO.NET Provider for ShipStation.
-
Create Mailjet-Connected Dashboards in Grafana
Connect to Mailjet Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Mailjet data.
-
Integrating Claude Code CLI with SQL Analysis Services 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.
-
Create Avro-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Avro Data from Klipfolio and build custom visualizations using live Avro data.
-
How to Work with DB2 Data in AWS Glue Jobs Using JDBC
Connect to DB2 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Zendesk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zendesk data access from reports, embedded analytics, and more.
-
Consume Oracle Eloqua Reporting OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle Eloqua Reporting feeds that reflect any changes in SAP Lumira.
-
Access RabbitMQ 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 RabbitMQ data.
-
Build Dashboards with Greenhouse Data in DBxtra
Create dynamic dashboards and perform analytics based on Greenhouse data in DBxtra.
-
Build Grafana Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Grafana data and build visualizations in Tableau.
-
Manage BambooHR Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for BambooHR.
-
Query Live SQL Server 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 SQL Server data directly from the development environment.
-
How to load Blackbaud FE NXT data into Elasticsearch via Logstash
Introducing a simple method to load Blackbaud FE NXT data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Back Up Neo4J data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Neo4J. In this article, we will employ an SSIS workflow to populate a database with Neo4J data data.
-
Use Dash to Build to Web Apps on Apify Data
Create Python applications that use pandas and Dash to build Apify-connected web apps.
-
Easily Integrate BigCommerce Data in Lazarus Pascal IDE
Learn how to easily integrate live BigCommerce data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Add ElevenLabs Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ElevenLabs with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software ODBC Driver for Jira Assets in MicroStrategy
Connect to Jira Assets data in MicroStrategy Developer using the CData Software ODBC Driver for Jira Assets.
-
Query Live PostgreSQL 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 PostgreSQL data directly from the development environment.
-
Import Real-Time Greenplum Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Greenplum data in ColdFusion.
-
Integrating Claude Code with Zendesk Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zendesk data within assisted coding and automated development workflows.
-
How to work with Apollo Data in Apache Spark using SQL
Access and process Apollo Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Adobe Analytics in SAS for Real-Time Reporting and Analytics
Connect to real-time Adobe Analytics data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Adobe Analytics.
-
Build CockroachDB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live CockroachDB data and build visualizations in Tableau.
-
Build Visualizations of Clockify Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Clockify data in Birst.
-
Query Pingdom Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Pingdom data from Node.js.
-
Integrate Devin with Live Kafka 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 Kafka data.
-
Connect and Query Live Azure DevOps Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure DevOps data into Databricks and enable direct, live querying and analysis without replication.
-
Replicate Multiple Customer.io Accounts
Replicate multiple Customer.io accounts to one or many databases.
-
Easily Integrate Google Ads Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Ads data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous SAP HANA XS Advanced Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Google BigQuery.
-
Feed Spotify Data into FineReport
How to set Spotify data as a JDBC data source in FineReport.
-
Configure the CData JDBC Driver for Google Calendar in a Connection Pool in Tomcat
Connect to Google Calendar data from a connection pool in Tomcat.
-
How to Seamlessly Import Jodoo Data into IBM SPSS Modeler
Integrate Jodoo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Greenhouse-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Greenhouse data without replication.
-
Import and Visualize Salesforce Marketing Data in Power View
Create data visualizations based on Salesforce Marketing data in Excel.
-
Use the CData ODBC Driver for Freshteam from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Freshteam to connect to Freshteam data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Freshteam data in Excel.
-
Build Apps with Live Toggl Data Using the Low-Code Development Platform of Mendix
Connect Toggl data with Mendix to build apps using the CData API Driver for JDBC.
-
How to Work with Sybase IQ Data in AWS Glue Jobs Using JDBC
Connect to Sybase IQ from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build IBM Cloud Object Storage-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live IBM Cloud Object Storage data and build IBM Cloud Object Storage-connected web apps with Axios.
-
Build Outreach.io-Connected Apps in Choreo
Use CData Connect AI to connect to Outreach.io Data from Choreo and build custom apps using live Outreach.io data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Opsgenie
Provide connectivity to Opsgenie data through an SAP BusinessObjects universe.
-
Create SSAS Tabular Models from Amplitude Data
How to build a SQL Server Analysis Service Tabular Model from Amplitude data using CData drivers.
-
Integrating OpenCode with Box 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.
-
Use Microsoft Copilot Studio to talk to your Zuora 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 Zuora data for you.
-
Integrate with Productboard Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Productboard data to a JSON file on disk.
-
Work with Notion Data in FoxPro
Load Notion data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Prepare, Blend, and Analyze Sybase IQ Data in Alteryx Designer (ODBC)
Build workflows to access live Sybase IQ data for self-service data analytics.
-
Use the CData ODBC Driver for Nethunt from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Nethunt to connect to Nethunt data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Nethunt data in Excel.
-
Automated Continuous SAP Business One Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Business One replication to Amazon S3.
-
Use the CData Software ODBC Driver for Hubstaff in MicroStrategy Desktop
Connect to Hubstaff data in MicroStrategy Desktop using the CData Software ODBC Driver for Hubstaff.
-
Integrate Open WebUI with Live OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live OneNote data from within the chat interface.
-
Integrate Trae with Live Blackbaud FE NXT Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Blackbaud FE NXT data from within the AI-powered IDE.
-
Validate ConstantContact Data with QuerySurge
Access and validate ConstantContact data in QuerySurge using the CData JDBC Driver.
-
Integrate with ADP Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ADP data to a JSON file on disk.
-
Enable the DocuSign JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with DocuSign data.
-
Build Voice Agents in ElevenLabs with access to Live Xero Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Xero data.
-
How to Easily Query Pinterest Data in OpenOffice Base
Connect to Pinterest data in OpenOffice Base using the CData ODBC Driver for Pinterest and generate reports with live data insights.
-
Bridge Xero Connectivity with Apache NiFi
Access and process Xero data in Apache NiFi using the CData JDBC Driver.
-
Model GitLab Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and GitLab, enabling the direct import of real-time GitLab data.
-
A PostgreSQL Interface for Monday.com Data (MySQL Remoting via JDBC)
Use the Remoting features of the Monday.com JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Real-Time Microsoft Ads Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Ads data in ColdFusion.
-
Automate LaunchDarkly Data Replication to Couchbase
Use CData Sync to Customize and automate LaunchDarkly data replication to Couchbase.
-
Visualize Cassandra Data in TIBCO Spotfire through ADO.NET
Integrate Cassandra data into dashboards in TIBCO Spotfire.
-
Connect to Box from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Box data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Explore Geographical Relationships in Microsoft OneDrive Data with Power Map
Create data visualizations with Microsoft OneDrive data in Power Map.
-
Replicate Multiple Moosend Accounts via the CData Sync CLI
Replicate multiple Moosend accounts to one or many databases.
-
How to Work with Microsoft Dataverse Data in ETL Validator JDBC
Connect to Microsoft Dataverse from ETL Validator jobs using the CData Software JDBC Driver.
-
How to integrate Metabase with Amazon Marketplace Data
Use CData Connect AI to connect to live Amazon Marketplace data and create an interactive dashboard in Metabase from Amazon Marketplace data.
-
Replicate SAP HANA Data to Multiple Databases via the CData Sync CLI
Replicate SAP HANA data to disparate databases with a single configuration.
-
How to integrate Metabase with Act-On Data
Use CData Connect AI to connect to live Act-On data and create an interactive dashboard in Metabase from Act-On data.
-
Connect to and Query Dynamics 365 Data in QlikView over ODBC
Create data visualizations with Dynamics 365 data in QlikView.
-
Use the CData Software ODBC Driver for Microsoft Entra ID in MicroStrategy Web
Connect to Microsoft Entra ID data in MicroStrategy Web using the CData Software ODBC Driver for Microsoft Entra ID.