CData Software - Knowledge Base
Recent Articles
-
Connect to Live Confluence Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Confluence in CData Connect AI and connect to your Confluence data from PostgreSQL.
-
Configure the CData JDBC Driver for Cohere in a Connection Pool in Tomcat
Connect to Cohere data from a connection pool in Tomcat.
-
Connect to Dynamics CRM Data in HULFT Integrate
Connect to Dynamics CRM as a JDBC data source in HULFT Integrate
-
Create SSAS Tabular Models from Parquet Data
How to build a SQL Server Analysis Service Tabular Model from Parquet data using CData drivers.
-
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.
-
Access Live XML 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 XML data through MCP integration.
-
Import Real-Time Rebilly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Rebilly data in ColdFusion.
-
Getting Started with the CData ADO.NET Provider for Keap
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Design BIRT Reports on Databricks Data
Provide current Databricks data to your embedded analytics.
-
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.
-
Process & Analyze Odoo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Odoo Data.
-
Connect to Spark Data from PowerBuilder via JDBC
This article demonstrates how to access Spark data from PowerBuilder using the Spark JDBC Driver.
-
Replicate Slack Data in Heroku for Use in Salesforce Connect
Replicate Slack data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Voice Agents in ElevenLabs with access to Live SendGrid Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SendGrid data.
-
Feed Front Data into FineReport
How to set Front data as a JDBC data source in FineReport.
-
How to connect to Google Directory Data with Squirrel SQL client
Connect to Google Directory data and execute queries in the Squirrel SQL Client.
-
Analyze Oracle Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
A PostgreSQL Interface for Pipeliner CRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the Pipeliner CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to publish and share Jumpseller Data dashboards with Tableau Server
The CData ODBC driver for Jumpseller enables you integrate Jumpseller data into Tableau dashboards.
-
How to update Azure Table from Excel
This article explains how to transfer data from Excel to Azure Table using the Excel Add-In for Azure Table.
-
Integrating Codex with Placid 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 OData Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable OData replication to Google Cloud SQL.
-
Connect TaxJar Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your TaxJar data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate with live Workday Data in Jitterbit
Use CData Connect AI to connect to and integrate live Workday data in Jitterbit.
-
Use the CData Software ODBC Driver for OpenWeatherMap in SAS for Real-Time Reporting and Analytics
Connect to real-time OpenWeatherMap data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for OpenWeatherMap.
-
Integrating Claude Code CLI with Google Search Results 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 create Amazon S3 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Amazon S3 data in MySQL .
-
Connecting Agentforce with Neo4J 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 Neo4J data for you.
-
Use JayDeBeApi to access HDFS Data in Python
Use standard Python scripting and the development environment of your choice to access live HDFS data.
-
Build Dashboards with Elasticsearch Data in Dundas BI
Create dynamic dashboards and perform analytics based on Elasticsearch data in Dundas BI.
-
SAP BusinessObjects BI Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP BusinessObjects BI data through CData Connect AI using different applications and tools.
-
How to work with RSS Feeds in Apache Spark using SQL
Access and process RSS Feeds in Apache Spark using the CData Software JDBC Driver.
-
Analyze SageHR Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SageHR from Power Pivot. You will use the Table Import Wizard to load SageHR data. You can visually build the import query or use any SQL supported by the driver.
-
Automate WordPress Data Replication to SAP HANA
Use CData Sync to customize and automate WordPress data replication to SAP HANA.
-
Connect to MailChimp Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MailChimp as an External Source in Dremio.
-
Connect to FHIR Data in JRuby
Create a simple JRuby app with access to live FHIR data.
-
Connect to Pingdom from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pingdom to connect to Pingdom data from Web applications running on WebLogic.
-
Automated Continuous Front Replication to SingleStore
Use CData Sync for automated, continuous, customizable Front replication to SingleStore.
-
Connecting Moonlit Workflow with Oracle Financials Cloud Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Oracle Financials Cloud data in real time.
-
Write a Simple Go Application to work with Workable Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Workable data.
-
How to Connect Greenhouse 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 Greenhouse data in real time using natural language.
-
Automated Continuous SingleStore Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SingleStore replication to Amazon Redshift.
-
Use Azure AI Foundry to Talk to Your DB2 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 DB2 data for you.
-
Excel Spreadsheet Automation on JobNimbus Data with the QUERY Formula
Pull data from JobNimbus, automate spreadsheets, and more with the QUERY formula.
-
Replicate Stack Exchange Data in Heroku for Use in Salesforce Connect
Replicate Stack Exchange data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connecting GenSpark with Salesforce CRM Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Salesforce CRM Analytics data without any replication or custom integration required.
-
Back Up IBM Cloud Object Storage data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for IBM Cloud Object Storage. In this article, we will employ an SSIS workflow to populate a database with IBM Cloud Object Storage data data.
-
Integrate OpenCode with Live Confluence Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Confluence data from within your AI coding agent.
-
Integrating Claude Code CLI with SAS Data Sets 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.
-
Use Databricks Agent Bricks to Talk to Your SAP SuccessFactors LMS Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP SuccessFactors LMS data for you.
-
Migrating data from Dotmailer to Google BigQuery using CData SSIS Components.
Easily push Dotmailer data to Google BigQuery using the CData SSIS Tasks for Dotmailer and Google BigQuery.
-
Getting Started with the CData Excel Add-In for Google Search
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Search.
-
Create Data Visualizations Based On Avalara AvaTax Data in Mode
Use CData Connect AI to connect to Avalara AvaTax Data from Mode and build visualizations using live Avalara AvaTax data.
-
Create Data Visualizations in Cognos BI with ZohoInvoice Data
Access ZohoInvoice data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Microsoft Planner Data in RapidMiner
Integrate Microsoft Planner data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate with Adobe Experience Manager Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Adobe Experience Manager data to a JSON file on disk.
-
Integrating GitHub Copilot with Retently 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.
-
Consume Dynamics 365 Business Central OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Dynamics 365 Business Central feeds that reflect any changes in SAP Lumira.
-
Connect Email to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Email data using the CData Python MCP Server.
-
Connect to Salesloft Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Salesloft data.
-
Connect to AlloyDB Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time AlloyDB data using standard SQL.
-
Visualize SharePoint Excel Services Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SharePoint Excel Services data.
-
Connect to CouchDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for CouchDB and the Script function in FileMaker Pro to connect to CouchDB and work with CouchDB data in your FileMaker application.
-
Connecting GenSpark with Jira Assets Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Jira Assets data without any replication or custom integration required.
-
Visualize Live Hugging Face Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Hugging Face data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Insightly Data in DataGrip
Create a Data Source for Insightly in DataGrip and use SQL to query live Insightly data.
-
Automated Continuous Hacker News Replication to Vertica
Use CData Sync for automated, continuous, customizable Hacker News replication to Vertica.
-
Automated Continuous PagerDuty Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable PagerDuty replication to PostgreSQL.
-
How to Seamlessly Import LightSpeedRetail Data into IBM SPSS Modeler
Integrate LightSpeedRetail data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Publish Crystal Reports on PhantomBuster Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PhantomBuster data.
-
Integrating Claude Code with Jumpseller Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Jumpseller data within assisted coding and automated development workflows.
-
Integrate with Live Salesforce Marketing Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Salesforce Marketing from the MuleSoft Anypoint Platform to integrate live Salesforce Marketing data into custom reports and dashboards.
-
Visualize Mouseflow Data in TIBCO Spotfire through ADO.NET
Integrate Mouseflow data into dashboards in TIBCO Spotfire.
-
Connect to BigQuery Data in DBeaver
Use the CData ODBC Driver to connect to BigQuery data in DBeaver.
-
How to Connect to Live ConstantContact Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your ConstantContact data for you.
-
Automated Continuous Reckon Replication to Databricks
Use CData Sync for automated, continuous, customizable Reckon replication to Databricks.
-
Design BIRT Reports on ShipEngine Data
Provide current ShipEngine data to your embedded analytics.
-
Connect to Paymo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Paymo to connect to Paymo data and execute queries in PowerBuilder.
-
Provide OData Services of HubDB Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for HubDB data by developing a WCF Service Application.
-
Getting Started with the CData Excel Add-In for Teradata
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Teradata.
-
Configure the CData JDBC Driver for Suadeo in a Connection Pool in Tomcat
Connect to Suadeo data from a connection pool in Tomcat.
-
Write a Simple Go Application to work with SendInBlue Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SendInBlue data.
-
A PostgreSQL Interface for Reply.io Data using the CData ODBC Driver
Use the SQL Gateway and Reply.io ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Tavily-Connected Dashboards in Grafana
Connect to Tavily Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Tavily data.
-
Getting Started with the CData SSIS Components for Bright Data
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bright Data.
-
Automated Continuous Slack Replication to SQLite
Use CData Sync for automated, continuous, customizable Slack replication to SQLite.
-
Build Semantic Layer Views for ZohoPeople Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ZohoPeople data.
-
Connect to and Query ClickTime Data in QlikView over ODBC
Create data visualizations with ClickTime data in QlikView.
-
Create Data Visualizations Based On Certinia Data in Mode
Use CData Connect AI to connect to Certinia Data from Mode and build visualizations using live Certinia data.
-
Connecting Pipedream with Jira Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Jira data in real time.
-
Connecting Moonlit Workflow with Workday Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Workday data in real time.
-
Import and Visualize Trello Data in Power View
Create data visualizations based on Trello data in Excel.
-
Access Live CockroachDB Data in TIBCO Data Virtualization
Use the CockroachDB Tibco DV Adapter to create a CockroachDB data data source in TIBCO Data Virtualization Studio and gain access to live CockroachDB data from your TDV Server.
-
Use the CData Software JDBC Driver for Reckon in MicroStrategy Web
Connect to Reckon data in MicroStrategy Web using the CData Software JDBC Driver for Reckon.
-
Access Live Pinterest Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Pinterest data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Raisers Edge NXT 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 Raisers Edge NXT data through MCP integration.
-
Use Biml to Build SSIS Tasks to Replicate Sage Cloud Accounting Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sage Cloud Accounting data to SQL Server.
-
Migrating data from Stack Exchange to Databricks using CData SSIS Components.
Easily push Stack Exchange data to Databricks using the CData SSIS Tasks for Stack Exchange and Databricks.
-
Supabase Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Supabase facts in real time.