CData Software - Knowledge Base
Recent Articles
-
Connect to Real-Time ZohoSubscriptions Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZohoSubscriptions in Power Apps.
-
Visualize Optimizely Data in TIBCO Spotfire through ADO.NET
Integrate Optimizely into dashboards in TIBCO Spotfire.
-
Replicate Intercom Data from PowerShell
Write a quick PowerShell script to query Intercom. Use connectivity to the live data to replicate Intercom to SQL Server.
-
Deploy the ADO.NET Provider for SendInBlue on an SSRS Report Server
Connect to SendInBlue 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.
-
How to Create Power BI Visual Reports with Real-Time RabbitMQ Data
Use CData Power BI Connectors to visualize RabbitMQ in Power BI.
-
Bind Live Pipeliner CRM Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Pipeliner CRM data
-
Analyze Spark Data in Looker
Use CData Connect AI to connect to Spark Data from Looker and build custom apps using live Apache Spark SQL.
-
Access Live Calendly Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Calendly data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Access Live Lakebase Data in Visual Studio Code via Cline
Run CData MCP Server for Lakebase on Windows Subsytem for Linux (WSL) and connect to live Lakebase from the Cline extension in Visual Studio Code.
-
LinkedIn Ads Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to LinkedIn Ads through CData Connect AI using different applications and tools.
-
ETL Float in Oracle Data Integrator
This article shows how to transfer Float into a data warehouse using Oracle Data Integrator.
-
Connect to CSV Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time CSV/TSV Files using standard SQL.
-
Natively Connect to ConvertAPI Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ConvertAPI. Leverage the native support for ODBC in PHP.
-
Connect to Parallel Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Parallel and work with Parallel in your FileMaker application.
-
How to Access Live Freshsales Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Freshsales enables you to integrate Freshsales into workflows built using Microsoft Power Automate Desktop.
-
Integrating Claude Code CLI with Stack Exchange 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.
-
How to Seamlessly Import Excel Online Data into IBM SPSS Modeler
Integrate Excel Online data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to work with BenchmarkEmail Data in Apache Spark using SQL
Access and process BenchmarkEmail Data in Apache Spark using the CData Software JDBC Driver.
-
Build Cosmos DB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Cosmos DB and build visualizations in Tableau Cloud.
-
How to Work with HelloSign Data in AWS Glue Jobs Using JDBC
Connect to HelloSign from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Model Zoho Creator Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoho Creator, enabling the direct import of real-time Zoho Creator.
-
Automated Continuous XML Replication to Amazon S3
Use CData Sync for automated, continuous, customizable XML replication to Amazon S3.
-
Integrate Live Google Campaign Manager 360 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Campaign Manager 360 to Blue Prism using the CData ODBC Driver for Google Campaign Manager 360 to create automated workflows for repetitive business tasks.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Calendar using the Model Context Protocol.
-
Connect to Azure DevOps in SpagoBI
Create reports featuring live Azure DevOps in SpagoBI Studio. Host Azure DevOps reports on SpagoBI Server.
-
Integrate Teamwork with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Teamwork with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Teamwork.
-
Access TaxJar Data from MySQL in PHP
Connect to TaxJar through the standard MySQL libraries in PHP.
-
Connect to Vault CRM Data from a Connection Pool in JBoss
Integrate Veeva Vault & Vault CRM into Java servlets: Use the Management Console in JBoss to install the Vault CRM JDBC Driver.
-
Query, Visualize, and Share live Impala Data in Redash
Use CData Connect AI to connect to live Apache Impala in Redash for querying, visualizing, and sharing.
-
Work with Live Azure Synapse Data in Power Query
Use CData Connect AI to connect to Azure Synapse and work with live Azure Synapse in Microsoft Power Query.
-
How to connect and process Veeva Vault & Vault CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Veeva Vault & Vault CRM.
-
Publish Google Sheets-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Sheets.
-
Integrate Hive Data in the Pentaho Report Designer
Publish reports based on Apache Hive in the Pentaho BI tool.
-
Connect to Live SharePoint Data in MicroStrategy through CData Connect AI
Create a live connection to SharePoint Data in CData Connect AI and connect to your Microsoft SharePoint from MicroStrategy.
-
How to Visualize FormSite Data in Python with pandas
Use pandas and other modules to analyze and visualize live FormSite in Python.
-
Create Datasets from Bullhorn CRM in Domo Workbench and Build Visualizations of Bullhorn CRM Data in Domo
Use the CData Software ODBC Driver for Bullhorn CRM to create datasets from Bullhorn CRM in Domo Workbench and then build visualizations in the Domo service.
-
Explore Geographical Relationships in ElevenLabs Data with Power Map
Create data visualizations with ElevenLabs in Power Map.
-
Build SAP Ariba Procurement-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAP Ariba Procurement to explore live SAP Ariba Procurement Data in Claude Code to assist with building SAP Ariba Procurement-powered applications.
-
Connect to Flowlu Data from PowerBuilder via ADO.NET
This article demonstrates how to access Flowlu from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Build an ETL App for Microsoft Dataverse Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Dataverse (CDS) in Python with petl.
-
Integrate with Act-On Data in JReport Designer
Create charts and reports based on Act-On in JReport Designer.
-
Import Oracle Service Cloud Data Using Azure Data Factory
Use CData Connect AI to connect to Oracle Service Cloud Data from Azure Data Factory and import live Oracle Service Cloud.
-
Build Charts with Microsoft Teams Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Teams in Clear Analytics.
-
Analyze Exa Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Exa and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live Oracle HCM Cloud Data in AWS Lambda
Connect to live Oracle HCM Cloud in AWS Lambda using the CData JDBC Driver.
-
Access Sybase IQ Data from MySQL in PHP
Connect to Sybase IQ through the standard MySQL libraries in PHP.
-
Automated Continuous Google Ad Manager Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Databricks.
-
How to Connect to Bright Data Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Bright Data. Leverage the pyodbc module for ODBC in Python.
-
How to load Telegram data into Elasticsearch via Logstash
Introducing a simple method to load Telegram data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to publish and share Splunk Data dashboards with Tableau Server
The CData ODBC driver for Splunk enables you integrate Splunk into Tableau dashboards.
-
How to Query Live Retently Data in Claude Desktop
Connect to and query live Retently Data in Claude Desktop using CData MCP Server.
-
Automate XML Data Replication to Couchbase
Use CData Sync to Customize and automate XML Files replication to Couchbase.
-
How to import TaxJar Data into Apache Solr
Use the CData Software JDBC Driver for TaxJar in Data Import Handler and create an automated import of TaxJar to Apache Solr Enterprise Search platform.
-
How to connect and process Landbot from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Landbot.
-
Connect to FormSite Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for FormSite to connect to FormSite and execute queries in PowerBuilder.
-
DataBind Charts to Chargebee Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Chargebee 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.
-
How to Query Live SparkPost Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SparkPost data in natural language using Python.
-
Build HCL Domino-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live HCL Domino.
-
Excel Spreadsheet Automation on Freshservice Data with the QUERY Formula
Pull data from Freshservice, automate spreadsheets, and more with the QUERY formula.
-
Replicate Klaviyo Data from PowerShell
Write a quick PowerShell script to query Klaviyo. Use connectivity to the live data to replicate Klaviyo to SQL Server.
-
How to connect to MariaDB Data with Squirrel SQL client
Connect to MariaDB and execute queries in the Squirrel SQL Client.
-
How to create an RPA flow for SendGrid Data in UiPath Studio
Use the SendGrid ODBC Driver to create workflows that access real-time SendGrid without any coding.
-
How to work with Google Calendar Data in Apache Spark using SQL
Access and process Google Calendar Data in Apache Spark using the CData Software JDBC Driver.
-
Build Apps with Live SAP Ariba Source in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Ariba Source into the Adalo platform and build custom mobile and web applications with real-time SAP Ariba Source.
-
Extract, Transform, and Load Redshift Data in Informatica PowerCenter
Create a simple Workflow for Amazon Redshift in Informatica PowerCenter.
-
Automated Continuous Optimizely Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Optimizely replication to Amazon S3.
-
Access LaunchDarkly Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LaunchDarkly from HeidiSQL.
-
Build Semantic Layer Views for Tanda Data in APOS Live Data Gateway
Use the CData Connector for Tanda in APOS Live Data Gateway to build Semantic Layer Views for Tanda.
-
Access Sage 300 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage 300 from your Oracle system.
-
How to Access Jodoo Data Using Entity Framework
This article shows how to access Jodoo using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze Tanda Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Tanda and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Theia IDE with Live NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Import Okta Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Okta Data and provide access to live Okta for custom reports in the Power BI Service.
-
Viewing AdRoll Data in RAD Studio Data Explorer
How to view AdRoll in RAD Studio Data Explorer using the CData ODBC Driver for AdRoll.
-
Integrating GitHub Copilot CLI with Chargebee 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 SAP Business Warehouse Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Business Warehouse in FileMaker Pro to connect to SAP Business Warehouse and work with SAP Business Warehouse in your FileMaker applications.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Reckon Accounts Hosted
Provide connectivity to Reckon Accounts Hosted through an SAP BusinessObjects universe.
-
How to Connect DBeaver to JSON via a JDBC Driver
Manage JSON with visual tools in DBeaver like the query browser.
-
Visualize Kintone Data in Sisense
Create an ElastiCube in Sisense app with access to Kintone.
-
Use Biml to Build SSIS Tasks to Replicate Oracle Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Database to SQL Server.
-
Connect to Live HubSpot Data in PostGresSQL Interface through CData Connect AI
Create a live connection to HubSpot in CData Connect AI and connect to your HubSpot from PostgreSQL.
-
Integrating GitHub Copilot CLI with Anaplan 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.
-
Build Voice Agents in ElevenLabs with access to Live ActiveCampaign Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ActiveCampaign.
-
How to connect Amazon QuickSight to Sage Cloud Accounting Data
Create a connection to Sage Business Cloud Accounting in CData Connect AI and insert Sage Business Cloud Accounting into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Productboard-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Productboard Data in GitHub Copilot to assist with building Productboard-powered applications.
-
Connect to Paddle Data in NetBeans
Connect to Paddle in NetBeans with the data source configuration wizard.
-
Build ZeroBounce-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live ZeroBounce Data in Cursor to assist with building ZeroBounce-powered applications.
-
Replicate Email Data from PowerShell
Write a quick PowerShell script to query Email. Use connectivity to the live data to replicate Email to SQL Server.
-
Choosing the Best Method to Connect SAP HANA XS Advanced to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP HANA XS Advanced from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Bind Live DB2 Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live DB2 data
-
Query Timely Data in DataGrip
Create a Data Source for Timely in DataGrip and use SQL to query live Timely.
-
Automated Continuous ZendeskSell Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Amazon Redshift.
-
Build JobNimbus-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live JobNimbus Data in Gemini Code Assist to assist with building JobNimbus-powered applications.
-
Build Visualizations of DocuSign Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of DocuSign in Birst.
-
Choosing the Best Method to Connect Excel Online to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Excel Online from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Controls to Tickspot Data in C++Builder
DataBind to Tickspot in C++Builder with standard components and controls.
-
Use the CData Software JDBC Driver for ChartMogul in MicroStrategy Web
Connect to ChartMogul in MicroStrategy Web using the CData Software JDBC Driver for ChartMogul.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed ChargeOver to Power BI dashboards. Simply drag and drop ChargeOver into data visuals on the Power BI canvas.
-
How to Design Avalara AvaTax Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Avalara AvaTax from mobile and tablet Power Apps.
-
Create HubSpot-Connected Business Apps in AppSheet
Connect to HubSpot Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to HubSpot.