CData Software - Knowledge Base
Recent Articles
-
Connect to SAP Fieldglass from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Fieldglass to connect to SAP Fieldglass from Web applications running on WebLogic.
-
Build Apps with Live SAS Data Sets in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAS Data Sets into the Adalo platform and build custom mobile and web applications with real-time SAS Data Sets.
-
Integrate with Adobe Target Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Adobe Target to a JSON file on disk.
-
Build Pipelines with Live SharePoint Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SharePoint from Google Cloud Data Fusion, enabling the integration of live Microsoft SharePoint into the building and management of effective data pipelines.
-
Build Visualizations of Google Tasks Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Tasks in Birst.
-
Operational Reporting on Confluence Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Atlassian Confluence.
-
Integrating Codex CLI with Miro 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.
-
EmailOctopus Reporting in OBIEE with the EmailOctopus JDBC Driver
Deploy the EmailOctopus JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Stream Eventbrite Data into Apache Kafka Topics
Access and stream Eventbrite in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connecting Mastra with Email Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Email, no replication required.
-
Connect to Outreach.io Data in RapidMiner
Integrate Outreach.io with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Claude Code with OData Services via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on OData within assisted coding and automated development workflows.
-
Automated Continuous WordPress Replication to Databricks
Use CData Sync for automated, continuous, customizable WordPress replication to Databricks.
-
Getting Started with the CData Python Connector for Adobe Experience Manager
Learn to install and license the CData Python Connector
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google Directory to Power BI dashboards. Simply drag and drop Google Directory into data visuals on the Power BI canvas.
-
Use the CData Software ODBC Driver for Klipfolio in MicroStrategy Desktop
Connect to Klipfolio in MicroStrategy Desktop using the CData Software ODBC Driver for Klipfolio.
-
How to create SAP Netweaver Gateway federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Netweaver Gateway in MySQL .
-
Build Agents in Relevance AI with Access to Live Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Jira Assets within intelligent agent workflows.
-
Analyze Front Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Front with the CData JDBC Driver for Front.
-
Publish Reports with Azure DevOps Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure DevOps.
-
Establish a Live Connection with ShipStation Data using Tableau Bridge
The CData ODBC Driver for ShipStation enables you to integrate live ShipStation into Tableau Cloud dashboards using the Tableau Bridge.
-
Bidirectional Access to Shippo Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Shippo in Filemaker Pro for Mac or Windows.
-
How to Work with ZohoPeople Data in ETL Validator JDBC
Connect to ZohoPeople from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Zoho Inventory Data in Talend Cloud Data Management Platform
Connect Zoho Inventory Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Zoho Inventory.
-
Use the CData ODBC Driver for Jira Assets in Microsoft Power Query
You can use the CData Jira Assets ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Jira Assets into Microsoft Power Query.
-
How to Query Live CouchDB Data in Perplexity MacOS Desktop
Connect to and query live CouchDB Data in Perplexity Desktop using CData MCP Server.
-
Query Twilio Data as a SQL Server Database in Node.js
Execute SQL Server queries against Twilio from Node.js.
-
How to connect PolyBase to Stripe
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Stripe.
-
Using the CData Software ODBC Driver for LionDesk in PyCharm
Connect to LionDesk as an ODBC data source in PyCharm using the CData Software ODBC Driver for LionDesk.
-
How to Create Power BI Visual Reports with Real-Time Hive Data
Use CData Power BI Connectors to visualize Apache Hive in Power BI.
-
Use the CData ODBC Driver for Factorial in Microsoft Power Query
You can use the CData Factorial ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Factorial into Microsoft Power Query.
-
Connect to JobNimbus Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for JobNimbus and the SQL Gateway to access JobNimbus from Google Apps Script.
-
Integrate Live GraphQL Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live GraphQL to Blue Prism using the CData ODBC Driver for GraphQL to create automated workflows for repetitive business tasks.
-
Consume Quickbase OData Feeds in PowerBuilder
This article demonstrates how to consume Quickbase as OData feeds from PowerBuilder using the API Server.
-
Use Agno to Talk to Your Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Freshservice for you.
-
Analyze Short.io Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Short.io with the CData JDBC Driver for Short.io.
-
Build Data Flows from SQL Server to Hive through SSIS
Easily push SQL Server data to Hive using the CData SSIS Tasks for Hive.
-
Visualize Live Xero Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Xero Accounting.
-
Visualize Webflow Data in Sisense
Create an ElastiCube in Sisense app with access to Webflow.
-
Automated Continuous Copper Replication to MongoDB
Use CData Sync for automated, continuous, customizable Copper replication to MongoDB.
-
Integrating Boomi Agentstudio with Google Analytics Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Analytics, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build ShipStation-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ShipStation and build ShipStation-connected web apps with Axios.
-
Migrating data from SAP SuccessFactors to Google BigQuery using CData SSIS Components.
Easily push SAP SuccessFactors to Google BigQuery using the CData SSIS Tasks for SAP SuccessFactors and Google BigQuery.
-
Connect to ActiveCampaign Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ActiveCampaign and the SQL Gateway to access ActiveCampaign from Google Apps Script.
-
How to Connect to Tickspot Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Tickspot. Leverage the pyodbc module for ODBC in Python.
-
Query Sentry Data as a MySQL Database in Node.js
Execute MySQL queries against Sentry from Node.js.
-
How to Connect to Live Google Campaign Manager 360 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 Google Campaign Manager 360 for you.
-
Visualize Asana Data in Sisense
Create an ElastiCube in Sisense app with access to Asana.
-
Provide OData Services of Helpscout Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Helpscout by developing a WCF Service Application.
-
Replicate ElevenLabs Data from PowerShell
Write a quick PowerShell script to query ElevenLabs. Use connectivity to the live data to replicate ElevenLabs to SQL Server.
-
Integrate Live GitHub Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to GitHub and integrate live GitHub into apps built in Microsoft Power Apps.
-
Work with FreshBooks Data in FoxPro
Load FreshBooks into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with Google Sheets Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Sheets to a JSON file on disk.
-
Connect to Anaplan Data in Aqua Data Studio
Access Anaplan from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to and Query Act CRM Data in QlikView over ODBC
Create data visualizations with Act CRM in QlikView.
-
Automated Continuous LDAP Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable LDAP replication to Google Cloud SQL.
-
Use the CData ODBC Driver for Customer.io from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Customer.io to connect to Customer.io from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Customer.io in Excel.
-
Connect to Real-Time eBay Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for eBay and Dataflow to import and use eBay in Power Apps.
-
Analyze SAP SuccessFactors LMS Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP SuccessFactors LMS with the CData JDBC Driver for SAP SuccessFactors LMS.
-
Build Data Flows from SQL Server to Pipedrive through SSIS
Easily push SQL Server data to Pipedrive using the CData SSIS Tasks for Pipedrive.
-
Easily Integrate Datadog Data in Lazarus Pascal IDE
Learn how to easily integrate live Datadog in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Live LinkedIn Ads Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LinkedIn Ads.
-
Access Sybase IQ 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 Sybase IQ.
-
Connect to SendInBlue Data in JRuby
Create a simple JRuby app with access to live SendInBlue.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Snowflake
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Snowflake.
-
Bidirectional Access to Parallel Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Parallel in Filemaker Pro for Mac or Windows.
-
How to Query Live Redshift Data in Perplexity MacOS Desktop
Connect to and query live Redshift Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous Freshteam Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Freshteam replication to Amazon S3.
-
Visualize Amazon Athena Data in TIBCO Spotfire through OData
Integrate Amazon Athena into dashboards in TIBCO Spotfire.
-
How to connect PolyBase to Aha!
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Aha!.
-
How to load Microsoft Dataverse data into Elasticsearch via Logstash
Introducing a simple method to load Microsoft Dataverse data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Billsby from Asprova with CData Software ODBC Driver for Billsby
This article shows how to connect faster to Billsby data from Asprova.
-
Import Real-Time Hugging Face Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Hugging Face in ColdFusion.
-
Connect to Freshservice Data in HULFT Integrate
Connect to Freshservice as a JDBC data source in HULFT Integrate
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Certinia
Provide connectivity to Certinia through an SAP BusinessObjects universe.
-
Integrating LangGraph with Kintone Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Kintone within automated workflows.
-
Data Privacy And Security
We understand our drivers are used in applications and provide connectivity to sources that have private and sensitive information. We take security and privacy very seriously. Here we outline some of our relevant policies.
-
Use the CData Software JDBC Driver for Paddle in MicroStrategy Web
Connect to Paddle in MicroStrategy Web using the CData Software JDBC Driver for Paddle.
-
Create Informatica Mappings From/To a JDBC Data Source for GitHub
Create GitHub data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous ZohoPeople Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Google BigQuery.
-
Integrating Antigravity CLI with LionDesk via CData CLI
Connect LionDesk to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Mouseflow Data in RazorSQL
Connect to Mouseflow from wizards and query Mouseflow from the GUI in the RazorSQL database management tool.
-
Connect Google Search to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Search using the CData Python MCP Server.
-
How to Resolve the Issue of a Missing CData Tab in Excel
Access live data from various data sources directly in Excel using CData Excel Add-Ins.
-
Connect to Klipfolio Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Klipfolio as an External Source in Dremio.
-
Connect to Oracle SCM from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle SCM, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Aha! Data in Tableau
The CData ODBC driver for Aha! enables you integrate Aha! into Tableau dashboards.
-
Access Live JSON Services in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live JSON from your Google Sheets.
-
Connect to Databricks Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Databricks Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Extract, Transform, and Load Cosmos DB Data in Informatica PowerCenter
Create a simple Workflow for Azure Cosmos DB in Informatica PowerCenter.
-
A PostgreSQL Interface for SendPulse Data (MySQL Remoting via JDBC)
Use the Remoting features of the SendPulse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Foursquare 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 Foursquare and work with Foursquare in your FileMaker application.
-
Build Missive-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Missive and build web apps with connectivity to live Missive.
-
Visualize SendPulse Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SendPulse.
-
LINQ to Confluence 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 Confluence Data Provider.
-
Automate Dynamics NAV Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Dynamics NAV replication to Azure Data Lake.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Planner to Power BI dashboards. Simply drag and drop Microsoft Planner into data visuals on the Power BI canvas.
-
Prepare, Blend, and Analyze Pipeliner CRM Data in Alteryx Designer (ODBC)
Build workflows to access live Pipeliner CRM for self-service data analytics.
-
Access Live Dropbox Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Dropbox from your Excel spreadsheets.
-
LINQ to ServiceNow 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 ServiceNow Data Provider.