CData Software - Knowledge Base
Recent Articles
-
Connect and Query Live HubDB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live HubDB data into Databricks and enable direct, live querying and analysis without replication.
-
Build MVC Applications with Connectivity to ElevenLabs Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ElevenLabs from an ASP.NET MVC application.
-
Access Dropbox 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 Dropbox data.
-
Automated Continuous HDFS Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable HDFS replication to PostgreSQL.
-
Build Semantic Layer Views for Xero Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Xero data.
-
Connect to Tickspot Data in Aqua Data Studio
Access Tickspot data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connecting Agentforce with API 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 API data for you.
-
Integrate with Jumpseller Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Jumpseller data in SnapLogic.
-
Build MySQL-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MySQL data and build web apps with connectivity to live MySQL data.
-
Visualize ChartMogul Data in Sisense
Create an ElastiCube in Sisense app with access to ChartMogul data.
-
Prepare, Blend, and Analyze Copper Data in Alteryx Designer (ODBC)
Build workflows to access live Copper data for self-service data analytics.
-
Build Shortcut-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Shortcut data and build web apps with connectivity to live Shortcut data.
-
DataBind Controls to SharePoint Excel Services Data in C++Builder
DataBind to SharePoint Excel Services data in C++Builder with standard components and controls.
-
Connecting GenSpark with ZohoMarketingHub Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to ZohoMarketingHub data without any replication or custom integration required.
-
Automate Trello Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Trello data from PowerShell? This article demonstrates how to utilize the Trello Cmdlets for tasks like connecting to Trello data, automating operations, downloading data, and more.
-
Build Agents in Relevance AI with Access to Live Salesloft Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Salesloft data within intelligent agent workflows.
-
Working with Browserless Data in LINQPad
Execute LINQ queries to Browserless data in LINQPad.
-
Automated Continuous Discord Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Discord replication to AlloyDB.
-
Connect to Factorial Data in Ruby
Connect to Factorial data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Analyze MailerLite Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MailerLite data and visualize live MailerLite data in Infragistics Reveal.
-
Object-Relational Mapping (ORM) with Zoho Recruit 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 Zoho Recruit data into a Java-based ORM framework, Hibernate.
-
How to create an RPA flow for SuiteCRM Data in UiPath Studio
Use the SuiteCRM ODBC Driver to create workflows that access real-time SuiteCRM data without any coding.
-
Automated Continuous Humanity Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Humanity replication to delimited files (CSV/TSV).
-
Using the CData Software ODBC Driver for Planio in PyCharm
Connect to Planio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Planio.
-
Import and Visualize Google Directory Data in Power View
Create data visualizations based on Google Directory data in Excel.
-
Integrating Claude Code CLI with AfterShip 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 GetResponse Data from AWS Glue
Use CData Connect AI to gain access to live GetResponse data from your AWS Glue jobs.
-
Build Grafana-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Grafana data.
-
Natively Connect to XML Data in PHP
The CData ODBC driver for XML enables you to create PHP applications with connectivity to XML data. Leverage the native support for ODBC in PHP.
-
Connect and Visualize Live Microsoft Ads Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Ads data into the Databricks platform and create visualization dashboards with real-time Microsoft Ads data.
-
Extract, Transform, and Load Codat Data in Informatica PowerCenter
Create a simple Workflow for Codat data in Informatica PowerCenter.
-
Integrate Google's Vertex AI Agent with Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live FTP data within intelligent workflows.
-
Building Dynamic Web Pages with SAP Ariba Procurement Data Using AngularJS
Create single-page applications with live connectivity to SAP Ariba Procurement using the CData API Server.
-
Integrate PhantomBuster Data in the Pentaho Report Designer
Publish reports based on PhantomBuster data in the Pentaho BI tool.
-
Bind Live Snowflake Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Snowflake data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Tally Data in Jaspersoft Studio
Execute SQL to remote Tally data in Jaspersoft Studio.
-
Integrating HubSpot Data in Talend Cloud Data Management Platform
Connect HubSpot Data with Talend Cloud Data Management Platform using the CData JDBC Driver for HubSpot.
-
MailChimp Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to MailChimp data through CData Connect AI using different applications and tools.
-
Integrate with Confluence Data in JReport Designer
Create charts and reports based on Confluence data in JReport Designer.
-
Establish a Live Connection with Zoho Inventory Data using Tableau Bridge
The CData ODBC Driver for Zoho Inventory enables you to integrate live Zoho Inventory data into Tableau Cloud dashboards using the Tableau Bridge.
-
LINQ to Elorus 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 Elorus Data Provider.
-
Build SQL Analysis Services-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SQL Analysis Services Data and create custom apps in Mendix.
-
Automated Continuous QuickBooks Online Replication to Snowflake
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Snowflake.
-
Integrating Antigravity CLI with Zoho Inventory data via CData CLI
Connect Zoho Inventory data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating LangChain with SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP Netweaver Gateway data within automated workflows.
-
Connect to Live Aweber Data in MicroStrategy through CData Connect AI
Create a live connection to Aweber Data in CData Connect AI and connect to your Aweber data from MicroStrategy.
-
Publish Reports with Datadog Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Datadog data.
-
Moving Data from IBM Cloud Object Storage to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live IBM Cloud Object Storage data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect to Zoom Data in DBVisualizer
Integrate Zoom data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build a Simple VCL Application for Bannerbear Data
How to build a simple VCL Application to view Bannerbear data in RAD Studio using the CData ODBC Driver for Bannerbear.
-
DataBind Controls to OneNote Data in C++Builder
DataBind to OneNote data in C++Builder with standard components and controls.
-
Integrate with live Shortcut Data in Jitterbit
Use CData Connect AI to connect to and integrate live Shortcut data in Jitterbit.
-
How to Connect to Live ServiceNow 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 ServiceNow data for you.
-
Integrate Drip with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Drip with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Drip data.
-
Connect to ClickUp Data in HULFT Integrate
Connect to ClickUp as a JDBC data source in HULFT Integrate
-
Connecting Moonlit Workflow with Amazon DynamoDB 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 Amazon DynamoDB data in real time.
-
How to Access Live Cvent Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Cvent enables you to integrate Cvent data into workflows built using Microsoft Power Automate Desktop.
-
Create SSAS Tabular Models from Greenplum Data
How to build a SQL Server Analysis Service Tabular Model from Greenplum data using CData drivers.
-
Analyze Amplitude Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Amplitude from Power Pivot. You will use the Table Import Wizard to load Amplitude data. You can visually build the import query or use any SQL supported by the driver.
-
Import and Visualize Invoiced Data in Power View
Create data visualizations based on Invoiced data in Excel.
-
Build a Singer.io Tap for SAS Data Sets With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAS Data Sets data using the CData Python Connector.
-
Design BIRT Reports on Accelo Data
Provide current Accelo data to your embedded analytics.
-
Edit and Search External Sybase Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Sybase data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Sybase Data objects that you can access from apps and the dashboard.
-
Integrate with live Mode Data in Jitterbit
Use CData Connect AI to connect to and integrate live Mode data in Jitterbit.
-
Build Apps with Live Mode Data Using the Low-Code Development Platform of Mendix
Connect Mode data with Mendix to build apps using the CData API Driver for JDBC.
-
How to Query Live CockroachDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CockroachDB data data in natural language using Python.
-
Connect to Raisers Edge NXT Data in ACL Analytics
Connect to Raisers Edge NXT data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Raisers Edge NXT data.
-
A PostgreSQL Interface for HBase Data using the CData ODBC Driver
Use the SQL Gateway and HBase ODBC Driver to create a PostgreSQL entry-point for data access.
-
Google Forms Reporting in OBIEE with the Google Forms JDBC Driver
Deploy the Google Forms JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Quickbase Data from Crystal Reports
Use CData Connect AI to connect to and report on live Quickbase data from Crystal Reports.
-
Connect to SAP SuccessFactors LMS Data in CloverDX (formerly CloverETL)
Transfer SAP SuccessFactors LMS data using the visual workflow in the CloverDX data integration tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for WordPress
Provide connectivity to WordPress data through an SAP BusinessObjects universe.
-
Connect to SuiteCRM Data in JRuby
Create a simple JRuby app with access to live SuiteCRM data.
-
How to Connect to & Open ClickUp Data in Microsoft Excel
This article uses the CData ODBC driver for ClickUp to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Operational Reporting on OData Services from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote OData services.
-
Connect to Parquet Data in Ruby
Connect to Parquet data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Live Google Sheets Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Sheets in CData Connect AI and connect to your Google Sheets data from PostgreSQL.
-
How to Create Power BI Visual Reports with Real-Time Raisers Edge NXT Data
Use CData Power BI Connectors to visualize Raisers Edge NXT data in Power BI.
-
Connect to Foursquare Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Foursquare.
-
How to connect to Google Spanner Data from IntelliJ
Integrate connectivity to Google Spanner data with wizards in IntelliJ.
-
Use CData Connect AI to Access Lakebase Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Lakebase data in the Power Pivot business intelligence tool.
-
Visualize Live Scrapfly Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Scrapfly data.
-
Object-Relational Mapping (ORM) with SAP Hybris C4C 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 SAP Hybris C4C data into a Java-based ORM framework, Hibernate.
-
Build MVC Applications with Connectivity to Acumatica Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Acumatica from an ASP.NET MVC application.
-
Automated Continuous Spark Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Spark replication to Google Cloud SQL.
-
Create Reports with Humanity Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Humanity data.
-
CData SAP Driver Deep Dive: How to Create SAP RFC Module and Access from CData Driver for SAP
A guide for how to call the generic modules and RFCs that form the core of the CData SAP ERP Driver
-
Create Azure Analysis Services-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Azure Analysis Services Data from OutSystems and build custom enterprise apps using live Azure Analysis Services data.
-
Build Apps with Live SAP Fieldglass data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Fieldglass data into the Adalo platform and build custom mobile and web applications with real-time SAP Fieldglass data.
-
Getting Started with the CData Excel Add-In for eBay Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for eBay Analytics.
-
Connect to Microsoft Dataverse Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Dataverse data from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Dataverse.
-
How to Create Power BI Visual Reports with Real-Time Adobe Target Data
Use CData Power BI Connectors to visualize Adobe Target data in Power BI.
-
Automated Continuous Zoho Creator Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Google Cloud SQL.
-
Integrating OpenCode with Azure Analysis Services 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.
-
Integrating LlamaIndex with Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Sage 200 data in real time.
-
How to Work with PagerDuty Data in ETL Validator JDBC
Connect to PagerDuty from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Python Connector for xBase
Learn to install and license the CData Python Connector and configure a connection to live xBase data.
-
How to Connect to Adobe Target Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Adobe Target data. Leverage the pyodbc module for ODBC in Python.
-
How to Build an ETL App for Perplexity Data in Python with CData Connect AI
Extract and transform live Perplexity data in Python with petl and the CData Connect AI Python SDK.
-
Manage Lakebase Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Lakebase.