CData Software - Knowledge Base
Recent Articles
-
How to connect to Oracle Eloqua Data with Squirrel SQL client
Connect to Oracle Eloqua and execute queries in the Squirrel SQL Client.
-
Integrating LangChain with Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Blackbaud FE NXT within automated workflows.
-
Integrate Open WebUI with Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live CockroachDB from within the chat interface.
-
Use the CData Software ODBC Driver for ShipEngine in MicroStrategy Desktop
Connect to ShipEngine in MicroStrategy Desktop using the CData Software ODBC Driver for ShipEngine.
-
Replicate Smartsheet Data from PowerShell
Write a quick PowerShell script to query Smartsheet. Use connectivity to the live data to replicate Smartsheet to SQL Server.
-
Automated Continuous HelloSign Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable HelloSign replication to Google BigQuery.
-
How to Query Copper Data in MySQL Workbench
Execute MySQL queries against live Copper from MySQL Workbench.
-
Connect to Zoho CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Zoho CRM from Appeon PowerBuilder using the CData ADO.NET Provider for Zoho CRM.
-
Visualize Smartsheet Data in TIBCO Spotfire through ADO.NET
Integrate Smartsheet into dashboards in TIBCO Spotfire.
-
Integrating Antigravity CLI with Retently via CData CLI
Connect Retently to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Microsoft Ads Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Ads from PowerBuilder using the Microsoft Ads JDBC Driver.
-
Connect to and Visualize Live Zoho Creator Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoho Creator.
-
Connect to SAP Ariba Procurement Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Ariba Procurement from HeidiSQL.
-
Access PhantomBuster Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PhantomBuster from HeidiSQL.
-
Access Live Slack Data in Coginiti Pro
Connect to and query live Slack from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Visualizations of Square Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Square in Birst.
-
How to integrate MariaDB with Apache Airflow
Access and process MariaDB in Apache Airflow using the CData JDBC Driver.
-
Object-Relational Mapping (ORM) with Azure Synapse 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 Azure Synapse into a Java-based ORM framework, Hibernate.
-
Access Salesforce Data 360 Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Salesforce Data 360 from HeidiSQL.
-
Bidirectional Access to NASA Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate NASA in Filemaker Pro for Mac or Windows.
-
Query DB2 Data as a MySQL Database in Node.js
Execute MySQL queries against IBM DB2 from Node.js.
-
Building Dynamic Web Pages with Neo4J Data Using AngularJS
Create single-page applications with live connectivity to Neo4J using the CData API Server.
-
Working with SendInBlue Data in LINQPad
Execute LINQ queries to SendInBlue in LINQPad.
-
Write a Simple Go Application to work with Dynamics CRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Dynamics CRM.
-
How to Query RabbitMQ Data in MySQL Workbench
Execute MySQL queries against live RabbitMQ from MySQL Workbench.
-
Write a Simple Go Application to work with Box Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Box.
-
Integrate Theia IDE with Live SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Visualize Landbot Data in TIBCO Spotfire through ADO.NET
Integrate Landbot into dashboards in TIBCO Spotfire.
-
Access Live Acumatica Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Acumatica ERP from your Google Sheets.
-
Connect to Real-Time Aweber Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Aweber in Power Apps.
-
Connect to Close Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Close to connect to Close and execute queries in PowerBuilder.
-
Getting Started with the CData Python Connector for Google Cloud Storage
Learn to install and license the CData Python Connector
-
Use JayDeBeApi to access Unbounce Data in Python
Use standard Python scripting and the development environment of your choice to access live Unbounce.
-
Access Live Mode Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Mode in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Blackbaud FE NXT-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Blackbaud FE NXT to explore live Blackbaud FE NXT Data in Gemini Code Assist to assist with building Blackbaud FE NXT-powered applications.
-
How to create an RPA flow for BigQuery Data in UiPath Studio
Use the BigQuery ODBC Driver to create workflows that access real-time Google BigQuery without any coding.
-
Automated Continuous Everhour Replication to Oracle
Use CData Sync for automated, continuous, customizable Everhour replication to Oracle.
-
Build Automated Workflows with Live YouTube Analytics Data in Workato
Use CData Connect AI to connect to live YouTube Analytics and build automated workflows in Workato.
-
Automated Continuous Slack Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Slack replication to Apache Cassandra.
-
Automated Continuous ZohoInvoice Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Amazon Redshift.
-
How to Visualize PolarTeamPro Data in Python with pandas
Use pandas and other modules to analyze and visualize live PolarTeamPro in Python.
-
Replicate Workday Data from PowerShell
Write a quick PowerShell script to query Workday. Use connectivity to the live data to replicate Workday to SQL Server.
-
Connect to Amazon S3 Data in DBeaver
Use the CData ODBC Driver to connect to Amazon S3 in DBeaver.
-
Integrating Kiro CLI with Microsoft Teams 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 Agno to Talk to Your Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Salesforce Pardot for you.
-
Explore Geographical Relationships in ChargeOver Data with Power Map
Create data visualizations with ChargeOver in Power Map.
-
Work with Teamgate Data in FoxPro
Load Teamgate into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Live SendGrid Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SendGrid using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Microsoft Teams Data in CloverDX (formerly CloverETL)
Transfer Microsoft Teams using the visual workflow in the CloverDX data integration tool.
-
Analyze Vault CRM Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Veeva Vault & Vault CRM and visualize Veeva Vault & Vault CRM in SAP Analytics Cloud.
-
How to Query Live SAP Ariba Source Data in Claude Desktop
Connect to and query live SAP Ariba Source Data in Claude Desktop using CData MCP Server.
-
Integrating NASA Data in Talend Cloud Data Management Platform
Connect NASA Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize Impala Data in TIBCO Spotfire through ADO.NET
Integrate Apache Impala into dashboards in TIBCO Spotfire.
-
Use Azure AI Foundry to Talk to Your EnterpriseDB 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 EnterpriseDB for you.
-
How to Work with Webflow Data in ETL Validator JDBC
Connect to Webflow from ETL Validator jobs using the CData Software JDBC Driver.
-
Migrating data from Wave Financial to Databricks using CData SSIS Components.
Easily push Wave Financial to Databricks using the CData SSIS Tasks for Wave Financial and Databricks.
-
Excel Spreadsheet Automation on Google Campaign Manager 360 Data with the QUERY Formula
Pull data from Google Campaign Manager 360, automate spreadsheets, and more with the QUERY formula.
-
Query XML Data in ColdFusion
Write standard ColdFusion data access code to connect to XML Files.
-
How to update Email from Excel
This article explains how to transfer data from Excel to Email using the Excel Add-In for Email.
-
Import Real-Time Superchat Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Superchat in ColdFusion.
-
Working with Cassandra Data in LINQPad
Execute LINQ queries to Apache Cassandra in LINQPad.
-
Connect to BigCommerce Data in DBeaver
Use the CData ODBC Driver to connect to BigCommerce in DBeaver.
-
Creating Kintone-Connected Applications in Unqork
You can use CData Connect AI to feed Kintone to Unqork and build custom business apps.
-
Visualize SAP SuccessFactors LMS Data in TIBCO Spotfire through OData
Integrate SAP SuccessFactors LMS into dashboards in TIBCO Spotfire.
-
How to work with ServiceNow Data in Apache Spark using SQL
Access and process ServiceNow Data in Apache Spark using the CData Software JDBC Driver.
-
Use CData Connect AI to Access DB2 Data in Microsoft Power Pivot
Use CData Connect AI to connect to live IBM DB2 in the Power Pivot business intelligence tool.
-
Integrating Claude Code CLI with FreshBooks 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.
-
Back Up Campaigner 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 Campaigner data.
-
Replicate Discord Data in Heroku for Use in Salesforce Connect
Replicate Discord to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate with Calendly Data in JReport Designer
Create charts and reports based on Calendly in JReport Designer.
-
Automated Continuous SQL Server Replication to Oracle
Use CData Sync for automated, continuous, customizable SQL Server replication to Oracle.
-
SAP Ariba Source Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Ariba Source through CData Connect AI using different applications and tools.
-
Telegram Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Telegram facts in real time.
-
Build Apps with Live SharePoint Data Using the Low-Code Development Platform of Mendix
Connect Microsoft SharePoint with Mendix to build apps using the CData JDBC Driver for SharePoint.
-
Trigger Square IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Square with standard wizards in Logic Apps.
-
Bidirectional Access to Adobe Analytics Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Adobe Analytics in Filemaker Pro for Mac or Windows.
-
Visualize Redis Data in Tableau
The CData ODBC driver for Redis enables you integrate Redis into Tableau dashboards.
-
Integrating Claude Code CLI with SurveyMonkey 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.
-
A PostgreSQL Interface for Oracle Data using the CData ODBC Driver
Use the SQL Gateway and Oracle ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create SSAS Tabular Models from Active Directory Data
How to build a SQL Server Analysis Service Tabular Model from Active Directory using CData drivers.
-
Import Real-Time Greenplum Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Pivotal GreenPlum in ColdFusion.
-
Import Real-Time ClickUp Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ClickUp in ColdFusion.
-
Automated Continuous Everhour Replication to Databricks
Use CData Sync for automated, continuous, customizable Everhour replication to Databricks.
-
Use the CData Software ODBC Driver for Salesforce in MicroStrategy Desktop
Connect to Salesforce & Force.com in MicroStrategy Desktop using the CData Software ODBC Driver for Salesforce.
-
How to Work with Google Sheets Data in ETL Validator JDBC
Connect to Google Sheets from ETL Validator jobs using the CData Software JDBC Driver.
-
Query Typeform Data in ColdFusion
Write standard ColdFusion data access code to connect to Typeform.
-
Access Live GitHub 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 GitHub through MCP integration.
-
Publish AlloyDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google AlloyDB.
-
Use Agno to Talk to Your Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Act-On for you.
-
Process & Analyze Jumpseller Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Jumpseller Data.
-
Use the CData Software ODBC Driver for WordPress in SAS for Real-Time Reporting and Analytics
Connect to real-time WordPress in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for WordPress.
-
Integrate with Sugar CRM Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Sugar CRM in SnapLogic.
-
Integrate Azure Table Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Azure Table Storage from Informatica Cloud.
-
Connect to SendInBlue Data in HULFT Integrate
Connect to SendInBlue as a JDBC data source in HULFT Integrate
-
Access EnterpriseDB 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 EnterpriseDB.
-
Prepare, Blend, and Analyze Twitter Ads Data in Alteryx Designer (ODBC)
Build workflows to access live Twitter Ads for self-service data analytics.
-
How to connect PolyBase to Neo4J
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Neo4J.
-
Automate QuickBooks Data Replication to Couchbase
Use CData Sync to Customize and automate QuickBooks Desktop replication to Couchbase.
-
Query Google Spanner Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Spanner from Node.js.
-
DataBind Charts to Dynamics CRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Dynamics CRM 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.