CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Sendwithus Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sendwithus replication to Google BigQuery.
-
How to update Snowflake from Excel
This article explains how to transfer data from Excel to Snowflake using the Excel Add-In for Snowflake.
-
Integrate Live Campaigner Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Campaigner data from within the IDE.
-
Connect to Google Tasks Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Tasks to connect to Google Tasks data and execute queries in PowerBuilder.
-
Connect to Mocean 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 Mocean and work with Mocean data in your FileMaker application.
-
Moving Data from Reckon to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Reckon data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect Amazon QuickSight to Amazon Marketplace Data
Create a connection to Amazon Marketplace data in CData Connect AI and insert Amazon Marketplace data into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Power BI Connector for Twitter Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Twitter Ads.
-
Automated Continuous TaxJar Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable TaxJar replication to Azure SQL Database.
-
Integrate HelloSign Data in Pentaho Data Integration
Build ETL pipelines based on HelloSign data in the Pentaho Data Integration tool.
-
Query Azure Table Data in DataGrip
Create a Data Source for Azure Table in DataGrip and use SQL to query live Azure Table data.
-
Integrate with Live ShipStation Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ShipStation from the MuleSoft Anypoint Platform to integrate live ShipStation data into custom reports and dashboards.
-
Access Live SAP Netweaver Gateway Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Netweaver Gateway data from your Excel spreadsheets.
-
Integrating Kiro with Shortcut 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.
-
Load Webflow Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Webflow data to a database.
-
Connect to Google Campaign Manager 360 Data from PowerBuilder via JDBC
This article demonstrates how to access Google Campaign Manager 360 data from PowerBuilder using the Google Campaign Manager 360 JDBC Driver.
-
Creating Google Drive-Connected Applications in Unqork
You can use CData Connect AI to feed Google Drive data to Unqork and build custom business apps.
-
Write a Simple Go Application to work with IBM Cloud Object Storage Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to IBM Cloud Object Storage data.
-
How to Visualize ZohoInvoice Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live ZohoInvoice data in Python.
-
Use the CData Software ODBC Driver for Gumroad in MicroStrategy
Connect to Gumroad data in MicroStrategy Developer using the CData Software ODBC Driver for Gumroad.
-
Connect to Databricks Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Databricks and the Script function in FileMaker Pro to connect to Databricks and work with Databricks data in your FileMaker application.
-
Publish Crystal Reports on SAP Netweaver Gateway Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Netweaver Gateway data.
-
Build Typeform-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Typeform Data and create custom apps in Bubble.
-
Integrate with live Freshservice Data in Jitterbit
Use CData Connect AI to connect to and integrate live Freshservice data in Jitterbit.
-
View Reports on Real-Time Hive Data in Power BI Report Server
Use the CData ODBC Driver for Hive to visualize Hive data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Dataiku with Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Dropbox data.
-
How to Connect to & Open HubSpot Data in Microsoft Excel
This article uses the CData ODBC driver for HubSpot to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Claude Code with OneNote Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on OneNote data within assisted coding and automated development workflows.
-
Build a Simple VCL Application for SurveyMonkey Data
How to build a simple VCL Application to view SurveyMonkey data in RAD Studio using the CData ODBC Driver for SurveyMonkey.
-
ETL OneNote in Oracle Data Integrator
This article shows how to transfer OneNote data into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData Connect AI Python SDK for ShipStation
Install the CData Connect AI Python SDK to read live ShipStation data with standard DB-API 2.0 Python code.
-
Access Insightly Data from MySQL in Amazon QuickSight
Connect to Insightly and build visualizations of Insightly data using a MySQL Connection in Amazon QuickSight.
-
How to Connect Flowise AI Agents to Live Cassandra Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Cassandra data without replication.
-
Connect to Oracle SCM Data in Aqua Data Studio
Access Oracle SCM data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to ZendeskSell Data in CloverDX (formerly CloverETL)
Transfer ZendeskSell data using the visual workflow in the CloverDX data integration tool.
-
Connect to Zoho Inventory Data in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho Inventory in FileMaker Pro to connect to Zoho Inventory and work with Zoho Inventory data in your FileMaker applications.
-
Query Bright Data Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Bright Data data from Node.js.
-
Automated Continuous GraphQL Replication to Amazon S3
Use CData Sync for automated, continuous, customizable GraphQL replication to Amazon S3.
-
Integrate Devin with Live IBM Cloud Object Storage Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live IBM Cloud Object Storage data.
-
Integrate with SAP HANA Data in JReport Designer
Create charts and reports based on SAP HANA data in JReport Designer.
-
How to Build an ETL App for Microsoft Ads Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft Ads data in Python with petl and the CData Connect AI Python SDK.
-
Link Scrapfly with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Scrapfly data in Filemaker Pro for Mac or Windows.
-
Automated Continuous Postmark Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Postmark replication to Azure SQL Database.
-
Build Automated Workflows with Live CockroachDB Data in Workato
Use CData Connect AI to connect to live CockroachDB data and build automated workflows in Workato.
-
Visualize Live Splunk Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Splunk data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Outreach.io Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Outreach.io data.
-
How to Query Live FormSite Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live FormSite data data in natural language using Python.
-
Access Live Shopify Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Shopify data from your Excel spreadsheets.
-
Access Smartsheet 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 Smartsheet data.
-
How to connect to SuiteCRM Data with Squirrel SQL client
Connect to SuiteCRM data and execute queries in the Squirrel SQL Client.
-
Analyze Hugging Face Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Hugging Face from Power Pivot. You will use the Table Import Wizard to load Hugging Face data. You can visually build the import query or use any SQL supported by the driver.
-
Create Power BI Reports on Real-Time Mocean Data
Use the CData ODBC Driver for Mocean to visualize Mocean data in Power BI Desktop.
-
Build Discord-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Discord data and build web apps with connectivity to live Discord data.
-
How to Work with Aweber Data in AWS Glue Jobs Using JDBC
Connect to Aweber from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Codex with ZohoDesk 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.
-
Working with Microsoft OneDrive Data in LINQPad
Execute LINQ queries to Microsoft OneDrive data in LINQPad.
-
Build Salesloft-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Salesloft data.
-
Automated Continuous Microsoft Teams Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Amazon S3.
-
Use the CData SSIS Components to Insert New or Update Existing Facebook Records from SQL Server
Easily push SQL Server data to Facebook using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Facebook or update existing records with data from a SQL Server database.
-
How to Connect the Power BI Service to Google Search: Complete Guide
Connect to the CData Software Power BI Connector for Google Search from PowerBI.com to provide real-time Google Search results across the organization.
-
Add SAP Concur Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Concur with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Agents in Relevance AI with Access to Live SuiteCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SuiteCRM data within intelligent agent workflows.
-
Access Sybase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sybase data from HeidiSQL.
-
Use the CData Software ODBC Driver for Coinbase in SAS for Real-Time Reporting and Analytics
Connect to real-time Coinbase data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Coinbase.
-
Automated Continuous Exact Online Replication to Databricks
Use CData Sync for automated, continuous, customizable Exact Online replication to Databricks.
-
Connect to Dropbox from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Dropbox data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Apps with Live Bullhorn CRM data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Bullhorn CRM data into the Adalo platform and build custom mobile and web applications with real-time Bullhorn CRM data.
-
Connect Azure Table to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Table with IBM WebSphere for seamless data integration and connectivity.
-
A PostgreSQL Interface for Email Data (MySQL Remoting via JDBC)
Use the Remoting features of the Email JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Elorus Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Elorus replication to AlloyDB.
-
How to create Postmark federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Postmark data in MySQL .
-
Connect to ChartMogul Data from PowerBuilder via JDBC
This article demonstrates how to access ChartMogul data from PowerBuilder using the ChartMogul JDBC Driver.
-
Build an OLAP Cube in SSAS from Square Data
Establish a connection to Square data data from SQL Server Analysis Services, and use the Square Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Informatica Mappings From/To a JDBC Data Source for Microsoft OneDrive
Create Microsoft OneDrive data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect HCL Domino to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live HCL Domino data using the CData Python MCP Server.
-
Build a Simple VCL Application for Amazon DynamoDB Data
How to build a simple VCL Application to view Amazon DynamoDB data in RAD Studio using the CData ODBC Driver for Amazon DynamoDB.
-
Connect to ZeroBounce Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZeroBounce data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Dashboards with Customer.io Data in DBxtra
Create dynamic dashboards and perform analytics based on Customer.io data in DBxtra.
-
Use CData Connect AI to Access Optimizely Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Optimizely data in the Power Pivot business intelligence tool.
-
Create Dashboards and Visualize Live Zoho Creator Data in Geckoboard
Use CData Connect AI to connect to live Zoho Creator data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Bind Live Stripe Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Stripe data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Getting Started with the CData Tableau Connector for Microsoft Exchange
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft Exchange.
-
Import Azure DevOps Data Using Azure Data Factory
Use CData Connect AI to connect to Azure DevOps Data from Azure Data Factory and import live Azure DevOps data.
-
Automated Continuous RabbitMQ Replication to Vertica
Use CData Sync for automated, continuous, customizable RabbitMQ replication to Vertica.
-
Build PayPal Visualizations in Tableau Cloud
Use CData Connect AI to connect to live PayPal data and build visualizations in Tableau Cloud.
-
Build Wave Financial-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Wave Financial data and build web apps with connectivity to live Wave Financial data.
-
Automated Continuous Adobe Analytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to SingleStore.
-
Connect to Pinecone 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 Pinecone and work with Pinecone data in your FileMaker application.
-
Access Live Mailgun 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 Mailgun data through MCP integration.
-
How to Connect eBay 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 eBay data in real time using natural language.
-
Integrate Dify with Live Reckon Accounts Hosted Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Reckon Accounts Hosted data.
-
Excel Spreadsheet Automation on Brex Data with the QUERY Formula
Pull data from Brex, automate spreadsheets, and more with the QUERY formula.
-
Connect to Vertica 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 Vertica data.
-
Integrate Parallel with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Parallel with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Parallel data.
-
Connect to JobNimbus Data from a Connection Pool in JBoss
Integrate JobNimbus data into Java servlets: Use the Management Console in JBoss to install the JobNimbus JDBC Driver.
-
How to Seamlessly Import Dynamics NAV Data into IBM SPSS Modeler
Integrate Dynamics NAV data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Chargebee Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Chargebee replication to AlloyDB.
-
Access Bitbucket 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 Bitbucket data.
-
Create Zendesk-Connected Business Apps in AppSheet
Connect to Zendesk Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zendesk data.
-
Create Dynamic Microsoft Ads Grids Using the Infragistics XamDataGrid
Learn how you can connect Microsoft Ads to Infragistics XamDataGrid to build dynamic grids.