CData Software - Knowledge Base
Recent Articles
-
How to Build an ETL App for Amazon S3 Data in Python with CData
Create ETL applications and real-time data pipelines for Amazon S3 in Python with petl.
-
Prepare, Blend, and Analyze Jodoo Data in Alteryx Designer (ODBC)
Build workflows to access live Jodoo for self-service data analytics.
-
Access Live Customer.io Data in AWS Lambda
Connect to live Customer.io in AWS Lambda using the CData JDBC Driver.
-
Integrating Printify Data in Talend Cloud Data Management Platform
Connect Printify Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize Live Workday Data in the Power BI Service
Use CData Connect AI to connect to live Workday and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Jodoo Data in Pentaho Data Integration
Build ETL pipelines based on Jodoo in the Pentaho Data Integration tool.
-
Visualize Microsoft Exchange Data in TIBCO Spotfire through OData
Integrate Microsoft Exchange into dashboards in TIBCO Spotfire.
-
Prepare, Blend, and Analyze Zoho Projects Data in Alteryx Designer (Connect AI)
Build workflows to access live Zoho Projects for self-service data analytics.
-
Automated Continuous Jira Assets Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Jira Assets replication to Azure SQL Database.
-
Design BIRT Reports on SAP Netweaver Gateway Data
Provide current SAP Netweaver Gateway to your embedded analytics.
-
Getting Started with the CData Excel Add-In for SuiteCRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SuiteCRM.
-
Visualize HubDB Data in Sisense
Create an ElastiCube in Sisense app with access to HubDB.
-
Use the CData Software ODBC Driver for Elorus in MicroStrategy Web
Connect to Elorus in MicroStrategy Web using the CData Software ODBC Driver for Elorus.
-
Connect to Sage 300 Data in NetBeans
Connect to Sage 300 in NetBeans with the data source configuration wizard.
-
Explore Geographical Relationships in Paddle Data with Power Map
Create data visualizations with Paddle in Power Map.
-
Migrating data from Nethunt to Databricks using CData SSIS Components.
Easily push Nethunt to Databricks using the CData SSIS Tasks for Nethunt and Databricks.
-
Getting Started with the CData JDBC Driver for SAP Fieldglass
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Fieldglass.
-
Automated Continuous Intercom Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Intercom replication to Amazon Redshift.
-
Getting Started with the CData Connect AI Python SDK for Azure Synapse
Install the CData Connect AI Python SDK to read and write live Azure Synapse with standard DB-API 2.0 Python code.
-
Connect to Oracle Eloqua Data from a Connection Pool in Jetty
The Oracle Eloqua JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle Eloqua from Web apps in Jetty.
-
Replicate FormSite Data from PowerShell
Write a quick PowerShell script to query FormSite. Use connectivity to the live data to replicate FormSite to SQL Server.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Oracle Sales to Power BI dashboards. Simply drag and drop Oracle Sales into data visuals on the Power BI canvas.
-
Integrating Cursor CLI with Google Spanner 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 Software ODBC Driver for NASA in MicroStrategy Web
Connect to NASA in MicroStrategy Web using the CData Software ODBC Driver for NASA.
-
Process & Analyze WordPress Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live WordPress Data.
-
How to Connect to Live HubSpot Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your HubSpot for you.
-
Access Live Amplitude Data in AWS Lambda
Connect to live Amplitude in AWS Lambda using the CData JDBC Driver.
-
Build Semantic Layer Views for Autopilot Data in APOS Live Data Gateway
Use the CData Connector for Autopilot in APOS Live Data Gateway to build Semantic Layer Views for Autopilot.
-
Integrate Live BigCommerce Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Connect to Live Apollo Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Apollo securely in real time.
-
How to integrate SAP Netweaver Gateway with Apache Airflow
Access and process SAP Netweaver Gateway in Apache Airflow using the CData JDBC Driver.
-
Integrate Live NetSuite Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to NetSuite from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live NetSuite CRM & ERP.
-
Build Google Spanner-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Google Spanner to explore live Google Spanner Data in Gemini Code Assist to assist with building Google Spanner-powered applications.
-
How to Easily Query Qualaroo Data in OpenOffice Base
Connect to Qualaroo data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Getting Started with the CData Tableau Connector for LionDesk
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Confluence-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Atlassian Confluence and build web apps with connectivity to live Atlassian Confluence.
-
How to connect and process Pinterest from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pinterest.
-
How to Build an ETL App for SingleStore Data in Python with CData Connect AI
Build ETL pipelines that read and write live SingleStore in Python with petl and the CData Connect AI Python SDK.
-
Connect to Avaza Data in Ruby
Connect to Avaza in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Sugar CRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Sugar CRM and the SQL Gateway to access Sugar CRM from Google Apps Script.
-
Use the CData Software ODBC Driver for Aircall in MicroStrategy
Connect to Aircall in MicroStrategy Developer using the CData Software ODBC Driver for Aircall.
-
Replicate Multiple Flowlu Accounts via the CData Sync CLI
Replicate multiple Flowlu accounts to one or many databases.
-
How to connect and process Helpscout from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Helpscout.
-
Use the CData Software JDBC Driver for Tavily in MicroStrategy
Connect to Tavily in MicroStrategy Developer using the CData Software JDBC Driver for Tavily.
-
How to Connect to Live Oracle HCM Cloud Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Oracle HCM Cloud for you.
-
Work with Reckon Accounts Hosted Data in FoxPro
Load Reckon Accounts Hosted into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Greenhouse Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Greenhouse from Node.js.
-
Write a Simple Go Application to work with Freshsales Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Freshsales.
-
Query Gong Data in ColdFusion
Write standard ColdFusion data access code to connect to Gong.
-
Integrating Claude Code CLI with Delighted 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 VWO in SpagoBI
Create reports featuring live VWO in SpagoBI Studio. Host VWO reports on SpagoBI Server.
-
How to Connect the Power BI Service to Parallel: Complete Guide
Connect to the CData Software Power BI Connector for Parallel from PowerBI.com to provide real-time Parallel across the organization.
-
Access Grafana Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Grafana from your Oracle system.
-
Configure the CData JDBC Driver for ZohoPeople in a Connection Pool in Tomcat
Connect to ZohoPeople from a connection pool in Tomcat.
-
Access Live SuiteCRM Data in Coginiti Pro
Connect to and query live SuiteCRM from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Attio Replication to MongoDB
Use CData Sync for automated, continuous, customizable Attio replication to MongoDB.
-
DataBind Controls to Blackbaud FE NXT Data in C++Builder
DataBind to Blackbaud FE NXT in C++Builder with standard components and controls.
-
Model, Search, and Visualize Live Google Ads Data in ThoughtSpot
Use CData Connect AI to connect to live Google Ads for modeling, searching, and visualizing.
-
Connect to Live Google Directory Data in MicroStrategy through CData Connect AI
Create a live connection to Google Directory Data in CData Connect AI and connect to your Google Directory from MicroStrategy.
-
How to Connect to Live Zoho CRM Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Zoho CRM for you.
-
How to connect PolyBase to Freshdesk
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Freshdesk.
-
Import Real-Time Oracle Eloqua Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle Eloqua in ColdFusion.
-
Access Live SAP ByDesign Data in Coginiti Pro
Connect to and query live SAP Business ByDesign from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Office 365 Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Office 365 replication to OneLake in Microsoft Fabric.
-
Integrating Codex CLI with Freshteam 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.
-
Automate GraphQL Data Replication to Azure Data Lake
Use CData Sync to customize and automate GraphQL replication to Azure Data Lake.
-
How to create Visio diagrams from Instagram Data
Automatically update Instagram with the changes you make to Visio master shapes.
-
Automated Continuous Parquet Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Parquet replication to IBM DB2.
-
DataBind Charts to Sentry Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sentry 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.
-
Query Live Airtable 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 Airtable directly from the development environment.
-
Analyze Dotmailer Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Dotmailer in Microsoft R Open.
-
How to Query Live ConvertKit Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ConvertKit data in natural language using Python.
-
Create Dynamic HelloSign Grids Using the Infragistics XamDataGrid
Learn how you can connect HelloSign to Infragistics XamDataGrid to build dynamic grids.
-
Build Pipedrive-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Pipedrive to explore live Pipedrive Data in Claude Code to assist with building Pipedrive-powered applications.
-
Query Live Facebook 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 Facebook directly from the development environment.
-
How to connect Amazon QuickSight to Email Data
Create a connection to Email in CData Connect AI and insert Email into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating OpenCode Terminal with Adobe Commerce 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.
-
Analyze Oracle Financials Cloud Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Oracle Financials Cloud and visualize live Oracle Financials Cloud in Infragistics Reveal.
-
Integrate Google Directory Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Directory and integrate live Google Directory into your Power Automate tasks.
-
How to connect PolyBase to MarkLogic
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MarkLogic.
-
How to publish and share Pipeliner CRM Data dashboards with Tableau Server
The CData ODBC driver for Pipeliner CRM enables you integrate Pipeliner CRM into Tableau dashboards.
-
Create ZohoPeople Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ZohoPeople from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to create an RPA flow for Cosmos DB Data in UiPath Studio
Use the Cosmos DB ODBC Driver to create workflows that access real-time Azure Cosmos DB without any coding.
-
Automated Continuous Splunk Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Splunk replication to IBM DB2.
-
Automated Continuous Google Cloud Storage Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Amazon S3.
-
How to connect to Demio Data from Spring Boot
Connect to Demio in a Spring Boot Application using the CData API Driver for JDBC
-
How to connect to Acumatica Data from IntelliJ
Integrate connectivity to Acumatica ERP with wizards in IntelliJ.
-
Bidirectional Access to ClickTime Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ClickTime in Filemaker Pro for Mac or Windows.
-
Query PabblySubscriptions Data in DataGrip
Create a Data Source for PabblySubscriptions in DataGrip and use SQL to query live PabblySubscriptions.
-
Connect to ZohoDesk Data in HULFT Integrate
Connect to ZohoDesk as a JDBC data source in HULFT Integrate
-
How to update SQLite from Excel
This article explains how to transfer data from Excel to SQLite using the Excel Add-In for SQLite.
-
Automated Continuous LightSpeedRetail Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Google BigQuery.
-
Use the CData API Server to Access Box Data in Microsoft PowerPivot
Use the CData API Server to connect to live Box in the Power Pivot business intelligence tool.
-
Integrate LionDesk Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live LionDesk from Informatica Cloud.
-
Connect to Gong Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Gong.
-
Connecting Moonlit Workflow with Sugar CRM 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 Sugar CRM in real time.
-
Connect to Amazon DynamoDB Data from PowerBuilder via ADO.NET
This article demonstrates how to access Amazon DynamoDB from Appeon PowerBuilder using the CData ADO.NET Provider for Amazon DynamoDB.
-
Import and Visualize Pinterest Data in Power View
Create data visualizations based on Pinterest in Excel.
-
How to load Front data into Elasticsearch via Logstash
Introducing a simple method to load Front data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automate Freshteam Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Freshteam from PowerShell? This article demonstrates how to utilize the Freshteam Cmdlets for tasks like connecting to Freshteam, automating operations, downloading data, and more.