CData Software - Knowledge Base
Recent Articles
-
Excel Spreadsheet Automation on Customer.io Data with the QUERY Formula
Pull data from Customer.io, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData Tableau Connector for Adobe Target
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Adobe Target.
-
Natively Connect to Stack Exchange Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Stack Exchange. Leverage the native support for ODBC in PHP.
-
Build Visualizations of Wistia Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Wistia in Birst.
-
Connect Gong to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Gong using the CData Python MCP Server.
-
Bind Live Adobe Commerce Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Adobe Commerce data
-
Getting Started with the CData ODBC Driver for SAS xpt
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAS xpt.
-
Integrate Real-Time Access to Drift in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Drift in real time.
-
Build a Simple VCL Application for Beeminder Data
How to build a simple VCL Application to view Beeminder in RAD Studio using the CData ODBC Driver for Beeminder.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SAP HANA to Power BI dashboards. Simply drag and drop SAP HANA into data visuals on the Power BI canvas.
-
Create Informatica Mappings From/To a JDBC Data Source for MongoDB
Create MongoDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Stack Exchange Data in DataGrip
Create a Data Source for Stack Exchange in DataGrip and use SQL to query live Stack Exchange.
-
Access Live ZohoDesk Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ZohoDesk into the statistical analysis tools available in SAS JMP. This article shows how to use ZohoDesk in the Graph Builder and Query Builder.
-
Use the CData Software ODBC Driver for Twitter Ads in MicroStrategy Web
Connect to Twitter Ads in MicroStrategy Web using the CData Software ODBC Driver for Twitter Ads.
-
Create Informatica Mappings From/To an ODBC Data Source for Humanity
Create an ODBC connection to Humanity in Informatica and browse and transfer Humanity.
-
Access Live Salesforce Marketing Data in AWS Lambda
Connect to live Salesforce Marketing Cloud in AWS Lambda using the CData JDBC Driver.
-
Import Close Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Close. In this article, you will use the OData format to import Close into Microsoft Power Query.
-
Integrating OpenCode Terminal with SAS xpt 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.
-
Explore Geographical Relationships in Adobe Experience Manager Data with Power Map
Create data visualizations with Adobe Experience Manager in Power Map.
-
Build Tally Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Tally ERP and build visualizations in Tableau.
-
Create Datadog Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Datadog data access from reports, embedded analytics, and more.
-
Query Greenhouse Data in ColdFusion
Write standard ColdFusion data access code to connect to Greenhouse.
-
Use the CData Software JDBC Driver for Cassandra in MicroStrategy Desktop
Connect to Apache Cassandra in MicroStrategy Desktop using the CData Software JDBC Driver for Cassandra.
-
Create Data Visualizations in Cognos BI with Helpscout Data
Access Helpscout as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import Keap Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Keap. In this article, you will use the OData format to import Keap into Microsoft Power Query.
-
Visualize Mixpanel Data in Tableau
The CData ODBC driver for Mixpanel enables you integrate Mixpanel into Tableau dashboards.
-
Use the CData Software ODBC Driver for LeadDesk in MicroStrategy
Connect to LeadDesk in MicroStrategy Developer using the CData Software ODBC Driver for LeadDesk.
-
Process & Analyze Instantly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Instantly Data.
-
Bind Live Splunk Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Splunk data
-
DataBind Controls to Deel Data in C++Builder
DataBind to Deel in C++Builder with standard components and controls.
-
Connect to Attio Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Attio and work with Attio in your FileMaker applications.
-
How to connect to Parallel Data in DBVisualizer
Integrate Parallel with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to LionDesk Data in JRuby
Create a simple JRuby app with access to live LionDesk.
-
Excel Spreadsheet Automation on Cohere Data with the QUERY Formula
Pull data from Cohere, automate spreadsheets, and more with the QUERY formula.
-
Access Live HubDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live HubDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Bind Live Discourse Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Discourse data
-
How to load Brex data into Elasticsearch via Logstash
Introducing a simple method to load Brex data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData JDBC Driver for Reckon
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Reckon.
-
How to Connect to Live Marketo 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 Marketo for you.
-
Build ZohoExpense-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZohoExpense.
-
Connecting Pipedream with Power BI XMLA Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Power BI XMLA data in real time.
-
Bidirectional Access to PivotalTracker Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PivotalTracker in Filemaker Pro for Mac or Windows.
-
How to Access Live Airtable Data in Visual Studio Code via Cline
Run CData MCP Server for Airtable on Windows Subsytem for Linux (WSL) and connect to live Airtable from the Cline extension in Visual Studio Code.
-
Import Real-Time PDFMonkey Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PDFMonkey in ColdFusion.
-
How to work with Impala Data in Apache Spark using SQL
Access and process Impala Data in Apache Spark using the CData Software JDBC Driver.
-
Rapidly Develop Foursquare-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Foursquare.
-
Manage PhantomBuster Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for PhantomBuster.
-
Build IBM Informix-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for IBM Informix to explore live IBM Informix Data in GitHub Copilot to assist with building IBM Informix-powered applications.
-
How to connect to Auth0 Data from IntelliJ
Integrate connectivity to Auth0 with wizards in IntelliJ.
-
How to connect to EmailOctopus Data from IntelliJ
Integrate connectivity to EmailOctopus with wizards in IntelliJ.
-
Enable the GitHub JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with GitHub.
-
How to Query Yelp Data in MySQL Workbench
Execute MySQL queries against live Yelp from MySQL Workbench.
-
Integrate Live YouTube Analytics Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to YouTube Analytics from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live YouTube Analytics.
-
Create Reports from Azure Synapse Data in Looker Studio
Use CData Connect AI to gain access to live Azure Synapse and create custom reports in Looker Studio.
-
Integrating LangGraph with Databricks Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Databricks within automated workflows.
-
How to Connect to Live GitHub 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 GitHub through natural language.
-
Automated Continuous Avaza Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Avaza replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData Power BI Connector for Discord
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Publish ZendeskSell-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZendeskSell.
-
How to connect Amazon QuickSight to PostgreSQL Data
Create a connection to PostgreSQL in CData Connect AI and insert PostgreSQL into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Excel Add-In for Bugsnag
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Bugsnag.
-
Deploy the ADO.NET Provider for Deel on an SSRS Report Server
Connect to Deel from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to Couchbase Data in Claris FileMaker Pro
Use the CData ODBC Driver for Couchbase in FileMaker Pro to connect to Couchbase and work with Couchbase in your FileMaker applications.
-
Integrating Antigravity CLI with TigerGraph via CData CLI
Connect TigerGraph to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Dynamic Procore Grids Using the Infragistics XamDataGrid
Learn how you can connect Procore to Infragistics XamDataGrid to build dynamic grids.
-
Analyze HBase Data in Cognos Analytics
Use CData Connect AI to connect to HBase Data from Cognos Analytics and analyze live Apache HBase.
-
Viewing ZohoDesk Data in RAD Studio Data Explorer
How to view ZohoDesk in RAD Studio Data Explorer using the CData ODBC Driver for ZohoDesk.
-
Consume PDFMonkey OData Feeds in PowerBuilder
This article demonstrates how to consume PDFMonkey as OData feeds from PowerBuilder using the API Server.
-
Connect to NetSuite Data in HULFT Integrate
Connect to NetSuite as a JDBC data source in HULFT Integrate
-
How to publish and share Reckon Data dashboards with Tableau Server
The CData ODBC driver for Reckon enables you integrate Reckon into Tableau dashboards.
-
Getting Started with the CData ODBC Driver for Reckon
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Reckon.
-
How to connect and process Workday from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Workday.
-
Getting Started with the CData Excel Add-In for BenchmarkEmail
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for BenchmarkEmail.
-
Import BambooHR Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to BambooHR Data and provide access to live BambooHR for custom reports in the Power BI Service.
-
Visualize Live Codat Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Codat.
-
Replicate Printful Data from PowerShell
Write a quick PowerShell script to query Printful. Use connectivity to the live data to replicate Printful to SQL Server.
-
Build Oracle Financials Cloud-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle Financials Cloud and build web apps with connectivity to live Oracle Financials Cloud.
-
Seamlessly Bring Phoenix Data into Retool Using CData Connect AI
Integrate Phoenix data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect and Query Live SAS xpt Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAS XPORT into Databricks
-
Build Mixpanel-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Mixpanel.
-
Build Automated Jira-Connected Workflows in Zapier
Use CData Connect AI to connect to live Atlassian Jira and build automated workflows in Zapier.
-
Analyze Google Drive Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Drive and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Perform Batch Operations with SAP Concur Data in Apache NiFi
Connect to SAP Concur and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrating Codex CLI with Samanage 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.
-
Access Live ActiveCampaign 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 ActiveCampaign through MCP integration.
-
Build Semantic Layer Views for Quickbase Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Quickbase.
-
Analyze Live Adobe Commerce Data in SAS Viya
Use CData Connect AI to connect to Adobe Commerce from SAS Viya and deploy self-service analytics using live Adobe Commerce.
-
Build ScrapingBee-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ScrapingBee and build web apps with connectivity to live ScrapingBee.
-
Migrating data from Presto to Google BigQuery using CData SSIS Components.
Easily push Presto to Google BigQuery using the CData SSIS Tasks for Presto and Google BigQuery.
-
Analyze Twilio Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Twilio and visualize live Twilio in Infragistics Reveal.
-
Explore Geographical Relationships in QuickBooks Data with Power Map
Create data visualizations with QuickBooks Desktop in Power Map.
-
A PostgreSQL Interface for LightSpeedRetail Data (MySQL Remoting via JDBC)
Use the Remoting features of the LightSpeedRetail JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Helpscout Data from MySQL in Amazon QuickSight
Connect to Helpscout and build visualizations of Helpscout using a MySQL Connection in Amazon QuickSight.
-
Prepare, Blend, and Analyze Salesforce Data in Alteryx Designer
Build workflows to access live Salesforce data for self-service data analytics.
-
How to connect and process Supabase from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Supabase.
-
Analyze Stack Exchange Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Stack Exchange with the CData JDBC Driver for Stack Exchange.
-
Explore Geographical Relationships in ConvertKit Data with Power Map
Create data visualizations with ConvertKit in Power Map.
-
Create Clockify Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Clockify from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Freshteam Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Freshteam to connect to Freshteam and execute queries in PowerBuilder.
-
Build Dashboards with Redshift Data in Dundas BI
Create dynamic dashboards and perform analytics based on Amazon Redshift in Dundas BI.