CData Software - Knowledge Base
Recent Articles
-
Connect to HubDB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for HubDB data in Airbyte.
-
Connect Mode to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mode with IBM WebSphere for seamless data integration and connectivity.
-
Create Power BI Reports on Real-Time SQL Server Data
Use the CData ODBC Driver for SQL Server to visualize SQL Server data in Power BI Desktop.
-
Build a Singer.io Tap for Salesloft With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Salesloft data using the CData Python Connector.
-
Use Manus AI to Talk to Your Avro 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 Avro data.
-
Analyze Helpscout Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Helpscout from Power Pivot. You will use the Table Import Wizard to load Helpscout data. You can visually build the import query or use any SQL supported by the driver.
-
How to Easily Query Samanage Data in OpenOffice Base
Connect to Samanage data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
ETL SAP Business Warehouse in Oracle Data Integrator
This article shows how to transfer SAP Business Warehouse data into a data warehouse using Oracle Data Integrator.
-
Query Wrike Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Wrike data from Node.js.
-
Integrating Dataiku with SuiteCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SuiteCRM data.
-
Build eBay Visualizations in Tableau Desktop
Use CData Connect AI to connect to live eBay data and build visualizations in Tableau.
-
How to Visualize Dynamics CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Dynamics CRM data in Python.
-
Create a Data Access Object for Oracle Service Cloud Data using JDBI
A brief overview of creating a SQL Object API for Oracle Service Cloud data in JDBI.
-
How to connect to Webflow Data from Spring Boot
Connect to Webflow in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to MailerLite Data from HeidiSQL
Use CData Connect AI to connect to and query live MailerLite data from HeidiSQL.
-
Integrate with live Tally Data in Jitterbit
Use CData Connect AI to connect to and integrate live Tally data in Jitterbit.
-
Create Power BI Reports on Real-Time MailerLite Data
Use the CData ODBC Driver for MailerLite to visualize MailerLite data in Power BI Desktop.
-
Automated Continuous Square Replication to SQLite
Use CData Sync for automated, continuous, customizable Square replication to SQLite.
-
Connect Gorgias to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Gorgias with IBM WebSphere for seamless data integration and connectivity.
-
Build AI Agents with Certinia Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Certinia data through CData Connect AI.
-
Connect to TigerGraph Data in Jaspersoft Studio
Execute SQL to remote TigerGraph data in Jaspersoft Studio.
-
Use Biml to Build SSIS Tasks to Replicate Bannerbear Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Bannerbear data to SQL Server.
-
Use ChatGPT to Talk to Your ZohoPeople Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your ZohoPeople data for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Jira Assets
Create Jira Assets data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to WordPress from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from WordPress data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Explore Geographical Relationships in TigerGraph Data with Power Map
Create data visualizations with TigerGraph data in Power Map.
-
A PostgreSQL Interface for SendGrid Data (MySQL Remoting via JDBC)
Use the Remoting features of the SendGrid JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Egnyte Data into Power Automate Desktop using CData Connect
CData Connect for Egnyte Data enables you to integrate Egnyte data into workflows built using Microsoft Power Automate Desktop.
-
Create Reports from SAP ByDesign Data in Looker Studio
Use CData Connect AI to gain access to live SAP ByDesign data and create custom reports in Looker Studio.
-
Build Apps with Live Confluence Data Using the Low-Code Development Platform of Mendix
Connect Confluence data with Mendix to build apps using the CData JDBC Driver for Confluence.
-
Create Campaigner-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Campaigner Data from OutSystems and build custom enterprise apps using live Campaigner data.
-
Prepare, Blend, and Analyze QuickBooks Data in Alteryx Designer (Connect AI)
Build workflows to access live QuickBooks data for self-service data analytics.
-
Access Parallel Data from MySQL in PHP
Connect to Parallel through the standard MySQL libraries in PHP.
-
How to Connect Flowise AI Agents to Live LDAP Objects via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live LDAP objects without replication.
-
Connect to Square Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Square data in Airbyte.
-
Connect to Live Neo4J Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Neo4J in CData Connect AI and connect to your Neo4J data from PostgreSQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Shippo
Provide connectivity to Shippo data through an SAP BusinessObjects universe.
-
Automated Continuous JobNimbus Replication to MySQL
Use CData Sync for automated, continuous, customizable JobNimbus replication to MySQL.
-
Access Jira Assets Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Jira Assets data from your Oracle system.
-
Connect to QuickBooks Time Data as an External Source in Dremio
Use the CData JDBC Driver to connect to QuickBooks Time as an External Source in Dremio.
-
Integrate Dify with Live ConstantContact 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 ConstantContact data.
-
Prepare, Blend, and Analyze Klipfolio Data in Alteryx Designer (ODBC)
Build workflows to access live Klipfolio data for self-service data analytics.
-
Replicate Shopify Data in Heroku for Use in Salesforce Connect
Replicate Shopify data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
LINQ to SAP BusinessObjects BI 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 SAP BusinessObjects BI Data Provider.
-
Create Amazon Marketplace-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Amazon Marketplace Data from Klipfolio and build custom visualizations using live Amazon Marketplace data.
-
Connect to SAP HANA Data in DBeaver
Use the CData ODBC Driver to connect to SAP HANA data in DBeaver.
-
How to work with Neo4J Data in Apache Spark using SQL
Access and process Neo4J Data in Apache Spark using the CData Software JDBC Driver.
-
Build Reckon Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Reckon data and build visualizations in Tableau.
-
Building Dynamic Web Pages with MongoDB Data Using AngularJS
Create single-page applications with live connectivity to MongoDB using the CData API Server.
-
Use the CData Software ODBC Driver for Blackbaud FE NXT in MicroStrategy
Connect to Blackbaud FE NXT data in MicroStrategy Developer using the CData Software ODBC Driver for Blackbaud FE NXT.
-
Work with Live Sybase IQ Data in Power Query
Use CData Connect AI to connect to Sybase IQ data and work with live Sybase IQ data in Microsoft Power Query.
-
Connect Quaderno to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Quaderno data using the CData Python MCP Server.
-
Connect to Webex Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Webex data.
-
Create ShipEngine-Connected Nintex Workflows
Use CData Connect AI to connect to ShipEngine Data from Nintex Workflow Cloud and build custom workflows using live ShipEngine data.
-
How to Query ZendeskSell Data in MySQL Workbench
Execute MySQL queries against live ZendeskSell data from MySQL Workbench.
-
Extract, Transform, and Load Datadog Data in Informatica PowerCenter
Create a simple Workflow for Datadog data in Informatica PowerCenter.
-
Use CData Connect AI to Access Adobe Commerce Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Adobe Commerce data in the Power Pivot business intelligence tool.
-
Build Apps with Live Square data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Square data into the Adalo platform and build custom mobile and web applications with real-time Square data.
-
Integrating Cursor with CircleCI 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.
-
Integrating LangGraph with Amazon DynamoDB Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Amazon DynamoDB data within automated workflows.
-
Integrating Claude Code with Redis Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Redis data within assisted coding and automated development workflows.
-
Integrate with live Facebook Ads Data in Jitterbit
Use CData Connect AI to connect to and integrate live Facebook Ads data in Jitterbit.
-
Connect to IBM Cloud Object Storage Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for IBM Cloud Object Storage to connect to IBM Cloud Object Storage data and execute queries in PowerBuilder.
-
Connect to Google Contacts Data in RapidMiner
Integrate Google Contacts data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connecting Pipedream with Greenhouse 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 Greenhouse data in real time.
-
Access Live Epicor Kinetic Data in AWS Lambda
Connect to live Epicor Kinetic data in AWS Lambda using the CData JDBC Driver.
-
Import Google Contacts Data Using Azure Data Factory
Use CData Connect AI to connect to Google Contacts Data from Azure Data Factory and import live Google Contacts data.
-
DataBind MariaDB Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for MariaDB with the DevExpress Windows Forms and Web controls to provide MariaDB data to a chart.
-
Query Salesforce Pardot Data in ColdFusion
Write standard ColdFusion data access code to connect to Salesforce Pardot data.
-
Visualize Bitly 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 Bitly data into TIBCO Spotfire.
-
Connect to Excel Online Data in CloverDX (formerly CloverETL)
Transfer Excel Online data using the visual workflow in the CloverDX data integration tool.
-
How to Query Tavily Data in MySQL Workbench
Execute MySQL queries against live Tavily data from MySQL Workbench.
-
Work with Live Klipfolio Data in Power Query
Use CData Connect AI to connect to Klipfolio data and work with live Klipfolio data in Microsoft Power Query.
-
Import Tally Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Tally Data and provide access to live Tally data for custom reports in the Power BI Service.
-
Create Reports with Clio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Clio data.
-
How to work with Parallel Data in Apache Spark using SQL
Access and process Parallel Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to JSON Services from a Connection Pool in JBoss
Integrate JSON services into Java servlets: Use the Management Console in JBoss to install the JSON JDBC Driver.
-
Build Greenplum-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Greenplum Data and create custom apps in Bubble.
-
How to use SQLAlchemy ORM to access Jira Assets Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Jira Assets data.
-
Connect to MongoDB Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with MongoDB Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Devin with Live xBase Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live xBase data.
-
Import Real-Time Stack Exchange Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Stack Exchange data in ColdFusion.
-
Connect to SAP HANA Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP HANA as an External Source in Dremio.
-
Replicate Snapchat Ads Data from PowerShell
Write a quick PowerShell script to query Snapchat Ads data. Use connectivity to the live data to replicate Snapchat Ads data to SQL Server.
-
Integrate with Deel Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Deel data to a JSON file on disk.
-
How to integrate Vimeo with Apache Airflow
Access and process Vimeo data in Apache Airflow using the CData JDBC Driver.
-
Connect to Greenhouse Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Greenhouse data.
-
Use the CData ODBC Driver for QuickBooks Time in Microsoft Power Query
You can use the CData QuickBooks Time ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import QuickBooks Time data into Microsoft Power Query.
-
Automate Workable Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Workable data from PowerShell? This article demonstrates how to utilize the Workable Cmdlets for tasks like connecting to Workable data, automating operations, downloading data, and more.
-
Interact with Live Office 365 Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Office 365 data.
-
How to Connect Flowise AI Agents to Live DB2 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 DB2 data without replication.
-
Publish BigCommerce-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live BigCommerce data.
-
Create Dynamic Strava Grids Using the Infragistics XamDataGrid
Learn how you can connect Strava to Infragistics XamDataGrid to build dynamic grids.
-
Bridge Front Connectivity with Apache NiFi
Access and process Front data in Apache NiFi using the CData JDBC Driver.
-
Analyze Testmonitor Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Testmonitor from Power Pivot. You will use the Table Import Wizard to load Testmonitor data. You can visually build the import query or use any SQL supported by the driver.
-
Analyze Samanage Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Samanage from Power Pivot. You will use the Table Import Wizard to load Samanage data. You can visually build the import query or use any SQL supported by the driver.
-
Automate Salesforce Pardot Data Replication to Azure Data Lake
Use CData Sync to customize and automate Salesforce Pardot data replication to Azure Data Lake.
-
How to Connect to Live Vertica Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Vertica data without replication.
-
Build a Singer.io Tap for Azure Analysis Services With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Azure Analysis Services data using the CData Python Connector.
-
Connect to Gorgias Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Gorgias as an External Source in Dremio.