CData Software - Knowledge Base
Recent Articles
-
How to connect to BambooHR Data from Spring Boot
Connect to BambooHR in a Spring Boot Application using the CData API Driver for JDBC
-
Access Live SAP HANA XS Advanced Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP HANA XS Advanced into the statistical analysis tools available in SAS JMP. This article shows how to use SAP HANA XS Advanced in the Graph Builder and Query Builder.
-
Connect Tickspot Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Tickspot using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to publish and share MariaDB Data dashboards with Tableau Server
The CData ODBC driver for MariaDB enables you integrate MariaDB into Tableau dashboards.
-
Getting Started with the CData SSIS Components for Ontraport
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Ontraport.
-
Use the CData Software ODBC Driver for Act-On in MicroStrategy
Connect to Act-On in MicroStrategy Developer using the CData Software ODBC Driver for Act-On.
-
Getting Started with the CData ODBC Driver for Oracle
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Oracle.
-
Natively Connect to Billsby Data in PHP
The CData ODBC driver for Billsby enables you to create PHP applications with connectivity to Billsby. Leverage the native support for ODBC in PHP.
-
Feed Bitbucket Data into FineReport
How to set Bitbucket as a JDBC data source in FineReport.
-
Query SAS Data Sets Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAS Data Sets from Node.js.
-
Automate Postmark Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Postmark and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Analyze ZeroBounce Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of ZeroBounce and visualize live ZeroBounce in Infragistics Reveal.
-
Authorize.Net Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Authorize.Net through CData Connect AI using different applications and tools.
-
How to Create Power BI Visual Reports with Real-Time Pinecone Data
Use CData Power BI Connectors to visualize Pinecone in Power BI.
-
How to Connect to Live MailChimp Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your MailChimp for you.
-
Use Biml to Build SSIS Tasks to Replicate Access Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Access to SQL Server.
-
Query FreeAgent Data as a MySQL Database in Node.js
Execute MySQL queries against FreeAgent from Node.js.
-
Build an OLAP Cube in SSAS from Lakebase Data
Establish a connection to Lakebase data from SQL Server Analysis Services, and use the Lakebase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Migrating data from Mouseflow to Databricks using CData SSIS Components.
Easily push Mouseflow to Databricks using the CData SSIS Tasks for Mouseflow and Databricks.
-
Use the CData Software ODBC Driver for Toggl in MicroStrategy Web
Connect to Toggl in MicroStrategy Web using the CData Software ODBC Driver for Toggl.
-
Object-Relational Mapping (ORM) with ZohoMarketingHub 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 ZohoMarketingHub into a Java-based ORM framework, Hibernate.
-
Building Dynamic Web Pages with Exact Online Data Using AngularJS
Create single-page applications with live connectivity to Exact Online using the CData API Server.
-
Onfleet Reporting in OBIEE with the Onfleet JDBC Driver
Deploy the Onfleet JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Bind Live Twitter Ads Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Twitter Ads data
-
DataBind Charts to Mailgun Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Mailgun 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.
-
Publish Crystal Reports on Clari Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Clari.
-
Automated Continuous CampaignMonitor Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Apache Cassandra.
-
How to Query Webflow Data in MySQL Workbench
Execute MySQL queries against live Webflow from MySQL Workbench.
-
Getting Started with the CData Python Connector for Billsby
Learn to install and license the CData Python Connector
-
Easily Integrate Bitly Data in Lazarus Pascal IDE
Learn how to easily integrate live Bitly in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Validate LightSpeedRetail Data with QuerySurge
Access and validate LightSpeedRetail in QuerySurge using the CData JDBC Driver.
-
Connect to SAP HANA from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP HANA, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Access Live Bullhorn CRM Data in Visual Studio Code via Cline
Run CData MCP Server for Bullhorn CRM on Windows Subsytem for Linux (WSL) and connect to live Bullhorn CRM from the Cline extension in Visual Studio Code.
-
Use Dash to Build to Web Apps on Presto Data
Create Python applications that use pandas and Dash to build Presto-connected web apps.
-
Access ZeroBounce Data from MySQL in Amazon QuickSight
Connect to ZeroBounce and build visualizations of ZeroBounce using a MySQL Connection in Amazon QuickSight.
-
Integrate with Salesforce Pardot Data in JReport Designer
Create charts and reports based on Salesforce Pardot in JReport Designer.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesforce Marketing
Provide connectivity to Salesforce Marketing Cloud through an SAP BusinessObjects universe.
-
Integrate Avalara AvaTax Data in the Pentaho Report Designer
Publish reports based on Avalara AvaTax in the Pentaho BI tool.
-
How to connect to ShipEngine Data with Squirrel SQL client
Connect to ShipEngine and execute queries in the Squirrel SQL Client.
-
DataBind Controls to ActiveCampaign Data in Delphi
DataBind to ActiveCampaign in Delphi with standard data access components and controls.
-
Publish Paylocity-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Paylocity.
-
Create Notion Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Notion data access from reports, embedded analytics, and more.
-
Optimizely Reporting in OBIEE with the Optimizely JDBC Driver
Deploy the Optimizely JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Import Real-Time Office 365 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Office 365 in ColdFusion.
-
How to Seamlessly Import PolarTeamPro Data into IBM SPSS Modeler
Integrate PolarTeamPro data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Vercel Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Vercel and the SQL Gateway to access Vercel from Google Apps Script.
-
Validate Wistia Data with QuerySurge
Access and validate Wistia in QuerySurge using the CData JDBC Driver.
-
Connect to Stripe Data in CloverDX (formerly CloverETL)
Transfer Stripe using the visual workflow in the CloverDX data integration tool.
-
Analyze Procore Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Procore in Microsoft R Open.
-
Integrating Claude Code with Slack Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Slack within assisted coding and automated development workflows.
-
How to Access Live EnterpriseDB Data in Power Automate Desktop via ODBC
The CData ODBC Driver for EnterpriseDB enables you to integrate EnterpriseDB into workflows built using Microsoft Power Automate Desktop.
-
Integrating OpenCode Terminal with Microsoft Planner 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 Miro Data in DBeaver
Use the CData ODBC Driver to connect to Miro in DBeaver.
-
How to create Shippo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Shippo in MySQL .
-
Replicate CampaignMonitor Data from PowerShell
Write a quick PowerShell script to query CampaignMonitor. Use connectivity to the live data to replicate CampaignMonitor to SQL Server.
-
Use the CData Software ODBC Driver for Kintone in SAS for Real-Time Reporting and Analytics
Connect to real-time Kintone in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Kintone.
-
Use Dash to Build to Web Apps on Dynamics 365 Data
Create Python applications that use pandas and Dash to build Dynamics 365-connected web apps.
-
Connect to Productboard Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Productboard.
-
Consume Landbot OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Landbot feeds that reflect any changes in SAP Lumira.
-
Access Live SAP SuccessFactors LMS Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP SuccessFactors LMS from your Excel spreadsheets.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP Netweaver Gateway
Create an ODBC connection to SAP Netweaver Gateway in Informatica and browse and transfer SAP Netweaver Gateway.
-
DataBind Controls to Airtable Data in C++Builder
DataBind to Airtable in C++Builder with standard components and controls.
-
Connecting Agentforce with Lakebase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Lakebase for you.
-
Integrating Codex CLI with NASA 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 work with HCL Domino Data in Apache Spark using SQL
Access and process HCL Domino Data in Apache Spark using the CData Software JDBC Driver.
-
Automate Tasks in Power Automate Using the CData API Server
Automate HubSpot actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to Act-On Data from AWS Glue
Use CData Connect AI to gain access to live Act-On from your AWS Glue jobs.
-
Query Mode Data in DataGrip
Create a Data Source for Mode in DataGrip and use SQL to query live Mode.
-
Viewing Moosend Data in RAD Studio Data Explorer
How to view Moosend in RAD Studio Data Explorer using the CData ODBC Driver for Moosend.
-
Build SQL Analysis Services Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SQL Analysis Services and build visualizations in Tableau Cloud.
-
How to Connect to & Open Chargebee Data in Microsoft Excel
This article uses the CData ODBC driver for Chargebee to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Import MailerLite Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access MailerLite. In this article, you will use the OData format to import MailerLite into Microsoft Power Query.
-
Integrate Outlook with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Outlook with External Services.
-
Connect to FormSite Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for FormSite in the Denodo Virtual DataPort Administrator.
-
Query Timely Data in ColdFusion
Write standard ColdFusion data access code to connect to Timely.
-
Access Live BigQuery Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google BigQuery into the statistical analysis tools available in SAS JMP. This article shows how to use Google BigQuery in the Graph Builder and Query Builder.
-
Build Automated Workflows with Live SharePoint Data in Workato
Use CData Connect AI to connect to live Microsoft SharePoint and build automated workflows in Workato.
-
Validate Salesforce Data 360 Data with QuerySurge
Access and validate Salesforce Data 360 in QuerySurge using the CData JDBC Driver.
-
Create SSAS Tabular Models from Rebilly Data
How to build a SQL Server Analysis Service Tabular Model from Rebilly using CData drivers.
-
A PostgreSQL Interface for Google Search Results (MySQL Remoting via JDBC)
Use the Remoting features of the Google Search JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Sybase IQ 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 Sybase IQ for you.
-
Connect to Perigon Data in Aqua Data Studio
Access Perigon from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect DBeaver to Aha! via a JDBC Driver
Manage Aha! with visual tools in DBeaver like the query browser.
-
Moving Data from Ontraport to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Ontraport data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData API Server to Access Paymo Data in Microsoft PowerPivot
Use the CData API Server to connect to live Paymo in the Power Pivot business intelligence tool.
-
Use the CData API Server to Access Attio Data in Microsoft PowerPivot
Use the CData API Server to connect to live Attio in the Power Pivot business intelligence tool.
-
Extend Google Sheets with Salesforce CRM Analytics Data
Make calls to Salesforce CRM Analytics from Google Apps Script via the API Server.
-
Connect to ClickTime Data in DBeaver
Use the CData ODBC Driver to connect to ClickTime in DBeaver.
-
Use the CData Software JDBC Driver for eBay Analytics in MicroStrategy
Connect to eBay Analytics in MicroStrategy Developer using the CData Software JDBC Driver for eBay Analytics.
-
Excel Spreadsheet Automation on Coinbase Data with the QUERY Formula
Pull data from Coinbase, automate spreadsheets, and more with the QUERY formula.
-
How to Visualize ChartMogul Data in Python with pandas
Use pandas and other modules to analyze and visualize live ChartMogul in Python.
-
Connect and Visualize Live Excel Online Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Excel Online into the Databricks platform and create visualization dashboards with real-time Microsoft Excel Online.
-
Connect and Visualize Live Redshift Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Amazon Redshift into the Databricks platform and create visualization dashboards with real-time Amazon Redshift.
-
LINQ to Google Drive 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 Google Drive Data Provider.
-
Consume Adobe Commerce OData Feeds in PowerBuilder
This article demonstrates how to consume Adobe Commerce as OData feeds from PowerBuilder using the API Server.
-
Create Nuclia Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Nuclia data access from reports, embedded analytics, and more.
-
Connecting Mastra with ADP Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time ADP, no replication required.
-
Configure the CData JDBC Driver for Pingdom in a Connection Pool in Tomcat
Connect to Pingdom from a connection pool in Tomcat.
-
Query MessageBird Data through ODBC in Node.js
Use node-odbc to execute SQL queries against MessageBird from Node.js.
-
Work with Live Google Calendar Data in Power Query
Use CData Connect AI to connect to Google Calendar and work with live Google Calendar in Microsoft Power Query.