CData Software - Knowledge Base
Recent Articles
-
Query, Visualize, and Share live Sage Cloud Accounting Data in Redash
Use CData Connect AI to connect to live Sage Business Cloud Accounting in Redash for querying, visualizing, and sharing.
-
Validate Jodoo Data with QuerySurge
Access and validate Jodoo in QuerySurge using the CData JDBC Driver.
-
IBM Cloud Object Storage Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to IBM Cloud Object Storage through CData Connect AI using different applications and tools.
-
Edit and Search External Google Analytics Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Analytics to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Analytics Data objects that you can access from apps and the dashboard.
-
How to Build an ETL App for Workday Data in Python with CData Connect AI
Build ETL pipelines that read and write live Workday in Python with petl and the CData Connect AI Python SDK.
-
Connect to Elorus 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 Elorus and work with Elorus in your FileMaker application.
-
Connect to Autopilot Data from PowerBuilder via ADO.NET
This article demonstrates how to access Autopilot from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to integrate SurveyMonkey with Apache Airflow
Access and process SurveyMonkey in Apache Airflow using the CData JDBC Driver.
-
Enable the Coda JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Coda.
-
Connect to ZohoExpense Data in CloverDX (formerly CloverETL)
Transfer ZohoExpense using the visual workflow in the CloverDX data integration tool.
-
Connect to Google Drive Data in CloverDX (formerly CloverETL)
Transfer Google Drive using the visual workflow in the CloverDX data integration tool.
-
Connect to ConstantContact Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData ODBC Driver for ConvertAPI from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ConvertAPI to connect to ConvertAPI from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ConvertAPI in Excel.
-
Manage Microsoft Ads Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft Ads.
-
Integrating Cursor CLI with Freshteam 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.
-
Object-Relational Mapping (ORM) with Landbot 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 Landbot into a Java-based ORM framework, Hibernate.
-
How to Use a Microsoft Access Database to Update Google Spanner Data in Real Time
Update Google Spanner data by creating a linked table in Microsoft Access with the CData Google Spanner ODBC Driver.
-
Integrate Mistral AI Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Mistral AI from Informatica Cloud.
-
Integrate Cline with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Azure Data Lake Storage from within your IDE.
-
How to create an RPA flow for Azure Data Catalog Data in UiPath Studio
Use the Azure Data Catalog ODBC Driver to create workflows that access real-time Azure Data Catalog without any coding.
-
Process & Analyze Mistral AI Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Mistral AI Data.
-
Feed Active Directory Data into FineReport
How to set Active Directory as a JDBC data source in FineReport.
-
Import and Visualize Outlook Data in Power View
Create data visualizations based on Outlook in Excel.
-
Connect to Browserless Data in JRuby
Create a simple JRuby app with access to live Browserless.
-
Build Voice Agents in ElevenLabs with access to Live SAP Hybris C4C Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP Hybris C4C.
-
Analyze ConstantContact Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ConstantContact in Microsoft R Open.
-
Integrate Goose with Live Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Exact Online from within the local AI agent.
-
Prepare, Blend, and Analyze OData Services in Alteryx Designer (Connect AI)
Build workflows to access live OData for self-service data analytics.
-
Connect and Visualize Live Couchbase Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Couchbase into the Databricks platform and create visualization dashboards with real-time Couchbase.
-
Integrate Open WebUI with Live FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live FreshBooks from within the chat interface.
-
Replicate Sybase Data from PowerShell
Write a quick PowerShell script to query Sybase. Use connectivity to the live data to replicate Sybase to SQL Server.
-
Connect to MYOB AccountRight Data from a Connection Pool in JBoss
Integrate MYOB AccountRight into Java servlets: Use the Management Console in JBoss to install the MYOB AccountRight JDBC Driver.
-
Create PayPal-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to PayPal Data from OutSystems and build custom enterprise apps using live PayPal.
-
Operational Reporting on Paddle Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Paddle.
-
How to create an RPA flow for CapsuleCRM Data in UiPath Studio
Use the CapsuleCRM ODBC Driver to create workflows that access real-time CapsuleCRM without any coding.
-
Use the CData Software ODBC Driver for Wrike in MicroStrategy
Connect to Wrike in MicroStrategy Developer using the CData Software ODBC Driver for Wrike.
-
Integrating NetSuite Data in Talend Cloud Data Management Platform
Connect NetSuite Data with Talend Cloud Data Management Platform using the CData JDBC Driver for NetSuite.
-
Integrating OpenCode Terminal with PabblySubscriptions 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.
-
Use the CData ODBC Driver for MongoDB in Microsoft Power Query
You can use the CData MongoDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MongoDB into Microsoft Power Query.
-
Analyze Azure Table Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Azure Table Storage and visualize Azure Table Storage in SAP Analytics Cloud.
-
Build Data Flows from ZohoSubscriptions to SQL Server using SSIS
Easily back up ZohoSubscriptions to SQL Server using the SSIS components for ZohoSubscriptions.
-
Build Dashboards with QuickBooks Online Data in Dundas BI
Create dynamic dashboards and perform analytics based on QuickBooks Online in Dundas BI.
-
Integrating Kiro CLI with SAP Netweaver Gateway 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 Oracle Eloqua Data in the Pentaho Report Designer
Publish reports based on Oracle Eloqua in the Pentaho BI tool.
-
Connect to SAP Ariba Source from Asprova with CData Software ODBC Driver for SAP Ariba Source
This article shows how to connect faster to SAP Ariba Source data from Asprova.
-
Access Live Quaderno Data in Coginiti Pro
Connect to and query live Quaderno from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to PhantomBuster Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PhantomBuster and the SQL Gateway to access PhantomBuster from Google Apps Script.
-
How to work with SAP Business Warehouse Data in Apache Spark using SQL
Access and process SAP Business Warehouse Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate with Azure Table Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Table Storage to a JSON file on disk.
-
Operational Reporting on Nethunt Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Nethunt.
-
Replicate Multiple SAP Ariba Procurement Accounts via the CData Sync CLI
Replicate multiple SAP Ariba Procurement accounts to one or many databases.
-
How to load Twitter Ads data into Elasticsearch via Logstash
Introducing a simple method to load Twitter Ads data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Prepare, Blend, and Analyze ScrapingBee Data in Alteryx Designer (ODBC)
Build workflows to access live ScrapingBee for self-service data analytics.
-
Integrating Codex CLI with Mailjet 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.
-
Use the CData Software JDBC Driver for Jira in MicroStrategy Desktop
Connect to Atlassian Jira in MicroStrategy Desktop using the CData Software JDBC Driver for Jira.
-
Bridge SAP Business Warehouse Connectivity with Apache NiFi
Access and process SAP Business Warehouse in Apache NiFi using the CData JDBC Driver.
-
Connect to ShipEngine Data in CloverDX (formerly CloverETL)
Transfer ShipEngine using the visual workflow in the CloverDX data integration tool.
-
Integrating Codex CLI with MailerLite 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.
-
Replicate Multiple Kintone Accounts via the CData Sync CLI
Replicate multiple Kintone accounts to one or many databases.
-
Analyze Blackbaud FE NXT Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Blackbaud FE NXT and visualize live Blackbaud FE NXT in Infragistics Reveal.
-
How to Connect to Live Sage Cloud Accounting Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Sage Business Cloud Accounting securely in real time.
-
Viewing Bannerbear Data in RAD Studio Data Explorer
How to view Bannerbear in RAD Studio Data Explorer using the CData ODBC Driver for Bannerbear.
-
Connect to FHIR Data in Claris FileMaker Pro
Use the CData ODBC Driver for FHIR in FileMaker Pro to connect to FHIR and work with FHIR in your FileMaker applications.
-
Build a PostgreSQL Interface for Scrapfly Data using the CData JDBC Driver
Use the Remoting features of the Scrapfly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import and Visualize Mistral AI Data in Power View
Create data visualizations based on Mistral AI in Excel.
-
How to Query Airtable Data in MySQL Workbench
Execute MySQL queries against live Airtable from MySQL Workbench.
-
A PostgreSQL Interface for Float Data (MySQL Remoting via JDBC)
Use the Remoting features of the Float JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Data Flows from Oracle Eloqua to SQL Server using SSIS
Easily back up Oracle Eloqua to SQL Server using the SSIS components for Oracle Eloqua.
-
Integrating Kiro CLI with Microsoft Dataverse 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.
-
Integrating LangChain with SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAS Data Sets within automated workflows.
-
Integrate with Reckon Accounts Hosted Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Reckon Accounts Hosted in SnapLogic.
-
Build Semantic Layer Views for Dropbox Data in APOS Live Data Gateway
Use the CData Connector for Dropbox in APOS Live Data Gateway to build Semantic Layer Views for Dropbox.
-
Automate Clockify Data Replication to SAP HANA
Use CData Sync to customize and automate Clockify replication to SAP HANA.
-
Design BIRT Reports on ConvertKit Data
Provide current ConvertKit to your embedded analytics.
-
How to Query Live Apify Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apify data in natural language using Python.
-
Use the CData ODBC Driver for Wistia in Microsoft Power Query
You can use the CData Wistia ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Wistia into Microsoft Power Query.
-
Create SAP BusinessObjects BI-Connected Nintex Workflows
Use CData Connect AI to connect to SAP BusinessObjects BI Data from Nintex Workflow Cloud and build custom workflows using live SAP BusinessObjects BI.
-
Connect to Google Forms Data from a Connection Pool in Jetty
The Google Forms JDBC Driver supports connection pooling: This article shows how to connect faster to Google Forms from Web apps in Jetty.
-
A PostgreSQL Interface for Reckon Data using the CData ODBC Driver
Use the SQL Gateway and Reckon ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Vault CRM from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Veeva Vault & Vault CRM, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData Excel Add-In for Bright Data
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Bright Data.
-
Use Biml to Build SSIS Tasks to Replicate Zoho Projects Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Projects to SQL Server.
-
Integrating GitHub Copilot CLI with ZohoDesk 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 a Singer.io Tap for Hugging Face With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Hugging Face data using
-
Analyze Twilio Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Twilio and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous HCL Domino Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable HCL Domino replication to Apache Kafka.
-
How to Connect to & Open eBay Analytics Data in Microsoft Excel
This article uses the CData ODBC driver for eBay Analytics to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Access Live ChartMogul Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ChartMogul enables you to integrate ChartMogul into workflows built using Microsoft Power Automate Desktop.
-
Moving Data from SFTP to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SFTP data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to and Query Oracle Sales Data in QlikView over ODBC
Create data visualizations with Oracle Sales in QlikView.
-
Getting Started with the CData Tableau Connector for Trello
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Trello.
-
Access Live MailChimp Data in Excel 365 Online (Excel for the web)
Connect to MailChimp from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Wave Financial Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Wave Financial replication to Amazon Redshift.
-
Create Datasets from Salesforce in Domo Workbench and Build Visualizations of Salesforce Data in Domo
Use the CData Software ODBC Driver for Salesforce to create datasets from Salesforce & Force.com in Domo Workbench and then build visualizations in the Domo service.
-
Analyze Parquet Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apache Parquet in Microsoft R Open.
-
How to Connect to Live Spark Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Apache Spark SQL through natural language.
-
Integrate Live FreeAgent Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live FreeAgent to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate with Salesforce Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Salesforce & Force.com in SnapLogic.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Exact Online
Provide connectivity to Exact Online through an SAP BusinessObjects universe.
-
Build Shopify-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Shopify Data from Zoho Analytics and import live Shopify.