CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for ZeroBounce in MicroStrategy
Connect to ZeroBounce in MicroStrategy Developer using the CData Software JDBC Driver for ZeroBounce.
-
Connect to Float from Asprova with CData Software ODBC Driver for Float
This article shows how to connect faster to Float data from Asprova.
-
Use the CData Software JDBC Driver for Moosend in MicroStrategy
Connect to Moosend in MicroStrategy Developer using the CData Software JDBC Driver for Moosend.
-
Build Dashboards with Landbot Data in DBxtra
Create dynamic dashboards and perform analytics based on Landbot in DBxtra.
-
Create SSAS Tabular Models from Zoho CRM Data
How to build a SQL Server Analysis Service Tabular Model from Zoho CRM using CData drivers.
-
Access QuickBooks Company File Data from DBeaver
Use the CData JDBC Driver for QuickBooks to access QuickBooks as a JDBC data source through the DBeaver connection manager.
-
Integrate Adobe Experience Manager Data in Pentaho Data Integration
Build ETL pipelines based on Adobe Experience Manager in the Pentaho Data Integration tool.
-
Build Data Flows from Google Translate to SQL Server using SSIS
Easily back up Google Translate to SQL Server using the SSIS components for Google Translate.
-
How to Query Live ChartMogul Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ChartMogul data in natural language using Python.
-
Build AI/ML Models with Live Amazon Athena Data using Dataiku
Connect Amazon Athena Data with Dataiku using the CData JDBC Driver for Amazon Athena.
-
Access Live WordPress Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live WordPress data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Publish Discord-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Discord.
-
How to Build an ETL App for Odoo Data in Python with CData
Create ETL applications and real-time data pipelines for Odoo ERP in Python with petl.
-
Create Mode Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Mode from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create SAP Business One Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Business One data access from reports, embedded analytics, and more.
-
Integrating OpenCode Terminal with Close 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.
-
Use the CData API Server to Access HDFS Data in Microsoft PowerPivot
Use the CData API Server to connect to live Apache HDFS in the Power Pivot business intelligence tool.
-
Create Informatica Mappings From/To a JDBC Data Source for Outreach.io
Create Outreach.io data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Theia IDE with Live Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Natively Connect to SendGrid Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SendGrid. Leverage the native support for ODBC in PHP.
-
Publish Crystal Reports on Apollo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apollo.
-
Easily Integrate HBase Data in Lazarus Pascal IDE
Learn how to easily integrate live Apache HBase in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Campaigner Data in Tableau
The CData ODBC driver for Campaigner enables you integrate Campaigner into Tableau dashboards.
-
Connect to Missive Data from a Connection Pool in Jetty
The Missive JDBC Driver supports connection pooling: This article shows how to connect faster to Missive from Web apps in Jetty.
-
How to connect and process Jodoo from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Jodoo.
-
How to Connect to SuiteCRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SuiteCRM. Leverage the pyodbc module for ODBC in Python.
-
How to Query Live HDFS Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apache HDFS data in natural language using Python.
-
Build Data Flows from Gorgias to SQL Server using SSIS
Easily back up Gorgias to SQL Server using the SSIS components for Gorgias.
-
Rapidly Develop Planio-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 Planio.
-
How to Easily Query SAP Data in OpenOffice Base
Connect to SAP data in OpenOffice Base using the CData ODBC Driver for SAP ERP and generate reports with live data insights.
-
Integrating Claude Code CLI with EmailOctopus 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 MySQL Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for MySQL Data and connect to MySQL in Akorbi Digital RunMyProcess.
-
A PostgreSQL Interface for Perigon Data using the CData ODBC Driver
Use the SQL Gateway and Perigon ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous CData Connect AI Replication to SQL Server
Use CData Sync for automated, continuous, customizable CData Connect AI replication to SQL Server.
-
Replicate WordPress Data from PowerShell
Write a quick PowerShell script to query WordPress. Use connectivity to the live data to replicate WordPress to SQL Server.
-
How to use SQLAlchemy ORM to access Egnyte Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Egnyte.
-
Import Real-Time Google Ads Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Ads in ColdFusion.
-
Excel Spreadsheet Automation on Dynamics CRM Data with the QUERY Formula
Pull data from Dynamics CRM, automate spreadsheets, and more with the QUERY formula.
-
Automated MongoDB Data Replication to Teradata
Use CData Sync to Customize and automate MongoDB replication to Teradata.
-
Connect to PostgreSQL Data in JRuby
Create a simple JRuby app with access to live PostgreSQL.
-
Stream LionDesk Data into Apache Kafka Topics
Access and stream LionDesk in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Moving Data from Front to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Front data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to integrate Metabase with SAS Data Sets Data
Use CData Connect AI to connect to live SAS Data Sets and create an interactive dashboard in Metabase from SAS Data Sets.
-
Query AgileCRM Data in DataGrip
Create a Data Source for AgileCRM in DataGrip and use SQL to query live AgileCRM.
-
Access MongoDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MongoDB from your Oracle system.
-
Create SAP Concur-Connected Business Apps in AppSheet
Connect to SAP Concur Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP Concur.
-
Explore Geographical Relationships in EnterpriseDB Data with Power Map
Create data visualizations with EnterpriseDB in Power Map.
-
Build Agents in Relevance AI with Access to Live Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Acumatica ERP within intelligent agent workflows.
-
How to Work with Phoenix Data in AWS Glue Jobs Using JDBC
Connect to Phoenix from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Claude to Talk to Your Redshift 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 Amazon Redshift for you.
-
Use the CData Software ODBC Driver for Basecamp in MicroStrategy
Connect to Basecamp in MicroStrategy Developer using the CData Software ODBC Driver for Basecamp.
-
Feed RSS Feeds into FineReport
How to set RSS Feeds as a JDBC data source in FineReport.
-
Visualize Email 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 Email into TIBCO Spotfire.
-
Create Square Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Square from PowerBI.com to create Power BI Dataflows with real-time data.
-
EmailOctopus Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on EmailOctopus facts in real time.
-
How to Build an ETL App for Klipfolio Data in Python with CData
Create ETL applications and real-time data pipelines for Klipfolio in Python with petl.
-
Working with Zoho CRM Data in LINQPad
Execute LINQ queries to Zoho CRM in LINQPad.
-
Query HubSpot Data from Node.js
Use the OData endpoint of the CData API Server to connect to your HubSpot and perform CRUD operations on HubSpot from Node.js.
-
How to Work with xBase Data in AWS Glue Jobs Using JDBC
Connect to xBase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData ADO.NET Provider for GitLab
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build a Singer.io Tap for Clockify With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Clockify data using
-
Getting Started with the CData Tableau Connector for SAP SuccessFactors
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP SuccessFactors.
-
Connect to Hacker News Data in RazorSQL
Connect to Hacker News from wizards and query Hacker News from the GUI in the RazorSQL database management tool.
-
Query Timely Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Timely from Node.js.
-
DataBind Controls to eBay Data in C++Builder
DataBind to eBay in C++Builder with standard components and controls.
-
Use the CData Software JDBC Driver for QuickBooks in MicroStrategy Web
Connect to QuickBooks Desktop in MicroStrategy Web using the CData Software JDBC Driver for QuickBooks.
-
How to Work with XML Data in ETL Validator JDBC
Connect to XML from ETL Validator jobs using the CData Software JDBC Driver.
-
How to create an RPA flow for Unbounce Data in UiPath Studio
Use the Unbounce ODBC Driver to create workflows that access real-time Unbounce without any coding.
-
Visualize JotForm Data in Tableau
The CData ODBC driver for JotForm enables you integrate JotForm into Tableau dashboards.
-
Getting Started with the CData Excel Add-In for Amazon Marketplace
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Amazon Marketplace.
-
Microsoft Teams Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Teams through CData Connect AI using different applications and tools.
-
Integrating Cursor CLI with HubDB 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 Everhour 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 Everhour.
-
How to create Epicor Kinetic federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Epicor Kinetic in MySQL .
-
Integrating LangGraph with LinkedIn Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on LinkedIn within automated workflows.
-
Connect Slack to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Slack with IBM WebSphere for seamless data integration and connectivity.
-
Build Data Flows from SQL Server to Microsoft Planner through SSIS
Easily push SQL Server data to Microsoft Planner using the CData SSIS Tasks for Microsoft Planner.
-
Viewing Intercom Data in RAD Studio Data Explorer
How to view Intercom in RAD Studio Data Explorer using the CData ODBC Driver for Intercom.
-
How to load Supabase data into Elasticsearch via Logstash
Introducing a simple method to load Supabase data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Publish GraphQL-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live GraphQL.
-
Connect to Recurly Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Recurly and the SQL Gateway to access Recurly from Google Apps Script.
-
Create a Data Access Object for Aircall Data using JDBI
A brief overview of creating a SQL Object API for Aircall in JDBI.
-
Connect to Bannerbear Data in RapidMiner
Integrate Bannerbear with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Sage 300 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Sage 300 replication to Azure SQL Database.
-
Build Apps with Live Mailjet Data Using the Low-Code Development Platform of Mendix
Connect Mailjet with Mendix to build apps using the CData API Driver for JDBC.
-
Build Redshift-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Amazon Redshift to explore live Redshift Data in Claude Code to assist with building Redshift-powered applications.
-
Automate Humanity Data Replication to SAP HANA
Use CData Sync to customize and automate Humanity replication to SAP HANA.
-
Integrating Claude Code with CockroachDB Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on CockroachDB within assisted coding and automated development workflows.
-
Object-Relational Mapping (ORM) with AlloyDB 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 Google AlloyDB into a Java-based ORM framework, Hibernate.
-
Connect to Adobe Target Data from a Connection Pool in JBoss
Integrate Adobe Target into Java servlets: Use the Management Console in JBoss to install the Adobe Target JDBC Driver.
-
Connect to Bullhorn CRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Bullhorn CRM from Filemaker Pro on Mac.
-
How to create an RPA flow for Short.io Data in UiPath Studio
Use the Short.io ODBC Driver to create workflows that access real-time Short.io without any coding.
-
Integrate PostgreSQL Data in Pentaho Data Integration
Build ETL pipelines based on PostgreSQL in the Pentaho Data Integration tool.
-
Connect to Google Calendar Data in DBArtisan
Use wizards in DBArtisan to configure Google Calendar as a data source.
-
Feed Planio Data into FineReport
How to set Planio as a JDBC data source in FineReport.
-
Integrate Delighted with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Delighted with External Services.
-
Import Google Drive Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Drive Data and provide access to live Google Drive for custom reports in the Power BI Service.
-
Connect to LDAP Objects in Aqua Data Studio
Access LDAP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Import Data from Parquet into Google Sheets
Import Apache Parquet into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous HDFS Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable HDFS replication to Google BigQuery.