CData Software - Knowledge Base
Recent Articles
-
How to integrate Metabase with Sugar CRM Data
Use CData Connect AI to connect to live Sugar CRM data and create an interactive dashboard in Metabase from Sugar CRM data.
-
Feed SAP SuccessFactors LMS Data into FineReport
How to set SAP SuccessFactors LMS data as a JDBC data source in FineReport.
-
Build a Singer.io Tap for MessageBird With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MessageBird data using the CData Python Connector.
-
Connect to Google Cloud Storage Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Cloud Storage data from HeidiSQL.
-
Getting Started with the CData SSIS Components for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Facebook Ads.
-
Model, Search, and Visualize Live Twitter Ads Data in ThoughtSpot
Use CData Connect AI to connect to live Twitter Ads data for modeling, searching, and visualizing.
-
Connect to ShipStation Data in Google Apps Script via Connect AI
Use CData Connect AI to access ShipStation data in Google Apps Script.
-
How to connect SharePoint with Sybase IQ Data through external lists
Provide Sybase IQ data to SharePoint users as an external list.
-
A PostgreSQL Interface for Moosend Data using the CData ODBC Driver
Use the SQL Gateway and Moosend ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Manus AI to Talk to Your ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on ADP data.
-
Integrating Claude Code with Microsoft Planner Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Planner data within assisted coding and automated development workflows.
-
Edit and Search External YouTube Analytics Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of YouTube Analytics data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create YouTube Analytics Data objects that you can access from apps and the dashboard.
-
Automate Google Ads Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Ads data replication to Azure Data Lake.
-
Publish Browserless-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Browserless data.
-
How to integrate Metabase with FTP Data
Use CData Connect AI to connect to live FTP data and create an interactive dashboard in Metabase from FTP data.
-
A PostgreSQL Interface for QuickBooks Online Data (MySQL Remoting via JDBC)
Use the Remoting features of the QuickBooks Online JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating GitHub Copilot with Vercel 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.
-
Access Live QuickBooks Time Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live QuickBooks Time data from your Excel spreadsheets.
-
Create SSAS Tabular Models from Exact Online Data
How to build a SQL Server Analysis Service Tabular Model from Exact Online data using CData drivers.
-
Build Dashboards with Oracle Service Cloud Data in DBxtra
Create dynamic dashboards and perform analytics based on Oracle Service Cloud data in DBxtra.
-
Automated Continuous ConstantContact Replication to SingleStore
Use CData Sync for automated, continuous, customizable ConstantContact replication to SingleStore.
-
Build Pipelines with Live LinkedIn Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to LinkedIn from Google Cloud Data Fusion, enabling the integration of live LinkedIn data into the building and management of effective data pipelines.
-
Rapidly Develop TaxJar-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by TaxJar.
-
Automated Continuous Beeminder Replication to Vertica
Use CData Sync for automated, continuous, customizable Beeminder replication to Vertica.
-
Working with LaunchDarkly Data in LINQPad
Execute LINQ queries to LaunchDarkly data in LINQPad.
-
Connect to Samanage Data in RazorSQL
Connect to Samanage from wizards and query Samanage data from the GUI in the RazorSQL database management tool.
-
Write a Simple Go Application to work with Egnyte Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Egnyte data.
-
Integrate Goose with Live Yelp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Yelp data from within the local AI agent.
-
Natively Connect to Gumroad Data in PHP
The CData ODBC driver for Gumroad enables you to create PHP applications with connectivity to Gumroad data. Leverage the native support for ODBC in PHP.
-
How to Access REST Data Using Entity Framework
This article shows how to access REST data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to create Wistia federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Wistia data in MySQL .
-
Build Apps with Live PolarTeamPro Data Using the Low-Code Development Platform of Mendix
Connect PolarTeamPro data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Live Oracle Eloqua Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle Eloqua Data in CData Connect AI and connect to your Oracle Eloqua data from MicroStrategy.
-
Validate Teamgate Data with QuerySurge
Access and validate Teamgate data in QuerySurge using the CData JDBC Driver.
-
Connect to Timely Data in Aqua Data Studio
Access Timely data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Bridge Aweber Connectivity with Apache NiFi
Access and process Aweber data in Apache NiFi using the CData JDBC Driver.
-
Access Live Testmonitor Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Testmonitor data from your Excel spreadsheets.
-
Automated Continuous Zoho CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zoho CRM data replication to OneLake in Microsoft Fabric.
-
Viewing Neo4J Data in RAD Studio Data Explorer
How to view Neo4J data in RAD Studio Data Explorer using the CData ODBC Driver for Neo4J.
-
Integrating Boomi Agentstudio with SAS Data Sets Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAS Data Sets data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Query Live NetSuite Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live NetSuite data data in natural language using Python.
-
Create Dynamic Templated Grids Using the Infragistics XamDataGrid
Learn how you can connect Templated to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Kafka Replication to SQL Server
Use CData Sync for automated, continuous, customizable Kafka replication to SQL Server.
-
How to Query Live Sage 300 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sage 300 data data in natural language using Python.
-
Working with ADP Data in LINQPad
Execute LINQ queries to ADP data in LINQPad.
-
Integrate Oracle Eloqua Reporting Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Oracle Eloqua Reporting data from Informatica Cloud.
-
Visualize Live Amazon S3 Data in the Power BI Service
Use CData Connect AI to connect to live Amazon S3 data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Tickspot Data in ColdFusion
Write standard ColdFusion data access code to connect to Tickspot data.
-
Build Visualizations of Google Tasks Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Tasks data in Birst.
-
Access Mailjet Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Mailjet data.
-
Use the CData Software JDBC Driver for Beeminder in MicroStrategy Desktop
Connect to Beeminder data in MicroStrategy Desktop using the CData Software JDBC Driver for Beeminder.
-
Build an OLAP Cube in SSAS from Oracle SCM Data
Establish a connection to Oracle SCM data data from SQL Server Analysis Services, and use the Oracle SCM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Smartsheet-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Smartsheet Data from OutSystems and build custom enterprise apps using live Smartsheet data.
-
How to connect to JSON Services from Spring Boot
Connect to JSON in a Spring Boot Application using the CData JDBC Driver for JSON
-
Access Live ZendeskSell Data in Coginiti Pro
Connect to and query live ZendeskSell data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Oracle SCM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Apache Cassandra.
-
Integrate Kafka with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Kafka with External Services.
-
How to connect SharePoint with DB2 Data through external lists
Provide DB2 data to SharePoint users as an external list.
-
Access Live Bitbucket Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Bitbucket data from your Excel spreadsheets.
-
Integrating Claude Code with OData Services via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on OData services within assisted coding and automated development workflows.
-
Establish a Live Connection with Microsoft Exchange Data using Tableau Bridge
The CData ODBC Driver for Microsoft Exchange enables you to integrate live Microsoft Exchange data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to create Quaderno federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Quaderno data in MySQL .
-
How to work with Avalara AvaTax Data in Apache Spark using SQL
Access and process Avalara AvaTax Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData JDBC Driver for ClickTime
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ClickTime.
-
Connect to ADP Data in Aqua Data Studio
Access ADP data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Agents in Relevance AI with Access to Live Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Jira Assets data within intelligent agent workflows.
-
Analyze Front Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Front data with the CData JDBC Driver for Front.
-
Query Amazon Marketplace Data as a SQL Server Database in Node.js
Execute SQL Server queries against Amazon Marketplace data from Node.js.
-
Use the CData ODBC Driver for Workable in Microsoft Power Query
You can use the CData Workable ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Workable data into Microsoft Power Query.
-
How to Query iContact Data in MySQL Workbench
Execute MySQL queries against live iContact data from MySQL Workbench.
-
Analyze Couchbase Data in Looker
Use CData Connect AI to connect to Couchbase Data from Looker and build custom apps using live Couchbase data.
-
Object-Relational Mapping (ORM) with Tickspot Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Tickspot data into a Java-based ORM framework, Hibernate.
-
How to Work with ZohoPeople Data in ETL Validator JDBC
Connect to ZohoPeople from ETL Validator jobs using the CData Software JDBC Driver.
-
Query Google Campaign Manager 360 Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Campaign Manager 360 data from Node.js.
-
Create Pipeline CRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Pipeline CRM data access from reports, embedded analytics, and more.
-
How to connect SharePoint with IBM Informix Data through external lists
Provide IBM Informix data to SharePoint users as an external list.
-
Integrate Trae with Live Dropbox Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Dropbox data from within the AI-powered IDE.
-
Use the CData ODBC Driver for Zoho Creator from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoho Creator to connect to Zoho Creator data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoho Creator data in Excel.
-
Query Twilio Data as a SQL Server Database in Node.js
Execute SQL Server queries against Twilio data from Node.js.
-
How to connect PolyBase to Stripe
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Stripe data.
-
Automate Azure Blob Storage Data Replication to Couchbase
Use CData Sync to Customize and automate Azure Blob Storage data replication to Couchbase.
-
Create Apps from Vertica Data in Qlik Sense Cloud
Use CData Connect AI to connect to Vertica Data and build apps from live Vertica data in Qlik Sense Cloud.
-
Build a Simple VCL Application for Pipedrive Data
How to build a simple VCL Application to view Pipedrive data in RAD Studio using the CData ODBC Driver for Pipedrive.
-
Analyze Discord Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Discord data and visualize live Discord data in Infragistics Reveal.
-
Integrating Ontraport Data in Talend Cloud Data Management Platform
Connect Ontraport Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Copper Replication to MongoDB
Use CData Sync for automated, continuous, customizable Copper replication to MongoDB.
-
Visualize Live Printify Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Printify data into custom reports in Power BI.
-
Automate Reckon Accounts Hosted Data Replication to SAP HANA
Use CData Sync to customize and automate Reckon Accounts Hosted data replication to SAP HANA.
-
Build Automated Stripe-Connected Workflows in Zapier
Use CData Connect AI to connect to live Stripe data and build automated workflows in Zapier.
-
Create Dynamic ZeroBounce Grids Using the Infragistics XamDataGrid
Learn how you can connect ZeroBounce to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Real-Time Bannerbear Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Bannerbear data in Power Apps.
-
Integrate Live Snapchat Ads Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Snapchat Ads data from within the IDE.
-
Use Biml to Build SSIS Tasks to Replicate Pingdom Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Pingdom data to SQL Server.
-
How to Connect the Power BI Service to Mailgun: Complete Guide
Connect to the CData Software Power BI Connector for Mailgun from PowerBI.com to provide real-time Mailgun data across the organization.
-
Integrate Google's Vertex AI Agent with Live Zoho Inventory 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 Zoho Inventory data within intelligent workflows.
-
Access Live Printify 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 Printify data through MCP integration.
-
Access CloudConvert Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access CloudConvert data from your Oracle system.
-
Import Real-Time AdRoll Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use AdRoll data in ColdFusion.
-
Build DB2-Connected Apps in Choreo
Use CData Connect AI to connect to DB2 Data from Choreo and build custom apps using live DB2 data.
-
How to Visualize Twitter Ads 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 Twitter Ads data in Python.