CData Software - Knowledge Base
Recent Articles
-
How to Easily Query Zuora Data in OpenOffice Base
Connect to Zuora data in OpenOffice Base using the CData ODBC Driver for Zuora and generate reports with live data insights.
-
How to Query Live Sentry Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sentry data in natural language using Python.
-
Automate Sugar CRM Data Replication to Azure Synapse
Use CData Sync to customize and automate Sugar CRM replication to Azure Synapse.
-
Use Biml to Build SSIS Tasks to Replicate Confluence Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Atlassian Confluence to SQL Server.
-
Use the CData ODBC Driver for Mistral AI from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mistral AI to connect to Mistral AI from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mistral AI in Excel.
-
Visualize Salesforce CRM Analytics Data in TIBCO Spotfire through ADO.NET
Integrate Salesforce CRM Analytics into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for Attio in MicroStrategy Web
Connect to Attio in MicroStrategy Web using the CData Software ODBC Driver for Attio.
-
Import and Visualize BenchmarkEmail Data in Power View
Create data visualizations based on BenchmarkEmail in Excel.
-
Integrating GitHub Copilot CLI with CampaignMonitor 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.
-
Automate Clio Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Clio from PowerShell? This article demonstrates how to utilize the Clio Cmdlets for tasks like connecting to Clio, automating operations, downloading data, and more.
-
Connect to FTP Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live FTP Servers from Filemaker Pro on Mac.
-
Consume Raisers Edge NXT OData Feeds in PowerBuilder
This article demonstrates how to consume Raisers Edge NXT as OData feeds from PowerBuilder using the API Server.
-
Integrate Real-Time Access to Oracle Sales in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle Sales in real time.
-
Connect to CSV Data in RapidMiner
Integrate CSV/TSV Files with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous eBay Replication to MongoDB
Use CData Sync for automated, continuous, customizable eBay replication to MongoDB.
-
Viewing Paddle Data in RAD Studio Data Explorer
How to view Paddle in RAD Studio Data Explorer using the CData ODBC Driver for Paddle.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Printful
Provide connectivity to Printful through an SAP BusinessObjects universe.
-
Publish Hacker News-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Hacker News.
-
Connect to Square from a Connection Pool in WebLogic
Use the CData JDBC Driver for Square to connect to Square from Web applications running on WebLogic.
-
Natively Connect to ServiceDesk Plus Data in PHP
The CData ODBC driver for ServiceDesk Plus enables you to create PHP applications with connectivity to ServiceDesk Plus. Leverage the native support for ODBC in PHP.
-
Connect to Mocean Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Mocean in the Denodo Virtual DataPort Administrator.
-
A PostgreSQL Interface for Webflow Data using the CData ODBC Driver
Use the SQL Gateway and Webflow ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code with Microsoft Ads Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Ads within assisted coding and automated development workflows.
-
Query Notion Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Notion from Node.js.
-
Create SSAS Tabular Models from Reckon Accounts Hosted Data
How to build a SQL Server Analysis Service Tabular Model from Reckon Accounts Hosted using CData drivers.
-
Automate ClickUp Data Replication to Azure Synapse
Use CData Sync to customize and automate ClickUp replication to Azure Synapse.
-
How to integrate Salesloft with Apache Airflow
Access and process Salesloft in Apache Airflow using the CData JDBC Driver.
-
Replicate Multiple Access Accounts via the CData Sync CLI
Replicate multiple Access accounts to one or many databases.
-
How to Connect Flowise AI Agents to Live Azure Table Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Azure Table Storage without replication.
-
Integrate Apollo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Apollo with External Services.
-
Integrate Jumpseller with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Jumpseller with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Jumpseller.
-
How to Access Printful Data Using Entity Framework
This article shows how to access Printful using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Add SharePoint Excel Services Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SharePoint Excel Services with the Informatica Enterprise Data Catalog to classify and organize data.
-
PivotalTracker Reporting in OBIEE with the PivotalTracker JDBC Driver
Deploy the PivotalTracker JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Data Flows from Gmail to SQL Server using SSIS
Easily back up Gmail to SQL Server using the SSIS components for Gmail.
-
Automate Everhour Data Replication to Couchbase
Use CData Sync to Customize and automate Everhour replication to Couchbase.
-
Use the CData Software ODBC Driver for LaunchDarkly in MicroStrategy
Connect to LaunchDarkly in MicroStrategy Developer using the CData Software ODBC Driver for LaunchDarkly.
-
Analyze Sage 300 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sage 300 from Power Pivot. You will use the Table Import Wizard to load Sage 300. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to Foursquare Data from Spring Boot
Connect to Foursquare in a Spring Boot Application using the CData API Driver for JDBC
-
Query Bullhorn CRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Bullhorn CRM from Node.js.
-
Integrate CockroachDB Data into Power Automate Desktop using CData Connect
CData Connect for CockroachDB Data enables you to integrate CockroachDB into workflows built using Microsoft Power Automate Desktop.
-
Import Real-Time Zuora Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zuora in ColdFusion.
-
Getting Started with the CData ADO.NET Provider for SAS Data Sets
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAS Data Sets.
-
How to Query Live Drip Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Drip data in natural language using Python.
-
Automated Continuous PayPal Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable PayPal replication to Google BigQuery.
-
Integrate Live Sage 200 Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to Redshift from Asprova with CData Software ODBC Driver for Redshift
This article shows how to connect faster to Redshift data from Asprova.
-
Connect to Bullhorn CRM from Asprova with CData Software ODBC Driver for Bullhorn CRM
This article shows how to connect faster to Bullhorn CRM data from Asprova.
-
Automated Continuous LeadDesk Replication to AlloyDB
Use CData Sync for automated, continuous, customizable LeadDesk replication to AlloyDB.
-
Connect to Adobe Analytics Data in CloverDX (formerly CloverETL)
Transfer Adobe Analytics using the visual workflow in the CloverDX data integration tool.
-
Build Reckon Accounts Hosted Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Reckon Accounts Hosted and build visualizations in Tableau Cloud.
-
Access Live Bannerbear Data in AWS Lambda
Connect to live Bannerbear in AWS Lambda using the CData JDBC Driver.
-
Visualize Facebook 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 Facebook into TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for Klipfolio
Create an ODBC connection to Klipfolio in Informatica and browse and transfer Klipfolio.
-
Access Live Hive Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Apache Hive from your Excel spreadsheets.
-
Connecting GenSpark with Jira Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Atlassian Jira without any replication or custom integration required.
-
Create Datasets from PivotalTracker in Domo Workbench and Build Visualizations of PivotalTracker Data in Domo
Use the CData Software ODBC Driver for PivotalTracker to create datasets from PivotalTracker in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Oracle Eloqua Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Eloqua from your Google Sheets.
-
Use the CData Software ODBC Driver for Zoho CRM in MicroStrategy Web
Connect to Zoho CRM in MicroStrategy Web using the CData Software ODBC Driver for Zoho CRM.
-
Moving Data from Rootly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Rootly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Microsoft Teams Data in HULFT Integrate
Connect to Microsoft Teams as a JDBC data source in HULFT Integrate
-
Build OneNote-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for OneNote Data and create custom apps in Bubble.
-
Connect to Flowlu Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Flowlu to connect to Flowlu and execute queries in PowerBuilder.
-
How to Query Live Freshdesk Data in Perplexity MacOS Desktop
Connect to and query live Freshdesk Data in Perplexity Desktop using CData MCP Server.
-
Connect to Facebook Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Facebook.
-
Use Manus AI to Talk to Your Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Azure Data Lake Storage.
-
Integrate OpenWeatherMap Data in the Pentaho Report Designer
Publish reports based on OpenWeatherMap in the Pentaho BI tool.
-
Access Paddle Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Paddle from HeidiSQL.
-
Connect to BigQuery Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with BigQuery Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Live DocuSign Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live DocuSign from your Excel spreadsheets.
-
Query ZendeskSell Data in ColdFusion
Write standard ColdFusion data access code to connect to ZendeskSell.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PhantomBuster
Provide connectivity to PhantomBuster through an SAP BusinessObjects universe.
-
How to Visualize Exact Online Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Exact Online in Python.
-
Use Agno to Talk to Your Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Azure DevOps for you.
-
ETL HelloSign in Oracle Data Integrator
This article shows how to transfer HelloSign into a data warehouse using Oracle Data Integrator.
-
Connect to and Query SAP Netweaver Gateway Data in QlikView over ODBC
Create data visualizations with SAP Netweaver Gateway in QlikView.
-
Design BIRT Reports on Typeform Data
Provide current Typeform to your embedded analytics.
-
Manage Oracle Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Oracle.
-
ETL NASA in Oracle Data Integrator
This article shows how to transfer NASA into a data warehouse using Oracle Data Integrator.
-
Analyze NetSuite Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze NetSuite CRM & ERP in Microsoft R Open.
-
Build Charts with Amazon Marketplace Data in Clear Analytics
Create dynamic charts and perform analytics based on Amazon Marketplace in Clear Analytics.
-
Create Informatica Mappings From/To a JDBC Data Source for Shortcut
Create Shortcut data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build a Singer.io Tap for Reply.io With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Reply.io data using
-
Getting Started with the CData Power BI Connector for Epicor Kinetic
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Epicor Kinetic.
-
View Reports on Real-Time Tavily Data in Power BI Report Server
Use the CData ODBC Driver for Tavily to visualize Tavily in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect to Bitbucket Data from Spring Boot
Connect to Bitbucket in a Spring Boot Application using the CData JDBC Driver for Bitbucket
-
Access Live Databricks Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Databricks from your Excel spreadsheets.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Entra ID to Power BI dashboards. Simply drag and drop Microsoft Entra ID into data visuals on the Power BI canvas.
-
Integrating LangChain with Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Twitter Ads within automated workflows.
-
Publish PhantomBuster-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live PhantomBuster.
-
Easily Integrate Rootly Data in Lazarus Pascal IDE
Learn how to easily integrate live Rootly in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Deploy the ADO.NET Provider for Asana on an SSRS Report Server
Connect to Asana 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.
-
Automated Continuous Campaigner Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Campaigner replication to Apache Cassandra.
-
How to Connect HBase Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live HBase data in real time using natural language.
-
Notion Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Notion facts in real time.
-
How to Access Live Google Sheets Data in Visual Studio Code via Cline
Run CData MCP Server for Google Sheets on Windows Subsytem for Linux (WSL) and connect to live Google Sheets from the Cline extension in Visual Studio Code.
-
How to create an RPA flow for Dotmailer Data in UiPath Studio
Use the Dotmailer ODBC Driver to create workflows that access real-time Dotmailer without any coding.
-
Automated Continuous MessageBird Replication to SingleStore
Use CData Sync for automated, continuous, customizable MessageBird replication to SingleStore.
-
Integrate Live BambooHR Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live BambooHR to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Analyze HBase Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apache HBase in Microsoft R Open.