CData Software - Knowledge Base
Recent Articles
-
Feed Microsoft Teams Data into FineReport
How to set Microsoft Teams data as a JDBC data source in FineReport.
-
How to use SQLAlchemy ORM to access Sybase IQ Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sybase IQ data.
-
Integrate Vertica Data into Power Automate Desktop using CData Connect
CData Connect for Vertica Data enables you to integrate Vertica data into workflows built using Microsoft Power Automate Desktop.
-
Replicate ZendeskSell Data to Multiple Databases via the CData Sync CLI
Replicate ZendeskSell data to disparate databases with a single configuration.
-
Integrate Opsgenie with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Opsgenie with External Services.
-
Create Apps from SAP HANA XS Advanced Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP HANA XS Advanced Data and build apps from live SAP HANA XS Advanced data in Qlik Sense Cloud.
-
Replicate Multiple Amplitude Accounts via the CData Sync CLI
Replicate multiple Amplitude accounts to one or many databases.
-
How to connect to TaxJar Data in DBVisualizer
Integrate TaxJar data with visual data analysis tools and data connection wizards in DBVisualizer
-
Excel Spreadsheet Automation on Harvest Data with the QUERY Formula
Pull data from Harvest, automate spreadsheets, and more with the QUERY formula.
-
Connect to Oracle Eloqua Reporting Data in JRuby
Create a simple JRuby app with access to live Oracle Eloqua Reporting data.
-
Connect to Act-On Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Act-On data using standard SQL.
-
Build Workable-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Workable data.
-
Integrating Kiro with RSS Feeds 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.
-
Use Dash to Build to Web Apps on Access Data
Create Python applications that use pandas and Dash to build Access-connected web apps.
-
Integrate with live Tavily Data in Jitterbit
Use CData Connect AI to connect to and integrate live Tavily data in Jitterbit.
-
Salesforce Pardot Reporting in OBIEE with the Salesforce Pardot JDBC Driver
Deploy the Salesforce Pardot JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Live SAP HANA Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP HANA data securely in real time.
-
Create Apps from AfterShip Data in Qlik Sense Cloud
Use CData Connect AI to connect to AfterShip Data and build apps from live AfterShip data in Qlik Sense Cloud.
-
Connect to Vault CRM Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Vault CRM to connect to Vault CRM data and execute queries in PowerBuilder.
-
Build Data Flows from Sage 200 to SQL Server using SSIS
Easily back up Sage 200 data to SQL Server using the SSIS components for Sage 200.
-
Build MongoDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MongoDB data.
-
How to create an RPA flow for Vimeo Data in UiPath Studio
Use the Vimeo ODBC Driver to create workflows that access real-time Vimeo data without any coding.
-
Use Azure AI Foundry to Talk to Your eBay Analytics 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 eBay Analytics data for you.
-
Build Avalara AvaTax-Connected Apps in Choreo
Use CData Connect AI to connect to Avalara AvaTax Data from Choreo and build custom apps using live Avalara AvaTax data.
-
How to Query Live Strava Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Strava data data in natural language using Python.
-
Import AgileCRM Data Using Azure Data Factory
Use CData Connect AI to connect to AgileCRM Data from Azure Data Factory and import live AgileCRM data.
-
Integrating OpenCode with Google Search results 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.
-
Integrating Codex with Amazon Athena 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 and Visualize Live Placid Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Placid data.
-
Build Apps with Live MailChimp data in Adalo using CData Connect AI
Use CData Connect AI to integrate live MailChimp data into the Adalo platform and build custom mobile and web applications with real-time MailChimp data.
-
Connect to Missive Data in NetBeans
Connect to Missive data in NetBeans with the data source configuration wizard.
-
DataBind Controls to Discourse Data in Delphi
DataBind to Discourse data in Delphi with standard data access components and controls.
-
Import Real-Time SAP Business One Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP Business One data in ColdFusion.
-
Query BigQuery Data through ODBC in Node.js
Use node-odbc to execute SQL queries against BigQuery data from Node.js.
-
Integrating SageHR Data in Talend Cloud Data Management Platform
Connect SageHR Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Import Real-Time Google Calendar Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Calendar data in ColdFusion.
-
Integrating Codex with SAP Business One 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.
-
Access Live Monday.com Data in Coginiti Pro
Connect to and query live Monday.com data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build AI/ML Models with Live SAP Business Warehouse Data using Dataiku
Connect SAP Business Warehouse Data with Dataiku using the CData JDBC Driver for SAP Business Warehouse.
-
How to Query Live Codat Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Codat data data in natural language using Python.
-
Design BIRT Reports on Gorgias Data
Provide current Gorgias data to your embedded analytics.
-
How to connect and process Planio data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Planio data.
-
Integrating Boomi Agentstudio with Exa Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Exa data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrating Cursor with Telegram 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.
-
Access Live ZohoInvoice 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 ZohoInvoice data through MCP integration.
-
LINQ to Brex Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Brex Data Provider.
-
Rapidly Develop Confluence-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 Confluence.
-
Replicate ZohoMarketingHub Data from PowerShell
Write a quick PowerShell script to query ZohoMarketingHub data. Use connectivity to the live data to replicate ZohoMarketingHub data to SQL Server.
-
Use the CData Software ODBC Driver for Zuora in SAS for Real-Time Reporting and Analytics
Connect to real-time Zuora data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zuora.
-
Analyze Raisers Edge NXT Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Raisers Edge NXT data and visualize Raisers Edge NXT data in SAP Analytics Cloud.
-
How to import xBase Data into Apache Solr
Use the CData Software JDBC Driver for xBase in Data Import Handler and create an automated import of xBase data to Apache Solr Enterprise Search platform.
-
How to Connect DBeaver to Teradata via a JDBC Driver
Manage Teradata data with visual tools in DBeaver like the query browser.
-
Automated Continuous GitLab Replication to AlloyDB
Use CData Sync for automated, continuous, customizable GitLab replication to AlloyDB.
-
Connect to Live GraphQL Data in PostGresSQL Interface through CData Connect AI
Create a live connection to GraphQL in CData Connect AI and connect to your GraphQL data from PostgreSQL.
-
Create Amazon DynamoDB-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Amazon DynamoDB Data from Klipfolio and build custom visualizations using live Amazon DynamoDB data.
-
Getting Started with the CData Excel Add-In for Instagram
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Instagram.
-
Integrate Live Azure DevOps Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Azure DevOps data to Blue Prism using the CData ODBC Driver for Azure DevOps to create automated workflows for repetitive business tasks.
-
A PostgreSQL Interface for Reckon Data (MySQL Remoting via JDBC)
Use the Remoting features of the Reckon JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Freshteam Data from a Connection Pool in JBoss
Integrate Freshteam data into Java servlets: Use the Management Console in JBoss to install the Freshteam JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for PostgreSQL
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for PostgreSQL.
-
Migrating data from Scrapfly to Google BigQuery using CData SSIS Components.
Easily push Scrapfly data to Google BigQuery using the CData SSIS Tasks for Scrapfly and Google BigQuery.
-
Manage Azure Data Catalog Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Azure Data Catalog.
-
Analyze Live HDFS Data in SAS Viya
Use CData Connect AI to connect to HDFS data from SAS Viya and deploy self-service analytics using live HDFS data.
-
Seamlessly Bring SAP Business Warehouse Data into Retool Using CData Connect AI
Integrate SAP Business Warehouse data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate EmailOctopus Data in the Pentaho Report Designer
Publish reports based on EmailOctopus data in the Pentaho BI tool.
-
Integrate with YouTube Analytics Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy YouTube Analytics data to a JSON file on disk.
-
Extract, Transform, and Load PDFMonkey Data in Informatica PowerCenter
Create a simple Workflow for PDFMonkey data in Informatica PowerCenter.
-
Connect to PingOne 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 PingOne data.
-
Connect to SAP Hybris C4C Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP Hybris C4C Data and connect to SAP Hybris C4C data in Akorbi Digital RunMyProcess.
-
Establish a Live Connection with ClickUp Data using Tableau Bridge
The CData ODBC Driver for ClickUp enables you to integrate live ClickUp data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to import Factorial Data into Apache Solr
Use the CData Software JDBC Driver for Factorial in Data Import Handler and create an automated import of Factorial data to Apache Solr Enterprise Search platform.
-
Connect to Okta Data in Jaspersoft Studio
Execute SQL to remote Okta data in Jaspersoft Studio.
-
Build Klipfolio-Connected Apps in Choreo
Use CData Connect AI to connect to Klipfolio Data from Choreo and build custom apps using live Klipfolio data.
-
Getting Started with the CData Excel Add-In for Bannerbear
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Bannerbear.
-
Access Live Pipeline CRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Pipeline CRM data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Mailgun Data from a Connection Pool in JBoss
Integrate Mailgun data into Java servlets: Use the Management Console in JBoss to install the Mailgun JDBC Driver.
-
Access Live Sybase Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Sybase data from your Excel spreadsheets.
-
Use Agno to Talk to Your Adobe Target 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 Adobe Target data for you.
-
Integrating Claude Code CLI with Zoom 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.
-
Integrating Cursor with Adobe Target 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 JDBC Driver for Vercel
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Vercel.
-
Establish a Live Connection with CSV Data using Tableau Bridge
The CData ODBC Driver for CSV enables you to integrate live CSV data into Tableau Cloud dashboards using the Tableau Bridge.
-
Access OnePageCrm Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for OnePageCrm data.
-
Build Oracle Sales-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 Oracle Sales data without replication.
-
How to connect to ClickUp Data in DBVisualizer
Integrate ClickUp data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live Okta Data in Excel 365 Online (Excel for the web)
Connect to Okta data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Prepare, Blend, and Analyze Demio Data in Alteryx Designer (ODBC)
Build workflows to access live Demio data for self-service data analytics.
-
Use the CData ODBC Driver for Apollo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Apollo to connect to Apollo data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apollo data in Excel.
-
How to load SAP data into Elasticsearch via Logstash
Introducing a simple method to load SAP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to eBay Analytics Data from Crystal Reports
Use CData Connect AI to connect to and report on live eBay Analytics data from Crystal Reports.
-
Integrating Antigravity CLI with Unbounce data via CData CLI
Connect Unbounce data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous ZohoInvoice Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to PostgreSQL.
-
Integrating Claude Code CLI with Telegram 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.
-
Viewing Google Sheets Data in RAD Studio Data Explorer
How to view Google Sheets data in RAD Studio Data Explorer using the CData ODBC Driver for Google Sheets.
-
Publish Crystal Reports on Invoiced Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Invoiced data.
-
Automated Continuous SAP Fieldglass Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to MySQL.
-
Excel Spreadsheet Automation on Avalara AvaTax Data with the QUERY Formula
Pull data from Avalara AvaTax, automate spreadsheets, and more with the QUERY formula.
-
Import Real-Time MessageBird Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use MessageBird data in ColdFusion.
-
Import and Visualize Teamwork Data in Power View
Create data visualizations based on Teamwork data in Excel.
-
Integrating Codex with LDAP objects 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.