CData Software - Knowledge Base
Recent Articles
-
How to Connect to & Open PivotalTracker Data in Microsoft Excel
This article uses the CData ODBC driver for PivotalTracker to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect to Live Raisers Edge NXT 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 Raisers Edge NXT for you.
-
Access Wrike Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Wrike from HeidiSQL.
-
Add Cloudant Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Cloudant with the Informatica Enterprise Data Catalog to classify and organize data.
-
Consume Oracle HCM Cloud OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle HCM Cloud feeds that reflect any changes in SAP Lumira.
-
Integrate with Float Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Float to a JSON file on disk.
-
Build Data Flows from Spotify to SQL Server using SSIS
Easily back up Spotify to SQL Server using the SSIS components for Spotify.
-
Connect to Elasticsearch Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Elasticsearch.
-
Getting Started with the CData JDBC Driver for Sage Intacct
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sage Intacct.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed MongoDB to Power BI dashboards. Simply drag and drop MongoDB into data visuals on the Power BI canvas.
-
How to create Visio diagrams from Slack Data
Automatically update Slack with the changes you make to Visio master shapes.
-
Automated Continuous Yelp Replication to SQL Server
Use CData Sync for automated, continuous, customizable Yelp replication to SQL Server.
-
Build Square-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Square Data and create custom apps in Bubble.
-
Replicate Bugsnag Data in Heroku for Use in Salesforce Connect
Replicate Bugsnag to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect HubSpot Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your HubSpot using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SendPulse
Provide connectivity to SendPulse through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To an ODBC Data Source for Simplesat
Create an ODBC connection to Simplesat in Informatica and browse and transfer Simplesat.
-
Publish Crystal Reports on LeadDesk Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date LeadDesk.
-
Connect to SAP BusinessObjects BI Data from a Connection Pool in Jetty
The SAP BusinessObjects BI JDBC Driver supports connection pooling: This article shows how to connect faster to SAP BusinessObjects BI from Web apps in Jetty.
-
Viewing Missive Data in RAD Studio Data Explorer
How to view Missive in RAD Studio Data Explorer using the CData ODBC Driver for Missive.
-
DataBind Charts to Bannerbear Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Bannerbear 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.
-
Automate Excel Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Excel replication to Azure Data Lake.
-
Stream Neo4J Data into Apache Kafka Topics
Access and stream Neo4J in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Basecamp Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Basecamp from HeidiSQL.
-
How to load Autopilot data into Elasticsearch via Logstash
Introducing a simple method to load Autopilot data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Salesforce Pardot-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Salesforce Pardot to explore live Salesforce Pardot Data in Cursor to assist with building Salesforce Pardot-powered applications.
-
Design BIRT Reports on Mocean Data
Provide current Mocean to your embedded analytics.
-
Replicate Humanity Data to Multiple Databases via the CData Sync CLI
Replicate Humanity to disparate databases with a single configuration.
-
Automated Continuous Twitter Ads Replication to MongoDB
Use CData Sync for automated, continuous, customizable Twitter Ads replication to MongoDB.
-
Getting Started with the CData ADO.NET Provider for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for IBM Cloud Object Storage.
-
Analyze Avalara AvaTax Data in Looker
Use CData Connect AI to connect to Avalara AvaTax Data from Looker and build custom apps using live Avalara AvaTax.
-
Connect iContact to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live iContact using the CData Python MCP Server.
-
Import Real-Time Mistral AI Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Mistral AI in ColdFusion.
-
Automated Continuous Wave Financial Replication to Oracle
Use CData Sync for automated, continuous, customizable Wave Financial replication to Oracle.
-
Visualize Live Foursquare Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Foursquare.
-
Automated Continuous Cassandra Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Cassandra replication to Azure SQL Database.
-
Create Power BI Reports on Real-Time Tanda Data
Use the CData ODBC Driver for Tanda to visualize Tanda in Power BI Desktop.
-
Publish VWO-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live VWO.
-
Connect Pushbullet to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Pushbullet using the CData Python MCP Server.
-
Getting Started with the CData ADO.NET Provider for Twitter Ads
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Twitter Ads.
-
Create Act CRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Act CRM data access from reports, embedded analytics, and more.
-
Connect to Teamwork Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Teamwork as an External Source in Dremio.
-
How to connect to Excel Online Data from Spring Boot
Connect to Excel Online in a Spring Boot Application using the CData JDBC Driver for Excel Online
-
Use Databricks Agent Bricks to Talk to Your Authorize.Net Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Authorize.Net for you.
-
Integrating Boomi Agentstudio with Redis Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Redis, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Visualize Live ADP Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ADP using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create SSAS Tabular Models from Google Campaign Manager 360 Data
How to build a SQL Server Analysis Service Tabular Model from Google Campaign Manager 360 using CData drivers.
-
Getting Started with the CData Python Connector for NASA
Learn to install and license the CData Python Connector
-
Connect to Sybase IQ Data in ACL Analytics
Connect to Sybase IQ via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Sybase IQ.
-
Connect to Amazon Marketplace Data in DBeaver
Use the CData ODBC Driver to connect to Amazon Marketplace in DBeaver.
-
Use Dash to Build to Web Apps on SurveyMonkey Data
Create Python applications that use pandas and Dash to build SurveyMonkey-connected web apps.
-
Natively Connect to ElevenLabs Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ElevenLabs. Leverage the native support for ODBC in PHP.
-
Access Oracle Sales Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Oracle Sales from your Oracle system.
-
Integrate Raisers Edge NXT Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Raisers Edge NXT from Informatica Cloud.
-
Build Pinterest-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Pinterest to explore live Pinterest Data in Gemini Code Assist to assist with building Pinterest-powered applications.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for HDFS
Provide connectivity to Apache HDFS through an SAP BusinessObjects universe.
-
Typeform Reporting in OBIEE with the Typeform JDBC Driver
Deploy the Typeform JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Sybase IQ-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Sybase IQ to explore live Sybase IQ Data in Claude Code to assist with building Sybase IQ-powered applications.
-
Integrate Facebook Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Facebook and integrate live Facebook into your Power Automate tasks.
-
Query Live Microsoft Teams 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 Microsoft Teams directly from the development environment.
-
Connect to Pipeline CRM from Asprova with CData Software ODBC Driver for Pipeline CRM
This article shows how to connect faster to Pipeline CRM data from Asprova.
-
Connect to and Visualize Live ShipEngine Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ShipEngine.
-
Feed FHIR Data into FineReport
How to set FHIR as a JDBC data source in FineReport.
-
Replicate Jodoo Data to Multiple Databases
Replicate Jodoo to disparate databases with a point-and-click configuration.
-
Connect to Calendly Data in HULFT Integrate
Connect to Calendly as a JDBC data source in HULFT Integrate
-
Replicate Multiple Helpscout Accounts via the CData Sync CLI
Replicate multiple Helpscout accounts to one or many databases.
-
Connect to ZohoExpense Data in RazorSQL
Connect to ZohoExpense from wizards and query ZohoExpense from the GUI in the RazorSQL database management tool.
-
How to Connect Microsoft Entra ID 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 Microsoft Entra ID data in real time using natural language.
-
Access Live Google Analytics Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Analytics into the statistical analysis tools available in SAS JMP. This article shows how to use Google Analytics in the Graph Builder and Query Builder.
-
Build a Simple VCL Application for Oracle Financials Cloud Data
How to build a simple VCL Application to view Oracle Financials Cloud in RAD Studio using the CData ODBC Driver for Oracle Financials Cloud.
-
Automated Continuous Cloudflare Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Cloudflare replication to delimited files (CSV/TSV).
-
Analyze Guru Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Guru in Microsoft R Open.
-
Publish Testmonitor-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Testmonitor.
-
Integrate Live Freshdesk Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create Power BI Reports on Real-Time Vimeo Data
Use the CData ODBC Driver for Vimeo to visualize Vimeo in Power BI Desktop.
-
Integrate LibreChat with Live Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Amazon DynamoDB from within the chat interface.
-
Integrate Live Greenplum Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Apify
Provide connectivity to Apify through an SAP BusinessObjects universe.
-
How to Connect to Live Twitter Ads Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Twitter Ads for you.
-
Integrate Cursor with Live Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Redis from within the editor.
-
Connect to OData Services from PowerBuilder via ADO.NET
This article demonstrates how to access OData from Appeon PowerBuilder using the CData ADO.NET Provider for OData.
-
Connect Egnyte to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Egnyte using the CData Python MCP Server.
-
Integrate LibreChat with Live PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live PostgreSQL from within the chat interface.
-
Process & Analyze Yelp Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Yelp Data.
-
Replicate Paylocity Data in Heroku for Use in Salesforce Connect
Replicate Paylocity to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Paddle Data in Jaspersoft Studio
Execute SQL to remote Paddle in Jaspersoft Studio.
-
Connect Amplitude to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Amplitude with IBM WebSphere for seamless data integration and connectivity.
-
Build Visualizations of Pingdom Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pingdom in Birst.
-
Prepare, Blend, and Analyze Shopify Data in Alteryx Designer (ODBC)
Build workflows to access live Shopify for self-service data analytics.
-
Publish Webex-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Webex.
-
Automate Unbounce Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Unbounce from PowerShell? This article demonstrates how to utilize the Unbounce Cmdlets for tasks like connecting to Unbounce, automating operations, downloading data, and more.
-
Access Outlook Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Outlook.
-
Raisers Edge NXT Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Raisers Edge NXT through CData Connect AI using different applications and tools.
-
Access Live Google Sheets Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Sheets from your Google Sheets.
-
Access SurveyMonkey Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for SurveyMonkey.
-
How to Connect to Live Act-On Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Act-On securely in real time.
-
Connect to Wistia Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Wistia and work with Wistia in your FileMaker applications.
-
Create Data Visualizations Based On SingleStore Data in Mode
Use CData Connect AI to connect to SingleStore Data from Mode and build visualizations using live
-
Replicate Multiple Kafka Accounts via the CData Sync CLI
Replicate multiple Kafka accounts to one or many databases.
-
Use the CData Software JDBC Driver for Outlook in MicroStrategy Desktop
Connect to Outlook in MicroStrategy Desktop using the CData Software JDBC Driver for Outlook.