CData Software - Knowledge Base
Recent Articles
-
Add Brex Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Brex with the Informatica Enterprise Data Catalog to classify and organize data.
-
Visualize Zoho CRM 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 Zoho CRM data into TIBCO Spotfire.
-
Access Live ServiceNow Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ServiceNow data from your Excel spreadsheets.
-
Build MVC Applications with Connectivity to Slack Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Slack from an ASP.NET MVC application.
-
Integrate Azure Table Data in Pentaho Data Integration
Build ETL pipelines based on Azure Table data in the Pentaho Data Integration tool.
-
How to use SQLAlchemy ORM to access SharePoint Excel Services Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SharePoint Excel Services data.
-
Getting Started with the CData SSIS Components for Egnyte
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Egnyte.
-
Create Dynamic Trello Grids Using the Infragistics XamDataGrid
Learn how you can connect Trello to Infragistics XamDataGrid to build dynamic grids.
-
Work with Live OneNote Data in Power Query
Use CData Connect AI to connect to OneNote data and work with live OneNote data in Microsoft Power Query.
-
How to integrate Excel Online with Apache Airflow
Access and process Excel Online data in Apache Airflow using the CData JDBC Driver.
-
Integrate with Aweber Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Aweber data to a JSON file on disk.
-
Connect to Short.io Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Short.io and work with Short.io data in your FileMaker applications.
-
Bridge Autopilot Connectivity with Apache NiFi
Access and process Autopilot data in Apache NiFi using the CData JDBC Driver.
-
Automate Factorial Data Replication to Couchbase
Use CData Sync to Customize and automate Factorial data replication to Couchbase.
-
Automated Continuous RabbitMQ Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable RabbitMQ replication to delimited files (CSV/TSV).
-
Integrate Open WebUI with Live Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Salesforce CRM Analytics data from within the chat interface.
-
How to Visualize Excel Online Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Excel Online data in Python.
-
Build Google Spanner-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Spanner Data from Zoho Analytics and import live Google Spanner data.
-
How to connect to FreeAgent Data with Squirrel SQL client
Connect to FreeAgent data and execute queries in the Squirrel SQL Client.
-
Automate Sybase Data Replication to Azure Synapse
Use CData Sync to customize and automate Sybase data replication to Azure Synapse.
-
Access Live FormSite Data in AWS Lambda
Connect to live FormSite data in AWS Lambda using the CData JDBC Driver.
-
Connect to Power BI XMLA Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Power BI XMLA data.
-
Create Email-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Email Data from OutSystems and build custom enterprise apps using live Email data.
-
Build Salesforce Marketing-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Salesforce Marketing Data and create custom apps in Mendix.
-
DataBind Controls to Mistral AI Data in C++Builder
DataBind to Mistral AI data in C++Builder with standard components and controls.
-
How to Connect DBeaver to Freshservice via a JDBC Driver
Manage Freshservice data with visual tools in DBeaver like the query browser.
-
Connect to Live Highrise Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Highrise in CData Connect AI and connect to your Highrise data from PostgreSQL.
-
How to Query Live Yelp Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Yelp data data in natural language using Python.
-
Connect to Campaigner Data in HULFT Integrate
Connect to Campaigner as a JDBC data source in HULFT Integrate
-
Build Dashboards with Monday.com Data in Dundas BI
Create dynamic dashboards and perform analytics based on Monday.com data in Dundas BI.
-
Build Visualizations of SAS xpt Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAS xpt data in Birst.
-
Visualize Smartsheet 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 Smartsheet data into TIBCO Spotfire.
-
Connect to IBM Cloud Object Storage Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to IBM Cloud Object Storage.
-
Connecting GenSpark with Avro Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Avro data without any replication or custom integration required.
-
Use the CData ODBC Driver for Templated in Microsoft Power Query
You can use the CData Templated ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Templated data into Microsoft Power Query.
-
Create a Data Access Object for Google Drive Data using JDBI
A brief overview of creating a SQL Object API for Google Drive data in JDBI.
-
Choosing the Best Method to Connect Amazon Marketplace to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Amazon Marketplace data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Humanity-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Humanity data.
-
Connect to Dynamics CRM Data in RapidMiner
Integrate Dynamics CRM data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automate Superchat Data Replication to Azure Synapse
Use CData Sync to customize and automate Superchat data replication to Azure Synapse.
-
Access Live API 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 API data through MCP integration.
-
DataBind ServiceNow Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for ServiceNow with the DevExpress Windows Forms and Web controls to provide ServiceNow data to a chart.
-
Connect and Visualize Live Sage 300 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Sage 300 data into the Databricks platform and create visualization dashboards with real-time Sage 300 data.
-
Connect to DocuSign Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for DocuSign and the Script function in FileMaker Pro to connect to DocuSign and work with DocuSign data in your FileMaker application.
-
Connect and Query Live Square Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Square data into Databricks and enable direct, live querying and analysis without replication.
-
Building Dynamic Web Pages with Twilio Data Using AngularJS
Create single-page applications with live connectivity to Twilio using the CData API Server.
-
Connect to and Visualize Live LDAP Objects in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live LDAP objects.
-
How to Build an ETL App for eBay Data in Python with CData
Create ETL applications and real-time data pipelines for eBay data in Python with petl.
-
Connect to Gumroad from Asprova with CData Software ODBC Driver for Gumroad
This article shows how to connect faster to Gumroad data from Asprova.
-
How to Connect the Power BI Service to CSV: Complete Guide
Connect to the CData Software Power BI Connector for CSV from PowerBI.com to provide real-time CSV data across the organization.
-
Access Live XML Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate XML data into the statistical analysis tools available in SAS JMP. This article shows how to use XML data in the Graph Builder and Query Builder.
-
Use JayDeBeApi to access HBase Data in Python
Use standard Python scripting and the development environment of your choice to access live HBase data.
-
Connect to Freshteam Data in JRuby
Create a simple JRuby app with access to live Freshteam data.
-
Integrating Antigravity CLI with Testmonitor data via CData CLI
Connect Testmonitor data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Reports with Wrike Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Wrike data.
-
Connecting Mastra with Airtable 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 Airtable data, no replication required.
-
Query Live Cloudant Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Cloudant data through a conversational interface.
-
How to Connect the Power BI Service to PayPal: Complete Guide
Connect to the CData Software Power BI Connector for PayPal from PowerBI.com to provide real-time PayPal data across the organization.
-
Build Google Translate-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Translate data and build web apps with connectivity to live Google Translate data.
-
How to Connect to Live Snowflake 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 Snowflake data for you.
-
Connect to SFTP in SpagoBI
Create reports featuring live SFTP data in SpagoBI Studio. Host SFTP reports on SpagoBI Server.
-
Query Spark Data as a MySQL Database in Node.js
Execute MySQL queries against Spark data from Node.js.
-
How to Connect to Live Exa 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 Exa data for you.
-
Build MVC Applications with Connectivity to Google Sheets Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Sheets from an ASP.NET MVC application.
-
Visualize Excel Online Data in TIBCO Spotfire through OData
Integrate Excel Online data into dashboards in TIBCO Spotfire.
-
Consume Box OData Feeds in PowerBuilder
This article demonstrates how to consume Box data as OData feeds from PowerBuilder using the API Server.
-
Use Agno to Talk to Your Klipfolio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Klipfolio data for you.
-
Connect to Toggl Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Toggl data from Filemaker Pro on Mac.
-
Build Quickbase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Quickbase data and build web apps with connectivity to live Quickbase data.
-
Import and Visualize Ontraport Data in Power View
Create data visualizations based on Ontraport data in Excel.
-
Build Data Flows from Toggl to SQL Server using SSIS
Easily back up Toggl data to SQL Server using the SSIS components for Toggl.
-
Access Live SQL Server Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SQL Server data through MCP integration.
-
How to Connect to Live eBay 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 eBay data through natural language.
-
Use Manus AI to Talk to Your IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on IBM Informix data.
-
Create Vault CRM-Connected Nintex Workflows
Use CData Connect AI to connect to Vault CRM Data from Nintex Workflow Cloud and build custom workflows using live Vault CRM data.
-
Connect to Shopify Data in Google Apps Script via Connect AI
Use CData Connect AI to access Shopify data in Google Apps Script.
-
Build AI/ML Models with Live Cassandra Data using Dataiku
Connect Cassandra Data with Dataiku using the CData JDBC Driver for Cassandra.
-
Automated Continuous Amazon S3 Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Apache Cassandra.
-
Configure the CData JDBC Driver for Mailgun in a Connection Pool in Tomcat
Connect to Mailgun data from a connection pool in Tomcat.
-
Analyze SAP Fieldglass Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Fieldglass data in Microsoft R Open.
-
DataBind JobNimbus Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide JobNimbus data to a chart.
-
Replicate Multiple Pipeliner CRM Accounts
Replicate multiple Pipeliner CRM accounts to one or many databases.
-
How to Work with OnePageCrm Data in AWS Glue Jobs Using JDBC
Connect to OnePageCrm from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for Raisers Edge NXT in MicroStrategy
Connect to Raisers Edge NXT data in MicroStrategy Developer using the CData Software ODBC Driver for Raisers Edge NXT.
-
Visualize Dynamics NAV Data in Sisense
Create an ElastiCube in Sisense app with access to Dynamics NAV data.
-
Automated Continuous IBM Cloud Object Storage Replication to MongoDB
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to MongoDB.
-
Use the CData Software ODBC Driver for Cohere in SAS for Real-Time Reporting and Analytics
Connect to real-time Cohere data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cohere.
-
Connecting GenSpark with PostgreSQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to PostgreSQL data without any replication or custom integration required.
-
Access Live MailerLite Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live MailerLite data through MCP integration.
-
Access Google Translate Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Translate data from your Oracle system.
-
Automated Continuous Avaza Replication to MongoDB
Use CData Sync for automated, continuous, customizable Avaza replication to MongoDB.
-
Integrate Live ServiceNow Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to ServiceNow from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live ServiceNow data.
-
Build AI/ML Models with Live Webflow Data using Dataiku
Connect Webflow Data with Dataiku using the CData API Driver for JDBC.
-
Connect Facebook to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Facebook with IBM WebSphere for seamless data integration and connectivity.
-
Excel Spreadsheet Automation on MongoDB Data with the QUERY Formula
Pull data from MongoDB, automate spreadsheets, and more with the QUERY formula.
-
Build a Singer.io Tap for Google Ad Manager With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Ad Manager data using the CData Python Connector.
-
Process & Analyze Oracle Eloqua Reporting Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle Eloqua Reporting Data.
-
Build a Simple VCL Application for SingleStore Data
How to build a simple VCL Application to view SingleStore data in RAD Studio using the CData ODBC Driver for SingleStore.
-
Connect to Egnyte Data in RazorSQL
Connect to Egnyte from wizards and query Egnyte data from the GUI in the RazorSQL database management tool.
-
Connect to Eventbrite Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Eventbrite and the SQL Gateway to access Eventbrite data from Google Apps Script.