CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Google Sheets in MicroStrategy
Connect to Google Sheets data in MicroStrategy Developer using the CData Software ODBC Driver for Google Sheets.
-
Access Live FHIR Data in AWS Lambda
Connect to live FHIR data in AWS Lambda using the CData JDBC Driver.
-
Create Datasets from Teradata in Domo Workbench and Build Visualizations of Teradata Data in Domo
Use the CData Software ODBC Driver for Teradata to create datasets from Teradata data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Printify Data into Power Automate Desktop using CData Connect
CData Connect for Printify Data enables you to integrate Printify data into workflows built using Microsoft Power Automate Desktop.
-
Natively Connect to RabbitMQ Data in PHP
The CData ODBC driver for RabbitMQ enables you to create PHP applications with connectivity to RabbitMQ data. Leverage the native support for ODBC in PHP.
-
Query Adobe Commerce Data as a MySQL Database in Node.js
Execute MySQL queries against Adobe Commerce data from Node.js.
-
Build a Simple VCL Application for AlloyDB Data
How to build a simple VCL Application to view AlloyDB data in RAD Studio using the CData ODBC Driver for AlloyDB.
-
Process & Analyze Zoho Creator Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zoho Creator Data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Invoiced
Provide connectivity to Invoiced data through an SAP BusinessObjects universe.
-
How to Build an ETL App for LinkedIn Data in Python with CData Connect AI
Build ETL pipelines that read and write live LinkedIn data in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous Elasticsearch Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Apache Cassandra.
-
Build Yelp-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Yelp data and build Yelp-connected web apps with Axios.
-
Integrate Live Quickbase Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Quickbase data and integrate live Quickbase data into apps built in Microsoft Power Apps.
-
Excel Spreadsheet Automation on LinkedIn Ads Data with the QUERY Formula
Pull data from LinkedIn Ads, automate spreadsheets, and more with the QUERY formula.
-
How to Work with SageHR Data in ETL Validator JDBC
Connect to SageHR from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Work with Microsoft Exchange Data in ETL Validator JDBC
Connect to Microsoft Exchange from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Email Replication to Databricks
Use CData Sync for automated, continuous, customizable Email replication to Databricks.
-
Publish Crystal Reports on GetResponse Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date GetResponse data.
-
How to create GraphQL federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for GraphQL data in MySQL .
-
Automated Amazon S3 Data Replication to Teradata
Use CData Sync to Customize and automate Amazon S3 data replication to Teradata.
-
How to create an RPA flow for Optimizely Data in UiPath Studio
Use the Optimizely ODBC Driver to create workflows that access real-time Optimizely data without any coding.
-
Import Real-Time PagerDuty Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use PagerDuty data in ColdFusion.
-
Automate GitLab Data Replication to SAP HANA
Use CData Sync to customize and automate GitLab data replication to SAP HANA.
-
How to connect PolyBase to Telegram
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Telegram data.
-
Automated Continuous Google Calendar Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Calendar replication to Vertica.
-
Validate ActiveCampaign Data with QuerySurge
Access and validate ActiveCampaign data in QuerySurge using the CData JDBC Driver.
-
Working with Reply.io Data in LINQPad
Execute LINQ queries to Reply.io data in LINQPad.
-
Access WooCommerce 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 WooCommerce data.
-
Operational Reporting on Teamgate Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Teamgate data.
-
Access Live Zendesk Data in TIBCO Data Virtualization
Use the Zendesk Tibco DV Adapter to create a Zendesk data data source in TIBCO Data Virtualization Studio and gain access to live Zendesk data from your TDV Server.
-
Access Live Zoho Creator Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoho Creator data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Access Workable Data Using Entity Framework
This article shows how to access Workable data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Claude Code CLI with SAP Business One 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 Live Perplexity Data in Excel 365 Online (Excel for the web)
Connect to Perplexity data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData Software JDBC Driver for MYOB AccountRight in MicroStrategy
Connect to MYOB AccountRight data in MicroStrategy Developer using the CData Software JDBC Driver for MYOB AccountRight.
-
Integrate with Ontraport Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Ontraport data to a JSON file on disk.
-
Use Manus AI to Talk to Your Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Jira Assets data.
-
How to Connect to Live BenchmarkEmail Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live BenchmarkEmail data securely in real time.
-
Connect to and Visualize Live Pinterest Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pinterest data.
-
Create Power BI Reports on Real-Time JSON Services
Use the CData ODBC Driver for JSON to visualize JSON services in Power BI Desktop.
-
Automated Continuous Pipeline CRM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Google Cloud SQL.
-
Prepare, Blend, and Analyze ZarMoney Data in Alteryx Designer (ODBC)
Build workflows to access live ZarMoney data for self-service data analytics.
-
Getting Started with the CData JDBC Driver for Typeform
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Typeform.
-
Automated Continuous ChartMogul Replication to SQLite
Use CData Sync for automated, continuous, customizable ChartMogul replication to SQLite.
-
Query Mistral AI Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Mistral AI data from Node.js.
-
Automated Continuous PayPal Replication to AlloyDB
Use CData Sync for automated, continuous, customizable PayPal replication to AlloyDB.
-
Automated Continuous BenchmarkEmail Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Apache Cassandra.
-
Create Dynamic Box Grids Using the Infragistics XamDataGrid
Learn how you can connect Box to Infragistics XamDataGrid to build dynamic grids.
-
Rapidly Develop Phoenix-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 Phoenix.
-
How to integrate Hacker News with Apache Airflow
Access and process Hacker News data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Facebook Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Facebook replication to Google Cloud SQL.
-
Connecting Agentforce with Perplexity 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 Perplexity data for you.
-
Replicate Guru Data from PowerShell
Write a quick PowerShell script to query Guru data. Use connectivity to the live data to replicate Guru data to SQL Server.
-
Automated Continuous Zoho CRM Replication to Vertica
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Vertica.
-
Validate CockroachDB Data with QuerySurge
Access and validate CockroachDB data in QuerySurge using the CData JDBC Driver.
-
Connect to ConstantContact Data in Aqua Data Studio
Access ConstantContact data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Google Drive Data from MySQL in Amazon QuickSight
Connect to Google Drive and build visualizations of Google Drive data using a MySQL Connection in Amazon QuickSight.
-
Access Aircall Data from MySQL in PHP
Connect to Aircall through the standard MySQL libraries in PHP.
-
Automate Freshdesk Data Replication to Azure Synapse
Use CData Sync to customize and automate Freshdesk data replication to Azure Synapse.
-
Choosing the Best Method to Connect Blackbaud FE NXT to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Blackbaud FE NXT data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Gong Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Gong data into the statistical analysis tools available in SAS JMP. This article shows how to use Gong data in the Graph Builder and Query Builder.
-
Integrate Google's Vertex AI Agent with Live Reckon Accounts Hosted 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 Reckon Accounts Hosted data within intelligent workflows.
-
Visualize GetResponse Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to GetResponse data.
-
Connect to and Visualize Live Highrise Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Highrise data.
-
Connect to and Visualize Live OneNote Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live OneNote data.
-
Natively Connect to HDFS Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to HDFS data. Leverage the native support for ODBC in PHP.
-
Back Up Front data 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 Front data data.
-
Automated Continuous Missive Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Missive replication to Google BigQuery.
-
Integrating LangGraph with Printify Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Printify data within automated workflows.
-
Getting Started with the CData JDBC Driver for ConvertKit
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ConvertKit.
-
Automated Continuous Avaza Replication to MySQL
Use CData Sync for automated, continuous, customizable Avaza replication to MySQL.
-
Integrate Live Avalara AvaTax 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 Avalara AvaTax data from within the IDE.
-
Integrate Google's Vertex AI Agent with Live Exa 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 Exa data within intelligent workflows.
-
Automated Continuous XML Replication to Vertica
Use CData Sync for automated, continuous, customizable XML replication to Vertica.
-
Configure the CData JDBC Driver for Adobe Analytics in a Connection Pool in Tomcat
Connect to Adobe Analytics data from a connection pool in Tomcat.
-
Build Semantic Layer Views for Microsoft Entra ID Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Entra ID data.
-
Visualize Sybase IQ 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 Sybase IQ data into TIBCO Spotfire.
-
Build Automated Workflows with Live Active Directory Data in Workato
Use CData Connect AI to connect to live Active Directory data and build automated workflows in Workato.
-
Extract, Transform, and Load HubSpot Data in Informatica PowerCenter
Create a simple Workflow for HubSpot data in Informatica PowerCenter.
-
Automated Continuous ZeroBounce Replication to SQLite
Use CData Sync for automated, continuous, customizable ZeroBounce replication to SQLite.
-
Connect to WordPress Data in Google Apps Script via Connect AI
Use CData Connect AI to access WordPress data in Google Apps Script.
-
How to connect to NASA Data with Squirrel SQL client
Connect to NASA data and execute queries in the Squirrel SQL Client.
-
Access Calendly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Calendly data from your Oracle system.
-
Connect to Mode in SpagoBI
Create reports featuring live Mode data in SpagoBI Studio. Host Mode reports on SpagoBI Server.
-
Automated Continuous Opsgenie Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Opsgenie replication to Amazon Redshift.
-
Connecting Moonlit Workflow with ZohoMarketingHub 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 ZohoMarketingHub data in real time.
-
Build Apps with Live Oracle data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle data into the Adalo platform and build custom mobile and web applications with real-time Oracle data.
-
Automate Freshteam Data Replication to Azure Synapse
Use CData Sync to customize and automate Freshteam data replication to Azure Synapse.
-
Getting Started with the CData Connect AI Python SDK for Google Contacts
Install the CData Connect AI Python SDK to read and write live Google Contacts data with standard DB-API 2.0 Python code.
-
Connect to SAP HANA Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP HANA data using standard SQL.
-
Extract, Transform, and Load Testmonitor Data in Informatica PowerCenter
Create a simple Workflow for Testmonitor data in Informatica PowerCenter.
-
How to import DocuSign Data into Apache Solr
Use the CData Software JDBC Driver for DocuSign in Data Import Handler and create an automated import of DocuSign data to Apache Solr Enterprise Search platform.
-
Query Live Zoho Projects 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 Zoho Projects data directly from the development environment.
-
How to Connect to Live Dynamics 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 Dynamics CRM data for you.
-
How to connect and process FTP data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live FTP data.
-
Stream ElevenLabs Data into Apache Kafka Topics
Access and stream ElevenLabs data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect to Factorial Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Factorial data. Leverage the pyodbc module for ODBC in Python.
-
Access Live Jira Assets Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Jira Assets data from your Google Sheets.
-
Visualize Live Shippo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Shippo data into custom reports in Power BI.
-
Bidirectional Access to Paylocity Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Paylocity data in Filemaker Pro for Mac or Windows.