CData Software - Knowledge Base
Recent Articles
-
Integrating Gumloop with Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Freshteam data within automated workflows.
-
Connect to MailerLite Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MailerLite and the SQL Gateway to access MailerLite data from Google Apps Script.
-
Connect to Google Search Results as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Search results.
-
How to Connect to Live Azure Table Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Azure Table data for you.
-
Integrate RSS with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate RSS with External Services.
-
Visualize Templated Data in TIBCO Spotfire through ADO.NET
Integrate Templated data into dashboards in TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for LinkedIn
Create an ODBC connection to LinkedIn in Informatica and browse and transfer LinkedIn data.
-
Use Azure AI Foundry to Talk to Your Sage 200 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 Sage 200 data for you.
-
Connect to GetResponse Data in RazorSQL
Connect to GetResponse from wizards and query GetResponse data from the GUI in the RazorSQL database management tool.
-
How to work with Tanda Data in Apache Spark using SQL
Access and process Tanda Data in Apache Spark using the CData Software JDBC Driver.
-
Query Cohere Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Cohere data from Node.js.
-
LINQ to ClickUp 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 ClickUp Data Provider.
-
Extract, Transform, and Load PayPal Data in Informatica PowerCenter
Create a simple Workflow for PayPal data in Informatica PowerCenter.
-
Integrating Claude Code CLI with HubSpot 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.
-
Design BIRT Reports on Deel Data
Provide current Deel data to your embedded analytics.
-
How to Work with Webex Data in ETL Validator JDBC
Connect to Webex from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Live SAP Ariba Procurement Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP Ariba Procurement in CData Connect AI and connect to your SAP Ariba Procurement data from PostgreSQL.
-
Build Semantic Layer Views for Odoo Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Odoo data.
-
Create Adobe Commerce-Connected Nintex Workflows
Use CData Connect AI to connect to Adobe Commerce Data from Nintex Workflow Cloud and build custom workflows using live Adobe Commerce data.
-
Access Microsoft Planner Data from MySQL in Amazon QuickSight
Connect to Microsoft Planner and build visualizations of Microsoft Planner data using a MySQL Connection in Amazon QuickSight.
-
Build Bitly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Bitly data and build web apps with connectivity to live Bitly data.
-
Bridge RSS Connectivity with Apache NiFi
Access and process RSS feeds in Apache NiFi using the CData JDBC Driver.
-
Build a PostgreSQL Interface for Clari Data using the CData JDBC Driver
Use the Remoting features of the Clari JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Marketo Data from Spring Boot
Connect to Marketo in a Spring Boot Application using the CData JDBC Driver for Marketo
-
Integrating Claude Code CLI with AgileCRM 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.
-
How to Visualize Square Data in Python with pandas
Use pandas and other modules to analyze and visualize live Square data in Python.
-
Create SAP Netweaver Gateway-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Netweaver Gateway Data from OutSystems and build custom enterprise apps using live SAP Netweaver Gateway data.
-
How to work with Coinbase Data in Apache Spark using SQL
Access and process Coinbase Data in Apache Spark using the CData Software JDBC Driver.
-
Query ShipEngine Data in DataGrip
Create a Data Source for ShipEngine in DataGrip and use SQL to query live ShipEngine data.
-
How to create Optimizely federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Optimizely data in MySQL .
-
How to Connect to Live Cloudflare Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Cloudflare data securely in real time.
-
Analyze SAP Ariba Source Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Ariba Source data with the CData JDBC Driver for SAP Ariba Source.
-
Connect and Visualize Live Lakebase Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Lakebase data into the Databricks platform and create visualization dashboards with real-time Lakebase data.
-
How to load Suadeo data into Elasticsearch via Logstash
Introducing a simple method to load Suadeo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Wrike Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Wrike replication to Google Cloud SQL.
-
Replicate Multiple Paylocity Accounts via the CData Sync CLI
Replicate multiple Paylocity accounts to one or many databases.
-
Connect to Perplexity Data from AWS Glue
Use CData Connect AI to gain access to live Perplexity data from your AWS Glue jobs.
-
Access Live GitLab Data in Excel 365 Online (Excel for the web)
Connect to GitLab data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Query SAP Business One Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP Business One data from Node.js.
-
Getting Started with the CData ODBC Driver for Freshsales
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Freshsales.
-
Use Databricks Agent Bricks to Talk to Your Google Cloud Storage Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Cloud Storage data for you.
-
Integrate Goose with Live Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Raisers Edge NXT data from within the local AI agent.
-
Use Claude to Talk to Your MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your MYOB AccountRight data for you.
-
A PostgreSQL Interface for Google Calendar Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Calendar JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SAP BusinessObjects BI 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 SAP BusinessObjects BI data.
-
Automated Continuous Ontraport Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Ontraport replication to Apache Kafka.
-
Replicate Multiple FormSite Accounts
Replicate multiple FormSite accounts to one or many databases.
-
Build Dashboards with Pinecone Data in Dundas BI
Create dynamic dashboards and perform analytics based on Pinecone data in Dundas BI.
-
Build MVC Applications with Connectivity to LinkedIn Ads Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LinkedIn Ads from an ASP.NET MVC application.
-
Create Reports with Certinia Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Certinia data.
-
Connect to Postmark Data in Ruby
Connect to Postmark data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Validate Onfleet Data with QuerySurge
Access and validate Onfleet data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous SAP Ariba Source Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Snowflake.
-
Use Dash to Build Web Apps on Paylocity Data via CData Connect AI
Build interactive Dash web apps on live Paylocity data using pandas and the CData Connect AI Python SDK.
-
How to Query Live Shortcut Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Shortcut data data in natural language using Python.
-
Visualize Codat 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 Codat data into TIBCO Spotfire.
-
Integrating LangChain with Notion Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Notion data within automated workflows.
-
Integrate Goose with Live Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Facebook data from within the local AI agent.
-
Use Claude to Talk to Your Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Dataverse data for you.
-
Import Phoenix Data Using Azure Data Factory
Use CData Connect AI to connect to Phoenix Data from Azure Data Factory and import live Phoenix data.
-
Integrate Google's Antigravity Agent with Live Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft Entra ID data using the Model Context Protocol.
-
Connect to Discord Data in NetBeans
Connect to Discord data in NetBeans with the data source configuration wizard.
-
Integrating GitHub Copilot with Raisers Edge NXT 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 Superchat Data in RapidMiner
Integrate Superchat data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live SurveyMonkey Data in Coginiti Pro
Connect to and query live SurveyMonkey data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Scrapfly Replication to SingleStore
Use CData Sync for automated, continuous, customizable Scrapfly replication to SingleStore.
-
Rapidly Develop SFTP-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by SFTP.
-
How to publish and share Placid Data dashboards with Tableau Server
The CData ODBC driver for Placid enables you integrate Placid data into Tableau dashboards.
-
Integrate Live Microsoft Dataverse Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Microsoft Dataverse from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Dataverse data.
-
Connect to ChartMogul in SpagoBI
Create reports featuring live ChartMogul data in SpagoBI Studio. Host ChartMogul reports on SpagoBI Server.
-
Build Epicor Kinetic-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Epicor Kinetic data and build web apps with connectivity to live Epicor Kinetic data.
-
Create Power BI Reports on Real-Time Shortcut Data
Use the CData ODBC Driver for Shortcut to visualize Shortcut data in Power BI Desktop.
-
Automated Continuous Adobe Analytics Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to IBM DB2.
-
Manage Brex Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Brex.
-
Access Live SuiteCRM Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SuiteCRM data through MCP integration.
-
Integrate Presto Data in the Pentaho Report Designer
Publish reports based on Presto data in the Pentaho BI tool.
-
Connect to SurveyMonkey Data in Claris FileMaker Pro
Use the CData ODBC Driver for SurveyMonkey in FileMaker Pro to connect to SurveyMonkey and work with SurveyMonkey data in your FileMaker applications.
-
How to load ShipEngine data into Elasticsearch via Logstash
Introducing a simple method to load ShipEngine data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to import RSS Feeds into Apache Solr
Use the CData Software JDBC Driver for RSS in Data Import Handler and create an automated import of RSS feeds to Apache Solr Enterprise Search platform.
-
Integrate Live Presto Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Presto data from within the IDE.
-
Use the CData Software ODBC Driver for Close in SAS for Real-Time Reporting and Analytics
Connect to real-time Close data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Close.
-
How to Connect DBeaver to ConvertKit via a JDBC Driver
Manage ConvertKit data with visual tools in DBeaver like the query browser.
-
How to Connect the Power BI Service to OnePageCrm: Complete Guide
Connect to the CData Software Power BI Connector for OnePageCrm from PowerBI.com to provide real-time OnePageCrm data across the organization.
-
Connect to Real-Time Deel Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Deel data in Power Apps.
-
Prepare, Blend, and Analyze Reckon Data in Alteryx Designer (Connect AI)
Build workflows to access live Reckon data for self-service data analytics.
-
NetSuite Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on NetSuite facts in real time.
-
Query Stripe Data in DataGrip
Create a Data Source for Stripe in DataGrip and use SQL to query live Stripe data.
-
Connecting Moonlit Workflow with SparkPost 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 SparkPost data in real time.
-
Working with Excel Data in LINQPad
Execute LINQ queries to Excel data in LINQPad.
-
Connect to Facebook Data in CloverDX (formerly CloverETL)
Transfer Facebook data using the visual workflow in the CloverDX data integration tool.
-
Create Datasets from Basecamp in Domo Workbench and Build Visualizations of Basecamp Data in Domo
Use the CData Software ODBC Driver for Basecamp to create datasets from Basecamp data in Domo Workbench and then build visualizations in the Domo service.
-
Create Asana-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Asana Data from OutSystems and build custom enterprise apps using live Asana data.
-
Build a Simple VCL Application for Testmonitor Data
How to build a simple VCL Application to view Testmonitor data in RAD Studio using the CData ODBC Driver for Testmonitor.
-
Integrate Theia IDE with Live Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Power BI XMLA data from within the development environment.
-
Build Egnyte-Connected Apps in Choreo
Use CData Connect AI to connect to Egnyte Data from Choreo and build custom apps using live Egnyte data.
-
Publish Crystal Reports on SendInBlue Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SendInBlue data.
-
How to connect to Billsby Data with Squirrel SQL client
Connect to Billsby data and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData Excel Add-In for VWO
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for VWO.
-
Back Up SAP ByDesign data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP ByDesign. In this article, we will employ an SSIS workflow to populate a database with SAP ByDesign data data.
-
Query VWO Data as a MySQL Database in Node.js
Execute MySQL queries against VWO data from Node.js.