CData Software - Knowledge Base
Recent Articles
-
Integrating Codex CLI with Productboard 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 Mouseflow from a Connection Pool in WebLogic
Use the CData JDBC Driver for Mouseflow to connect to Mouseflow from Web applications running on WebLogic.
-
Automate SAP HANA XS Advanced Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP HANA XS Advanced and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Bidirectional Access to LightSpeedRetail Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate LightSpeedRetail in Filemaker Pro for Mac or Windows.
-
Connect to Perplexity Data in NetBeans
Connect to Perplexity in NetBeans with the data source configuration wizard.
-
Build Basecamp Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Basecamp and build visualizations in Tableau Cloud.
-
Build JSON Visualizations in Tableau Cloud
Use CData Connect AI to connect to live JSON and build visualizations in Tableau Cloud.
-
Integrating Claude Code with Freshdesk Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Freshdesk within assisted coding and automated development workflows.
-
Integrating Gumloop with PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on PostgreSQL within automated workflows.
-
Automated Continuous GitHub Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable GitHub replication to OneLake in Microsoft Fabric.
-
Replicate Google Spanner Data to Multiple Databases
Replicate Google Spanner to disparate databases with a point-and-click configuration.
-
Automated Continuous Chargebee Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Chargebee replication to Amazon S3.
-
How to use SQLAlchemy ORM to access Suadeo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Suadeo.
-
How to work with Reckon Data in Apache Spark using SQL
Access and process Reckon Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData API Server to Access HCL Domino Data in Microsoft PowerPivot
Use the CData API Server to connect to live HCL Domino in the Power Pivot business intelligence tool.
-
Access RabbitMQ Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live RabbitMQ from HeidiSQL.
-
Connect to Clari Data from PowerBuilder via JDBC
This article demonstrates how to access Clari from PowerBuilder using the Clari JDBC Driver.
-
Import Real-Time ServiceNow Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ServiceNow in ColdFusion.
-
Use Dash to Build to Web Apps on PivotalTracker Data
Create Python applications that use pandas and Dash to build PivotalTracker-connected web apps.
-
Migrating data from JobNimbus to Snowflake using CData SSIS Components.
Easily push JobNimbus to Snowflake using the CData SSIS Tasks for JobNimbus and Snowflake.
-
Build Dashboards with PivotalTracker Data in Dundas BI
Create dynamic dashboards and perform analytics based on PivotalTracker in Dundas BI.
-
Create Dynamic Factorial Grids Using the Infragistics XamDataGrid
Learn how you can connect Factorial to Infragistics XamDataGrid to build dynamic grids.
-
Deploy the ADO.NET Provider for Okta on an SSRS Report Server
Connect to Okta 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 Connect to Live Microsoft Ads Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Microsoft Ads without replication.
-
Integrate Live Facebook Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Facebook from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Facebook.
-
Integrating Claude Code CLI with Spark 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.
-
Import Real-Time Freshservice Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Freshservice in ColdFusion.
-
Work with Live SAP BusinessObjects BI Data in Power Query
Use CData Connect AI to connect to SAP BusinessObjects BI and work with live SAP BusinessObjects BI in Microsoft Power Query.
-
Provide OData Services of Perplexity Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Perplexity by developing a WCF Service Application.
-
Automate Mocean Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Mocean from PowerShell? This article demonstrates how to utilize the Mocean Cmdlets for tasks like connecting to Mocean, automating operations, downloading data, and more.
-
Connect to BambooHR Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with BambooHR Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Seamlessly Bring MYOB AccountRight Data into Retool Using CData Connect AI
Integrate MYOB AccountRight data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to load Marketo data into Elasticsearch via Logstash
Introducing a simple method to load Marketo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Migrating data from RSS to Databricks using CData SSIS Components.
Easily push RSS Feeds to Databricks using the CData SSIS Tasks for RSS and Databricks.
-
How to Access Sage 300 Data Using Entity Framework
This article shows how to access Sage 300 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Bugsnag Replication to Oracle
Use CData Sync for automated, continuous, customizable Bugsnag replication to Oracle.
-
Automated Continuous Certinia Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Certinia replication to OneLake in Microsoft Fabric.
-
Automated Continuous ZohoPeople Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Azure SQL Database.
-
How to publish and share Spotify Data dashboards with Tableau Server
The CData ODBC driver for Spotify enables you integrate Spotify into Tableau dashboards.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Amazon Redshift to Power BI dashboards. Simply drag and drop Amazon Redshift into data visuals on the Power BI canvas.
-
DataBind Charts to Hubstaff Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Hubstaff 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.
-
Integrate with Live SAP SuccessFactors LMS Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP SuccessFactors LMS from the MuleSoft Anypoint Platform to integrate live SAP SuccessFactors LMS into custom reports and dashboards.
-
Integrate with Samanage Data in JReport Designer
Create charts and reports based on Samanage in JReport Designer.
-
Build Exact Online-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Exact Online Data and create custom apps in Bubble.
-
Connect PhantomBuster to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live PhantomBuster using the CData Python MCP Server.
-
Connect to ConvertKit Data in Aqua Data Studio
Access ConvertKit from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Dashboards with Confluence Data in Dundas BI
Create dynamic dashboards and perform analytics based on Atlassian Confluence in Dundas BI.
-
How to load Drift data into Elasticsearch via Logstash
Introducing a simple method to load Drift data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Visualize SAP SuccessFactors 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 SAP SuccessFactors into TIBCO Spotfire.
-
Build QuickBooks Time-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for QuickBooks Time to explore live QuickBooks Time Data in Claude Code to assist with building QuickBooks Time-powered applications.
-
Automated Continuous Salesloft Replication to Snowflake
Use CData Sync for automated, continuous, customizable Salesloft replication to Snowflake.
-
How to work with Wave Financial Data in Apache Spark using SQL
Access and process Wave Financial Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate with Cohere Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Cohere to a JSON file on disk.
-
Integrating Kiro CLI with Exa 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.
-
Connect to MariaDB Data in RapidMiner
Integrate MariaDB with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to MailerLite Data from PowerBuilder via JDBC
This article demonstrates how to access MailerLite from PowerBuilder using the MailerLite JDBC Driver.
-
Access QuickBooks Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access QuickBooks Desktop from your Oracle system.
-
Connect to Spotify Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Spotify and work with Spotify in your FileMaker applications.
-
Connecting Mastra with Reckon Accounts Hosted Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Reckon Accounts Hosted, no replication required.
-
Build a Singer.io Tap for PDFMonkey With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PDFMonkey data using
-
Getting Started with the CData Python Connector for Tanda
Learn to install and license the CData Python Connector
-
Object-Relational Mapping (ORM) with Tanda Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Tanda into a Java-based ORM framework, Hibernate.
-
Access Live OneNote Data in TIBCO Data Virtualization
Use the OneNote Tibco DV Adapter to create a Microsoft OneNote data source in TIBCO Data Virtualization Studio and gain access to live Microsoft OneNote from your TDV Server.
-
Connecting Moonlit Workflow with FTP Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your FTP Servers in real time.
-
How to Visualize Stripe Data in Python with pandas
Use pandas and other modules to analyze and visualize live Stripe in Python.
-
Import Real-Time Onfleet Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Onfleet in ColdFusion.
-
Integrating Antigravity CLI with Act-On via CData CLI
Connect Act-On to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Cursor with Live MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live MariaDB from within the editor.
-
How to connect to Apify Data in DBVisualizer
Integrate Apify with visual data analysis tools and data connection wizards in DBVisualizer
-
DataBind BambooHR Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide BambooHR to a chart.
-
Build QuickBooks-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for QuickBooks to explore live QuickBooks Data in GitHub Copilot to assist with building QuickBooks-powered applications.
-
Automate EmailOctopus Data Replication to Azure Data Lake
Use CData Sync to customize and automate EmailOctopus replication to Azure Data Lake.
-
Moving Data from SpaceX to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SpaceX data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
A PostgreSQL Interface for HubDB Data using the CData ODBC Driver
Use the SQL Gateway and HubDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Close Data in RazorSQL
Connect to Close from wizards and query Close from the GUI in the RazorSQL database management tool.
-
Integrate Live Redis Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Redis to Blue Prism using the CData ODBC Driver for Redis to create automated workflows for repetitive business tasks.
-
Automated Continuous ADP Replication to Oracle
Use CData Sync for automated, continuous, customizable ADP replication to Oracle.
-
Integrate with eBay Analytics Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy eBay Analytics to a JSON file on disk.
-
Import Real-Time PabblySubscriptions Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PabblySubscriptions in ColdFusion.
-
How to Query Live Oracle Eloqua Reporting Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle Eloqua Reporting data in natural language using Python.
-
Getting Started with the CData Power BI Connector for ZohoExpense
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Calendly Data in Jaspersoft Studio
Execute SQL to remote Calendly in Jaspersoft Studio.
-
Build Freshdesk-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Freshdesk Data and create custom apps in Mendix.
-
Getting Started with the CData Python Connector for DB2
Learn to install and license the CData Python Connector
-
Design BIRT Reports on ZarMoney Data
Provide current ZarMoney to your embedded analytics.
-
Build Avalara AvaTax-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Avalara AvaTax.
-
Use the CData Software ODBC Driver for Pingdom in MicroStrategy Desktop
Connect to Pingdom in MicroStrategy Desktop using the CData Software ODBC Driver for Pingdom.
-
Access Salesforce CRM Analytics Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Salesforce CRM Analytics from your Oracle system.
-
Publish Reports with Oracle SCM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle SCM.
-
Automated Continuous Salesforce CRM Analytics Replication to Snowflake
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Snowflake.
-
PhantomBuster Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on PhantomBuster facts in real time.
-
Create Data Visualizations in Cognos BI with Greenhouse Data
Access Greenhouse as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build BigQuery-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for BigQuery to explore live BigQuery Data in Gemini Code Assist to assist with building BigQuery-powered applications.
-
Validate MySQL Data with QuerySurge
Access and validate MySQL in QuerySurge using the CData JDBC Driver.
-
How to integrate Metabase with Cosmos DB Data
Use CData Connect AI to connect to live Azure Cosmos DB and create an interactive dashboard in Metabase from Azure Cosmos DB.
-
Excel Spreadsheet Automation on ZohoMarketingHub Data with the QUERY Formula
Pull data from ZohoMarketingHub, automate spreadsheets, and more with the QUERY formula.
-
How to integrate Sybase with Apache Airflow
Access and process Sybase in Apache Airflow using the CData JDBC Driver.
-
Build Visualizations of NetSuite Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of NetSuite CRM & ERP in Birst.
-
Use the CData Software ODBC Driver for BenchmarkEmail in MicroStrategy Web
Connect to BenchmarkEmail in MicroStrategy Web using the CData Software ODBC Driver for BenchmarkEmail.
-
Migrating data from LDAP to Google BigQuery using CData SSIS Components.
Easily push LDAP to Google BigQuery using the CData SSIS Tasks for LDAP and Google BigQuery.