CData Software - Knowledge Base
Recent Articles
-
Easily Integrate Google Search Results in Lazarus Pascal IDE
Learn how to easily integrate live Google Search results in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to Live BambooHR Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your BambooHR data for you.
-
How to work with Excel Data in Apache Spark using SQL
Access and process Excel Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Front Replication to SingleStore
Use CData Sync for automated, continuous, customizable Front replication to SingleStore.
-
Use the CData ODBC Driver for Paddle in Microsoft Power Query
You can use the CData Paddle ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Paddle data into Microsoft Power Query.
-
Query Codat Data as a MySQL Database in Node.js
Execute MySQL queries against Codat data from Node.js.
-
Query Tavily Data in DataGrip
Create a Data Source for Tavily in DataGrip and use SQL to query live Tavily data.
-
Automated Continuous SendInBlue Replication to SingleStore
Use CData Sync for automated, continuous, customizable SendInBlue replication to SingleStore.
-
Excel Spreadsheet Automation on JobNimbus Data with the QUERY Formula
Pull data from JobNimbus, automate spreadsheets, and more with the QUERY formula.
-
Connect to Stripe Data in NetBeans
Connect to Stripe data in NetBeans with the data source configuration wizard.
-
Automated Continuous Float Replication to Snowflake
Use CData Sync for automated, continuous, customizable Float replication to Snowflake.
-
How to Build an ETL App for Google Spanner Data in Python with CData
Create ETL applications and real-time data pipelines for Google Spanner data in Python with petl.
-
Connect to Azure Synapse Data from HeidiSQL
Use CData Connect AI to connect to and query live Azure Synapse data from HeidiSQL.
-
Connect to FormSite Data in DBeaver
Use the CData ODBC Driver to connect to FormSite data in DBeaver.
-
Viewing Todoist Data in RAD Studio Data Explorer
How to view Todoist data in RAD Studio Data Explorer using the CData ODBC Driver for Todoist.
-
Building Dynamic Web Pages with Google Ad Manager Data Using AngularJS
Create single-page applications with live connectivity to Google Ad Manager using the CData API Server.
-
Query Azure Data Lake Storage Data as a SQL Server Database in Node.js
Execute SQL Server queries against Azure Data Lake Storage data from Node.js.
-
Replicate Multiple Accelo Accounts
Replicate multiple Accelo accounts to one or many databases.
-
Create Power BI Reports on Real-Time Sage 300 Data
Use the CData ODBC Driver for Sage 300 to visualize Sage 300 data in Power BI Desktop.
-
Create SSAS Tabular Models from Airtable Data
How to build a SQL Server Analysis Service Tabular Model from Airtable data using CData drivers.
-
Query CouchDB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume CouchDB entities in PHP by modeling them as objects.
-
Integrating GitHub Copilot with Retently 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 FreshBooks Data in Aqua Data Studio
Access FreshBooks data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build XML Visualizations in Tableau Cloud
Use CData Connect AI to connect to live XML data and build visualizations in Tableau Cloud.
-
Build SendPulse-Connected Apps in Choreo
Use CData Connect AI to connect to SendPulse Data from Choreo and build custom apps using live SendPulse data.
-
Connect to Salesloft 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 Salesloft data.
-
Operational Reporting on Klipfolio Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Klipfolio data.
-
Use Agno to Talk to Your LinkedIn 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 LinkedIn data for you.
-
Access Live Freshteam Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Freshteam data from your Excel spreadsheets.
-
Import Real-Time Azure Synapse Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Azure Synapse data in ColdFusion.
-
How to Create Power BI Visual Reports with Real-Time Lakebase Data
Use CData Power BI Connectors to visualize Lakebase data in Power BI.
-
Integrate Devin with Live ServiceNow Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live ServiceNow data.
-
Automated Continuous HCL Domino Replication to SQLite
Use CData Sync for automated, continuous, customizable HCL Domino replication to SQLite.
-
Use the CData Software JDBC Driver for Missive in MicroStrategy Web
Connect to Missive data in MicroStrategy Web using the CData Software JDBC Driver for Missive.
-
Moving Data from Lakebase to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Lakebase data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous SendPulse Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SendPulse replication to delimited files (CSV/TSV).
-
Create Power BI Reports on Real-Time Google Analytics Data
Use the CData ODBC Driver for Google Analytics to visualize Google Analytics data in Power BI Desktop.
-
Connect to BigQuery Data in DBeaver
Use the CData ODBC Driver to connect to BigQuery data in DBeaver.
-
Use the CData Software ODBC Driver for Salesforce CRM Analytics in MicroStrategy Desktop
Connect to Salesforce CRM Analytics data in MicroStrategy Desktop using the CData Software ODBC Driver for Salesforce CRM Analytics.
-
Getting Started with the CData ADO.NET Provider for Active Directory
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Active Directory.
-
Access Printify Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Printify data from HeidiSQL.
-
Automated Continuous Cassandra Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Cassandra replication to AlloyDB.
-
Getting Started with the CData SSIS Components for Bright Data
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bright Data.
-
Connect to Adobe Target Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Adobe Target.
-
Connect to Xero Data from a Connection Pool in Jetty
The Xero JDBC Driver supports connection pooling: This article shows how to connect faster to Xero data from Web apps in Jetty.
-
Connect to CockroachDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from CockroachDB data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Model AfterShip Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and AfterShip, enabling the direct import of real-time AfterShip data.
-
Integrate Cosmos DB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Cosmos DB with External Services.
-
Analyze Rebilly Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Rebilly data with the CData JDBC Driver for Rebilly.
-
Import and Visualize Trello Data in Power View
Create data visualizations based on Trello data in Excel.
-
Automated Continuous Webflow Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Webflow replication to AlloyDB.
-
How to Access HubSpot Data Using Entity Framework
This article shows how to access HubSpot data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Feed Procore Data into FineReport
How to set Procore data as a JDBC data source in FineReport.
-
How to Connect Flowise AI Agents to Live MongoDB Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live MongoDB data without replication.
-
Working with FreeAgent Data in LINQPad
Execute LINQ queries to FreeAgent data in LINQPad.
-
Create Apps from Campaigner Data in Qlik Sense Cloud
Use CData Connect AI to connect to Campaigner Data and build apps from live Campaigner data in Qlik Sense Cloud.
-
How to Connect to & Open GitHub Data in Microsoft Excel
This article uses the CData ODBC driver for GitHub to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData Software JDBC Driver for Procore in MicroStrategy
Connect to Procore data in MicroStrategy Developer using the CData Software JDBC Driver for Procore.
-
Build MVC Applications with Connectivity to IBM Informix Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access IBM Informix from an ASP.NET MVC application.
-
Operational Reporting on Brex Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Brex data.
-
Build Freshteam-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Freshteam data and build web apps with connectivity to live Freshteam data.
-
How to create an RPA flow for TigerGraph Data in UiPath Studio
Use the TigerGraph ODBC Driver to create workflows that access real-time TigerGraph data without any coding.
-
View Reports on Real-Time SendPulse Data in Power BI Report Server
Use the CData ODBC Driver for SendPulse to visualize SendPulse data in Power BI Desktop and then publish them to Power BI Report Server.
-
Analyze Zoho Projects Data in Cognos Analytics
Use CData Connect AI to connect to Zoho Projects Data from Cognos Analytics and analyze live Zoho Projects data.
-
Integrate Real-Time Access to LinkedIn in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to LinkedIn data in real time.
-
Integrate Live SAP ByDesign Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP ByDesign data to Blue Prism using the CData ODBC Driver for SAP ByDesign to create automated workflows for repetitive business tasks.
-
Analyze Lakebase Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Lakebase data and visualize live Lakebase data in Infragistics Reveal.
-
Integrate Devin with Live GraphQL Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live GraphQL data.
-
Automated Continuous SAP Business One Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Business One replication to SQL Server.
-
Choosing the Best Method to Connect Adobe Experience Manager to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Adobe Experience Manager data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Prepare, Blend, and Analyze FreshBooks Data in Alteryx Designer (ODBC)
Build workflows to access live FreshBooks data for self-service data analytics.
-
Work with Clockify Data in FoxPro
Load Clockify data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate OpenCode with Live Zuora Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Zuora data from within your AI coding agent.
-
Connect to Auth0 Data in DBArtisan
Use wizards in DBArtisan to configure Auth0 data as a data source.
-
Connect to and Visualize Live Sage 200 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage 200 data.
-
Create Dashboards and Visualize Live SparkPost Data in Geckoboard
Use CData Connect AI to connect to live SparkPost data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Load Spark Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Spark data to a database.
-
Access Dynamics 365 Business Central Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Dynamics 365 Business Central data from HeidiSQL.
-
Create Reports from Asana Data in Looker Studio
Use CData Connect AI to gain access to live Asana data and create custom reports in Looker Studio.
-
Automated Continuous Invoiced Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Invoiced replication to Google BigQuery.
-
Build Dashboards with eBay Data in Dundas BI
Create dynamic dashboards and perform analytics based on eBay data in Dundas BI.
-
Integrating GitHub Copilot with AfterShip 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.
-
Query Smartsheet Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Smartsheet entities in PHP by modeling them as objects.
-
Model Aweber Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Aweber, enabling the direct import of real-time Aweber data.
-
How to connect to Sage 300 Data from IntelliJ
Integrate connectivity to Sage 300 data with wizards in IntelliJ.
-
Access LightSpeedRetail Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access LightSpeedRetail data from your Oracle system.
-
Query Todoist Data as a MySQL Database in Node.js
Execute MySQL queries against Todoist data from Node.js.
-
Access GitHub Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live GitHub data from HeidiSQL.
-
Visualize HBase Data in Tableau
The CData ODBC driver for HBase enables you integrate HBase data into Tableau dashboards.
-
DataBind Controls to Onfleet Data in Delphi
DataBind to Onfleet data in Delphi with standard data access components and controls.
-
Extract, Transform, and Load Excel Data in Informatica PowerCenter
Create a simple Workflow for Excel data in Informatica PowerCenter.
-
Rapidly Develop Elasticsearch-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 Elasticsearch.
-
Integrate Live ShipEngine Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live ShipEngine data from within the IDE.
-
Visualize Live Avro Data in the Power BI Service
Use CData Connect AI to connect to live Avro data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Consume Google Spanner OData Feeds in PowerBuilder
This article demonstrates how to consume Google Spanner data as OData feeds from PowerBuilder using the API Server.
-
Access Klaviyo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Klaviyo data from your Oracle system.
-
Import and Visualize Sybase IQ Data in Power View
Create data visualizations based on Sybase IQ data in Excel.
-
Use ChatGPT to Talk to Your HDFS 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 HDFS data for you.
-
Easily Integrate Sage Intacct Data in Lazarus Pascal IDE
Learn how to easily integrate live Sage Intacct data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create a Data Access Object for Oracle Eloqua Reporting Data using JDBI
A brief overview of creating a SQL Object API for Oracle Eloqua Reporting data in JDBI.