CData Software - Knowledge Base
Recent Articles
-
Connect to Mode Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Mode data using standard SQL.
-
Use Dash to Build to Web Apps on Shopify Data
Create Python applications that use pandas and Dash to build Shopify-connected web apps.
-
Stream SAP SuccessFactors LMS Data into Apache Kafka Topics
Access and stream SAP SuccessFactors LMS data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Google's Vertex AI Agent with Live ZohoMarketingHub 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 ZohoMarketingHub data within intelligent workflows.
-
Integrating Aircall Data in Talend Cloud Data Management Platform
Connect Aircall Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Sage 300 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sage 300 replication to Google Cloud SQL.
-
Integrating WooCommerce Data in Talend Cloud Data Management Platform
Connect WooCommerce Data with Talend Cloud Data Management Platform using the CData JDBC Driver for WooCommerce.
-
ETL Datadog in Oracle Data Integrator
This article shows how to transfer Datadog data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous LDAP Replication to SQL Server
Use CData Sync for automated, continuous, customizable LDAP replication to SQL Server.
-
How to Query Live Bright Data Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Bright Data data data in natural language using Python.
-
Process & Analyze Microsoft Exchange Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Microsoft Exchange Data.
-
Connect to Live Teradata Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Teradata in CData Connect AI and connect to your Teradata data from PostgreSQL.
-
DataBind Front Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Front data to a chart.
-
Access Live AgileCRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live AgileCRM data from your Excel spreadsheets.
-
Use the CData Software ODBC Driver for Reckon in MicroStrategy Desktop
Connect to Reckon data in MicroStrategy Desktop using the CData Software ODBC Driver for Reckon.
-
Connect to Tavily Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Tavily data in the Denodo Virtual DataPort Administrator.
-
Build Power BI XMLA Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Power BI XMLA data and build visualizations in Tableau.
-
Integrating Kiro with MailerSend 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.
-
Connect to Beeminder Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Beeminder data.
-
Automated Continuous Todoist Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Todoist replication to delimited files (CSV/TSV).
-
Creating Amazon DynamoDB-Connected Applications in Unqork
You can use CData Connect AI to feed Amazon DynamoDB data to Unqork and build custom business apps.
-
Build Customer.io-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Customer.io data.
-
Use JayDeBeApi to access Email Data in Python
Use standard Python scripting and the development environment of your choice to access live Email data.
-
Query Beeminder Data in ColdFusion
Write standard ColdFusion data access code to connect to Beeminder data.
-
Integrating Claude Code with Stripe Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Stripe data within assisted coding and automated development workflows.
-
How to Query AdRoll Data in MySQL Workbench
Execute MySQL queries against live AdRoll data from MySQL Workbench.
-
Connect to CapsuleCRM Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for CapsuleCRM Data and connect to CapsuleCRM data in Akorbi Digital RunMyProcess.
-
Prepare, Blend, and Analyze LinkedIn Data in Alteryx Designer (ODBC)
Build workflows to access live LinkedIn data for self-service data analytics.
-
Automated Continuous ServiceNow Replication to Vertica
Use CData Sync for automated, continuous, customizable ServiceNow replication to Vertica.
-
How to Visualize SAP HANA 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 SAP HANA data in Python.
-
Analyze Cvent Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Cvent data and visualize Cvent data in SAP Analytics Cloud.
-
Create WordPress-Connected Dashboards in Grafana
Connect to WordPress Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to WordPress data.
-
Bind Live Microsoft Exchange Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Exchange data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Highrise Data in Google Apps Script via Connect AI
Use CData Connect AI to access Highrise data in Google Apps Script.
-
Automated Continuous PabblySubscriptions Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Azure SQL Database.
-
How to connect to Email Data from IntelliJ
Integrate connectivity to Email data with wizards in IntelliJ.
-
Connect to Square Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Square data.
-
Connect to Real-Time PostgreSQL Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for PostgreSQL and Dataflow to import and use PostgreSQL data in Power Apps.
-
Migrating data from eBay Analytics to Snowflake using CData SSIS Components.
Easily push eBay Analytics data to Snowflake using the CData SSIS Tasks for eBay Analytics and Snowflake.
-
Visualize Live Exa Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Exa data.
-
Replicate Multiple Attio Accounts
Replicate multiple Attio accounts to one or many databases.
-
Visualize Zoho CRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoho CRM data.
-
Integrating Claude Code CLI with Google Forms 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 Power BI Reports on Real-Time OneNote Data
Use the CData ODBC Driver for OneNote to visualize OneNote data in Power BI Desktop.
-
Use the CData ODBC Driver for Act CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Act CRM to connect to Act CRM data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Act CRM data in Excel.
-
Build Dashboards with Amazon S3 Data in DBxtra
Create dynamic dashboards and perform analytics based on Amazon S3 data in DBxtra.
-
Use JayDeBeApi to access Gorgias Data in Python
Use standard Python scripting and the development environment of your choice to access live Gorgias data.
-
Access Live Mode Data in Excel 365 Online (Excel for the web)
Connect to Mode data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Query ScrapingBee Data in DataGrip
Create a Data Source for ScrapingBee in DataGrip and use SQL to query live ScrapingBee data.
-
How to Easily Query Zoho Recruit Data in OpenOffice Base
Connect to Zoho Recruit data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to connect PolyBase to Blackbaud FE NXT
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Blackbaud FE NXT data.
-
Query Live SageHR 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 SageHR data directly from the development environment.
-
How to Connect to Live SurveyMonkey Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SurveyMonkey data securely in real time.
-
Integrate Active Directory Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Active Directory data and integrate live Active Directory data into your Power Automate tasks.
-
Analyze Live Salesforce Data in Infragistics Reveal by Connecting through CData Connect AI or CData API Server
Use CData Connect AI or CData API Server to create an OData API on top of Salesforce data and visualize live Salesforce data in Infragistics Reveal.
-
Build Amazon S3-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Amazon S3 data and build Amazon S3-connected web apps with Axios.
-
How to connect and process HubDB data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live HubDB data.
-
Visualize Live Salesforce Pardot Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Salesforce Pardot data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Natively Connect to PolarTeamPro Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PolarTeamPro data. Leverage the native support for ODBC in PHP.
-
Connect to Landbot from a Connection Pool in WebLogic
Use the CData JDBC Driver for Landbot to connect to Landbot data from Web applications running on WebLogic.
-
Explore Geographical Relationships in Sugar CRM Data with Power Map
Create data visualizations with Sugar CRM data in Power Map.
-
A PostgreSQL Interface for Jumpseller Data using the CData ODBC Driver
Use the SQL Gateway and Jumpseller ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to CockroachDB Data in DBArtisan
Use wizards in DBArtisan to configure CockroachDB data as a data source.
-
How to Connect to & Open Google Cloud Storage Data in Microsoft Excel
This article uses the CData ODBC driver for Google Cloud Storage to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous ZohoExpense Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Apache Cassandra.
-
How to publish and share Dynamics NAV Data dashboards with Tableau Server
The CData ODBC driver for Dynamics NAV enables you integrate Dynamics NAV data into Tableau dashboards.
-
Build Automated ShipStation-Connected Workflows in Zapier
Use CData Connect AI to connect to live ShipStation data and build automated workflows in Zapier.
-
Access Nethunt Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Nethunt data from your Oracle system.
-
How to Access OnePageCrm Data Using Entity Framework
This article shows how to access OnePageCrm data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Reports from Perplexity Data in Looker Studio
Use CData Connect AI to gain access to live Perplexity data and create custom reports in Looker Studio.
-
Query Live Guru Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Guru data through a conversational interface.
-
Build Mailjet-Connected Apps in Choreo
Use CData Connect AI to connect to Mailjet Data from Choreo and build custom apps using live Mailjet data.
-
Build Semantic Layer Views for SAP Fieldglass Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Fieldglass data.
-
Analyze AgileCRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze AgileCRM data in Microsoft R Open.
-
Access Live Twilio Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Twilio data from your Excel spreadsheets.
-
How to Connect to & Open Pingdom Data in Microsoft Excel
This article uses the CData ODBC driver for Pingdom to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Work with Live SAS xpt Data in Power Query
Use CData Connect AI to connect to SAS xpt data and work with live SAS xpt data in Microsoft Power Query.
-
Access Live Guru Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Guru data from your Excel spreadsheets.
-
Consume MySQL OData Feeds in SAP Lumira
Use the API Server to create data visualizations on MySQL feeds that reflect any changes in SAP Lumira.
-
How to import LinkedIn Ads Data into Apache Solr
Use the CData Software JDBC Driver for LinkedIn Ads in Data Import Handler and create an automated import of LinkedIn Ads data to Apache Solr Enterprise Search platform.
-
Connect Go Applications to Web APIs Using net/http and CData API Server
Learn how to connect Go applications to datasource by exposing tables as REST APIs with CData API Server.
-
Replicate Xero Data to Multiple Databases
Replicate Xero data to disparate databases with a point-and-click configuration.
-
Connect to Salesforce CRM Analytics from a Connection Pool in WebLogic
Use the CData JDBC Driver for Salesforce CRM Analytics to connect to Salesforce CRM Analytics data from Web applications running on WebLogic.
-
Analyze Notion Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Notion data and visualize Notion data in SAP Analytics Cloud.
-
Use Claude to Talk to Your Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Couchbase data for you.
-
Build VWO-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to VWO Data from Zoho Analytics and import live VWO data.
-
Build a Simple VCL Application for Intercom Data
How to build a simple VCL Application to view Intercom data in RAD Studio using the CData ODBC Driver for Intercom.
-
Automated OData Services Replication to Teradata
Use CData Sync to Customize and automate OData services replication to Teradata.
-
Access Live SAP HANA XS Advanced Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP HANA XS Advanced data from your Excel spreadsheets.
-
Back Up Simplesat 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 Simplesat data data.
-
Build Apps with Live Google Directory data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Directory data into the Adalo platform and build custom mobile and web applications with real-time Google Directory data.
-
Connect to Intercom Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Intercom as an External Source in Dremio.
-
Create Amazon Marketplace-Connected Applications in Appsmith
Connect to Amazon Marketplace Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Amazon Marketplace data.
-
Connect to Suadeo Data in NetBeans
Connect to Suadeo data in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Python Connector for SAP SuccessFactors LMS
Learn to install and license the CData Python Connector and configure a connection to live SAP SuccessFactors LMS data.
-
Connect to Apify Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Apify data using standard SQL.
-
Build Data Flows from SQL Server to Sybase IQ through SSIS
Easily push SQL Server data to Sybase IQ using the CData SSIS Tasks for Sybase IQ.
-
Import Real-Time BambooHR Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use BambooHR data in ColdFusion.
-
How to Connect the Power BI Service to Google Cloud Storage: Complete Guide
Connect to the CData Software Power BI Connector for Google Cloud Storage from PowerBI.com to provide real-time Google Cloud Storage data across the organization.
-
Getting Started with the CData JDBC Driver for SendPulse
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SendPulse.