CData Software - Knowledge Base
Recent Articles
-
Connect to Sugar CRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Import Real-Time Perplexity Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Perplexity in ColdFusion.
-
How to Visualize Apify Data in Python with pandas
Use pandas and other modules to analyze and visualize live Apify in Python.
-
How to Query Live SAP Netweaver Gateway Data in Perplexity MacOS Desktop
Connect to and query live SAP Netweaver Gateway Data in Perplexity Desktop using CData MCP Server.
-
How to Visualize Databricks Data in Python with pandas
Use pandas and other modules to analyze and visualize live Databricks in Python.
-
Integrate Goose with Live Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Google Analytics from within the local AI agent.
-
Use JayDeBeApi to access Adobe Analytics Data in Python
Use standard Python scripting and the development environment of your choice to access live Adobe Analytics.
-
Create Data Visualizations in Cognos BI with Superchat Data
Access Superchat as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Bitly Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Bitly and the SQL Gateway to access Bitly from Google Apps Script.
-
Build MVC Applications with Connectivity to SAP ByDesign Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP ByDesign from an ASP.NET MVC application.
-
Integrating OpenCode Terminal with Smartsheet 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.
-
How to import Omnisend Data into Apache Solr
Use the CData Software JDBC Driver for Omnisend in Data Import Handler and create an automated import of Omnisend to Apache Solr Enterprise Search platform.
-
Build a Singer.io Tap for Presto With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Presto data using
-
Work with Harvest Data in FoxPro
Load Harvest into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Visualizations of Zendesk Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zendesk in Birst.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Teamwork
Provide connectivity to Teamwork through an SAP BusinessObjects universe.
-
How to Access Live LightSpeedRetail Data in Power Automate Desktop via ODBC
The CData ODBC Driver for LightSpeedRetail enables you to integrate LightSpeedRetail into workflows built using Microsoft Power Automate Desktop.
-
Establish a Live Connection with Oracle HCM Cloud Data using Tableau Bridge
The CData ODBC Driver for Oracle HCM Cloud enables you to integrate live Oracle HCM Cloud into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to PostgreSQL Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for PostgreSQL in Airbyte.
-
Use CData Connect AI to Access Microsoft OneDrive Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Microsoft OneDrive in the Power Pivot business intelligence tool.
-
Working with PivotalTracker Data in LINQPad
Execute LINQ queries to PivotalTracker in LINQPad.
-
Query Quickbase Data in DataGrip
Create a Data Source for Quickbase in DataGrip and use SQL to query live Quickbase.
-
Integrate Cursor with Live MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live MySQL from within the editor.
-
Query ElevenLabs Data as a MySQL Database in Node.js
Execute MySQL queries against ElevenLabs from Node.js.
-
How to connect and process Scrapfly from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Scrapfly.
-
Reckon Accounts Hosted Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Reckon Accounts Hosted through CData Connect AI using different applications and tools.
-
Automated Continuous PayPal Replication to IBM DB2
Use CData Sync for automated, continuous, customizable PayPal replication to IBM DB2.
-
Build Apps with Live GraphQL Data Using the Low-Code Development Platform of Mendix
Connect GraphQL with Mendix to build apps using the CData JDBC Driver for GraphQL.
-
Create Data Visualizations Based On Zoho Books Data in Mode
Use CData Connect AI to connect to Zoho Books Data from Mode and build visualizations using live
-
How to Access Live Odoo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Odoo enables you to integrate Odoo ERP into workflows built using Microsoft Power Automate Desktop.
-
How to update Snowflake from Excel
This article explains how to transfer data from Excel to Snowflake using the Excel Add-In for Snowflake.
-
Integrating OpenCode Terminal with Azure Data Catalog 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 Data Flows from SQL Server to QuickBooks through SSIS
Easily push SQL Server data to QuickBooks using the CData SSIS Tasks for QuickBooks.
-
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 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 in your FileMaker application.
-
Creating Acumatica-Connected Applications in Unqork
You can use CData Connect AI to feed Acumatica ERP to Unqork and build custom business apps.
-
Add Snapchat Ads Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Snapchat Ads with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating LangGraph with NetSuite SuiteAnalytics Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on NetSuite SuiteAnalytics within automated workflows.
-
A PostgreSQL Interface for Missive Data (MySQL Remoting via JDBC)
Use the Remoting features of the Missive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect QuickBooks Online to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect QuickBooks Online with IBM WebSphere for seamless data integration and connectivity.
-
Edit and Search SuiteCRM External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SuiteCRM to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SuiteCRM objects that you can access from apps and the dashboard.
-
Automated Continuous SAS xpt Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAS xpt replication to SingleStore.
-
Build WordPress-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for WordPress Data and create custom apps in Mendix.
-
Automated Continuous Impala Replication to MySQL
Use CData Sync for automated, continuous, customizable Impala replication to MySQL.
-
Publish Bullhorn CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Bullhorn CRM.
-
Access Live SAP Netweaver Gateway Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Netweaver Gateway from your Excel spreadsheets.
-
Operational Reporting on LaunchDarkly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote LaunchDarkly.
-
Automated Continuous Azure DevOps Replication to Oracle
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Oracle.
-
Visualize Live Square Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Square using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
LINQ to ElevenLabs 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 ElevenLabs Data Provider.
-
Create Reports with SAS Data Sets Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAS Data Sets.
-
Connect to Instantly Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Instantly and work with Instantly in your FileMaker applications.
-
Connect to Float Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Float and the SQL Gateway to access Float from Google Apps Script.
-
Establish a Live Connection with FreshBooks Data using Tableau Bridge
The CData ODBC Driver for FreshBooks enables you to integrate live FreshBooks into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate Multiple Drip Accounts via the CData Sync CLI
Replicate multiple Drip accounts to one or many databases.
-
Automated Continuous GraphQL Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable GraphQL replication to Apache Cassandra.
-
DataBind Kafka Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Kafka with the DevExpress Windows Forms and Web controls to provide Apache Kafka to a chart.
-
Replicate Aircall Data to Multiple Databases via the CData Sync CLI
Replicate Aircall to disparate databases with a single configuration.
-
Integrate Discord with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Discord with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Discord.
-
Replicate Multiple Insightly Accounts
Replicate multiple Insightly accounts to one or many databases.
-
Integrating Claude Code with OneNote Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft OneNote within assisted coding and automated development workflows.
-
Natively Connect to Mailjet Data in PHP
The CData ODBC driver for Mailjet enables you to create PHP applications with connectivity to Mailjet. Leverage the native support for ODBC in PHP.
-
Connect to Hive Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Hive and the SQL Gateway to access Apache Hive from Google Apps Script.
-
Prepare, Blend, and Analyze Blackbaud FE NXT Data in Alteryx Designer (Connect AI)
Build workflows to access live Blackbaud FE NXT for self-service data analytics.
-
ETL OneNote in Oracle Data Integrator
This article shows how to transfer Microsoft OneNote into a data warehouse using Oracle Data Integrator.
-
Validate LDAP Objects with QuerySurge
Access and validate LDAP in QuerySurge using the CData JDBC Driver.
-
Create Salesforce Marketing-Connected Business Apps in AppSheet
Connect to Salesforce Marketing Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Salesforce Marketing Cloud.
-
How to Access Postmark Data Using Entity Framework
This article shows how to access Postmark using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Excel Data in HULFT Integrate
Connect to Excel as a JDBC data source in HULFT Integrate
-
Prepare, Blend, and Analyze AgileCRM Data in Alteryx Designer (ODBC)
Build workflows to access live AgileCRM for self-service data analytics.
-
Extract, Transform, and Load Attio Data in Informatica PowerCenter
Create a simple Workflow for Attio in Informatica PowerCenter.
-
Query Bright Data Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Bright Data from Node.js.
-
Connect Delighted Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Delighted using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Bridge SQL Analysis Services Connectivity with Apache NiFi
Access and process SQL Analysis Services in Apache NiFi using the CData JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Blackbaud FE NXT within intelligent workflows.
-
Connect to Nuclia Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Nuclia to connect to Nuclia and execute queries in PowerBuilder.
-
How to connect SharePoint with Google Contacts Data through external lists
Provide Google Contacts to SharePoint users as an external list.
-
Build Pipelines with Live Zoho Creator Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Zoho Creator from Google Cloud Data Fusion, enabling the integration of live Zoho Creator into the building and management of effective data pipelines.
-
Integrate with Presto Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Presto in SnapLogic.
-
Excel Spreadsheet Automation on Redis Data with the QUERY Formula
Pull data from Redis, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData Tableau Connector for ConstantContact
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData Software ODBC Driver for SendGrid in SAS for Real-Time Reporting and Analytics
Connect to real-time SendGrid in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SendGrid.
-
Integrating Dataiku with Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Airtable.
-
Access Live HCL Domino Data in Excel 365 Online (Excel for the web)
Connect to HCL Domino from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Configure the CData JDBC Driver for MySQL in a Connection Pool in Tomcat
Connect to MySQL from a connection pool in Tomcat.
-
Write a Simple Go Application to work with Intercom Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Intercom.
-
Integrate Live Neo4J Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Neo4J to Blue Prism using the CData ODBC Driver for Neo4J to create automated workflows for repetitive business tasks.
-
Migrating data from Nethunt to Google BigQuery using CData SSIS Components.
Easily push Nethunt to Google BigQuery using the CData SSIS Tasks for Nethunt and Google BigQuery.
-
Access Live Shopify Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Shopify from your Excel spreadsheets.
-
Working with Supabase Data in LINQPad
Execute LINQ queries to Supabase in LINQPad.
-
Access Live Timely Data in AWS Lambda
Connect to live Timely in AWS Lambda using the CData JDBC Driver.
-
Use the CData API Server to Access Trello Data in Microsoft PowerPivot
Use the CData API Server to connect to live Trello in the Power Pivot business intelligence tool.
-
Working with Microsoft OneDrive Data in LINQPad
Execute LINQ queries to Microsoft OneDrive in LINQPad.
-
Consume SharePoint OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SharePoint feeds that reflect any changes in SAP Lumira.
-
Manage Access Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Access.
-
Automated Continuous ZarMoney Replication to MySQL
Use CData Sync for automated, continuous, customizable ZarMoney replication to MySQL.
-
Connect to Freshservice Data in Ruby
Connect to Freshservice in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData JDBC Driver for Amplitude
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Amplitude.
-
Replicate Multiple Email Accounts
Replicate multiple Email accounts to one or many databases.
-
Build Dashboards with SAP SuccessFactors LMS Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP SuccessFactors LMS in Dundas BI.