CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with Attio Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Attio.
-
Connect to Dotmailer Data in HULFT Integrate
Connect to Dotmailer as a JDBC data source in HULFT Integrate
-
Write a Simple Go Application to work with Quaderno Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Quaderno.
-
Build Marketo-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Marketo.
-
Build Redis-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Redis and build web apps with connectivity to live Redis.
-
Edit and Search External Zoho CRM Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Zoho CRM to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Zoho CRM Data objects that you can access from apps and the dashboard.
-
Build MVC Applications with Connectivity to Aha! Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Aha! from an ASP.NET MVC application.
-
Automated Continuous OneNote Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable OneNote replication to Azure SQL Database.
-
Connect to Phoenix Data in JRuby
Create a simple JRuby app with access to live Apache Phoenix.
-
Integrating LangChain with ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on ShipStation within automated workflows.
-
Connect to eBay Data in CloverDX (formerly CloverETL)
Transfer eBay using the visual workflow in the CloverDX data integration tool.
-
Integrate with BigCommerce Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy BigCommerce to a JSON file on disk.
-
How to Easily Query MongoDB Data in OpenOffice Base
Connect to MongoDB data in OpenOffice Base using the CData ODBC Driver for MongoDB and generate reports with live data insights.
-
Analyze Azure Synapse Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Azure Synapse and visualize Azure Synapse in SAP Analytics Cloud.
-
Excel Spreadsheet Automation on MySQL Data with the QUERY Formula
Pull data from MySQL, automate spreadsheets, and more with the QUERY formula.
-
Connect to VWO Data in Ruby
Connect to VWO in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Egnyte Data in Aqua Data Studio
Access Egnyte from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software ODBC Driver for Recurly in MicroStrategy Desktop
Connect to Recurly in MicroStrategy Desktop using the CData Software ODBC Driver for Recurly.
-
Rapidly Develop Close-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 Close.
-
Build a Simple VCL Application for GraphQL Data
How to build a simple VCL Application to view GraphQL in RAD Studio using the CData ODBC Driver for GraphQL.
-
Object-Relational Mapping (ORM) with Productboard 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 Productboard into a Java-based ORM framework, Hibernate.
-
Integrating Kiro CLI with Zoho CRM 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.
-
Integrate Cursor with Live Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Sybase from within the editor.
-
Integrate Live Sage 200 Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Sage 200 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Sage 200.
-
Automate Campaigner Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Campaigner from PowerShell? This article demonstrates how to utilize the Campaigner Cmdlets for tasks like connecting to Campaigner, automating operations, downloading data, and more.
-
Create Neo4J-Connected Dashboards in Grafana
Connect to Neo4J Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Neo4J.
-
Integrate Splunk Data in the Pentaho Report Designer
Publish reports based on Splunk in the Pentaho BI tool.
-
How to Easily Query Miro Data in OpenOffice Base
Connect to Miro data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Import Data from JSON into Google Sheets
Import JSON into a Google spreadsheet that is automatically refreshed.
-
How to Connect DBeaver to Dynamics CRM via a JDBC Driver
Manage Microsoft Dynamics CRM with visual tools in DBeaver like the query browser.
-
Connect to Parallel Data from a Connection Pool in JBoss
Integrate Parallel into Java servlets: Use the Management Console in JBoss to install the Parallel JDBC Driver.
-
Integrate Pingdom with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Pingdom with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Pingdom.
-
How to Connect to Live ServiceNow 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 ServiceNow for you.
-
Connect to BigQuery in SpagoBI
Create reports featuring live Google BigQuery in SpagoBI Studio. Host BigQuery reports on SpagoBI Server.
-
Getting Started with the CData SSIS Components for Clari
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Clari.
-
Getting Started with the CData Python Connector for CloudConvert
Learn to install and license the CData Python Connector
-
How to Visualize Helpscout Data in Python with pandas
Use pandas and other modules to analyze and visualize live Helpscout in Python.
-
How to Access QuickBooks Online Data Using Entity Framework
This article shows how to access QuickBooks Online using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData Tableau Connector for iContact
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure Table
Create an ODBC connection to Azure Table in Informatica and browse and transfer Azure Table Storage.
-
Connect to Confluence Data from PowerBuilder via ADO.NET
This article demonstrates how to access Atlassian Confluence from Appeon PowerBuilder using the CData ADO.NET Provider for Confluence.
-
Impala Reporting in OBIEE with the Impala JDBC Driver
Deploy the Impala JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Automated Workflows with Live Confluence Data in Workato
Use CData Connect AI to connect to live Atlassian Confluence and build automated workflows in Workato.
-
Integrate Ontraport Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Ontraport from Informatica Cloud.
-
Use the CData Software ODBC Driver for Pinecone in MicroStrategy Web
Connect to Pinecone in MicroStrategy Web using the CData Software ODBC Driver for Pinecone.
-
Integrating Claude Code CLI with Oracle HCM Cloud 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 and Query MailerSend Data in QlikView over ODBC
Create data visualizations with MailerSend in QlikView.
-
Provide OData Services of Factorial Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Factorial by developing a WCF Service Application.
-
Build HubSpot-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for HubSpot to explore live HubSpot Data in Claude Code to assist with building HubSpot-powered applications.
-
How to Work with RabbitMQ Data in AWS Glue Jobs Using JDBC
Connect to RabbitMQ from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connecting GenSpark with ActiveCampaign Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to ActiveCampaign without any replication or custom integration required.
-
How to Query Live Printify Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Printify data in natural language using Python.
-
How to Access Live SAP ByDesign Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP ByDesign enables you to integrate SAP Business ByDesign into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to Live Dynamics 365 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 Microsoft Dynamics 365 for you.
-
Automate GitLab Data Replication to Couchbase
Use CData Sync to Customize and automate GitLab replication to Couchbase.
-
Automate Miro Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Miro from PowerShell? This article demonstrates how to utilize the Miro Cmdlets for tasks like connecting to Miro, automating operations, downloading data, and more.
-
Bridge Apollo Connectivity with Apache NiFi
Access and process Apollo in Apache NiFi using the CData JDBC Driver.
-
Migrating data from Float to Databricks using CData SSIS Components.
Easily push Float to Databricks using the CData SSIS Tasks for Float and Databricks.
-
Visualize Google Ads Data in Sisense
Create an ElastiCube in Sisense app with access to Google Ads.
-
Extract, Transform, and Load SQL Analysis Services Data in Informatica PowerCenter
Create a simple Workflow for SQL Analysis Services in Informatica PowerCenter.
-
Integrate with Live Sage Cloud Accounting Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Sage Cloud Accounting from the MuleSoft Anypoint Platform to integrate live Sage Business Cloud Accounting into custom reports and dashboards.
-
Integrating Antigravity CLI with LeadDesk via CData CLI
Connect LeadDesk to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build CockroachDB-Connected Apps in Choreo
Use CData Connect AI to connect to CockroachDB Data from Choreo and build custom apps using live CockroachDB.
-
Query MailChimp Data from Node.js
Use the OData endpoint of the CData API Server to connect to your MailChimp and perform CRUD operations on MailChimp from Node.js.
-
Build a Simple VCL Application for Bullhorn CRM Data
How to build a simple VCL Application to view Bullhorn CRM in RAD Studio using the CData ODBC Driver for Bullhorn CRM.
-
Migrating data from HubSpot to Snowflake using CData SSIS Components.
Easily push HubSpot to Snowflake using the CData SSIS Tasks for HubSpot and Snowflake.
-
Integrate Gumroad Data in the Pentaho Report Designer
Publish reports based on Gumroad in the Pentaho BI tool.
-
Use the CData Software JDBC Driver for Quickbase in MicroStrategy Web
Connect to Quickbase in MicroStrategy Web using the CData Software JDBC Driver for Quickbase.
-
How to use SQLAlchemy ORM to access Dotmailer Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Dotmailer.
-
Connect to Salesforce Marketing Data from AWS Glue
Use CData Connect AI to gain access to live Salesforce Marketing Cloud from your AWS Glue jobs.
-
Validate MarkLogic Data with QuerySurge
Access and validate MarkLogic in QuerySurge using the CData JDBC Driver.
-
Integrating Codex CLI with Browserless 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 Google Calendar Data in TIBCO Data Virtualization
Use the Google Calendar Tibco DV Adapter to create a Google Calendar data source in TIBCO Data Virtualization Studio and gain access to live Google Calendar from your TDV Server.
-
Create Reports with SFTP Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SFTP.
-
Getting Started with the CData Power BI Connector for Nethunt
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use the CData Software ODBC Driver for Clari in SAS for Real-Time Reporting and Analytics
Connect to real-time Clari in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Clari.
-
Use Dash to Build Web Apps on SAP SuccessFactors Data via CData Connect AI
Build interactive Dash web apps on live SAP SuccessFactors using pandas and the CData Connect AI Python SDK.
-
Create Informatica Mappings From/To an ODBC Data Source for iContact
Create an ODBC connection to iContact in Informatica and browse and transfer iContact.
-
Build EnterpriseDB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live EnterpriseDB and build visualizations in Tableau.
-
A PostgreSQL Interface for SageHR Data using the CData ODBC Driver
Use the SQL Gateway and SageHR ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Jodoo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Jodoo in the Denodo Virtual DataPort Administrator.
-
Bridge RabbitMQ Connectivity with Apache NiFi
Access and process RabbitMQ in Apache NiFi using the CData JDBC Driver.
-
LINQ to Microsoft OneDrive 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 Microsoft OneDrive Data Provider.
-
Automated Continuous Slack Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Slack replication to Google BigQuery.
-
Connect to Bright Data Data in DBeaver
Use the CData ODBC Driver to connect to Bright Data in DBeaver.
-
Query Yelp Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Yelp from Node.js.
-
Access Wave Financial Data from MySQL in PHP
Connect to Wave Financial through the standard MySQL libraries in PHP.
-
Build Apps with Live Printify Data Using the Low-Code Development Platform of Mendix
Connect Printify with Mendix to build apps using the CData API Driver for JDBC.
-
Getting Started with the CData JDBC Driver for HelloSign
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for HelloSign.
-
How to load Amazon S3 data into Elasticsearch via Logstash
Introducing a simple method to load Amazon S3 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Factorial Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Factorial from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software ODBC Driver for Postmark in MicroStrategy
Connect to Postmark in MicroStrategy Developer using the CData Software ODBC Driver for Postmark.
-
Bridge Gmail Connectivity with Apache NiFi
Access and process Gmail in Apache NiFi using the CData JDBC Driver.
-
Access Live Spark 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 Apache Spark SQL through MCP integration.
-
Replicate Multiple Spark Accounts
Replicate multiple Spark accounts to one or many databases.
-
Query Hugging Face Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Hugging Face from Node.js.
-
Connect to JSON Services in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for JSON Services and connect to JSON in Akorbi Digital RunMyProcess.
-
Automated Continuous Klaviyo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Klaviyo replication to delimited files (CSV/TSV).
-
Postmark Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Postmark facts in real time.
-
How to Connect to Live Odoo 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 Odoo ERP for you.