CData Software - Knowledge Base
Recent Articles
-
Replicate Retently Data from PowerShell
Write a quick PowerShell script to query Retently data. Use connectivity to the live data to replicate Retently data to SQL Server.
-
Create Dynamics 365 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Dynamics 365 data access from reports, embedded analytics, and more.
-
How to load PabblySubscriptions data into Elasticsearch via Logstash
Introducing a simple method to load PabblySubscriptions data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build a PostgreSQL Interface for MariaDB Data using the CData JDBC Driver
Use the Remoting features of the MariaDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Outlook Replication to SingleStore
Use CData Sync for automated, continuous, customizable Outlook replication to SingleStore.
-
Work with Greenhouse Data in FoxPro
Load Greenhouse data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automate Toggl Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Toggl data from PowerShell? This article demonstrates how to utilize the Toggl Cmdlets for tasks like connecting to Toggl data, automating operations, downloading data, and more.
-
How to Connect to Live SQL Server 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 SQL Server data without replication.
-
Build Data Flows from Sentry to SQL Server using SSIS
Easily back up Sentry data to SQL Server using the SSIS components for Sentry.
-
Connect and Visualize Live YouTube Analytics Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live YouTube Analytics data into the Databricks platform and create visualization dashboards with real-time YouTube Analytics data.
-
Create Power BI Reports on Real-Time Webex Data
Use the CData ODBC Driver for Webex to visualize Webex data in Power BI Desktop.
-
Connect to Sugar CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sugar CRM to connect to Sugar CRM data from Web applications running on WebLogic.
-
Build SAP Fieldglass Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP Fieldglass data and build visualizations in Tableau.
-
Getting Started with the CData Excel Add-In for Sage Intacct
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sage Intacct.
-
Integrating Claude Code CLI with Attio 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 Live MailerLite 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 MailerLite data without replication.
-
Connect to Real-Time AlloyDB Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for AlloyDB and Dataflow to import and use AlloyDB data in Power Apps.
-
Build SAP Concur Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Concur data and build visualizations in Tableau Cloud.
-
Connect to Teamgate in SpagoBI
Create reports featuring live Teamgate data in SpagoBI Studio. Host Teamgate reports on SpagoBI Server.
-
Integrate Short.io with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Short.io with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Short.io data.
-
Connect to Real-Time Quickbase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Quickbase and Dataflow to import and use Quickbase data in Power Apps.
-
Integrating Cursor with Microsoft Dataverse 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.
-
Connect to ScrapingBee Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ScrapingBee to connect to ScrapingBee data and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for Snowflake in MicroStrategy
Connect to Snowflake data in MicroStrategy Developer using the CData Software ODBC Driver for Snowflake.
-
Visualize Live Sendwithus Data in the Power BI Service
Use CData Connect AI to connect to live Sendwithus data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live Salesforce CRM Analytics Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce CRM Analytics data from your Google Sheets.
-
Connect to Webflow Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Webflow data in the Denodo Virtual DataPort Administrator.
-
How to Connect Flowise AI Agents to Live Raisers Edge NXT Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Raisers Edge NXT data without replication.
-
Publish Reports with Mistral AI Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mistral AI data.
-
Integrating Dataiku with RSS Feeds via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live RSS feeds.
-
Getting Started with the CData ODBC Driver for Redshift
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Redshift.
-
Integrating Cursor with Klipfolio 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 Dify with Live MailerLite 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 MailerLite data.
-
Connect to Printify 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 Printify data.
-
Work with Smartsheet Data in FoxPro
Load Smartsheet data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Link ScrapingBee with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ScrapingBee data in Filemaker Pro for Mac or Windows.
-
How to create Aha! federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Aha! data in MySQL .
-
Integrate OpenCode with Live Freshservice Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Freshservice data from within your AI coding agent.
-
Use JayDeBeApi to access CSV Data in Python
Use standard Python scripting and the development environment of your choice to access live CSV data.
-
Access Live Dynamics 365 Business Central 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 Dynamics 365 Business Central data through MCP integration.
-
Connect to FreeAgent in SpagoBI
Create reports featuring live FreeAgent data in SpagoBI Studio. Host FreeAgent reports on SpagoBI Server.
-
Trigger Shopify IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Shopify with standard wizards in Logic Apps.
-
Create Apps from SAP ByDesign Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP ByDesign Data and build apps from live SAP ByDesign data in Qlik Sense Cloud.
-
Replicate Multiple Zoom Accounts
Replicate multiple Zoom accounts to one or many databases.
-
Automated Continuous Salesloft Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Salesloft replication to PostgreSQL.
-
Automated Continuous Tavily Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Tavily replication to Azure SQL Database.
-
How to Connect BigQuery 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 BigQuery data in real time using natural language.
-
Create Informatica Mappings From/To an ODBC Data Source for Dynamics CRM
Create an ODBC connection to Dynamics CRM in Informatica and browse and transfer Dynamics CRM data.
-
Visualize MailChimp Data in Tableau
The CData ODBC driver for MailChimp enables you integrate MailChimp data into Tableau dashboards.
-
Connect to Salesforce Marketing Data in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce Marketing in FileMaker Pro to connect to Salesforce Marketing and work with Salesforce Marketing data in your FileMaker applications.
-
Visualize Zoho Books Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoho Books data.
-
Use Manus AI to Talk to Your Oracle 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 Oracle data.
-
Automated Continuous Recurly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Recurly replication to Azure SQL Database.
-
Getting Started with the CData JDBC Driver for Google Directory
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Directory.
-
Build Charts with Aha! Data in Clear Analytics
Create dynamic charts and perform analytics based on Aha! data in Clear Analytics.
-
Connect to WordPress Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with WordPress Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect to Twilio Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Twilio data. Leverage the pyodbc module for ODBC in Python.
-
Build AI Agents with LinkedIn Ads Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live LinkedIn Ads data through CData Connect AI.
-
Integrate Devin with Live Oracle 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 Oracle data.
-
Integrating Claude Code CLI with Close 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.
-
DataBind Charts to Klaviyo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Klaviyo 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.
-
How to integrate QuickBooks Time with Apache Airflow
Access and process QuickBooks Time data in Apache Airflow using the CData JDBC Driver.
-
Build MailerLite Visualizations in Tableau Desktop
Use CData Connect AI to connect to live MailerLite data and build visualizations in Tableau.
-
Automated Continuous Redis Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Redis replication to Google Cloud SQL.
-
Connect to Asana Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Asana and the SQL Gateway to access Asana data from Google Apps Script.
-
Connect to MySQL Data in Jaspersoft Studio
Execute SQL to remote MySQL data in Jaspersoft Studio.
-
Integrate with Live SAP Concur Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP Concur from the MuleSoft Anypoint Platform to integrate live SAP Concur data into custom reports and dashboards.
-
Build Automated Bannerbear-Connected Workflows in Zapier
Use CData Connect AI to connect to live Bannerbear data and build automated workflows in Zapier.
-
Build Automated Workflows with Live SAP Concur Data in Workato
Use CData Connect AI to connect to live SAP Concur data and build automated workflows in Workato.
-
Integrating GitHub Copilot with Zoho Inventory 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.
-
Connect to Egnyte Data in DBeaver
Use the CData ODBC Driver to connect to Egnyte data in DBeaver.
-
Migrating data from Google Contacts to Databricks using CData SSIS Components.
Easily push Google Contacts data to Databricks using the CData SSIS Tasks for Google Contacts and Databricks.
-
Access Live Aweber Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Aweber data from your Excel spreadsheets.
-
Natively Connect to Dynamics NAV Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Dynamics NAV data. Leverage the native support for ODBC in PHP.
-
Query SAP Netweaver Gateway Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP Netweaver Gateway entities in PHP by modeling them as objects.
-
How to Connect to Live Freshdesk Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Freshdesk data securely in real time.
-
Automate Testmonitor Data Replication to Azure Data Lake
Use CData Sync to customize and automate Testmonitor data replication to Azure Data Lake.
-
Explore Geographical Relationships in Jira Data with Power Map
Create data visualizations with Jira data in Power Map.
-
How to connect and process MessageBird data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MessageBird data.
-
Stream SendGrid Data into Apache Kafka Topics
Access and stream SendGrid data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Easily Query Guru Data in OpenOffice Base
Connect to Guru data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Power BI Reports on Real-Time Sage 200 Data
Use the CData ODBC Driver for Sage 200 to visualize Sage 200 data in Power BI Desktop.
-
How to Connect to Live Salesforce Data 360 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 Salesforce Data 360 data for you.
-
Getting Started with the CData ADO.NET Provider for Email
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Email.
-
Access Salesforce Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Salesforce data.
-
How to create an RPA flow for BigCommerce Data in UiPath Studio
Use the BigCommerce ODBC Driver to create workflows that access real-time BigCommerce data without any coding.
-
Connect to Email Data in NetBeans
Connect to Email data in NetBeans with the data source configuration wizard.
-
Configure the CData JDBC Driver for Vault CRM in a Connection Pool in Tomcat
Connect to Vault CRM data from a connection pool in Tomcat.
-
Automated Continuous DB2 for i Replication to SingleStore
Use CData Sync for automated, continuous, customizable DB2 for i replication to SingleStore.
-
Integrating Codex with EnterpriseDB 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.
-
Getting Started with the CData JDBC Driver for Klipfolio
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Klipfolio.
-
Use the CData Software JDBC Driver for Placid in MicroStrategy Desktop
Connect to Placid data in MicroStrategy Desktop using the CData Software JDBC Driver for Placid.
-
Natively Connect to Zuora Data in PHP
The CData ODBC driver for Zuora enables you to create PHP applications with connectivity to Zuora data. Leverage the native support for ODBC in PHP.
-
How to Visualize Yelp 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 Yelp data in Python.
-
Create MYOB AccountRight Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MYOB AccountRight data access from reports, embedded analytics, and more.
-
Connecting Moonlit Workflow with Authorize.Net 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 Authorize.Net data in real time.
-
Edit and Search External Google Calendar Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Calendar data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Calendar Data objects that you can access from apps and the dashboard.
-
How to integrate MailerLite with Apache Airflow
Access and process MailerLite data in Apache Airflow using the CData JDBC Driver.
-
Connect to Sentry Data in DBeaver
Use the CData ODBC Driver to connect to Sentry data in DBeaver.
-
Analyze Cassandra Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Cassandra data and visualize Cassandra data in SAP Analytics Cloud.