CData Software - Knowledge Base
Recent Articles
-
How to publish and share Helpscout Data dashboards with Tableau Server
The CData ODBC driver for Helpscout enables you integrate Helpscout into Tableau dashboards.
-
Access Live Act CRM Data in AWS Lambda
Connect to live Act CRM in AWS Lambda using the CData JDBC Driver.
-
Bidirectional Access to Planio Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Planio in Filemaker Pro for Mac or Windows.
-
How to integrate BenchmarkEmail with Apache Airflow
Access and process BenchmarkEmail in Apache Airflow using the CData JDBC Driver.
-
Create Reports from Lakebase Data in Looker Studio
Use CData Connect AI to gain access to live Lakebase and create custom reports in Looker Studio.
-
Use Databricks Agent Bricks to Talk to Your Marketo Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Marketo for you.
-
How to Access Live REST Data in Visual Studio Code via Cline
Run CData MCP Server for REST on Windows Subsytem for Linux (WSL) and connect to live REST from the Cline extension in Visual Studio Code.
-
Automated Continuous GitHub Replication to AlloyDB
Use CData Sync for automated, continuous, customizable GitHub replication to AlloyDB.
-
Automated Continuous ClickUp Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ClickUp replication to Google Cloud SQL.
-
How Derived Views in Connect AI Reduce LLM Token Usage
Learn how Derived Views and Connect AI’s semantic layer reduce token costs and speed up multi-source analytics.
-
Bidirectional Access to CouchDB Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apache CouchDB in Filemaker Pro for Mac or Windows.
-
Integrate with Pingdom Data in JReport Designer
Create charts and reports based on Pingdom in JReport Designer.
-
Automated Continuous eBay Replication to Snowflake
Use CData Sync for automated, continuous, customizable eBay replication to Snowflake.
-
Create a Data Access Object for Facebook Data using JDBI
A brief overview of creating a SQL Object API for Facebook in JDBI.
-
Use Dash to Build to Web Apps on WooCommerce Data
Create Python applications that use pandas and Dash to build WooCommerce-connected web apps.
-
Automate Perplexity Data Replication to Azure Synapse
Use CData Sync to customize and automate Perplexity replication to Azure Synapse.
-
DataBind Controls to ZarMoney Data in Delphi
DataBind to ZarMoney in Delphi with standard data access components and controls.
-
Automated Continuous Front Replication to Vertica
Use CData Sync for automated, continuous, customizable Front replication to Vertica.
-
Use JayDeBeApi to access Gong Data in Python
Use standard Python scripting and the development environment of your choice to access live Gong.
-
How to Connect to Live Slack Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Slack for you.
-
Analyze Live SAP Netweaver Gateway Data in SAS Viya
Use CData Connect AI to connect to SAP Netweaver Gateway from SAS Viya and deploy self-service analytics using live SAP Netweaver Gateway.
-
Back Up Microsoft OneNote to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for OneNote. In this article, we will employ an SSIS workflow to populate a database with Microsoft OneNote data.
-
How to Visualize Pipedrive Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Pipedrive in Python.
-
Connecting Mastra with SQL Server 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 Microsoft SQL Server, no replication required.
-
Create Datasets from Foursquare in Domo Workbench and Build Visualizations of Foursquare Data in Domo
Use the CData Software ODBC Driver for Foursquare to create datasets from Foursquare in Domo Workbench and then build visualizations in the Domo service.
-
Import Real-Time OpenWeatherMap Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use OpenWeatherMap in ColdFusion.
-
Connect to Yelp Data in DBArtisan
Use wizards in DBArtisan to configure Yelp as a data source.
-
Easily Integrate Delighted Data in Lazarus Pascal IDE
Learn how to easily integrate live Delighted in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build SendGrid Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SendGrid and build visualizations in Tableau.
-
DataBind Controls to RSS Feeds in C++Builder
DataBind to RSS Feeds in C++Builder with standard components and controls.
-
Natively Connect to FreeAgent Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to FreeAgent. Leverage the native support for ODBC in PHP.
-
Natively Connect to Freshdesk Data in PHP
The CData ODBC driver for Freshdesk enables you to create PHP applications with connectivity to Freshdesk. Leverage the native support for ODBC in PHP.
-
Connect to Intercom Data from a Connection Pool in Jetty
The Intercom JDBC Driver supports connection pooling: This article shows how to connect faster to Intercom from Web apps in Jetty.
-
Connect to iContact Data from PowerBuilder via ADO.NET
This article demonstrates how to access iContact from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Cloudant Data in RazorSQL
Connect to Cloudant from wizards and query IBM Cloudant from the GUI in the RazorSQL database management tool.
-
How to Connect ServiceNow Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live ServiceNow data in real time using natural language.
-
Build a PostgreSQL Interface for Microsoft Entra ID Data using the CData JDBC Driver
Use the Remoting features of the Microsoft Entra ID JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Kiro CLI with Bannerbear 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.
-
Viewing Cloudflare Data in RAD Studio Data Explorer
How to view Cloudflare in RAD Studio Data Explorer using the CData ODBC Driver for Cloudflare.
-
Integrate Goose with Live Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Oracle Sales from within the local AI agent.
-
Connect to Certinia Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Certinia.
-
Deploy the ADO.NET Provider for Pinterest on an SSRS Report Server
Connect to Pinterest from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build a Simple VCL Application for FTP Data
How to build a simple VCL Application to view FTP Servers in RAD Studio using the CData ODBC Driver for FTP.
-
Query Amazon Athena Data as a SQL Server Database in Node.js
Execute SQL Server queries against Amazon Athena from Node.js.
-
Query Confluence Data in DataGrip
Create a Data Source for Confluence in DataGrip and use SQL to query live Atlassian Confluence.
-
How to publish and share ZeroBounce Data dashboards with Tableau Server
The CData ODBC driver for ZeroBounce enables you integrate ZeroBounce into Tableau dashboards.
-
Integrate SuiteCRM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SuiteCRM from Informatica Cloud.
-
Automated Continuous Elorus Replication to Vertica
Use CData Sync for automated, continuous, customizable Elorus replication to Vertica.
-
How to Query Live Monday.com Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Monday.com data in natural language using Python.
-
Use the CData ODBC Driver for Freshteam in Microsoft Power Query
You can use the CData Freshteam ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Freshteam into Microsoft Power Query.
-
Connect to SAP Business One Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP Business One from Filemaker Pro on Mac.
-
Build Pipelines with Live Blackbaud FE NXT Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Blackbaud FE NXT from Google Cloud Data Fusion, enabling the integration of live Blackbaud FE NXT into the building and management of effective data pipelines.
-
Working with FHIR Data in LINQPad
Execute LINQ queries to FHIR in LINQPad.
-
Integrating Clockify Data in Talend Cloud Data Management Platform
Connect Clockify Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Connect to Live Zoho Creator 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 Zoho Creator for you.
-
Integrate Authorize.Net with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Authorize.Net with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Authorize.Net.
-
Query Zendesk Data as a MySQL Database in Node.js
Execute MySQL queries against Zendesk from Node.js.
-
Use Azure AI Foundry to Talk to Your SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAP Business One for you.
-
View Reports on Real-Time Opsgenie Data in Power BI Report Server
Use the CData ODBC Driver for Opsgenie to visualize Opsgenie in Power BI Desktop and then publish them to Power BI Report Server.
-
Build a Singer.io Tap for Foursquare With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Foursquare data using
-
Connect to Redshift Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Amazon Redshift in Airbyte.
-
Automated Continuous Oracle Sales Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle Sales replication to SQL Server.
-
Create SSAS Tabular Models from Blackbaud FE NXT Data
How to build a SQL Server Analysis Service Tabular Model from Blackbaud FE NXT using CData drivers.
-
Integrating Cursor CLI with Pingdom 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 to Live Google Ads Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Google Ads for you.
-
Build Visualizations of ServiceNow Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ServiceNow in Birst.
-
Edit and Search LinkedIn External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of LinkedIn to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create LinkedIn objects that you can access from apps and the dashboard.
-
Connect to Brex 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 Brex and work with Brex in your FileMaker application.
-
Use the CData Software ODBC Driver for ServiceNow in MicroStrategy Desktop
Connect to ServiceNow in MicroStrategy Desktop using the CData Software ODBC Driver for ServiceNow.
-
Query Foursquare Data in ColdFusion
Write standard ColdFusion data access code to connect to Foursquare.
-
Access Live Pushbullet Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Pushbullet in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build SAP Concur-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP Concur Data from Zoho Analytics and import live SAP Concur.
-
Integrating Antigravity CLI with Zoho Projects via CData CLI
Connect Zoho Projects to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Extract, Transform, and Load Outlook Data in Informatica PowerCenter
Create a simple Workflow for Outlook in Informatica PowerCenter.
-
Validate Couchbase Data with QuerySurge
Access and validate Couchbase in QuerySurge using the CData JDBC Driver.
-
Connect to ShipEngine Data in DBeaver
Use the CData ODBC Driver to connect to ShipEngine in DBeaver.
-
Connect to Discourse Data in DBArtisan
Use wizards in DBArtisan to configure Discourse as a data source.
-
Establish a Live Connection with Sybase IQ Data using Tableau Bridge
The CData ODBC Driver for Sybase IQ enables you to integrate live Sybase IQ into Tableau Cloud dashboards using the Tableau Bridge.
-
Automate FreeAgent Data Replication to Couchbase
Use CData Sync to Customize and automate FreeAgent replication to Couchbase.
-
Excel Spreadsheet Automation on Strava Data with the QUERY Formula
Pull data from Strava, automate spreadsheets, and more with the QUERY formula.
-
How to use SQLAlchemy ORM to access ZohoSubscriptions Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ZohoSubscriptions.
-
Integrate SAP SuccessFactors LMS Data in the Pentaho Report Designer
Publish reports based on SAP SuccessFactors LMS in the Pentaho BI tool.
-
Access FHIR Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access FHIR from your Oracle system.
-
Access Live eBay Analytics Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live eBay Analytics data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Semantic Layer Views for Paymo Data in APOS Live Data Gateway
Use the CData Connector for Paymo in APOS Live Data Gateway to build Semantic Layer Views for Paymo.
-
Work with Authorize.Net Data in FoxPro
Load Authorize.Net into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Live OneNote 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 Microsoft OneNote directly from the development environment.
-
Query LeadDesk Data in DataGrip
Create a Data Source for LeadDesk in DataGrip and use SQL to query live LeadDesk.
-
Automated Continuous Excel Online Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Excel Online replication to IBM DB2.
-
Connect to Close Data in HULFT Integrate
Connect to Close as a JDBC data source in HULFT Integrate
-
How to Connect to Live Zendesk 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 Zendesk for you.
-
Access Live EnterpriseDB 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 EnterpriseDB through MCP integration.
-
Replicate MySQL Data from PowerShell
Write a quick PowerShell script to query MySQL. Use connectivity to the live data to replicate MySQL to SQL Server.
-
Integrating Cursor CLI with Outlook 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.
-
Connect to and Query Salesforce CRM Analytics Data in QlikView over ODBC
Create data visualizations with Salesforce CRM Analytics in QlikView.
-
How to Query Databricks Data in MySQL Workbench
Execute MySQL queries against live Databricks from MySQL Workbench.
-
Build Semantic Layer Views for SageHR Data in APOS Live Data Gateway
Use the CData Connector for SageHR in APOS Live Data Gateway to build Semantic Layer Views for SageHR.
-
Consume Adobe Commerce OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Adobe Commerce feeds that reflect any changes in SAP Lumira.
-
Query, Visualize, and Share live BigCommerce Data in Redash
Use CData Connect AI to connect to live BigCommerce in Redash for querying, visualizing, and sharing.
-
Automated Continuous Typeform Replication to MongoDB
Use CData Sync for automated, continuous, customizable Typeform replication to MongoDB.