CData Software - Knowledge Base
Recent Articles
-
How to Query Live Google Ads Data in Perplexity MacOS Desktop
Connect to and query live Google Ads Data in Perplexity Desktop using CData MCP Server.
-
Connect to Attio Data in JRuby
Create a simple JRuby app with access to live Attio.
-
Connect to Vercel Data in Aqua Data Studio
Access Vercel from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Pipeline CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to MySQL.
-
How to import Google Campaign Manager 360 Data into Apache Solr
Use the CData Software JDBC Driver for Google Campaign Manager 360 in Data Import Handler and create an automated import of Google Campaign Manager 360 to Apache Solr Enterprise Search platform.
-
Automated Continuous Zoho Creator Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Amazon S3.
-
Connect to AdRoll from a Connection Pool in WebLogic
Use the CData JDBC Driver for AdRoll to connect to AdRoll from Web applications running on WebLogic.
-
How to Build an ETL App for Bugsnag Data in Python with CData
Create ETL applications and real-time data pipelines for Bugsnag in Python with petl.
-
How to Connect to Live Trello Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Trello securely in real time.
-
Natively Connect to Zoho Projects Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zoho Projects. Leverage the native support for ODBC in PHP.
-
Edit and Search Amazon Marketplace External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Amazon Marketplace to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Amazon Marketplace objects that you can access from apps and the dashboard.
-
Import IBM Informix Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to IBM Informix Data and provide access to live IBM Informix for custom reports in the Power BI Service.
-
Connect to Ontraport Data from PowerBuilder via JDBC
This article demonstrates how to access Ontraport from PowerBuilder using the Ontraport JDBC Driver.
-
Automated Continuous Jodoo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Jodoo replication to Snowflake.
-
Build Apps with Live Amazon Marketplace Data Using the Low-Code Development Platform of Mendix
Connect Amazon Marketplace with Mendix to build apps using the CData JDBC Driver for Amazon Marketplace.
-
Use Grok to Talk to Your Lakebase 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 Lakebase for you.
-
Connect Suadeo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Suadeo using the CData Python MCP Server.
-
Analyze Vercel Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Vercel and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect Amazon DynamoDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Amazon DynamoDB using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Publish ZohoPeople-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZohoPeople.
-
Create Google Search-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Search Results from OutSystems and build custom enterprise apps using live Google Search.
-
Integrate Confluence with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Confluence with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Atlassian Confluence.
-
Access Live Typeform Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Typeform data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Migrating data from Parallel to Snowflake using CData SSIS Components.
Easily push Parallel to Snowflake using the CData SSIS Tasks for Parallel and Snowflake.
-
Integrate Paddle with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Paddle with External Services.
-
Connect Workday to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Workday with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous ZohoSubscriptions Replication to SQLite
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to SQLite.
-
Write a Simple Go Application to work with SageHR Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SageHR.
-
Visualize Active Directory Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Active Directory into TIBCO Spotfire.
-
Edit and Search Freshteam External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Freshteam to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Freshteam objects that you can access from apps and the dashboard.
-
Build a Salesforce Integration with Java and MCP Server
Accelerate Salesforce-Java integration from days to hours using AI-assisted development with CData drivers and Cursor IDE
-
Create Data Visualizations Based On Klaviyo Data in Mode
Use CData Connect AI to connect to Klaviyo Data from Mode and build visualizations using live
-
Integrating LangChain with HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on HCL Domino within automated workflows.
-
Connect SAP Ariba Procurement to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Ariba Procurement with IBM WebSphere for seamless data integration and connectivity.
-
How to create Bugsnag federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Bugsnag in MySQL .
-
Build a Singer.io Tap for Highrise With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Highrise data using
-
Connect to and Visualize Live Paddle Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Paddle.
-
Automated Continuous Shortcut Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Shortcut replication to IBM DB2.
-
How to Work with Vault CRM Data in AWS Glue Jobs Using JDBC
Connect to Vault CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Teamgate Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Teamgate replication to IBM DB2.
-
Analyze Cosmos DB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Azure Cosmos DB and visualize live Azure Cosmos DB in Infragistics Reveal.
-
Connect Pipedrive Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Pipedrive using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Stream SAP Ariba Procurement Data into Apache Kafka Topics
Access and stream SAP Ariba Procurement in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData JDBC Driver for Mouseflow
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mouseflow.
-
Import Zoho Creator Data Using Azure Data Factory
Use CData Connect AI to connect to Zoho Creator Data from Azure Data Factory and import live Zoho Creator.
-
Access Unbounce Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Unbounce from HeidiSQL.
-
Automate Google Search Results Replication to Azure Data Lake
Use CData Sync to customize and automate Google Search replication to Azure Data Lake.
-
Getting Started with the CData Excel Add-In for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP SuccessFactors LMS.
-
How to Connect Flowise AI Agents to Live Greenhouse 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 Greenhouse without replication.
-
How to Import Data from Act CRM into Google Sheets
Import Act CRM into a Google spreadsheet that is automatically refreshed.
-
Connect to Discord Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Discord and work with Discord in your FileMaker applications.
-
How to Create Power BI Visual Reports with Real-Time Missive Data
Use CData Power BI Connectors to visualize Missive in Power BI.
-
Getting Started with the CData Power BI Connector for ZohoSubscriptions
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to integrate Google Calendar with Apache Airflow
Access and process Google Calendar in Apache Airflow using the CData JDBC Driver.
-
Connect to Snapchat Ads Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Snapchat Ads in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Wistia Replication to SQL Server
Use CData Sync for automated, continuous, customizable Wistia replication to SQL Server.
-
How to work with Facebook Ads Data in Apache Spark using SQL
Access and process Facebook Ads Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Google Forms Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Forms replication to Apache Kafka.
-
How to work with Short.io Data in Apache Spark using SQL
Access and process Short.io Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData ODBC Driver for SAP Fieldglass from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Fieldglass to connect to SAP Fieldglass from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Fieldglass in Excel.
-
Access Auth0 Data from MySQL in PHP
Connect to Auth0 through the standard MySQL libraries in PHP.
-
Operational Reporting on Onfleet Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Onfleet.
-
Connect to Google Cloud Storage Data from a Connection Pool in JBoss
Integrate Google Cloud Storage into Java servlets: Use the Management Console in JBoss to install the Google Cloud Storage JDBC Driver.
-
Bridge Zoom Connectivity with Apache NiFi
Access and process Zoom in Apache NiFi using the CData JDBC Driver.
-
Extract, Transform, and Load Sybase Data in Informatica PowerCenter
Create a simple Workflow for Sybase in Informatica PowerCenter.
-
Integrate Open WebUI with Live Google Search Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Search from within the chat interface.
-
How to Connect DBeaver to Gong via a JDBC Driver
Manage Gong with visual tools in DBeaver like the query browser.
-
Integrating GitHub Copilot CLI with ZeroBounce 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 Real-Time Access to Datadog in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Datadog in real time.
-
Choosing the Best Method to Connect Zuora to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zuora from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
LINQ to Optimizely 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 Optimizely Data Provider.
-
Manage CloudConvert Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CloudConvert.
-
Connect to Vault CRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Vault CRM as an External Source in Dremio.
-
Create Reports with Pipedrive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pipedrive.
-
Automated Continuous Dynamics NAV Replication to MySQL
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to MySQL.
-
Integrating Boomi Agentstudio with Okta Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Okta, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Extend Google Sheets with Presto Data
Make calls to Presto from Google Apps Script via the API Server.
-
Build AI/ML Models with Live Eventbrite Data using Dataiku
Connect Eventbrite Data with Dataiku using the CData API Driver for JDBC.
-
Build a PostgreSQL Interface for Lakebase Data using the CData JDBC Driver
Use the Remoting features of the Lakebase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Excel Spreadsheet Automation on LightSpeedRetail Data with the QUERY Formula
Pull data from LightSpeedRetail, automate spreadsheets, and more with the QUERY formula.
-
Integrating Gumloop with Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Contacts within automated workflows.
-
Migrating data from Facebook to Databricks using CData SSIS Components.
Easily push Facebook to Databricks using the CData SSIS Tasks for Facebook and Databricks.
-
How to connect Amazon QuickSight to MYOB AccountRight Data
Create a connection to MYOB AccountRight in CData Connect AI and insert MYOB AccountRight into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Kintone Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Kintone from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software ODBC Driver for Couchbase in MicroStrategy Web
Connect to Couchbase in MicroStrategy Web using the CData Software ODBC Driver for Couchbase.
-
Build AI/ML Models with Live Facebook Ads Data using Dataiku
Connect Facebook Ads Data with Dataiku using the CData JDBC Driver for Facebook Ads.
-
Integrating Claude Code CLI with Jira 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 LlamaIndex with Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Couchbase in real time.
-
Publish Reports with Kafka Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Kafka.
-
Enable the Access JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Access.
-
Use the CData ODBC Driver for Splunk in Microsoft Power Query
You can use the CData Splunk ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Splunk into Microsoft Power Query.
-
Integrate Oracle Financials Cloud with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle Financials Cloud with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Financials Cloud.
-
Automated Continuous Reckon Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Reckon replication to delimited files (CSV/TSV).
-
Create Power BI Reports on Real-Time SparkPost Data
Use the CData ODBC Driver for SparkPost to visualize SparkPost in Power BI Desktop.
-
Connect to Snowflake Data in HULFT Integrate
Connect to Snowflake as a JDBC data source in HULFT Integrate
-
Connecting Agentforce with Amazon S3 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 Amazon S3 for you.
-
Connect to Cvent in SpagoBI
Create reports featuring live Cvent in SpagoBI Studio. Host Cvent reports on SpagoBI Server.
-
How to Connect DBeaver to Quickbase via a JDBC Driver
Manage Quickbase with visual tools in DBeaver like the query browser.
-
Build Automated Google Ad Manager-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Ad Manager and build automated workflows in Zapier.
-
Use the CData Software ODBC Driver for Sage Cloud Accounting in MicroStrategy Web
Connect to Sage Business Cloud Accounting in MicroStrategy Web using the CData Software ODBC Driver for Sage Cloud Accounting.