CData Software - Knowledge Base
Recent Articles
-
Connect to DB2 Data in Claris FileMaker Pro
Use the CData ODBC Driver for DB2 in FileMaker Pro to connect to DB2 and work with DB2 data in your FileMaker applications.
-
Use Biml to Build SSIS Tasks to Replicate Amazon S3 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amazon S3 data to SQL Server.
-
Add iContact Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for iContact with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Odoo Data in Google Apps Script via Connect AI
Use CData Connect AI to access Odoo data in Google Apps Script.
-
Use Grok to Talk to Your Tally 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 Tally data for you.
-
Excel Spreadsheet Automation on Google Search Results with the QUERY Formula
Pull data from Google Search, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Avro Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Avro replication to Azure SQL Database.
-
Integrate Goose with Live DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live DB2 data from within the local AI agent.
-
Automated Continuous Stripe Replication to SingleStore
Use CData Sync for automated, continuous, customizable Stripe replication to SingleStore.
-
Integrate Harvest with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Harvest with External Services.
-
Access Live Jira Data in TIBCO Data Virtualization
Use the Jira Tibco DV Adapter to create a Jira data data source in TIBCO Data Virtualization Studio and gain access to live Jira data from your TDV Server.
-
Use Agno to Talk to Your JSON Services 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 JSON services for you.
-
Automated Continuous Spotify Replication to SQL Server
Use CData Sync for automated, continuous, customizable Spotify replication to SQL Server.
-
Integrating LlamaIndex with Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Analytics data in real time.
-
Use Databricks Agent Bricks to Talk to Your Azure Synapse Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Azure Synapse data for you.
-
How to create Visio diagrams from Sage Intacct Data
Automatically update Sage Intacct data with the changes you make to Visio master shapes.
-
Enable the CircleCI JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with CircleCI data.
-
Configure the CData JDBC Driver for Zoho Books in a Connection Pool in Tomcat
Connect to Zoho Books data from a connection pool in Tomcat.
-
Integrate Exact Online Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Exact Online data from Informatica Cloud.
-
Access Live SAS Data Sets Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAS Data Sets data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Live YouTube Analytics Data in MicroStrategy through CData Connect AI
Create a live connection to YouTube Analytics Data in CData Connect AI and connect to your YouTube Analytics data from MicroStrategy.
-
Build Google Drive-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Drive Data from Zoho Analytics and import live Google Drive data.
-
Integrate ZohoInvoice with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZohoInvoice with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZohoInvoice data.
-
Use Databricks Agent Bricks to Talk to Your Coda Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Coda data for you.
-
Integrating Gumloop with Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Azure Synapse data within automated workflows.
-
Publish Google Drive-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Drive data.
-
Bridge MailerSend Connectivity with Apache NiFi
Access and process MailerSend data in Apache NiFi using the CData JDBC Driver.
-
Access Live Discord Data in AWS Lambda
Connect to live Discord data in AWS Lambda using the CData JDBC Driver.
-
Build Charts with Oracle Sales Data in Clear Analytics
Create dynamic charts and perform analytics based on Oracle Sales data in Clear Analytics.
-
Automated Continuous Google Ads Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Ads replication to Oracle.
-
How to use SQLAlchemy ORM to access Insightly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Insightly data.
-
Automated Continuous Timely Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Timely replication to Google Cloud SQL.
-
Build CapsuleCRM-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live CapsuleCRM data without replication.
-
Connect to Retently Data in NetBeans
Connect to Retently data in NetBeans with the data source configuration wizard.
-
Connect to Avalara AvaTax Data in NetBeans
Connect to Avalara AvaTax data in NetBeans with the data source configuration wizard.
-
Query Oracle Financials Cloud Data as a SQL Server Database in Node.js
Execute SQL Server queries against Oracle Financials Cloud data from Node.js.
-
How to Connect DBeaver to Sage Intacct via a JDBC Driver
Manage Sage Intacct data with visual tools in DBeaver like the query browser.
-
Integrating OpenCode with Aweber 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.
-
Model, Search, and Visualize Live Salesforce Data in ThoughtSpot
Use CData Connect AI to connect to live Salesforce data for modeling, searching, and visualizing.
-
Access Live SparkPost 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 SparkPost data through MCP integration.
-
Automated Continuous Freshservice Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Freshservice replication to Apache Kafka.
-
How to Connect to Live SingleStore 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 SingleStore data for you.
-
Integrating SAP Concur Data in Talend Cloud Data Management Platform
Connect SAP Concur Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP Concur.
-
Create Teamwork Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Teamwork from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import Real-Time MySQL Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MySQL data in ColdFusion.
-
How to connect SharePoint with XML Data through external lists
Provide XML data to SharePoint users as an external list.
-
Automated Continuous Microsoft Dataverse Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to SQLite.
-
Automated Continuous Optimizely Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Optimizely replication to Azure SQL Database.
-
Use the CData ODBC Driver for Close from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Close to connect to Close data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Close data in Excel.
-
Connect Instantly Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Instantly data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze Coda Data in Cognos Analytics
Use CData Connect AI to connect to Coda Data from Cognos Analytics and analyze live Coda data.
-
Create Informatica Mappings From/To an ODBC Data Source for Datadog
Create an ODBC connection to Datadog in Informatica and browse and transfer Datadog data.
-
Automated Continuous Oracle Financials Cloud Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Amazon Redshift.
-
Automate DB2 for i Data Replication to SAP HANA
Use CData Sync to customize and automate DB2 for i data replication to SAP HANA.
-
Visualize Google Cloud Storage Data in TIBCO Spotfire through ADO.NET
Integrate Google Cloud Storage data into dashboards in TIBCO Spotfire.
-
How to use SQLAlchemy ORM to access Facebook Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Facebook data.
-
Connect to Discord Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Discord data in the Denodo Virtual DataPort Administrator.
-
Integrating OpenCode with Certinia 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.
-
Build Data Flows from ChargeOver to SQL Server using SSIS
Easily back up ChargeOver data to SQL Server using the SSIS components for ChargeOver.
-
Query Sage Intacct Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sage Intacct data from Node.js.
-
Create Datasets from Sage 300 in Domo Workbench and Build Visualizations of Sage 300 Data in Domo
Use the CData Software ODBC Driver for Sage 300 to create datasets from Sage 300 data in Domo Workbench and then build visualizations in the Domo service.
-
How to import Sendwithus Data into Apache Solr
Use the CData Software JDBC Driver for Sendwithus in Data Import Handler and create an automated import of Sendwithus data to Apache Solr Enterprise Search platform.
-
How to create an RPA flow for Cloudflare Data in UiPath Studio
Use the Cloudflare ODBC Driver to create workflows that access real-time Cloudflare data without any coding.
-
Access Azure Analysis Services Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Azure Analysis Services data from HeidiSQL.
-
Access Live Azure DevOps Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure DevOps data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate DB2 with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate DB2 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to DB2 data.
-
Bidirectional Access to Highrise Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Highrise data in Filemaker Pro for Mac or Windows.
-
Build Dashboards with Helpscout Data in Dundas BI
Create dynamic dashboards and perform analytics based on Helpscout data in Dundas BI.
-
Connect to Azure Table from Asprova with CData Software ODBC Driver for Azure Table
This article shows how to connect faster to Azure Table data from Asprova.
-
Building Dynamic Web Pages with Zuora Data Using AngularJS
Create single-page applications with live connectivity to Zuora using the CData API Server.
-
Connect to Templated from a Connection Pool in WebLogic
Use the CData JDBC Driver for Templated to connect to Templated data from Web applications running on WebLogic.
-
Create Reports with Helpscout Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Helpscout data.
-
Access Live Dynamics CRM Data in AWS Lambda
Connect to live Dynamics CRM data in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Live Testmonitor Data 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 Testmonitor data through natural language.
-
Manage NASA Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for NASA.
-
How to Connect to Live PostgreSQL Data 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 PostgreSQL data through natural language.
-
A PostgreSQL Interface for Microsoft OneDrive Data using the CData ODBC Driver
Use the SQL Gateway and Microsoft OneDrive ODBC Driver to create a PostgreSQL entry-point for data access.
-
Explore Geographical Relationships in Qualaroo Data with Power Map
Create data visualizations with Qualaroo data in Power Map.
-
Build ZohoSubscriptions-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for ZohoSubscriptions Data and create custom apps in Mendix.
-
Build Data Flows from Cohere to SQL Server using SSIS
Easily back up Cohere data to SQL Server using the SSIS components for Cohere.
-
Publish Salesforce Pardot-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Salesforce Pardot data.
-
Prepare, Blend, and Analyze SAP Business Warehouse Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Business Warehouse data for self-service data analytics.
-
Visualize Live Deel Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Deel data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Viewing SharePoint Excel Services Data in RAD Studio Data Explorer
How to view SharePoint Excel Services data in RAD Studio Data Explorer using the CData ODBC Driver for SharePoint Excel Services.
-
How to connect to Bright Data Data from Spring Boot
Connect to Bright Data in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Placid Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Placid replication to Apache Cassandra.
-
Integrate Google's Vertex AI Agent with Live OneNote 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 OneNote data within intelligent workflows.
-
Integrating Kiro with Active Directory 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.
-
Build Apps with Live Oracle Service Cloud Data Using the Low-Code Development Platform of Mendix
Connect Oracle Service Cloud data with Mendix to build apps using the CData JDBC Driver for Oracle Service Cloud.
-
Connect to PolarTeamPro in SpagoBI
Create reports featuring live PolarTeamPro data in SpagoBI Studio. Host PolarTeamPro reports on SpagoBI Server.
-
Explore Geographical Relationships in SAS xpt Data with Power Map
Create data visualizations with SAS xpt data in Power Map.
-
Integrate Freshdesk Data in the Pentaho Report Designer
Publish reports based on Freshdesk data in the Pentaho BI tool.
-
Provide OData Services of Google Search Results from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Search results by developing a WCF Service Application.
-
How to import Datadog Data into Apache Solr
Use the CData Software JDBC Driver for Datadog in Data Import Handler and create an automated import of Datadog data to Apache Solr Enterprise Search platform.
-
Access Live XML Data in AWS Lambda
Connect to live XML data in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData Excel Add-In for HDFS
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for HDFS.
-
Integrate SAP SuccessFactors Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP SuccessFactors data and integrate live SAP SuccessFactors data into your Power Automate tasks.
-
Visualize Perigon 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 Perigon data into TIBCO Spotfire.
-
Getting Started with the CData Connect AI Python SDK for Microsoft Dataverse
Install the CData Connect AI Python SDK to read and write live Microsoft Dataverse data with standard DB-API 2.0 Python code.
-
Bind Live Azure Synapse Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure Synapse data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.