CData Software - Knowledge Base
Recent Articles
-
Analyze XML Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of XML Files and visualize live XML Files in Infragistics Reveal.
-
Visualize Slack Data in Tableau
The CData ODBC driver for Slack enables you integrate Slack into Tableau dashboards.
-
Query Opsgenie Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Opsgenie from Node.js.
-
Build MVC Applications with Connectivity to Google Campaign Manager 360 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Campaign Manager 360 from an ASP.NET MVC application.
-
Publish Crystal Reports on ServiceDesk Plus Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ServiceDesk Plus.
-
Moving Data from Facebook to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Facebook data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Microsoft Entra ID in SpagoBI
Create reports featuring live Microsoft Entra ID in SpagoBI Studio. Host Microsoft Entra ID reports on SpagoBI Server.
-
Visualize Beeminder Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Beeminder into TIBCO Spotfire.
-
Connect to Reckon from Asprova with CData Software ODBC Driver for Reckon
This article shows how to connect faster to Reckon data from Asprova.
-
How to connect to Salesforce Marketing Data in DBVisualizer
Integrate Salesforce Marketing Cloud with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Visualizations of Zoho Creator Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Creator in Birst.
-
Excel Spreadsheet Automation on VWO Data with the QUERY Formula
Pull data from VWO, automate spreadsheets, and more with the QUERY formula.
-
Build MVC Applications with Connectivity to Billsby Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Billsby from an ASP.NET MVC application.
-
Publish Reports with Zoho Creator Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Creator.
-
Build Splunk-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Splunk Data and create custom apps in Bubble.
-
Connect to SAP Business One Data in ACL Analytics
Connect to SAP Business One via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Business One.
-
Connect to ServiceDesk Plus Data in Jaspersoft Studio
Execute SQL to remote ServiceDesk Plus in Jaspersoft Studio.
-
Build Asana-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Asana to explore live Asana Data in Gemini Code Assist to assist with building Asana-powered applications.
-
Integrate xBase Data in Pentaho Data Integration
Build ETL pipelines based on xBase in the Pentaho Data Integration tool.
-
Build Databricks-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Databricks Data and create custom apps in Bubble.
-
Query Coda Data as a MySQL Database in Node.js
Execute MySQL queries against Coda from Node.js.
-
Build Amazon S3-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Amazon S3 Data from Zoho Analytics and import live Amazon S3.
-
Integrate Real-Time Access to Phoenix in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Phoenix in real time.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Azure Cosmos DB to Power BI dashboards. Simply drag and drop Azure Cosmos DB into data visuals on the Power BI canvas.
-
How to Work with GraphQL Data in AWS Glue Jobs Using JDBC
Connect to GraphQL from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Live LinkedIn Ads Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live LinkedIn Ads into custom reports in Power BI.
-
Connect to and Visualize Live Rebilly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Rebilly.
-
Connect to ServiceDesk Plus Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ServiceDesk Plus and work with ServiceDesk Plus in your FileMaker applications.
-
Visualize Live LeadDesk Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LeadDesk.
-
Query Live FreshBooks 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 FreshBooks directly from the development environment.
-
Build Agents in Relevance AI with Access to Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on QuickBooks Time within intelligent agent workflows.
-
Connect SAP Business One to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Business One with IBM WebSphere for seamless data integration and connectivity.
-
Analyze ZohoExpense Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZohoExpense from Power Pivot. You will use the Table Import Wizard to load ZohoExpense. You can visually build the import query or use any SQL supported by the driver.
-
Create Data Visualizations Based On Snapchat Ads Data in Mode
Use CData Connect AI to connect to Snapchat Ads Data from Mode and build visualizations using live
-
Integrate Live RabbitMQ Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live RabbitMQ to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating Kiro CLI with PabblySubscriptions 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 BigQuery Data from a Connection Pool in JBoss
Integrate Google BigQuery into Java servlets: Use the Management Console in JBoss to install the BigQuery JDBC Driver.
-
How to Build an ETL App for Avro Data in Python with CData
Create ETL applications and real-time data pipelines for Apache Avro in Python with petl.
-
How to Use a Microsoft Access Database to Update SAP Netweaver Gateway Data in Real Time
Update SAP Netweaver Gateway data by creating a linked table in Microsoft Access with the CData SAP Netweaver Gateway ODBC Driver.
-
Establish a Live Connection with Reply.io Data using Tableau Bridge
The CData ODBC Driver for Reply.io enables you to integrate live Reply.io into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to CapsuleCRM Data from a Connection Pool in JBoss
Integrate CapsuleCRM into Java servlets: Use the Management Console in JBoss to install the CapsuleCRM JDBC Driver.
-
How to connect to RSS Feeds in DBVisualizer
Integrate RSS Feeds with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Figshare Replication to SQL Server
Use CData Sync for automated, continuous, customizable Figshare replication to SQL Server.
-
How to Query Google Forms Data in MySQL Workbench
Execute MySQL queries against live Google Forms from MySQL Workbench.
-
Access Live Microsoft Ads Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Ads from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Theia IDE with Live Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automated Continuous Impala Replication to Vertica
Use CData Sync for automated, continuous, customizable Impala replication to Vertica.
-
Create MarkLogic-Connected Applications in Appsmith
Connect to MarkLogic Data via CData Connect AI in Appsmith and create custom business applications with real-time access to MarkLogic.
-
Access Live SAP Ariba Procurement Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Ariba Procurement in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Access Live Kintone Data in Visual Studio Code via Cline
Run CData MCP Server for Kintone on Windows Subsytem for Linux (WSL) and connect to live Kintone from the Cline extension in Visual Studio Code.
-
Connect to Active Directory from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Active Directory, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Dashboards with Suadeo Data in DBxtra
Create dynamic dashboards and perform analytics based on Suadeo in DBxtra.
-
Viewing IBM Informix Data in RAD Studio Data Explorer
How to view IBM Informix in RAD Studio Data Explorer using the CData ODBC Driver for IBM Informix.
-
Use the CData ODBC Driver for Raisers Edge NXT from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Raisers Edge NXT to connect to Raisers Edge NXT from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Raisers Edge NXT in Excel.
-
Connect to Gmail Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Gmail and the Script function in FileMaker Pro to connect to Gmail and work with Gmail in your FileMaker application.
-
Connect to Cvent Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Cvent to connect to Cvent and execute queries in PowerBuilder.
-
Visualize Facebook Ads Data in Sisense
Create an ElastiCube in Sisense app with access to Facebook Ads.
-
Create ClickTime Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ClickTime from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Dashboards with Factorial Data in Dundas BI
Create dynamic dashboards and perform analytics based on Factorial in Dundas BI.
-
Integrate with Live ActiveCampaign Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ActiveCampaign from the MuleSoft Anypoint Platform to integrate live ActiveCampaign into custom reports and dashboards.
-
ETL SFTP in Oracle Data Integrator
This article shows how to transfer SFTP into a data warehouse using Oracle Data Integrator.
-
Connect to ZohoInvoice Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ZohoInvoice using standard SQL.
-
Access ConvertAPI Data from MySQL in Amazon QuickSight
Connect to ConvertAPI and build visualizations of ConvertAPI using a MySQL Connection in Amazon QuickSight.
-
Connect to Deel from Asprova with CData Software ODBC Driver for Deel
This article shows how to connect faster to Deel data from Asprova.
-
Build a PostgreSQL Interface for eBay Data using the CData JDBC Driver
Use the Remoting features of the eBay JDBC Driver to create a PostgreSQL entry-point for data access.
-
ETL Excel Online in Oracle Data Integrator
This article shows how to transfer Microsoft Excel Online into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData Power BI Connector for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build AI/ML Models with Live Salesforce Marketing Data using Dataiku
Connect Salesforce Marketing Data with Dataiku using the CData JDBC Driver for Salesforce Marketing.
-
Integrate Cline with Live HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live HCL Domino from within your IDE.
-
Seamlessly Bring SAP Concur Data into Retool Using CData Connect AI
Integrate SAP Concur data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use Microsoft Copilot Studio to talk to your Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Apollo for you.
-
Connect to Paymo Data in RazorSQL
Connect to Paymo from wizards and query Paymo from the GUI in the RazorSQL database management tool.
-
Deploy the ADO.NET Provider for Google Tasks on an SSRS Report Server
Connect to Google Tasks 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.
-
Access Live Samanage Data in AWS Lambda
Connect to live Samanage in AWS Lambda using the CData JDBC Driver.
-
Visualize Live Spark Data in the Power BI Service
Use CData Connect AI to connect to live Apache Spark SQL and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Dash to Build to Web Apps on Avro Data
Create Python applications that use pandas and Dash to build Avro-connected web apps.
-
DataBind Controls to Dynamics CRM Data in C++Builder
DataBind to Microsoft Dynamics CRM in C++Builder with standard components and controls.
-
Build AI/ML Models with Live Supabase Data using Dataiku
Connect Supabase Data with Dataiku using the CData API Driver for JDBC.
-
Explore Geographical Relationships in Amazon S3 Data with Power Map
Create data visualizations with Amazon S3 in Power Map.
-
Query Presto Data in ColdFusion
Write standard ColdFusion data access code to connect to Presto.
-
Access Live NetSuite Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live NetSuite data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Deploy the ADO.NET Provider for Beeminder on an SSRS Report Server
Connect to Beeminder 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.
-
Automate Zoho Creator Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho Creator replication to Azure Data Lake.
-
How to publish and share Calendly Data dashboards with Tableau Server
The CData ODBC driver for Calendly enables you integrate Calendly into Tableau dashboards.
-
Use JayDeBeApi to access Freshteam Data in Python
Use standard Python scripting and the development environment of your choice to access live Freshteam.
-
Connect to Facebook Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Facebook to connect to Facebook and execute queries in PowerBuilder.
-
Publish Crystal Reports on Slack Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Slack.
-
Integrating GitHub Copilot CLI with Salesforce Marketing Cloud 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 ScrapingBee Data with Power Map
Create data visualizations with ScrapingBee in Power Map.
-
Getting Started with the CData ODBC Driver for HelloSign
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for HelloSign.
-
Migrating data from Excel Online to Snowflake using CData SSIS Components.
Easily push Microsoft Excel Online to Snowflake using the CData SSIS Tasks for Excel Online and Snowflake.
-
Replicate CapsuleCRM Data to Multiple Databases via the CData Sync CLI
Replicate CapsuleCRM to disparate databases with a single configuration.
-
Build Dashboards with CampaignMonitor Data in DBxtra
Create dynamic dashboards and perform analytics based on CampaignMonitor in DBxtra.
-
Integrate Cursor with Live Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Jira Assets from within the editor.
-
Analyze Microsoft Entra ID Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Microsoft Entra ID from Power Pivot. You will use the Table Import Wizard to load Microsoft Entra ID. You can visually build the import query or use any SQL supported by the driver.
-
Integrating OpenCode Terminal with DocuSign 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.
-
Analyze SAP ByDesign Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Business ByDesign in Microsoft R Open.
-
Integrating LangChain with Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Zoho Projects within automated workflows.
-
Integrate Zuora Data into Power Automate Desktop using CData Connect
CData Connect for Zuora Data enables you to integrate Zuora into workflows built using Microsoft Power Automate Desktop.
-
Connect to PabblySubscriptions Data in Jaspersoft Studio
Execute SQL to remote PabblySubscriptions in Jaspersoft Studio.