CData Software - Knowledge Base
Recent Articles
-
Connect to ChargeOver Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ChargeOver data using standard SQL.
-
Connect to Amazon S3 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Amazon S3 as an External Source in Dremio.
-
Query Sage 300 Data in ColdFusion
Write standard ColdFusion data access code to connect to Sage 300 data.
-
Integrating Dataiku with CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live CouchDB data.
-
Access Active Directory Data from MySQL in Amazon QuickSight
Connect to Active Directory and build visualizations of Active Directory data using a MySQL Connection in Amazon QuickSight.
-
Integrate with BambooHR Data in JReport Designer
Create charts and reports based on BambooHR data in JReport Designer.
-
Connect to Beeminder Data in RapidMiner
Integrate Beeminder data with standard components and data source configuration wizards in RapidMiner Studio.
-
Import Real-Time Splunk Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Splunk data in ColdFusion.
-
DataBind Controls to Email Data in Delphi
DataBind to Email data in Delphi with standard data access components and controls.
-
Operational Reporting on Shippo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Shippo data.
-
A PostgreSQL Interface for Excel Data using the CData ODBC Driver
Use the SQL Gateway and Excel ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Adobe Target Data in JRuby
Create a simple JRuby app with access to live Adobe Target data.
-
Amazon S3 Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Amazon S3 data through CData Connect AI using different applications and tools.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Azure SQL Database.
-
Use the CData Software ODBC Driver for Ontraport in MicroStrategy
Connect to Ontraport data in MicroStrategy Developer using the CData Software ODBC Driver for Ontraport.
-
How to Easily Query Typeform Data in OpenOffice Base
Connect to Typeform data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build MVC Applications with Connectivity to Gong Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Gong from an ASP.NET MVC application.
-
Query Omnisend Data as a SQL Server Database in Node.js
Execute SQL Server queries against Omnisend data from Node.js.
-
Automated Continuous Paylocity Replication to SQL Server
Use CData Sync for automated, continuous, customizable Paylocity replication to SQL Server.
-
Connect to Active Directory Data in Claris FileMaker Pro
Use the CData ODBC Driver for Active Directory in FileMaker Pro to connect to Active Directory and work with Active Directory data in your FileMaker applications.
-
Visualize Live Oracle Data in the Power BI Service
Use CData Connect AI to connect to live Oracle data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build a Singer.io Tap for Sage 200 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sage 200 data using the CData Python Connector.
-
Build Dashboards with ServiceNow Data in DBxtra
Create dynamic dashboards and perform analytics based on ServiceNow data in DBxtra.
-
Analyze Square Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Square data and visualize live Square data in Infragistics Reveal.
-
Automated Continuous Zoho CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Zoho CRM replication to MongoDB.
-
Create Couchbase-Connected Applications in Appsmith
Connect to Couchbase Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Couchbase data.
-
Extract, Transform, and Load Chargebee Data in Informatica PowerCenter
Create a simple Workflow for Chargebee data in Informatica PowerCenter.
-
How to Connect to Live Omnisend 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 Omnisend data without replication.
-
Integrating OpenCode with Tanda 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.
-
Getting Started with the CData Python Connector for NetSuite
Learn to install and license the CData Python Connector and configure a connection to live NetSuite data.
-
Connect to Acumatica 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 Acumatica data.
-
Visualize Live MarkLogic Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MarkLogic data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Bidirectional Access to Box Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Box data in Filemaker Pro for Mac or Windows.
-
Analyze Live Cvent Data in SAS Viya
Use CData Connect AI to connect to Cvent data from SAS Viya and deploy self-service analytics using live Cvent data.
-
Connect to CircleCI Data in Jaspersoft Studio
Execute SQL to remote CircleCI data in Jaspersoft Studio.
-
Connect to PDFMonkey Data in RazorSQL
Connect to PDFMonkey from wizards and query PDFMonkey data from the GUI in the RazorSQL database management tool.
-
Integrate OpenCode with Live Greenhouse Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Greenhouse data from within your AI coding agent.
-
Building Dynamic Web Pages with ActiveCampaign Data Using AngularJS
Create single-page applications with live connectivity to ActiveCampaign using the CData API Server.
-
Publish Reports with Couchbase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Couchbase data.
-
Search External Jumpseller Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Jumpseller data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Jumpseller Data objects that you can access from apps and the dashboard.
-
Excel Spreadsheet Automation on BambooHR Data with the QUERY Formula
Pull data from BambooHR, automate spreadsheets, and more with the QUERY formula.
-
Create Zoho CRM-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho CRM Data from Nintex Workflow Cloud and build custom workflows using live Zoho CRM data.
-
Visualize Apify Data in TIBCO Spotfire through ADO.NET
Integrate Apify data into dashboards in TIBCO Spotfire.
-
Connect to Sentry Data in RapidMiner
Integrate Sentry data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use ChatGPT to Talk to Your Perplexity 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 Perplexity data for you.
-
How to Create Power BI Visual Reports with Real-Time Optimizely Data
Use CData Power BI Connectors to visualize Optimizely data in Power BI.
-
How to publish and share Amazon Marketplace Data dashboards with Tableau Server
The CData ODBC driver for Amazon Marketplace enables you integrate Amazon Marketplace data into Tableau dashboards.
-
Publish Crystal Reports on Oracle Sales Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle Sales data.
-
Create Act-On Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Act-On from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Wistia Data from Crystal Reports
Use CData Connect AI to connect to and report on live Wistia data from Crystal Reports.
-
Connect to Live Figshare Data in MicroStrategy through CData Connect AI
Create a live connection to Figshare Data in CData Connect AI and connect to your Figshare data from MicroStrategy.
-
Consume CockroachDB OData Feeds in PowerBuilder
This article demonstrates how to consume CockroachDB data as OData feeds from PowerBuilder using the API Server.
-
Import and Visualize Auth0 Data in Power View
Create data visualizations based on Auth0 data in Excel.
-
Connecting Pipedream with Adobe Analytics 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 Adobe Analytics data in real time.
-
DataBind Factorial Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Factorial data to a chart.
-
How to work with Zoho Inventory Data in Apache Spark using SQL
Access and process Zoho Inventory Data in Apache Spark using the CData Software JDBC Driver.
-
How to Visualize Square Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Square data in Python.
-
Automate SAP SuccessFactors Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP SuccessFactors data replication to Azure Data Lake.
-
PingOne Reporting in OBIEE with the PingOne JDBC Driver
Deploy the PingOne JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to & Open AlloyDB Data in Microsoft Excel
This article uses the CData ODBC driver for AlloyDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connecting Pipedream with Moosend 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 Moosend data in real time.
-
Getting Started with the CData Python Connector for Ontraport
Learn to install and license the CData Python Connector and configure a connection to live Ontraport data.
-
Connect to Exa Data from AWS Glue
Use CData Connect AI to gain access to live Exa data from your AWS Glue jobs.
-
Using CData JDBC Drivers from NetBeans
CData JDBC Drivers make it easy for Java developers to work with a variety of data sources. In this article we show how to develop with CData JDBC Drivers using the NetBeans Java IDE.
-
Create Zoho CRM-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Zoho CRM Data from Klipfolio and build custom visualizations using live Zoho CRM data.
-
How to create an RPA flow for Dynamics NAV Data in UiPath Studio
Use the Dynamics NAV ODBC Driver to create workflows that access real-time Dynamics NAV data without any coding.
-
Build Visualizations of Postmark Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Postmark data in Birst.
-
Connect and Query Live Reckon Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Reckon data into Databricks and enable direct, live querying and analysis without replication.
-
Natively Connect to Cvent Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Cvent data. Leverage the native support for ODBC in PHP.
-
Connect to Suadeo Data from a Connection Pool in JBoss
Integrate Suadeo data into Java servlets: Use the Management Console in JBoss to install the Suadeo JDBC Driver.
-
Automated Continuous Bitly Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Bitly replication to Google BigQuery.
-
How to connect to ClickTime Data with Squirrel SQL client
Connect to ClickTime data and execute queries in the Squirrel SQL Client.
-
Connect to Gmail Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Gmail data.
-
How to Connect to QuickBooks Time Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to QuickBooks Time data. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData Connect AI Python SDK for Mailgun
Install the CData Connect AI Python SDK to read live Mailgun data with standard DB-API 2.0 Python code.
-
Build AI/ML Models with Live Rebilly Data using Dataiku
Connect Rebilly Data with Dataiku using the CData API Driver for JDBC.
-
Easily Integrate BenchmarkEmail Data in Lazarus Pascal IDE
Learn how to easily integrate live BenchmarkEmail data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to connect to Optimizely Data with Squirrel SQL client
Connect to Optimizely data and execute queries in the Squirrel SQL Client.
-
Natively Connect to Suadeo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Suadeo data. Leverage the native support for ODBC in PHP.
-
Access Live LaunchDarkly Data in AWS Lambda
Connect to live LaunchDarkly data in AWS Lambda using the CData JDBC Driver.
-
Build Voice Agents in ElevenLabs with access to Live Sugar CRM Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sugar CRM data.
-
Working with Okta Data in LINQPad
Execute LINQ queries to Okta data in LINQPad.
-
How to Connect to Live Vault CRM Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Vault CRM data for you.
-
Automated Continuous Keap Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Keap replication to IBM DB2.
-
View Reports on Real-Time Contentful Data in Power BI Report Server
Use the CData ODBC Driver for Contentful to visualize Contentful data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Access Live Datadog Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Datadog enables you to integrate Datadog data into workflows built using Microsoft Power Automate Desktop.
-
Analyze Neo4J Data in Looker
Use CData Connect AI to connect to Neo4J Data from Looker and build custom apps using live Neo4J data.
-
Integrating Cursor with Microsoft Entra ID 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 OpenCode with Parallel 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 Gmail Data in Claris FileMaker Pro
Use the CData ODBC Driver for Gmail in FileMaker Pro to connect to Gmail and work with Gmail data in your FileMaker applications.
-
Integrating Claude Code with ConstantContact Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on ConstantContact data within assisted coding and automated development workflows.
-
How to create Visio diagrams from Excel Online Data
Automatically update Excel Online data with the changes you make to Visio master shapes.
-
Access Klipfolio Data from MySQL in Amazon QuickSight
Connect to Klipfolio and build visualizations of Klipfolio data using a MySQL Connection in Amazon QuickSight.
-
Connecting GenSpark with ServiceDesk Plus Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to ServiceDesk Plus data without any replication or custom integration required.
-
Build iContact-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to iContact data and build web apps with connectivity to live iContact data.
-
How to create an RPA flow for SAP Netweaver Gateway Data in UiPath Studio
Use the SAP Netweaver Gateway ODBC Driver to create workflows that access real-time SAP Netweaver Gateway data without any coding.
-
Query Insightly Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Insightly data from Node.js.
-
Integrate with Slack Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Slack data in SnapLogic.
-
Build SparkPost-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SparkPost Data and create custom apps in Mendix.
-
Create Informatica Mappings From/To an ODBC Data Source for Recurly
Create an ODBC connection to Recurly in Informatica and browse and transfer Recurly data.