CData Software - Knowledge Base
Recent Articles
-
Analyze GitHub Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of GitHub data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Semantic Layer Views for Clari Data in APOS Live Data Gateway
Use the CData Connector for Clari in APOS Live Data Gateway to build Semantic Layer Views for Clari data.
-
How to publish and share Omnisend Data dashboards with Tableau Server
The CData ODBC driver for Omnisend enables you integrate Omnisend data into Tableau dashboards.
-
Integrate Active Directory Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Active Directory data from Informatica Cloud.
-
How to Connect to Live Microsoft Teams 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 Microsoft Teams data for you.
-
How to use SQLAlchemy ORM to access Factorial Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Factorial data.
-
Perform Batch Operations with Zendesk Data in Apache NiFi
Connect to Zendesk data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create ServiceNow-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to ServiceNow Data from OutSystems and build custom enterprise apps using live ServiceNow data.
-
Connect to Vault CRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Vault CRM data from Crystal Reports.
-
Connecting Agentforce with JSON Services 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 JSON services for you.
-
Getting Started with the CData SSIS Components for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bullhorn CRM.
-
Search External Wistia Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Wistia data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Wistia Data objects that you can access from apps and the dashboard.
-
Query Live Excel Online 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 Excel Online data directly from the development environment.
-
Query Greenplum Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Greenplum entities in PHP by modeling them as objects.
-
Write a Simple Go Application to work with VWO Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to VWO data.
-
Use the CData Software ODBC Driver for Auth0 in SAS for Real-Time Reporting and Analytics
Connect to real-time Auth0 data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Auth0.
-
Integrate with Live Google Contacts Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Contacts from the MuleSoft Anypoint Platform to integrate live Google Contacts data into custom reports and dashboards.
-
Integrate with live Bright Data Data in Jitterbit
Use CData Connect AI to connect to and integrate live Bright Data data in Jitterbit.
-
Publish Reports with HBase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HBase data.
-
Build Charts with Instantly Data in Clear Analytics
Create dynamic charts and perform analytics based on Instantly data in Clear Analytics.
-
Validate SAP Business One Data with QuerySurge
Access and validate SAP Business One data in QuerySurge using the CData JDBC Driver.
-
Use the CData ODBC Driver for Odoo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Odoo to connect to Odoo data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Odoo data in Excel.
-
Configure the CData JDBC Driver for Foursquare in a Connection Pool in Tomcat
Connect to Foursquare data from a connection pool in Tomcat.
-
Integrate Nuclia with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Nuclia with External Services.
-
Configure the CData JDBC Driver for LinkedIn in a Connection Pool in Tomcat
Connect to LinkedIn data from a connection pool in Tomcat.
-
Use ChatGPT to Talk to Your Highrise 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 Highrise data for you.
-
Access Live Google Tasks Data in AWS Lambda
Connect to live Google Tasks data in AWS Lambda using the CData JDBC Driver.
-
Access Live Pinterest Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Pinterest data from your Google Sheets.
-
Add PabblySubscriptions Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PabblySubscriptions with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to PolarTeamPro Data in JRuby
Create a simple JRuby app with access to live PolarTeamPro data.
-
Build Pipelines with Live Certinia Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Certinia from Google Cloud Data Fusion, enabling the integration of live Certinia data into the building and management of effective data pipelines.
-
Prepare, Blend, and Analyze FHIR Data in Alteryx Designer (ODBC)
Build workflows to access live FHIR data for self-service data analytics.
-
Automated Continuous Auth0 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Auth0 replication to PostgreSQL.
-
Build Charts with Teamgate Data in Clear Analytics
Create dynamic charts and perform analytics based on Teamgate data in Clear Analytics.
-
Getting Started with the CData ODBC Driver for Todoist
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Todoist.
-
Connect to Sage 300 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Sage 300 and the SQL Gateway to access Sage 300 data from Google Apps Script.
-
Connect to Sendwithus in SpagoBI
Create reports featuring live Sendwithus data in SpagoBI Studio. Host Sendwithus reports on SpagoBI Server.
-
Use Dash to Build Web Apps on Epicor Kinetic Data via CData Connect AI
Build interactive Dash web apps on live Epicor Kinetic data using pandas and the CData Connect AI Python SDK.
-
Integrating Claude Code CLI with Bright Data 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 with Mailgun Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Mailgun data to a JSON file on disk.
-
Build Monday.com-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Monday.com data and build web apps with connectivity to live Monday.com data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LaunchDarkly
Provide connectivity to LaunchDarkly data through an SAP BusinessObjects universe.
-
How to load SAP Concur data into Elasticsearch via Logstash
Introducing a simple method to load SAP Concur data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query Excel Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Excel entities in PHP by modeling them as objects.
-
Create Microsoft OneDrive-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft OneDrive Data from Nintex Workflow Cloud and build custom workflows using live Microsoft OneDrive data.
-
Replicate Monday.com Data to Multiple Databases via the CData Sync CLI
Replicate Monday.com data to disparate databases with a single configuration.
-
Access Live Vault CRM Data in TIBCO Data Virtualization
Use the Vault CRM Tibco DV Adapter to create a Vault CRM data data source in TIBCO Data Virtualization Studio and gain access to live Vault CRM data from your TDV Server.
-
Build Demio-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Demio data.
-
Analyze Bitbucket Data in Looker
Use CData Connect AI to connect to Bitbucket Data from Looker and build custom apps using live Bitbucket data.
-
Object-Relational Mapping (ORM) with SAP BusinessObjects BI Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP BusinessObjects BI data into a Java-based ORM framework, Hibernate.
-
Create Stripe Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Stripe data access from reports, embedded analytics, and more.
-
Integrate Devin with Live Salesforce Marketing Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Salesforce Marketing data.
-
Use the CData ODBC Driver for AdRoll from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for AdRoll to connect to AdRoll data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring AdRoll data in Excel.
-
Connect to Impala Data in DBeaver
Use the CData ODBC Driver to connect to Impala data in DBeaver.
-
Create Dynamics NAV-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Dynamics NAV Data from Klipfolio and build custom visualizations using live Dynamics NAV data.
-
Build a PostgreSQL Interface for SAP HANA Data using the CData JDBC Driver
Use the Remoting features of the SAP HANA JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to MYOB AccountRight Data in RazorSQL
Connect to MYOB AccountRight from wizards and query MYOB AccountRight data from the GUI in the RazorSQL database management tool.
-
Connecting GenSpark with Monday.com Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Monday.com data without any replication or custom integration required.
-
Connect to Snapchat Ads Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Snapchat Ads data from Filemaker Pro on Mac.
-
How to Access Live Amazon Marketplace Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Amazon Marketplace enables you to integrate Amazon Marketplace data into workflows built using Microsoft Power Automate Desktop.
-
Visualize Live SAP Hybris C4C Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Hybris C4C data into custom reports in Power BI.
-
Add iContact Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for iContact with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Manus AI to Talk to Your Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Zoom data.
-
Model, Search, and Visualize Live Presto Data in ThoughtSpot
Use CData Connect AI to connect to live Presto data for modeling, searching, and visualizing.
-
Connect to Asana Data from HeidiSQL
Use CData Connect AI to connect to and query live Asana data from HeidiSQL.
-
How to Connect Flowise AI Agents to Live ConstantContact Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live ConstantContact data without replication.
-
Build Wave Financial Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Wave Financial data and build visualizations in Tableau.
-
Automated Continuous MailerSend Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MailerSend replication to Google BigQuery.
-
Automated Continuous Spotify Replication to SQL Server
Use CData Sync for automated, continuous, customizable Spotify replication to SQL Server.
-
Stream HubDB Data into Apache Kafka Topics
Access and stream HubDB data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Billsby Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Billsby data replication to OneLake in Microsoft Fabric.
-
Viewing Placid Data in RAD Studio Data Explorer
How to view Placid data in RAD Studio Data Explorer using the CData ODBC Driver for Placid.
-
Import Real-Time PingOne Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PingOne data in ColdFusion.
-
Automated Continuous ServiceNow Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ServiceNow replication to PostgreSQL.
-
Integrate with Live Paylocity Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Paylocity from the MuleSoft Anypoint Platform to integrate live Paylocity data into custom reports and dashboards.
-
Automated Continuous MailerLite Replication to MongoDB
Use CData Sync for automated, continuous, customizable MailerLite replication to MongoDB.
-
Publish NASA-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live NASA data.
-
Use Dash to Build Web Apps on MailChimp Data via CData Connect AI
Build interactive Dash web apps on live MailChimp data using pandas and the CData Connect AI Python SDK.
-
Integrating Codex with SendInBlue 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.
-
Extract, Transform, and Load Recurly Data in Informatica PowerCenter
Create a simple Workflow for Recurly data in Informatica PowerCenter.
-
Integrate Amazon Athena Data in the Pentaho Report Designer
Publish reports based on Amazon Athena data in the Pentaho BI tool.
-
Analyze Marketo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Marketo from Power Pivot. You will use the Table Import Wizard to load Marketo data. You can visually build the import query or use any SQL supported by the driver.
-
Build a PostgreSQL Interface for Exact Online Data using the CData JDBC Driver
Use the Remoting features of the Exact Online JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Teamgate Data in RazorSQL
Connect to Teamgate from wizards and query Teamgate data from the GUI in the RazorSQL database management tool.
-
How to connect to Google Calendar Data with Squirrel SQL client
Connect to Google Calendar data and execute queries in the Squirrel SQL Client.
-
Integrating Antigravity CLI with Splunk data via CData CLI
Connect Splunk data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to publish and share Google Contacts Data dashboards with Tableau Server
The CData ODBC driver for Google Contacts enables you integrate Google Contacts data into Tableau dashboards.
-
Connect to Sybase Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Sybase data in Airbyte.
-
Use Databricks Agent Bricks to Talk to Your Coda Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Coda data for you.
-
Creating eBay Analytics-Connected Applications in Unqork
You can use CData Connect AI to feed eBay Analytics data to Unqork and build custom business apps.
-
Connect to Insightly Data from PowerBuilder via JDBC
This article demonstrates how to access Insightly data from PowerBuilder using the Insightly JDBC Driver.
-
Bridge MailerSend Connectivity with Apache NiFi
Access and process MailerSend data in Apache NiFi using the CData JDBC Driver.
-
How to update Office 365 from Excel
This article explains how to transfer data from Excel to Office 365 using the Excel Add-In for Office 365.
-
Integrating Oracle Eloqua Reporting Data in Talend Cloud Data Management Platform
Connect Oracle Eloqua Reporting Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle Eloqua Reporting.
-
Pingdom Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Pingdom facts in real time.
-
How to Connect to Live Timely Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Timely data through natural language.
-
Build AI Agents with Microsoft Entra ID 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 Microsoft Entra ID data through CData Connect AI.
-
Analyze Google Calendar Data in Looker
Use CData Connect AI to connect to Google Calendar Data from Looker and build custom apps using live Google Calendar data.
-
Manage BambooHR Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for BambooHR.
-
Use Dash to Build Web Apps on RSS Feeds via CData Connect AI
Build interactive Dash web apps on live RSS feeds using pandas and the CData Connect AI Python SDK.