CData Software - Knowledge Base
Recent Articles
-
Connect and Query Live CSV Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live CSV data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Adobe Experience Manager Data from a Connection Pool in JBoss
Integrate Adobe Experience Manager data into Java servlets: Use the Management Console in JBoss to install the Adobe Experience Manager JDBC Driver.
-
Use the CData ODBC Driver for Mouseflow from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mouseflow to connect to Mouseflow data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mouseflow data in Excel.
-
Integrate Live Impala Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Impala from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Impala data.
-
Connect Blackbaud FE NXT Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Blackbaud FE NXT data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Dify with Live Amazon S3 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Amazon S3 data.
-
Connect to Klipfolio from a Connection Pool in WebLogic
Use the CData JDBC Driver for Klipfolio to connect to Klipfolio data from Web applications running on WebLogic.
-
Integrate Vault CRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Vault CRM with External Services.
-
Visualize Live Aircall Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Aircall data.
-
Moving Data from Adobe Experience Manager to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Adobe Experience Manager data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Bidirectional Access to NetSuite Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate NetSuite data in Filemaker Pro for Mac or Windows.
-
Use Databricks Agent Bricks to Talk to Your Mailjet Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Mailjet data for you.
-
Create Datasets from ScrapingBee in Domo Workbench and Build Visualizations of ScrapingBee Data in Domo
Use the CData Software ODBC Driver for ScrapingBee to create datasets from ScrapingBee data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Zoho Projects Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho Projects data from your Google Sheets.
-
Provide OData Services of Supabase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Supabase data by developing a WCF Service Application.
-
Integrating Kiro with Sage 300 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.
-
Visualize Google Ad Manager Data in Sisense
Create an ElastiCube in Sisense app with access to Google Ad Manager data.
-
How to connect to Microsoft Teams Data with Squirrel SQL client
Connect to Microsoft Teams data and execute queries in the Squirrel SQL Client.
-
Replicate Omnisend Data to Multiple Databases via the CData Sync CLI
Replicate Omnisend data to disparate databases with a single configuration.
-
Analyze Datadog Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Datadog data with the CData JDBC Driver for Datadog.
-
Replicate Multiple Microsoft Dataverse Accounts
Replicate multiple Microsoft Dataverse accounts to one or many databases.
-
Publish Crystal Reports on Databricks Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Databricks data.
-
Connect to Real-Time ConvertKit Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ConvertKit data in Power Apps.
-
Visualize Live HCL Domino Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live HCL Domino data.
-
Connect Epicor Kinetic to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Epicor Kinetic with IBM WebSphere for seamless data integration and connectivity.
-
Integrating Codex with SpaceX 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.
-
Visualize Float 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 Float data into TIBCO Spotfire.
-
Migrating data from Toggl to Snowflake using CData SSIS Components.
Easily push Toggl data to Snowflake using the CData SSIS Tasks for Toggl and Snowflake.
-
Use the CData ODBC Driver for Teradata in Microsoft Power Query
You can use the CData Teradata ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Teradata data into Microsoft Power Query.
-
Connect to Samanage Data in Aqua Data Studio
Access Samanage data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Superchat-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Superchat data and build web apps with connectivity to live Superchat data.
-
Build Dashboards with TigerGraph Data in DBxtra
Create dynamic dashboards and perform analytics based on TigerGraph data in DBxtra.
-
Query Postmark Data as a MySQL Database in Node.js
Execute MySQL queries against Postmark data from Node.js.
-
Access Live MailChimp 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 MailChimp data through MCP integration.
-
How to Connect to Live Printify Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Printify data securely in real time.
-
Integrating Dataiku with ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ServiceNow data.
-
Automated Continuous Elasticsearch Replication to SingleStore
Use CData Sync for automated, continuous, customizable Elasticsearch replication to SingleStore.
-
Connect to Impala from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Impala data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Salesloft-Connected Applications in Appsmith
Connect to Salesloft Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Salesloft data.
-
Add Azure Analysis Services Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Azure Analysis Services with the Informatica Enterprise Data Catalog to classify and organize data.
-
Visualize SharePoint Excel Services 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 SharePoint Excel Services data into TIBCO Spotfire.
-
Consume EnterpriseDB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on EnterpriseDB feeds that reflect any changes in SAP Lumira.
-
Bind Live SingleStore Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SingleStore data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to Connect DBeaver to Okta via a JDBC Driver
Manage Okta data with visual tools in DBeaver like the query browser.
-
Connecting Pipedream with BigCommerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on BigCommerce data in real time.
-
Connect to ConvertKit Data from a Connection Pool in JBoss
Integrate ConvertKit data into Java servlets: Use the Management Console in JBoss to install the ConvertKit JDBC Driver.
-
Getting Started with the CData Connect AI Python SDK for SendGrid
Install the CData Connect AI Python SDK to read and write live SendGrid data with standard DB-API 2.0 Python code.
-
How to Connect to Live Exact Online Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Exact Online data for you.
-
Establish a Live Connection with Superchat Data using Tableau Bridge
The CData ODBC Driver for Superchat enables you to integrate live Superchat data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use JayDeBeApi to access Keap Data in Python
Use standard Python scripting and the development environment of your choice to access live Keap data.
-
How to Seamlessly Import JobNimbus Data into IBM SPSS Modeler
Integrate JobNimbus data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Easily Integrate ZohoDesk Data in Lazarus Pascal IDE
Learn how to easily integrate live ZohoDesk data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Reports from Facebook Ads Data in Looker Studio
Use CData Connect AI to gain access to live Facebook Ads data and create custom reports in Looker Studio.
-
Create Trello-Connected Business Apps in AppSheet
Connect to Trello Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Trello data.
-
Integrate YouTube Analytics Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to YouTube Analytics data and integrate live YouTube Analytics data into your Power Automate tasks.
-
Getting Started with the CData JDBC Driver for MongoDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MongoDB.
-
Access SAP HANA XS Advanced Data from MySQL in PHP
Connect to SAP HANA XS Advanced through the standard MySQL libraries in PHP.
-
Integrate Goose with Live ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ActiveCampaign data from within the local AI agent.
-
Import Real-Time Hive Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Hive data in ColdFusion.
-
Use the CData Software JDBC Driver for Redis in MicroStrategy
Connect to Redis data in MicroStrategy Developer using the CData Software JDBC Driver for Redis.
-
Connect to ZohoPeople Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ZohoPeople Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Live Zendesk Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zendesk data from your Excel spreadsheets.
-
Automate Unbounce Data Replication to Couchbase
Use CData Sync to Customize and automate Unbounce data replication to Couchbase.
-
How to create an RPA flow for SharePoint Data in UiPath Studio
Use the SharePoint ODBC Driver to create workflows that access real-time SharePoint data without any coding.
-
Migrating data from Webex to Databricks using CData SSIS Components.
Easily push Webex data to Databricks using the CData SSIS Tasks for Webex and Databricks.
-
Trigger Blackbaud FE NXT IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Blackbaud FE NXT with standard wizards in Logic Apps.
-
How to connect and process Missive data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Missive data.
-
Use the CData Software JDBC Driver for SpaceX in MicroStrategy Web
Connect to SpaceX data in MicroStrategy Web using the CData Software JDBC Driver for SpaceX.
-
Query SendPulse Data as a SQL Server Database in Node.js
Execute SQL Server queries against SendPulse data from Node.js.
-
Jira Reporting in OBIEE with the Jira JDBC Driver
Deploy the Jira JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Google's Vertex AI Agent with Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Xero data within intelligent workflows.
-
Build a Singer.io Tap for Optimizely With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Optimizely data using the CData Python Connector.
-
Connect to ZohoMarketingHub Data from Crystal Reports
Use CData Connect AI to connect to and report on live ZohoMarketingHub data from Crystal Reports.
-
How to Seamlessly Import Guru Data into IBM SPSS Modeler
Integrate Guru data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Live HCL Domino Data in the Power BI Service
Use CData Connect AI to connect to live HCL Domino data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Excel Add-In for Tally
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Tally.
-
How to Connect DBeaver to Unbounce via a JDBC Driver
Manage Unbounce data with visual tools in DBeaver like the query browser.
-
How to Connect to Live SendPulse 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 SendPulse data for you.
-
Rapidly Develop Bitbucket-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Bitbucket.
-
Create Bitbucket-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Bitbucket Data from Klipfolio and build custom visualizations using live Bitbucket data.
-
Import and Visualize NetSuite Data in Power View
Create data visualizations based on NetSuite data in Excel.
-
Getting Started with the CData JDBC Driver for Jumpseller
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Jumpseller.
-
Automated Continuous SharePoint Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SharePoint replication to Apache Kafka.
-
How to Connect to Notion Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Notion data. Leverage the pyodbc module for ODBC in Python.
-
How to Access Live Float Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Float enables you to integrate Float data into workflows built using Microsoft Power Automate Desktop.
-
Oracle Service Cloud Reporting in OBIEE with the Oracle Service Cloud JDBC Driver
Deploy the Oracle Service Cloud JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Working with Zoho Projects Data in LINQPad
Execute LINQ queries to Zoho Projects data in LINQPad.
-
Create Informatica Mappings From/To a JDBC Data Source for Raisers Edge NXT
Create Raisers Edge NXT data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build CSV-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live CSV data without replication.
-
Connect to Epicor Kinetic Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Epicor Kinetic data.
-
Build Wistia-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Wistia data.
-
Use Claude to Talk to Your XML Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your XML data for you.
-
Build Shortcut-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Shortcut data and build web apps with connectivity to live Shortcut data.
-
Work with Google Directory Data in FoxPro
Load Google Directory data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build a PostgreSQL Interface for MailChimp Data using the CData JDBC Driver
Use the Remoting features of the MailChimp JDBC Driver to create a PostgreSQL entry-point for data access.
-
LINQ to BigCommerce 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 BigCommerce Data Provider.
-
Publish Confluence-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Confluence data.
-
Visualize Live Greenhouse Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Greenhouse data into custom reports in Power BI.
-
Integrating LangGraph with Snowflake Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Snowflake data within automated workflows.
-
Query Freshsales Data as a MySQL Database in Node.js
Execute MySQL queries against Freshsales data from Node.js.