CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Google Sheets Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Sheets securely in real time.
-
Connect to Salesforce Pardot Data in RazorSQL
Connect to Salesforce Pardot from wizards and query Salesforce Pardot from the GUI in the RazorSQL database management tool.
-
Automated Continuous Supabase Replication to SingleStore
Use CData Sync for automated, continuous, customizable Supabase replication to SingleStore.
-
ETL Freshdesk in Oracle Data Integrator
This article shows how to transfer Freshdesk into a data warehouse using Oracle Data Integrator.
-
How to connect and process RabbitMQ from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live RabbitMQ.
-
Integrate Cline with Live BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google BigQuery from within your IDE.
-
Getting Started with the CData Excel Add-In for Ontraport
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Ontraport.
-
Access Live Workday Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Workday through MCP integration.
-
Build a Simple VCL Application for Facebook Ads Data
How to build a simple VCL Application to view Facebook Ads in RAD Studio using the CData ODBC Driver for Facebook Ads.
-
Build Visualizations of Adobe Commerce Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Adobe Commerce in Birst.
-
Automate Short.io Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Short.io from PowerShell? This article demonstrates how to utilize the Short.io Cmdlets for tasks like connecting to Short.io, automating operations, downloading data, and more.
-
Natively Connect to ZohoPeople Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ZohoPeople. Leverage the native support for ODBC in PHP.
-
Create Informatica Mappings From/To an ODBC Data Source for Neo4J
Create an ODBC connection to Neo4J in Informatica and browse and transfer Neo4J.
-
Integrate Azure Synapse Data in the Pentaho Report Designer
Publish reports based on Azure Synapse in the Pentaho BI tool.
-
Natively Connect to Pinterest Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pinterest. Leverage the native support for ODBC in PHP.
-
Connect to Google Directory Data from PowerBuilder via JDBC
This article demonstrates how to access Google Directory from PowerBuilder using the Google Directory JDBC Driver.
-
How to Connect DBeaver to QuickBooks Time via a JDBC Driver
Manage QuickBooks Time with visual tools in DBeaver like the query browser.
-
Connect to SAP Business Warehouse Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Business Warehouse using standard SQL.
-
Use Azure AI Foundry to Talk to Your OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Microsoft OneNote for you.
-
Natively Connect to Twilio Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Twilio. Leverage the native support for ODBC in PHP.
-
Easily Integrate Tickspot Data in Lazarus Pascal IDE
Learn how to easily integrate live Tickspot in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live Jira Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Atlassian Jira through MCP integration.
-
Create Datasets from PayPal in Domo Workbench and Build Visualizations of PayPal Data in Domo
Use the CData Software ODBC Driver for PayPal to create datasets from PayPal in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software JDBC Driver for Invoiced in MicroStrategy Desktop
Connect to Invoiced in MicroStrategy Desktop using the CData Software JDBC Driver for Invoiced.
-
Connect to PolarTeamPro Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PolarTeamPro and the SQL Gateway to access PolarTeamPro from Google Apps Script.
-
Connect to Factorial Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Factorial and work with Factorial in your FileMaker application.
-
Integrate Live BenchmarkEmail Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live BenchmarkEmail to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate with live Azure Table Data in Jitterbit
Use CData Connect AI to connect to and integrate live Azure Table Storage in Jitterbit.
-
DataBind Controls to Google Cloud Storage Data in Delphi
DataBind to Google Cloud Storage in Delphi with standard data access components and controls.
-
Import Real-Time Helpscout Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Helpscout in ColdFusion.
-
Visualize Live Teamwork Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Teamwork.
-
How to update Lakebase from Excel
This article explains how to transfer data from Excel to Lakebase using the Excel Add-In for Lakebase.
-
Using the CData Software ODBC Driver for MailChimp in PyCharm
Connect to MailChimp as an ODBC data source in PyCharm using the CData Software ODBC Driver for MailChimp.
-
Build Agents in Relevance AI with Access to Live Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Workday within intelligent agent workflows.
-
Replicate Multiple Avaza Accounts
Replicate multiple Avaza accounts to one or many databases.
-
Build Semantic Layer Views for GitLab Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for GitLab.
-
Use the CData Software ODBC Driver for SAP SuccessFactors in MicroStrategy Web
Connect to SAP SuccessFactors in MicroStrategy Web using the CData Software ODBC Driver for SAP SuccessFactors.
-
Connect to Epicor Kinetic Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Epicor Kinetic Data and connect to Epicor Kinetic in Akorbi Digital RunMyProcess.
-
Use the CData Software JDBC Driver for Codat in MicroStrategy
Connect to Codat in MicroStrategy Developer using the CData Software JDBC Driver for Codat.
-
Integrate Simplesat with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Simplesat with External Services.
-
Provide OData Services of Timely Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Timely by developing a WCF Service Application.
-
Automated Continuous Salesforce Marketing Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Azure SQL Database.
-
Connect to CSV from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from CSV/TSV Files, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Agents in Relevance AI with Access to Live Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sage Business Cloud Accounting within intelligent agent workflows.
-
Integrating Access Data in Talend Cloud Data Management Platform
Connect Access Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Access.
-
Automate Recurly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Recurly from PowerShell? This article demonstrates how to utilize the Recurly Cmdlets for tasks like connecting to Recurly, automating operations, downloading data, and more.
-
How to Connect to & Open Confluence Data in Microsoft Excel
This article uses the CData ODBC driver for Confluence to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Blackbaud FE NXT Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Blackbaud FE NXT from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Query Live Pipedrive Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Pipedrive data in natural language using Python.
-
Build Qualaroo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Qualaroo and build web apps with connectivity to live Qualaroo.
-
Getting Started with the CData Python Connector for Insightly
Learn to install and license the CData Python Connector
-
How to connect and process Okta from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Okta.
-
Connect to Unbounce Data in JRuby
Create a simple JRuby app with access to live Unbounce.
-
Use the CData Software JDBC Driver for RabbitMQ in MicroStrategy
Connect to RabbitMQ in MicroStrategy Developer using the CData Software JDBC Driver for RabbitMQ.
-
Enable the Aircall JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Aircall.
-
Create Power BI Reports on Real-Time HCL Domino Data
Use the CData ODBC Driver for HCL Domino to visualize HCL Domino in Power BI Desktop.
-
Connect to Humanity Data in Ruby
Connect to Humanity in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Live Avalara AvaTax 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 Avalara AvaTax directly from the development environment.
-
How to connect to MessageBird Data in DBVisualizer
Integrate MessageBird with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect and Query Live CouchDB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Apache CouchDB into Databricks
-
Connect to Accelo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Accelo in the Denodo Virtual DataPort Administrator.
-
Automate ConstantContact Data Replication to Couchbase
Use CData Sync to Customize and automate ConstantContact replication to Couchbase.
-
Work with TigerGraph Data in FoxPro
Load TigerGraph into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Microsoft Planner Data in HULFT Integrate
Connect to Microsoft Planner as a JDBC data source in HULFT Integrate
-
Automate Amazon S3 Data Replication to Couchbase
Use CData Sync to Customize and automate Amazon S3 replication to Couchbase.
-
Stream IBM Cloud Object Storage Data into Apache Kafka Topics
Access and stream IBM Cloud Object Storage in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to create Oracle Service Cloud federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle Service Cloud in MySQL .
-
Process & Analyze Google Ads Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Ads Data.
-
View Reports on Real-Time Certinia Data in Power BI Report Server
Use the CData ODBC Driver for Certinia to visualize Certinia in Power BI Desktop and then publish them to Power BI Report Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Apollo
Provide connectivity to Apollo through an SAP BusinessObjects universe.
-
Build Apps with Live Basecamp in Adalo using CData Connect AI
Use CData Connect AI to integrate live Basecamp into the Adalo platform and build custom mobile and web applications with real-time Basecamp.
-
How to Connect to Live Workday 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 Workday for you.
-
How to use SQLAlchemy ORM to access Dynamics CRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Dynamics CRM.
-
Automated Continuous Mouseflow Replication to SingleStore
Use CData Sync for automated, continuous, customizable Mouseflow replication to SingleStore.
-
Operational Reporting on Amazon Athena Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Amazon Athena.
-
Automated Continuous SendInBlue Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SendInBlue replication to delimited files (CSV/TSV).
-
Create Confluence-Connected Nintex Workflows
Use CData Connect AI to connect to Confluence Data from Nintex Workflow Cloud and build custom workflows using live Atlassian Confluence.
-
Connecting Moonlit Workflow with Redshift 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 Amazon Redshift in real time.
-
How to use SQLAlchemy ORM to access Campaigner Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Campaigner.
-
Create PingOne Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PingOne data access from reports, embedded analytics, and more.
-
Edit and Search Oracle External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Oracle Database to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Oracle objects that you can access from apps and the dashboard.
-
Getting Started with the CData JDBC Driver for Zoho Recruit
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zoho Recruit.
-
Create Dynamic Wave Financial Grids Using the Infragistics XamDataGrid
Learn how you can connect Wave Financial to Infragistics XamDataGrid to build dynamic grids.
-
Write a Simple Go Application to work with Mistral AI Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mistral AI.
-
Presto Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Presto facts in real time.
-
Connect and Query Live API Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live API into Databricks
-
Connect to OnePageCrm Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time OnePageCrm using standard SQL.
-
How to Connect the Power BI Service to Oracle Financials Cloud: Complete Guide
Connect to the CData Software Power BI Connector for Oracle Financials Cloud from PowerBI.com to provide real-time Oracle Financials Cloud across the organization.
-
Access Live IBM Cloud Object Storage Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live IBM Cloud Object Storage data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Jira Assets-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Jira Assets and build Jira Assets-connected web apps with Axios.
-
Import Real-Time eBay Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use eBay in ColdFusion.
-
Query Teradata Data in ColdFusion
Write standard ColdFusion data access code to connect to Teradata.
-
Todoist Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Todoist facts in real time.
-
How to work with Amazon S3 Data in Apache Spark using SQL
Access and process Amazon S3 Data in Apache Spark using the CData Software JDBC Driver.
-
Create Apps from OData Services in Qlik Sense Cloud
Use CData Connect AI to connect to OData Services and build apps from live OData in Qlik Sense Cloud.
-
Build Visualizations of Teradata Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Teradata in Birst.
-
Integrating GitHub Copilot CLI with PDFMonkey 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 SSAS Tabular Models from Presto Data
How to build a SQL Server Analysis Service Tabular Model from Presto using CData drivers.
-
Connect to Sybase from Asprova with CData Software ODBC Driver for Sybase
This article shows how to connect faster to Sybase data from Asprova.
-
How to Connect Azure Synapse Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Azure Synapse data in real time using natural language.