CData Software - Knowledge Base
Recent Articles
-
Integrate Sybase Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Sybase from Informatica Cloud.
-
Build Azure Synapse-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Azure Synapse to explore live Azure Synapse Data in Gemini Code Assist to assist with building Azure Synapse-powered applications.
-
Getting Started with the CData ODBC Driver for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Adobe Analytics.
-
How to Connect to & Open Zuora Data in Microsoft Excel
This article uses the CData ODBC driver for Zuora to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData SSIS Components to Insert New or Update Existing Google Spanner Records from SQL Server
Easily push SQL Server data to Google Spanner using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Spanner or update existing records with data from a SQL Server database.
-
Query SAP Netweaver Gateway Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Netweaver Gateway from Node.js.
-
Natively Connect to Drift Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Drift. Leverage the native support for ODBC in PHP.
-
Integrating Gumloop with Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Jira Assets within automated workflows.
-
How to create CSV federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for CSV/TSV Files in MySQL .
-
Import Real-Time Datadog Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Datadog in ColdFusion.
-
Build eBay Analytics-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for eBay Analytics to explore live eBay Analytics Data in Claude Code to assist with building eBay Analytics-powered applications.
-
How to Query Live ZarMoney Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZarMoney data in natural language using Python.
-
Build an OLAP Cube in SSAS from Retently Data
Establish a connection to Retently data from SQL Server Analysis Services, and use the Retently Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build AI/ML Models with Live Unbounce Data using Dataiku
Connect Unbounce Data with Dataiku using the CData API Driver for JDBC.
-
Use ChatGPT to Talk to Your Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Tally ERP for you.
-
Connect to MailerSend Data in JRuby
Create a simple JRuby app with access to live MailerSend.
-
Automated Continuous LionDesk Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LionDesk replication to Amazon S3.
-
Visualize Outlook Data in TIBCO Spotfire through ADO.NET
Integrate Outlook into dashboards in TIBCO Spotfire.
-
Getting Started with the CData ADO.NET Provider for Aweber
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build Dashboards with QuickBooks Data in DBxtra
Create dynamic dashboards and perform analytics based on QuickBooks Desktop in DBxtra.
-
Add Wave Financial Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Wave Financial with the Informatica Enterprise Data Catalog to classify and organize data.
-
Bridge MessageBird Connectivity with Apache NiFi
Access and process MessageBird in Apache NiFi using the CData JDBC Driver.
-
Access Azure DevOps Data from MySQL in PHP
Connect to Azure DevOps through the standard MySQL libraries in PHP.
-
Extract, Transform, and Load OnePageCrm Data in Informatica PowerCenter
Create a simple Workflow for OnePageCrm in Informatica PowerCenter.
-
How to update HubDB from Excel
This article explains how to transfer data from Excel to HubDB using the Excel Add-In for HubDB.
-
DataBind Charts to Optimizely Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Optimizely 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.
-
Publish Crystal Reports on HubSpot Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date HubSpot.
-
Integrating GitHub Copilot CLI with LDAP 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 Telegram Data in Aqua Data Studio
Access Telegram from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Adobe Commerce with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Adobe Commerce with External Services.
-
How to Connect to Live Vertica 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 Vertica for you.
-
Moving Data from Sage 300 to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Sage 300 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Attio Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Attio in the Denodo Virtual DataPort Administrator.
-
Connect to Vault CRM Data in HULFT Integrate
Connect to Vault CRM as a JDBC data source in HULFT Integrate
-
Getting Started with the CData JDBC Driver for Reply.io
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Reply.io.
-
How to Connect the Power BI Service to eBay: Complete Guide
Connect to the CData Software Power BI Connector for eBay from PowerBI.com to provide real-time eBay across the organization.
-
Use the CData ODBC Driver for Campaigner from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Campaigner to connect to Campaigner from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Campaigner in Excel.
-
Query Salesforce Data 360 Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Salesforce Data 360 from Node.js.
-
Build MongoDB-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for MongoDB to explore live MongoDB Data in Gemini Code Assist to assist with building MongoDB-powered applications.
-
Connect to SAP Concur Data in HULFT Integrate
Connect to SAP Concur as a JDBC data source in HULFT Integrate
-
Automate YouTube Analytics Data Replication to Azure Synapse
Use CData Sync to customize and automate YouTube Analytics replication to Azure Synapse.
-
Visualize Slack Data in TIBCO Spotfire through OData
Integrate Slack into dashboards in TIBCO Spotfire.
-
Configure the CData JDBC Driver for Avaza in a Connection Pool in Tomcat
Connect to Avaza from a connection pool in Tomcat.
-
Getting Started with the CData JDBC Driver for Printful
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Printful.
-
Integrate MailChimp Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MailChimp from Informatica Cloud.
-
Connect and Query Live Lakebase Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Lakebase into Databricks
-
Use Microsoft Copilot Studio to talk to your Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Azure Data Lake Storage for you.
-
Automated Continuous Avalara AvaTax Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to OneLake in Microsoft Fabric.
-
Build an OLAP Cube in SSAS from Google Forms Data
Establish a connection to Google Forms data from SQL Server Analysis Services, and use the Google Forms Data Provider to build OLAP cubes for use in analytics and reporting.
-
Natively Connect to Mocean Data in PHP
The CData ODBC driver for Mocean enables you to create PHP applications with connectivity to Mocean. Leverage the native support for ODBC in PHP.
-
Connect Google Ad Manager to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Ad Manager using the CData Python MCP Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Eloqua Reporting
Provide connectivity to Oracle Eloqua Reporting through an SAP BusinessObjects universe.
-
Connect to SuiteCRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for SuiteCRM to connect to SuiteCRM from Web applications running on WebLogic.
-
Working with SAP Concur Data in LINQPad
Execute LINQ queries to SAP Concur in LINQPad.
-
How to use SQLAlchemy ORM to access Oracle Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Database.
-
Access Live Klaviyo Data in Excel 365 Online (Excel for the web)
Connect to Klaviyo from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build SendGrid-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SendGrid Data from Zoho Analytics and import live SendGrid.
-
Connect to DocuSign Data in CloverDX (formerly CloverETL)
Transfer DocuSign using the visual workflow in the CloverDX data integration tool.
-
Create Datasets from Google Calendar in Domo Workbench and Build Visualizations of Google Calendar Data in Domo
Use the CData Software ODBC Driver for Google Calendar to create datasets from Google Calendar in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to Greenhouse Data in DBVisualizer
Integrate Greenhouse with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Easily Query Adobe Commerce Data in OpenOffice Base
Connect to Adobe Commerce data in OpenOffice Base using the CData ODBC Driver for Adobe Commerce and generate reports with live data insights.
-
Build a PostgreSQL Interface for eBay Analytics Data using the CData JDBC Driver
Use the Remoting features of the eBay Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build AI/ML Models with Live ConstantContact Data using Dataiku
Connect ConstantContact Data with Dataiku using the CData API Driver for JDBC.
-
Connect to PayPal Data in Claris FileMaker Pro
Use the CData ODBC Driver for PayPal in FileMaker Pro to connect to PayPal and work with PayPal in your FileMaker applications.
-
Automate Sybase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sybase replication to Azure Data Lake.
-
Access Planio Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Planio from your Oracle system.
-
Connect to SAS xpt Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAS XPORT in Google Apps Script.
-
Connect to SendPulse Data in RazorSQL
Connect to SendPulse from wizards and query SendPulse from the GUI in the RazorSQL database management tool.
-
Integrate LibreChat with Live Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Office 365 from within the chat interface.
-
Access Live Pinterest Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Pinterest data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Migrating data from Cvent to Google BigQuery using CData SSIS Components.
Easily push Cvent to Google BigQuery using the CData SSIS Tasks for Cvent and Google BigQuery.
-
Establish a Live Connection with PayPal Data using Tableau Bridge
The CData ODBC Driver for PayPal enables you to integrate live PayPal into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Acumatica in SpagoBI
Create reports featuring live Acumatica ERP in SpagoBI Studio. Host Acumatica reports on SpagoBI Server.
-
Replicate Multiple Dotmailer Accounts
Replicate multiple Dotmailer accounts to one or many databases.
-
Connect to Greenhouse Data from Crystal Reports
Use CData Connect AI to connect to and report on live Greenhouse from Crystal Reports.
-
Connect to Vimeo Data in Aqua Data Studio
Access Vimeo from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Validate Postmark Data with QuerySurge
Access and validate Postmark in QuerySurge using the CData JDBC Driver.
-
Query, Visualize, and Share live HubSpot Data in Redash
Use CData Connect AI to connect to live HubSpot in Redash for querying, visualizing, and sharing.
-
Analyze HCL Domino Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of HCL Domino and visualize HCL Domino in SAP Analytics Cloud.
-
Access Live SparkPost Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SparkPost into the statistical analysis tools available in SAS JMP. This article shows how to use SparkPost in the Graph Builder and Query Builder.
-
Edit and Search Twitter Ads External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Twitter Ads to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Twitter Ads objects that you can access from apps and the dashboard.
-
Connect to FTP Data from Crystal Reports
Use CData Connect AI to connect to and report on live FTP Servers from Crystal Reports.
-
How to connect to Google Spanner Data with Squirrel SQL client
Connect to Google Spanner and execute queries in the Squirrel SQL Client.
-
Validate Teamwork Data with QuerySurge
Access and validate Teamwork in QuerySurge using the CData JDBC Driver.
-
DataBind Charts to Everhour Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Everhour 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.
-
Work with Demio Data in FoxPro
Load Demio into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Todoist Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Todoist replication to Apache Kafka.
-
How to Access Active Directory Data Using Entity Framework
This article shows how to access Active Directory using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Twilio Data in CloverDX (formerly CloverETL)
Transfer Twilio using the visual workflow in the CloverDX data integration tool.
-
Connecting Pipedream with IBM Informix Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on IBM Informix data in real time.
-
Connect to Vercel Data from PowerBuilder via JDBC
This article demonstrates how to access Vercel from PowerBuilder using the Vercel JDBC Driver.
-
Build Agents in Relevance AI with Access to Live Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Avalara AvaTax within intelligent agent workflows.
-
Import Real-Time Beeminder Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Beeminder in ColdFusion.
-
Excel Spreadsheet Automation on Snowflake Data with the QUERY Formula
Pull data from Snowflake, automate spreadsheets, and more with the QUERY formula.
-
Connecting Agentforce with Google Spanner 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 Google Spanner for you.
-
Integrate Office 365 Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Office 365 and integrate live Microsoft Office 365 into your Power Automate tasks.
-
How to connect PolyBase to QuickBooks
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live QuickBooks Desktop.
-
Access Live BambooHR Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to BambooHR from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Explore Geographical Relationships in Monday.com Data with Power Map
Create data visualizations with Monday.com in Power Map.
-
Migrating data from Amplitude to Databricks using CData SSIS Components.
Easily push Amplitude to Databricks using the CData SSIS Tasks for Amplitude and Databricks.