CData Software - Knowledge Base
Recent Articles
-
How to Access Live Bugsnag Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Bugsnag enables you to integrate Bugsnag data into workflows built using Microsoft Power Automate Desktop.
-
Publish Azure Table-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Azure Table data.
-
Analyze Oracle Eloqua Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle Eloqua data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Apps with Live Pushbullet Data Using the Low-Code Development Platform of Mendix
Connect Pushbullet data with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Paymo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Paymo with External Services.
-
Consume Hive OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Hive feeds that reflect any changes in SAP Lumira.
-
Analyze Pinecone Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Pinecone from Power Pivot. You will use the Table Import Wizard to load Pinecone data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Klaviyo Data from a Connection Pool in JBoss
Integrate Klaviyo data into Java servlets: Use the Management Console in JBoss to install the Klaviyo JDBC Driver.
-
How to Connect to Live WordPress 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 WordPress data for you.
-
Getting Started with the CData ADO.NET Provider for CloudConvert
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
CData SSIS Packages for Azure Data Factory
CData and Microsoft have partnered to make it easy to use CData SSIS Components within Azure Data Factory (ADF)
-
Create Dashboards and Visualize Live Bright Data Data in Geckoboard
Use CData Connect AI to connect to live Bright Data data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Visualize Live FreshBooks Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live FreshBooks data into custom reports in Power BI.
-
Configure the CData JDBC Driver for ScrapingBee in a Connection Pool in Tomcat
Connect to ScrapingBee data from a connection pool in Tomcat.
-
Design BIRT Reports on QuickBooks Data
Provide current QuickBooks data to your embedded analytics.
-
Automated Continuous Freshteam Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Freshteam data replication to OneLake in Microsoft Fabric.
-
Build Google Cloud Storage Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Cloud Storage data and build visualizations in Tableau.
-
Connect to Excel Online from a Connection Pool in WebLogic
Use the CData JDBC Driver for Excel Online to connect to Excel Online data from Web applications running on WebLogic.
-
Use Manus AI to Talk to Your eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on eBay data.
-
Connect to NetSuite Data in Jaspersoft Studio
Execute SQL to remote NetSuite data in Jaspersoft Studio.
-
Use Databricks Agent Bricks to Talk to Your Spark Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Spark data for you.
-
Connecting Moonlit Workflow with BambooHR 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 BambooHR data in real time.
-
Automate Gong Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Gong data from PowerShell? This article demonstrates how to utilize the Gong Cmdlets for tasks like connecting to Gong data, automating operations, downloading data, and more.
-
Getting Started with the CData Connect AI Python SDK for YouTube Analytics
Install the CData Connect AI Python SDK to read and write live YouTube Analytics data with standard DB-API 2.0 Python code.
-
Access Testmonitor Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Testmonitor data from HeidiSQL.
-
Integrate Open WebUI with Live Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Sage Cloud Accounting data from within the chat interface.
-
Build Charts with Flowlu Data in Clear Analytics
Create dynamic charts and perform analytics based on Flowlu data in Clear Analytics.
-
Automated Continuous Adobe Analytics Replication to SQL Server
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to SQL Server.
-
Integrate Open WebUI with Live Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Timely data from within the chat interface.
-
Query Live SQL Analysis Services Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live SQL Analysis Services data through a conversational interface.
-
Connect Samanage to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Samanage data using the CData Python MCP Server.
-
Use JayDeBeApi to access Accelo Data in Python
Use standard Python scripting and the development environment of your choice to access live Accelo data.
-
Automated Continuous Workday Replication to Databricks
Use CData Sync for automated, continuous, customizable Workday replication to Databricks.
-
Visualize Sage Cloud Accounting Data in Sisense
Create an ElastiCube in Sisense app with access to Sage Cloud Accounting data.
-
Integrate with ZendeskSell Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZendeskSell data to a JSON file on disk.
-
How to Work with Customer.io Data in ETL Validator JDBC
Connect to Customer.io from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Tally Replication to Oracle
Use CData Sync for automated, continuous, customizable Tally replication to Oracle.
-
Integrate Devin with Live SurveyMonkey Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SurveyMonkey data.
-
Create Informatica Mappings From/To an ODBC Data Source for Okta
Create an ODBC connection to Okta in Informatica and browse and transfer Okta data.
-
Replicate Multiple Nethunt Accounts
Replicate multiple Nethunt accounts to one or many databases.
-
Integrating LlamaIndex with xBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on xBase data in real time.
-
Build Aweber-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Aweber data and build web apps with connectivity to live Aweber data.
-
Connect to Sage Cloud Accounting Data from AWS Glue
Use CData Connect AI to gain access to live Sage Cloud Accounting data from your AWS Glue jobs.
-
Connect to Brex Data in RapidMiner
Integrate Brex data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Azure AI Foundry to Talk to Your Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Hive data for you.
-
Using the CData Software ODBC Driver for IBM Informix in PyCharm
Connect to IBM Informix as an ODBC data source in PyCharm using the CData Software ODBC Driver for IBM Informix.
-
CData API Server Overview
A detailed overview of CData API Server and its ability to create REST APIs for cloud and on-prem data.
-
Replicate Excel Online Data to Multiple Databases
Replicate Excel Online data to disparate databases with a point-and-click configuration.
-
Create Reports from Azure DevOps Data in Looker Studio
Use CData Connect AI to gain access to live Azure DevOps data and create custom reports in Looker Studio.
-
Getting Started with the CData Excel Add-In for Toggl
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Toggl.
-
Work with Calendly Data in FoxPro
Load Calendly data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect to Live Odoo Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Odoo data securely in real time.
-
Connect to Dropbox Data in ACL Analytics
Connect to Dropbox data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Dropbox data.
-
Automated Continuous Aha! Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Aha! replication to IBM DB2.
-
Automated Continuous AgileCRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable AgileCRM replication to Apache Cassandra.
-
How to connect and process Bitbucket data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Bitbucket data.
-
How to Connect to Live Google Spanner Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Spanner data securely in real time.
-
Add Pinterest Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Pinterest with the Informatica Enterprise Data Catalog to classify and organize data.
-
Replicate ConvertAPI Data from PowerShell
Write a quick PowerShell script to query ConvertAPI data. Use connectivity to the live data to replicate ConvertAPI data to SQL Server.
-
How to Build an ETL App for Salesforce Marketing Data in Python with CData Connect AI
Build ETL pipelines that read and write live Salesforce Marketing data in Python with petl and the CData Connect AI Python SDK.
-
Create Apps from Salesforce Pardot Data in Qlik Sense Cloud
Use CData Connect AI to connect to Salesforce Pardot Data and build apps from live Salesforce Pardot data in Qlik Sense Cloud.
-
How to Query Hugging Face Data in MySQL Workbench
Execute MySQL queries against live Hugging Face data from MySQL Workbench.
-
Create Informatica Mappings From/To a JDBC Data Source for Spotify
Create Spotify data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Claude Code with Shopify Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Shopify data within assisted coding and automated development workflows.
-
Visualize Live CouchDB Data in the Power BI Service
Use CData Connect AI to connect to live CouchDB data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Validate Supabase Data with QuerySurge
Access and validate Supabase data in QuerySurge using the CData JDBC Driver.
-
Design BIRT Reports on Aircall Data
Provide current Aircall data to your embedded analytics.
-
Automated Continuous Marketo Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Marketo replication to Apache Kafka.
-
Automated Continuous BigCommerce Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable BigCommerce replication to Apache Kafka.
-
Integrate Live Authorize.Net Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Authorize.Net from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Authorize.Net data.
-
Build Jira Assets-Connected Apps in Choreo
Use CData Connect AI to connect to Jira Assets Data from Choreo and build custom apps using live Jira Assets data.
-
Automated Continuous ConvertKit Replication to SQL Server
Use CData Sync for automated, continuous, customizable ConvertKit replication to SQL Server.
-
How to connect and process Wistia data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Wistia data.
-
Build Dashboards with Vercel Data in Dundas BI
Create dynamic dashboards and perform analytics based on Vercel data in Dundas BI.
-
Create SSAS Tabular Models from Greenhouse Data
How to build a SQL Server Analysis Service Tabular Model from Greenhouse data using CData drivers.
-
Prepare, Blend, and Analyze Microsoft Entra ID Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Entra ID data for self-service data analytics.
-
Automated Continuous Monday.com Replication to SQLite
Use CData Sync for automated, continuous, customizable Monday.com replication to SQLite.
-
Back Up ServiceDesk Plus 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 ServiceDesk Plus data data.
-
Build AI/ML Models with Live Postmark Data using Dataiku
Connect Postmark Data with Dataiku using the CData API Driver for JDBC.
-
Build Dashboards with Avro Data in Dundas BI
Create dynamic dashboards and perform analytics based on Avro data in Dundas BI.
-
Provide OData Services of SAP Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP data by developing a WCF Service Application.
-
Automated Continuous Vercel Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Vercel replication to Google BigQuery.
-
Integrate Oracle with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle data.
-
Connecting Moonlit Workflow with Microsoft Entra ID 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 Microsoft Entra ID data in real time.
-
Create ADP-Connected Nintex Workflows
Use CData Connect AI to connect to ADP Data from Nintex Workflow Cloud and build custom workflows using live ADP data.
-
Integrating LangChain with Exa Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Exa data within automated workflows.
-
Use the CData ODBC Driver for Snapchat Ads in Microsoft Power Query
You can use the CData Snapchat Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Snapchat Ads data into Microsoft Power Query.
-
Connect to Opsgenie Data in RapidMiner
Integrate Opsgenie data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Claude to Talk to Your ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your ZohoExpense data for you.
-
Feed Mixpanel Data into FineReport
How to set Mixpanel data as a JDBC data source in FineReport.
-
Add Mixpanel Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Mixpanel with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Pushbullet Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Pushbullet replication to AlloyDB.
-
Analyze Tally Data in Looker
Use CData Connect AI to connect to Tally Data from Looker and build custom apps using live Tally data.
-
Connect to Auth0 from Asprova with CData Software ODBC Driver for Auth0
This article shows how to connect faster to Auth0 data from Asprova.
-
Build Dashboards with Azure Synapse Data in Dundas BI
Create dynamic dashboards and perform analytics based on Azure Synapse data in Dundas BI.
-
Moving Data from SQL Analysis Services to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SQL Analysis Services data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with Zoho Books Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zoho Books data to a JSON file on disk.
-
Use the CData Software JDBC Driver for Notion in MicroStrategy Desktop
Connect to Notion data in MicroStrategy Desktop using the CData Software JDBC Driver for Notion.
-
Integrate Live Asana Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Asana from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Asana data.
-
Rapidly Develop Calendly-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 Calendly.