CData Software - Knowledge Base
Recent Articles
-
How to Query Discord Data in MySQL Workbench
Execute MySQL queries against live Discord data from MySQL Workbench.
-
How to Connect to Live Excel Online 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 Excel Online data for you.
-
Automated Continuous IBM Cloud Object Storage Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to PostgreSQL.
-
Access Live BigQuery Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live BigQuery data from your Excel spreadsheets.
-
Dynamically Retrieve Data Based on Cell Values with the CData Excel Add-in: CData Excel Formulas
Learn how to use the CData Excel Add-in and CData Excel Formulas to dynamically retrieve and refresh live cloud data in Excel using SQL queries.
-
Publish Dotmailer-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Dotmailer data.
-
Connecting Moonlit Workflow with Salesforce CRM Analytics 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 Salesforce CRM Analytics data in real time.
-
Building Dynamic Web Pages with SendGrid Data Using AngularJS
Create single-page applications with live connectivity to SendGrid using the CData API Server.
-
How to Connect to Live BigQuery 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 BigQuery data for you.
-
How to create an RPA flow for Postmark Data in UiPath Studio
Use the Postmark ODBC Driver to create workflows that access real-time Postmark data without any coding.
-
Replicate Microsoft Planner Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Planner data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect to Blackbaud FE NXT Data in DBVisualizer
Integrate Blackbaud FE NXT data with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Nuclia Data from PowerShell
Write a quick PowerShell script to query Nuclia data. Use connectivity to the live data to replicate Nuclia data to SQL Server.
-
Create Informatica Mappings From/To an ODBC Data Source for Missive
Create an ODBC connection to Missive in Informatica and browse and transfer Missive data.
-
Integrate with Google Ads Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Ads data to a JSON file on disk.
-
Connect to PDFMonkey Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PDFMonkey and the SQL Gateway to access PDFMonkey data from Google Apps Script.
-
Integrate with Authorize.Net Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Authorize.Net data in SnapLogic.
-
Connecting Agentforce with GetResponse Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your GetResponse data for you.
-
Working with Onfleet Data in LINQPad
Execute LINQ queries to Onfleet data in LINQPad.
-
Migrating data from Customer.io to Databricks using CData SSIS Components.
Easily push Customer.io data to Databricks using the CData SSIS Tasks for Customer.io and Databricks.
-
How to connect to Avaza Data with Squirrel SQL client
Connect to Avaza data and execute queries in the Squirrel SQL Client.
-
Migrating data from Todoist to Snowflake using CData SSIS Components.
Easily push Todoist data to Snowflake using the CData SSIS Tasks for Todoist and Snowflake.
-
Analyze SAP Business One Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP Business One data and visualize SAP Business One data in SAP Analytics Cloud.
-
Automated Continuous Excel Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Excel replication to Apache Cassandra.
-
Query SFTP Data in DataGrip
Create a Data Source for SFTP in DataGrip and use SQL to query live SFTP data.
-
Query Salesloft Data as a SQL Server Database in Node.js
Execute SQL Server queries against Salesloft data from Node.js.
-
Connecting Mastra with RSS Feeds via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time RSS feeds, no replication required.
-
Connect to Freshservice Data from Crystal Reports
Use CData Connect AI to connect to and report on live Freshservice data from Crystal Reports.
-
How to Work with HDFS Data in AWS Glue Jobs Using JDBC
Connect to HDFS from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to import HDFS Data into Apache Solr
Use the CData Software JDBC Driver for HDFS in Data Import Handler and create an automated import of HDFS data to Apache Solr Enterprise Search platform.
-
Integrate HDFS Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to HDFS data and integrate live HDFS data into your Power Automate tasks.
-
Getting Started with the CData Python Connector for Outlook
Learn to install and license the CData Python Connector and configure a connection to live Outlook data.
-
Replicate Multiple NetSuite SuiteAnalytics Accounts via the CData Sync CLI
Replicate multiple NetSuite SuiteAnalytics accounts to one or many databases.
-
How to Connect to Live Paymo 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 Paymo data for you.
-
Create Informatica Mappings From/To an ODBC Data Source for Outlook
Create an ODBC connection to Outlook in Informatica and browse and transfer Outlook data.
-
Use Biml to Build SSIS Tasks to Replicate FormSite Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate FormSite data to SQL Server.
-
Connect to TaxJar Data in CloverDX (formerly CloverETL)
Transfer TaxJar data using the visual workflow in the CloverDX data integration tool.
-
Connect to CSV Data in RazorSQL
Connect to CSV from wizards and query CSV data from the GUI in the RazorSQL database management tool.
-
Integrate Dify with Live Wave Financial 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 Wave Financial data.
-
Use Dash to Build to Web Apps on SAP HANA XS Advanced Data
Create Python applications that use pandas and Dash to build SAP HANA XS Advanced-connected web apps.
-
Connect to Salesforce Marketing Data from a Connection Pool in Jetty
The Salesforce Marketing JDBC Driver supports connection pooling: This article shows how to connect faster to Salesforce Marketing data from Web apps in Jetty.
-
Automate Webflow Data Replication to Couchbase
Use CData Sync to Customize and automate Webflow data replication to Couchbase.
-
Getting Started with the CData JDBC Driver for RabbitMQ
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for RabbitMQ.
-
Access Spotify Data from MySQL in Amazon QuickSight
Connect to Spotify and build visualizations of Spotify data using a MySQL Connection in Amazon QuickSight.
-
Bidirectional Access to AlloyDB Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate AlloyDB data in Filemaker Pro for Mac or Windows.
-
Build Semantic Layer Views for MySQL Data in APOS Live Data Gateway
Use the CData Connector for MySQL in APOS Live Data Gateway to build Semantic Layer Views for MySQL data.
-
How to create Visio diagrams from CockroachDB Data
Automatically update CockroachDB data with the changes you make to Visio master shapes.
-
Replicate Hive Data from PowerShell
Write a quick PowerShell script to query Hive data. Use connectivity to the live data to replicate Hive data to SQL Server.
-
Analyze HBase Data in Looker
Use CData Connect AI to connect to HBase Data from Looker and build custom apps using live HBase data.
-
Mode Reporting in OBIEE with the Mode JDBC Driver
Deploy the Mode JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Bitly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Bitly data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Creating YouTube Analytics-Connected Applications in Unqork
You can use CData Connect AI to feed YouTube Analytics data to Unqork and build custom business apps.
-
Connect to ZohoPeople Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ZohoPeople data using standard SQL.
-
How to Seamlessly Import Productboard Data into IBM SPSS Modeler
Integrate Productboard data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Moosend from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Moosend data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to create an RPA flow for Intercom Data in UiPath Studio
Use the Intercom ODBC Driver to create workflows that access real-time Intercom data without any coding.
-
Object-Relational Mapping (ORM) with MailerLite 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 MailerLite data into a Java-based ORM framework, Hibernate.
-
Automated Continuous AgileCRM Replication to SQLite
Use CData Sync for automated, continuous, customizable AgileCRM replication to SQLite.
-
Build AI/ML Models with Live Suadeo Data using Dataiku
Connect Suadeo Data with Dataiku using the CData JDBC Driver for Suadeo.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Printify
Provide connectivity to Printify data through an SAP BusinessObjects universe.
-
Analyze Dynamics CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Dynamics CRM from Power Pivot. You will use the Table Import Wizard to load Dynamics CRM data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Hugging Face Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Hugging Face replication to Google Cloud SQL.
-
Use Databricks Agent Bricks to Talk to Your SQL Analysis Services Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SQL Analysis Services data for you.
-
Query Live Shopify 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 Shopify data through a conversational interface.
-
Build ZohoMarketingHub-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ZohoMarketingHub Data from Zoho Analytics and import live ZohoMarketingHub data.
-
Build Dashboards with OpenWeatherMap Data in Dundas BI
Create dynamic dashboards and perform analytics based on OpenWeatherMap data in Dundas BI.
-
How to create Power BI XMLA federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Power BI XMLA data in MySQL .
-
Publish Crystal Reports on Mailgun Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Mailgun data.
-
Create Power BI Reports on Real-Time Reckon Data
Use the CData ODBC Driver for Reckon to visualize Reckon data in Power BI Desktop.
-
Build Cvent-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Cvent data and build Cvent-connected web apps with Axios.
-
Replicate Discord Data to Multiple Databases
Replicate Discord data to disparate databases with a point-and-click configuration.
-
Model, Search, and Visualize Live Testmonitor Data in ThoughtSpot
Use CData Connect AI to connect to live Testmonitor data for modeling, searching, and visualizing.
-
Connect to LaunchDarkly Data from a Connection Pool in JBoss
Integrate LaunchDarkly data into Java servlets: Use the Management Console in JBoss to install the LaunchDarkly JDBC Driver.
-
Integrate Real-Time Access to SAP BusinessObjects BI in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP BusinessObjects BI data in real time.
-
Access Live Sage Intacct 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 Sage Intacct data through MCP integration.
-
How to Create Power BI Visual Reports with Real-Time PingOne Data
Use CData Power BI Connectors to visualize PingOne data in Power BI.
-
DataBind Controls to Monday.com Data in Delphi
DataBind to Monday.com data in Delphi with standard data access components and controls.
-
Use Databricks Agent Bricks to Talk to Your Snowflake Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Snowflake data for you.
-
Connect to Paymo 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 Paymo and work with Paymo data in your FileMaker application.
-
Use Azure AI Foundry to Talk to Your Dynamics 365 Business Central 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 Dynamics 365 Business Central data for you.
-
Automated Amazon Marketplace Data Replication to Teradata
Use CData Sync to Customize and automate Amazon Marketplace data replication to Teradata.
-
How to connect to AgileCRM Data in DBVisualizer
Integrate AgileCRM data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to Smartsheet Data with Squirrel SQL client
Connect to Smartsheet data and execute queries in the Squirrel SQL Client.
-
Use Dash to Build to Web Apps on ZendeskSell Data
Create Python applications that use pandas and Dash to build ZendeskSell-connected web apps.
-
Bridge Freshservice Connectivity with Apache NiFi
Access and process Freshservice data in Apache NiFi using the CData JDBC Driver.
-
Use the CData ODBC Driver for Mailjet in Microsoft Power Query
You can use the CData Mailjet ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mailjet data into Microsoft Power Query.
-
How to Connect to Telegram Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Telegram data. Leverage the pyodbc module for ODBC in Python.
-
How to create an RPA flow for Microsoft Planner Data in UiPath Studio
Use the Microsoft Planner ODBC Driver to create workflows that access real-time Microsoft Planner data without any coding.
-
Natively Connect to ZohoExpense Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ZohoExpense data. Leverage the native support for ODBC in PHP.
-
Provide OData Services of Short.io Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Short.io data by developing a WCF Service Application.
-
Connect to Printify Data in CloverDX (formerly CloverETL)
Transfer Printify data using the visual workflow in the CloverDX data integration tool.
-
Build Visualizations of Instantly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Instantly data in Birst.
-
Import Square Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Square Data and provide access to live Square data for custom reports in the Power BI Service.
-
Getting Started with the CData SSIS Components for Google Tasks
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Tasks.
-
Automated Continuous Salesforce Pardot Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Google Cloud SQL.
-
Deploy the ADO.NET Provider for MongoDB on an SSRS Report Server
Connect to MongoDB 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.
-
Connect to Live SAP ByDesign Data in MicroStrategy through CData Connect AI
Create a live connection to SAP ByDesign Data in CData Connect AI and connect to your SAP ByDesign data from MicroStrategy.
-
Integrate ZarMoney Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZarMoney data from Informatica Cloud.
-
Integrate with SAP Concur Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Concur data in SnapLogic.
-
Getting Started with the CData Excel Add-In for Pingdom
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pingdom.