CData Software - Knowledge Base
Recent Articles
-
Query Oracle Eloqua Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle Eloqua data from Node.js.
-
Create Datasets from Google Campaign Manager 360 in Domo Workbench and Build Visualizations of Google Campaign Manager 360 Data in Domo
Use the CData Software ODBC Driver for Google Campaign Manager 360 to create datasets from Google Campaign Manager 360 data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Freshdesk Data from HeidiSQL
Use CData Connect AI to connect to and query live Freshdesk data from HeidiSQL.
-
Object-Relational Mapping (ORM) with Redshift Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Redshift data into a Java-based ORM framework, Hibernate.
-
Integrating Antigravity CLI with Samanage data via CData CLI
Connect Samanage data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Real-Time Bannerbear Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Bannerbear data in Power Apps.
-
View Reports on Real-Time Bullhorn CRM Data in Power BI Report Server
Use the CData ODBC Driver for Bullhorn CRM to visualize Bullhorn CRM data in Power BI Desktop and then publish them to Power BI Report Server.
-
DataBind Charts to Cosmos DB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Cosmos DB 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.
-
Stream Apollo Data into Apache Kafka Topics
Access and stream Apollo data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect and process Excel data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Excel data.
-
Visualize Pinecone Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Pinecone data into TIBCO Spotfire.
-
Operational Reporting on Bright Data Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Bright Data data.
-
Easily Integrate PingOne Data in Lazarus Pascal IDE
Learn how to easily integrate live PingOne data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live Guru Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Guru data from your Google Sheets.
-
Integrate OpenCode with Live QuickBooks Time Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live QuickBooks Time data from within your AI coding agent.
-
Create Dashboards and Visualize Live Apify Data in Geckoboard
Use CData Connect AI to connect to live Apify data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build DB2-Connected Apps in Choreo
Use CData Connect AI to connect to DB2 Data from Choreo and build custom apps using live DB2 data.
-
Use Claude to Talk to Your Azure DevOps 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 Azure DevOps data for you.
-
How to Connect to Bannerbear Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Bannerbear data. Leverage the pyodbc module for ODBC in Python.
-
Model, Search, and Visualize Live SAP Ariba Procurement Data in ThoughtSpot
Use CData Connect AI to connect to live SAP Ariba Procurement data for modeling, searching, and visualizing.
-
Automated Pinecone Data Replication to Teradata
Use CData Sync to Customize and automate Pinecone data replication to Teradata.
-
Create a Data Access Object for Browserless Data using JDBI
A brief overview of creating a SQL Object API for Browserless data in JDBI.
-
Connect to Zoho Creator from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zoho Creator to connect to Zoho Creator data from Web applications running on WebLogic.
-
Integrating LlamaIndex with Google Cloud Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Cloud Storage data in real time.
-
Connect Sage Cloud Accounting to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sage Cloud Accounting data using the CData Python MCP Server.
-
A PostgreSQL Interface for Greenhouse Data using the CData ODBC Driver
Use the SQL Gateway and Greenhouse ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build AI/ML Models with Live Phoenix Data using Dataiku
Connect Phoenix Data with Dataiku using the CData JDBC Driver for Phoenix.
-
Build Voice Agents in ElevenLabs with access to Live PingOne Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live PingOne data.
-
Import Real-Time Unbounce Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Unbounce data in ColdFusion.
-
Use Databricks Agent Bricks to Talk to Your QuickBooks Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your QuickBooks data for you.
-
Access Zoho Inventory Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zoho Inventory data from HeidiSQL.
-
Connect to MySQL Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MySQL data using standard SQL.
-
Access Salesforce Marketing 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 Salesforce Marketing data.
-
How to use SQLAlchemy ORM to access ChargeOver Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ChargeOver data.
-
Visualize Live YouTube Analytics Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live YouTube Analytics data.
-
Add ZohoMarketingHub Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ZohoMarketingHub with the Informatica Enterprise Data Catalog to classify and organize data.
-
Import and Visualize Pipedrive Data in Power View
Create data visualizations based on Pipedrive data in Excel.
-
Integrating OpenCode 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.
-
How to Connect to Office 365 Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Office 365 data. Leverage the pyodbc module for ODBC in Python.
-
Integrating GitHub Copilot with QuickBooks Online 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.
-
Build Visualizations of GitHub Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of GitHub data in Birst.
-
Process & Analyze Contentful Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Contentful Data.
-
Build Dashboards with Eventbrite Data in DBxtra
Create dynamic dashboards and perform analytics based on Eventbrite data in DBxtra.
-
Automated Continuous ConstantContact Replication to Vertica
Use CData Sync for automated, continuous, customizable ConstantContact replication to Vertica.
-
Connect to Short.io Data in Ruby
Connect to Short.io data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Extract, Transform, and Load Trello Data in Informatica PowerCenter
Create a simple Workflow for Trello data in Informatica PowerCenter.
-
Working with Rebilly Data in LINQPad
Execute LINQ queries to Rebilly data in LINQPad.
-
DataBind Charts to QuickBooks Online Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to QuickBooks Online 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.
-
Use the CData ODBC Driver for Pipeline CRM in Microsoft Power Query
You can use the CData Pipeline CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pipeline CRM data into Microsoft Power Query.
-
Import and Visualize CircleCI Data in Power View
Create data visualizations based on CircleCI data in Excel.
-
Create Data Visualizations in Cognos BI with Timely Data
Access Timely data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Query Apify Data in MySQL Workbench
Execute MySQL queries against live Apify data from MySQL Workbench.
-
Create Datasets from Bannerbear in Domo Workbench and Build Visualizations of Bannerbear Data in Domo
Use the CData Software ODBC Driver for Bannerbear to create datasets from Bannerbear data in Domo Workbench and then build visualizations in the Domo service.
-
Extract, Transform, and Load Microsoft Teams Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Teams data in Informatica PowerCenter.
-
Natively Connect to Cosmos DB Data in PHP
The CData ODBC driver for Cosmos DB enables you to create PHP applications with connectivity to Cosmos DB data. Leverage the native support for ODBC in PHP.
-
How to connect to Contentful Data in DBVisualizer
Integrate Contentful data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Jumpseller Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Jumpseller replication to Amazon Redshift.
-
Connect to CSV Data from PowerBuilder via JDBC
This article demonstrates how to access CSV data from PowerBuilder using the CSV JDBC Driver.
-
Integrate ActiveCampaign with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ActiveCampaign with External Services.
-
How to Connect to Live Mode Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Mode data for you.
-
Create Oracle Service Cloud Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle Service Cloud data access from reports, embedded analytics, and more.
-
Query LDAP Objects in DataGrip
Create a Data Source for LDAP in DataGrip and use SQL to query live LDAP objects.
-
Integrating Antigravity CLI with SAP HANA data via CData CLI
Connect SAP HANA data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Live Greenplum Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Greenplum data into custom reports in Power BI.
-
How to Access Live Outreach.io Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Outreach.io enables you to integrate Outreach.io data into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Excel Add-In for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Bullhorn CRM.
-
Use the CData Software JDBC Driver for Dynamics 365 in MicroStrategy Desktop
Connect to Dynamics 365 data in MicroStrategy Desktop using the CData Software JDBC Driver for Dynamics 365.
-
Visualize Square Data in Tableau
The CData ODBC driver for Square enables you integrate Square data into Tableau dashboards.
-
Build Data Flows from Google Campaign Manager 360 to SQL Server using SSIS
Easily back up Google Campaign Manager 360 data to SQL Server using the SSIS components for Google Campaign Manager 360.
-
Connect to Attio Data in CloverDX (formerly CloverETL)
Transfer Attio data using the visual workflow in the CloverDX data integration tool.
-
Connect to Redshift Data from a Connection Pool in Jetty
The Redshift JDBC Driver supports connection pooling: This article shows how to connect faster to Redshift data from Web apps in Jetty.
-
Integrating Claude Code CLI with SAP Hybris C4C 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 SSAS Tabular Models from Stack Exchange Data
How to build a SQL Server Analysis Service Tabular Model from Stack Exchange data using CData drivers.
-
Build Email-Connected Apps in Choreo
Use CData Connect AI to connect to Email Data from Choreo and build custom apps using live Email data.
-
A PostgreSQL Interface for SAP SuccessFactors LMS Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP SuccessFactors LMS JDBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the SAP BusinessObjects BI JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP BusinessObjects BI data.
-
How to Seamlessly Import Sentry Data into IBM SPSS Modeler
Integrate Sentry data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
DataBind Controls to Discourse Data in C++Builder
DataBind to Discourse data in C++Builder with standard components and controls.
-
Create Kafka-Connected Nintex Workflows
Use CData Connect AI to connect to Kafka Data from Nintex Workflow Cloud and build custom workflows using live Kafka data.
-
Use the CData ODBC Driver for Certinia from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Certinia to connect to Certinia data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Certinia data in Excel.
-
Getting Started with the CData Tableau Connector for DocuSign
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for DocuSign.
-
Build SQL Analysis Services-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SQL Analysis Services data and build SQL Analysis Services-connected web apps with Axios.
-
Create Act-On-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Act-On Data from Klipfolio and build custom visualizations using live Act-On data.
-
Connecting GenSpark with Sybase IQ Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Sybase IQ data without any replication or custom integration required.
-
Connect to Zoho Projects Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoho Projects data using standard SQL.
-
Getting Started with the CData Tableau Connector for Twilio
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Twilio.
-
Connect to Anaplan from a Connection Pool in WebLogic
Use the CData JDBC Driver for Anaplan to connect to Anaplan data from Web applications running on WebLogic.
-
Build Visualizations of Mode Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Mode data in Birst.
-
Bridge Amazon Athena Connectivity with Apache NiFi
Access and process Amazon Athena data in Apache NiFi using the CData JDBC Driver.
-
Integrating Boomi Agentstudio with Bright Data Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Bright Data data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData Software ODBC Driver for Avaza in MicroStrategy
Connect to Avaza data in MicroStrategy Developer using the CData Software ODBC Driver for Avaza.
-
Use the CData SSIS Components to Insert New or Update Existing Azure Table Records from SQL Server
Easily push SQL Server data to Azure Table using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Azure Table or update existing records with data from a SQL Server database.
-
Build Pipelines with Live Redis Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Redis from Google Cloud Data Fusion, enabling the integration of live Redis data into the building and management of effective data pipelines.
-
Create WordPress Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time WordPress data access from reports, embedded analytics, and more.
-
Use the CData Software ODBC Driver for FreshBooks in SAS for Real-Time Reporting and Analytics
Connect to real-time FreshBooks data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for FreshBooks.
-
Automated Continuous WordPress Replication to AlloyDB
Use CData Sync for automated, continuous, customizable WordPress replication to AlloyDB.
-
Model, Search, and Visualize Live MySQL Data in ThoughtSpot
Use CData Connect AI to connect to live MySQL data for modeling, searching, and visualizing.
-
How to connect SharePoint with Teradata Data through external lists
Provide Teradata data to SharePoint users as an external list.
-
How to Work with SendGrid Data in AWS Glue Jobs Using JDBC
Connect to SendGrid from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Creating HDFS-Connected Applications in Unqork
You can use CData Connect AI to feed HDFS data to Unqork and build custom business apps.