CData Software - Knowledge Base
Recent Articles
-
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 within assisted coding and automated development workflows.
-
Automate Azure DevOps Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Azure DevOps and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Query Live BigQuery Data in Claude Desktop
Connect to and query live BigQuery Data in Claude Desktop using CData MCP Server.
-
How to integrate Metabase with FTP Data
Use CData Connect AI to connect to live FTP Servers and create an interactive dashboard in Metabase from FTP Servers.
-
Import Real-Time SharePoint Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft SharePoint in ColdFusion.
-
Connect to Twilio Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Twilio.
-
How to create Visio diagrams from Microsoft Exchange Data
Automatically update Microsoft Exchange with the changes you make to Visio master shapes.
-
Getting Started with the CData Excel Add-In for WordPress
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for WordPress.
-
Automated Continuous ConstantContact Replication to SingleStore
Use CData Sync for automated, continuous, customizable ConstantContact replication to SingleStore.
-
Integrate Tally Data into Power Automate Desktop using CData Connect
CData Connect for Tally Data enables you to integrate Tally ERP into workflows built using Microsoft Power Automate Desktop.
-
Analyze MariaDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MariaDB in Microsoft R Open.
-
Automated Continuous Bitbucket Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Bitbucket replication to delimited files (CSV/TSV).
-
Use Agno to Talk to Your Zoho Creator Data 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 Zoho Creator for you.
-
Working with LaunchDarkly Data in LINQPad
Execute LINQ queries to LaunchDarkly in LINQPad.
-
Connect to Square Data in HULFT Integrate
Connect to Square as a JDBC data source in HULFT Integrate
-
Connect to Redshift 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 Amazon Redshift.
-
Connect to Samanage Data in RazorSQL
Connect to Samanage from wizards and query Samanage from the GUI in the RazorSQL database management tool.
-
Use the CData Software ODBC Driver for Drip in MicroStrategy Desktop
Connect to Drip in MicroStrategy Desktop using the CData Software ODBC Driver for Drip.
-
Create Dynamic Azure Analysis Services Grids Using the Infragistics XamDataGrid
Learn how you can connect Azure Analysis Services to Infragistics XamDataGrid to build dynamic grids.
-
Design BIRT Reports on Auth0 Data
Provide current Auth0 to your embedded analytics.
-
How to create Wistia federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Wistia in MySQL .
-
Stream RSS Feeds into Apache Kafka Topics
Access and stream RSS Feeds in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Apps with Live PolarTeamPro Data Using the Low-Code Development Platform of Mendix
Connect PolarTeamPro with Mendix to build apps using the CData API Driver for JDBC.
-
DataBind Controls to MongoDB Data in C++Builder
DataBind to MongoDB in C++Builder with standard components and controls.
-
Integrate Live BigCommerce Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to BigCommerce and integrate live BigCommerce into apps built in Microsoft Power Apps.
-
Work with Attio Data in FoxPro
Load Attio into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Adobe Commerce Data in Excel 365 Online (Excel for the web)
Connect to Adobe Commerce from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect to Live LinkedIn Ads 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 LinkedIn Ads through natural language.
-
Automated Continuous Zoho CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zoho CRM replication to OneLake in Microsoft Fabric.
-
Build Greenhouse-Connected Apps in Choreo
Use CData Connect AI to connect to Greenhouse Data from Choreo and build custom apps using live Greenhouse.
-
Microsoft OneDrive Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft OneDrive through CData Connect AI using different applications and tools.
-
Use the CData Software ODBC Driver for Neo4J in MicroStrategy Desktop
Connect to Neo4J in MicroStrategy Desktop using the CData Software ODBC Driver for Neo4J.
-
Build Mistral AI-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Mistral AI Data in GitHub Copilot to assist with building Mistral AI-powered applications.
-
Create Dynamic Templated Grids Using the Infragistics XamDataGrid
Learn how you can connect Templated to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Teradata Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Teradata using standard SQL.
-
Query Exact Online Data in ColdFusion
Write standard ColdFusion data access code to connect to Exact Online.
-
Replicate Multiple Zoho Projects Accounts
Replicate multiple Zoho Projects accounts to one or many databases.
-
How to Connect to SAP Business Warehouse Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Business Warehouse. Leverage the pyodbc module for ODBC in Python.
-
Connect to Tally Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Tally Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build SAP SuccessFactors-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP SuccessFactors and build web apps with connectivity to live SAP SuccessFactors.
-
Automated Continuous NetSuite Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable NetSuite replication to Azure SQL Database.
-
Edit and Search External Google Search Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Search to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Search Results objects that you can access from apps and the dashboard.
-
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.
-
Integrating Antigravity CLI with Bullhorn CRM via CData CLI
Connect Bullhorn CRM to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Back Up Auth0 to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Auth0 data.
-
Connect to SAP Business One Data from a Connection Pool in JBoss
Integrate SAP Business One into Java servlets: Use the Management Console in JBoss to install the SAP Business One JDBC Driver.
-
Connect to Monday.com Data in DBArtisan
Use wizards in DBArtisan to configure Monday.com as a data source.
-
How to update Act-On from Excel
This article explains how to transfer data from Excel to Act-On using the Excel Add-In for Act-On.
-
How to work with Zoho Recruit Data in Apache Spark using SQL
Access and process Zoho Recruit Data in Apache Spark using the CData Software JDBC Driver.
-
How to import Sentry Data into Apache Solr
Use the CData Software JDBC Driver for Sentry in Data Import Handler and create an automated import of Sentry to Apache Solr Enterprise Search platform.
-
Moving Data from Close to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Close data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Microsoft Copilot Studio to talk to your Freshservice 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 Freshservice for you.
-
Write a Simple Go Application to work with Invoiced Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Invoiced.
-
Toggl Reporting in OBIEE with the Toggl JDBC Driver
Deploy the Toggl JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to ADP Data in Aqua Data Studio
Access ADP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to WooCommerce Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time WooCommerce using standard SQL.
-
Excel Spreadsheet Automation on AgileCRM Data with the QUERY Formula
Pull data from AgileCRM, automate spreadsheets, and more with the QUERY formula.
-
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 into Microsoft Power Query.
-
Analyze SAP BusinessObjects BI Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP BusinessObjects BI and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Query Google Campaign Manager 360 Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Campaign Manager 360 from Node.js.
-
How to connect SharePoint with IBM Informix Data through external lists
Provide IBM Informix to SharePoint users as an external list.
-
Automated Continuous Adobe Analytics Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Amazon Redshift.
-
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 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoho Creator in Excel.
-
Create Power BI XMLA-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Power BI XMLA Data from Klipfolio and build custom visualizations using live Power BI XMLA.
-
Getting Started with the CData Excel Add-In for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dynamics CRM.
-
Automate Azure Blob Storage Data Replication to Couchbase
Use CData Sync to Customize and automate Azure Blob Storage replication to Couchbase.
-
How to Connect to Live Google Spanner 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 Google Spanner for you.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft Exchange Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Exchange to SQL Server.
-
How to integrate Metabase with Office 365 Data
Use CData Connect AI to connect to live Microsoft Office 365 and create an interactive dashboard in Metabase from Microsoft Office 365.
-
Create Apps from Vertica Data in Qlik Sense Cloud
Use CData Connect AI to connect to Vertica Data and build apps from live Vertica in Qlik Sense Cloud.
-
Automated Continuous Zoho Projects Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Google Cloud SQL.
-
Integrating Antigravity CLI with Salesloft via CData CLI
Connect Salesloft to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Query Live Sage Intacct 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 Sage Intacct directly from the development environment.
-
How to Access CSV Data Using Entity Framework
This article shows how to access CSV/TSV Files using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to LinkedIn Ads Data in RazorSQL
Connect to LinkedIn Ads from wizards and query LinkedIn Ads from the GUI in the RazorSQL database management tool.
-
Automate Reckon Accounts Hosted Data Replication to SAP HANA
Use CData Sync to customize and automate Reckon Accounts Hosted replication to SAP HANA.
-
Connect to Dynamics CRM Data in JRuby
Create a simple JRuby app with access to live Microsoft Dynamics CRM.
-
Build Automated Stripe-Connected Workflows in Zapier
Use CData Connect AI to connect to live Stripe and build automated workflows in Zapier.
-
Load Anaplan Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Anaplan to a database.
-
Create Dynamic ZeroBounce Grids Using the Infragistics XamDataGrid
Learn how you can connect ZeroBounce to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Live Snapchat Ads Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Query Live Bugsnag Data in Perplexity MacOS Desktop
Connect to and query live Bugsnag Data in Perplexity Desktop using CData MCP Server.
-
Connecting Moonlit Workflow with SAP HANA 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 SAP HANA in real time.
-
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 across the organization.
-
Build Flowlu-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Flowlu.
-
Prepare, Blend, and Analyze Elorus Data in Alteryx Designer (ODBC)
Build workflows to access live Elorus for self-service data analytics.
-
Publish SurveyMonkey-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SurveyMonkey.
-
Integrate MessageBird Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MessageBird from Informatica Cloud.
-
Connect to Real-Time Lakebase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Lakebase and Dataflow to import and use Lakebase in Power Apps.
-
Back Up Presto to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Presto. In this article, we will employ an SSIS workflow to populate a database with Presto data.
-
Rapidly Develop Google Campaign Manager 360-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 Google Campaign Manager 360.
-
Feed SAP Hybris C4C Data into FineReport
How to set SAP Hybris C4C as a JDBC data source in FineReport.
-
Integrating OpenCode Terminal with Act-On 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 AgileCRM Replication to Vertica
Use CData Sync for automated, continuous, customizable AgileCRM replication to Vertica.
-
Use the CData Software ODBC Driver for Phoenix in MicroStrategy Web
Connect to Apache Phoenix in MicroStrategy Web using the CData Software ODBC Driver for Phoenix.
-
Integrating Codex CLI with Aircall 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 a Singer.io Tap for Contentful With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Contentful data using
-
Automated Continuous Neo4J Replication to SQLite
Use CData Sync for automated, continuous, customizable Neo4J replication to SQLite.
-
Automated Continuous Shopify Replication to SQL Server
Use CData Sync for automated, continuous, customizable Shopify replication to SQL Server.
-
Design BIRT Reports on Microsoft OneDrive Data
Provide current Microsoft OneDrive to your embedded analytics.