CData Software - Knowledge Base
Recent Articles
-
Create ZarMoney Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ZarMoney from PowerBI.com to create Power BI Dataflows with real-time data.
-
Configure the CData JDBC Driver for Sentry in a Connection Pool in Tomcat
Connect to Sentry data from a connection pool in Tomcat.
-
How to publish and share WordPress Data dashboards with Tableau Server
The CData ODBC driver for WordPress enables you integrate WordPress data into Tableau dashboards.
-
How to Connect to Dotmailer Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Dotmailer data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Everhour Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Everhour and the SQL Gateway to access Everhour data from Google Apps Script.
-
How to Build an ETL App for GitLab Data in Python with CData
Create ETL applications and real-time data pipelines for GitLab data in Python with petl.
-
Build Apps with Live Azure Analysis Services data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Azure Analysis Services data into the Adalo platform and build custom mobile and web applications with real-time Azure Analysis Services data.
-
How to import Optimizely Data into Apache Solr
Use the CData Software JDBC Driver for Optimizely in Data Import Handler and create an automated import of Optimizely data to Apache Solr Enterprise Search platform.
-
Connect and Query Live Airtable Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Airtable data into Databricks and enable direct, live querying and analysis without replication.
-
Access Live Cohere Data in AWS Lambda
Connect to live Cohere data in AWS Lambda using the CData JDBC Driver.
-
How to Access Live Wistia Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Wistia enables you to integrate Wistia data into workflows built using Microsoft Power Automate Desktop.
-
Integrating LangChain with Wistia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Wistia data within automated workflows.
-
Use Azure AI Foundry to Talk to Your SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAP Ariba Source data for you.
-
Use the CData Software JDBC Driver for Pinterest in MicroStrategy Desktop
Connect to Pinterest data in MicroStrategy Desktop using the CData Software JDBC Driver for Pinterest.
-
Connect to Hacker News Data in DBeaver
Use the CData ODBC Driver to connect to Hacker News data in DBeaver.
-
Create Power BI Reports on Real-Time Outreach.io Data
Use the CData ODBC Driver for Outreach.io to visualize Outreach.io data in Power BI Desktop.
-
Work with Mouseflow Data in FoxPro
Load Mouseflow data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Voice Agents in ElevenLabs with access to Live Airtable Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Airtable data.
-
Connect to Mouseflow Data in JRuby
Create a simple JRuby app with access to live Mouseflow data.
-
Connect to Clockify Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Clockify data using standard SQL.
-
Configure the CData JDBC Driver for Procore in a Connection Pool in Tomcat
Connect to Procore data from a connection pool in Tomcat.
-
Prepare, Blend, and Analyze Oracle HCM Cloud Data in Alteryx Designer (Connect AI)
Build workflows to access live Oracle HCM Cloud data for self-service data analytics.
-
Integrate Open WebUI with Live Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Twilio data from within the chat interface.
-
Query FreshBooks Data as a MySQL Database in Node.js
Execute MySQL queries against FreshBooks data from Node.js.
-
How to connect to Box Data from IntelliJ
Integrate connectivity to Box data with wizards in IntelliJ.
-
Getting Started with the CData Python Connector for Paddle
Learn to install and license the CData Python Connector and configure a connection to live Paddle data.
-
Connecting GenSpark with ConstantContact Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to ConstantContact data without any replication or custom integration required.
-
Build Dashboards with SAP SuccessFactors Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP SuccessFactors data in DBxtra.
-
Build Semantic Layer Views for Coinbase Data in APOS Live Data Gateway
Use the CData Connector for Coinbase in APOS Live Data Gateway to build Semantic Layer Views for Coinbase data.
-
Automated AlloyDB Data Replication to Teradata
Use CData Sync to Customize and automate AlloyDB data replication to Teradata.
-
How to Access Live Certinia Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Certinia enables you to integrate Certinia data into workflows built using Microsoft Power Automate Desktop.
-
How to Access Live Quickbase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Quickbase enables you to integrate Quickbase data into workflows built using Microsoft Power Automate Desktop.
-
How to Access ZohoSubscriptions Data Using Entity Framework
This article shows how to access ZohoSubscriptions data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze OneNote Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze OneNote data with the CData JDBC Driver for OneNote.
-
How to Connect to Live IBM Cloud Object Storage Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your IBM Cloud Object Storage data for you.
-
Integrate with Kintone Data in JReport Designer
Create charts and reports based on Kintone data in JReport Designer.
-
Getting Started with the CData ADO.NET Provider for ZohoExpense
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Operational Reporting on GitHub Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote GitHub data.
-
Create FTP Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time FTP data access from reports, embedded analytics, and more.
-
Build Data Flows from FreshBooks to SQL Server using SSIS
Easily back up FreshBooks data to SQL Server using the SSIS components for FreshBooks.
-
Access Quaderno 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 Quaderno data.
-
Build Apps with Live Zoho Recruit Data Using the Low-Code Development Platform of Mendix
Connect Zoho Recruit data with Mendix to build apps using the CData API Driver for JDBC.
-
Use the CData ODBC Driver for Shortcut from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Shortcut to connect to Shortcut data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Shortcut data in Excel.
-
Connect to Cosmos DB Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Cosmos DB data in the Denodo Virtual DataPort Administrator.
-
Import and Visualize Greenplum Data in Power View
Create data visualizations based on Greenplum data in Excel.
-
How to Seamlessly Import Customer.io Data into IBM SPSS Modeler
Integrate Customer.io data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Trae with Live Stripe Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Stripe data from within the AI-powered IDE.
-
Replicate Sage Intacct Data to Multiple Databases via the CData Sync CLI
Replicate Sage Intacct data to disparate databases with a single configuration.
-
Connect to Printify Data from PowerBuilder via JDBC
This article demonstrates how to access Printify data from PowerBuilder using the Printify JDBC Driver.
-
Create Coda-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Coda Data from OutSystems and build custom enterprise apps using live Coda data.
-
Connect to GetResponse Data in Aqua Data Studio
Access GetResponse data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Gorgias Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Gorgias replication to IBM DB2.
-
Create Informatica Mappings From/To a JDBC Data Source for Beeminder
Create Beeminder data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Perform Batch Operations with Teradata Data in Apache NiFi
Connect to Teradata data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate with Live Snapchat Ads Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Snapchat Ads from the MuleSoft Anypoint Platform to integrate live Snapchat Ads data into custom reports and dashboards.
-
Perform Batch Operations with Bullhorn CRM Data in Apache NiFi
Connect to Bullhorn CRM data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Tanda
Provide connectivity to Tanda data through an SAP BusinessObjects universe.
-
Establish a Live Connection with Moosend Data using Tableau Bridge
The CData ODBC Driver for Moosend enables you to integrate live Moosend data into Tableau Cloud dashboards using the Tableau Bridge.
-
Microsoft Entra ID Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Microsoft Entra ID facts in real time.
-
How to Connect to Spotify Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Spotify data. Leverage the pyodbc module for ODBC in Python.
-
How to Create Power BI Visual Reports with Real-Time Dynamics 365 Data
Use CData Power BI Connectors to visualize Dynamics 365 data in Power BI.
-
Connect to Google Sheets Data in Jaspersoft Studio
Execute SQL to remote Google Sheets data in Jaspersoft Studio.
-
Visualize Instagram Data in TIBCO Spotfire through ADO.NET
Integrate Instagram data into dashboards in TIBCO Spotfire.
-
Create Hugging Face Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Hugging Face data access from reports, embedded analytics, and more.
-
Enable the NetSuite JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with NetSuite data.
-
Automated Continuous Guru Replication to Databricks
Use CData Sync for automated, continuous, customizable Guru replication to Databricks.
-
Visualize Live Google Search Results of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Search results using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Multiple PolarTeamPro Accounts via the CData Sync CLI
Replicate multiple PolarTeamPro accounts to one or many databases.
-
Access Live Vault CRM Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Vault CRM data from your Google Sheets.
-
Import and Visualize Shortcut Data in Power View
Create data visualizations based on Shortcut data in Excel.
-
View Reports on Real-Time Microsoft Ads Data in Power BI Report Server
Use the CData ODBC Driver for Microsoft Ads to visualize Microsoft Ads data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Dash to Build to Web Apps on Vercel Data
Create Python applications that use pandas and Dash to build Vercel-connected web apps.
-
Automated Continuous Planio Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Planio replication to Azure SQL Database.
-
How to Work with Missive Data in AWS Glue Jobs Using JDBC
Connect to Missive from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous SAP Netweaver Gateway Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Amazon S3.
-
Connect to Factorial Data in HULFT Integrate
Connect to Factorial as a JDBC data source in HULFT Integrate
-
Build Dynamics CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Dynamics CRM Data and create custom apps in Mendix.
-
Analyze Moosend Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Moosend data in Microsoft R Open.
-
Integrating GitHub Copilot with HDFS 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 Aweber
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrating Airtable Data in Talend Cloud Data Management Platform
Connect Airtable Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Airtable.
-
Create a Data Access Object for Amazon Athena Data using JDBI
A brief overview of creating a SQL Object API for Amazon Athena data in JDBI.
-
Connect to Postmark Data in CloverDX (formerly CloverETL)
Transfer Postmark data using the visual workflow in the CloverDX data integration tool.
-
How to Connect to Live Reckon Accounts Hosted Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Reckon Accounts Hosted data without replication.
-
How to connect to Bugsnag Data from Spring Boot
Connect to Bugsnag in a Spring Boot Application using the CData API Driver for JDBC
-
Build Semantic Layer Views for HubSpot Data in APOS Live Data Gateway
Use the CData Connector for HubSpot in APOS Live Data Gateway to build Semantic Layer Views for HubSpot data.
-
Use the CData ODBC Driver for ChartMogul from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ChartMogul to connect to ChartMogul data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ChartMogul data in Excel.
-
Getting Started with the CData ODBC Driver for SAP Concur
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Concur.
-
Use the CData ODBC Driver for Airtable in Microsoft Power Query
You can use the CData Airtable ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Airtable data into Microsoft Power Query.
-
Build Dashboards with Raisers Edge NXT Data in DBxtra
Create dynamic dashboards and perform analytics based on Raisers Edge NXT data in DBxtra.
-
Bridge Printify Connectivity with Apache NiFi
Access and process Printify data in Apache NiFi using the CData JDBC Driver.
-
Top CData Connectors for Microsoft Power BI's DirectQuery Feature
This article explains the Power BI DirectQuery feature and introduces popular CData Connectors for DirectQuery purposes.
-
Integrating Codex with Excel 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 the CData ODBC Driver for Clio in Microsoft Power Query
You can use the CData Clio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Clio data into Microsoft Power Query.
-
Visualize Twitter Ads Data in Tableau
The CData ODBC driver for Twitter Ads enables you integrate Twitter Ads data into Tableau dashboards.
-
Connect to PayPal Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for PayPal Data and connect to PayPal data in Akorbi Digital RunMyProcess.
-
Connect and Visualize Live SAP Ariba Source Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP Ariba Source data into the Databricks platform and create visualization dashboards with real-time SAP Ariba Source data.
-
Publish Reports with Calendly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Calendly data.
-
Stream RabbitMQ Data into Apache Kafka Topics
Access and stream RabbitMQ data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Cloudant Data in Aqua Data Studio
Access Cloudant data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.