CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with SAP Netweaver Gateway Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Netweaver Gateway data.
-
Connecting Agentforce with Procore 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 Procore data for you.
-
DataBind Charts to Sentry Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sentry 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.
-
Query Live FTP Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live FTP data directly from the development environment.
-
Connect to Authorize.Net Data from Crystal Reports
Use CData Connect AI to connect to and report on live Authorize.Net data from Crystal Reports.
-
Analyze Dotmailer Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Dotmailer data in Microsoft R Open.
-
Publish Reports with SparkPost Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SparkPost data.
-
Create Datasets from Impala in Domo Workbench and Build Visualizations of Impala Data in Domo
Use the CData Software ODBC Driver for Impala to create datasets from Impala data in Domo Workbench and then build visualizations in the Domo service.
-
How to connect PolyBase to SFTP
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SFTP data.
-
Connect to Mailjet Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Mailjet data.
-
Integrating LlamaIndex with Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Greenplum data in real time.
-
How to connect to OneNote Data from IntelliJ
Integrate connectivity to OneNote data with wizards in IntelliJ.
-
Build Agents in Relevance AI with Access to Live Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Twilio data within intelligent agent workflows.
-
How to load PDFMonkey data into Elasticsearch via Logstash
Introducing a simple method to load PDFMonkey data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Gumloop with PingOne Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on PingOne data within automated workflows.
-
Build a Singer.io Tap for Webex With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Webex data using the CData Python Connector.
-
Build Apps with Live Google Drive Data Using the Low-Code Development Platform of Mendix
Connect Google Drive data with Mendix to build apps using the CData JDBC Driver for Google Drive.
-
Connect to Cloudant Data in Jaspersoft Studio
Execute SQL to remote Cloudant data in Jaspersoft Studio.
-
Replicate Elorus Data in Heroku for Use in Salesforce Connect
Replicate Elorus data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to use SQLAlchemy ORM to access RSS Feeds in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of RSS feeds.
-
Build Semantic Layer Views for SendGrid Data in APOS Live Data Gateway
Use the CData Connector for SendGrid in APOS Live Data Gateway to build Semantic Layer Views for SendGrid data.
-
Integrating Boomi Agentstudio with BigQuery Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to BigQuery data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
LINQ to PagerDuty 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 PagerDuty Data Provider.
-
How to connect to Demio Data from Spring Boot
Connect to Demio in a Spring Boot Application using the CData API Driver for JDBC
-
Access Live Postmark Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Postmark data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Certinia Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Certinia data and build visualizations in Tableau Cloud.
-
Automated Continuous Aha! Replication to Snowflake
Use CData Sync for automated, continuous, customizable Aha! replication to Snowflake.
-
Publish Reports with Vercel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Vercel data.
-
Import and Visualize Pinterest Data in Power View
Create data visualizations based on Pinterest data in Excel.
-
Use JayDeBeApi to access MessageBird Data in Python
Use standard Python scripting and the development environment of your choice to access live MessageBird data.
-
Connect to Everhour Data in DBeaver
Use the CData ODBC Driver to connect to Everhour data in DBeaver.
-
Connect to Klaviyo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Klaviyo and the SQL Gateway to access Klaviyo data from Google Apps Script.
-
Connect and Query Live FHIR Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live FHIR data into Databricks and enable direct, live querying and analysis without replication.
-
How to connect to Kafka Data from Spring Boot
Connect to Kafka in a Spring Boot Application using the CData JDBC Driver for Kafka
-
Trigger GitHub IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for GitHub with standard wizards in Logic Apps.
-
Connecting Pipedream with ZohoPeople 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 ZohoPeople data in real time.
-
Load Simplesat Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Simplesat data to a database.
-
Automated Continuous Attio Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Attio replication to Amazon S3.
-
Building Dynamic Web Pages with Google Contacts Data Using AngularJS
Create single-page applications with live connectivity to Google Contacts using the CData API Server.
-
Integrate Live PDFMonkey Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live PDFMonkey data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Bitbucket Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Bitbucket and the SQL Gateway to access Bitbucket data from Google Apps Script.
-
Connect to ActiveCampaign Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ActiveCampaign.
-
Build ZohoPeople-Connected Apps in Choreo
Use CData Connect AI to connect to ZohoPeople Data from Choreo and build custom apps using live ZohoPeople data.
-
How to load Printify data into Elasticsearch via Logstash
Introducing a simple method to load Printify data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Back Up HubSpot data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for HubSpot. In this article, we will employ an SSIS workflow to populate a database with HubSpot data data.
-
Connect to Webflow Data in HULFT Integrate
Connect to Webflow as a JDBC data source in HULFT Integrate
-
How to connect PolyBase to Google Sheets
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Sheets data.
-
Perform Batch Operations with Microsoft Dataverse Data in Apache NiFi
Connect to Microsoft Dataverse data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Airtable Data from MySQL in Amazon QuickSight
Connect to Airtable and build visualizations of Airtable data using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData Python Connector for SAP Ariba Procurement
Learn to install and license the CData Python Connector and configure a connection to live SAP Ariba Procurement data.
-
Replicate MessageBird Data from PowerShell
Write a quick PowerShell script to query MessageBird data. Use connectivity to the live data to replicate MessageBird data to SQL Server.
-
Integrate with live SQL Server Data in Jitterbit
Use CData Connect AI to connect to and integrate live SQL Server data in Jitterbit.
-
How to Work with MariaDB Data in AWS Glue Jobs Using JDBC
Connect to MariaDB from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to OneNote in SpagoBI
Create reports featuring live OneNote data in SpagoBI Studio. Host OneNote reports on SpagoBI Server.
-
Visualize Missive Data in Tableau
The CData ODBC driver for Missive enables you integrate Missive data into Tableau dashboards.
-
Create Samanage-Connected Business Apps in AppSheet
Connect to Samanage Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Samanage data.
-
Design BIRT Reports on Everhour Data
Provide current Everhour data to your embedded analytics.
-
How to load SingleStore data into Elasticsearch via Logstash
Introducing a simple method to load SingleStore data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query Supabase Data in ColdFusion
Write standard ColdFusion data access code to connect to Supabase data.
-
Create Google Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Analytics data access from reports, embedded analytics, and more.
-
Integrating Antigravity CLI with Printful data via CData CLI
Connect Printful data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Import and Visualize ZohoDesk Data in Power View
Create data visualizations based on ZohoDesk data in Excel.
-
How to Build an ETL App for Keap Data in Python with CData
Create ETL applications and real-time data pipelines for Keap data in Python with petl.
-
How to Seamlessly Import SFTP Data into IBM SPSS Modeler
Integrate SFTP data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to create GitLab federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for GitLab data in MySQL .
-
Import Real-Time PostgreSQL Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use PostgreSQL data in ColdFusion.
-
SAP BusinessObjects BI Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP BusinessObjects BI facts in real time.
-
Automated Continuous Auth0 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Auth0 replication to Azure SQL Database.
-
Rapidly Develop PayPal-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 PayPal.
-
Query Google Ads Data as a MySQL Database in Node.js
Execute MySQL queries against Google Ads data from Node.js.
-
Moving Data from Excel Online to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Excel Online data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Live Onfleet Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Onfleet data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to Live Email 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 Email data for you.
-
Build Visualizations of Quaderno Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Quaderno data in Birst.
-
How to integrate Clockify with Apache Airflow
Access and process Clockify data in Apache Airflow using the CData JDBC Driver.
-
Build Semantic Layer Views for BenchmarkEmail Data in APOS Live Data Gateway
Use the CData Connector for BenchmarkEmail in APOS Live Data Gateway to build Semantic Layer Views for BenchmarkEmail data.
-
Automated Continuous Supabase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Supabase replication to Google BigQuery.
-
Use Azure AI Foundry to Talk to Your Acumatica 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 Acumatica data for you.
-
How to Connect to Live Acumatica 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 Acumatica data for you.
-
Create Klipfolio-Connected Nintex Workflows
Use CData Connect AI to connect to Klipfolio Data from Nintex Workflow Cloud and build custom workflows using live Klipfolio data.
-
How to connect to LinkedIn Ads Data from IntelliJ
Integrate connectivity to LinkedIn Ads data with wizards in IntelliJ.
-
Access Live Freshteam Data in AWS Lambda
Connect to live Freshteam data in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Beeminder Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Beeminder data. Leverage the pyodbc module for ODBC in Python.
-
Prepare, Blend, and Analyze Google Analytics Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Analytics data for self-service data analytics.
-
DataBind Charts to GraphQL Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to GraphQL 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 Connect to Postmark Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Postmark data. Leverage the pyodbc module for ODBC in Python.
-
Model, Search, and Visualize Live Certinia Data in ThoughtSpot
Use CData Connect AI to connect to live Certinia data for modeling, searching, and visualizing.
-
Getting Started with the CData ODBC Driver for Quickbase
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Quickbase.
-
How to use SQLAlchemy ORM to access SAP ByDesign Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP ByDesign data.
-
Replicate CloudConvert Data in Heroku for Use in Salesforce Connect
Replicate CloudConvert data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData Tableau Connector for Planio
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Exact Online-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Exact Online data.
-
How to Connect to Live Salesforce Data 360 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 Salesforce Data 360 data for you.
-
Integrating GitHub Copilot with Cohere 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 connect and process Bright Data data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Bright Data data.
-
Create Dashboards and Visualize Live NetSuite Data in Geckoboard
Use CData Connect AI to connect to live NetSuite data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Visualize CircleCI Data in Tableau
The CData ODBC driver for CircleCI enables you integrate CircleCI data into Tableau dashboards.
-
Build Nuclia-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Nuclia data.
-
Connect to Gong 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 Gong data.
-
Integrating Claude Code CLI with Odoo 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.