CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Mode 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 Mode data for you.
-
Easily Integrate eBay Analytics Data in Lazarus Pascal IDE
Learn how to easily integrate live eBay Analytics data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
DataBind Controls to HubDB Data in Delphi
DataBind to HubDB data in Delphi with standard data access components and controls.
-
Query Tanda Data as a MySQL Database in Node.js
Execute MySQL queries against Tanda data from Node.js.
-
Connect to Microsoft OneDrive Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft OneDrive and the SQL Gateway to access Microsoft OneDrive data from Google Apps Script.
-
Integrating SharePoint Excel Services Data in Talend Cloud Data Management Platform
Connect SharePoint Excel Services Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SharePoint Excel Services.
-
Choosing the Best Method to Connect Salesforce CRM Analytics to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Salesforce CRM Analytics data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect to Paddle Data from IntelliJ
Integrate connectivity to Paddle data with wizards in IntelliJ.
-
Visualize Zuora Data in TIBCO Spotfire through OData
Integrate Zuora data into dashboards in TIBCO Spotfire.
-
Excel Spreadsheet Automation on PhantomBuster Data with the QUERY Formula
Pull data from PhantomBuster, automate spreadsheets, and more with the QUERY formula.
-
Object-Relational Mapping (ORM) with Salesloft 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 Salesloft data into a Java-based ORM framework, Hibernate.
-
Automated Continuous Snapchat Ads Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Snapchat Ads data replication to OneLake in Microsoft Fabric.
-
DataBind Charts to Freshdesk Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Freshdesk 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.
-
Connect to Webex Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Webex as an External Source in Dremio.
-
Analyze Office 365 Data in Cognos Analytics
Use CData Connect AI to connect to Office 365 Data from Cognos Analytics and analyze live Office 365 data.
-
Back Up Grafana data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Grafana data data.
-
Build Apps with Live Google Campaign Manager 360 Data Using the Low-Code Development Platform of Mendix
Connect Google Campaign Manager 360 data with Mendix to build apps using the CData JDBC Driver for Google Campaign Manager 360.
-
Connect to Cloudant Data in CloverDX (formerly CloverETL)
Transfer Cloudant data using the visual workflow in the CloverDX data integration tool.
-
Design BIRT Reports on Oracle Sales Data
Provide current Oracle Sales data to your embedded analytics.
-
Visualize Salesforce Data in TIBCO Spotfire through OData
Integrate Salesforce data into dashboards in TIBCO Spotfire.
-
Use Microsoft Copilot Studio to talk to your Act-On 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 Act-On data for you.
-
Integrate ShipEngine Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to ShipEngine data and integrate live ShipEngine data into your Power Automate tasks.
-
Use CData Connect AI to Access Dynamics CRM Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Dynamics CRM data in the Power Pivot business intelligence tool.
-
Connecting Pipedream with xBase 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 xBase data in real time.
-
DataBind Postmark Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Postmark data to a chart.
-
Automated Continuous OnePageCrm Replication to SQL Server
Use CData Sync for automated, continuous, customizable OnePageCrm replication to SQL Server.
-
Automate SpaceX Data Replication to Couchbase
Use CData Sync to Customize and automate SpaceX data replication to Couchbase.
-
How to Connect to Live Zoho Creator Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zoho Creator data securely in real time.
-
Bridge ZendeskSell Connectivity with Apache NiFi
Access and process ZendeskSell data in Apache NiFi using the CData JDBC Driver.
-
Connect to Microsoft OneDrive Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft OneDrive data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Teamwork Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Teamwork replication to delimited files (CSV/TSV).
-
Replicate SingleStore Data from PowerShell
Write a quick PowerShell script to query SingleStore data. Use connectivity to the live data to replicate SingleStore data to SQL Server.
-
How to Query SendInBlue Data in MySQL Workbench
Execute MySQL queries against live SendInBlue data from MySQL Workbench.
-
Create Dynamics 365-Connected Dashboards in Grafana
Connect to Dynamics 365 Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Dynamics 365 data.
-
Create Data Visualizations Based On MailerLite Data in Mode
Use CData Connect AI to connect to MailerLite Data from Mode and build visualizations using live MailerLite data.
-
Natively Connect to OpenWeatherMap Data in PHP
The CData ODBC driver for OpenWeatherMap enables you to create PHP applications with connectivity to OpenWeatherMap data. Leverage the native support for ODBC in PHP.
-
Model, Search, and Visualize Live AgileCRM Data in ThoughtSpot
Use CData Connect AI to connect to live AgileCRM data for modeling, searching, and visualizing.
-
Integrate Theia IDE with Live Attio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Attio data from within the development environment.
-
How to use SQLAlchemy ORM to access Optimizely Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Optimizely data.
-
Working with ZeroBounce Data in LINQPad
Execute LINQ queries to ZeroBounce data in LINQPad.
-
Prepare, Blend, and Analyze Wistia Data in Alteryx Designer (Connect AI)
Build workflows to access live Wistia data for self-service data analytics.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Mailgun
Provide connectivity to Mailgun data through an SAP BusinessObjects universe.
-
Automate Bright Data Data Replication to Couchbase
Use CData Sync to Customize and automate Bright Data data replication to Couchbase.
-
Integrating GitHub Copilot with Brex 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 Gmail Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Gmail data and integrate live Gmail data into apps built in Microsoft Power Apps.
-
Work with Pushbullet Data in FoxPro
Load Pushbullet data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Data Visualizations Based On Spark Data in Mode
Use CData Connect AI to connect to Spark Data from Mode and build visualizations using live Spark data.
-
Automated Continuous Mouseflow Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Mouseflow replication to PostgreSQL.
-
Integrate Kafka Data in the Pentaho Report Designer
Publish reports based on Kafka data in the Pentaho BI tool.
-
Automated Continuous SAS xpt Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAS xpt replication to Snowflake.
-
Build Toggl Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Toggl data and build visualizations in Tableau.
-
Use the CData ODBC Driver for Planio in Microsoft Power Query
You can use the CData Planio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Planio data into Microsoft Power Query.
-
How to Query Live Vercel Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Vercel data data in natural language using Python.
-
Query Lakebase Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Lakebase data from Node.js.
-
Integrate Harvest Data in Pentaho Data Integration
Build ETL pipelines based on Harvest data in the Pentaho Data Integration tool.
-
Getting Started with the CData Connect AI Python SDK for SFTP
Install the CData Connect AI Python SDK to read and write live SFTP data with standard DB-API 2.0 Python code.
-
Automated Continuous Google Ad Manager Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Google BigQuery.
-
Create Datasets from Airtable in Domo Workbench and Build Visualizations of Airtable Data in Domo
Use the CData Software ODBC Driver for Airtable to create datasets from Airtable data in Domo Workbench and then build visualizations in the Domo service.
-
Build a PostgreSQL Interface for Azure Analysis Services Data using the CData JDBC Driver
Use the Remoting features of the Azure Analysis Services JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous ShipStation Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ShipStation data replication to OneLake in Microsoft Fabric.
-
Work with LaunchDarkly Data in FoxPro
Load LaunchDarkly data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Live Presto Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Presto in CData Connect AI and connect to your Presto data from PostgreSQL.
-
Integrate Google's Vertex AI Agent with Live Box 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 Box data within intelligent workflows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZohoExpense
Provide connectivity to ZohoExpense data through an SAP BusinessObjects universe.
-
Replicate Multiple PagerDuty Accounts
Replicate multiple PagerDuty accounts to one or many databases.
-
Create Reports with Freshteam Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshteam data.
-
Automate Webex Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Webex data from PowerShell? This article demonstrates how to utilize the Webex Cmdlets for tasks like connecting to Webex data, automating operations, downloading data, and more.
-
Excel Spreadsheet Automation on Wave Financial Data with the QUERY Formula
Pull data from Wave Financial, automate spreadsheets, and more with the QUERY formula.
-
Provide OData Services of Microsoft Planner Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Planner data by developing a WCF Service Application.
-
How to Build an ETL App for Zendesk Data in Python with CData
Create ETL applications and real-time data pipelines for Zendesk data in Python with petl.
-
Access Live Microsoft Ads 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 Microsoft Ads data through MCP integration.
-
How to Work with Aha! Data in AWS Glue Jobs Using JDBC
Connect to Aha! from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Perigon with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Perigon with External Services.
-
Integrate Open WebUI with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure Data Lake Storage data from within the chat interface.
-
How to connect SharePoint with Google Drive Data through external lists
Provide Google Drive data to SharePoint users as an external list.
-
Use the CData Software JDBC Driver for IBM Cloud Object Storage in MicroStrategy Web
Connect to IBM Cloud Object Storage data in MicroStrategy Web using the CData Software JDBC Driver for IBM Cloud Object Storage.
-
Object-Relational Mapping (ORM) with FormSite 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 FormSite data into a Java-based ORM framework, Hibernate.
-
Consume HDFS OData Feeds in PowerBuilder
This article demonstrates how to consume HDFS data as OData feeds from PowerBuilder using the API Server.
-
Use CData Sync to Replicate NetSuite Data to Snowflake
Use CData Sync to add NetSuite data to your Snowflake data warehouse.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Bitbucket
Provide connectivity to Bitbucket data through an SAP BusinessObjects universe.
-
Connect to Jumpseller Data from a Connection Pool in JBoss
Integrate Jumpseller data into Java servlets: Use the Management Console in JBoss to install the Jumpseller JDBC Driver.
-
Connect to Discourse Data in Ruby
Connect to Discourse data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Creating SAP SuccessFactors-Connected Applications in Unqork
You can use CData Connect AI to feed SAP SuccessFactors data to Unqork and build custom business apps.
-
Automated Continuous Toggl Replication to MySQL
Use CData Sync for automated, continuous, customizable Toggl replication to MySQL.
-
Use Microsoft Copilot Studio to talk to your SAP HANA 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 SAP HANA data for you.
-
Integrate with JotForm Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy JotForm data to a JSON file on disk.
-
Build Apps with Live Raisers Edge NXT Data Using the Low-Code Development Platform of Mendix
Connect Raisers Edge NXT data with Mendix to build apps using the CData JDBC Driver for Raisers Edge NXT.
-
Access Live PayPal Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to PayPal data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Manage Elasticsearch Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Elasticsearch.
-
Build Apps with Live Egnyte data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Egnyte data into the Adalo platform and build custom mobile and web applications with real-time Egnyte data.
-
Access Live Gmail Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Gmail data into the statistical analysis tools available in SAS JMP. This article shows how to use Gmail data in the Graph Builder and Query Builder.
-
CapsuleCRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on CapsuleCRM facts in real time.
-
Build Insightly-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Insightly data.
-
Create Reports with Aircall Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Aircall data.
-
Migrating data from Jira to Snowflake using CData SSIS Components.
Easily push Jira data to Snowflake using the CData SSIS Tasks for Jira and Snowflake.
-
Integrating GitHub Copilot with Mistral AI 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.
-
How to Connect to Strava Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Strava data. Leverage the pyodbc module for ODBC in Python.
-
Use the CData SSIS Components to Insert New or Update Existing Teradata Records from SQL Server
Easily push SQL Server data to Teradata using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Teradata or update existing records with data from a SQL Server database.
-
How to Connect to Live Avalara AvaTax Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Avalara AvaTax data for you.
-
Bind Live SQL Server Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SQL Server data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.