CData Software - Knowledge Base
Recent Articles
-
Create Power BI Reports on Real-Time Moosend Data
Use the CData ODBC Driver for Moosend to visualize Moosend data in Power BI Desktop.
-
Interact with Live Workday Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Workday data.
-
Access Live Wistia Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Wistia data through MCP integration.
-
Access Live ConstantContact Data in Excel 365 Online (Excel for the web)
Connect to ConstantContact data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
ETL CapsuleCRM in Oracle Data Integrator
This article shows how to transfer CapsuleCRM data into a data warehouse using Oracle Data Integrator.
-
Integrating OpenCode with Slack 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.
-
Integrate GitHub Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to GitHub data and integrate live GitHub data into your Power Automate tasks.
-
Connect to SAP Hybris C4C Data in Jaspersoft Studio
Execute SQL to remote SAP Hybris C4C data in Jaspersoft Studio.
-
Replicate Printful Data in Heroku for Use in Salesforce Connect
Replicate Printful data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query, Visualize, and Share live Microsoft Planner Data in Redash
Use CData Connect AI to connect to live Microsoft Planner data in Redash for querying, visualizing, and sharing.
-
Visualize RabbitMQ Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to RabbitMQ data.
-
Google Ad Manager Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Ad Manager facts in real time.
-
How to create JotForm federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for JotForm data in MySQL .
-
How to Work with Samanage Data in ETL Validator JDBC
Connect to Samanage from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Avalara AvaTax Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Avalara AvaTax data in the Denodo Virtual DataPort Administrator.
-
Create Dynamics 365-Connected Nintex Workflows
Use CData Connect AI to connect to Dynamics 365 Data from Nintex Workflow Cloud and build custom workflows using live Dynamics 365 data.
-
Automated Continuous Mistral AI Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Mistral AI replication to Amazon S3.
-
Create Dashboards and Visualize Live Freshteam Data in Geckoboard
Use CData Connect AI to connect to live Freshteam data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating LangGraph with SFTP Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SFTP data within automated workflows.
-
Build Visualizations of Access Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Access data in Birst.
-
Automated Continuous Pinecone Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Pinecone replication to Amazon S3.
-
Query Live Oracle Sales Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Oracle Sales data through a conversational interface.
-
Publish Rootly-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Rootly data.
-
Automated Continuous Paylocity Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Paylocity replication to Amazon S3.
-
Working with Tanda Data in LINQPad
Execute LINQ queries to Tanda data in LINQPad.
-
Build Voice Agents in ElevenLabs with access to Live Quickbase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Quickbase data.
-
Use CData Connect AI to Access Jumpseller Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Jumpseller data in the Power Pivot business intelligence tool.
-
DataBind Controls to BigQuery Data in Delphi
DataBind to BigQuery data in Delphi with standard data access components and controls.
-
Connect to ZarMoney Data in Jaspersoft Studio
Execute SQL to remote ZarMoney data in Jaspersoft Studio.
-
Use the CData ODBC Driver for Google Campaign Manager 360 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Campaign Manager 360 to connect to Google Campaign Manager 360 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Campaign Manager 360 data in Excel.
-
How to Visualize Cassandra Data in Python with pandas
Use pandas and other modules to analyze and visualize live Cassandra data in Python.
-
Build Charts with Salesforce Pardot Data in Clear Analytics
Create dynamic charts and perform analytics based on Salesforce Pardot data in Clear Analytics.
-
Load ServiceNow Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ServiceNow data to a database.
-
Use the CData Software ODBC Driver for Customer.io in MicroStrategy Desktop
Connect to Customer.io data in MicroStrategy Desktop using the CData Software ODBC Driver for Customer.io.
-
Integrating GitHub Copilot with Flowlu 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 SAP Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP to connect to SAP data and execute queries in PowerBuilder.
-
Integrate Google's Antigravity Agent with Live Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Kintone data using the Model Context Protocol.
-
Extract, Transform, and Load Paymo Data in Informatica PowerCenter
Create a simple Workflow for Paymo data in Informatica PowerCenter.
-
How to create Visio diagrams from Greenplum Data
Automatically update Greenplum data with the changes you make to Visio master shapes.
-
Build Apps with Live ZohoExpense Data Using the Low-Code Development Platform of Mendix
Connect ZohoExpense data with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate OpenCode with Live ZohoMarketingHub Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live ZohoMarketingHub data from within your AI coding agent.
-
Use Grok to Talk to Your Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Box data for you.
-
Build Sage 200-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Sage 200 Data from Zoho Analytics and import live Sage 200 data.
-
Import iContact Data Using Azure Data Factory
Use CData Connect AI to connect to iContact Data from Azure Data Factory and import live iContact data.
-
Analyze QuickBooks Online Data in Cognos Analytics
Use CData Connect AI to connect to QuickBooks Online Data from Cognos Analytics and analyze live QuickBooks Online data.
-
Integrate Cline with Live ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live ActiveCampaign data from within your IDE.
-
Consume MariaDB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on MariaDB feeds that reflect any changes in SAP Lumira.
-
Connect to Google Search Results in Google Apps Script via Connect AI
Use CData Connect AI to access Google Search results in Google Apps Script.
-
Manage OData Services in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for OData.
-
Access Live Greenhouse Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Greenhouse data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating GitHub Copilot with Vault CRM 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.
-
Analyze SAP Business Warehouse Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Business Warehouse from Power Pivot. You will use the Table Import Wizard to load SAP Business Warehouse data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Act CRM Data in NetBeans
Connect to Act CRM data in NetBeans with the data source configuration wizard.
-
Interact with Live Elasticsearch Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Elasticsearch data.
-
How to connect Amazon QuickSight to Greenhouse Data
Create a connection to Greenhouse data in CData Connect AI and insert Greenhouse data into Amazon QuickSight SPICE to build interactive dashboards.
-
Use ChatGPT to Talk to Your SAP Business Warehouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAP Business Warehouse data for you.
-
Use Grok to Talk to Your MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your MySQL data for you.
-
How to Connect the Power BI Service to ADP: Complete Guide
Connect to the CData Software Power BI Connector for ADP from PowerBI.com to provide real-time ADP data across the organization.
-
Connect to Apollo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Apollo to connect to Apollo data from Web applications running on WebLogic.
-
Build Apps with Live Short.io Data Using the Low-Code Development Platform of Mendix
Connect Short.io data with Mendix to build apps using the CData API Driver for JDBC.
-
ETL Google Forms in Oracle Data Integrator
This article shows how to transfer Google Forms data into a data warehouse using Oracle Data Integrator.
-
How to Seamlessly Import ServiceDesk Plus Data into IBM SPSS Modeler
Integrate ServiceDesk Plus data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build ConvertAPI-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ConvertAPI data and build web apps with connectivity to live ConvertAPI data.
-
How to Query SingleStore Data in MySQL Workbench
Execute MySQL queries against live SingleStore data from MySQL Workbench.
-
Connect to Zoho CRM Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Zoho CRM data.
-
Build AI Agents with PayPal 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 PayPal data through CData Connect AI.
-
Connect to SAP Fieldglass Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Fieldglass data from Crystal Reports.
-
Integrating Codex with xBase 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.
-
Consume BigCommerce OData Feeds in SAP Lumira
Use the API Server to create data visualizations on BigCommerce feeds that reflect any changes in SAP Lumira.
-
Connect to Coinbase Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Coinbase and work with Coinbase data in your FileMaker application.
-
A PostgreSQL Interface for Teradata Data using the CData ODBC Driver
Use the SQL Gateway and Teradata ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Trello Data in MySQL Workbench
Execute MySQL queries against live Trello data from MySQL Workbench.
-
Build Data Flows from MySQL to SQL Server using SSIS
Easily back up MySQL data to SQL Server using the SSIS components for MySQL.
-
Use the CData Software ODBC Driver for Demio in SAS for Real-Time Reporting and Analytics
Connect to real-time Demio data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Demio.
-
Getting Started with the CData Connect AI Python SDK for Jira Assets
Install the CData Connect AI Python SDK to read and write live Jira Assets data with standard DB-API 2.0 Python code.
-
Creating Google Directory-Connected Applications in Unqork
You can use CData Connect AI to feed Google Directory data to Unqork and build custom business apps.
-
How to Connect to Live Oracle 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 Oracle data for you.
-
How to Access Live Oracle Sales Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Oracle Sales enables you to integrate Oracle Sales data into workflows built using Microsoft Power Automate Desktop.
-
Connect to SAP Ariba Source Data in HULFT Integrate
Connect to SAP Ariba Source as a JDBC data source in HULFT Integrate
-
Replicate Microsoft Dataverse Data from PowerShell
Write a quick PowerShell script to query Microsoft Dataverse data. Use connectivity to the live data to replicate Microsoft Dataverse data to SQL Server.
-
Visualize Live Contentful Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Contentful data.
-
Search External Amazon Marketplace Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Amazon Marketplace data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Amazon Marketplace Data objects that you can access from apps and the dashboard.
-
Connect to and Query Hugging Face Data in QlikView over ODBC
Create data visualizations with Hugging Face data in QlikView.
-
DataBind Controls to SAP SuccessFactors Data in C++Builder
DataBind to SAP SuccessFactors data in C++Builder with standard components and controls.
-
Getting Started with the CData Excel Add-In for Airtable
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Airtable.
-
Connect to Okta Data in Claris FileMaker Pro
Use the CData ODBC Driver for Okta in FileMaker Pro to connect to Okta and work with Okta data in your FileMaker applications.
-
Integrate Billsby Data in Pentaho Data Integration
Build ETL pipelines based on Billsby data in the Pentaho Data Integration tool.
-
Visualize Bitbucket Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Bitbucket data.
-
Visualize Live LinkedIn Data in the Power BI Service
Use CData Connect AI to connect to live LinkedIn data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Google's Antigravity Agent with Live ZohoPeople Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live ZohoPeople data using the Model Context Protocol.
-
Bind Live Anaplan Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Anaplan data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Build Cloudant-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Cloudant data and build web apps with connectivity to live Cloudant data.
-
How to Use a Microsoft Access Database to Update JSON Services in Real Time
Update JSON data by creating a linked table in Microsoft Access with the CData JSON ODBC Driver.
-
Build SuiteCRM-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SuiteCRM Data from Zoho Analytics and import live SuiteCRM data.
-
Establish a Live Connection with ServiceNow Data using Tableau Bridge
The CData ODBC Driver for ServiceNow enables you to integrate live ServiceNow data into Tableau Cloud dashboards using the Tableau Bridge.
-
Excel Spreadsheet Automation on Sybase IQ Data with the QUERY Formula
Pull data from Sybase IQ, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for Cosmos DB in MicroStrategy
Connect to Cosmos DB data in MicroStrategy Developer using the CData Software ODBC Driver for Cosmos DB.
-
Build Charts with Email Data in Clear Analytics
Create dynamic charts and perform analytics based on Email data in Clear Analytics.
-
Build a Singer.io Tap for Rebilly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Rebilly data using the CData Python Connector.
-
Publish HelloSign-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live HelloSign data.