CData Software - Knowledge Base
Recent Articles
-
Build Apps with Live Salesforce Data Using the Low-Code Development Platform of Mendix
Connect Salesforce data with Mendix to build apps using the CData JDBC Driver for Salesforce.
-
How to Connect to Live Sybase 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 Sybase data through natural language.
-
Connect to Bullhorn CRM from Asprova with CData Software ODBC Driver for Bullhorn CRM
This article shows how to connect faster to Bullhorn CRM data from Asprova.
-
DataBind Charts to SingleStore Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SingleStore data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to Create Power BI Visual Reports with Real-Time Azure DevOps Data
Use CData Power BI Connectors to visualize Azure DevOps data in Power BI.
-
Build MVC Applications with Connectivity to Spark Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Spark from an ASP.NET MVC application.
-
Build Voice Agents in ElevenLabs with access to Live Klaviyo Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Klaviyo data.
-
Build a Singer.io Tap for Google Ads With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Ads data using the CData Python Connector.
-
Access Live Aweber Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Aweber data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to HubDB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for HubDB data.
-
Integrate Pipeline CRM Data in the Pentaho Report Designer
Publish reports based on Pipeline CRM data in the Pentaho BI tool.
-
Publish OneNote-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live OneNote data.
-
Stream ServiceNow Data into Apache Kafka Topics
Access and stream ServiceNow data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData Python Connector for MessageBird
Learn to install and license the CData Python Connector and configure a connection to live MessageBird data.
-
How to connect to Facebook Data in DBVisualizer
Integrate Facebook data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate with OneNote Data in SnapLogic
Use CData Connect AI to connect to and integrate with live OneNote data in SnapLogic.
-
Connect to Tally Data from Crystal Reports
Use CData Connect AI to connect to and report on live Tally data from Crystal Reports.
-
Integrating Boomi Agentstudio with Printify Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Printify data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Import Real-Time Everhour Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Everhour data in ColdFusion.
-
Integrate Theia IDE with Live HubDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live HubDB data from within the development environment.
-
Connect to Live BenchmarkEmail Data in PostGresSQL Interface through CData Connect AI
Create a live connection to BenchmarkEmail in CData Connect AI and connect to your BenchmarkEmail data from PostgreSQL.
-
Build Elasticsearch Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Elasticsearch data and build visualizations in Tableau Cloud.
-
Connect to CampaignMonitor Data in Aqua Data Studio
Access CampaignMonitor data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to GraphQL Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live GraphQL data.
-
Connect to Epicor Kinetic Data from HeidiSQL
Use CData Connect AI to connect to and query live Epicor Kinetic data from HeidiSQL.
-
Bridge XML Connectivity with Apache NiFi
Access and process XML data in Apache NiFi using the CData JDBC Driver.
-
Access Live SAP SuccessFactors LMS Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP SuccessFactors LMS data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automate Box Data Replication to SAP HANA
Use CData Sync to customize and automate Box data replication to SAP HANA.
-
Use JayDeBeApi to access Reply.io Data in Python
Use standard Python scripting and the development environment of your choice to access live Reply.io data.
-
Getting Started with the CData Tableau Connector for Pinecone
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Work with Live Monday.com Data in Power Query
Use CData Connect AI to connect to Monday.com data and work with live Monday.com data in Microsoft Power Query.
-
Back Up Freshteam data 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 Freshteam data data.
-
Replicate Stripe Data in Heroku for Use in Salesforce Connect
Replicate Stripe data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Migrating data from HubDB to Databricks using CData SSIS Components.
Easily push HubDB data to Databricks using the CData SSIS Tasks for HubDB and Databricks.
-
Connect Sage Intacct Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Sage Intacct data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query Pipedrive Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Pipedrive entities in PHP by modeling them as objects.
-
Automated Continuous Presto Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Presto replication to AlloyDB.
-
Rapidly Develop Access-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 Access.
-
Automate Supabase Data Replication to Couchbase
Use CData Sync to Customize and automate Supabase data replication to Couchbase.
-
Replicate Asana Data to Multiple Databases
Replicate Asana data to disparate databases with a point-and-click configuration.
-
Build a Singer.io Tap for Reply.io With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Reply.io data using the CData Python Connector.
-
How to connect and process Azure Synapse data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Azure Synapse data.
-
Automate Wistia Data Replication to Azure Data Lake
Use CData Sync to customize and automate Wistia data replication to Azure Data Lake.
-
How to connect to Bitbucket Data from Spring Boot
Connect to Bitbucket in a Spring Boot Application using the CData JDBC Driver for Bitbucket
-
Enable the Cvent JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Cvent data.
-
Automated Continuous Microsoft Planner Replication to Oracle
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Oracle.
-
Create Reports with Basecamp Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Basecamp data.
-
How to Connect to Live Exact Online Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Exact Online data securely in real time.
-
Choosing the Best Method to Connect LeadDesk to SQL Server: 5 Options Explained
Discover multiple ways to connect and use LeadDesk data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Campaigner 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 Campaigner data.
-
Integrating GitHub Copilot with EmailOctopus 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 update Paylocity from Excel
This article explains how to transfer data from Excel to Paylocity using the Excel Add-In for Paylocity.
-
Automated Continuous Cvent Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Cvent replication to Apache Kafka.
-
Connect to Raisers Edge NXT Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Raisers Edge NXT Data and connect to Raisers Edge NXT data in Akorbi Digital RunMyProcess.
-
Integrate Live Unbounce Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Unbounce data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to create an RPA flow for Dotmailer Data in UiPath Studio
Use the Dotmailer ODBC Driver to create workflows that access real-time Dotmailer data without any coding.
-
Excel Spreadsheet Automation on CSV Data with the QUERY Formula
Pull data from CSV, automate spreadsheets, and more with the QUERY formula.
-
Build MVC Applications with Connectivity to Zoho Projects Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho Projects from an ASP.NET MVC application.
-
How to create an RPA flow for SAP SuccessFactors Data in UiPath Studio
Use the SAP SuccessFactors ODBC Driver to create workflows that access real-time SAP SuccessFactors data without any coding.
-
Create Dynamics CRM-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Dynamics CRM Data from Klipfolio and build custom visualizations using live Dynamics CRM data.
-
Connect to and Visualize Live AdRoll Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live AdRoll data.
-
Build an OLAP Cube in SSAS from Toggl Data
Establish a connection to Toggl data data from SQL Server Analysis Services, and use the Toggl Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect the Power BI Service to Float: Complete Guide
Connect to the CData Software Power BI Connector for Float from PowerBI.com to provide real-time Float data across the organization.
-
How to Create Power BI Visual Reports with Real-Time Google Campaign Manager 360 Data
Use CData Power BI Connectors to visualize Google Campaign Manager 360 data in Power BI.
-
Build Charts with Pinterest Data in Clear Analytics
Create dynamic charts and perform analytics based on Pinterest data in Clear Analytics.
-
Natively Connect to eBay Analytics Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to eBay Analytics data. Leverage the native support for ODBC in PHP.
-
How to Connect DBeaver to Airtable via a JDBC Driver
Manage Airtable data with visual tools in DBeaver like the query browser.
-
Publish Crystal Reports on Google Spanner Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Spanner data.
-
How to connect to Attio Data in DBVisualizer
Integrate Attio data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Power BI Reports on Real-Time Dynamics CRM Data
Use the CData ODBC Driver for Dynamics CRM to visualize Dynamics CRM data in Power BI Desktop.
-
Migrating data from SAP Ariba Procurement to Snowflake using CData SSIS Components.
Easily push SAP Ariba Procurement data to Snowflake using the CData SSIS Tasks for SAP Ariba Procurement and Snowflake.
-
Connect to Deel Data from PowerBuilder via ADO.NET
This article demonstrates how to access Deel data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Consume Oracle Service Cloud OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle Service Cloud feeds that reflect any changes in SAP Lumira.
-
How to Build an ETL App for Oracle Sales Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle Sales data in Python with petl.
-
View Reports on Real-Time Oracle Service Cloud Data in Power BI Report Server
Use the CData ODBC Driver for Oracle Service Cloud to visualize Oracle Service Cloud data in Power BI Desktop and then publish them to Power BI Report Server.
-
Migrating data from Salesforce Marketing to Databricks using CData SSIS Components.
Easily push Salesforce Marketing data to Databricks using the CData SSIS Tasks for Salesforce Marketing and Databricks.
-
Getting Started with the CData ADO.NET Provider for Aircall
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous ZohoExpense Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZohoExpense replication to delimited files (CSV/TSV).
-
Publish Tavily-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Tavily data.
-
Enable the Todoist JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Todoist data.
-
Replicate SharePoint Data in Heroku for Use in Salesforce Connect
Replicate SharePoint data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Aha! Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Aha! replication to Azure SQL Database.
-
Connect to Dropbox Data from a Connection Pool in Jetty
The Dropbox JDBC Driver supports connection pooling: This article shows how to connect faster to Dropbox data from Web apps in Jetty.
-
Integrating LangGraph with HCL Domino Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on HCL Domino data within automated workflows.
-
Rapidly Develop Strava-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 Strava.
-
Build Google Drive-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 Google Drive data without replication.
-
Integrate Live Zoho Creator Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Zoho Creator data and integrate live Zoho Creator data into apps built in Microsoft Power Apps.
-
Replicate FreshBooks Data to Multiple Databases via the CData Sync CLI
Replicate FreshBooks data to disparate databases with a single configuration.
-
Integrate Google's Antigravity Agent with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Pipedrive data using the Model Context Protocol.
-
Connecting GenSpark with Zuora Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Zuora data without any replication or custom integration required.
-
Import and Visualize Planio Data in Power View
Create data visualizations based on Planio data in Excel.
-
Connect to SAP Hybris C4C from Asprova with CData Software ODBC Driver for SAP Hybris C4C
This article shows how to connect faster to SAP Hybris C4C data from Asprova.
-
Automated Continuous Testmonitor Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Testmonitor replication to Google Cloud SQL.
-
How to Connect to Live Redshift 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 Redshift data for you.
-
Connect to Teamwork Data from a Connection Pool in JBoss
Integrate Teamwork data into Java servlets: Use the Management Console in JBoss to install the Teamwork JDBC Driver.
-
Integrate LibreChat with Live Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Ad Manager data from within the chat interface.
-
Connect to Confluence Data in Ruby
Connect to Confluence data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating Codex with SparkPost 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.
-
Getting Started with the CData ODBC Driver for Sendwithus
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sendwithus.
-
Connect Oracle SCM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle SCM data using the CData Python MCP Server.