CData Software - Knowledge Base
Recent Articles
-
Create Reports with Aircall Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Aircall data.
-
Build MVC Applications with Connectivity to Microsoft Planner Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Microsoft Planner from an ASP.NET MVC application.
-
Build Apps with Live Sage 300 Data Using the Low-Code Development Platform of Mendix
Connect Sage 300 data with Mendix to build apps using the CData JDBC Driver for Sage 300.
-
Integrate Goose with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SQL Server data from within the local AI agent.
-
How to publish and share Paylocity Data dashboards with Tableau Server
The CData ODBC driver for Paylocity enables you integrate Paylocity data into Tableau dashboards.
-
Integrate Cline with Live Salesforce Data 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Salesforce Data 360 data from within your IDE.
-
Connect to Freshteam Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Freshteam as an External Source in Dremio.
-
Visualize Live Discourse Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Discourse data.
-
Connect to SharePoint Data from PowerBuilder via JDBC
This article demonstrates how to access SharePoint data from PowerBuilder using the SharePoint JDBC Driver.
-
Connect to SAP Business Warehouse Data from a Connection Pool in Jetty
The SAP Business Warehouse JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Business Warehouse data from Web apps in Jetty.
-
How to Easily Query Klipfolio Data in OpenOffice Base
Connect to Klipfolio data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build Copper-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Copper data.
-
Access Live Google Contacts Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Google Contacts data through MCP integration.
-
Integrating Codex with Suadeo 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 Google Cloud Storage Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Cloud Storage data using standard SQL.
-
Connect to Superchat Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Superchat to connect to Superchat data and execute queries in PowerBuilder.
-
Work with Google Calendar Data in FoxPro
Load Google Calendar data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Stream Supabase Data into Apache Kafka Topics
Access and stream Supabase data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize CapsuleCRM 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 CapsuleCRM data into TIBCO Spotfire.
-
Getting Started with the CData Python Connector for Splunk
Learn to install and license the CData Python Connector and configure a connection to live Splunk data.
-
Analyze Reckon Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Reckon data and visualize live Reckon data in Infragistics Reveal.
-
Use the CData Software ODBC Driver for JotForm in MicroStrategy Desktop
Connect to JotForm data in MicroStrategy Desktop using the CData Software ODBC Driver for JotForm.
-
How to Connect to Live Azure Synapse 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 Azure Synapse data for you.
-
Connect to SAP Netweaver Gateway Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Netweaver Gateway data from PowerBuilder using the SAP Netweaver Gateway JDBC Driver.
-
Excel Spreadsheet Automation on Sentry Data with the QUERY Formula
Pull data from Sentry, automate spreadsheets, and more with the QUERY formula.
-
How to Access Live Harvest Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Harvest enables you to integrate Harvest data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Pinterest Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Pinterest data replication to OneLake in Microsoft Fabric.
-
How to Connect to Live Jira Assets 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 Jira Assets data for you.
-
Replicate Multiple Paddle Accounts
Replicate multiple Paddle accounts to one or many databases.
-
Build Semantic Layer Views for Aha! Data in APOS Live Data Gateway
Use the CData Connector for Aha! in APOS Live Data Gateway to build Semantic Layer Views for Aha! data.
-
Build Sybase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sybase data.
-
Building Dynamic Web Pages with Basecamp Data Using AngularJS
Create single-page applications with live connectivity to Basecamp using the CData API Server.
-
Work with Live ConstantContact Data in Power Query
Use CData Connect AI to connect to ConstantContact data and work with live ConstantContact data in Microsoft Power Query.
-
Connect to Office 365 Data in JRuby
Create a simple JRuby app with access to live Office 365 data.
-
Write a Simple Go Application to work with AlloyDB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to AlloyDB data.
-
Interact with Live ActiveCampaign Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live ActiveCampaign data.
-
How to Connect Samanage 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 Samanage data in real time using natural language.
-
Replicate SAP Concur Data to Multiple Databases via the CData Sync CLI
Replicate SAP Concur data to disparate databases with a single configuration.
-
Connect to Aircall Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Aircall.
-
Connect to SAP HANA XS Advanced Data from a Connection Pool in JBoss
Integrate SAP HANA XS Advanced data into Java servlets: Use the Management Console in JBoss to install the SAP HANA XS Advanced JDBC Driver.
-
How to Use a Microsoft Access Database to Update Dynamics CRM Data in Real Time
Update Dynamics CRM data by creating a linked table in Microsoft Access with the CData Dynamics CRM ODBC Driver.
-
Getting Started with the CData Excel Add-In for Klaviyo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Klaviyo.
-
How to Connect DBeaver to Tanda via a JDBC Driver
Manage Tanda data with visual tools in DBeaver like the query browser.
-
Build Visualizations of Zoom Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoom data in Birst.
-
Analyze Wistia Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Wistia data and visualize Wistia data in SAP Analytics Cloud.
-
Build a Simple VCL Application for Exact Online Data
How to build a simple VCL Application to view Exact Online data in RAD Studio using the CData ODBC Driver for Exact Online.
-
Automated Continuous Quickbase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Quickbase replication to AlloyDB.
-
Replicate HubSpot Data in Heroku for Use in Salesforce Connect
Replicate HubSpot data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous PostgreSQL Replication to Amazon S3
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Amazon S3.
-
Connect to Live IBM Cloud Object Storage Data in MicroStrategy through CData Connect AI
Create a live connection to IBM Cloud Object Storage Data in CData Connect AI and connect to your IBM Cloud Object Storage data from MicroStrategy.
-
Integrate Odoo Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Odoo data and integrate live Odoo data into your Power Automate tasks.
-
Connect to Tavily Data from HeidiSQL
Use CData Connect AI to connect to and query live Tavily data from HeidiSQL.
-
Retently Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Retently facts in real time.
-
How to Connect to Live AgileCRM Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live AgileCRM data securely in real time.
-
Integrating OpenCode with Chargebee 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.
-
Automated Continuous Google Directory Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Directory replication to Google Cloud SQL.
-
How to Connect to Live SQL Analysis Services 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 SQL Analysis Services data for you.
-
Integrating SendInBlue Data in Talend Cloud Data Management Platform
Connect SendInBlue Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Query Live MariaDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MariaDB data data in natural language using Python.
-
Publish ServiceNow-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ServiceNow data.
-
Create Apps from AlloyDB Data in Qlik Sense Cloud
Use CData Connect AI to connect to AlloyDB Data and build apps from live AlloyDB data in Qlik Sense Cloud.
-
Create Informatica Mappings From/To an ODBC Data Source for RSS
Create an ODBC connection to RSS in Informatica and browse and transfer RSS feeds.
-
Getting Started with the CData Tableau Connector for Shopify
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Shopify.
-
Migrating data from Retently to Databricks using CData SSIS Components.
Easily push Retently data to Databricks using the CData SSIS Tasks for Retently and Databricks.
-
Connecting Agentforce with Instagram 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 Instagram data for you.
-
Getting Started with the CData Tableau Connector for Beeminder
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous ZohoExpense Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZohoExpense replication to SingleStore.
-
Connect to ZohoDesk Data in Ruby
Connect to ZohoDesk data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData SSIS Components for Vercel
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Vercel.
-
Publish ZeroBounce-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZeroBounce data.
-
Kintone Reporting in OBIEE with the Kintone JDBC Driver
Deploy the Kintone JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
LINQ to Splunk 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 Splunk Data Provider.
-
Connect to PostgreSQL from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from PostgreSQL data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData Tableau Connector for Spotify
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Explore Geographical Relationships in Trello Data with Power Map
Create data visualizations with Trello data in Power Map.
-
Connect Azure Data Catalog Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Azure Data Catalog data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect Facebook Ads Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Facebook Ads data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize Live Adobe Target Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Adobe Target data.
-
Choosing the Best Method to Connect JotForm to SQL Server: 5 Options Explained
Discover multiple ways to connect and use JotForm data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Visualizations of Google Ad Manager Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Ad Manager data in Birst.
-
Using the CData Software ODBC Driver for iContact in PyCharm
Connect to iContact as an ODBC data source in PyCharm using the CData Software ODBC Driver for iContact.
-
Create Reports with Hubstaff Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Hubstaff data.
-
How to Connect to Live LDAP Objects 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 LDAP objects through natural language.
-
Connect to Live Zoho CRM Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Zoho CRM in CData Connect AI and connect to your Zoho CRM data from PostgreSQL.
-
Connect to FHIR Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to FHIR.
-
Build AI/ML Models with Live Dynamics CRM Data using Dataiku
Connect Dynamics CRM Data with Dataiku using the CData JDBC Driver for Dynamics CRM.
-
Query Bitly Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Bitly data from Node.js.
-
Integrate Google's Vertex AI Agent with Live Google Directory 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 Google Directory data within intelligent workflows.
-
Use the CData Software ODBC Driver for ActiveCampaign in MicroStrategy Desktop
Connect to ActiveCampaign data in MicroStrategy Desktop using the CData Software ODBC Driver for ActiveCampaign.
-
How to Query OData Services in MySQL Workbench
Execute MySQL queries against live OData services from MySQL Workbench.
-
Replicate Neo4J Data from PowerShell
Write a quick PowerShell script to query Neo4J data. Use connectivity to the live data to replicate Neo4J data to SQL Server.
-
Feed YouTube Analytics Data into FineReport
How to set YouTube Analytics data as a JDBC data source in FineReport.
-
Connect to ShipEngine Data in Jaspersoft Studio
Execute SQL to remote ShipEngine data in Jaspersoft Studio.
-
Enable the Sage 200 JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Sage 200 data.
-
Connect to BambooHR Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to BambooHR and work with BambooHR data in your FileMaker applications.
-
Analyze TaxJar Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze TaxJar data with the CData JDBC Driver for TaxJar.
-
Use the CData Software ODBC Driver for Freshsales in MicroStrategy Web
Connect to Freshsales data in MicroStrategy Web using the CData Software ODBC Driver for Freshsales.
-
Natively Connect to Oracle Eloqua Reporting Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Oracle Eloqua Reporting data. Leverage the native support for ODBC in PHP.
-
Connect and Query Live Freshteam Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Freshteam data into Databricks and enable direct, live querying and analysis without replication.
-
Automated Continuous Mode Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Mode replication to Apache Cassandra.