CData Software - Knowledge Base
Recent Articles
-
Integrating GitHub Copilot with Aweber 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 load Aha! data into Elasticsearch via Logstash
Introducing a simple method to load Aha! data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Load LeadDesk Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load LeadDesk data to a database.
-
Connecting Mastra with Klipfolio 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 Klipfolio data, no replication required.
-
Create Reports from Moosend Data in Looker Studio
Use CData Connect AI to gain access to live Moosend data and create custom reports in Looker Studio.
-
Create Dashboards and Visualize Live SAP Fieldglass Data in Geckoboard
Use CData Connect AI to connect to live SAP Fieldglass data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Excel Online Data in NetBeans
Connect to Excel Online data in NetBeans with the data source configuration wizard.
-
Getting Started with the CData SSIS Components for Box
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Box.
-
Access Live Dynamics 365 Data in TIBCO Data Virtualization
Use the Dynamics 365 Tibco DV Adapter to create a Dynamics 365 data data source in TIBCO Data Virtualization Studio and gain access to live Dynamics 365 data from your TDV Server.
-
View Reports on Real-Time Excel Online Data in Power BI Report Server
Use the CData ODBC Driver for Excel Online to visualize Excel Online data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Claude Code CLI with Placid 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.
-
Access Live Marketo Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Marketo data through MCP integration.
-
How to connect to Gumroad Data with Squirrel SQL client
Connect to Gumroad data and execute queries in the Squirrel SQL Client.
-
Connect to Strava Data in Jaspersoft Studio
Execute SQL to remote Strava data in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for Greenhouse in MicroStrategy Desktop
Connect to Greenhouse data in MicroStrategy Desktop using the CData Software ODBC Driver for Greenhouse.
-
Integrating Claude Code CLI with Bitbucket 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.
-
Use the CData Software ODBC Driver for Freshteam in MicroStrategy
Connect to Freshteam data in MicroStrategy Developer using the CData Software ODBC Driver for Freshteam.
-
Build Apps with Live Unbounce Data Using the Low-Code Development Platform of Mendix
Connect Unbounce data with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Theia IDE with Live Zoom 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 Zoom data from within the development environment.
-
Create Informatica Mappings From/To a JDBC Data Source for Nethunt
Create Nethunt data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Informatica Mappings From/To a JDBC Data Source for Amplitude
Create Amplitude data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connecting Agentforce with SAP Ariba Procurement Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your SAP Ariba Procurement data for you.
-
Analyze Cvent Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Cvent data with the CData JDBC Driver for Cvent.
-
Automated Continuous Couchbase Replication to SQL Server
Use CData Sync for automated, continuous, customizable Couchbase replication to SQL Server.
-
Creating Cassandra-Connected Applications in Unqork
You can use CData Connect AI to feed Cassandra data to Unqork and build custom business apps.
-
Automated Continuous Recurly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Recurly replication to Amazon S3.
-
Validate SAP Concur Data with QuerySurge
Access and validate SAP Concur data in QuerySurge using the CData JDBC Driver.
-
Publish Oracle SCM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Oracle SCM data.
-
Build MVC Applications with Connectivity to ZohoPeople Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZohoPeople from an ASP.NET MVC application.
-
Build Couchbase-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Couchbase data and build Couchbase-connected web apps with Axios.
-
Integrating GitHub Copilot with Factorial 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.
-
SAP SuccessFactors LMS Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP SuccessFactors LMS data through CData Connect AI using different applications and tools.
-
Integrating Antigravity CLI with SingleStore data via CData CLI
Connect SingleStore data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build a PostgreSQL Interface for Zoho Projects Data using the CData JDBC Driver
Use the Remoting features of the Zoho Projects JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze ZohoMarketingHub Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ZohoMarketingHub data and visualize ZohoMarketingHub data in SAP Analytics Cloud.
-
Connect to SageHR from Asprova with CData Software ODBC Driver for SageHR
This article shows how to connect faster to SageHR data from Asprova.
-
Build Automated Workflows with Live Phoenix Data in Workato
Use CData Connect AI to connect to live Phoenix data and build automated workflows in Workato.
-
Automated Continuous Optimizely Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Optimizely replication to IBM DB2.
-
Excel Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Excel facts in real time.
-
Integrate Google's Antigravity Agent with Live PolarTeamPro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live PolarTeamPro data using the Model Context Protocol.
-
How to connect PolyBase to OnePageCrm
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live OnePageCrm data.
-
Build Ontraport-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Ontraport data and build web apps with connectivity to live Ontraport data.
-
Import ConstantContact Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to ConstantContact Data and provide access to live ConstantContact data for custom reports in the Power BI Service.
-
Build a Simple VCL Application for Microsoft Ads Data
How to build a simple VCL Application to view Microsoft Ads data in RAD Studio using the CData ODBC Driver for Microsoft Ads.
-
Automated Continuous Active Directory Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Active Directory replication to Apache Kafka.
-
Automate RSS Integration Tasks from PowerShell
Are you in search of a quick and easy way to access RSS feeds from PowerShell? This article demonstrates how to utilize the RSS Cmdlets for tasks like connecting to RSS feeds, automating operations, downloading data, and more.
-
Feed Drip Data into FineReport
How to set Drip data as a JDBC data source in FineReport.
-
LeadDesk Reporting in OBIEE with the LeadDesk JDBC Driver
Deploy the LeadDesk JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Live JSON Services from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your JSON services through natural language.
-
Migrating data from QuickBooks to Snowflake using CData SSIS Components.
Easily push QuickBooks data to Snowflake using the CData SSIS Tasks for QuickBooks and Snowflake.
-
Access Live Helpscout Data in AWS Lambda
Connect to live Helpscout data in AWS Lambda using the CData JDBC Driver.
-
Integrate Live ClickUp Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ClickUp data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Visualize Mailgun Data in Sisense
Create an ElastiCube in Sisense app with access to Mailgun data.
-
Integrate Live Klaviyo 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 Klaviyo data from within the IDE.
-
Interact with Live Supabase Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Supabase data.
-
How to Connect to Live Avro Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Avro data through natural language.
-
Use Grok to Talk to Your Zoho Creator 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 Zoho Creator data for you.
-
How to Connect to Live Monday.com Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Monday.com data for you.
-
Automated Continuous Intercom Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Intercom replication to delimited files (CSV/TSV).
-
Integrate Google's Antigravity Agent with Live Shortcut Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Shortcut data using the Model Context Protocol.
-
Connect to Elasticsearch Data in Google Apps Script via Connect AI
Use CData Connect AI to access Elasticsearch data in Google Apps Script.
-
Access SAP SuccessFactors LMS Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP SuccessFactors LMS data from HeidiSQL.
-
How to work with Google Analytics Data in Apache Spark using SQL
Access and process Google Analytics Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Facebook Data from PowerShell
Write a quick PowerShell script to query Facebook data. Use connectivity to the live data to replicate Facebook data to SQL Server.
-
Automated Continuous Perplexity Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Perplexity replication to Google BigQuery.
-
Connect to Spotify Data in RazorSQL
Connect to Spotify from wizards and query Spotify data from the GUI in the RazorSQL database management tool.
-
How to load LinkedIn Ads data into Elasticsearch via Logstash
Introducing a simple method to load LinkedIn Ads data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Write a Simple Go Application to work with Email Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Email data.
-
Visualize Dynamics 365 Business Central Data in Tableau
The CData ODBC driver for Dynamics 365 Business Central enables you integrate Dynamics 365 Business Central data into Tableau dashboards.
-
Build AI Agents with Paylocity Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Paylocity data through CData Connect AI.
-
A PostgreSQL Interface for SendPulse Data using the CData ODBC Driver
Use the SQL Gateway and SendPulse ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Opsgenie Data in JReport Designer
Create charts and reports based on Opsgenie data in JReport Designer.
-
Replicate Multiple PostgreSQL Accounts via the CData Sync CLI
Replicate multiple PostgreSQL accounts to one or many databases.
-
Integrate Live Optimizely 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 Optimizely data from within the IDE.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure Data Catalog
Create an ODBC connection to Azure Data Catalog in Informatica and browse and transfer Azure Data Catalog data.
-
Excel Spreadsheet Automation on Sybase Data with the QUERY Formula
Pull data from Sybase, automate spreadsheets, and more with the QUERY formula.
-
Connect to Vercel from a Connection Pool in WebLogic
Use the CData JDBC Driver for Vercel to connect to Vercel data from Web applications running on WebLogic.
-
Natively Connect to ZohoPeople Data in PHP
The CData ODBC driver for ZohoPeople enables you to create PHP applications with connectivity to ZohoPeople data. Leverage the native support for ODBC in PHP.
-
Connect Sage 200 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sage 200 data using the CData Python MCP Server.
-
Create SSAS Tabular Models from GitLab Data
How to build a SQL Server Analysis Service Tabular Model from GitLab data using CData drivers.
-
Bridge BigCommerce Connectivity with Apache NiFi
Access and process BigCommerce data in Apache NiFi using the CData JDBC Driver.
-
Connect to SAP Hybris C4C Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SAP Hybris C4C.
-
Create a Data Access Object for Datadog Data using JDBI
A brief overview of creating a SQL Object API for Datadog data in JDBI.
-
Access Live PolarTeamPro Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PolarTeamPro data from your Google Sheets.
-
How to Connect the Power BI Service to IBM Informix: Complete Guide
Connect to the CData Software Power BI Connector for IBM Informix from PowerBI.com to provide real-time IBM Informix data across the organization.
-
Create ServiceDesk Plus-Connected Dashboards in Grafana
Connect to ServiceDesk Plus Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ServiceDesk Plus data.
-
Stream Calendly Data into Apache Kafka Topics
Access and stream Calendly data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData Software JDBC Driver for Highrise in MicroStrategy Web
Connect to Highrise data in MicroStrategy Web using the CData Software JDBC Driver for Highrise.
-
Visualize Auth0 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 Auth0 data into TIBCO Spotfire.
-
How to Access Dotmailer Data Using Entity Framework
This article shows how to access Dotmailer data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Create Power BI Visual Reports with Real-Time Contentful Data
Use CData Power BI Connectors to visualize Contentful data in Power BI.
-
Connect to Greenplum from Asprova with CData Software ODBC Driver for Greenplum
This article shows how to connect faster to Greenplum data from Asprova.
-
Natively Connect to YouTube Analytics Data in PHP
The CData ODBC driver for YouTube Analytics enables you to create PHP applications with connectivity to YouTube Analytics data. Leverage the native support for ODBC in PHP.
-
Analyze Live GitLab Data in SAS Viya
Use CData Connect AI to connect to GitLab data from SAS Viya and deploy self-service analytics using live GitLab data.
-
Integrating Codex with Gumroad 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.
-
Migrating data from Rootly to Snowflake using CData SSIS Components.
Easily push Rootly data to Snowflake using the CData SSIS Tasks for Rootly and Snowflake.
-
Create Reports with SuiteCRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SuiteCRM data.
-
DataBind Charts to Authorize.Net Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Authorize.Net 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.
-
How to publish and share Harvest Data dashboards with Tableau Server
The CData ODBC driver for Harvest enables you integrate Harvest data into Tableau dashboards.
-
Build a PostgreSQL Interface for Salesforce Data using the CData JDBC Driver
Use the Remoting features of the Salesforce JDBC Driver to create a PostgreSQL entry-point for data access.