CData Software - Knowledge Base
Recent Articles
-
Bidirectional Access to Pipeline CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pipeline CRM in Filemaker Pro for Mac or Windows.
-
Connect to Confluence Data from Crystal Reports
Use CData Connect AI to connect to and report on live Atlassian Confluence from Crystal Reports.
-
Visualize Airtable Data in Tableau
The CData ODBC driver for Airtable enables you integrate Airtable into Tableau dashboards.
-
Getting Started with the CData ODBC Driver for Redis
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Redis.
-
Migrating data from Beeminder to Databricks using CData SSIS Components.
Easily push Beeminder to Databricks using the CData SSIS Tasks for Beeminder and Databricks.
-
Query ClickTime Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ClickTime entities in PHP by modeling them as objects.
-
How to connect PolyBase to LDAP
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LDAP.
-
Access eBay Analytics Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live eBay Analytics from HeidiSQL.
-
Build Semantic Layer Views for Box Data in APOS Live Data Gateway
Use the CData Connector for Box in APOS Live Data Gateway to build Semantic Layer Views for Box.
-
How to Work with FreeAgent Data in AWS Glue Jobs Using JDBC
Connect to FreeAgent from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Process & Analyze Twilio Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Twilio Data.
-
How to load SAS Data Sets data into Elasticsearch via Logstash
Introducing a simple method to load SAS Data Sets data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Email-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Email and build Email-connected web apps with Axios.
-
Build Zoho Inventory-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Zoho Inventory to explore live Zoho Inventory Data in Cursor to assist with building Zoho Inventory-powered applications.
-
Use the CData Software ODBC Driver for FreeAgent in MicroStrategy Desktop
Connect to FreeAgent in MicroStrategy Desktop using the CData Software ODBC Driver for FreeAgent.
-
Replicate JobNimbus Data from PowerShell
Write a quick PowerShell script to query JobNimbus. Use connectivity to the live data to replicate JobNimbus to SQL Server.
-
Build Phoenix-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Phoenix to explore live Phoenix Data in Gemini Code Assist to assist with building Phoenix-powered applications.
-
Getting Started with the CData Power BI Connector for MariaDB
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for MariaDB.
-
Publish Salesloft-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Salesloft.
-
Access Live ScrapingBee Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a ScrapingBee data source in TIBCO Data Virtualization Studio and gain access to live ScrapingBee from your TDV Server.
-
Operational Reporting on Yelp Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Yelp.
-
Connect to Shortcut Data in CloverDX (formerly CloverETL)
Transfer Shortcut using the visual workflow in the CloverDX data integration tool.
-
Design BIRT Reports on JSON Services
Provide current JSON to your embedded analytics.
-
Getting Started with the CData ADO.NET Provider for Slack
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Slack.
-
Publish Crystal Reports on SAP SuccessFactors LMS Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP SuccessFactors LMS.
-
How to Connect to Live Monday.com 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 Monday.com for you.
-
Visualize Live Cosmos DB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Azure Cosmos DB.
-
Publish Microsoft Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Ads.
-
Use the CData Software ODBC Driver for Reckon Accounts Hosted in MicroStrategy Web
Connect to Reckon Accounts Hosted in MicroStrategy Web using the CData Software ODBC Driver for Reckon Accounts Hosted.
-
Connect to Real-Time Tanda Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Tanda in Power Apps.
-
Create Facebook-Connected Applications in Appsmith
Connect to Facebook Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Facebook.
-
View Reports on Real-Time HBase Data in Power BI Report Server
Use the CData ODBC Driver for HBase to visualize Apache HBase in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate Intercom Data Replication to Couchbase
Use CData Sync to Customize and automate Intercom replication to Couchbase.
-
Access Live Missive Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Missive in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Consume Shopify OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Shopify feeds that reflect any changes in SAP Lumira.
-
Getting Started with the CData ODBC Driver for Harvest
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Harvest.
-
Visualize Recurly 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 Recurly into TIBCO Spotfire.
-
Use the CData Software JDBC Driver for HubSpot in MicroStrategy Web
Connect to HubSpot in MicroStrategy Web using the CData Software JDBC Driver for HubSpot.
-
Build Voice Agents in ElevenLabs with access to Live Okta Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Okta.
-
Load Zoho Inventory Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zoho Inventory to a database.
-
Use the CData Software ODBC Driver for Klaviyo in MicroStrategy
Connect to Klaviyo in MicroStrategy Developer using the CData Software ODBC Driver for Klaviyo.
-
Access Mixpanel Data from MySQL in Amazon QuickSight
Connect to Mixpanel and build visualizations of Mixpanel using a MySQL Connection in Amazon QuickSight.
-
How to Connect the Power BI Service to Twilio: Complete Guide
Connect to the CData Software Power BI Connector for Twilio from PowerBI.com to provide real-time Twilio across the organization.
-
Use Microsoft Copilot Studio to talk to your Spark 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 Apache Spark SQL for you.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Office 365 to Power BI dashboards. Simply drag and drop Microsoft Office 365 into data visuals on the Power BI canvas.
-
Use the CData Software ODBC Driver for Microsoft Teams in MicroStrategy
Connect to Microsoft Teams in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Teams.
-
Work with Live Zoho Inventory Data in Power Query
Use CData Connect AI to connect to Zoho Inventory and work with live Zoho Inventory in Microsoft Power Query.
-
How to Query PayPal Data in MySQL Workbench
Execute MySQL queries against live PayPal from MySQL Workbench.
-
Consume EmailOctopus OData Feeds in PowerBuilder
This article demonstrates how to consume EmailOctopus as OData feeds from PowerBuilder using the API Server.
-
Integrating Chargebee Data in Talend Cloud Data Management Platform
Connect Chargebee Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Import Real-Time Oracle HCM Cloud Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle HCM Cloud in ColdFusion.
-
Write a Simple Go Application to work with Accelo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Accelo.
-
Automated Continuous AlloyDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google AlloyDB replication to OneLake in Microsoft Fabric.
-
Connect to Pipedrive Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Pipedrive and the SQL Gateway to access Pipedrive from Google Apps Script.
-
Automated Continuous MYOB AccountRight Replication to SQLite
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to SQLite.
-
Create Monday.com-Connected Nintex Workflows
Use CData Connect AI to connect to Monday.com Data from Nintex Workflow Cloud and build custom workflows using live Monday.com.
-
Integrating LlamaIndex with Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Reckon Accounts Hosted in real time.
-
Excel Spreadsheet Automation on Monday.com Data with the QUERY Formula
Pull data from Monday.com, automate spreadsheets, and more with the QUERY formula.
-
Build Automated Azure Data Lake Storage-Connected Workflows in Zapier
Use CData Connect AI to connect to live Azure Data Lake Storage and build automated workflows in Zapier.
-
Build Exa-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Exa Data in Gemini Code Assist to assist with building Exa-powered applications.
-
Integrating RabbitMQ Data in Talend Cloud Data Management Platform
Connect RabbitMQ Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Getting Started with the CData Python Connector for Landbot
Learn to install and license the CData Python Connector
-
How to Query Live Guru Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Guru data in natural language using Python.
-
Use Dash to Build to Web Apps on Cloudflare Data
Create Python applications that use pandas and Dash to build Cloudflare-connected web apps.
-
Analyze Live Facebook Ads Data in SAS Viya
Use CData Connect AI to connect to Facebook Ads from SAS Viya and deploy self-service analytics using live Facebook Ads.
-
How to import Calendly Data into Apache Solr
Use the CData Software JDBC Driver for Calendly in Data Import Handler and create an automated import of Calendly to Apache Solr Enterprise Search platform.
-
Build a Singer.io Tap for SAP HANA XS Advanced With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP HANA XS Advanced data using
-
How to Access Live Raisers Edge NXT Data in Visual Studio Code via Cline
Run CData MCP Server for Raisers Edge NXT on Windows Subsytem for Linux (WSL) and connect to live Raisers Edge NXT from the Cline extension in Visual Studio Code.
-
How to Query Live Wistia Data in Perplexity MacOS Desktop
Connect to and query live Wistia Data in Perplexity Desktop using CData MCP Server.
-
Use the CData Software ODBC Driver for CapsuleCRM in MicroStrategy
Connect to CapsuleCRM in MicroStrategy Developer using the CData Software ODBC Driver for CapsuleCRM.
-
Connect to ClickUp Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ClickUp in the Denodo Virtual DataPort Administrator.
-
Connect to SAS Data Sets Data from a Connection Pool in JBoss
Integrate SAS Data Sets into Java servlets: Use the Management Console in JBoss to install the SAS Data Sets JDBC Driver.
-
Analyze Billsby Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Billsby in Microsoft R Open.
-
Replicate Avaza Data from PowerShell
Write a quick PowerShell script to query Avaza. Use connectivity to the live data to replicate Avaza to SQL Server.
-
Getting Started with the CData ODBC Driver for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Bullhorn CRM.
-
Create Informatica Mappings From/To a JDBC Data Source for Elorus
Create Elorus data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Migrating data from Zoho Books to Databricks using CData SSIS Components.
Easily push Zoho Books to Databricks using the CData SSIS Tasks for Zoho Books and Databricks.
-
Build AI/ML Models with Live GetResponse Data using Dataiku
Connect GetResponse Data with Dataiku using the CData API Driver for JDBC.
-
Explore Geographical Relationships in SendPulse Data with Power Map
Create data visualizations with SendPulse in Power Map.
-
How to Query Slack Data in MySQL Workbench
Execute MySQL queries against live Slack from MySQL Workbench.
-
Configure the CData JDBC Driver for Figshare in a Connection Pool in Tomcat
Connect to Figshare from a connection pool in Tomcat.
-
Natively Connect to Adobe Analytics Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Adobe Analytics. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Excel Add-In for Placid
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Placid.
-
Integrating Antigravity CLI with Odoo ERP via CData CLI
Connect Odoo ERP to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous PabblySubscriptions Replication to SQL Server
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to SQL Server.
-
Create Datasets from Google Directory in Domo Workbench and Build Visualizations of Google Directory Data in Domo
Use the CData Software ODBC Driver for Google Directory to create datasets from Google Directory in Domo Workbench and then build visualizations in the Domo service.
-
Bidirectional Access to Omnisend Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Omnisend in Filemaker Pro for Mac or Windows.
-
Publish Crystal Reports on Wrike Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Wrike.
-
Access SAP ByDesign Data from MySQL in PHP
Connect to SAP ByDesign through the standard MySQL libraries in PHP.
-
Build Apps with Live Authorize.Net Data Using the Low-Code Development Platform of Mendix
Connect Authorize.Net with Mendix to build apps using the CData JDBC Driver for Authorize.Net.
-
Integrating GitHub Copilot CLI with FreshBooks 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.
-
Add CapsuleCRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for CapsuleCRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect to Outreach.io Data in DBVisualizer
Integrate Outreach.io with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Dynamics CRM Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Dynamics CRM in DBeaver.
-
How to import Klaviyo Data into Apache Solr
Use the CData Software JDBC Driver for Klaviyo in Data Import Handler and create an automated import of Klaviyo to Apache Solr Enterprise Search platform.
-
Integrate SAP Fieldglass Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Fieldglass from Informatica Cloud.
-
Automated Continuous Intercom Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Intercom replication to Azure SQL Database.
-
Publish ElevenLabs-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ElevenLabs.
-
Integrating OpenCode Terminal with SuiteCRM 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.
-
DataBind Superchat Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Superchat to a chart.