CData Software - Knowledge Base
Recent Articles
-
How to load Hubstaff data into Elasticsearch via Logstash
Introducing a simple method to load Hubstaff data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query GitHub Data in DataGrip
Create a Data Source for GitHub in DataGrip and use SQL to query live GitHub.
-
Automated Continuous Toggl Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Toggl replication to Amazon Redshift.
-
Query Bitly Data in ColdFusion
Write standard ColdFusion data access code to connect to Bitly.
-
Excel Spreadsheet Automation on Foursquare Data with the QUERY Formula
Pull data from Foursquare, automate spreadsheets, and more with the QUERY formula.
-
Import and Visualize Wrike Data in Power View
Create data visualizations based on Wrike in Excel.
-
Connect to Box Data in CloverDX (formerly CloverETL)
Transfer Box using the visual workflow in the CloverDX data integration tool.
-
Query SpaceX Data in ColdFusion
Write standard ColdFusion data access code to connect to SpaceX.
-
How to Access Live PolarTeamPro Data in Power Automate Desktop via ODBC
The CData ODBC Driver for PolarTeamPro enables you to integrate PolarTeamPro into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Harvest Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Harvest replication to delimited files (CSV/TSV).
-
Integrating Cursor CLI with Oracle HCM Cloud 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 Semantic Layer Views for Yelp Data in APOS Live Data Gateway
Use the CData Connector for Yelp in APOS Live Data Gateway to build Semantic Layer Views for Yelp.
-
Getting Started with the CData Power BI Connector for Mixpanel
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Stream Quaderno Data into Apache Kafka Topics
Access and stream Quaderno in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for BigCommerce
Provide connectivity to BigCommerce through an SAP BusinessObjects universe.
-
Connect to Google Tasks Data in NetBeans
Connect to Google Tasks in NetBeans with the data source configuration wizard.
-
Migrating data from Browserless to Snowflake using CData SSIS Components.
Easily push Browserless to Snowflake using the CData SSIS Tasks for Browserless and Snowflake.
-
View Reports on Real-Time DB2 Data in Power BI Report Server
Use the CData ODBC Driver for DB2 to visualize IBM DB2 in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect Spark to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Apache Spark SQL using the CData Python MCP Server.
-
Write a Simple Go Application to work with Splunk Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Splunk.
-
Connect to TaxJar Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for TaxJar and the Script function in FileMaker Pro to connect to TaxJar and work with TaxJar in your FileMaker application.
-
Build Pipelines with Live Vertica Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Vertica from Google Cloud Data Fusion, enabling the integration of live Vertica into the building and management of effective data pipelines.
-
How to Connect to Live SAP HANA 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 SAP HANA for you.
-
Getting Started with the CData SSIS Components for LDAP
Complete guide to installing, licensing, and connecting with the CData SSIS Components for LDAP.
-
Access Oracle Service Cloud Data from MySQL in PHP
Connect to Oracle Service Cloud through the standard MySQL libraries in PHP.
-
How to Use a Microsoft Access Database to Update HubDB Data in Real Time
Update HubDB data by creating a linked table in Microsoft Access with the CData HubDB ODBC Driver.
-
How to connect to Short.io Data from IntelliJ
Integrate connectivity to Short.io with wizards in IntelliJ.
-
Publish Tanda-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Tanda.
-
Integrating Kiro CLI with PingOne 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 MVC Applications with Connectivity to SAP Fieldglass Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Fieldglass from an ASP.NET MVC application.
-
How to update SFTP from Excel
This article explains how to transfer data from Excel to SFTP using the Excel Add-In for SFTP.
-
Build SAP HANA-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAP HANA to explore live SAP HANA Data in Gemini Code Assist to assist with building SAP HANA-powered applications.
-
Rapidly Develop Acumatica-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 Acumatica.
-
Connect to Dynamics 365 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Dynamics 365 as an External Source in Dremio.
-
Import Real-Time Oracle Financials Cloud Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle Financials Cloud in ColdFusion.
-
Connect to Google Ad Manager from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Ad Manager, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Oracle Eloqua-Connected Dashboards in Grafana
Connect to Oracle Eloqua Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle Eloqua.
-
Use ChatGPT to Talk to Your Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Directory for you.
-
ETL Rebilly in Oracle Data Integrator
This article shows how to transfer Rebilly into a data warehouse using Oracle Data Integrator.
-
How to Import Data from Reckon Accounts Hosted into Google Sheets
Import Reckon Accounts Hosted into a Google spreadsheet that is automatically refreshed.
-
Feed Superchat Data into FineReport
How to set Superchat as a JDBC data source in FineReport.
-
Use the CData Software JDBC Driver for Freshsales in MicroStrategy Web
Connect to Freshsales in MicroStrategy Web using the CData Software JDBC Driver for Freshsales.
-
Automate Supabase Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Supabase from PowerShell? This article demonstrates how to utilize the Supabase Cmdlets for tasks like connecting to Supabase, automating operations, downloading data, and more.
-
Connect to Slack from a Connection Pool in WebLogic
Use the CData JDBC Driver for Slack to connect to Slack from Web applications running on WebLogic.
-
Connect to Rebilly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Rebilly to connect to Rebilly and execute queries in PowerBuilder.
-
Connect to SAP BusinessObjects BI from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP BusinessObjects BI to connect to SAP BusinessObjects BI from Web applications running on WebLogic.
-
Replicate Bitbucket Data to Multiple Databases
Replicate Bitbucket to disparate databases with a point-and-click configuration.
-
Connect to and Visualize Live Epicor Kinetic Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Epicor Kinetic.
-
Use Grok to Talk to Your JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your JSON for you.
-
How to Connect to & Open Dynamics 365 Business Central Data in Microsoft Excel
This article uses the CData ODBC driver for Dynamics 365 Business Central to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to SendPulse in SpagoBI
Create reports featuring live SendPulse in SpagoBI Studio. Host SendPulse reports on SpagoBI Server.
-
Connect to Microsoft Exchange Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Exchange from PowerBuilder using the Microsoft Exchange JDBC Driver.
-
Integrate Teradata Data in the Pentaho Report Designer
Publish reports based on Teradata in the Pentaho BI tool.
-
Integrate Azure DevOps with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Azure DevOps with External Services.
-
How to create an RPA flow for Drip Data in UiPath Studio
Use the Drip ODBC Driver to create workflows that access real-time Drip without any coding.
-
Back Up ZarMoney to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ZarMoney data.
-
Access Live Salesforce Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesforce & Force.com into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce & Force.com in the Graph Builder and Query Builder.
-
Update Multiple Invoices using the CData Excel Add-In for QuickBooks
The CData Excel Add-In for QuickBooks makes it easy to modify your QuickBooks data right in Excel. This article will explain how to use the CData Excel Add-In for QuickBooks to mark multiple Invoices at once for printing and e-mailing.
-
Work with Sage 200 Data in FoxPro
Load Sage 200 into a FoxPro database. This article includes full code and a walk-through of the process.
-
Validate Aircall Data with QuerySurge
Access and validate Aircall in QuerySurge using the CData JDBC Driver.
-
Integrate Zoho CRM Data in the Pentaho Report Designer
Publish reports based on Zoho CRM in the Pentaho BI tool.
-
How to integrate Egnyte with Apache Airflow
Access and process Egnyte in Apache Airflow using the CData JDBC Driver.
-
Viewing Apollo Data in RAD Studio Data Explorer
How to view Apollo in RAD Studio Data Explorer using the CData ODBC Driver for Apollo.
-
How to Connect to Live Oracle 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 Oracle Database for you.
-
Connect to Microsoft Entra ID Data in RapidMiner
Integrate Microsoft Entra ID with standard components and data source configuration wizards in RapidMiner Studio.
-
Natively Connect to Chargebee Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Chargebee. Leverage the native support for ODBC in PHP.
-
Connect to CampaignMonitor Data from PowerBuilder via ADO.NET
This article demonstrates how to access CampaignMonitor from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous SAP Concur Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Concur replication to Amazon S3.
-
How to update WordPress from Excel
This article explains how to transfer data from Excel to WordPress using the Excel Add-In for WordPress.
-
How to Query Live Salesforce Pardot Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Salesforce Pardot data in natural language using Python.
-
Access Live Clio Data in Coginiti Pro
Connect to and query live Clio from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use JayDeBeApi to access xBase Data in Python
Use standard Python scripting and the development environment of your choice to access live xBase.
-
Use Dash to Build Web Apps on Apollo Data via CData Connect AI
Build interactive Dash web apps on live Apollo using pandas and the CData Connect AI Python SDK.
-
LINQ to MailerSend 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 MailerSend Data Provider.
-
Integrate Cline with Live HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Apache HBase from within your IDE.
-
Connecting Moonlit Workflow with OData Services 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 OData in real time.
-
Google BigQuery: Million Row Challenge
CData Software tests a one million row bulk load of Google BigQuery data.
-
ZendeskSell Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ZendeskSell facts in real time.
-
Write a Simple Go Application to work with SurveyMonkey Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SurveyMonkey.
-
Automated Continuous FreshBooks Replication to MongoDB
Use CData Sync for automated, continuous, customizable FreshBooks replication to MongoDB.
-
Use JayDeBeApi to access Amazon DynamoDB Data in Python
Use standard Python scripting and the development environment of your choice to access live Amazon DynamoDB.
-
Integrate with Cosmos DB Data in JReport Designer
Create charts and reports based on Azure Cosmos DB in JReport Designer.
-
Natively Connect to CapsuleCRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to CapsuleCRM. Leverage the native support for ODBC in PHP.
-
Migrating data from ZohoExpense to Google BigQuery using CData SSIS Components.
Easily push ZohoExpense to Google BigQuery using the CData SSIS Tasks for ZohoExpense and Google BigQuery.
-
Publish ZohoExpense-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZohoExpense.
-
Connect to Avalara AvaTax Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Avalara AvaTax to connect to Avalara AvaTax and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for Telegram in MicroStrategy
Connect to Telegram in MicroStrategy Developer using the CData Software JDBC Driver for Telegram.
-
Visualize Eventbrite 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 Eventbrite into TIBCO Spotfire.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed BigCommerce to Power BI dashboards. Simply drag and drop BigCommerce into data visuals on the Power BI canvas.
-
How to Query SAP Data in MySQL Workbench
Execute MySQL queries against live SAP ERP/NetWeaver from MySQL Workbench.
-
Excel Spreadsheet Automation on Couchbase Data with the QUERY Formula
Pull data from Couchbase, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Google Spanner Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Spanner replication to SingleStore.
-
Access Parquet Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Apache Parquet from HeidiSQL.
-
Working with BigCommerce Data in LINQPad
Execute LINQ queries to BigCommerce in LINQPad.
-
View Reports on Real-Time Bugsnag Data in Power BI Report Server
Use the CData ODBC Driver for Bugsnag to visualize Bugsnag in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Python Connector for Front
Learn to install and license the CData Python Connector
-
Add SAP Business Warehouse Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Business Warehouse with the Informatica Enterprise Data Catalog to classify and organize data.
-
Query AlloyDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google AlloyDB from Node.js.
-
Integrate Live Microsoft Ads Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Analyze Active Directory Data in Cognos Analytics
Use CData Connect AI to connect to Active Directory Data from Cognos Analytics and analyze live Active Directory.