CData Software - Knowledge Base
Recent Articles
-
Connect to Superchat Data in RapidMiner
Integrate Superchat with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Claude Code with ShipStation Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on ShipStation within assisted coding and automated development workflows.
-
How to Connect to & Open Blackbaud FE NXT Data in Microsoft Excel
This article uses the CData ODBC driver for Blackbaud FE NXT to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to publish and share Placid Data dashboards with Tableau Server
The CData ODBC driver for Placid enables you integrate Placid into Tableau dashboards.
-
DataBind SFTP Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SFTP with the DevExpress Windows Forms and Web controls to provide SFTP to a chart.
-
DataBind Oracle SCM Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Oracle SCM with the DevExpress Windows Forms and Web controls to provide Oracle SCM to a chart.
-
How to Connect the Power BI Service to Reply.io: Complete Guide
Connect to the CData Software Power BI Connector for Reply.io from PowerBI.com to provide real-time Reply.io across the organization.
-
How to create Billsby federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Billsby in MySQL .
-
Visualize Live Klaviyo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Klaviyo using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Zoho CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zoho CRM.
-
Build Voice Agents in ElevenLabs with access to Live GitLab Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live GitLab.
-
Connect to Bugsnag Data from PowerBuilder via JDBC
This article demonstrates how to access Bugsnag from PowerBuilder using the Bugsnag JDBC Driver.
-
How to work with SAP Ariba Procurement Data in Apache Spark using SQL
Access and process SAP Ariba Procurement Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate with FormSite Data in JReport Designer
Create charts and reports based on FormSite in JReport Designer.
-
Connect to and Query Square Data in QlikView over ODBC
Create data visualizations with Square in QlikView.
-
Integrating Claude Code CLI with Apify 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 Real-Time Acumatica Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Acumatica ERP in ColdFusion.
-
Connect to Coinbase Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Coinbase to connect to Coinbase and execute queries in PowerBuilder.
-
Access Live Shopify Data in AWS Lambda
Connect to live Shopify in AWS Lambda using the CData JDBC Driver.
-
Integrating Kiro CLI with Retently 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.
-
Replicate AgileCRM Data from PowerShell
Write a quick PowerShell script to query AgileCRM. Use connectivity to the live data to replicate AgileCRM to SQL Server.
-
Analyze Amazon S3 Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Amazon S3 and visualize Amazon S3 in SAP Analytics Cloud.
-
Validate Ontraport Data with QuerySurge
Access and validate Ontraport in QuerySurge using the CData JDBC Driver.
-
Build Vault CRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Veeva Vault & Vault CRM and build web apps with connectivity to live Veeva Vault & Vault CRM.
-
Visualize Live Airtable Data in the Power BI Service
Use CData Connect AI to connect to live Airtable and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Bullhorn CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Bullhorn CRM facts in real time.
-
Connect to iContact in SpagoBI
Create reports featuring live iContact in SpagoBI Studio. Host iContact reports on SpagoBI Server.
-
How to Connect to Live Hive 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 Apache Hive for you.
-
Enable the Reply.io JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Reply.io.
-
Integrate with Live Email Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Email from the MuleSoft Anypoint Platform to integrate live Email into custom reports and dashboards.
-
Use the CData ODBC Driver for Tally from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Tally to connect to Tally ERP from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Tally ERP in Excel.
-
How to Query Live Active Directory Data in Perplexity MacOS Desktop
Connect to and query live Active Directory Data in Perplexity Desktop using CData MCP Server.
-
Query Sage Cloud Accounting Data as a MySQL Database in Node.js
Execute MySQL queries against Sage Business Cloud Accounting from Node.js.
-
Connect to ConvertAPI Data from a Connection Pool in Jetty
The ConvertAPI JDBC Driver supports connection pooling: This article shows how to connect faster to ConvertAPI from Web apps in Jetty.
-
How to Connect to Live Amazon Marketplace 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 Amazon Marketplace through natural language.
-
Connecting Pipedream with Freshservice 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 Freshservice data in real time.
-
Replicate Freshsales Data from PowerShell
Write a quick PowerShell script to query Freshsales. Use connectivity to the live data to replicate Freshsales to SQL Server.
-
Query Workday Data as a SQL Server Database in Node.js
Execute SQL Server queries against Workday from Node.js.
-
Deploy the ADO.NET Provider for HubDB on an SSRS Report Server
Connect to HubDB from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Visualize Live PolarTeamPro Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PolarTeamPro.
-
How to Query Reply.io Data in MySQL Workbench
Execute MySQL queries against live Reply.io from MySQL Workbench.
-
Enable the PostgreSQL JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PostgreSQL.
-
Build Semantic Layer Views for Pingdom Data in APOS Live Data Gateway
Use the CData Connector for Pingdom in APOS Live Data Gateway to build Semantic Layer Views for Pingdom.
-
Integrating Claude Code CLI with Hacker News 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 Connect to Live Google Contacts 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 Google Contacts without replication.
-
How to Build an ETL App for Freshdesk Data in Python with CData Connect AI
Build ETL pipelines that read and write live Freshdesk in Python with petl and the CData Connect AI Python SDK.
-
How to Access Grafana Data Using Entity Framework
This article shows how to access Grafana using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData SSIS Components to Insert New or Update Existing Dropbox Records from SQL Server
Easily push SQL Server data to Dropbox using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Dropbox or update existing records with data from a SQL Server database.
-
Automated Continuous QuickBooks Online Replication to SingleStore
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to SingleStore.
-
How to Connect DBeaver to Supabase via a JDBC Driver
Manage Supabase with visual tools in DBeaver like the query browser.
-
Prepare, Blend, and Analyze Sendwithus Data in Alteryx Designer (ODBC)
Build workflows to access live Sendwithus for self-service data analytics.
-
Use Dash to Build to Web Apps on Timely Data
Create Python applications that use pandas and Dash to build Timely-connected web apps.
-
Connect to and Visualize Live Freshservice Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Freshservice.
-
Automated Continuous MailerLite Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MailerLite replication to Google BigQuery.
-
Import and Visualize VWO Data in Power View
Create data visualizations based on VWO in Excel.
-
Create a Data Access Object for Rootly Data using JDBI
A brief overview of creating a SQL Object API for Rootly in JDBI.
-
Connect to and Visualize Live eBay Analytics Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live eBay Analytics.
-
How to publish and share VWO Data dashboards with Tableau Server
The CData ODBC driver for VWO enables you integrate VWO into Tableau dashboards.
-
Connect to Paymo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Paymo in the Denodo Virtual DataPort Administrator.
-
Integrate Cursor with Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Veeva Vault & Vault CRM from within the editor.
-
DataBind Charts to Facebook Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Facebook 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.
-
Connect Mistral AI to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mistral AI with IBM WebSphere for seamless data integration and connectivity.
-
Extract, Transform, and Load ZendeskSell Data in Informatica PowerCenter
Create a simple Workflow for ZendeskSell in Informatica PowerCenter.
-
Query Phoenix Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Apache Phoenix and perform CRUD operations on Phoenix from Node.js.
-
Build Freshservice-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Freshservice and build web apps with connectivity to live Freshservice.
-
How to Query Live Adobe Commerce Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Adobe Commerce data in natural language using Python.
-
Import and Visualize Box Data in Power View
Create data visualizations based on Box in Excel.
-
Automated Continuous REST Replication to MongoDB
Use CData Sync for automated, continuous, customizable REST replication to MongoDB.
-
Automated Continuous Neo4J Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Neo4J replication to delimited files (CSV/TSV).
-
Integrating Claude Code with Oracle HCM Cloud Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle HCM Cloud within assisted coding and automated development workflows.
-
How to Build an ETL App for Marketo Data in Python with CData
Create ETL applications and real-time data pipelines for Marketo in Python with petl.
-
Getting Started with the CData ODBC Driver for Parquet
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Parquet.
-
Build Sugar CRM-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Sugar CRM to explore live Sugar CRM Data in Gemini Code Assist to assist with building Sugar CRM-powered applications.
-
Access Live Phoenix 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 Apache Phoenix through MCP integration.
-
Import SFTP Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SFTP. In this article, you will use the OData format to import SFTP into Microsoft Power Query.
-
Query Hive Data in ColdFusion
Write standard ColdFusion data access code to connect to Apache Hive.
-
Build Semantic Layer Views for Elasticsearch Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Elasticsearch.
-
How to Connect to Live SAP BusinessObjects BI 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 SAP BusinessObjects BI for you.
-
Integrating LlamaIndex with API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on API in real time.
-
Choosing the Best Method to Connect REST to SQL Server: 5 Options Explained
Discover multiple ways to connect and use REST from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Query Optimizely Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Optimizely from Node.js.
-
Load Printful Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Printful to a database.
-
Facebook Ads Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Facebook Ads facts in real time.
-
Build FreshBooks-Connected Apps in Choreo
Use CData Connect AI to connect to FreshBooks Data from Choreo and build custom apps using live FreshBooks.
-
Connect to Azure Data Catalog Data in RapidMiner
Integrate Azure Data Catalog with standard components and data source configuration wizards in RapidMiner Studio.
-
How to create an RPA flow for LionDesk Data in UiPath Studio
Use the LionDesk ODBC Driver to create workflows that access real-time LionDesk without any coding.
-
Moving Data from Oracle Eloqua to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Oracle Eloqua data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Natively Connect to DocuSign Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to DocuSign. Leverage the native support for ODBC in PHP.
-
Integrate Real-Time Access to SAP SuccessFactors in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP SuccessFactors in real time.
-
Bridge Sage 300 Connectivity with Apache NiFi
Access and process Sage 300 in Apache NiFi using the CData JDBC Driver.
-
Replicate API Data in Heroku for Use in Salesforce Connect
Replicate API to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Object-Relational Mapping (ORM) with CircleCI 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 CircleCI into a Java-based ORM framework, Hibernate.
-
Analyze Live Sage 200 Data in SAS Viya
Use CData Connect AI to connect to Sage 200 from SAS Viya and deploy self-service analytics using live Sage 200.
-
Flowlu Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Flowlu facts in real time.
-
Query Microsoft Planner Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Planner from Node.js.
-
Connect to Notion Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Notion and work with Notion in your FileMaker application.
-
Easily Integrate Active Directory Data in Lazarus Pascal IDE
Learn how to easily integrate live Active Directory in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Google Forms Data Replication to Teradata
Use CData Sync to Customize and automate Google Forms replication to Teradata.
-
Using the CData Software ODBC Driver for Vercel in PyCharm
Connect to Vercel as an ODBC data source in PyCharm using the CData Software ODBC Driver for Vercel.
-
Build a PostgreSQL Interface for Shortcut Data using the CData JDBC Driver
Use the Remoting features of the Shortcut JDBC Driver to create a PostgreSQL entry-point for data access.