CData Software - Knowledge Base
Recent Articles
-
Integrate Live OpenWeatherMap Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live OpenWeatherMap data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Visualize Act-On Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Act-On data in Python.
-
Automated Continuous Lakebase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Lakebase replication to Google BigQuery.
-
Automate Guru Data Replication to Azure Data Lake
Use CData Sync to customize and automate Guru data replication to Azure Data Lake.
-
How to connect PolyBase to Greenhouse
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Greenhouse data.
-
Consume Gmail OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Gmail feeds that reflect any changes in SAP Lumira.
-
Connect to Greenhouse 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 Greenhouse data.
-
Automated Continuous Retently Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Retently replication to Amazon Redshift.
-
Automate Google Drive Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Drive data from PowerShell? This article demonstrates how to utilize the Google Drive Cmdlets for tasks like connecting to Google Drive data, automating operations, downloading data, and more.
-
Choosing the Best Method to Connect SAP SuccessFactors to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP SuccessFactors data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Trello Data in AWS Lambda
Connect to live Trello data in AWS Lambda using the CData JDBC Driver.
-
Visualize WooCommerce Data in Sisense
Create an ElastiCube in Sisense app with access to WooCommerce data.
-
Build Apps with Live Elasticsearch Data Using the Low-Code Development Platform of Mendix
Connect Elasticsearch data with Mendix to build apps using the CData JDBC Driver for Elasticsearch.
-
Getting Started with the CData Power BI Connector for Splunk
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Splunk.
-
How to publish and share Cvent Data dashboards with Tableau Server
The CData ODBC driver for Cvent enables you integrate Cvent data into Tableau dashboards.
-
Use the CData Software ODBC Driver for CampaignMonitor in MicroStrategy Desktop
Connect to CampaignMonitor data in MicroStrategy Desktop using the CData Software ODBC Driver for CampaignMonitor.
-
Access Live PostgreSQL Data in Coginiti Pro
Connect to and query live PostgreSQL data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Microsoft Exchange Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Exchange data into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Exchange data in the Graph Builder and Query Builder.
-
Rapidly Develop Freshteam-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 Freshteam.
-
Integrate Google's Antigravity Agent with Live Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Oracle SCM data using the Model Context Protocol.
-
Analyze CSV Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of CSV data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to SingleStore Data from HeidiSQL
Use CData Connect AI to connect to and query live SingleStore data from HeidiSQL.
-
Work with Moosend Data in FoxPro
Load Moosend data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Manage Act CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Act CRM.
-
Integrate with SharePoint Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SharePoint data to a JSON file on disk.
-
How to Connect Adobe Commerce Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Adobe Commerce data in real time using natural language.
-
Create Dashboards and Visualize Live Bullhorn CRM Data in Geckoboard
Use CData Connect AI to connect to live Bullhorn CRM data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
DataBind Controls to ZendeskSell Data in C++Builder
DataBind to ZendeskSell data in C++Builder with standard components and controls.
-
Using the CData Software ODBC Driver for Azure Table in PyCharm
Connect to Azure Table as an ODBC data source in PyCharm using the CData Software ODBC Driver for Azure Table.
-
Create a Data Access Object for Couchbase Data using JDBI
A brief overview of creating a SQL Object API for Couchbase data in JDBI.
-
Connect to Blackbaud FE NXT Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Blackbaud FE NXT data using standard SQL.
-
Automated Continuous MessageBird Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MessageBird replication to AlloyDB.
-
How to work with Amazon DynamoDB Data in Apache Spark using SQL
Access and process Amazon DynamoDB Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating LangChain with MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MongoDB data within automated workflows.
-
Build Agents in Relevance AI with Access to Live Aweber Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Aweber data within intelligent agent workflows.
-
Connect to BenchmarkEmail 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 BenchmarkEmail data.
-
Getting Started with the CData Python Connector for ZohoInvoice
Learn to install and license the CData Python Connector and configure a connection to live ZohoInvoice data.
-
Visualize Nethunt Data in Sisense
Create an ElastiCube in Sisense app with access to Nethunt data.
-
Integrate Dify with Live Sage 300 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Sage 300 data.
-
Integrating Gumloop with AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on AlloyDB data within automated workflows.
-
Connect to ChartMogul Data in NetBeans
Connect to ChartMogul data in NetBeans with the data source configuration wizard.
-
Provide OData Services of Freshservice Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Freshservice data by developing a WCF Service Application.
-
Automated Continuous Teamwork Replication to Databricks
Use CData Sync for automated, continuous, customizable Teamwork replication to Databricks.
-
Load ADP Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ADP data to a database.
-
Replicate Tally Data to Multiple Databases via the CData Sync CLI
Replicate Tally data to disparate databases with a single configuration.
-
Connecting Moonlit Workflow with QuickBooks Online 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 QuickBooks Online data in real time.
-
Access Live Zoho CRM Data in AWS Lambda
Connect to live Zoho CRM data in AWS Lambda using the CData JDBC Driver.
-
Bind Live Microsoft Planner Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Planner data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Getting Started with the CData Connect AI Python SDK for MailerLite
Install the CData Connect AI Python SDK to read live MailerLite data with standard DB-API 2.0 Python code.
-
Build Shopify Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Shopify data and build visualizations in Tableau.
-
Connect to Freshteam Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Freshteam data from Filemaker Pro on Mac.
-
How to Connect to & Open AdRoll Data in Microsoft Excel
This article uses the CData ODBC driver for AdRoll to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dashboards with Sugar CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Sugar CRM data in DBxtra.
-
Use the CData ODBC Driver for Hacker News in Microsoft Power Query
You can use the CData Hacker News ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Hacker News data into Microsoft Power Query.
-
Connect to Access in SpagoBI
Create reports featuring live Access data in SpagoBI Studio. Host Access reports on SpagoBI Server.
-
Integrating Cursor with PingOne 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.
-
Use Biml to Build SSIS Tasks to Replicate CircleCI Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate CircleCI data to SQL Server.
-
Prepare, Blend, and Analyze ADP Data in Alteryx Designer (Connect AI)
Build workflows to access live ADP data for self-service data analytics.
-
Integrating Gmail Data in Talend Cloud Data Management Platform
Connect Gmail Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Gmail.
-
Integrate Theia IDE with Live Exa 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 Exa data from within the development environment.
-
Office 365 Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Office 365 data through CData Connect AI using different applications and tools.
-
Automated Continuous Toggl Replication to MongoDB
Use CData Sync for automated, continuous, customizable Toggl replication to MongoDB.
-
Visualize Live ConstantContact Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ConstantContact data.
-
Integrating GitHub Copilot with Qualaroo 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.
-
Working with PayPal Data in LINQPad
Execute LINQ queries to PayPal data in LINQPad.
-
Natively Connect to ServiceNow Data in PHP
The CData ODBC driver for ServiceNow enables you to create PHP applications with connectivity to ServiceNow data. Leverage the native support for ODBC in PHP.
-
How to Connect DBeaver to Klaviyo via a JDBC Driver
Manage Klaviyo data with visual tools in DBeaver like the query browser.
-
Integrate Goose with Live Perplexity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Perplexity data from within the local AI agent.
-
Getting Started with the CData Excel Add-In for Sybase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sybase.
-
How to connect Amazon QuickSight to Google Search Results
Create a connection to Google Search results in CData Connect AI and insert Google Search results into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Redis Replication to MySQL
Use CData Sync for automated, continuous, customizable Redis replication to MySQL.
-
Use the CData Software ODBC Driver for SuiteCRM in SAS for Real-Time Reporting and Analytics
Connect to real-time SuiteCRM data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SuiteCRM.
-
Use the CData Software ODBC Driver for Clockify in MicroStrategy
Connect to Clockify data in MicroStrategy Developer using the CData Software ODBC Driver for Clockify.
-
Automated Continuous Procore Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Procore replication to delimited files (CSV/TSV).
-
Build ZohoInvoice Visualizations in Tableau Cloud
Use CData Connect AI to connect to live ZohoInvoice data and build visualizations in Tableau Cloud.
-
How to create Google Search federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Search results in MySQL .
-
Integrate with Wrike Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Wrike data to a JSON file on disk.
-
How to Connect to Live Spark 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 Spark data for you.
-
How to connect to Clockify Data from Spring Boot
Connect to Clockify in a Spring Boot Application using the CData API Driver for JDBC
-
Access Oracle Eloqua Data from MySQL in Amazon QuickSight
Connect to Oracle Eloqua and build visualizations of Oracle Eloqua data using a MySQL Connection in Amazon QuickSight.
-
Create ActiveCampaign-Connected Dashboards in Grafana
Connect to ActiveCampaign Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ActiveCampaign data.
-
How to Connect to Live SQL Server Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your SQL Server data for you.
-
How to Connect to Live Google Directory 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 Google Directory data for you.
-
How to Access Live Phoenix Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Phoenix enables you to integrate Phoenix data into workflows built using Microsoft Power Automate Desktop.
-
Connect to OpenWeatherMap from a Connection Pool in WebLogic
Use the CData JDBC Driver for OpenWeatherMap to connect to OpenWeatherMap data from Web applications running on WebLogic.
-
Establish a Live Connection with Productboard Data using Tableau Bridge
The CData ODBC Driver for Productboard enables you to integrate live Productboard data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect Mailjet to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mailjet with IBM WebSphere for seamless data integration and connectivity.
-
Build Facebook Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Facebook data and build visualizations in Tableau Cloud.
-
View Reports on Real-Time Oracle Sales Data in Power BI Report Server
Use the CData ODBC Driver for Oracle Sales to visualize Oracle Sales data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to ZeroBounce Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ZeroBounce and work with ZeroBounce data in your FileMaker application.
-
Integrate Google's Vertex AI Agent with Live Dynamics CRM 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 Dynamics CRM data within intelligent workflows.
-
Query Cosmos DB Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Cosmos DB data from Node.js.
-
Integrating Gumloop with Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Entra ID data within automated workflows.
-
Integrate Theia IDE with Live Amazon Marketplace 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 Amazon Marketplace data from within the development environment.
-
Google Search Results Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Search results through CData Connect AI using different applications and tools.
-
Explore Geographical Relationships in Google Translate Data with Power Map
Create data visualizations with Google Translate data in Power Map.
-
Visualize NetSuite Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load NetSuite data into TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for Telegram
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Telegram.
-
Analyze Acumatica Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Acumatica data with the CData JDBC Driver for Acumatica.
-
Automated Zoho Creator Data Replication to Teradata
Use CData Sync to Customize and automate Zoho Creator data replication to Teradata.