CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Teamwork
Provide connectivity to Teamwork data 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 data 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 data 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 data 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 data in the Power Pivot business intelligence tool.
-
Query Quickbase Data in DataGrip
Create a Data Source for Quickbase in DataGrip and use SQL to query live Quickbase data.
-
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 data from within the editor.
-
Query ElevenLabs Data as a MySQL Database in Node.js
Execute MySQL queries against ElevenLabs data from Node.js.
-
How to connect and process Scrapfly data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Scrapfly data.
-
Reckon Accounts Hosted Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Reckon Accounts Hosted data 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 data 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 Zoho Books data.
-
How to Access Live Odoo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Odoo enables you to integrate Odoo data 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 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.
-
Model Figshare Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Figshare, enabling the direct import of real-time Figshare data.
-
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 data 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 data in your FileMaker application.
-
Creating Acumatica-Connected Applications in Unqork
You can use CData Connect AI to feed Acumatica data 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 data 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.
-
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 data.
-
Access Live SAP Netweaver Gateway Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Netweaver Gateway data from your Excel spreadsheets.
-
Build Agents in Relevance AI with Access to Live Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Guru data within intelligent agent workflows.
-
Operational Reporting on LaunchDarkly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote LaunchDarkly data.
-
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 data 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 data.
-
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 data 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 data 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 data into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Apps from PingOne Data in Qlik Sense Cloud
Use CData Connect AI to connect to PingOne Data and build apps from live PingOne data in Qlik Sense Cloud.
-
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 Kafka data to a chart.
-
Replicate Aircall Data to Multiple Databases via the CData Sync CLI
Replicate Aircall data to disparate databases with a single configuration.
-
Integrating Boomi Agentstudio with SparkPost Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SparkPost data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
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 data.
-
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 OneNote data 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 data. 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 Hive data 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 data for self-service data analytics.
-
Use Dash to Build Web Apps on xBase Data via CData Connect AI
Build interactive Dash web apps on live xBase data using pandas and the CData Connect AI Python SDK.
-
ETL OneNote in Oracle Data Integrator
This article shows how to transfer OneNote data into a data warehouse using Oracle Data Integrator.
-
Validate LDAP Objects with QuerySurge
Access and validate LDAP objects 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 data.
-
How to Access Postmark Data Using Entity Framework
This article shows how to access Postmark data 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 data for self-service data analytics.
-
Extract, Transform, and Load Attio Data in Informatica PowerCenter
Create a simple Workflow for Attio data in Informatica PowerCenter.
-
Query Bright Data Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Bright Data data from Node.js.
-
Integrate Dify with Live Google Ads 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 Google Ads data.
-
Bridge SQL Analysis Services Connectivity with Apache NiFi
Access and process SQL Analysis Services data in Apache NiFi using the CData JDBC Driver.
-
Integrate Google's Vertex AI Agent with Live Blackbaud FE NXT 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 Blackbaud FE NXT data 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 data and execute queries in PowerBuilder.
-
How to connect SharePoint with Google Contacts Data through external lists
Provide Google Contacts data 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 data 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 data 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 data 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 data.
-
Access Live HCL Domino Data in Excel 365 Online (Excel for the web)
Connect to HCL Domino data 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 data 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 data.
-
Integrate Live Neo4J Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Neo4J data 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 data 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 data from your Excel spreadsheets.
-
Working with Supabase Data in LINQPad
Execute LINQ queries to Supabase data in LINQPad.
-
Access Live Timely Data in AWS Lambda
Connect to live Timely data in AWS Lambda using the CData JDBC Driver.
-
Import Mode Data Using Azure Data Factory
Use CData Connect AI to connect to Mode Data from Azure Data Factory and import live Mode data.
-
Working with Microsoft OneDrive Data in LINQPad
Execute LINQ queries to Microsoft OneDrive data 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 data 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 data in Dundas BI.
-
Connect to Live Certinia Data in MicroStrategy through CData Connect AI
Create a live connection to Certinia Data in CData Connect AI and connect to your Certinia data from MicroStrategy.
-
Salesloft Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Salesloft data through CData Connect AI using different applications and tools.
-
Connect to Nethunt Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Nethunt data.
-
How to publish and share Sage Cloud Accounting Data dashboards with Tableau Server
The CData ODBC driver for Sage Cloud Accounting enables you integrate Sage Cloud Accounting data into Tableau dashboards.
-
Automate Quaderno Data Replication to Azure Synapse
Use CData Sync to customize and automate Quaderno data replication to Azure Synapse.
-
Add SAP Concur Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Concur with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Microsoft Copilot Studio to talk to your WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your WordPress data for you.
-
Integrate Trae with Live NetSuite Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live NetSuite data from within the AI-powered IDE.
-
Automate Datadog Data Replication to SAP HANA
Use CData Sync to customize and automate Datadog data replication to SAP HANA.
-
Publish Crystal Reports on Nethunt Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Nethunt data.
-
Replicate Multiple Certinia Accounts via the CData Sync CLI
Replicate multiple Certinia accounts to one or many databases.
-
Work with ConvertKit Data in FoxPro
Load ConvertKit data into a FoxPro database. This article includes full code and a walk-through of the process.