CData Software - Knowledge Base
Recent Articles
-
Integrating Antigravity CLI with Sage Cloud Accounting data via CData CLI
Connect Sage Cloud Accounting data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Analyze Stripe Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Stripe data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Publish Reports with JDBC-ODBC Bridge Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date JDBC-ODBC Bridge data.
-
How to import WooCommerce Data into Apache Solr
Use the CData Software JDBC Driver for WooCommerce in Data Import Handler and create an automated import of WooCommerce data to Apache Solr Enterprise Search platform.
-
Automate Printful Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Printful data from PowerShell? This article demonstrates how to utilize the Printful Cmdlets for tasks like connecting to Printful data, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for Instantly in MicroStrategy Desktop
Connect to Instantly data in MicroStrategy Desktop using the CData Software JDBC Driver for Instantly.
-
Feed Clio Data into FineReport
How to set Clio data as a JDBC data source in FineReport.
-
Build Visualizations of Unbounce Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Unbounce data in Birst.
-
How to Work with Adobe Commerce Data in AWS Glue Jobs Using JDBC
Connect to Adobe Commerce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build AI/ML Models with Live Snowflake Data using Dataiku
Connect Snowflake Data with Dataiku using the CData JDBC Driver for Snowflake.
-
Automated Continuous Mode Replication to MySQL
Use CData Sync for automated, continuous, customizable Mode replication to MySQL.
-
Connect to ElevenLabs Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ElevenLabs to connect to ElevenLabs data and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for OData in SAS for Real-Time Reporting and Analytics
Connect to real-time OData services in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for OData.
-
How to create an RPA flow for Outreach.io Data in UiPath Studio
Use the Outreach.io ODBC Driver to create workflows that access real-time Outreach.io data without any coding.
-
Query Microsoft Teams Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft Teams data.
-
Operational Reporting on WordPress Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote WordPress data.
-
Create Data Visualizations in Cognos BI with BenchmarkEmail Data
Access BenchmarkEmail data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build a PostgreSQL Interface for XML Data using the CData JDBC Driver
Use the Remoting features of the XML JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Supabase Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Supabase data from your Excel spreadsheets.
-
Create SendGrid-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SendGrid Data from Klipfolio and build custom visualizations using live SendGrid data.
-
Integrating Boomi Agentstudio with HCL Domino Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to HCL Domino data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Visualize Elasticsearch Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Elasticsearch data.
-
How to connect Amazon QuickSight to ADP Data
Create a connection to ADP data in CData Connect AI and insert ADP data into Amazon QuickSight SPICE to build interactive dashboards.
-
Query, Visualize, and Share live Couchbase Data in Redash
Use CData Connect AI to connect to live Couchbase data in Redash for querying, visualizing, and sharing.
-
Access SAP Ariba Source 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 SAP Ariba Source data.
-
Integrate with SAP Business One Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Business One data to a JSON file on disk.
-
Analyze ShipEngine Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ShipEngine data and visualize ShipEngine data in SAP Analytics Cloud.
-
Use the CData Software ODBC Driver for Access in MicroStrategy Desktop
Connect to Access data in MicroStrategy Desktop using the CData Software ODBC Driver for Access.
-
Integrate Theia IDE with Live SFTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SFTP data from within the development environment.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Marketo
Provide connectivity to Marketo data through an SAP BusinessObjects universe.
-
Integrating Cursor with Phoenix 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.
-
Access Live WordPress Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live WordPress data from your Excel spreadsheets.
-
How to load Tanda data into Elasticsearch via Logstash
Introducing a simple method to load Tanda data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Shippo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Shippo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Shippo data.
-
Integrate Presto Data into Power Automate Desktop using CData Connect
CData Connect for Presto Data enables you to integrate Presto data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Trello Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Trello data.
-
Build Calendly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Calendly data and build web apps with connectivity to live Calendly data.
-
Create Qualaroo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Qualaroo data access from reports, embedded analytics, and more.
-
How to Build an ETL App for iContact Data in Python with CData
Create ETL applications and real-time data pipelines for iContact data in Python with petl.
-
DataBind Controls to Adobe Experience Manager Data in Delphi
DataBind to Adobe Experience Manager data in Delphi with standard data access components and controls.
-
Automated Continuous Onfleet Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Onfleet replication to Apache Cassandra.
-
Build Agents in Relevance AI with Access to Live Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sugar CRM data within intelligent agent workflows.
-
How to Connect the Power BI Service to ConvertAPI: Complete Guide
Connect to the CData Software Power BI Connector for ConvertAPI from PowerBI.com to provide real-time ConvertAPI data across the organization.
-
Import Instagram Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Instagram Data and provide access to live Instagram data for custom reports in the Power BI Service.
-
Build Data Flows from SQL Server to LinkedIn through SSIS
Easily push SQL Server data to LinkedIn using the CData SSIS Tasks for LinkedIn.
-
Integrate Google's Vertex AI Agent with Live Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Power BI XMLA data within intelligent workflows.
-
Visualize Live ConvertAPI Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ConvertAPI data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Excel Spreadsheet Automation on Amazon DynamoDB Data with the QUERY Formula
Pull data from Amazon DynamoDB, automate spreadsheets, and more with the QUERY formula.
-
Query Vault CRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Vault CRM data from Node.js.
-
Analyze Live Printify Data in SAS Viya
Use CData Connect AI to connect to Printify data from SAS Viya and deploy self-service analytics using live Printify data.
-
Access RSS Feeds from MySQL in Amazon QuickSight
Connect to RSS and build visualizations of RSS feeds using a MySQL Connection in Amazon QuickSight.
-
Integrate Live FTP Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live FTP data to Blue Prism using the CData ODBC Driver for FTP to create automated workflows for repetitive business tasks.
-
Access Live LightSpeedRetail Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate LightSpeedRetail data into the statistical analysis tools available in SAS JMP. This article shows how to use LightSpeedRetail data in the Graph Builder and Query Builder.
-
Access Live Cosmos DB 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 Cosmos DB data through MCP integration.
-
Connecting Mastra with Campaigner Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Campaigner data, no replication required.
-
Pipeliner CRM Reporting in OBIEE with the Pipeliner CRM JDBC Driver
Deploy the Pipeliner CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
LINQ to Impala 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 Impala Data Provider.
-
Integrate Trae with Live BenchmarkEmail Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live BenchmarkEmail data from within the AI-powered IDE.
-
Connect to Unbounce Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Unbounce and work with Unbounce data in your FileMaker applications.
-
How to connect SharePoint with SAP Business One Data through external lists
Provide SAP Business One data to SharePoint users as an external list.
-
Build Semantic Layer Views for Aweber Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Aweber data.
-
Write a Simple Go Application to work with Zoho CRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoho CRM data.
-
Analyze Zendesk Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zendesk data with the CData JDBC Driver for Zendesk.
-
Rapidly Develop Hugging Face-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 Hugging Face.
-
Import Oracle Sales Data Using Azure Data Factory
Use CData Connect AI to connect to Oracle Sales Data from Azure Data Factory and import live Oracle Sales data.
-
Use the CData ODBC Driver for Tickspot from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Tickspot to connect to Tickspot data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Tickspot data in Excel.
-
Connecting GenSpark with Asana Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Asana data without any replication or custom integration required.
-
How to Connect to Copper Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Copper data. Leverage the pyodbc module for ODBC in Python.
-
Analyze Live Guru Data in SAS Viya
Use CData Connect AI to connect to Guru data from SAS Viya and deploy self-service analytics using live Guru data.
-
Integrate Live ServiceNow Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ServiceNow data to Blue Prism using the CData ODBC Driver for ServiceNow to create automated workflows for repetitive business tasks.
-
Connect to LinkedIn Ads Data from Crystal Reports
Use CData Connect AI to connect to and report on live LinkedIn Ads data from Crystal Reports.
-
Configure the CData JDBC Driver for Rootly in a Connection Pool in Tomcat
Connect to Rootly data from a connection pool in Tomcat.
-
Automated Continuous OData Replication to Oracle
Use CData Sync for automated, continuous, customizable OData replication to Oracle.
-
Analyze Raisers Edge NXT Data in Cognos Analytics
Use CData Connect AI to connect to Raisers Edge NXT Data from Cognos Analytics and analyze live Raisers Edge NXT data.
-
Getting Started with the CData Tableau Connector for Microsoft Ads
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft Ads.
-
Integrate ServiceNow Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ServiceNow data from Informatica Cloud.
-
How to publish and share Pinterest Data dashboards with Tableau Server
The CData ODBC driver for Pinterest enables you integrate Pinterest data into Tableau dashboards.
-
Build Presto-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Presto data and build Presto-connected web apps with Axios.
-
Connect to SAP HANA Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP HANA data from HeidiSQL.
-
Integrating Claude Code CLI with Miro 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 Google Forms from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Forms data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Query Attio Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Attio data from Node.js.
-
Connect and Visualize Live Zendesk Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zendesk data into the Databricks platform and create visualization dashboards with real-time Zendesk data.
-
How to Connect to Live Pipedrive 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 Pipedrive data for you.
-
Create ADP-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ADP Data from Klipfolio and build custom visualizations using live ADP data.
-
Getting Started with the CData ADO.NET Provider for Instantly
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating Claude Code CLI with ScrapingBee 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.
-
Create Informatica Mappings From/To a JDBC Data Source for ZohoSubscriptions
Create ZohoSubscriptions data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Edit and Search External SAP SuccessFactors Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP SuccessFactors data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP SuccessFactors Data objects that you can access from apps and the dashboard.
-
Using the CData Software ODBC Driver for CampaignMonitor in PyCharm
Connect to CampaignMonitor as an ODBC data source in PyCharm using the CData Software ODBC Driver for CampaignMonitor.
-
Create Datasets from Blackbaud FE NXT in Domo Workbench and Build Visualizations of Blackbaud FE NXT Data in Domo
Use the CData Software ODBC Driver for Blackbaud FE NXT to create datasets from Blackbaud FE NXT data in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData SSIS Components for SAP Fieldglass
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Fieldglass.
-
Getting Started with the CData ODBC Driver for Qualaroo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Qualaroo.
-
Integrate with Dynamics 365 Business Central Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Dynamics 365 Business Central data to a JSON file on disk.
-
Replicate SAP HANA XS Advanced Data in Heroku for Use in Salesforce Connect
Replicate SAP HANA XS Advanced data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to and Query Blackbaud FE NXT Data in QlikView over ODBC
Create data visualizations with Blackbaud FE NXT data in QlikView.
-
Visualize Workday 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 Workday data into TIBCO Spotfire.
-
Build Charts with Attio Data in Clear Analytics
Create dynamic charts and perform analytics based on Attio data in Clear Analytics.
-
How to connect and process XML data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live XML data.
-
Operational Reporting on OnePageCrm Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote OnePageCrm data.