CData Software - Knowledge Base
Recent Articles
-
Access Live Adobe Analytics Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Adobe Analytics in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating GitHub Copilot CLI with ConvertKit 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 Dropbox Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Dropbox and the SQL Gateway to access Dropbox from Google Apps Script.
-
Rapidly Develop LinkedIn Ads-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by LinkedIn Ads.
-
Query Zoho CRM Data as a MySQL Database in Node.js
Execute MySQL queries against Zoho CRM from Node.js.
-
Connect to Shippo Data in RazorSQL
Connect to Shippo from wizards and query Shippo from the GUI in the RazorSQL database management tool.
-
Access Calendly Data from MySQL in PHP
Connect to Calendly through the standard MySQL libraries in PHP.
-
Query Harvest Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Harvest from Node.js.
-
Connect to Snowflake Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build ShipStation-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for ShipStation to explore live ShipStation Data in Cursor to assist with building ShipStation-powered applications.
-
Use Grok to Talk to Your API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your API for you.
-
Integrate with Box Data in JReport Designer
Create charts and reports based on Box in JReport Designer.
-
Explore Geographical Relationships in Bitbucket Data with Power Map
Create data visualizations with Bitbucket in Power Map.
-
DataBind Controls to Brex Data in Delphi
DataBind to Brex in Delphi with standard data access components and controls.
-
Use JayDeBeApi to access JSON Services in Python
Use standard Python scripting and the development environment of your choice to access live JSON.
-
Configure the CData JDBC Driver for WooCommerce in a Connection Pool in Tomcat
Connect to WooCommerce from a connection pool in Tomcat.
-
Natively Connect to Printful Data in PHP
The CData ODBC driver for Printful enables you to create PHP applications with connectivity to Printful. Leverage the native support for ODBC in PHP.
-
Automated Continuous Bullhorn CRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to SQL Server.
-
Analyze Lakebase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Lakebase with the CData JDBC Driver for Lakebase.
-
Use the CData Software JDBC Driver for Salesforce Marketing in MicroStrategy Desktop
Connect to Salesforce Marketing Cloud in MicroStrategy Desktop using the CData Software JDBC Driver for Salesforce Marketing.
-
Visualize BambooHR Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to BambooHR.
-
How to create Okta federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Okta in MySQL .
-
Create Dynamic Smartsheet Grids Using the Infragistics XamDataGrid
Learn how you can connect Smartsheet to Infragistics XamDataGrid to build dynamic grids.
-
How to Easily Query Humanity Data in OpenOffice Base
Connect to Humanity data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Active Directory from Asprova with CData Software ODBC Driver for Active Directory
This article shows how to connect faster to Active Directory data from Asprova.
-
Integrating ZendeskSell Data in Talend Cloud Data Management Platform
Connect ZendeskSell Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build SAP ByDesign-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP Business ByDesign.
-
Build a Simple VCL Application for Freshdesk Data
How to build a simple VCL Application to view Freshdesk in RAD Studio using the CData ODBC Driver for Freshdesk.
-
Connecting Moonlit Workflow with Avalara AvaTax 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 Avalara AvaTax in real time.
-
How to Query Live QuickBooks Time Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live QuickBooks Time data in natural language using Python.
-
Load YouTube Analytics Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load YouTube Analytics to a database.
-
Automate Postmark Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Postmark from PowerShell? This article demonstrates how to utilize the Postmark Cmdlets for tasks like connecting to Postmark, automating operations, downloading data, and more.
-
Write a Simple Go Application to work with Vault CRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Veeva Vault & Vault CRM.
-
Easily Integrate SharePoint Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft SharePoint in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Migrating data from Zoho Recruit to Snowflake using CData SSIS Components.
Easily push Zoho Recruit to Snowflake using the CData SSIS Tasks for Zoho Recruit and Snowflake.
-
Integrating Boomi Agentstudio with Shopify Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Shopify, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Visualize Live Postmark Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Postmark using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
View Reports on Real-Time YouTube Analytics Data in Power BI Report Server
Use the CData ODBC Driver for YouTube Analytics to visualize YouTube Analytics in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Outlook Data in DataGrip
Create a Data Source for Outlook in DataGrip and use SQL to query live Outlook.
-
Build Dashboards with Datadog Data in DBxtra
Create dynamic dashboards and perform analytics based on Datadog in DBxtra.
-
Integrate with Live Confluence Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Confluence from the MuleSoft Anypoint Platform to integrate live Atlassian Confluence into custom reports and dashboards.
-
Work with Live Zoho CRM Data in Power Query
Use CData Connect AI to connect to Zoho CRM and work with live Zoho CRM in Microsoft Power Query.
-
Connect to WordPress Data as an External Source in Dremio
Use the CData JDBC Driver to connect to WordPress as an External Source in Dremio.
-
Build Charts with Klaviyo Data in Clear Analytics
Create dynamic charts and perform analytics based on Klaviyo in Clear Analytics.
-
Automated Continuous Gorgias Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Gorgias replication to Amazon Redshift.
-
Create Power BI Reports on Real-Time HBase Data
Use the CData ODBC Driver for HBase to visualize Apache HBase in Power BI Desktop.
-
Connect to DB2 Data from a Connection Pool in JBoss
Integrate IBM DB2 into Java servlets: Use the Management Console in JBoss to install the DB2 JDBC Driver.
-
Integrate SAP Ariba Source with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Ariba Source with External Services.
-
Explore Geographical Relationships in PayPal Data with Power Map
Create data visualizations with PayPal in Power Map.
-
Integrate Amazon Marketplace Data into Power Automate Desktop using CData Connect
CData Connect for Amazon Marketplace Data enables you to integrate Amazon Marketplace into workflows built using Microsoft Power Automate Desktop.
-
Using the CData Software ODBC Driver for Helpscout in PyCharm
Connect to Helpscout as an ODBC data source in PyCharm using the CData Software ODBC Driver for Helpscout.
-
Bidirectional Access to Sage 300 Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sage 300 in Filemaker Pro for Mac or Windows.
-
Integrate Live HubDB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live HubDB to Blue Prism using the CData ODBC Driver for HubDB to create automated workflows for repetitive business tasks.
-
Integrating LlamaIndex with Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft OneDrive in real time.
-
Connect to Square from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Square, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous ZohoSubscriptions Replication to MongoDB
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to MongoDB.
-
Integrate with Brex Data in JReport Designer
Create charts and reports based on Brex in JReport Designer.
-
Connect to Cassandra Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Apache Cassandra from Filemaker Pro on Mac.
-
How to integrate Metabase with Box Data
Use CData Connect AI to connect to live Box and create an interactive dashboard in Metabase from Box.
-
Use Grok to Talk to Your HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your HubSpot for you.
-
Connect to Perigon Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Perigon in the Denodo Virtual DataPort Administrator.
-
How to Access Live Oracle Eloqua Data in Visual Studio Code via Cline
Run CData MCP Server for Oracle Eloqua on Windows Subsytem for Linux (WSL) and connect to live Oracle Eloqua from the Cline extension in Visual Studio Code.
-
Connect to ClickTime Data from PowerBuilder via JDBC
This article demonstrates how to access ClickTime from PowerBuilder using the ClickTime JDBC Driver.
-
Build Visualizations of QuickBooks Time Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of QuickBooks Time in Birst.
-
How to connect PolyBase to Helpscout
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Helpscout.
-
Create Datasets from QuickBooks Online in Domo Workbench and Build Visualizations of QuickBooks Online Data in Domo
Use the CData Software ODBC Driver for QuickBooks Online to create datasets from QuickBooks Online in Domo Workbench and then build visualizations in the Domo service.
-
Connect to FreeAgent Data from a Connection Pool in Jetty
The FreeAgent JDBC Driver supports connection pooling: This article shows how to connect faster to FreeAgent from Web apps in Jetty.
-
How to Connect to Live NetSuite SuiteAnalytics Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your NetSuite SuiteAnalytics for you.
-
Connect to Supabase Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Supabase using standard SQL.
-
Connect to Twitter Ads Data from AWS Glue
Use CData Connect AI to gain access to live Twitter Ads from your AWS Glue jobs.
-
Operational Reporting on Spotify Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Spotify.
-
Build a PostgreSQL Interface for Amplitude Data using the CData JDBC Driver
Use the Remoting features of the Amplitude JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Outreach.io actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Build Excel-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Excel to explore live Excel Data in Claude Code to assist with building Excel-powered applications.
-
Connect to Raisers Edge NXT Data from Crystal Reports
Use CData Connect AI to connect to and report on live Raisers Edge NXT from Crystal Reports.
-
Migrating data from CloudConvert to Databricks using CData SSIS Components.
Easily push CloudConvert to Databricks using the CData SSIS Tasks for CloudConvert and Databricks.
-
Access Live Google Ad Manager Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Ad Manager data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
LINQ to OnePageCrm Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the OnePageCrm Data Provider.
-
Connecting Agentforce with Google Directory 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 Directory for you.
-
How to Connect to Live Hive 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 Apache Hive without replication.
-
Add FreshBooks Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for FreshBooks with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to ZohoPeople Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ZohoPeople and work with ZohoPeople in your FileMaker applications.
-
Connect to Google Translate Data in JRuby
Create a simple JRuby app with access to live Google Translate.
-
Automated Continuous Sugar CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sugar CRM replication to PostgreSQL.
-
Connect to IBM Cloud Object Storage Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for IBM Cloud Object Storage in the Denodo Virtual DataPort Administrator.
-
Automate Exact Online Data Replication to Couchbase
Use CData Sync to Customize and automate Exact Online replication to Couchbase.
-
How to Connect to Live SQL Analysis Services Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SQL Analysis Services through natural language.
-
Analyze Databricks Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Databricks and visualize live Databricks in Infragistics Reveal.
-
Create Power BI Reports on Real-Time AdRoll Data
Use the CData ODBC Driver for AdRoll to visualize AdRoll in Power BI Desktop.
-
Visualize PDFMonkey Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load PDFMonkey into TIBCO Spotfire.
-
Connect to ConvertKit Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ConvertKit and the SQL Gateway to access ConvertKit from Google Apps Script.
-
Use the CData ODBC Driver for Microsoft Exchange from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft Exchange to connect to Microsoft Exchange from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Exchange in Excel.
-
Connect to Dotmailer Data in JRuby
Create a simple JRuby app with access to live Dotmailer.
-
Integrating OpenCode Terminal with Bullhorn CRM 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 Access Live ChargeOver Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ChargeOver enables you to integrate ChargeOver into workflows built using Microsoft Power Automate Desktop.
-
How to Create Power BI Visual Reports with Real-Time Salesforce Data 360 Data
Use CData Power BI Connectors to visualize Salesforce Data 360 in Power BI.
-
Bidirectional Access to Bitly Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Bitly in Filemaker Pro for Mac or Windows.
-
LINQ to Pipeliner CRM Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Pipeliner CRM Data Provider.
-
How to connect PolyBase to Apollo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apollo.
-
Build Zendesk-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Zendesk and build web apps with connectivity to live Zendesk.