CData Software - Knowledge Base
Recent Articles
-
Back Up Pingdom 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 Pingdom data data.
-
Integrate with Live BigQuery Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to BigQuery from the MuleSoft Anypoint Platform to integrate live BigQuery data into custom reports and dashboards.
-
How to connect to Google Forms Data in DBVisualizer
Integrate Google Forms data with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for Omnisend in MicroStrategy Web
Connect to Omnisend data in MicroStrategy Web using the CData Software ODBC Driver for Omnisend.
-
Access RabbitMQ Data from MySQL in Amazon QuickSight
Connect to RabbitMQ and build visualizations of RabbitMQ data using a MySQL Connection in Amazon QuickSight.
-
Access Live Bullhorn CRM Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Bullhorn CRM data through MCP integration.
-
Build Pipelines with Live Marketo Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Marketo from Google Cloud Data Fusion, enabling the integration of live Marketo data into the building and management of effective data pipelines.
-
Publish Telegram-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Telegram data.
-
How to Connect to Live Sybase IQ 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 Sybase IQ data for you.
-
Connect to ActiveCampaign Data in NetBeans
Connect to ActiveCampaign data in NetBeans with the data source configuration wizard.
-
How to Work with CircleCI Data in AWS Glue Jobs Using JDBC
Connect to CircleCI from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to create Humanity federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Humanity data in MySQL .
-
Using the CData Software ODBC Driver for LaunchDarkly in PyCharm
Connect to LaunchDarkly as an ODBC data source in PyCharm using the CData Software ODBC Driver for LaunchDarkly.
-
Visualize GitLab Data in Sisense
Create an ElastiCube in Sisense app with access to GitLab data.
-
Integrate Live Power BI XMLA Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Power BI XMLA data to Blue Prism using the CData ODBC Driver for Power BI XMLA to create automated workflows for repetitive business tasks.
-
Automated Continuous PabblySubscriptions Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Apache Kafka.
-
Connect to Amazon Athena Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Amazon Athena data in Airbyte.
-
Connect to Zoho Projects Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Zoho Projects.
-
Integrating Kiro with SingleStore 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 Access Live ActiveCampaign Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ActiveCampaign enables you to integrate ActiveCampaign data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Printify Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Printify data in Airbyte.
-
Integrating LangChain with Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Dynamics 365 data within automated workflows.
-
Create FTP-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to FTP Data from Klipfolio and build custom visualizations using live FTP data.
-
Automated Continuous Pushbullet Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Pushbullet replication to Apache Cassandra.
-
Automated Continuous ZohoDesk Replication to SQLite
Use CData Sync for automated, continuous, customizable ZohoDesk replication to SQLite.
-
Connect to Raisers Edge NXT Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Raisers Edge NXT.
-
Connect to Onfleet Data from a Connection Pool in Jetty
The Onfleet JDBC Driver supports connection pooling: This article shows how to connect faster to Onfleet data from Web apps in Jetty.
-
Build Apps with Live Zoho Creator Data Using the Low-Code Development Platform of Mendix
Connect Zoho Creator data with Mendix to build apps using the CData JDBC Driver for Zoho Creator.
-
Use the CData Software ODBC Driver for Oracle HCM Cloud in MicroStrategy
Connect to Oracle HCM Cloud data in MicroStrategy Developer using the CData Software ODBC Driver for Oracle HCM Cloud.
-
Automated Continuous HDFS Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable HDFS replication to Azure SQL Database.
-
Integrate with Notion Data in JReport Designer
Create charts and reports based on Notion data in JReport Designer.
-
How to Connect to Live VWO 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 VWO data for you.
-
Add SAP Fieldglass Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Fieldglass with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use ChatGPT to Talk to Your Toggl Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Toggl data for you.
-
Automated Continuous Trello Replication to MySQL
Use CData Sync for automated, continuous, customizable Trello replication to MySQL.
-
How to Build an ETL App for Raisers Edge NXT Data in Python with CData Connect AI
Extract and transform live Raisers Edge NXT data in Python with petl and the CData Connect AI Python SDK.
-
How to integrate Metabase with CapsuleCRM Data
Use CData Connect AI to connect to live CapsuleCRM data and create an interactive dashboard in Metabase from CapsuleCRM data.
-
Integrate Theia IDE with Live Microsoft Teams 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 Microsoft Teams data from within the development environment.
-
Connect to Notion Data from AWS Glue
Use CData Connect AI to gain access to live Notion data from your AWS Glue jobs.
-
Integrate Trae with Live Freshdesk Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Freshdesk data from within the AI-powered IDE.
-
Replicate Multiple Spark Accounts
Replicate multiple Spark accounts to one or many databases.
-
How to work with Supabase Data in Apache Spark using SQL
Access and process Supabase Data in Apache Spark using the CData Software JDBC Driver.
-
Choosing the Best Method to Connect Pushbullet to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pushbullet data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Claude Code with Adobe Experience Manager Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Adobe Experience Manager data within assisted coding and automated development workflows.
-
Enable the Bitly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Bitly data.
-
Connect to GitLab Data in ACL Analytics
Connect to GitLab data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to GitLab data.
-
Integrate Google's Antigravity Agent with Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Dynamics CRM data using the Model Context Protocol.
-
Use Biml to Build SSIS Tasks to Replicate Dynamics 365 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Dynamics 365 data to SQL Server.
-
How to Connect to Live xBase Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live xBase data without replication.
-
Create Informatica Mappings From/To an ODBC Data Source for PolarTeamPro
Create an ODBC connection to PolarTeamPro in Informatica and browse and transfer PolarTeamPro data.
-
Connect to Salesforce Data 360 Data in HULFT Integrate
Connect to Salesforce Data 360 as a JDBC data source in HULFT Integrate
-
Connect to Google Translate Data in RazorSQL
Connect to Google Translate from wizards and query Google Translate data from the GUI in the RazorSQL database management tool.
-
Prepare, Blend, and Analyze Avaza Data in Alteryx Designer (ODBC)
Build workflows to access live Avaza data for self-service data analytics.
-
Integrate with MailerLite Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MailerLite data to a JSON file on disk.
-
Consume Dynamics 365 Business Central OData Feeds in PowerBuilder
This article demonstrates how to consume Dynamics 365 Business Central data as OData feeds from PowerBuilder using the API Server.
-
Access Live SparkPost Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SparkPost data from your Excel spreadsheets.
-
Build Oracle Eloqua-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle Eloqua Data from Zoho Analytics and import live Oracle Eloqua data.
-
Build Dashboards with Coda Data in Dundas BI
Create dynamic dashboards and perform analytics based on Coda data in Dundas BI.
-
Connect to Amazon S3 in SpagoBI
Create reports featuring live Amazon S3 data in SpagoBI Studio. Host Amazon S3 reports on SpagoBI Server.
-
Use the CData Software JDBC Driver for RSS in MicroStrategy
Connect to RSS feeds in MicroStrategy Developer using the CData Software JDBC Driver for RSS.
-
Use Databricks Agent Bricks to Talk to Your BigQuery Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your BigQuery data for you.
-
How to Connect to Mixpanel Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mixpanel data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Missive Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Missive data replication to OneLake in Microsoft Fabric.
-
Deploy the ADO.NET Provider for Apollo on an SSRS Report Server
Connect to Apollo 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.
-
Import Real-Time Oracle SCM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle SCM data in ColdFusion.
-
Use ChatGPT to Talk to Your Shippo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Shippo data for you.
-
How to Connect to Live Testmonitor 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 Testmonitor data for you.
-
Connect to YouTube Analytics Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live YouTube Analytics data from Filemaker Pro on Mac.
-
How to use SQLAlchemy ORM to access Epicor Kinetic Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Epicor Kinetic data.
-
Connect to Cloudflare Data in Aqua Data Studio
Access Cloudflare data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Jumpseller Data in Tableau
The CData ODBC driver for Jumpseller enables you integrate Jumpseller data into Tableau dashboards.
-
Replicate Billsby Data to Multiple Databases
Replicate Billsby data to disparate databases with a point-and-click configuration.
-
Integrate Missive Data in Pentaho Data Integration
Build ETL pipelines based on Missive data in the Pentaho Data Integration tool.
-
Create Informatica Mappings From/To an ODBC Data Source for WooCommerce
Create an ODBC connection to WooCommerce in Informatica and browse and transfer WooCommerce data.
-
Using the CData Software ODBC Driver for Omnisend in PyCharm
Connect to Omnisend as an ODBC data source in PyCharm using the CData Software ODBC Driver for Omnisend.
-
Use the CData Software ODBC Driver for MailerSend in MicroStrategy Web
Connect to MailerSend data in MicroStrategy Web using the CData Software ODBC Driver for MailerSend.
-
Integrating OpenCode with Pipeline CRM 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.
-
Build MVC Applications with Connectivity to Jira Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Jira from an ASP.NET MVC application.
-
Analyze HDFS Data in Cognos Analytics
Use CData Connect AI to connect to HDFS Data from Cognos Analytics and analyze live HDFS data.
-
Integrate JobNimbus Data in the Pentaho Report Designer
Publish reports based on JobNimbus data in the Pentaho BI tool.
-
Build an OLAP Cube in SSAS from Azure Synapse Data
Establish a connection to Azure Synapse data data from SQL Server Analysis Services, and use the Azure Synapse Data Provider to build OLAP cubes for use in analytics and reporting.
-
Validate Oracle HCM Cloud Data with QuerySurge
Access and validate Oracle HCM Cloud data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Nethunt Replication to SQLite
Use CData Sync for automated, continuous, customizable Nethunt replication to SQLite.
-
How to Connect to Live Acumatica 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 Acumatica data for you.
-
Access Live Oracle Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Oracle data from your Excel spreadsheets.
-
Automated Continuous SurveyMonkey Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Amazon Redshift.
-
Connect Mixpanel to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Mixpanel data using the CData Python MCP Server.
-
Connect to MailerSend from Asprova with CData Software ODBC Driver for MailerSend
This article shows how to connect faster to MailerSend data from Asprova.
-
Access Live Mistral AI Data in Coginiti Pro
Connect to and query live Mistral AI data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to PabblySubscriptions Data in RazorSQL
Connect to PabblySubscriptions from wizards and query PabblySubscriptions data from the GUI in the RazorSQL database management tool.
-
How to Connect to & Open Gong Data in Microsoft Excel
This article uses the CData ODBC driver for Gong to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData Excel Add-In for Adobe Commerce
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Adobe Commerce.
-
Integrating Dataiku with JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live JSON services.
-
Replicate Datadog Data from PowerShell
Write a quick PowerShell script to query Datadog data. Use connectivity to the live data to replicate Datadog data to SQL Server.
-
Interact with Live SQL Analysis Services Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SQL Analysis Services data.
-
Automated Continuous Jira Assets Replication to MySQL
Use CData Sync for automated, continuous, customizable Jira Assets replication to MySQL.
-
Visualize Bannerbear Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Bannerbear data.
-
Build Dashboards with Google Sheets Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Sheets data in Dundas BI.
-
Integrating GitHub Copilot with Reckon 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 JayDeBeApi to access Postmark Data in Python
Use standard Python scripting and the development environment of your choice to access live Postmark data.