CData Software - Knowledge Base
Recent Articles
-
Connect to Google Cloud Storage from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Cloud Storage data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Build an ETL App for Scrapfly Data in Python with CData
Create ETL applications and real-time data pipelines for Scrapfly data in Python with petl.
-
Integrate Google's Vertex AI Agent with Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live CockroachDB data within intelligent workflows.
-
Integrating Antigravity CLI with Paylocity data via CData CLI
Connect Paylocity data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Python Connector for Zoom
Learn to install and license the CData Python Connector and configure a connection to live Zoom data.
-
How to create an RPA flow for Oracle Data in UiPath Studio
Use the Oracle ODBC Driver to create workflows that access real-time Oracle data without any coding.
-
Access Live OData Services in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to OData services from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating GitHub Copilot with Egnyte 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.
-
Integrate with Contentful Data in JReport Designer
Create charts and reports based on Contentful data in JReport Designer.
-
Use Biml to Build SSIS Tasks to Replicate Wrike Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Wrike data to SQL Server.
-
Analyze Zoho Books Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zoho Books data and visualize live Zoho Books data in Infragistics Reveal.
-
How to create Salesforce CRM Analytics federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesforce CRM Analytics data in MySQL .
-
Connect to ShipEngine Data in RazorSQL
Connect to ShipEngine from wizards and query ShipEngine data from the GUI in the RazorSQL database management tool.
-
Analyze Slack Data in Cognos Analytics
Use CData Connect AI to connect to Slack Data from Cognos Analytics and analyze live Slack data.
-
DataBind Hive Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Hive with the DevExpress Windows Forms and Web controls to provide Hive data to a chart.
-
Design BIRT Reports on Google Cloud Storage Data
Provide current Google Cloud Storage data to your embedded analytics.
-
Create Apps from AgileCRM Data in Qlik Sense Cloud
Use CData Connect AI to connect to AgileCRM Data and build apps from live AgileCRM data in Qlik Sense Cloud.
-
Choosing the Best Method to Connect Optimizely to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Optimizely data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Antigravity CLI with Google Translate data via CData CLI
Connect Google Translate data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Access Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Access from PowerBI.com to create Power BI Dataflows with real-time data.
-
Search External PayPal Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of PayPal data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create PayPal Data objects that you can access from apps and the dashboard.
-
Automated Continuous SAP Hybris C4C Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Amazon S3.
-
Create SSAS Tabular Models from Workday Data
How to build a SQL Server Analysis Service Tabular Model from Workday data using CData drivers.
-
Integrate LibreChat with Live Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Box data from within the chat interface.
-
Getting Started with the CData ADO.NET Provider for Drip
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Connect to Live IBM Informix Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your IBM Informix data for you.
-
Build a Simple VCL Application for Google Sheets Data
How to build a simple VCL Application to view Google Sheets data in RAD Studio using the CData ODBC Driver for Google Sheets.
-
Connect to HubSpot 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 HubSpot data.
-
Build Semantic Layer Views for Pipedrive Data in APOS Live Data Gateway
Use the CData Connector for Pipedrive in APOS Live Data Gateway to build Semantic Layer Views for Pipedrive data.
-
View Reports on Real-Time Unbounce Data in Power BI Report Server
Use the CData ODBC Driver for Unbounce to visualize Unbounce data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to SAP Business Warehouse Data in HULFT Integrate
Connect to SAP Business Warehouse as a JDBC data source in HULFT Integrate
-
Integrate Live MarkLogic Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to MarkLogic from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live MarkLogic data.
-
Integrating Cursor with Facebook Ads 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 Amazon S3-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Amazon S3 data and build web apps with connectivity to live Amazon S3 data.
-
Moving Data from xBase to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live xBase data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Sage 200 Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Sage 200 data and build visualizations in Tableau Cloud.
-
Integrate ShipStation with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ShipStation with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ShipStation data.
-
Build a PostgreSQL Interface for HelloSign Data using the CData JDBC Driver
Use the Remoting features of the HelloSign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData ADO.NET Provider for Gorgias
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Explore Geographical Relationships in Supabase Data with Power Map
Create data visualizations with Supabase data in Power Map.
-
Getting Started with the CData Power BI Connector for Sybase
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sybase.
-
Integrating Claude Code with ADP Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on ADP data within assisted coding and automated development workflows.
-
Create Informatica Mappings From/To a JDBC Data Source for Zuora
Create Zuora data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData Excel Add-In for Moosend
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Moosend.
-
Integrating Kiro with Reply.io 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.
-
Connecting Agentforce with Apollo Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Apollo data for you.
-
Integrate Google Contacts Data in Pentaho Data Integration
Build ETL pipelines based on Google Contacts data in the Pentaho Data Integration tool.
-
Connect to eBay Data from HeidiSQL
Use CData Connect AI to connect to and query live eBay data from HeidiSQL.
-
Analyze Cvent Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Cvent data and visualize live Cvent data in Infragistics Reveal.
-
Integrate SAP ByDesign with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP ByDesign with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP ByDesign data.
-
Query, Visualize, and Share live Toggl Data in Redash
Use CData Connect AI to connect to live Toggl data in Redash for querying, visualizing, and sharing.
-
Integrate Dify with Live Campaigner 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 Campaigner data.
-
How to Use a Microsoft Access Database to Update DB2 Data in Real Time
Update DB2 data by creating a linked table in Microsoft Access with the CData DB2 ODBC Driver.
-
Automated Continuous FreshBooks Replication to AlloyDB
Use CData Sync for automated, continuous, customizable FreshBooks replication to AlloyDB.
-
Enable the Odoo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Odoo data.
-
Replicate Exa Data from PowerShell
Write a quick PowerShell script to query Exa data. Use connectivity to the live data to replicate Exa data to SQL Server.
-
Feed Demio Data into FineReport
How to set Demio data as a JDBC data source in FineReport.
-
Use the CData Software JDBC Driver for Productboard in MicroStrategy Web
Connect to Productboard data in MicroStrategy Web using the CData Software JDBC Driver for Productboard.
-
Connect to MailerLite Data from PowerBuilder via ADO.NET
This article demonstrates how to access MailerLite data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Data Visualizations in Cognos BI with Pinecone Data
Access Pinecone data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build QuickBooks Time-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live QuickBooks Time data.
-
Access Live Facebook Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Facebook data into the statistical analysis tools available in SAS JMP. This article shows how to use Facebook data in the Graph Builder and Query Builder.
-
How to Access Live HBase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for HBase enables you to integrate HBase data into workflows built using Microsoft Power Automate Desktop.
-
Query, Visualize, and Share live Grafana Data in Redash
Use CData Connect AI to connect to live Grafana data in Redash for querying, visualizing, and sharing.
-
Build Automated Oracle HCM Cloud-Connected Workflows in Zapier
Use CData Connect AI to connect to live Oracle HCM Cloud data and build automated workflows in Zapier.
-
How to Connect DBeaver to QuickBooks Online via a JDBC Driver
Manage QuickBooks Online data with visual tools in DBeaver like the query browser.
-
How to Query Sendwithus Data in MySQL Workbench
Execute MySQL queries against live Sendwithus data from MySQL Workbench.
-
Analyze ZohoPeople Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZohoPeople data with the CData JDBC Driver for ZohoPeople.
-
Use Dash to Build Web Apps on ZohoPeople Data via CData Connect AI
Build interactive Dash web apps on live ZohoPeople data using pandas and the CData Connect AI Python SDK.
-
Connect to Auth0 in SpagoBI
Create reports featuring live Auth0 data in SpagoBI Studio. Host Auth0 reports on SpagoBI Server.
-
Build Semantic Layer Views for Tickspot Data in APOS Live Data Gateway
Use the CData Connector for Tickspot in APOS Live Data Gateway to build Semantic Layer Views for Tickspot data.
-
How to Connect to Live Couchbase Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Couchbase data for you.
-
Bind Live Asana Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Asana data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect and Query Live WooCommerce Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live WooCommerce data into Databricks and enable direct, live querying and analysis without replication.
-
How to Visualize Egnyte Data in Python with pandas
Use pandas and other modules to analyze and visualize live Egnyte data in Python.
-
Automate Zoho Recruit Data Replication to Azure Synapse
Use CData Sync to customize and automate Zoho Recruit data replication to Azure Synapse.
-
Create Oracle SCM-Connected Applications in Appsmith
Connect to Oracle SCM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle SCM data.
-
How to Easily Query Factorial Data in OpenOffice Base
Connect to Factorial data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData Software JDBC Driver for Recurly in MicroStrategy
Connect to Recurly data in MicroStrategy Developer using the CData Software JDBC Driver for Recurly.
-
Natively Connect to CampaignMonitor Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to CampaignMonitor data. Leverage the native support for ODBC in PHP.
-
Migrating data from Mailjet to Databricks using CData SSIS Components.
Easily push Mailjet data to Databricks using the CData SSIS Tasks for Mailjet and Databricks.
-
Query Oracle SCM Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle SCM entities in PHP by modeling them as objects.
-
Object-Relational Mapping (ORM) with Zoho CRM 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 Zoho CRM data into a Java-based ORM framework, Hibernate.
-
Build Salesforce Marketing-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Salesforce Marketing data and build web apps with connectivity to live Salesforce Marketing data.
-
Create Reports from Paymo Data in Looker Studio
Use CData Connect AI to gain access to live Paymo data and create custom reports in Looker Studio.
-
Visualize Live ZendeskSell Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ZendeskSell data.
-
Visualize Attio Data in Tableau
The CData ODBC driver for Attio enables you integrate Attio data into Tableau dashboards.
-
How to import Instagram Data into Apache Solr
Use the CData Software JDBC Driver for Instagram in Data Import Handler and create an automated import of Instagram data to Apache Solr Enterprise Search platform.
-
Connect to and Visualize Live Grafana Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Grafana data.
-
Connect and Query Live Oracle Sales Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Oracle Sales data into Databricks and enable direct, live querying and analysis without replication.
-
How to work with Spotify Data in Apache Spark using SQL
Access and process Spotify Data in Apache Spark using the CData Software JDBC Driver.
-
Edit and Search External Reckon Accounts Hosted Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Reckon Accounts Hosted data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Reckon Accounts Hosted Data objects that you can access from apps and the dashboard.
-
Automated Continuous SAS xpt Replication to SQLite
Use CData Sync for automated, continuous, customizable SAS xpt replication to SQLite.
-
Getting Started with the CData Connect AI Python SDK for Avalara AvaTax
Install the CData Connect AI Python SDK to read and write live Avalara AvaTax data with standard DB-API 2.0 Python code.
-
Analyze PostgreSQL Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of PostgreSQL data and visualize live PostgreSQL data in Infragistics Reveal.
-
Analyze Live Shopify Data in SAS Viya
Use CData Connect AI to connect to Shopify data from SAS Viya and deploy self-service analytics using live Shopify data.
-
Manage Avaza Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Avaza.
-
Import Real-Time ScrapingBee Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ScrapingBee data in ColdFusion.
-
Viewing HubSpot Data in RAD Studio Data Explorer
How to view HubSpot data in RAD Studio Data Explorer using the CData ODBC Driver for HubSpot.
-
How to connect PolyBase to Reckon
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Reckon data.