CData Software - Knowledge Base
Recent Articles
-
Visualize Teamgate Data in TIBCO Spotfire through ADO.NET
Integrate Teamgate into dashboards in TIBCO Spotfire.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Omnisend to Power BI dashboards. Simply drag and drop Omnisend into data visuals on the Power BI canvas.
-
Use Biml to Build SSIS Tasks to Replicate Vercel Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Vercel to SQL Server.
-
Use the CData ODBC Driver for Mode in Microsoft Power Query
You can use the CData Mode ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mode into Microsoft Power Query.
-
Connect to Samanage from a Connection Pool in WebLogic
Use the CData JDBC Driver for Samanage to connect to Samanage from Web applications running on WebLogic.
-
How to Query Live Microsoft Planner Data in Perplexity MacOS Desktop
Connect to and query live Microsoft Planner Data in Perplexity Desktop using CData MCP Server.
-
Replicate Azure Table Data from PowerShell
Write a quick PowerShell script to query Azure Table Storage. Use connectivity to the live data to replicate Azure Table Storage to SQL Server.
-
Use ChatGPT to Talk to Your Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Apache Phoenix for you.
-
Connect to Google Forms Data in Ruby
Connect to Google Forms in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Semantic Layer Views for Clari Data in APOS Live Data Gateway
Use the CData Connector for Clari in APOS Live Data Gateway to build Semantic Layer Views for Clari.
-
Import Short.io Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Short.io. In this article, you will use the OData format to import Short.io into Microsoft Power Query.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SQL Analysis Services
Provide connectivity to SQL Analysis Services through an SAP BusinessObjects universe.
-
Query Aircall Data as a MySQL Database in Node.js
Execute MySQL queries against Aircall from Node.js.
-
How to publish and share Omnisend Data dashboards with Tableau Server
The CData ODBC driver for Omnisend enables you integrate Omnisend into Tableau dashboards.
-
Integrate Live Twitter Ads Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Import eBay Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to eBay Data and provide access to live eBay for custom reports in the Power BI Service.
-
Analyze Twitter Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Twitter Ads and visualize live Twitter Ads in Infragistics Reveal.
-
Import Zoho Books Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Zoho Books. In this article, you will use the OData format to import Zoho Books into Microsoft Power Query.
-
Integrate Active Directory Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Active Directory from Informatica Cloud.
-
Access Live Epicor Kinetic Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Epicor Kinetic from your Google Sheets.
-
How to Connect to Live Microsoft Teams Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Microsoft Teams for you.
-
Migrating data from LinkedIn Ads to Databricks using CData SSIS Components.
Easily push LinkedIn Ads to Databricks using the CData SSIS Tasks for LinkedIn Ads and Databricks.
-
Query Copper Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Copper entities in PHP by modeling them as objects.
-
Use the CData ODBC Driver for Pipeliner CRM in Microsoft Power Query
You can use the CData Pipeliner CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pipeliner CRM into Microsoft Power Query.
-
Connect to Act CRM Data in Ruby
Connect to Act CRM in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Dashboards with Tavily Data in Dundas BI
Create dynamic dashboards and perform analytics based on Tavily in Dundas BI.
-
Connecting Agentforce with JSON Services 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 JSON for you.
-
Getting Started with the CData SSIS Components for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bullhorn CRM.
-
Query Greenplum Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Greenplum entities in PHP by modeling them as objects.
-
Write a Simple Go Application to work with VWO Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to VWO.
-
Analyze Live CouchDB Data in SAS Viya
Use CData Connect AI to connect to Apache CouchDB from SAS Viya and deploy self-service analytics using live Apache CouchDB.
-
Use the CData Software ODBC Driver for Auth0 in SAS for Real-Time Reporting and Analytics
Connect to real-time Auth0 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Auth0.
-
Publish Reports with HBase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache HBase.
-
Build Automated Workflows with Live Dynamics CRM Data in Workato
Use CData Connect AI to connect to live Microsoft Dynamics CRM and build automated workflows in Workato.
-
A PostgreSQL Interface for SuiteCRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the SuiteCRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData API Server to Access Suadeo Data in Microsoft PowerPivot
Use the CData API Server to connect to live Suadeo in the Power Pivot business intelligence tool.
-
Use the CData Software ODBC Driver for Drift in SAS for Real-Time Reporting and Analytics
Connect to real-time Drift in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Drift.
-
Validate SAP Business One Data with QuerySurge
Access and validate SAP Business One in QuerySurge using the CData JDBC Driver.
-
Feed Parallel Data into FineReport
How to set Parallel as a JDBC data source in FineReport.
-
Integrate Nuclia with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Nuclia with External Services.
-
Configure the CData JDBC Driver for LinkedIn in a Connection Pool in Tomcat
Connect to LinkedIn from a connection pool in Tomcat.
-
Provide OData Services of JobNimbus Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for JobNimbus by developing a WCF Service Application.
-
Use ChatGPT to Talk to Your Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Highrise CRM for you.
-
Access Live Google Tasks Data in AWS Lambda
Connect to live Google Tasks in AWS Lambda using the CData JDBC Driver.
-
Add PabblySubscriptions Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PabblySubscriptions with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to PolarTeamPro Data in JRuby
Create a simple JRuby app with access to live PolarTeamPro.
-
How to work with Cloudflare Data in Apache Spark using SQL
Access and process Cloudflare Data in Apache Spark using the CData Software JDBC Driver.
-
Build Pipelines with Live Certinia Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Certinia from Google Cloud Data Fusion, enabling the integration of live Certinia into the building and management of effective data pipelines.
-
How to Import Data from ZendeskSell into Google Sheets
Import ZendeskSell into a Google spreadsheet that is automatically refreshed.
-
Prepare, Blend, and Analyze Presto Data in Alteryx Designer (ODBC)
Build workflows to access live Presto for self-service data analytics.
-
Build Egnyte-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Egnyte Data in Claude Code to assist with building Egnyte-powered applications.
-
Getting Started with the CData ODBC Driver for Todoist
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Todoist.
-
Build Apps with Live Azure Data Lake Storage in Adalo using CData Connect AI
Use CData Connect AI to integrate live Azure Data Lake Storage into the Adalo platform and build custom mobile and web applications with real-time Azure Data Lake Storage.
-
Migrating data from Sendwithus to Databricks using CData SSIS Components.
Easily push Sendwithus to Databricks using the CData SSIS Tasks for Sendwithus and Databricks.
-
Query Spark Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Apache Spark SQL and perform CRUD operations on Spark from Node.js.
-
Integrating Claude Code CLI with Bright Data 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 with Mailgun Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Mailgun to a JSON file on disk.
-
Build Monday.com-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Monday.com and build web apps with connectivity to live Monday.com.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LaunchDarkly
Provide connectivity to LaunchDarkly through an SAP BusinessObjects universe.
-
Query Excel Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Excel entities in PHP by modeling them as objects.
-
Create Microsoft OneDrive-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft OneDrive Data from Nintex Workflow Cloud and build custom workflows using live Microsoft OneDrive.
-
Import Real-Time Bannerbear Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bannerbear in ColdFusion.
-
Build Dashboards with Excel Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Excel in Dundas BI.
-
How to load Mixpanel data into Elasticsearch via Logstash
Introducing a simple method to load Mixpanel data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Establish a Live Connection with DB2 Data using Tableau Bridge
The CData ODBC Driver for DB2 enables you to integrate live IBM DB2 into Tableau Cloud dashboards using the Tableau Bridge.
-
DataBind Controls to Opsgenie Data in C++Builder
DataBind to Opsgenie in C++Builder with standard components and controls.
-
Use the CData ODBC Driver for AdRoll from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for AdRoll to connect to AdRoll from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring AdRoll in Excel.
-
Connect to Impala Data in DBeaver
Use the CData ODBC Driver to connect to Apache Impala in DBeaver.
-
How to Access Live Clio Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Clio from the Cline extension in Visual Studio Code.
-
Build ChartMogul-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live ChartMogul Data in GitHub Copilot to assist with building ChartMogul-powered applications.
-
Build Apps with Live Opsgenie Data Using the Low-Code Development Platform of Mendix
Connect Opsgenie with Mendix to build apps using the CData API Driver for JDBC.
-
Build a PostgreSQL Interface for SAP HANA Data using the CData JDBC Driver
Use the Remoting features of the SAP HANA JDBC Driver to create a PostgreSQL entry-point for data access.
-
LINQ to Acumatica 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 Acumatica Data Provider.
-
Connect to Snapchat Ads Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Snapchat Ads from Filemaker Pro on Mac.
-
Connect to and Visualize Live Sage 300 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage 300.
-
How to Access Live Amazon Marketplace Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Amazon Marketplace enables you to integrate Amazon Marketplace into workflows built using Microsoft Power Automate Desktop.
-
Build MVC Applications with Connectivity to Templated Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Templated from an ASP.NET MVC application.
-
Build Voice Agents in ElevenLabs with access to Live Amazon S3 Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Amazon S3.
-
Connect to Teradata Data in HULFT Integrate
Connect to Teradata as a JDBC data source in HULFT Integrate
-
A PostgreSQL Interface for Calendly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Calendly JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Live Outreach.io Data in Perplexity MacOS Desktop
Connect to and query live Outreach.io Data in Perplexity Desktop using CData MCP Server.
-
Integrating Freshdesk Data in Talend Cloud Data Management Platform
Connect Freshdesk Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Freshdesk.
-
Model, Search, and Visualize Live Presto Data in ThoughtSpot
Use CData Connect AI to connect to live Presto for modeling, searching, and visualizing.
-
A PostgreSQL Interface for Twilio Data using the CData ODBC Driver
Use the SQL Gateway and Twilio ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Mouseflow Replication to Oracle
Use CData Sync for automated, continuous, customizable Mouseflow replication to Oracle.
-
Automated Continuous Billsby Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Billsby replication to OneLake in Microsoft Fabric.
-
Viewing Placid Data in RAD Studio Data Explorer
How to view Placid in RAD Studio Data Explorer using the CData ODBC Driver for Placid.
-
Replicate Multiple Highrise Accounts
Replicate multiple Highrise accounts to one or many databases.
-
How to Easily Query Bannerbear Data in OpenOffice Base
Connect to Bannerbear data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous MailerLite Replication to MongoDB
Use CData Sync for automated, continuous, customizable MailerLite replication to MongoDB.
-
Automated Continuous Oracle SCM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Google BigQuery.
-
Access Live DocuSign Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live DocuSign through MCP integration.
-
How to connect and process Mailgun from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Mailgun.
-
Connect to Teamgate Data in RazorSQL
Connect to Teamgate from wizards and query Teamgate from the GUI in the RazorSQL database management tool.
-
Connect to ShipStation Data from PowerBuilder via ADO.NET
This article demonstrates how to access ShipStation from Appeon PowerBuilder using the CData ADO.NET Provider for ShipStation.
-
Integrating Antigravity CLI with Splunk via CData CLI
Connect Splunk to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Active Directory Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Active Directory.
-
How to Work with DB2 Data in AWS Glue Jobs Using JDBC
Connect to DB2 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build PivotalTracker-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live PivotalTracker Data in Cursor to assist with building PivotalTracker-powered applications.
-
How to update Office 365 from Excel
This article explains how to transfer data from Excel to Office 365 using the Excel Add-In for Office 365.