CData Software - Knowledge Base
Recent Articles
-
Connect to Asana from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Asana, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Pipeline CRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Pipeline CRM as an External Source in Dremio.
-
How to Connect Flowise AI Agents to Live Zoom 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 Zoom without replication.
-
Connect to and Query FreshBooks Data in QlikView over ODBC
Create data visualizations with FreshBooks in QlikView.
-
Build Agents in Relevance AI with Access to Live Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Spanner within intelligent agent workflows.
-
Connect to MarkLogic Data from Crystal Reports
Use CData Connect AI to connect to and report on live MarkLogic from Crystal Reports.
-
Create Informatica Mappings From/To an ODBC Data Source for Klaviyo
Create an ODBC connection to Klaviyo in Informatica and browse and transfer Klaviyo.
-
Automated Continuous IBM Cloud Object Storage Replication to IBM DB2
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to IBM DB2.
-
Integrate with Live Monday.com Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Monday.com from the MuleSoft Anypoint Platform to integrate live Monday.com into custom reports and dashboards.
-
Connect to Live ShipStation Data in MicroStrategy through CData Connect AI
Create a live connection to ShipStation Data in CData Connect AI and connect to your ShipStation from MicroStrategy.
-
Access FreshBooks 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 FreshBooks.
-
Build AI/ML Models with Live Scrapfly Data using Dataiku
Connect Scrapfly Data with Dataiku using the CData API Driver for JDBC.
-
How to publish and share Guru Data dashboards with Tableau Server
The CData ODBC driver for Guru enables you integrate Guru into Tableau dashboards.
-
Use the CData Software ODBC Driver for Zoho CRM in MicroStrategy Desktop
Connect to Zoho CRM in MicroStrategy Desktop using the CData Software ODBC Driver for Zoho CRM.
-
Use JayDeBeApi to access Pipeline CRM Data in Python
Use standard Python scripting and the development environment of your choice to access live Pipeline CRM.
-
Publish ConvertKit-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ConvertKit.
-
Automated Continuous Pingdom Replication to MongoDB
Use CData Sync for automated, continuous, customizable Pingdom replication to MongoDB.
-
Automate Sybase IQ Data Replication to Couchbase
Use CData Sync to Customize and automate Sybase IQ replication to Couchbase.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for HelloSign
Provide connectivity to HelloSign through an SAP BusinessObjects universe.
-
Import Real-Time Recurly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Recurly in ColdFusion.
-
Visualize PagerDuty Data in TIBCO Spotfire through ADO.NET
Integrate PagerDuty into dashboards in TIBCO Spotfire.
-
Replicate Multiple Dynamics 365 Business Central Accounts
Replicate multiple Dynamics 365 Business Central accounts to one or many databases.
-
How to Access Live ConstantContact Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ConstantContact enables you to integrate ConstantContact into workflows built using Microsoft Power Automate Desktop.
-
Feed Pinecone Data into FineReport
How to set Pinecone as a JDBC data source in FineReport.
-
Easily Integrate Amazon Marketplace Data in Lazarus Pascal IDE
Learn how to easily integrate live Amazon Marketplace in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Bind Live RSS Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live RSS data
-
Visualize Asana Data in Tableau
The CData ODBC driver for Asana enables you integrate Asana into Tableau dashboards.
-
How to connect to Mode Data from IntelliJ
Integrate connectivity to Mode with wizards in IntelliJ.
-
Natively Connect to Todoist Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Todoist. Leverage the native support for ODBC in PHP.
-
Integrating Claude Code CLI with Bannerbear 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.
-
Create Dynamic CircleCI Grids Using the Infragistics XamDataGrid
Learn how you can connect CircleCI to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Snapchat Ads Data from AWS Glue
Use CData Connect AI to gain access to live Snapchat Ads from your AWS Glue jobs.
-
Use the CData ODBC Driver for eBay from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for eBay to connect to eBay from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring eBay in Excel.
-
Use the CData API Server to Access SAP Ariba Procurement Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP Ariba Procurement in the Power Pivot business intelligence tool.
-
Operational Reporting on Aweber Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Aweber.
-
Integrating Boomi Agentstudio with API Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to API, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live CouchDB Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Apache CouchDB from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Salesforce Marketing Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Salesforce Marketing Cloud through MCP integration.
-
How to create an RPA flow for Reckon Data in UiPath Studio
Use the Reckon ODBC Driver to create workflows that access real-time Reckon without any coding.
-
Connect to Campaigner from Asprova with CData Software ODBC Driver for Campaigner
This article shows how to connect faster to Campaigner data from Asprova.
-
Access Live Short.io Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Short.io in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live Zoho Inventory Data in Coginiti Pro
Connect to and query live Zoho Inventory from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Real-Time Sage Intacct Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sage Intacct and Dataflow to import and use Sage Intacct in Power Apps.
-
Connect to Google Forms Data from PowerBuilder via JDBC
This article demonstrates how to access Google Forms from PowerBuilder using the Google Forms JDBC Driver.
-
Access Live Templated Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Templated into the statistical analysis tools available in SAS JMP. This article shows how to use Templated in the Graph Builder and Query Builder.
-
Connect to Twilio Data from a Connection Pool in JBoss
Integrate Twilio into Java servlets: Use the Management Console in JBoss to install the Twilio JDBC Driver.
-
Create Paylocity-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Paylocity Data from Klipfolio and build custom visualizations using live Paylocity.
-
Use Grok to Talk to Your Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Gmail for you.
-
Connect to Microsoft Planner from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Planner, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData Tableau Connector for Clockify
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData API Server to Access Greenhouse Data in Microsoft PowerPivot
Use the CData API Server to connect to live Greenhouse in the Power Pivot business intelligence tool.
-
Query Quickbase Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Quickbase from Node.js.
-
Query Live Raisers Edge NXT 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 Raisers Edge NXT directly from the development environment.
-
Connect to Suadeo Data in Claris FileMaker Pro
Use the CData ODBC Driver for Suadeo in FileMaker Pro to connect to Suadeo and work with Suadeo in your FileMaker applications.
-
Integrating Antigravity CLI with Azure Data Lake Storage via CData CLI
Connect Azure Data Lake Storage to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Add Auth0 Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Auth0 with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Informatica Mappings From/To a JDBC Data Source for Instagram
Create Instagram data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Import Real-Time Lakebase Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Lakebase in ColdFusion.
-
Automate Copper Data Replication to Azure Synapse
Use CData Sync to customize and automate Copper replication to Azure Synapse.
-
Build SharePoint Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft SharePoint and build visualizations in Tableau.
-
Operational Reporting on Sendwithus Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sendwithus.
-
How to connect to Zoom Data with Squirrel SQL client
Connect to Zoom and execute queries in the Squirrel SQL Client.
-
Build MVC Applications with Connectivity to Exact Online Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Exact Online from an ASP.NET MVC application.
-
Integrating Dataiku with Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Vertica.
-
Use the CData Software JDBC Driver for Paymo in MicroStrategy
Connect to Paymo in MicroStrategy Developer using the CData Software JDBC Driver for Paymo.
-
Access Freshsales Data from MySQL in PHP
Connect to Freshsales through the standard MySQL libraries in PHP.
-
Connect to Unbounce Data in Ruby
Connect to Unbounce in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Bridge Gong Connectivity with Apache NiFi
Access and process Gong in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Amazon Marketplace Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to PostgreSQL.
-
Integrate Cline with Live Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Dropbox from within your IDE.
-
Enable the Tickspot JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Tickspot.
-
Connect to and Query DocuSign Data in QlikView over ODBC
Create data visualizations with DocuSign in QlikView.
-
Build Asana-Connected Apps in Choreo
Use CData Connect AI to connect to Asana Data from Choreo and build custom apps using live Asana.
-
Access Facebook Data from MySQL in Amazon QuickSight
Connect to Facebook and build visualizations of Facebook using a MySQL Connection in Amazon QuickSight.
-
Load Amazon Marketplace Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon Marketplace to a database.
-
How to integrate Metabase with FHIR Data
Use CData Connect AI to connect to live FHIR and create an interactive dashboard in Metabase from FHIR.
-
Validate Opsgenie Data with QuerySurge
Access and validate Opsgenie in QuerySurge using the CData JDBC Driver.
-
Analyze Blackbaud FE NXT Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Blackbaud FE NXT with the CData JDBC Driver for Blackbaud FE NXT.
-
Connect to Zuora Data from a Connection Pool in JBoss
Integrate Zuora into Java servlets: Use the Management Console in JBoss to install the Zuora JDBC Driver.
-
How to Work with Wistia Data in AWS Glue Jobs Using JDBC
Connect to Wistia from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Xero-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Xero to explore live Xero Data in Cursor to assist with building Xero-powered applications.
-
Integrate Vault CRM Data in Pentaho Data Integration
Build ETL pipelines based on Veeva Vault & Vault CRM in the Pentaho Data Integration tool.
-
Build IBM Informix-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live IBM Informix.
-
Provide OData Services of Coinbase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Coinbase by developing a WCF Service Application.
-
Connect to Pingdom from Asprova with CData Software ODBC Driver for Pingdom
This article shows how to connect faster to Pingdom data from Asprova.
-
DataBind Charts to Browserless Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Browserless 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.
-
Integrating OpenCode Terminal with Beeminder 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 Auth0 Data in the Pentaho Report Designer
Publish reports based on Auth0 in the Pentaho BI tool.
-
A PostgreSQL Interface for Parallel Data using the CData ODBC Driver
Use the SQL Gateway and Parallel ODBC Driver to create a PostgreSQL entry-point for data access.
-
Moving Data from Float to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Float data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Excel Spreadsheet Automation on Adobe Analytics Data with the QUERY Formula
Pull data from Adobe Analytics, automate spreadsheets, and more with the QUERY formula.
-
Build a Simple VCL Application for Copper Data
How to build a simple VCL Application to view Copper in RAD Studio using the CData ODBC Driver for Copper.
-
Building Dynamic Web Pages with Azure Analysis Services Data Using AngularJS
Create single-page applications with live connectivity to Azure Analysis Services using the CData API Server.
-
Visualize Live Supabase Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Supabase using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live Oracle Service Cloud Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Oracle Service Cloud from your Excel spreadsheets.
-
Connect to Google Drive Data in ACL Analytics
Connect to Google Drive via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Drive.
-
How to create an RPA flow for ChartMogul Data in UiPath Studio
Use the ChartMogul ODBC Driver to create workflows that access real-time ChartMogul without any coding.
-
A PostgreSQL Interface for SAP HANA XS Advanced Data using the CData ODBC Driver
Use the SQL Gateway and SAP HANA XS Advanced ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Power BI Reports on Real-Time SAP HANA XS Advanced Data
Use the CData ODBC Driver for SAP HANA XS Advanced to visualize SAP HANA XS Advanced in Power BI Desktop.
-
Publish Crystal Reports on Excel Online Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Excel Online.