CData Software - Knowledge Base
Recent Articles
-
Visualize Everhour Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Everhour.
-
Working with Salesloft Data in LINQPad
Execute LINQ queries to Salesloft in LINQPad.
-
Visualize Webflow Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Webflow.
-
Automate Clio Data Replication to Azure Data Lake
Use CData Sync to customize and automate Clio replication to Azure Data Lake.
-
Work with Snapchat Ads Data in FoxPro
Load Snapchat Ads into a FoxPro database. This article includes full code and a walk-through of the process.
-
Analyze Snapchat Ads Data in Cognos Analytics
Use CData Connect AI to connect to Snapchat Ads Data from Cognos Analytics and analyze live Snapchat Ads.
-
Build Dashboards with PostgreSQL Data in DBxtra
Create dynamic dashboards and perform analytics based on PostgreSQL in DBxtra.
-
Build Agents in Relevance AI with Access to Live Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Azure Table Storage within intelligent agent workflows.
-
Integrate Live SAP SuccessFactors LMS Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP SuccessFactors LMS and integrate live SAP SuccessFactors LMS into apps built in Microsoft Power Apps.
-
How to Connect to Live Odoo 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 Odoo ERP without replication.
-
Moving Data from Templated to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Templated data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Query Live Nethunt Data in Perplexity MacOS Desktop
Connect to and query live Nethunt Data in Perplexity Desktop using CData MCP Server.
-
Build PhantomBuster-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PhantomBuster.
-
How to Import Data from ClickUp into Google Sheets
Import ClickUp into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous Phoenix Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Phoenix replication to Amazon S3.
-
Integrate Live Pinterest Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Pinterest to Blue Prism using the CData ODBC Driver for Pinterest to create automated workflows for repetitive business tasks.
-
Migrating data from XML to Databricks using CData SSIS Components.
Easily push XML Files to Databricks using the CData SSIS Tasks for XML and Databricks.
-
Integrate Outreach.io with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Outreach.io with External Services.
-
Connect to and Visualize Live Elorus Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Elorus.
-
Connect to Recurly Data in HULFT Integrate
Connect to Recurly as a JDBC data source in HULFT Integrate
-
Connect to LeadDesk in SpagoBI
Create reports featuring live LeadDesk in SpagoBI Studio. Host LeadDesk reports on SpagoBI Server.
-
Build Dashboards with SAS Data Sets Data in DBxtra
Create dynamic dashboards and perform analytics based on SAS Data Sets in DBxtra.
-
Build an OLAP Cube in SSAS from Shippo Data
Establish a connection to Shippo data from SQL Server Analysis Services, and use the Shippo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Splunk Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Splunk replication to delimited files (CSV/TSV).
-
Getting Started with the CData ODBC Driver for Tavily
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Tavily.
-
Create Kintone Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Kintone data access from reports, embedded analytics, and more.
-
Connect to Lakebase Data from a Connection Pool in Jetty
The Lakebase JDBC Driver supports connection pooling: This article shows how to connect faster to Lakebase from Web apps in Jetty.
-
Use the CData Software JDBC Driver for Amplitude in MicroStrategy
Connect to Amplitude in MicroStrategy Developer using the CData Software JDBC Driver for Amplitude.
-
Connect to Workday Data from AWS Glue
Use CData Connect AI to gain access to live Workday from your AWS Glue jobs.
-
Integrate Live Avalara AvaTax Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Avalara AvaTax from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Avalara AvaTax.
-
Query Oracle Sales Data in ColdFusion
Write standard ColdFusion data access code to connect to Oracle Sales.
-
Build Automated Workflows with Live Raisers Edge NXT Data in Workato
Use CData Connect AI to connect to live Raisers Edge NXT and build automated workflows in Workato.
-
How to Connect to Live GitLab 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 GitLab for you.
-
Connect to MongoDB Data from Crystal Reports
Use CData Connect AI to connect to and report on live MongoDB from Crystal Reports.
-
Load FHIR Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load FHIR to a database.
-
Create LinkedIn Ads-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to LinkedIn Ads Data from Klipfolio and build custom visualizations using live LinkedIn Ads.
-
Excel Spreadsheet Automation on CloudConvert Data with the QUERY Formula
Pull data from CloudConvert, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Highrise Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Highrise replication to Azure SQL Database.
-
A PostgreSQL Interface for Salesforce CRM Analytics Data using the CData ODBC Driver
Use the SQL Gateway and Salesforce CRM Analytics ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous ShipEngine Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ShipEngine replication to OneLake in Microsoft Fabric.
-
Perform Batch Operations with Blackbaud FE NXT Data in Apache NiFi
Connect to Blackbaud FE NXT and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for Landbot
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build Data Flows from Hugging Face to SQL Server using SSIS
Easily back up Hugging Face to SQL Server using the SSIS components for Hugging Face.
-
Replicate MailerLite Data from PowerShell
Write a quick PowerShell script to query MailerLite. Use connectivity to the live data to replicate MailerLite to SQL Server.
-
Creating Trello-Connected Applications in Unqork
You can use CData Connect AI to feed Trello to Unqork and build custom business apps.
-
Connect to NetSuite Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live NetSuite CRM & ERP.
-
Automated Continuous Apify Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apify replication to OneLake in Microsoft Fabric.
-
Connect to Perplexity Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Perplexity to connect to Perplexity and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for Dynamics NAV in MicroStrategy Desktop
Connect to Microsoft Dynamics NAV in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics NAV.
-
Analyze Couchbase Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Couchbase in Microsoft R Open.
-
Integrate Cursor with Live Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Amazon Redshift from within the editor.
-
Build Voice Agents in ElevenLabs with access to Live Snowflake Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Snowflake.
-
Build a Simple VCL Application for SAP ByDesign Data
How to build a simple VCL Application to view SAP Business ByDesign in RAD Studio using the CData ODBC Driver for SAP ByDesign.
-
Connecting Moonlit Workflow with AlloyDB 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 Google AlloyDB in real time.
-
Use the CData Software ODBC Driver for Sendwithus in MicroStrategy Web
Connect to Sendwithus in MicroStrategy Web using the CData Software ODBC Driver for Sendwithus.
-
Integrating Cursor CLI with Tally 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.
-
Build Charts with LionDesk Data in Clear Analytics
Create dynamic charts and perform analytics based on LionDesk in Clear Analytics.
-
Use the CData Software ODBC Driver for FTP in SAS for Real-Time Reporting and Analytics
Connect to real-time FTP Servers in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for FTP.
-
Query Sage Cloud Accounting Data as a SQL Server Database in Node.js
Execute SQL Server queries against Sage Business Cloud Accounting from Node.js.
-
Analyze Google Search Results with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Search from Power Pivot. You will use the Table Import Wizard to load Google Search. You can visually build the import query or use any SQL supported by the driver.
-
Consume Omnisend OData Feeds in PowerBuilder
This article demonstrates how to consume Omnisend as OData feeds from PowerBuilder using the API Server.
-
How to Access Live Redshift Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Redshift enables you to integrate Amazon Redshift into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to Freshservice Data in C++Builder
DataBind to Freshservice in C++Builder with standard components and controls.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Outreach.io within intelligent workflows.
-
Build Quickbase-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Quickbase to explore live Quickbase Data in Cursor to assist with building Quickbase-powered applications.
-
Connect to GitLab Data in DBArtisan
Use wizards in DBArtisan to configure GitLab as a data source.
-
A PostgreSQL Interface for Adobe Commerce Data using the CData ODBC Driver
Use the SQL Gateway and Adobe Commerce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query Instantly Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Instantly entities in PHP by modeling them as objects.
-
Access Live OData Services in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to OData from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Apollo Data in HULFT Integrate
Connect to Apollo as a JDBC data source in HULFT Integrate
-
ETL JDBC-ODBC Bridge in Oracle Data Integrator
This article shows how to transfer JDBC-ODBC Bridge into a data warehouse using Oracle Data Integrator.
-
Replicate Multiple Typeform Accounts
Replicate multiple Typeform accounts to one or many databases.
-
Use the CData Software JDBC Driver for Gong in MicroStrategy Web
Connect to Gong in MicroStrategy Web using the CData Software JDBC Driver for Gong.
-
Build MySQL-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to MySQL Data from Zoho Analytics and import live MySQL.
-
DataBind Hive Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Apache Hive with the DevExpress Windows Forms and Web controls to provide Apache Hive to a chart.
-
Build Semantic Layer Views for Contentful Data in APOS Live Data Gateway
Use the CData Connector for Contentful in APOS Live Data Gateway to build Semantic Layer Views for Contentful.
-
Create SSAS Tabular Models from Workday Data
How to build a SQL Server Analysis Service Tabular Model from Workday using CData drivers.
-
Access Live Zuora Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zuora from your Excel spreadsheets.
-
Integrate LibreChat with Live Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Box from within the chat interface.
-
Integrating Antigravity CLI with Cloudflare via CData CLI
Connect Cloudflare to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData Software JDBC Driver for Workday in MicroStrategy Web
Connect to Workday in MicroStrategy Web using the CData Software JDBC Driver for Workday.
-
Build a Simple VCL Application for Google Sheets Data
How to build a simple VCL Application to view Google Sheets in RAD Studio using the CData ODBC Driver for Google Sheets.
-
Connect to HubSpot 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 HubSpot.
-
Extend Google Sheets with MYOB AccountRight Data
Make calls to MYOB AccountRight from Google Apps Script via the API Server.
-
Design BIRT Reports on Mailjet Data
Provide current Mailjet to your embedded analytics.
-
Query Zoho Projects Data in DataGrip
Create a Data Source for Zoho Projects in DataGrip and use SQL to query live Zoho Projects.
-
Working with Blackbaud FE NXT Data in LINQPad
Execute LINQ queries to Blackbaud FE NXT in LINQPad.
-
Connect to Wistia Data in Aqua Data Studio
Access Wistia from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to SAP Business Warehouse Data in HULFT Integrate
Connect to SAP Business Warehouse as a JDBC data source in HULFT Integrate
-
How to Create Power BI Visual Reports with Real-Time Humanity Data
Use CData Power BI Connectors to visualize Humanity in Power BI.
-
Access Live SendGrid Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SendGrid data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrating Cursor CLI with Facebook Ads 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.
-
Import LinkedIn Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access LinkedIn. In this article, you will use the OData format to import LinkedIn into Microsoft Power Query.
-
Automated Continuous ChargeOver Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ChargeOver replication to IBM DB2.
-
Publish Accelo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Accelo.
-
Build ScrapingBee-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live ScrapingBee Data in Cursor to assist with building ScrapingBee-powered applications.
-
Process & Analyze SAP Fieldglass Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Fieldglass Data.
-
Integrating Dataiku with Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Jira Assets.
-
Visualize Live Redis Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Redis into custom reports in Power BI.
-
Use the CData Software JDBC Driver for Webex in MicroStrategy Web
Connect to Webex in MicroStrategy Web using the CData Software JDBC Driver for Webex.