CData Software - Knowledge Base
Recent Articles
-
Connect to SageHR Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SageHR data using standard SQL.
-
Visualize SAP Business One Data in Sisense
Create an ElastiCube in Sisense app with access to SAP Business One data.
-
Build a Singer.io Tap for Avro With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Avro data using the CData Python Connector.
-
Integrate Postmark Data in the Pentaho Report Designer
Publish reports based on Postmark data in the Pentaho BI tool.
-
Model Bitly Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Bitly, enabling the direct import of real-time Bitly data.
-
Connect to and Visualize Live Google Calendar Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Calendar data.
-
Work with Guru Data in FoxPro
Load Guru data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Wistia Data in Talend Cloud Data Management Platform
Connect Wistia Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use the CData Software ODBC Driver for PostgreSQL in MicroStrategy Desktop
Connect to PostgreSQL data in MicroStrategy Desktop using the CData Software ODBC Driver for PostgreSQL.
-
Link Rebilly with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Rebilly data in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData Connect AI Python SDK for Sugar CRM
Install the CData Connect AI Python SDK to read and write live Sugar CRM data with standard DB-API 2.0 Python code.
-
Replicate Jumpseller Data to Multiple Databases
Replicate Jumpseller data to disparate databases with a point-and-click configuration.
-
How to Build an ETL App for Sugar CRM Data in Python with CData Connect AI
Build ETL pipelines that read and write live Sugar CRM data in Python with petl and the CData Connect AI Python SDK.
-
Easily Integrate MailerLite Data in Lazarus Pascal IDE
Learn how to easily integrate live MailerLite data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Create Power BI Visual Reports with Real-Time Zuora Data
Use CData Power BI Connectors to visualize Zuora data in Power BI.
-
How to integrate SQL Server with Apache Airflow
Access and process SQL Server data in Apache Airflow using the CData JDBC Driver.
-
Replicate Typeform Data in Heroku for Use in Salesforce Connect
Replicate Typeform data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Apify Data in Cognos Analytics
Use CData Connect AI to connect to Apify Data from Cognos Analytics and analyze live Apify data.
-
Replicate Zoho Projects Data to Multiple Databases
Replicate Zoho Projects data to disparate databases with a point-and-click configuration.
-
Rapidly Develop Nethunt-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 Nethunt.
-
Use ChatGPT to Talk to Your Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Authorize.Net data for you.
-
Build Cloudant-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Cloudant Data and create custom apps in Bubble.
-
Connecting Moonlit Workflow with QuickBooks 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 QuickBooks data in real time.
-
Automated Continuous SAP Fieldglass Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to SingleStore.
-
Automated Continuous Zoho CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoho CRM replication to IBM DB2.
-
How to Access Live GitLab Data in Power Automate Desktop via ODBC
The CData ODBC Driver for GitLab enables you to integrate GitLab data into workflows built using Microsoft Power Automate Desktop.
-
How to Build an ETL App for Hubstaff Data in Python with CData
Create ETL applications and real-time data pipelines for Hubstaff data in Python with petl.
-
How to Visualize Microsoft Planner Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Planner data in Python.
-
Access Live Azure Analysis Services Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Azure Analysis Services data through MCP integration.
-
Integrating Boomi Agentstudio with ZohoDesk Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ZohoDesk data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to and Query SuiteCRM Data in QlikView over ODBC
Create data visualizations with SuiteCRM data in QlikView.
-
Excel Spreadsheet Automation on Kintone Data with the QUERY Formula
Pull data from Kintone, automate spreadsheets, and more with the QUERY formula.
-
DataBind Controls to Wistia Data in C++Builder
DataBind to Wistia data in C++Builder with standard components and controls.
-
Create Dashboards and Visualize Live Campaigner Data in Geckoboard
Use CData Connect AI to connect to live Campaigner data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Build an ETL App for Adobe Analytics Data in Python with CData Connect AI
Extract and transform live Adobe Analytics data in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous JobNimbus Replication to SQL Server
Use CData Sync for automated, continuous, customizable JobNimbus replication to SQL Server.
-
Bind Live QuickBooks Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Automate Shortcut Data Replication to Azure Synapse
Use CData Sync to customize and automate Shortcut data replication to Azure Synapse.
-
How to Build an ETL App for Highrise Data in Python with CData
Create ETL applications and real-time data pipelines for Highrise data in Python with petl.
-
Connect Sybase IQ to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sybase IQ data using the CData Python MCP Server.
-
Automated Continuous CapsuleCRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to SingleStore.
-
Build Pipelines with Live Paymo Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Paymo from Google Cloud Data Fusion, enabling the integration of live Paymo data into the building and management of effective data pipelines.
-
Build Agents in Relevance AI with Access to Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle Service Cloud data within intelligent agent workflows.
-
How to use SQLAlchemy ORM to access Humanity Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Humanity data.
-
Integrate Dify with Live OneNote Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live OneNote data.
-
Connect to ZarMoney Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZarMoney as an External Source in Dremio.
-
Write a Simple Go Application to work with SFTP Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SFTP data.
-
How to connect to Mouseflow Data from Spring Boot
Connect to Mouseflow in a Spring Boot Application using the CData API Driver for JDBC
-
Build Apps with Live LightSpeedRetail Data Using the Low-Code Development Platform of Mendix
Connect LightSpeedRetail data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to and Query Omnisend Data in QlikView over ODBC
Create data visualizations with Omnisend data in QlikView.
-
Automated Continuous Zoom Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoom replication to IBM DB2.
-
Integrating Cursor with Dynamics 365 Business Central 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.
-
Analyze CampaignMonitor Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze CampaignMonitor data with the CData JDBC Driver for CampaignMonitor.
-
Connect to Slack Data from PowerBuilder via JDBC
This article demonstrates how to access Slack data from PowerBuilder using the Slack JDBC Driver.
-
Access Live IBM Informix Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live IBM Informix data from your Excel spreadsheets.
-
Integrate Google's Vertex AI Agent with Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data within intelligent workflows.
-
Write a Simple Go Application to work with Cloudflare Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Cloudflare data.
-
Automated Continuous Omnisend Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Omnisend replication to PostgreSQL.
-
Connect to Hugging Face Data from a Connection Pool in Jetty
The Hugging Face JDBC Driver supports connection pooling: This article shows how to connect faster to Hugging Face data from Web apps in Jetty.
-
Using the CData Software ODBC Driver for Gong in PyCharm
Connect to Gong as an ODBC data source in PyCharm using the CData Software ODBC Driver for Gong.
-
Query Live Oracle HCM Cloud Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Oracle HCM Cloud data directly from the development environment.
-
Publish Crystal Reports on SQL Analysis Services Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SQL Analysis Services data.
-
How to create Visio diagrams from Oracle Service Cloud Data
Automatically update Oracle Service Cloud data with the changes you make to Visio master shapes.
-
Create Dynamic Paymo Grids Using the Infragistics XamDataGrid
Learn how you can connect Paymo to Infragistics XamDataGrid to build dynamic grids.
-
Build a PostgreSQL Interface for Cosmos DB Data using the CData JDBC Driver
Use the Remoting features of the Cosmos DB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Quickbase Data in DBxtra
Create dynamic dashboards and perform analytics based on Quickbase data in DBxtra.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Impala
Provide connectivity to Impala data through an SAP BusinessObjects universe.
-
Getting Started with the CData SSIS Components for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sage Cloud Accounting.
-
Use Databricks Agent Bricks to Talk to Your Google Campaign Manager 360 Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Campaign Manager 360 data for you.
-
Build Charts with CloudConvert Data in Clear Analytics
Create dynamic charts and perform analytics based on CloudConvert data in Clear Analytics.
-
Connect to Zoho CRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho CRM and the SQL Gateway to access Zoho CRM data from Google Apps Script.
-
Build AI Agents with eBay Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live eBay data through CData Connect AI.
-
Access Live Marketo Data in AWS Lambda
Connect to live Marketo data in AWS Lambda using the CData JDBC Driver.
-
CloudConvert Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on CloudConvert facts in real time.
-
How to create Landbot federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Landbot data in MySQL .
-
Provide OData Services of Google Cloud Storage Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Cloud Storage data by developing a WCF Service Application.
-
Automate SAP Netweaver Gateway Data Replication to Couchbase
Use CData Sync to Customize and automate SAP Netweaver Gateway data replication to Couchbase.
-
Automated Continuous Mode Replication to Oracle
Use CData Sync for automated, continuous, customizable Mode replication to Oracle.
-
Build SuiteCRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SuiteCRM data and build SuiteCRM-connected web apps with Axios.
-
Build TaxJar-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live TaxJar data.
-
Build Apps with Live ShipStation Data Using the Low-Code Development Platform of Mendix
Connect ShipStation data with Mendix to build apps using the CData JDBC Driver for ShipStation.
-
Import Real-Time XML Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use XML data in ColdFusion.
-
Getting Started with the CData SSIS Components for Codat
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Codat.
-
Visualize Paddle Data in Sisense
Create an ElastiCube in Sisense app with access to Paddle data.
-
Import SAP ByDesign Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP ByDesign Data and provide access to live SAP ByDesign data for custom reports in the Power BI Service.
-
Deploy the ADO.NET Provider for Confluence on an SSRS Report Server
Connect to Confluence data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Replicate Dynamics 365 Business Central Data from PowerShell
Write a quick PowerShell script to query Dynamics 365 Business Central data. Use connectivity to the live data to replicate Dynamics 365 Business Central data to SQL Server.
-
DataBind HubDB Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for HubDB with the DevExpress Windows Forms and Web controls to provide HubDB data to a chart.
-
Use Microsoft Copilot Studio to talk to your Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Blackbaud FE NXT data for you.
-
Connect to Facebook Ads Data in DBArtisan
Use wizards in DBArtisan to configure Facebook Ads data as a data source.
-
Connect to eBay Analytics from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from eBay Analytics data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData Software ODBC Driver for Planio in SAS for Real-Time Reporting and Analytics
Connect to real-time Planio data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Planio.
-
Connect to Miro Data from a Connection Pool in JBoss
Integrate Miro data into Java servlets: Use the Management Console in JBoss to install the Miro JDBC Driver.
-
Operational Reporting on Cassandra Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Cassandra data.
-
Creating Adobe Target-Connected Applications in Unqork
You can use CData Connect AI to feed Adobe Target data to Unqork and build custom business apps.
-
Model SAP ByDesign Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP ByDesign, enabling the direct import of real-time SAP ByDesign data.
-
Automated Continuous Browserless Replication to SQLite
Use CData Sync for automated, continuous, customizable Browserless replication to SQLite.
-
How to Easily Query Salesforce Data in OpenOffice Base
Connect to Salesforce data in OpenOffice Base using the CData ODBC Driver for Salesforce and generate reports with live data insights.
-
Use Databricks Agent Bricks to Talk to Your Salesforce CRM Analytics Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Salesforce CRM Analytics data for you.
-
How to connect and process Clockify data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Clockify data.