CData Software - Knowledge Base
Recent Articles
-
How to Connect the Power BI Service to LeadDesk: Complete Guide
Connect to the CData Software Power BI Connector for LeadDesk from PowerBI.com to provide real-time LeadDesk data across the organization.
-
Create Informatica Mappings From/To a JDBC Data Source for Supabase
Create Supabase data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous HDFS Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable HDFS replication to Azure SQL Database.
-
Zoho Recruit Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Zoho Recruit facts in real time.
-
Build Voice Agents in ElevenLabs with access to Live Presto Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Presto data.
-
Access Gong Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Gong data from HeidiSQL.
-
Add SAP Fieldglass Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Fieldglass with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use ChatGPT to Talk to Your Toggl 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 Toggl data for you.
-
Use the CData ODBC Driver for Kintone in Microsoft Power Query
You can use the CData Kintone ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Kintone data into Microsoft Power Query.
-
Design BIRT Reports on ChargeOver Data
Provide current ChargeOver data to your embedded analytics.
-
LINQ to Snapchat Ads Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Snapchat Ads Data Provider.
-
Use the CData Software ODBC Driver for Attio in SAS for Real-Time Reporting and Analytics
Connect to real-time Attio data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Attio.
-
Build Google Forms-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Forms data.
-
Integrate Theia IDE with Live Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Microsoft Teams data from within the development environment.
-
Build Apps with Live BigQuery Data Using the Low-Code Development Platform of Mendix
Connect BigQuery data with Mendix to build apps using the CData JDBC Driver for BigQuery.
-
Connect to GitLab Data in ACL Analytics
Connect to GitLab data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to GitLab data.
-
Write a Simple Go Application to work with SuiteCRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SuiteCRM data.
-
Query Strava Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Strava data from Node.js.
-
How to Connect to Live Sendwithus Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Sendwithus data securely in real time.
-
Write a Simple Go Application to work with Google Sheets Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Sheets data.
-
How to Query Live Flowlu Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Flowlu data data in natural language using Python.
-
Automated Continuous Brex Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Brex replication to Apache Kafka.
-
Use the CData Software ODBC Driver for Sugar CRM in MicroStrategy Web
Connect to Sugar CRM data in MicroStrategy Web using the CData Software ODBC Driver for Sugar CRM.
-
Build Pipelines with Live Adobe Target Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Adobe Target from Google Cloud Data Fusion, enabling the integration of live Adobe Target data into the building and management of effective data pipelines.
-
Create FHIR-Connected Business Apps in AppSheet
Connect to FHIR Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to FHIR data.
-
How to load ZohoExpense data into Elasticsearch via Logstash
Introducing a simple method to load ZohoExpense data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData Power BI Connector for OData
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for OData.
-
Integrate QuickBooks Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live QuickBooks data from Informatica Cloud.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Search
Provide connectivity to Google Search results through an SAP BusinessObjects universe.
-
Integrating Claude Code CLI with SharePoint 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.
-
Integrating OpenCode with Pipeline 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.
-
Access Live Microsoft Ads Data in AWS Lambda
Connect to live Microsoft Ads data in AWS Lambda using the CData JDBC Driver.
-
Integrating Gumloop with Pinterest Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Pinterest data within automated workflows.
-
Automated Continuous Google Campaign Manager 360 Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to IBM DB2.
-
How to Access Live Salesforce CRM Analytics Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Salesforce CRM Analytics enables you to integrate Salesforce CRM Analytics data into workflows built using Microsoft Power Automate Desktop.
-
Query Google Calendar Data as a MySQL Database in Node.js
Execute MySQL queries against Google Calendar data from Node.js.
-
Access Live Oracle Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Oracle data from your Excel spreadsheets.
-
Visualize Google Translate Data in Tableau
The CData ODBC driver for Google Translate enables you integrate Google Translate data into Tableau dashboards.
-
How to connect PolyBase to Box
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Box data.
-
Connect to Cloudant Data from AWS Glue
Use CData Connect AI to gain access to live Cloudant data from your AWS Glue jobs.
-
Explore Geographical Relationships in Onfleet Data with Power Map
Create data visualizations with Onfleet data in Power Map.
-
Use the CData ODBC Driver for CapsuleCRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for CapsuleCRM to connect to CapsuleCRM data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring CapsuleCRM data in Excel.
-
Build Charts with Clockify Data in Clear Analytics
Create dynamic charts and perform analytics based on Clockify data in Clear Analytics.
-
Analyze HDFS Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for HDFS from Power Pivot. You will use the Table Import Wizard to load HDFS data. You can visually build the import query or use any SQL supported by the driver.
-
Automate Amazon S3 Data Replication to Azure Data Lake
Use CData Sync to customize and automate Amazon S3 data replication to Azure Data Lake.
-
Automated Continuous Gong Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Gong replication to Amazon Redshift.
-
Getting Started with the CData Connect AI Python SDK for Act-On
Install the CData Connect AI Python SDK to read and write live Act-On data with standard DB-API 2.0 Python code.
-
Connect to Vault CRM Data in DBeaver
Use the CData ODBC Driver to connect to Vault CRM data in DBeaver.
-
Integrating Claude Code CLI with PingOne 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 Live CockroachDB Data in SAS Viya
Use CData Connect AI to connect to CockroachDB data from SAS Viya and deploy self-service analytics using live CockroachDB data.
-
Replicate Multiple BambooHR Accounts via the CData Sync CLI
Replicate multiple BambooHR accounts to one or many databases.
-
How to Connect to Live Oracle Sales Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Oracle Sales data for you.
-
How to connect SharePoint with SAP SuccessFactors LMS Data through external lists
Provide SAP SuccessFactors LMS data to SharePoint users as an external list.
-
View Reports on Real-Time Wave Financial Data in Power BI Report Server
Use the CData ODBC Driver for Wave Financial to visualize Wave Financial data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Semantic Layer Views for Discord Data in APOS Live Data Gateway
Use the CData Connector for Discord in APOS Live Data Gateway to build Semantic Layer Views for Discord data.
-
Analyze SFTP Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SFTP data with the CData JDBC Driver for SFTP.
-
How to Connect to Live Azure Table 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 Azure Table data for you.
-
Model LDAP Objects Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and LDAP, enabling the direct import of real-time LDAP objects.
-
How to create an RPA flow for Supabase Data in UiPath Studio
Use the Supabase ODBC Driver to create workflows that access real-time Supabase data without any coding.
-
Replicate CSV Data from PowerShell
Write a quick PowerShell script to query CSV data. Use connectivity to the live data to replicate CSV data to SQL Server.
-
Automated Continuous Sentry Replication to MySQL
Use CData Sync for automated, continuous, customizable Sentry replication to MySQL.
-
Connect to Coinbase from Asprova with CData Software ODBC Driver for Coinbase
This article shows how to connect faster to Coinbase data from Asprova.
-
Publish Retently-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Retently data.
-
Create SSAS Tabular Models from Teamwork Data
How to build a SQL Server Analysis Service Tabular Model from Teamwork data using CData drivers.
-
Operational Reporting on Certinia Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Certinia data.
-
Connect to Live Guru Data in MicroStrategy through CData Connect AI
Create a live connection to Guru Data in CData Connect AI and connect to your Guru data from MicroStrategy.
-
Connect Acumatica Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Acumatica data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Build an ETL App for Dynamics 365 Business Central Data in Python with CData Connect AI
Build ETL pipelines that read and write live Dynamics 365 Business Central data in Python with petl and the CData Connect AI Python SDK.
-
Build Apps with Live Oracle HCM Cloud data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle HCM Cloud data into the Adalo platform and build custom mobile and web applications with real-time Oracle HCM Cloud data.
-
Natively Connect to Gorgias Data in PHP
The CData ODBC driver for Gorgias enables you to create PHP applications with connectivity to Gorgias data. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Moosend in MicroStrategy Web
Connect to Moosend data in MicroStrategy Web using the CData Software JDBC Driver for Moosend.
-
Automated Continuous Oracle Service Cloud Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Apache Kafka.
-
Automated Continuous SAP HANA XS Advanced Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to SQL Server.
-
Build Anaplan Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Anaplan data and build visualizations in Tableau Cloud.
-
How to Work with Copper Data in ETL Validator JDBC
Connect to Copper from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Live HubSpot Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live HubSpot data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to use SQLAlchemy ORM to access Stack Exchange Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Stack Exchange data.
-
Import Real-Time Oracle Service Cloud Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Oracle Service Cloud data in ColdFusion.
-
How to Work with Google Analytics Data in ETL Validator JDBC
Connect to Google Analytics from ETL Validator jobs using the CData Software JDBC Driver.
-
Enable the FreshBooks JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with FreshBooks data.
-
Integrating Strava Data in Talend Cloud Data Management Platform
Connect Strava Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Charts with Excel Online Data in Clear Analytics
Create dynamic charts and perform analytics based on Excel Online data in Clear Analytics.
-
A PostgreSQL Interface for Couchbase Data using the CData ODBC Driver
Use the SQL Gateway and Couchbase ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Google's Vertex AI Agent with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Azure Synapse data within intelligent workflows.
-
How to Connect to Live ADP 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 ADP data for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Azure Table
Provide connectivity to Azure Table data through an SAP BusinessObjects universe.
-
How to Connect to Live Workday Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Workday data for you.
-
Integrate with Live WordPress Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to WordPress from the MuleSoft Anypoint Platform to integrate live WordPress data into custom reports and dashboards.
-
Automated Amazon S3 Data Replication to Teradata
Use CData Sync to Customize and automate Amazon S3 data replication to Teradata.
-
How to create an RPA flow for Optimizely Data in UiPath Studio
Use the Optimizely ODBC Driver to create workflows that access real-time Optimizely data without any coding.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ADP
Provide connectivity to ADP data through an SAP BusinessObjects universe.
-
Use Microsoft Copilot Studio to talk to your Aweber 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 Aweber data for you.
-
Automated SharePoint Excel Services Data Replication to Teradata
Use CData Sync to Customize and automate SharePoint Excel Services data replication to Teradata.
-
Integrating Kiro with Copper 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.
-
Access WooCommerce 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 WooCommerce data.
-
Visualize Salesforce Marketing Data in Sisense
Create an ElastiCube in Sisense app with access to Salesforce Marketing data.
-
Access Live Jodoo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Jodoo data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Automated SAP Business One-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Business One data and build automated workflows in Zapier.
-
Replicate OpenWeatherMap Data in Heroku for Use in Salesforce Connect
Replicate OpenWeatherMap data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build a PostgreSQL Interface for BigCommerce Data using the CData JDBC Driver
Use the Remoting features of the BigCommerce JDBC Driver to create a PostgreSQL entry-point for data access.