CData Software - Knowledge Base
Recent Articles
-
Integrating LlamaIndex with Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Greenhouse in real time.
-
Access Live OnePageCrm Data in AWS Lambda
Connect to live OnePageCrm in AWS Lambda using the CData JDBC Driver.
-
Consume Jira OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Jira feeds that reflect any changes in SAP Lumira.
-
Access Live Planio Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Planio into the statistical analysis tools available in SAS JMP. This article shows how to use Planio in the Graph Builder and Query Builder.
-
Visualize Close Data in TIBCO Spotfire through ADO.NET
Integrate Close into dashboards in TIBCO Spotfire.
-
Analyze Live Odoo Data in SAS Viya
Use CData Connect AI to connect to Odoo ERP from SAS Viya and deploy self-service analytics using live Odoo ERP.
-
Explore Geographical Relationships in Smartsheet Data with Power Map
Create data visualizations with Smartsheet in Power Map.
-
Automated Continuous MarkLogic Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MarkLogic replication to Google BigQuery.
-
Configure the CData JDBC Driver for AdRoll in a Connection Pool in Tomcat
Connect to AdRoll from a connection pool in Tomcat.
-
Build MVC Applications with Connectivity to Avro Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Avro from an ASP.NET MVC application.
-
Integrate Mocean Data in the Pentaho Report Designer
Publish reports based on Mocean in the Pentaho BI tool.
-
Connect to Customer.io Data in NetBeans
Connect to Customer.io in NetBeans with the data source configuration wizard.
-
Build a Simple VCL Application for Avaza Data
How to build a simple VCL Application to view Avaza in RAD Studio using the CData ODBC Driver for Avaza.
-
Analyze MongoDB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MongoDB and visualize live MongoDB in Infragistics Reveal.
-
Build Agents in Relevance AI with Access to Live OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on OData within intelligent agent workflows.
-
Connect to SAS xpt Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Data Flows from CampaignMonitor to SQL Server using SSIS
Easily back up CampaignMonitor to SQL Server using the SSIS components for CampaignMonitor.
-
Connecting Pipedream with Microsoft Exchange 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 Microsoft Exchange data in real time.
-
Write a Simple Go Application to work with SAP Ariba Procurement Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Ariba Procurement.
-
Integrating Kiro CLI with CSV 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 Exact Online Data from a Connection Pool in JBoss
Integrate Exact Online into Java servlets: Use the Management Console in JBoss to install the Exact Online JDBC Driver.
-
Connect to and Visualize Live Azure Synapse Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Synapse.
-
Replicate Marketo Data to Multiple Databases via the CData Sync CLI
Replicate Marketo to disparate databases with a single configuration.
-
A PostgreSQL Interface for Cosmos DB Data (MySQL Remoting via JDBC)
Use the Remoting features of the Cosmos DB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Tableau Connector for Short.io
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
LINQ to LaunchDarkly 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 LaunchDarkly Data Provider.
-
How to create Teradata federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Teradata in MySQL .
-
Access Live Reply.io Data in Coginiti Pro
Connect to and query live Reply.io from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Oracle Financials Cloud Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle Financials Cloud from Filemaker Pro on Mac.
-
Connect to CapsuleCRM Data from a Connection Pool in Jetty
The CapsuleCRM JDBC Driver supports connection pooling: This article shows how to connect faster to CapsuleCRM from Web apps in Jetty.
-
Integrating LangChain with Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Presto within automated workflows.
-
Connect to and Visualize Live Marketo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Marketo.
-
Build Sage Cloud Accounting-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sage Business Cloud Accounting.
-
Build Avro-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Avro to explore live Avro Data in Claude Code to assist with building Avro-powered applications.
-
Use the CData SSIS Components to Insert New or Update Existing Google Drive Records from SQL Server
Easily push SQL Server data to Google Drive using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Drive or update existing records with data from a SQL Server database.
-
Visualize SAP HANA Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP HANA.
-
Connect to Coinbase Data in Aqua Data Studio
Access Coinbase from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
QuickBooks Time Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to QuickBooks Time through CData Connect AI using different applications and tools.
-
Build Visualizations of Calendly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Calendly in Birst.
-
Connecting Moonlit Workflow with Azure Data Lake Storage 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 Azure Data Lake Storage in real time.
-
Build a Singer.io Tap for Quaderno With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Quaderno data using
-
How to Work with Harvest Data in ETL Validator JDBC
Connect to Harvest from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live GitHub using the Model Context Protocol.
-
Connect to Helpscout Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Helpscout to connect to Helpscout and execute queries in PowerBuilder.
-
Access Live OData Services in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live OData from your Excel spreadsheets.
-
Getting Started with the CData Excel Add-In for ActiveCampaign
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ActiveCampaign.
-
How to connect PolyBase to Klaviyo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Klaviyo.
-
Model SAP Fieldglass Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Fieldglass, enabling the direct import of real-time SAP Fieldglass.
-
Build AI/ML Models with Live Google Search Data using Dataiku
Connect Google Search Data with Dataiku using the CData JDBC Driver for Google Search.
-
Use the CData Software JDBC Driver for Opsgenie in MicroStrategy Web
Connect to Opsgenie in MicroStrategy Web using the CData Software JDBC Driver for Opsgenie.
-
Connect to Freshsales Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Freshsales to connect to Freshsales and execute queries in PowerBuilder.
-
Analyze Everhour Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Everhour from Power Pivot. You will use the Table Import Wizard to load Everhour. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software ODBC Driver for Jira in MicroStrategy Web
Connect to Atlassian Jira in MicroStrategy Web using the CData Software ODBC Driver for Jira.
-
Design BIRT Reports on Redis Data
Provide current Redis to your embedded analytics.
-
Object-Relational Mapping (ORM) with Kintone 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 Kintone into a Java-based ORM framework, Hibernate.
-
How to Work with Google Spanner Data in ETL Validator JDBC
Connect to Google Spanner from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Query SuiteCRM Data in MySQL Workbench
Execute MySQL queries against live SuiteCRM from MySQL Workbench.
-
How to Query Zendesk Data in MySQL Workbench
Execute MySQL queries against live Zendesk from MySQL Workbench.
-
Rapidly Develop Parallel-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 Parallel.
-
Import Real-Time ShipEngine Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ShipEngine in ColdFusion.
-
Automated Continuous SparkPost Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SparkPost replication to Amazon S3.
-
Integrate TigerGraph with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate TigerGraph with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to TigerGraph.
-
Create Datasets from Nethunt in Domo Workbench and Build Visualizations of Nethunt Data in Domo
Use the CData Software ODBC Driver for Nethunt to create datasets from Nethunt in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Cline with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Amazon Athena from within your IDE.
-
How to update MariaDB from Excel
This article explains how to transfer data from Excel to MariaDB using the Excel Add-In for MariaDB.
-
Use the CData Software JDBC Driver for Slack in MicroStrategy Desktop
Connect to Slack in MicroStrategy Desktop using the CData Software JDBC Driver for Slack.
-
DataBind Controls to REST Data in Delphi
DataBind to REST in Delphi with standard data access components and controls.
-
How to Query Live Dynamics CRM Data in Claude Desktop
Connect to and query live Dynamics CRM Data in Claude Desktop using CData MCP Server.
-
Publish OpenWeatherMap-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live OpenWeatherMap.
-
Build Automated SAP Concur-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Concur and build automated workflows in Zapier.
-
Create Sendwithus Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sendwithus from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind REST Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for REST with the DevExpress Windows Forms and Web controls to provide REST to a chart.
-
Rapidly Develop Amazon S3-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 Amazon S3.
-
Drift Reporting in OBIEE with the Drift JDBC Driver
Deploy the Drift JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Avaza Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Avaza from HeidiSQL.
-
Process & Analyze Freshteam Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Freshteam Data.
-
Integrate Live SharePoint Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft SharePoint and integrate live Microsoft SharePoint into apps built in Microsoft Power Apps.
-
Visualize Productboard Data in Sisense
Create an ElastiCube in Sisense app with access to Productboard.
-
Getting Started with the CData ODBC Driver for VWO
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for VWO.
-
Build a Simple VCL Application for Accelo Data
How to build a simple VCL Application to view Accelo in RAD Studio using the CData ODBC Driver for Accelo.
-
Access Live ZohoPeople Data in AWS Lambda
Connect to live ZohoPeople in AWS Lambda using the CData JDBC Driver.
-
How to create Highrise federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Highrise CRM in MySQL .
-
Integrate Cloudflare Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Cloudflare from Informatica Cloud.
-
Automate Google Contacts Data Replication to SAP HANA
Use CData Sync to customize and automate Google Contacts replication to SAP HANA.
-
Using the CData Software ODBC Driver for Qualaroo in PyCharm
Connect to Qualaroo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Qualaroo.
-
Bridge Basecamp Connectivity with Apache NiFi
Access and process Basecamp in Apache NiFi using the CData JDBC Driver.
-
How to publish and share Presto Data dashboards with Tableau Server
The CData ODBC driver for Presto enables you integrate Presto into Tableau dashboards.
-
Build Charts with Cohere Data in Clear Analytics
Create dynamic charts and perform analytics based on Cohere in Clear Analytics.
-
Feed Mode Data into FineReport
How to set Mode as a JDBC data source in FineReport.
-
How to Query Live Bullhorn CRM Data in Claude Desktop
Connect to and query live Bullhorn CRM Data in Claude Desktop using CData MCP Server.
-
Build AI/ML Models with Live RSS Data using Dataiku
Connect RSS Data with Dataiku using the CData JDBC Driver for RSS.
-
Build a Singer.io Tap for Microsoft Ads With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Microsoft Ads data using
-
Automated Continuous Presto Replication to MySQL
Use CData Sync for automated, continuous, customizable Presto replication to MySQL.
-
Connect to Avalara AvaTax Data in Aqua Data Studio
Access Avalara AvaTax from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Explore Geographical Relationships in Chargebee Data with Power Map
Create data visualizations with Chargebee in Power Map.
-
Build Apps with Live ClickUp Data Using the Low-Code Development Platform of Mendix
Connect ClickUp with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Stripe Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Stripe replication to Google Cloud SQL.
-
Automated Continuous Xero Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Xero replication to PostgreSQL.
-
Use the CData Software ODBC Driver for Sentry in MicroStrategy Web
Connect to Sentry in MicroStrategy Web using the CData Software ODBC Driver for Sentry.
-
Integrate Live Sybase Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Sybase to Blue Prism using the CData ODBC Driver for Sybase to create automated workflows for repetitive business tasks.