CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with Parquet Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apache Parquet.
-
Connect to Zoho Inventory Data in CloverDX (formerly CloverETL)
Transfer Zoho Inventory using the visual workflow in the CloverDX data integration tool.
-
Choosing the Best Method to Connect eBay Analytics to SQL Server: 5 Options Explained
Discover multiple ways to connect and use eBay Analytics from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated QuickBooks Time Data Replication to Teradata
Use CData Sync to Customize and automate QuickBooks Time replication to Teradata.
-
Automated Continuous Nethunt Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Nethunt replication to delimited files (CSV/TSV).
-
Access Live Salesforce Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Salesforce & Force.com from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Apollo Data in JRuby
Create a simple JRuby app with access to live Apollo.
-
Publish JDBC-ODBC Bridge-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live JDBC-ODBC Bridge.
-
Connect to Tavily Data in Ruby
Connect to Tavily in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Publish Zendesk-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zendesk.
-
Connect to SAP Data in CloverDX (formerly CloverETL)
Transfer SAP ERP/NetWeaver using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Drift Replication to SQL Server
Use CData Sync for automated, continuous, customizable Drift replication to SQL Server.
-
Connect to eBay Analytics Data in Ruby
Connect to eBay Analytics in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Work with Wistia Data in ETL Validator JDBC
Connect to Wistia from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live HBase Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache HBase from your Excel spreadsheets.
-
Back Up RSS Feeds to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for RSS. In this article, we will employ an SSIS workflow to populate a database with RSS Feeds data.
-
Build Oracle Service Cloud-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Oracle Service Cloud to explore live Oracle Service Cloud Data in Gemini Code Assist to assist with building Oracle Service Cloud-powered applications.
-
Build Charts with Stack Exchange Data in Clear Analytics
Create dynamic charts and perform analytics based on Stack Exchange in Clear Analytics.
-
DataBind Controls to ADP Data in Delphi
DataBind to ADP in Delphi with standard data access components and controls.
-
Connect to ZohoInvoice Data in Aqua Data Studio
Access ZohoInvoice from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous BenchmarkEmail Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Amazon Redshift.
-
DataBind Controls to Box Data in Delphi
DataBind to Box in Delphi with standard data access components and controls.
-
LINQ to Stripe 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 Stripe Data Provider.
-
Extract, Transform, and Load Authorize.Net Data in Informatica PowerCenter
Create a simple Workflow for Authorize.Net in Informatica PowerCenter.
-
Bind Live Google Sheets Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Sheets data
-
Seamlessly Bring Couchbase Data into Retool Using CData Connect AI
Integrate Couchbase data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
DataBind Controls to QuickBooks Online Data in C++Builder
DataBind to QuickBooks Online in C++Builder with standard components and controls.
-
How to Work with SAP HANA XS Advanced Data in ETL Validator JDBC
Connect to SAP HANA XS Advanced from ETL Validator jobs using the CData Software JDBC Driver.
-
MessageBird Reporting in OBIEE with the MessageBird JDBC Driver
Deploy the MessageBird JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automate Ontraport Data Replication to Azure Synapse
Use CData Sync to customize and automate Ontraport replication to Azure Synapse.
-
Integrate ServiceDesk Plus with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ServiceDesk Plus with External Services.
-
Provide OData Services of VWO Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for VWO by developing a WCF Service Application.
-
How to Connect DBeaver to PivotalTracker via a JDBC Driver
Manage PivotalTracker with visual tools in DBeaver like the query browser.
-
How to Connect to Planio Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Planio. Leverage the pyodbc module for ODBC in Python.
-
Access Google Directory Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Directory from your Oracle system.
-
Use the CData Software ODBC Driver for Google Campaign Manager 360 in MicroStrategy
Connect to Google Campaign Manager 360 in MicroStrategy Developer using the CData Software ODBC Driver for Google Campaign Manager 360.
-
How to connect to Shortcut Data in DBVisualizer
Integrate Shortcut with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Query Live HCL Domino Data in Perplexity MacOS Desktop
Connect to and query live HCL Domino Data in Perplexity Desktop using CData MCP Server.
-
Create Monday.com-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Monday.com Data from OutSystems and build custom enterprise apps using live Monday.com.
-
How to connect to Aweber Data from IntelliJ
Integrate connectivity to Aweber with wizards in IntelliJ.
-
Query Slack Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Slack from Node.js.
-
Build Data Flows from SQL Server to Cosmos DB through SSIS
Easily push SQL Server data to Cosmos DB using the CData SSIS Tasks for Cosmos DB.
-
Connect to Eventbrite 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 Eventbrite and work with Eventbrite in your FileMaker application.
-
Object-Relational Mapping (ORM) with Paylocity 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 Paylocity into a Java-based ORM framework, Hibernate.
-
Access Live Dynamics CRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Dynamics CRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Migrating data from Opsgenie to Databricks using CData SSIS Components.
Easily push Opsgenie to Databricks using the CData SSIS Tasks for Opsgenie and Databricks.
-
Build Dashboards with Aircall Data in Dundas BI
Create dynamic dashboards and perform analytics based on Aircall in Dundas BI.
-
Natively Connect to Perplexity Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Perplexity. Leverage the native support for ODBC in PHP.
-
Connect to ServiceNow Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Basecamp Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Basecamp replication to Amazon S3.
-
How to Import Data from Couchbase into Google Sheets
Import Couchbase into a Google spreadsheet that is automatically refreshed.
-
Use the CData Software JDBC Driver for AfterShip in MicroStrategy Web
Connect to AfterShip in MicroStrategy Web using the CData Software JDBC Driver for AfterShip.
-
Connect to Real-Time Google Drive Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Drive and Dataflow to import and use Google Drive in Power Apps.
-
Visualize Live Sage Cloud Accounting Data in the Power BI Service
Use CData Connect AI to connect to live Sage Business Cloud Accounting and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Claude Code with Lakebase Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Lakebase within assisted coding and automated development workflows.
-
Replicate Freshservice Data to Multiple Databases via the CData Sync CLI
Replicate Freshservice to disparate databases with a single configuration.
-
A PostgreSQL Interface for Lakebase Data using the CData ODBC Driver
Use the SQL Gateway and Lakebase ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Visualize Google Translate Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Translate in Python.
-
Connect to Guru Data in DBeaver
Use the CData ODBC Driver to connect to Guru in DBeaver.
-
Use Agno to Talk to Your Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Procore for you.
-
How to Import Data from Sybase IQ into Google Sheets
Import Sybase IQ into a Google spreadsheet that is automatically refreshed.
-
Access Live Sybase IQ Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sybase IQ from your Google Sheets.
-
Deploy the ADO.NET Provider for SAP Ariba Procurement on an SSRS Report Server
Connect to SAP Ariba Procurement from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automated Continuous IBM Informix Replication to AlloyDB
Use CData Sync for automated, continuous, customizable IBM Informix replication to AlloyDB.
-
Getting Started with the CData Python Connector for Google Sheets
Learn to install and license the CData Python Connector
-
Replicate HelloSign Data from PowerShell
Write a quick PowerShell script to query HelloSign. Use connectivity to the live data to replicate HelloSign to SQL Server.
-
How to connect to Presto Data in DBVisualizer
Integrate Presto with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Clio Data in DBeaver
Use the CData ODBC Driver to connect to Clio in DBeaver.
-
How to Work with Redshift Data in ETL Validator JDBC
Connect to Redshift from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Salesforce CRM Analytics-Connected Applications in Appsmith
Connect to Salesforce CRM Analytics Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Salesforce CRM Analytics.
-
Excel Spreadsheet Automation on OpenWeatherMap Data with the QUERY Formula
Pull data from OpenWeatherMap, automate spreadsheets, and more with the QUERY formula.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Azure Analysis Services using the Model Context Protocol.
-
Automated Continuous Confluence Replication to SQLite
Use CData Sync for automated, continuous, customizable Confluence replication to SQLite.
-
Connect to Salesforce Data 360 Data in RapidMiner
Integrate Salesforce Data 360 with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Codex CLI with XML Files 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 and Visualize Live SharePoint Excel Services Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SharePoint Excel Services.
-
Import Real-Time Wave Financial Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Wave Financial in ColdFusion.
-
Create Reports from Microsoft OneDrive Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft OneDrive and create custom reports in Looker Studio.
-
How to Visualize Sugar CRM 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 Sugar CRM in Python.
-
How to integrate Metabase with SAP Ariba Source Data
Use CData Connect AI to connect to live SAP Ariba Source and create an interactive dashboard in Metabase from SAP Ariba Source.
-
Connect to eBay Data in RazorSQL
Connect to eBay from wizards and query eBay from the GUI in the RazorSQL database management tool.
-
How to Connect to Live WooCommerce Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your WooCommerce for you.
-
Access Microsoft Planner Data from MySQL in Amazon QuickSight
Connect to Microsoft Planner and build visualizations of Microsoft Planner using a MySQL Connection in Amazon QuickSight.
-
How to Connect to Live ADP Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live ADP without replication.
-
Automated Continuous Keap Replication to Oracle
Use CData Sync for automated, continuous, customizable Keap replication to Oracle.
-
Build MVC Applications with Connectivity to Teamgate Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Teamgate from an ASP.NET MVC application.
-
Integrating Claude Code CLI with AgileCRM 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 Databricks Data from MySQL in PHP
Connect to Databricks through the standard MySQL libraries in PHP.
-
Create SAP Netweaver Gateway-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Netweaver Gateway Data from OutSystems and build custom enterprise apps using live SAP Netweaver Gateway.
-
How to integrate Airtable with Apache Airflow
Access and process Airtable in Apache Airflow using the CData JDBC Driver.
-
Use JayDeBeApi to access Coinbase Data in Python
Use standard Python scripting and the development environment of your choice to access live Coinbase.
-
Build AI/ML Models with Live Invoiced Data using Dataiku
Connect Invoiced Data with Dataiku using the CData API Driver for JDBC.
-
Query Hubstaff Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Hubstaff from Node.js.
-
Enable the CockroachDB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with CockroachDB.
-
Connect to CloudConvert Data from PowerBuilder via ADO.NET
This article demonstrates how to access CloudConvert from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Object-Relational Mapping (ORM) with Onfleet 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 Onfleet into a Java-based ORM framework, Hibernate.
-
Analyze Deel Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Deel with the CData JDBC Driver for Deel.
-
Analyze SAP Ariba Source Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Ariba Source with the CData JDBC Driver for SAP Ariba Source.
-
Connect and Visualize Live Lakebase Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Lakebase into the Databricks platform and create visualization dashboards with real-time Lakebase.
-
Edit and Search External Redis Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Redis to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Redis Data objects that you can access from apps and the dashboard.