CData Software - Knowledge Base
Recent Articles
-
Build Ontraport-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Ontraport.
-
How to integrate Google Translate with Apache Airflow
Access and process Google Translate in Apache Airflow using the CData JDBC Driver.
-
Connect to Strava from Asprova with CData Software ODBC Driver for Strava
This article shows how to connect faster to Strava data from Asprova.
-
Provide OData Services of Typeform Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Typeform by developing a WCF Service Application.
-
Add QuickBooks Time Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for QuickBooks Time with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Semantic Layer Views for Avro Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Apache Avro.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Act-On to Power BI dashboards. Simply drag and drop Act-On into data visuals on the Power BI canvas.
-
Establish a Live Connection with Supabase Data using Tableau Bridge
The CData ODBC Driver for Supabase enables you to integrate live Supabase into Tableau Cloud dashboards using the Tableau Bridge.
-
Build a Simple VCL Application for Pipeline CRM Data
How to build a simple VCL Application to view Pipeline CRM in RAD Studio using the CData ODBC Driver for Pipeline CRM.
-
Access Live Azure Table Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Table Storage from your Google Sheets.
-
Integrating eBay Analytics Data in Talend Cloud Data Management Platform
Connect eBay Analytics Data with Talend Cloud Data Management Platform using the CData JDBC Driver for eBay Analytics.
-
Use the CData Software ODBC Driver for EnterpriseDB in MicroStrategy Web
Connect to EnterpriseDB in MicroStrategy Web using the CData Software ODBC Driver for EnterpriseDB.
-
Import Real-Time ZohoExpense Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ZohoExpense in ColdFusion.
-
How to Work with Toggl Data in ETL Validator JDBC
Connect to Toggl from ETL Validator jobs using the CData Software JDBC Driver.
-
Query SAP Business Warehouse Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP Business Warehouse entities in PHP by modeling them as objects.
-
Build Semantic Layer Views for BigQuery Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google BigQuery.
-
Access Live SQL Analysis Services Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SQL Analysis Services through MCP integration.
-
Use the CData ODBC Driver for Active Directory in Microsoft Power Query
You can use the CData Active Directory ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Active Directory into Microsoft Power Query.
-
Manage Foursquare Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Foursquare.
-
How to Build an ETL App for HCL Domino Data in Python with CData
Create ETL applications and real-time data pipelines for HCL Domino in Python with petl.
-
Create Data Visualizations Based On HCL Domino Data in Mode
Use CData Connect AI to connect to HCL Domino Data from Mode and build visualizations using live
-
Create Certinia-Connected Nintex Workflows
Use CData Connect AI to connect to Certinia Data from Nintex Workflow Cloud and build custom workflows using live Certinia.
-
Build Agents in Relevance AI with Access to Live Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Ads within intelligent agent workflows.
-
Use the CData Software JDBC Driver for Adobe Analytics in MicroStrategy Web
Connect to Adobe Analytics in MicroStrategy Web using the CData Software JDBC Driver for Adobe Analytics.
-
Consume Square OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Square feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Perplexity Replication to MySQL
Use CData Sync for automated, continuous, customizable Perplexity replication to MySQL.
-
How to connect to Amazon Marketplace Data from Spring Boot
Connect to Amazon Marketplace in a Spring Boot Application using the CData JDBC Driver for Amazon Marketplace
-
Integrate with ConvertKit Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ConvertKit to a JSON file on disk.
-
Operational Reporting on MarkLogic Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote MarkLogic.
-
Integrating LangGraph with Sybase Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Sybase within automated workflows.
-
Query Live Zoho Books 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 Zoho Books directly from the development environment.
-
Migrating data from Testmonitor to Databricks using CData SSIS Components.
Easily push Testmonitor to Databricks using the CData SSIS Tasks for Testmonitor and Databricks.
-
How to Connect to Live Amazon S3 Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Amazon S3 securely in real time.
-
How to Visualize NetSuite Data in Python with pandas
Use pandas and other modules to analyze and visualize live NetSuite CRM & ERP in Python.
-
Import Real-Time Flowlu Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Flowlu in ColdFusion.
-
Access Amazon DynamoDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amazon DynamoDB from HeidiSQL.
-
Write a Simple Go Application to work with Sage 300 Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sage 300.
-
Feed Oracle SCM Data into FineReport
How to set Oracle SCM as a JDBC data source in FineReport.
-
Access Live Opsgenie Data in AWS Lambda
Connect to live Opsgenie in AWS Lambda using the CData JDBC Driver.
-
Create SSAS Tabular Models from Gmail Data
How to build a SQL Server Analysis Service Tabular Model from Gmail using CData drivers.
-
Operational Reporting on Pingdom Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pingdom.
-
Use the CData Software ODBC Driver for Salesforce CRM Analytics in SAS for Real-Time Reporting and Analytics
Connect to real-time Salesforce CRM Analytics in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Salesforce CRM Analytics.
-
Replicate ClickUp Data to Multiple Databases via the CData Sync CLI
Replicate ClickUp to disparate databases with a single configuration.
-
Integrate OData Services into Power Automate Desktop using CData Connect
CData Connect for OData Services enables you to integrate OData into workflows built using Microsoft Power Automate Desktop.
-
Publish Crystal Reports on MailerLite Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MailerLite.
-
Connecting Agentforce with SAS xpt Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your SAS XPORT for you.
-
Import and Visualize Epicor Kinetic Data in Power View
Create data visualizations based on Epicor Kinetic in Excel.
-
Bridge Jira Connectivity with Apache NiFi
Access and process Atlassian Jira in Apache NiFi using the CData JDBC Driver.
-
Integrating Kiro CLI with Freshdesk 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.
-
How to connect Amazon QuickSight to GitHub Data
Create a connection to GitHub in CData Connect AI and insert GitHub into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize Oracle HCM Cloud Data in Tableau
The CData ODBC driver for Oracle HCM Cloud enables you integrate Oracle HCM Cloud into Tableau dashboards.
-
Build Voice Agents in ElevenLabs with access to Live Azure Table Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Azure Table Storage.
-
How to create Gong federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Gong in MySQL .
-
Process & Analyze Teamgate Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Teamgate Data.
-
Explore Geographical Relationships in Discourse Data with Power Map
Create data visualizations with Discourse in Power Map.
-
Connect to MailChimp Data from a Connection Pool in JBoss
Integrate MailChimp into Java servlets: Use the Management Console in JBoss to install the MailChimp JDBC Driver.
-
Connect to and Query Hive Data in QlikView over ODBC
Create data visualizations with Apache Hive in QlikView.
-
Automate MongoDB Data Replication to Couchbase
Use CData Sync to Customize and automate MongoDB replication to Couchbase.
-
Natively Connect to Teamwork Data in PHP
The CData ODBC driver for Teamwork enables you to create PHP applications with connectivity to Teamwork. Leverage the native support for ODBC in PHP.
-
Create Apps from Microsoft Planner Data in Qlik Sense Cloud
Use CData Connect AI to connect to Microsoft Planner Data and build apps from live Microsoft Planner in Qlik Sense Cloud.
-
Migrating data from Short.io to Google BigQuery using CData SSIS Components.
Easily push Short.io to Google BigQuery using the CData SSIS Tasks for Short.io and Google BigQuery.
-
How to Connect to Live AlloyDB Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Google AlloyDB without replication.
-
How to connect SharePoint with SQL Analysis Services Data through external lists
Provide SQL Analysis Services to SharePoint users as an external list.
-
Integrate IBM Informix with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate IBM Informix with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to IBM Informix.
-
How to connect SharePoint with Oracle HCM Cloud Data through external lists
Provide Oracle HCM Cloud to SharePoint users as an external list.
-
Integrating Claude Code CLI with Billsby 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.
-
A PostgreSQL Interface for Telegram Data using the CData ODBC Driver
Use the SQL Gateway and Telegram ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect Xero to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Xero Accounting using the CData Python MCP Server.
-
Access Live Square Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Square from your Excel spreadsheets.
-
Integrate Live SAP Concur Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP Concur to Blue Prism using the CData ODBC Driver for SAP Concur to create automated workflows for repetitive business tasks.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Mixpanel
Provide connectivity to Mixpanel through an SAP BusinessObjects universe.
-
How to create an RPA flow for Gong Data in UiPath Studio
Use the Gong ODBC Driver to create workflows that access real-time Gong without any coding.
-
Prepare, Blend, and Analyze Salesforce CRM Analytics Data in Alteryx Designer (Connect AI)
Build workflows to access live Salesforce CRM Analytics for self-service data analytics.
-
Access Live Cloudant Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live IBM Cloudant from your Excel spreadsheets.
-
Analyze ShipEngine Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ShipEngine in Microsoft R Open.
-
How to create an RPA flow for Google Tasks Data in UiPath Studio
Use the Google Tasks ODBC Driver to create workflows that access real-time Google Tasks without any coding.
-
How to Connect to & Open SAP ByDesign Data in Microsoft Excel
This article uses the CData ODBC driver for SAP ByDesign to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to ClickTime Data from PowerBuilder via ADO.NET
This article demonstrates how to access ClickTime from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Publish PolarTeamPro-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live PolarTeamPro.
-
Amazon Athena Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Amazon Athena through CData Connect AI using different applications and tools.
-
Operational Reporting on FormSite Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote FormSite.
-
Connect QuickBooks to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live QuickBooks Desktop using the CData Python MCP Server.
-
Access Live SAP Fieldglass Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Fieldglass from your Excel spreadsheets.
-
Automated Continuous Kafka Replication to SQLite
Use CData Sync for automated, continuous, customizable Kafka replication to SQLite.
-
Connecting Pipedream with Twitter Ads 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 Twitter Ads data in real time.
-
Use Dash to Build Web Apps on Google Cloud Storage Data via CData Connect AI
Build interactive Dash web apps on live Google Cloud Storage using pandas and the CData Connect AI Python SDK.
-
How to publish and share CapsuleCRM Data dashboards with Tableau Server
The CData ODBC driver for CapsuleCRM enables you integrate CapsuleCRM into Tableau dashboards.
-
Bidirectional Access to MySQL Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate MySQL in Filemaker Pro for Mac or Windows.
-
Build YouTube Analytics Visualizations in Tableau Desktop
Use CData Connect AI to connect to live YouTube Analytics and build visualizations in Tableau.
-
Getting Started with the CData JDBC Driver for Presto
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Presto.
-
How to connect PolyBase to SAP Ariba Source
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Ariba Source.
-
Integrate with live Dynamics 365 Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Dynamics 365 in Jitterbit.
-
Build Google Calendar-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Google Calendar to explore live Google Calendar Data in Claude Code to assist with building Google Calendar-powered applications.
-
Automate SAP HANA Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP HANA replication to Azure Data Lake.
-
Import and Visualize Couchbase Data in Power View
Create data visualizations based on Couchbase in Excel.
-
Analyze Calendly Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Calendly from Power Pivot. You will use the Table Import Wizard to load Calendly. You can visually build the import query or use any SQL supported by the driver.
-
How to create an RPA flow for Salesforce CRM Analytics Data in UiPath Studio
Use the Salesforce CRM Analytics ODBC Driver to create workflows that access real-time Salesforce CRM Analytics without any coding.
-
Validate Exa Data with QuerySurge
Access and validate Exa in QuerySurge using the CData JDBC Driver.
-
How to Access Float Data Using Entity Framework
This article shows how to access Float using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Easily Integrate Missive Data in Lazarus Pascal IDE
Learn how to easily integrate live Missive in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.