CData Software - Knowledge Base
Recent Articles
-
Connect to ADP Data from a Connection Pool in JBoss
Integrate ADP into Java servlets: Use the Management Console in JBoss to install the ADP JDBC Driver.
-
Connect to Yelp Data from PowerBuilder via JDBC
This article demonstrates how to access Yelp from PowerBuilder using the Yelp JDBC Driver.
-
Access Dynamics 365 Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dynamics 365 from HeidiSQL.
-
Build Apps with Live Dynamics CRM Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Dynamics CRM with Mendix to build apps using the CData JDBC Driver for Dynamics CRM.
-
Visualize Live Bright Data Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Bright Data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Query Mailjet Data in MySQL Workbench
Execute MySQL queries against live Mailjet from MySQL Workbench.
-
Access Oracle Service Cloud Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle Service Cloud from HeidiSQL.
-
Integrating Kiro CLI with REST 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 Visualize Excel Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Excel in Python.
-
Access Vault CRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Veeva Vault & Vault CRM from your Oracle system.
-
Connect to Redshift Data in Jaspersoft Studio
Execute SQL to remote Amazon Redshift in Jaspersoft Studio.
-
DataBind Charts to Retently Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Retently 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.
-
Replicate Retently Data from PowerShell
Write a quick PowerShell script to query Retently. Use connectivity to the live data to replicate Retently 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.
-
Work with Greenhouse Data in FoxPro
Load Greenhouse 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 from PowerShell? This article demonstrates how to utilize the Toggl Cmdlets for tasks like connecting to Toggl, automating operations, downloading data, and more.
-
How to Connect to Live SQL Server Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Microsoft SQL Server without replication.
-
Build Data Flows from Sentry to SQL Server using SSIS
Easily back up Sentry 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 into the Databricks platform and create visualization dashboards with real-time YouTube Analytics.
-
Create Power BI Reports on Real-Time Webex Data
Use the CData ODBC Driver for Webex to visualize Webex 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 from Web applications running on WebLogic.
-
Build SAP Fieldglass Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP Fieldglass 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.
-
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 Google AlloyDB in Power Apps.
-
Build SAP Concur Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Concur and build visualizations in Tableau Cloud.
-
Connect to Teamgate in SpagoBI
Create reports featuring live Teamgate 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.
-
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 in Power Apps.
-
Integrating Cursor CLI 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 and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for Snowflake in MicroStrategy
Connect to Snowflake in MicroStrategy Developer using the CData Software ODBC Driver for Snowflake.
-
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 from your Google Sheets.
-
Connect to Webflow Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Webflow 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 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.
-
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 CLI 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.
-
Work with Smartsheet Data in FoxPro
Load Smartsheet into a FoxPro database. This article includes full code and a walk-through of the process.
-
Bidirectional Access to ScrapingBee Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ScrapingBee 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! in MySQL .
-
Use JayDeBeApi to access CSV Data in Python
Use standard Python scripting and the development environment of your choice to access live CSV/TSV Files.
-
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 through MCP integration.
-
Connect to FreeAgent in SpagoBI
Create reports featuring live FreeAgent 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 Business ByDesign 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.
-
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 Microsoft Dynamics CRM.
-
Visualize MailChimp Data in Tableau
The CData ODBC driver for MailChimp enables you integrate MailChimp 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 Cloud in your FileMaker applications.
-
Visualize Zoho Books Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoho Books.
-
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 Database.
-
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! 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. 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 through CData Connect AI.
-
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 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 in Apache Airflow using the CData JDBC Driver.
-
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 from Google Apps Script.
-
Connect to MySQL Data in Jaspersoft Studio
Execute SQL to remote MySQL 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 into custom reports and dashboards.
-
Build Automated Workflows with Live SAP Concur Data in Workato
Use CData Connect AI to connect to live SAP Concur and build automated workflows in Workato.
-
Integrating GitHub Copilot CLI with Zoho Inventory 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 in DBeaver.
-
How to Access Live Excel Data in Visual Studio Code via Cline
Run CData MCP Server for Excel on Windows Subsytem for Linux (WSL) and connect to live Microsoft Excel from the Cline extension in Visual Studio Code.
-
Migrating data from Google Contacts to Databricks using CData SSIS Components.
Easily push Google Contacts to Databricks using the CData SSIS Tasks for Google Contacts and Databricks.
-
Natively Connect to Dynamics NAV Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Dynamics NAV. 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 securely in real time.
-
Automate Testmonitor Data Replication to Azure Data Lake
Use CData Sync to customize and automate Testmonitor replication to Azure Data Lake.
-
Explore Geographical Relationships in Jira Data with Power Map
Create data visualizations with Atlassian Jira in Power Map.
-
How to Import Data from REST into Google Sheets
Import REST into a Google spreadsheet that is automatically refreshed.
-
How to connect and process MessageBird from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MessageBird.
-
Stream SendGrid Data into Apache Kafka Topics
Access and stream SendGrid 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 in Power BI Desktop.
-
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 & Force.com.
-
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 without any coding.
-
Connect to Email Data in NetBeans
Connect to Email in NetBeans with the data source configuration wizard.
-
Configure the CData JDBC Driver for Vault CRM in a Connection Pool in Tomcat
Connect to Veeva Vault & Vault CRM 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 CLI with EnterpriseDB 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 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. Leverage the native support for ODBC in PHP.
-
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 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 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 in Apache Airflow using the CData JDBC Driver.
-
Connect to Sentry Data in DBeaver
Use the CData ODBC Driver to connect to Sentry in DBeaver.
-
Analyze Cassandra Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Apache Cassandra and visualize Apache Cassandra in SAP Analytics Cloud.