CData Software - Knowledge Base
Recent Articles
-
Connect to Toggl Data in Aqua Data Studio
Access Toggl data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to integrate Metabase with PayPal Data
Use CData Connect AI to connect to live PayPal data and create an interactive dashboard in Metabase from PayPal data.
-
Access Live MongoDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MongoDB data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Open WebUI with Live Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Trello data from within the chat interface.
-
Connect OData Services to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your OData services using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to LightSpeedRetail in SpagoBI
Create reports featuring live LightSpeedRetail data in SpagoBI Studio. Host LightSpeedRetail reports on SpagoBI Server.
-
Connecting Moonlit Workflow with Tally 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 Tally data in real time.
-
Connect to Active Directory from a Connection Pool in WebLogic
Use the CData JDBC Driver for Active Directory to connect to Active Directory data from Web applications running on WebLogic.
-
Automated Microsoft Entra ID Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft Entra ID data replication to Teradata.
-
Access Live Blackbaud FE NXT Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Blackbaud FE NXT data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze Redis Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Redis data with the CData JDBC Driver for Redis.
-
Operational Reporting on SQL Server Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SQL Server data.
-
Getting Started with the CData ODBC Driver for Demio
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Demio.
-
Query Mailjet Data in ColdFusion
Write standard ColdFusion data access code to connect to Mailjet data.
-
Analyze Microsoft Teams Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Teams data and visualize live Microsoft Teams data in Infragistics Reveal.
-
Automated Continuous Microsoft Planner Replication to Vertica
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Vertica.
-
Automated RabbitMQ Data Replication to Teradata
Use CData Sync to Customize and automate RabbitMQ data replication to Teradata.
-
Automated Continuous Keap Replication to MongoDB
Use CData Sync for automated, continuous, customizable Keap replication to MongoDB.
-
Feed Perplexity Data into FineReport
How to set Perplexity data as a JDBC data source in FineReport.
-
Build MVC Applications with Connectivity to Mistral AI Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Mistral AI from an ASP.NET MVC application.
-
Write a Simple Go Application to work with Drip Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Drip data.
-
Connect to Exact Online Data from PowerBuilder via ADO.NET
This article demonstrates how to access Exact Online data from Appeon PowerBuilder using the CData ADO.NET Provider for Exact Online.
-
Visualize Postmark Data in TIBCO Spotfire through ADO.NET
Integrate Postmark data into dashboards in TIBCO Spotfire.
-
Deploy the ADO.NET Provider for CSV on an SSRS Report Server
Connect to CSV data 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.
-
SAS xpt Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAS xpt facts in real time.
-
Build Voice Agents in ElevenLabs with access to Live Dynamics NAV Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Dynamics NAV data.
-
Moving Data from EnterpriseDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live EnterpriseDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to import Unbounce Data into Apache Solr
Use the CData Software JDBC Driver for Unbounce in Data Import Handler and create an automated import of Unbounce data to Apache Solr Enterprise Search platform.
-
How to Access Live Airtable Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Airtable enables you to integrate Airtable data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Antigravity CLI with Wrike data via CData CLI
Connect Wrike data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
DataBind SAP Netweaver Gateway Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP Netweaver Gateway with the DevExpress Windows Forms and Web controls to provide SAP Netweaver Gateway data to a chart.
-
Build Visualizations of Cassandra Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Cassandra data in Birst.
-
Integrate with live Oracle SCM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Oracle SCM data in Jitterbit.
-
Build AI/ML Models with Live Oracle Data using Dataiku
Connect Oracle Data with Dataiku using the CData JDBC Driver for Oracle.
-
Automate Pipeliner CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Pipeliner CRM data from PowerShell? This article demonstrates how to utilize the Pipeliner CRM Cmdlets for tasks like connecting to Pipeliner CRM data, automating operations, downloading data, and more.
-
How to Access Live Mocean Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Mocean enables you to integrate Mocean data into workflows built using Microsoft Power Automate Desktop.
-
How to create Discord federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Discord data in MySQL .
-
Build a PostgreSQL Interface for Zoho Books Data using the CData JDBC Driver
Use the Remoting features of the Zoho Books JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Elasticsearch Data in Looker
Use CData Connect AI to connect to Elasticsearch Data from Looker and build custom apps using live Elasticsearch data.
-
Connect to Apify Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Apify data from Filemaker Pro on Mac.
-
Connecting Pipedream with iContact 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 iContact data in real time.
-
Integrating GitHub Copilot with MYOB AccountRight 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.
-
Build BambooHR-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for BambooHR Data and create custom apps in Mendix.
-
Back Up Apify data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Apify data data.
-
Visualize Nethunt 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 Nethunt data into TIBCO Spotfire.
-
Create Power BI Reports on Real-Time Coinbase Data
Use the CData ODBC Driver for Coinbase to visualize Coinbase data in Power BI Desktop.
-
Connecting Pipedream with Salesforce 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 Salesforce data in real time.
-
Integrate with Live Dynamics NAV Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Dynamics NAV from the MuleSoft Anypoint Platform to integrate live Dynamics NAV data into custom reports and dashboards.
-
Create LinkedIn-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to LinkedIn Data from OutSystems and build custom enterprise apps using live LinkedIn data.
-
Use ChatGPT to Talk to Your Mode 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 Mode data for you.
-
How to Connect to Live Databricks 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 Databricks data for you.
-
Use CData Connect AI to Access BigCommerce Data in Microsoft Power Pivot
Use CData Connect AI to connect to live BigCommerce data in the Power Pivot business intelligence tool.
-
Access Workday Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Workday data from your Oracle system.
-
Visualize SQL Server Data in TIBCO Spotfire through OData
Integrate SQL Server data into dashboards in TIBCO Spotfire.
-
Integrate Goose with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SQL Server data from within the local AI agent.
-
Connect to Flowlu Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Flowlu to connect to Flowlu data and execute queries in PowerBuilder.
-
Building Dynamic Web Pages with Phoenix Data Using AngularJS
Create single-page applications with live connectivity to Phoenix using the CData API Server.
-
Automate Monday.com Data Replication to SAP HANA
Use CData Sync to customize and automate Monday.com data replication to SAP HANA.
-
Access Tally 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 Tally data.
-
Automated Continuous Coinbase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Coinbase replication to PostgreSQL.
-
Connecting GenSpark with FHIR Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to FHIR data without any replication or custom integration required.
-
Visualize Cloudflare 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 Cloudflare data into TIBCO Spotfire.
-
Connect to eBay Data in HULFT Integrate
Connect to eBay as a JDBC data source in HULFT Integrate
-
Use the CData Software JDBC Driver for Coda in MicroStrategy
Connect to Coda data in MicroStrategy Developer using the CData Software JDBC Driver for Coda.
-
Automated Continuous Freshteam Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Freshteam replication to Azure SQL Database.
-
How to update Zoho Inventory from Excel
This article explains how to transfer data from Excel to Zoho Inventory using the Excel Add-In for Zoho Inventory.
-
Create Vercel Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Vercel from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate with Live FTP Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to FTP from the MuleSoft Anypoint Platform to integrate live FTP data into custom reports and dashboards.
-
How to Visualize BigQuery Data in Python with pandas
Use pandas and other modules to analyze and visualize live BigQuery data in Python.
-
Integrating Codex with Reply.io 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.
-
Work with Live ZohoExpense Data in Power Query
Use CData Connect AI to connect to ZohoExpense data and work with live ZohoExpense data in Microsoft Power Query.
-
Create Missive Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Missive data access from reports, embedded analytics, and more.
-
Work with Live YouTube Analytics Data in Power Query
Use CData Connect AI to connect to YouTube Analytics data and work with live YouTube Analytics data in Microsoft Power Query.
-
Connect to Cassandra Data from a Connection Pool in Jetty
The Cassandra JDBC Driver supports connection pooling: This article shows how to connect faster to Cassandra data from Web apps in Jetty.
-
Import SAP Hybris C4C Data Using Azure Data Factory
Use CData Connect AI to connect to SAP Hybris C4C Data from Azure Data Factory and import live SAP Hybris C4C data.
-
Create Azure Analysis Services-Connected Business Apps in AppSheet
Connect to Azure Analysis Services Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Azure Analysis Services data.
-
Automated Continuous Teamgate Replication to MongoDB
Use CData Sync for automated, continuous, customizable Teamgate replication to MongoDB.
-
Extract, Transform, and Load SAP Data in Informatica PowerCenter
Create a simple Workflow for SAP data in Informatica PowerCenter.
-
Use the CData SSIS Components to Insert New or Update Existing Redshift Records from SQL Server
Easily push SQL Server data to Redshift using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Redshift or update existing records with data from a SQL Server database.
-
Integrate Dify with Live Azure Analysis Services 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 Azure Analysis Services data.
-
Use the CData Software JDBC Driver for eBay Analytics in MicroStrategy Desktop
Connect to eBay Analytics data in MicroStrategy Desktop using the CData Software JDBC Driver for eBay Analytics.
-
Working with Dynamics CRM Data in LINQPad
Execute LINQ queries to Dynamics CRM data in LINQPad.
-
Write a Simple Go Application to work with AlloyDB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to AlloyDB data.
-
Build Semantic Layer Views for Campaigner Data in APOS Live Data Gateway
Use the CData Connector for Campaigner in APOS Live Data Gateway to build Semantic Layer Views for Campaigner data.
-
Integrate SFTP with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SFTP with External Services.
-
Integrate Live Lakebase Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Lakebase from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Lakebase data.
-
MongoDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MongoDB facts in real time.
-
Object-Relational Mapping (ORM) with Impala 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 Impala data into a Java-based ORM framework, Hibernate.
-
Replicate SAP Concur Data to Multiple Databases via the CData Sync CLI
Replicate SAP Concur data to disparate databases with a single configuration.
-
Integrating Cursor with Shortcut 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.
-
Build Semantic Layer Views for SAP Ariba Source Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Ariba Source data.
-
Automated Continuous Customer.io Replication to SingleStore
Use CData Sync for automated, continuous, customizable Customer.io replication to SingleStore.
-
Connect to SAP HANA XS Advanced Data from a Connection Pool in JBoss
Integrate SAP HANA XS Advanced data into Java servlets: Use the Management Console in JBoss to install the SAP HANA XS Advanced JDBC Driver.
-
How to Use a Microsoft Access Database to Update Dynamics CRM Data in Real Time
Update Dynamics CRM data by creating a linked table in Microsoft Access with the CData Dynamics CRM ODBC Driver.
-
Integrating LlamaIndex with NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on NetSuite data in real time.
-
Automated Continuous Everhour Replication to Snowflake
Use CData Sync for automated, continuous, customizable Everhour replication to Snowflake.
-
Build a Simple VCL Application for Exact Online Data
How to build a simple VCL Application to view Exact Online data in RAD Studio using the CData ODBC Driver for Exact Online.
-
Automated Continuous Quickbase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Quickbase replication to AlloyDB.
-
Create Reports with Tanda Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Tanda data.
-
How to connect to AdRoll Data from IntelliJ
Integrate connectivity to AdRoll data with wizards in IntelliJ.