CData Software - Knowledge Base
Recent Articles
-
Connect to MarkLogic Data in Ruby
Connect to MarkLogic in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Building Dynamic Web Pages with Reckon Accounts Hosted Data Using AngularJS
Create single-page applications with live connectivity to Reckon Accounts Hosted using the CData API Server.
-
Analyze Onfleet Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Onfleet with the CData JDBC Driver for Onfleet.
-
Migrating data from Greenhouse to Snowflake using CData SSIS Components.
Easily push Greenhouse to Snowflake using the CData SSIS Tasks for Greenhouse and Snowflake.
-
Integrating Claude Code with SAP Hybris C4C Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP Hybris C4C within assisted coding and automated development workflows.
-
Connect to SAP Ariba Procurement Data in Ruby
Connect to SAP Ariba Procurement in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Work with IBM Informix Data in FoxPro
Load IBM Informix into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to create Visio diagrams from Lakebase Data
Automatically update Lakebase with the changes you make to Visio master shapes.
-
Create Reports with Tavily Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Tavily.
-
How to Query Freshservice Data in MySQL Workbench
Execute MySQL queries against live Freshservice from MySQL Workbench.
-
Connect to Google Contacts Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Contacts in Airbyte.
-
Connect Certinia Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Certinia using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Live Gmail Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to RSS Feeds from PowerBuilder via ADO.NET
This article demonstrates how to access RSS Feeds from Appeon PowerBuilder using the CData ADO.NET Provider for RSS.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Stack Exchange
Provide connectivity to Stack Exchange through an SAP BusinessObjects universe.
-
Choosing the Best Method to Connect Placid to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Placid from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Build an ETL App for Microsoft Ads Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Ads in Python with petl.
-
How to connect to Excel Data from Spring Boot
Connect to Excel in a Spring Boot Application using the CData JDBC Driver for Microsoft Excel
-
Connect to JSON Services Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for JSON and the Script function in FileMaker Pro to connect to JSON and work with JSON in your FileMaker application.
-
Connect to QuickBooks Time Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with QuickBooks Time Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Query Live Azure Table Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure Table Storage data in natural language using Python.
-
Analyze MariaDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of MariaDB and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live Attio Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Attio in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Azure Data Catalog Data in DBeaver
Use the CData ODBC Driver to connect to Azure Data Catalog in DBeaver.
-
Connect to PayPal Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for PayPal in Airbyte.
-
How to Easily Query Trello Data in OpenOffice Base
Connect to Trello data in OpenOffice Base using the CData ODBC Driver for Trello and generate reports with live data insights.
-
Manage Trello Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Trello.
-
Automated Continuous Coinbase Replication to Oracle
Use CData Sync for automated, continuous, customizable Coinbase replication to Oracle.
-
Enable the Mailgun JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Mailgun.
-
Build Charts with Cassandra Data in Clear Analytics
Create dynamic charts and perform analytics based on Apache Cassandra in Clear Analytics.
-
Build a PostgreSQL Interface for Sage 300 Data using the CData JDBC Driver
Use the Remoting features of the Sage 300 JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Seamlessly Import Figshare Data into IBM SPSS Modeler
Integrate Figshare data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Query Live Reckon Data in Perplexity MacOS Desktop
Connect to and query live Reckon Data in Perplexity Desktop using CData MCP Server.
-
Automate Acumatica Data Replication to SAP HANA
Use CData Sync to customize and automate Acumatica ERP replication to SAP HANA.
-
A PostgreSQL Interface for Keap Data (MySQL Remoting via JDBC)
Use the Remoting features of the Keap JDBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the LaunchDarkly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with LaunchDarkly.
-
Automated Continuous AdRoll Replication to Oracle
Use CData Sync for automated, continuous, customizable AdRoll replication to Oracle.
-
Connect Flowlu Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Flowlu using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live Gmail Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Gmail from your Excel spreadsheets.
-
Use ChatGPT to Talk to Your FTP 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 FTP Servers for you.
-
Access Live MariaDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MariaDB from your Google Sheets.
-
How to Work with PhantomBuster Data in ETL Validator JDBC
Connect to PhantomBuster from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Avalara AvaTax Data in HULFT Integrate
Connect to Avalara AvaTax as a JDBC data source in HULFT Integrate
-
Use Databricks Agent Bricks to Talk to Your Twitter Ads Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Twitter Ads for you.
-
Query Anaplan Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Anaplan and perform CRUD operations on Anaplan from Node.js.
-
Build Dashboards with Phoenix Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apache Phoenix in Dundas BI.
-
Automated Continuous Adobe Commerce Replication to SQLite
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to SQLite.
-
Access Live Office 365 Data in Coginiti Pro
Connect to and query live Microsoft Office 365 from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build OnePageCrm-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live OnePageCrm Data in GitHub Copilot to assist with building OnePageCrm-powered applications.
-
Use Agno to Talk to Your SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SAP Fieldglass for you.
-
Connect to Gong Data in JRuby
Create a simple JRuby app with access to live Gong.
-
Connect to Mistral AI Data in DBArtisan
Use wizards in DBArtisan to configure Mistral AI as a data source.
-
Connect to Live Microsoft Ads Data in MicroStrategy through CData Connect AI
Create a live connection to Microsoft Ads Data in CData Connect AI and connect to your Microsoft Ads from MicroStrategy.
-
Build Pipelines with Live Slack Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Slack from Google Cloud Data Fusion, enabling the integration of live Slack into the building and management of effective data pipelines.
-
Build Visualizations of Sage Cloud Accounting Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sage Business Cloud Accounting in Birst.
-
Connect to Qualaroo Data in DBeaver
Use the CData ODBC Driver to connect to Qualaroo in DBeaver.
-
Use Databricks Agent Bricks to Talk to Your Microsoft Exchange Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Exchange for you.
-
Build Automated Workflows with Live Adobe Analytics Data in Workato
Use CData Connect AI to connect to live Adobe Analytics and build automated workflows in Workato.
-
Build Pipelines with Live AlloyDB Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to AlloyDB from Google Cloud Data Fusion, enabling the integration of live Google AlloyDB into the building and management of effective data pipelines.
-
Integrating Claude Code CLI with Float 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.
-
LINQ to Avalara AvaTax 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 Avalara AvaTax Data Provider.
-
Replicate Multiple Cosmos DB Accounts
Replicate multiple Cosmos DB accounts to one or many databases.
-
Integrate Live QuickBooks Time Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to QuickBooks Time and integrate live QuickBooks Time into apps built in Microsoft Power Apps.
-
Access Live ZohoDesk Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live ZohoDesk data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use the CData Software JDBC Driver for Splunk in MicroStrategy Web
Connect to Splunk in MicroStrategy Web using the CData Software JDBC Driver for Splunk.
-
How to Access Live Keap Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Keap from the Cline extension in Visual Studio Code.
-
Use ChatGPT to Talk to Your Amazon S3 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 Amazon S3 for you.
-
Build AI/ML Models with Live Parquet Data using Dataiku
Connect Parquet Data with Dataiku using the CData JDBC Driver for Parquet.
-
Build EnterpriseDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live EnterpriseDB.
-
Integrate Theia IDE with Live DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Getting Started with the CData Tableau Connector for GetResponse
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Connect to Live Salesforce Marketing Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Salesforce Marketing Cloud without replication.
-
Query LDAP Objects using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume LDAP entities in PHP by modeling them as objects.
-
Integrate Live Instantly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Instantly to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connecting Mastra with MailChimp 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 MailChimp, no replication required.
-
Build PDFMonkey-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live PDFMonkey Data in GitHub Copilot to assist with building PDFMonkey-powered applications.
-
Visualize CloudConvert Data in Sisense
Create an ElastiCube in Sisense app with access to CloudConvert.
-
Build a PostgreSQL Interface for ShipStation Data using the CData JDBC Driver
Use the Remoting features of the ShipStation JDBC Driver to create a PostgreSQL entry-point for data access.
-
Back Up Certinia to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Certinia. In this article, we will employ an SSIS workflow to populate a database with Certinia data.
-
Create Data Visualizations in Cognos BI with Act CRM Data
Access Act CRM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Access Live Telegram Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Telegram from the Cline extension in Visual Studio Code.
-
How to Access Hive Data Using Entity Framework
This article shows how to access Apache Hive using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze ActiveCampaign Data in Cognos Analytics
Use CData Connect AI to connect to ActiveCampaign Data from Cognos Analytics and analyze live ActiveCampaign.
-
How to create an RPA flow for Datadog Data in UiPath Studio
Use the Datadog ODBC Driver to create workflows that access real-time Datadog without any coding.
-
Integrate Live Excel Online Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Excel Online from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Excel Online.
-
Automated Continuous Facebook Ads Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Google Cloud SQL.
-
How to Connect to Live OData Services 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 OData for you.
-
Build AlloyDB-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for AlloyDB Data and create custom apps in Mendix.
-
Build a Simple VCL Application for SAP SuccessFactors LMS Data
How to build a simple VCL Application to view SAP SuccessFactors LMS in RAD Studio using the CData ODBC Driver for SAP SuccessFactors LMS.
-
Integrate JobNimbus with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate JobNimbus with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to JobNimbus.
-
Access Google Forms Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Google Forms.
-
Stream Sage Cloud Accounting Data into Apache Kafka Topics
Access and stream Sage Business Cloud Accounting in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create CockroachDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for CockroachDB from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Access Replication to Databricks
Use CData Sync for automated, continuous, customizable Access replication to Databricks.
-
Natively Connect to HCL Domino Data in PHP
The CData ODBC driver for HCL Domino enables you to create PHP applications with connectivity to HCL Domino. Leverage the native support for ODBC in PHP.
-
Integrate Theia IDE with Live SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Provide OData Services of Google Drive Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Drive by developing a WCF Service Application.
-
Bind Live Telegram Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Telegram data
-
Connect to Google Tasks from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Tasks to connect to Google Tasks from Web applications running on WebLogic.
-
Create SSAS Tabular Models from Box Data
How to build a SQL Server Analysis Service Tabular Model from Box using CData drivers.