CData Software - Knowledge Base
Recent Articles
-
Connect to Microsoft Planner Data from a Connection Pool in Jetty
The Microsoft Planner JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Planner data from Web apps in Jetty.
-
How to integrate Metabase with Microsoft OneDrive Data
Use CData Connect AI to connect to live Microsoft OneDrive data and create an interactive dashboard in Metabase from Microsoft OneDrive data.
-
Build Semantic Layer Views for Cloudflare Data in APOS Live Data Gateway
Use the CData Connector for Cloudflare in APOS Live Data Gateway to build Semantic Layer Views for Cloudflare data.
-
Access Live Raisers Edge NXT Data in Excel 365 Online (Excel for the web)
Connect to Raisers Edge NXT data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Tavily 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 Tavily data.
-
Integrating Boomi Agentstudio with Redis Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Redis data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Pipeline CRM Data in NetBeans
Connect to Pipeline CRM data in NetBeans with the data source configuration wizard.
-
Build NetSuite-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to NetSuite data and build web apps with connectivity to live NetSuite data.
-
Replicate Multiple Billsby Accounts via the CData Sync CLI
Replicate multiple Billsby accounts to one or many databases.
-
Object-Relational Mapping (ORM) with Pipeline CRM 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 Pipeline CRM data into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData Python Connector for NASA
Learn to install and license the CData Python Connector and configure a connection to live NASA data.
-
Integrate with Live Apify Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Apify from the MuleSoft Anypoint Platform to integrate live Apify data into custom reports and dashboards.
-
How to create an RPA flow for Discord Data in UiPath Studio
Use the Discord ODBC Driver to create workflows that access real-time Discord data without any coding.
-
How to connect to ZendeskSell Data from Spring Boot
Connect to ZendeskSell in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Amazon Marketplace Data in DBeaver
Use the CData ODBC Driver to connect to Amazon Marketplace data in DBeaver.
-
Automated Continuous Microsoft Exchange Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Azure SQL Database.
-
How to Build an ETL App for Grafana Data in Python with CData Connect AI
Extract and transform live Grafana data in Python with petl and the CData Connect AI Python SDK.
-
Integrating Codex with Aha! 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 Freshservice Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Freshservice data and integrate live Freshservice data into your Power Automate tasks.
-
Bind Live Spark Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Spark data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Query Live Microsoft Teams 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 Microsoft Teams data directly from the development environment.
-
Write a Simple Go Application to work with Telegram Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Telegram data.
-
Use Biml to Build SSIS Tasks to Replicate Qualaroo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Qualaroo data to SQL Server.
-
How to Work with Zuora Data in ETL Validator JDBC
Connect to Zuora from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to & Open Todoist Data in Microsoft Excel
This article uses the CData ODBC driver for Todoist to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build a Simple VCL Application for ZendeskSell Data
How to build a simple VCL Application to view ZendeskSell data in RAD Studio using the CData ODBC Driver for ZendeskSell.
-
Integrate with live Paylocity Data in Jitterbit
Use CData Connect AI to connect to and integrate live Paylocity data in Jitterbit.
-
Easily Integrate Google Translate Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Translate data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Python Connector for SAP Business Warehouse
Learn to install and license the CData Python Connector and configure a connection to live SAP Business Warehouse data.
-
Connect to Salesforce from Asprova with CData Software ODBC Driver for Salesforce
This article shows how to connect faster to Salesforce data from Asprova.
-
Connect to Google Ads Data in NetBeans
Connect to Google Ads data in NetBeans with the data source configuration wizard.
-
Connect to Superchat Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Superchat and work with Superchat data in your FileMaker applications.
-
Automated Continuous Shippo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Shippo replication to Snowflake.
-
Publish Crystal Reports on Gumroad Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Gumroad data.
-
Build a Simple VCL Application for Oracle Financials Cloud Data
How to build a simple VCL Application to view Oracle Financials Cloud data in RAD Studio using the CData ODBC Driver for Oracle Financials Cloud.
-
ETL Salesloft in Oracle Data Integrator
This article shows how to transfer Salesloft data into a data warehouse using Oracle Data Integrator.
-
Integrate LibreChat with Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP SuccessFactors data from within the chat interface.
-
Automated Continuous Webex Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Webex data replication to OneLake in Microsoft Fabric.
-
Add Zoho Creator Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoho Creator with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build OnePageCrm-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live OnePageCrm data.
-
Intercom Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Intercom facts in real time.
-
Automated Continuous eBay Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable eBay replication to Apache Kafka.
-
Build Semantic Layer Views for Printful Data in APOS Live Data Gateway
Use the CData Connector for Printful in APOS Live Data Gateway to build Semantic Layer Views for Printful data.
-
Integrate HBase Data into Power Automate Desktop using CData Connect
CData Connect for HBase Data enables you to integrate HBase data into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to Adobe Analytics Data in Delphi
DataBind to Adobe Analytics data in Delphi with standard data access components and controls.
-
Integrate Paylocity Data in Pentaho Data Integration
Build ETL pipelines based on Paylocity data in the Pentaho Data Integration tool.
-
Integrate Live Greenplum Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Greenplum data from within the IDE.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Apify
Provide connectivity to Apify data through an SAP BusinessObjects universe.
-
Use Microsoft Copilot Studio to talk to your SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SharePoint data for you.
-
Query YouTube Analytics Data in DataGrip
Create a Data Source for YouTube Analytics in DataGrip and use SQL to query live YouTube Analytics data.
-
Working with Google Ad Manager Data in LINQPad
Execute LINQ queries to Google Ad Manager data in LINQPad.
-
Integrate Real-Time Access to Sage 300 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sage 300 data in real time.
-
How to Connect to Live Twitter Ads 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 Twitter Ads data for you.
-
Getting Started with the CData Power BI Connector for TigerGraph
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for TigerGraph.
-
Integrate Exa Data into Power Automate Desktop using CData Connect
CData Connect for Exa Data enables you to integrate Exa data into workflows built using Microsoft Power Automate Desktop.
-
Link Campaigner with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Campaigner data in Filemaker Pro for Mac or Windows.
-
Connect to Dynamics 365 Business Central Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Dynamics 365 Business Central data using standard SQL.
-
Create Lakebase-Connected Nintex Workflows
Use CData Connect AI to connect to Lakebase Data from Nintex Workflow Cloud and build custom workflows using live Lakebase data.
-
Integrate Real-Time Access to Kintone in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Kintone data in real time.
-
Access Vault CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Vault CRM data from HeidiSQL.
-
DataBind Charts to PayPal Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to PayPal 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.
-
Automated Continuous Timely Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Timely replication to Amazon S3.
-
Build MVC Applications with Connectivity to EnterpriseDB Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access EnterpriseDB from an ASP.NET MVC application.
-
Publish Crystal Reports on Epicor Kinetic Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Epicor Kinetic data.
-
Manage Highrise Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Highrise.
-
Deploy the ADO.NET Provider for REST on an SSRS Report Server
Connect to REST data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build Voice Agents in ElevenLabs with access to Live Lakebase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Lakebase data.
-
How to connect to Instantly Data with Squirrel SQL client
Connect to Instantly data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Highrise Replication to MongoDB
Use CData Sync for automated, continuous, customizable Highrise replication to MongoDB.
-
How to Use a Microsoft Access Database to Update Cassandra Data in Real Time
Update Cassandra data by creating a linked table in Microsoft Access with the CData Cassandra ODBC Driver.
-
Automate Unbounce Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Unbounce data from PowerShell? This article demonstrates how to utilize the Unbounce Cmdlets for tasks like connecting to Unbounce data, automating operations, downloading data, and more.
-
Access Outlook 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 Outlook data.
-
Integrating Cursor with YouTube Analytics 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 Live SAP Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP data to Blue Prism using the CData ODBC Driver for SAP to create automated workflows for repetitive business tasks.
-
How to Connect to & Open ZohoDesk Data in Microsoft Excel
This article uses the CData ODBC driver for ZohoDesk to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access SurveyMonkey 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 SurveyMonkey data.
-
Automated Continuous Bitly Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Bitly replication to delimited files (CSV/TSV).
-
Use JayDeBeApi to access Templated Data in Python
Use standard Python scripting and the development environment of your choice to access live Templated data.
-
Connect to Kafka Data from PowerBuilder via JDBC
This article demonstrates how to access Kafka data from PowerBuilder using the Kafka JDBC Driver.
-
Integrating Dataiku with PingOne Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live PingOne data.
-
DataBind DocuSign Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for DocuSign with the DevExpress Windows Forms and Web controls to provide DocuSign data to a chart.
-
Getting Started with the CData ADO.NET Provider for Google Analytics
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Analytics.
-
Migrating data from Everhour to Google BigQuery using CData SSIS Components.
Easily push Everhour data to Google BigQuery using the CData SSIS Tasks for Everhour and Google BigQuery.
-
How to work with Teradata Data in Apache Spark using SQL
Access and process Teradata Data in Apache Spark using the CData Software JDBC Driver.
-
Analyze Sybase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sybase data with the CData JDBC Driver for Sybase.
-
Connect to and Query BigCommerce Data in QlikView over ODBC
Create data visualizations with BigCommerce data in QlikView.
-
Create Informatica Mappings From/To an ODBC Data Source for Pipeliner CRM
Create an ODBC connection to Pipeliner CRM in Informatica and browse and transfer Pipeliner CRM data.
-
Integrate HBase Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to HBase data and integrate live HBase data into your Power Automate tasks.
-
Easily Integrate HubSpot Data in Lazarus Pascal IDE
Learn how to easily integrate live HubSpot data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Informatica Mappings From/To a JDBC Data Source for Accelo
Create Accelo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect the Power BI Service to Kintone: Complete Guide
Connect to the CData Software Power BI Connector for Kintone from PowerBI.com to provide real-time Kintone data across the organization.
-
A PostgreSQL Interface for Teradata Data (MySQL Remoting via JDBC)
Use the Remoting features of the Teradata JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Wave Financial Data Replication to Couchbase
Use CData Sync to Customize and automate Wave Financial data replication to Couchbase.
-
Integrate Trae with Live ServiceNow Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ServiceNow data from within the AI-powered IDE.
-
Analyze Grafana Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Grafana data and visualize Grafana data in SAP Analytics Cloud.
-
Automated Continuous MessageBird Replication to SingleStore
Use CData Sync for automated, continuous, customizable MessageBird replication to SingleStore.
-
Use Dash to Build to Web Apps on Suadeo Data
Create Python applications that use pandas and Dash to build Suadeo-connected web apps.
-
Build Dashboards with Mode Data in Dundas BI
Create dynamic dashboards and perform analytics based on Mode data in Dundas BI.
-
How to Connect to Landbot Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Landbot data. Leverage the pyodbc module for ODBC in Python.
-
How to create Quickbase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Quickbase data in MySQL .