CData Software - Knowledge Base
Recent Articles
-
Connect to Exa Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Exa data using standard SQL.
-
Operational Reporting on Recurly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Recurly data.
-
Configure the CData JDBC Driver for FreeAgent in a Connection Pool in Tomcat
Connect to FreeAgent data from a connection pool in Tomcat.
-
Use Grok to Talk to Your Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Smartsheet data for you.
-
Automated Continuous Outreach.io Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Outreach.io replication to delimited files (CSV/TSV).
-
Integrating Kiro with Reckon 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 Dashboards with FormSite Data in Dundas BI
Create dynamic dashboards and perform analytics based on FormSite data in Dundas BI.
-
Connect to Mailjet Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Mailjet.
-
Build a Singer.io Tap for AdRoll With the CData Python Connector
Learn how to easily build a Singer.io Tap for live AdRoll data using the CData Python Connector.
-
Connect to HCL Domino Data from PowerBuilder via ADO.NET
This article demonstrates how to access HCL Domino data from Appeon PowerBuilder using the CData ADO.NET Provider for HCL Domino.
-
Automated Continuous Browserless Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Browserless replication to Amazon S3.
-
Connect to Superchat Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Superchat to connect to Superchat data and execute queries in PowerBuilder.
-
Build Semantic Layer Views for Calendly Data in APOS Live Data Gateway
Use the CData Connector for Calendly in APOS Live Data Gateway to build Semantic Layer Views for Calendly data.
-
Work with Google Calendar Data in FoxPro
Load Google Calendar data into a FoxPro database. This article includes full code and a walk-through of the process.
-
DataBind Charts to Parallel Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Parallel data 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.
-
Replicate Productboard Data from PowerShell
Write a quick PowerShell script to query Productboard data. Use connectivity to the live data to replicate Productboard data to SQL Server.
-
Visualize CapsuleCRM 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 CapsuleCRM data into TIBCO Spotfire.
-
Integrating LlamaIndex with FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on FreshBooks data in real time.
-
Create Grafana Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Grafana from PowerBI.com to create Power BI Dataflows with real-time data.
-
Analyze Reckon Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Reckon data and visualize live Reckon data in Infragistics Reveal.
-
Connect to MySQL Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live MySQL data.
-
Query ZohoInvoice Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoInvoice data.
-
Connect to SAP Netweaver Gateway Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Netweaver Gateway data from PowerBuilder using the SAP Netweaver Gateway JDBC Driver.
-
Excel Spreadsheet Automation on Sentry Data with the QUERY Formula
Pull data from Sentry, automate spreadsheets, and more with the QUERY formula.
-
How to load Gumroad data into Elasticsearch via Logstash
Introducing a simple method to load Gumroad data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect to Testmonitor Data in DBVisualizer
Integrate Testmonitor data with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze SageHR Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SageHR data and visualize live SageHR data in Infragistics Reveal.
-
How to connect to Oracle Eloqua Reporting Data in DBVisualizer
Integrate Oracle Eloqua Reporting data with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Bullhorn CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Bullhorn CRM data in Microsoft R Open.
-
Automated Continuous Short.io Replication to Oracle
Use CData Sync for automated, continuous, customizable Short.io replication to Oracle.
-
Use the CData Software ODBC Driver for Ontraport in SAS for Real-Time Reporting and Analytics
Connect to real-time Ontraport data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Ontraport.
-
Integrating Gumloop with PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on PayPal data within automated workflows.
-
Automated Continuous Oracle SCM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle SCM data replication to OneLake in Microsoft Fabric.
-
How to Build an ETL App for Foursquare Data in Python with CData
Create ETL applications and real-time data pipelines for Foursquare data in Python with petl.
-
Connect and Visualize Live Dynamics NAV Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Dynamics NAV data into the Databricks platform and create visualization dashboards with real-time Dynamics NAV data.
-
Connecting Moonlit Workflow with Bitbucket 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 Bitbucket data in real time.
-
How to publish and share Greenplum Data dashboards with Tableau Server
The CData ODBC driver for Greenplum enables you integrate Greenplum data into Tableau dashboards.
-
DataBind Controls to Perplexity Data in Delphi
DataBind to Perplexity data in Delphi with standard data access components and controls.
-
Working with Excel Online Data in LINQPad
Execute LINQ queries to Excel Online data in LINQPad.
-
Create Reports with EmailOctopus Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date EmailOctopus data.
-
Link Perplexity with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Perplexity data in Filemaker Pro for Mac or Windows.
-
Connect to Live Freshdesk Data in MicroStrategy through CData Connect AI
Create a live connection to Freshdesk Data in CData Connect AI and connect to your Freshdesk data from MicroStrategy.
-
Use Azure AI Foundry to Talk to Your Bright Data Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Bright Data data for you.
-
Connect to ChargeOver in SpagoBI
Create reports featuring live ChargeOver data in SpagoBI Studio. Host ChargeOver reports on SpagoBI Server.
-
How to Connect Samanage 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 Samanage data in real time using natural language.
-
Getting Started with the CData Python Connector for Opsgenie
Learn to install and license the CData Python Connector and configure a connection to live Opsgenie data.
-
Object-Relational Mapping (ORM) with Auth0 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 Auth0 data into a Java-based ORM framework, Hibernate.
-
Use Databricks Agent Bricks to Talk to Your Elasticsearch Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Elasticsearch data for you.
-
Integrate with Freshdesk Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Freshdesk data to a JSON file on disk.
-
How to work with Marketo Data in Apache Spark using SQL
Access and process Marketo Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData SSIS Components for Invoiced
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Invoiced.
-
Build SharePoint-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SharePoint data and build web apps with connectivity to live SharePoint data.
-
Visualize EmailOctopus Data in Sisense
Create an ElastiCube in Sisense app with access to EmailOctopus data.
-
Use Manus AI to Talk to Your Slack 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 Slack data.
-
How to Connect DBeaver to Tanda via a JDBC Driver
Manage Tanda data with visual tools in DBeaver like the query browser.
-
Build Automated Workflows with Live Dynamics 365 Data in Workato
Use CData Connect AI to connect to live Dynamics 365 data and build automated workflows in Workato.
-
Connect to Box Data in HULFT Integrate
Connect to Box as a JDBC data source in HULFT Integrate
-
Integrating Cursor with ChargeOver 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.
-
Create Dashboards and Visualize Live ShipStation Data in Geckoboard
Use CData Connect AI to connect to live ShipStation data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build a PostgreSQL Interface for Stack Exchange Data using the CData JDBC Driver
Use the Remoting features of the Stack Exchange JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to import Slack Data into Apache Solr
Use the CData Software JDBC Driver for Slack in Data Import Handler and create an automated import of Slack data to Apache Solr Enterprise Search platform.
-
Use the CData Software JDBC Driver for Basecamp in MicroStrategy
Connect to Basecamp data in MicroStrategy Developer using the CData Software JDBC Driver for Basecamp.
-
Create Data Visualizations in Cognos BI with SAP Business Warehouse Data
Access SAP Business Warehouse data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Dashboards and Visualize Live MailerLite Data in Geckoboard
Use CData Connect AI to connect to live MailerLite data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Connect to Live Impala 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 Impala data for you.
-
Process & Analyze Codat Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Codat Data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Front
Provide connectivity to Front data through an SAP BusinessObjects universe.
-
Build Apps with Live Auth0 Data Using the Low-Code Development Platform of Mendix
Connect Auth0 data with Mendix to build apps using the CData API Driver for JDBC.
-
How to Connect to Live AgileCRM Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live AgileCRM data securely in real time.
-
Create a Data Access Object for Salesforce Data using JDBI
A brief overview of creating a SQL Object API for Salesforce data in JDBI.
-
Use the CData ODBC Driver for RabbitMQ from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for RabbitMQ to connect to RabbitMQ data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring RabbitMQ data in Excel.
-
How to Query Live MariaDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MariaDB data data in natural language using Python.
-
Query, Visualize, and Share live Salesforce Data 360 Data in Redash
Use CData Connect AI to connect to live Salesforce Data 360 data in Redash for querying, visualizing, and sharing.
-
Automated Continuous Teradata Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Teradata replication to AlloyDB.
-
How to integrate Metabase with ZohoInvoice Data
Use CData Connect AI to connect to live ZohoInvoice data and create an interactive dashboard in Metabase from ZohoInvoice data.
-
Create a Data Access Object for Klipfolio Data using JDBI
A brief overview of creating a SQL Object API for Klipfolio data in JDBI.
-
Model, Search, and Visualize Live Gong Data in ThoughtSpot
Use CData Connect AI to connect to live Gong data for modeling, searching, and visualizing.
-
Create Adobe Experience Manager Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Adobe Experience Manager data access from reports, embedded analytics, and more.
-
Manage MongoDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MongoDB.
-
How to Easily Query Blackbaud FE NXT Data in OpenOffice Base
Connect to Blackbaud FE NXT data in OpenOffice Base using the CData ODBC Driver for Blackbaud FE NXT and generate reports with live data insights.
-
Integrate Google's Antigravity Agent with Live Discord Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Discord data using the Model Context Protocol.
-
How to Work with Typeform Data in AWS Glue Jobs Using JDBC
Connect to Typeform from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Timely Data in Coginiti Pro
Connect to and query live Timely data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Intercom Replication to Databricks
Use CData Sync for automated, continuous, customizable Intercom replication to Databricks.
-
Connect to Demio Data from a Connection Pool in Jetty
The Demio JDBC Driver supports connection pooling: This article shows how to connect faster to Demio data from Web apps in Jetty.
-
Migrating data from Azure Data Catalog to Snowflake using CData SSIS Components.
Easily push Azure Data Catalog data to Snowflake using the CData SSIS Tasks for Azure Data Catalog and Snowflake.
-
Connect to OneNote Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live OneNote data.
-
Automate CampaignMonitor Data Replication to SAP HANA
Use CData Sync to customize and automate CampaignMonitor data replication to SAP HANA.
-
Publish ZeroBounce-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZeroBounce data.
-
Use Manus AI to Talk to Your Wave Financial 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 Wave Financial data.
-
Integrate Cline with Live Sage 300 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sage 300 data from within your IDE.
-
How to connect Amazon QuickSight to Mode Data
Create a connection to Mode data in CData Connect AI and insert Mode data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect and Query Live Azure Synapse Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure Synapse data into Databricks and enable direct, live querying and analysis without replication.
-
Model Cvent Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Cvent, enabling the direct import of real-time Cvent data.
-
ServiceNow Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ServiceNow data through CData Connect AI using different applications and tools.
-
Publish Reports with CampaignMonitor Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CampaignMonitor data.
-
Using the CData Software ODBC Driver for iContact in PyCharm
Connect to iContact as an ODBC data source in PyCharm using the CData Software ODBC Driver for iContact.
-
How to load LDAP data into Elasticsearch via Logstash
Introducing a simple method to load LDAP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live HubSpot Data in AWS Lambda
Connect to live HubSpot data in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData Power BI Connector for Google Calendar
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Calendar.