CData Software - Knowledge Base
Recent Articles
-
Integrate with live SAP Business Warehouse Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP Business Warehouse data in Jitterbit.
-
How to Connect to Live SAS xpt Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAS xpt data for you.
-
Build ZohoPeople Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ZohoPeople data and build visualizations in Tableau.
-
Bridge Google Drive Connectivity with Apache NiFi
Access and process Google Drive data in Apache NiFi using the CData JDBC Driver.
-
Edit and Search External TaxJar Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of TaxJar data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create TaxJar Data objects that you can access from apps and the dashboard.
-
How to connect to Spotify Data from Spring Boot
Connect to Spotify in a Spring Boot Application using the CData API Driver for JDBC
-
Query Discourse Data in DataGrip
Create a Data Source for Discourse in DataGrip and use SQL to query live Discourse data.
-
How to connect to Guru Data with Squirrel SQL client
Connect to Guru data and execute queries in the Squirrel SQL Client.
-
Natively Connect to NetSuite Data in PHP
The CData ODBC driver for NetSuite enables you to create PHP applications with connectivity to NetSuite data. Leverage the native support for ODBC in PHP.
-
Import Real-Time Pipedrive Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Pipedrive data in ColdFusion.
-
Integrate Live ZohoDesk Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ZohoDesk data and integrate live ZohoDesk data into apps built in Microsoft Power Apps.
-
DataBind Charts to Amazon S3 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Amazon S3 data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Analyze Postmark Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Postmark from Power Pivot. You will use the Table Import Wizard to load Postmark data. You can visually build the import query or use any SQL supported by the driver.
-
Viewing ChartMogul Data in RAD Studio Data Explorer
How to view ChartMogul data in RAD Studio Data Explorer using the CData ODBC Driver for ChartMogul.
-
Use the CData ODBC Driver for Sage 200 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sage 200 to connect to Sage 200 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sage 200 data in Excel.
-
Build Dashboards with Drip Data in Dundas BI
Create dynamic dashboards and perform analytics based on Drip data in Dundas BI.
-
Choosing the Best Method to Connect Microsoft Exchange to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Exchange data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Add ServiceNow Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ServiceNow with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect Active Directory Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Active Directory data in real time using natural language.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Sheets
Create Google Sheets data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Bitbucket Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Bitbucket Data and connect to Bitbucket data in Akorbi Digital RunMyProcess.
-
How to integrate Smartsheet with Apache Airflow
Access and process Smartsheet data in Apache Airflow using the CData JDBC Driver.
-
How to Connect to & Open MYOB AccountRight Data in Microsoft Excel
This article uses the CData ODBC driver for MYOB AccountRight to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Seamlessly Import eBay Data into IBM SPSS Modeler
Integrate eBay data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect and process Splunk data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Splunk data.
-
Connect to Elorus Data in CloverDX (formerly CloverETL)
Transfer Elorus data using the visual workflow in the CloverDX data integration tool.
-
Visualize SAS Data Sets Data in TIBCO Spotfire through OData
Integrate SAS Data Sets data into dashboards in TIBCO Spotfire.
-
Integrating Cursor with OneNote 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.
-
Connect to Google Spanner Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Spanner data from HeidiSQL.
-
Replicate MailChimp Data to Multiple Databases via the CData Sync CLI
Replicate MailChimp data to disparate databases with a single configuration.
-
Integrating Teamwork Data in Talend Cloud Data Management Platform
Connect Teamwork Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Greenhouse-Connected Nintex Workflows
Use CData Connect AI to connect to Greenhouse Data from Nintex Workflow Cloud and build custom workflows using live Greenhouse data.
-
Access Live Phoenix Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Phoenix data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create a Data Access Object for Todoist Data using JDBI
A brief overview of creating a SQL Object API for Todoist data in JDBI.
-
Natively Connect to Aha! Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Aha! data. Leverage the native support for ODBC in PHP.
-
How to Connect to Live LinkedIn Ads Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your LinkedIn Ads data for you.
-
Access Live Reckon Accounts Hosted Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Reckon Accounts Hosted data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Visualize Foursquare Data in Sisense
Create an ElastiCube in Sisense app with access to Foursquare data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for HCL Domino
Provide connectivity to HCL Domino data through an SAP BusinessObjects universe.
-
Query Google Calendar Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Calendar data.
-
How to Use a Microsoft Access Database to Update Oracle Data in Real Time
Update Oracle data by creating a linked table in Microsoft Access with the CData Oracle ODBC Driver.
-
Integrate with Discord Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Discord data in SnapLogic.
-
Use the CData Software ODBC Driver for Planio in MicroStrategy Desktop
Connect to Planio data in MicroStrategy Desktop using the CData Software ODBC Driver for Planio.
-
Connect and Query Live Cloudflare Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Cloudflare data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Strava Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Strava data.
-
Analyze Discourse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Discourse data in Microsoft R Open.
-
Access Live Mailjet Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Mailjet data from your Google Sheets.
-
Query, Visualize, and Share live eBay Analytics Data in Redash
Use CData Connect AI to connect to live eBay Analytics data in Redash for querying, visualizing, and sharing.
-
How to connect and process Testmonitor data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Testmonitor data.
-
Process & Analyze Hacker News Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Hacker News Data.
-
Access Live Dynamics 365 Data in Coginiti Pro
Connect to and query live Dynamics 365 data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Theia IDE with Live Campaigner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Campaigner data from within the development environment.
-
Build Dashboards with MariaDB Data in Dundas BI
Create dynamic dashboards and perform analytics based on MariaDB data in Dundas BI.
-
Build a PostgreSQL Interface for Printful Data using the CData JDBC Driver
Use the Remoting features of the Printful JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Pipedrive Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Pipedrive data and build visualizations in Tableau Cloud.
-
Working with Oracle Eloqua Data in LINQPad
Execute LINQ queries to Oracle Eloqua data in LINQPad.
-
Build Voice Agents in ElevenLabs with access to Live Phoenix Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Phoenix data.
-
Connect to Sage 200 Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Sage 200 and the Script function in FileMaker Pro to connect to Sage 200 and work with Sage 200 data in your FileMaker application.
-
Access Live DocuSign Data in TIBCO Data Virtualization
Use the DocuSign Tibco DV Adapter to create a DocuSign data data source in TIBCO Data Virtualization Studio and gain access to live DocuSign data from your TDV Server.
-
Integrating Dataiku with GetResponse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live GetResponse data.
-
Excel Spreadsheet Automation on Neo4J Data with the QUERY Formula
Pull data from Neo4J, automate spreadsheets, and more with the QUERY formula.
-
Build Apps with Live Zoom Data Using the Low-Code Development Platform of Mendix
Connect Zoom data with Mendix to build apps using the CData API Driver for JDBC.
-
Access Live Redshift Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Redshift data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build a Simple VCL Application for Insightly Data
How to build a simple VCL Application to view Insightly data in RAD Studio using the CData ODBC Driver for Insightly.
-
Integrating LangGraph with Salesforce Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Salesforce data within automated workflows.
-
Visualize Live Zendesk Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zendesk data.
-
Operational Reporting on Amazon S3 Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Amazon S3 data.
-
Access Live Coinbase Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Coinbase data into the statistical analysis tools available in SAS JMP. This article shows how to use Coinbase data in the Graph Builder and Query Builder.
-
Access Live LinkedIn Ads Data in AWS Lambda
Connect to live LinkedIn Ads data in AWS Lambda using the CData JDBC Driver.
-
Integrate Workday with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Workday with External Services.
-
Operational Reporting on Todoist Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Todoist data.
-
How to Connect to Live Excel Online 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 Excel Online data for you.
-
Use the CData Software ODBC Driver for SAP Ariba Procurement in MicroStrategy Web
Connect to SAP Ariba Procurement data in MicroStrategy Web using the CData Software ODBC Driver for SAP Ariba Procurement.
-
Access Aha! 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 Aha! data.
-
Operational Reporting on Klaviyo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Klaviyo data.
-
View Reports on Real-Time Nethunt Data in Power BI Report Server
Use the CData ODBC Driver for Nethunt to visualize Nethunt data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous ZohoMarketingHub Replication to Databricks
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Databricks.
-
Integrating Codex with Adobe Target 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 Connect Flowise AI Agents to Live Zoho Creator Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Zoho Creator data without replication.
-
Automated Continuous Productboard Replication to SingleStore
Use CData Sync for automated, continuous, customizable Productboard replication to SingleStore.
-
How to Query Live Moosend Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Moosend data data in natural language using Python.
-
Build Semantic Layer Views for Google Cloud Storage Data in APOS Live Data Gateway
Use the CData Connector for Google Cloud Storage in APOS Live Data Gateway to build Semantic Layer Views for Google Cloud Storage data.
-
Query NetSuite Data through ODBC in Node.js
Use node-odbc to execute SQL queries against NetSuite data from Node.js.
-
Connect to CapsuleCRM Data in Ruby
Connect to CapsuleCRM data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Smartsheet from a Connection Pool in WebLogic
Use the CData JDBC Driver for Smartsheet to connect to Smartsheet data from Web applications running on WebLogic.
-
Create Power BI Reports on Real-Time Deel Data
Use the CData ODBC Driver for Deel to visualize Deel data in Power BI Desktop.
-
Migrating data from Basecamp to Google BigQuery using CData SSIS Components.
Easily push Basecamp data to Google BigQuery using the CData SSIS Tasks for Basecamp and Google BigQuery.
-
Integrating Cursor with Sage Cloud Accounting 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 Create Power BI Visual Reports with Real-Time MailerLite Data
Use CData Power BI Connectors to visualize MailerLite data in Power BI.
-
DataBind Cloudant Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Cloudant with the DevExpress Windows Forms and Web controls to provide Cloudant data to a chart.
-
Build Automated Square-Connected Workflows in Zapier
Use CData Connect AI to connect to live Square data and build automated workflows in Zapier.
-
How to update Spark from Excel
This article explains how to transfer data from Excel to Spark using the Excel Add-In for Spark.
-
Access SendGrid 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 SendGrid data.
-
How to Build an ETL App for Lakebase Data in Python with CData Connect AI
Build ETL pipelines that read and write live Lakebase data in Python with petl and the CData Connect AI Python SDK.
-
Getting Started with the CData Tableau Connector for TaxJar
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for TaxJar.
-
Create Data Visualizations in Cognos BI with ActiveCampaign Data
Access ActiveCampaign data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect and Query Live WordPress Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live WordPress data into Databricks and enable direct, live querying and analysis without replication.
-
How to Work with Google Directory Data in AWS Glue Jobs Using JDBC
Connect to Google Directory from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Adobe Commerce Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Adobe Commerce data and integrate live Adobe Commerce data into your Power Automate tasks.
-
Integrate Google's Vertex AI Agent with Live Gmail 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 Gmail data within intelligent workflows.