CData Software - Knowledge Base
Recent Articles
-
Integrate Goose with Live Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Gong data from within the local AI agent.
-
How to Visualize Zoho Books Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoho Books data in Python.
-
Publish Reckon-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Reckon data.
-
Process & Analyze Calendly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Calendly Data.
-
Automated ClickUp Data Replication to Teradata
Use CData Sync to Customize and automate ClickUp data replication to Teradata.
-
Build a PostgreSQL Interface for VWO Data using the CData JDBC Driver
Use the Remoting features of the VWO JDBC Driver to create a PostgreSQL entry-point for data access.
-
Gorgias Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Gorgias facts in real time.
-
DataBind Controls to Basecamp Data in Delphi
DataBind to Basecamp data in Delphi with standard data access components and controls.
-
Manage LDAP Objects in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for LDAP.
-
Query, Visualize, and Share live Dynamics 365 Data in Redash
Use CData Connect AI to connect to live Dynamics 365 data in Redash for querying, visualizing, and sharing.
-
Excel Spreadsheet Automation on Unbounce Data with the QUERY Formula
Pull data from Unbounce, automate spreadsheets, and more with the QUERY formula.
-
Build Apps with Live Miro Data Using the Low-Code Development Platform of Mendix
Connect Miro data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to WooCommerce Data in RazorSQL
Connect to WooCommerce from wizards and query WooCommerce data from the GUI in the RazorSQL database management tool.
-
Connect to Microsoft Ads Data from a Connection Pool in JBoss
Integrate Microsoft Ads data into Java servlets: Use the Management Console in JBoss to install the Microsoft Ads JDBC Driver.
-
How to Connect to Live Azure Table 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 Azure Table data for you.
-
Automate Strava Data Replication to Azure Synapse
Use CData Sync to customize and automate Strava data replication to Azure Synapse.
-
Connect to Contentful Data in CloverDX (formerly CloverETL)
Transfer Contentful data using the visual workflow in the CloverDX data integration tool.
-
Use Biml to Build SSIS Tasks to Replicate Calendly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Calendly data to SQL Server.
-
Connect to Splunk Data in ACL Analytics
Connect to Splunk data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Splunk data.
-
Use Azure AI Foundry to Talk to Your Sage 200 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 Sage 200 data for you.
-
Easily Integrate Shippo Data in Lazarus Pascal IDE
Learn how to easily integrate live Shippo data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Object-Relational Mapping (ORM) with Stack Exchange 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 Stack Exchange data into a Java-based ORM framework, Hibernate.
-
Build a Singer.io Tap for Cosmos DB With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Cosmos DB data using the CData Python Connector.
-
How to load Figshare data into Elasticsearch via Logstash
Introducing a simple method to load Figshare data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Vimeo
Provide connectivity to Vimeo data through an SAP BusinessObjects universe.
-
Getting Started with the CData JDBC Driver for HubSpot
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for HubSpot.
-
Analyze Toggl Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Toggl data in Microsoft R Open.
-
Connect to Gmail Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Gmail data using standard SQL.
-
Access Live XML Data in AWS Lambda (with IntelliJ IDEA)
Connect to live XML data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Bridge RSS Connectivity with Apache NiFi
Access and process RSS feeds in Apache NiFi using the CData JDBC Driver.
-
Build a PostgreSQL Interface for Clari Data using the CData JDBC Driver
Use the Remoting features of the Clari JDBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Smartsheet Data in Power BI Report Server
Use the CData ODBC Driver for Smartsheet to visualize Smartsheet data in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Power BI Connector for eBay
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for eBay.
-
Use the CData ODBC Driver for Oracle Eloqua in Microsoft Power Query
You can use the CData Oracle Eloqua ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle Eloqua data into Microsoft Power Query.
-
A PostgreSQL Interface for Bitbucket Data using the CData ODBC Driver
Use the SQL Gateway and Bitbucket ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Semantic Layer Views for ScrapingBee Data in APOS Live Data Gateway
Use the CData Connector for ScrapingBee in APOS Live Data Gateway to build Semantic Layer Views for ScrapingBee data.
-
Build a Simple VCL Application for Miro Data
How to build a simple VCL Application to view Miro data in RAD Studio using the CData ODBC Driver for Miro.
-
Use the CData Software ODBC Driver for Pipeline CRM in MicroStrategy
Connect to Pipeline CRM data in MicroStrategy Developer using the CData Software ODBC Driver for Pipeline CRM.
-
Connect to Authorize.Net 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 Authorize.Net data.
-
Build a Singer.io Tap for CloudConvert With the CData Python Connector
Learn how to easily build a Singer.io Tap for live CloudConvert data using the CData Python Connector.
-
How to Visualize Square Data in Python with pandas
Use pandas and other modules to analyze and visualize live Square data in Python.
-
Build a Simple VCL Application for OData Services
How to build a simple VCL Application to view OData services in RAD Studio using the CData ODBC Driver for OData.
-
Stream Microsoft Planner Data into Apache Kafka Topics
Access and stream Microsoft Planner data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect PolyBase to Sage 300
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sage 300 data.
-
Connect ZarMoney to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZarMoney data using the CData Python MCP Server.
-
Integrate Cline with Live Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Freshdesk data from within your IDE.
-
Automated Opsgenie Data Replication to Teradata
Use CData Sync to Customize and automate Opsgenie data replication to Teradata.
-
Provide OData Services of Hive Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Hive data by developing a WCF Service Application.
-
Manage QuickBooks Online Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for QuickBooks Online.
-
Query MariaDB Data through ODBC in Node.js
Use node-odbc to execute SQL queries against MariaDB data from Node.js.
-
Visualize FreeAgent Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to FreeAgent data.
-
Analyze Cloudant Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Cloudant data in Microsoft R Open.
-
Query SAP Business One Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP Business One data from Node.js.
-
How to Connect to Live WooCommerce 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 WooCommerce data for you.
-
How to Connect to Live Azure Data Catalog 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 Azure Data Catalog data for you.
-
How to Connect the Power BI Service to Sentry: Complete Guide
Connect to the CData Software Power BI Connector for Sentry from PowerBI.com to provide real-time Sentry data across the organization.
-
How to import Discord Data into Apache Solr
Use the CData Software JDBC Driver for Discord in Data Import Handler and create an automated import of Discord data to Apache Solr Enterprise Search platform.
-
Access Live Klaviyo 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 Klaviyo data through MCP integration.
-
Build AI/ML Models with Live Parallel Data using Dataiku
Connect Parallel Data with Dataiku using the CData API Driver for JDBC.
-
Integrate Goose with Live Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Raisers Edge NXT data from within the local AI agent.
-
Build MVC Applications with Connectivity to ZarMoney Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZarMoney from an ASP.NET MVC application.
-
Integrate Exact Online Data in the Pentaho Report Designer
Publish reports based on Exact Online data in the Pentaho BI tool.
-
Access Live Zoho Books Data in Excel 365 Online (Excel for the web)
Connect to Zoho Books data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Workday Data from PowerBuilder via JDBC
This article demonstrates how to access Workday data from PowerBuilder using the Workday JDBC Driver.
-
Automated Continuous NetSuite SuiteAnalytics Replication to MySQL
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to MySQL.
-
How to Create Power BI Visual Reports with Real-Time NetSuite Data
Use CData Power BI Connectors to visualize NetSuite data in Power BI.
-
How to Visualize Shopify 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 Shopify data in Python.
-
Integrate with live Avro Data in Jitterbit
Use CData Connect AI to connect to and integrate live Avro data in Jitterbit.
-
Connecting GenSpark with Box Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Box data without any replication or custom integration required.
-
Query, Visualize, and Share live Dynamics 365 Business Central Data in Redash
Use CData Connect AI to connect to live Dynamics 365 Business Central data in Redash for querying, visualizing, and sharing.
-
How to connect and process CockroachDB data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live CockroachDB data.
-
Integrating GitHub Copilot with SQL Analysis Services 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 Salesforce Pardot 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 Salesforce Pardot data in real time using natural language.
-
Connect to Real-Time Wave Financial Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Wave Financial and Dataflow to import and use Wave Financial data in Power Apps.
-
Integrating GitHub Copilot with Raisers Edge NXT 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Autopilot
Create Autopilot data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access FTP Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live FTP data from HeidiSQL.
-
Use Grok to Talk to Your Authorize.Net 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 Authorize.Net data for you.
-
Automate Google Contacts Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Contacts data replication to Azure Data Lake.
-
How to Work with MarkLogic Data in ETL Validator JDBC
Connect to MarkLogic from ETL Validator jobs using the CData Software JDBC Driver.
-
Build a PostgreSQL Interface for Workable Data using the CData JDBC Driver
Use the Remoting features of the Workable JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Scrapfly Replication to SingleStore
Use CData Sync for automated, continuous, customizable Scrapfly replication to SingleStore.
-
Automated Continuous ZendeskSell Replication to Vertica
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Vertica.
-
Creating Google Campaign Manager 360-Connected Applications in Unqork
You can use CData Connect AI to feed Google Campaign Manager 360 data to Unqork and build custom business apps.
-
Connect Google Calendar Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Calendar data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate with Sage 200 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sage 200 data to a JSON file on disk.
-
How to connect to Autopilot Data from IntelliJ
Integrate connectivity to Autopilot data with wizards in IntelliJ.
-
How to create Excel federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Excel data in MySQL .
-
How to integrate Freshteam with Apache Airflow
Access and process Freshteam data in Apache Airflow using the CData JDBC Driver.
-
Access Invoiced Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Invoiced data from HeidiSQL.
-
Build Epicor Kinetic-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Epicor Kinetic data and build web apps with connectivity to live Epicor Kinetic data.
-
Connect to Adobe Experience Manager Data in Claris FileMaker Pro
Use the CData ODBC Driver for Adobe Experience Manager in FileMaker Pro to connect to Adobe Experience Manager and work with Adobe Experience Manager data in your FileMaker applications.
-
Build Dashboards with LinkedIn Ads Data in Dundas BI
Create dynamic dashboards and perform analytics based on LinkedIn Ads data in Dundas BI.
-
Automated Continuous Auth0 Replication to SingleStore
Use CData Sync for automated, continuous, customizable Auth0 replication to SingleStore.
-
Connect to Google Cloud Storage Data in Ruby
Connect to Google Cloud Storage data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to Figshare Data in DBVisualizer
Integrate Figshare data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Timely Data in RapidMiner
Integrate Timely data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Presto Data in the Pentaho Report Designer
Publish reports based on Presto data in the Pentaho BI tool.
-
Build Charts with GetResponse Data in Clear Analytics
Create dynamic charts and perform analytics based on GetResponse data in Clear Analytics.
-
Use the CData Software ODBC Driver for Clockify in MicroStrategy Desktop
Connect to Clockify data in MicroStrategy Desktop using the CData Software ODBC Driver for Clockify.