CData Software - Knowledge Base
Recent Articles
-
Use Claude to Talk to Your Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Basecamp data for you.
-
Using the CData Software ODBC Driver for Google Campaign Manager 360 in PyCharm
Connect to Google Campaign Manager 360 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Campaign Manager 360.
-
Visualize SingleStore Data in Tableau
The CData ODBC driver for SingleStore enables you integrate SingleStore data into Tableau dashboards.
-
Interact with Live FHIR Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live FHIR data.
-
How to publish and share HelloSign Data dashboards with Tableau Server
The CData ODBC driver for HelloSign enables you integrate HelloSign data into Tableau dashboards.
-
Automated Continuous ShipStation Replication to SingleStore
Use CData Sync for automated, continuous, customizable ShipStation replication to SingleStore.
-
How to connect Amazon QuickSight to Facebook Data
Create a connection to Facebook data in CData Connect AI and insert Facebook data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Query Live Zoho Books Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zoho Books data data in natural language using Python.
-
Integrating GitHub Copilot with Sendwithus 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 ZohoInvoice-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ZohoInvoice Data from Zoho Analytics and import live ZohoInvoice data.
-
Connect to Jodoo Data in DBeaver
Use the CData ODBC Driver to connect to Jodoo data in DBeaver.
-
Integrate with Live Highrise Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Highrise from the MuleSoft Anypoint Platform to integrate live Highrise data into custom reports and dashboards.
-
How to use SQLAlchemy ORM to access Avaza Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Avaza data.
-
How to Work with AfterShip Data in ETL Validator JDBC
Connect to AfterShip from ETL Validator jobs using the CData Software JDBC Driver.
-
Publish Freshdesk-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Freshdesk data.
-
Build MVC Applications with Connectivity to Epicor Kinetic Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Epicor Kinetic from an ASP.NET MVC application.
-
Integrate with Live Square Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Square from the MuleSoft Anypoint Platform to integrate live Square data into custom reports and dashboards.
-
Build Wistia-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Wistia data and build web apps with connectivity to live Wistia data.
-
Visualize Anaplan Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Anaplan data.
-
Create Dynamic Sage 200 Grids Using the Infragistics XamDataGrid
Learn how you can connect Sage 200 to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous CloudConvert Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable CloudConvert replication to Google BigQuery.
-
Connect to Paylocity 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 Paylocity data.
-
Import Office 365 Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Office 365 Data and provide access to live Office 365 data for custom reports in the Power BI Service.
-
Building Dynamic Web Pages with ADP Data Using AngularJS
Create single-page applications with live connectivity to ADP using the CData API Server.
-
Connect to Adobe Experience Manager Data in NetBeans
Connect to Adobe Experience Manager data in NetBeans with the data source configuration wizard.
-
Use the CData Software ODBC Driver for Kintone in MicroStrategy Desktop
Connect to Kintone data in MicroStrategy Desktop using the CData Software ODBC Driver for Kintone.
-
Use the CData Software JDBC Driver for Impala in MicroStrategy Desktop
Connect to Impala data in MicroStrategy Desktop using the CData Software JDBC Driver for Impala.
-
Query SAP Ariba Source Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Ariba Source data.
-
Access Live ShipStation Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ShipStation data from your Excel spreadsheets.
-
Connect to Teradata Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Teradata data in the Denodo Virtual DataPort Administrator.
-
Access Live Parallel Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Parallel data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
DataBind Controls to Nuclia Data in Delphi
DataBind to Nuclia data in Delphi with standard data access components and controls.
-
Integrate Live SFTP Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live SFTP data from within the IDE.
-
Rapidly Develop Testmonitor-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 Testmonitor.
-
How to Connect Google Forms Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Forms data in real time using natural language.
-
Build Sage Intacct Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Sage Intacct data and build visualizations in Tableau Cloud.
-
Analyze Live Epicor Kinetic Data in SAS Viya
Use CData Connect AI to connect to Epicor Kinetic data from SAS Viya and deploy self-service analytics using live Epicor Kinetic data.
-
Getting Started with the CData Connect AI Python SDK for ConstantContact
Install the CData Connect AI Python SDK to read live ConstantContact data with standard DB-API 2.0 Python code.
-
Analyze Vertica Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Vertica data and visualize live Vertica data in Infragistics Reveal.
-
How to Create Power BI Visual Reports with Real-Time SendPulse Data
Use CData Power BI Connectors to visualize SendPulse data in Power BI.
-
Manage Greenplum Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Greenplum.
-
Viewing Cohere Data in RAD Studio Data Explorer
How to view Cohere data in RAD Studio Data Explorer using the CData ODBC Driver for Cohere.
-
Process & Analyze Flowlu Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Flowlu Data.
-
Connect to ZohoPeople Data in Google Apps Script via Connect AI
Use CData Connect AI to access ZohoPeople data in Google Apps Script.
-
DocuSign Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on DocuSign facts in real time.
-
How to integrate Metabase with Azure Analysis Services Data
Use CData Connect AI to connect to live Azure Analysis Services data and create an interactive dashboard in Metabase from Azure Analysis Services data.
-
Getting Started with the CData Python Connector for Customer.io
Learn to install and license the CData Python Connector and configure a connection to live Customer.io data.
-
Use JayDeBeApi to access Azure Analysis Services Data in Python
Use standard Python scripting and the development environment of your choice to access live Azure Analysis Services data.
-
Create Datasets from REST in Domo Workbench and Build Visualizations of REST Data in Domo
Use the CData Software ODBC Driver for REST to create datasets from REST data in Domo Workbench and then build visualizations in the Domo service.
-
Provide OData Services of Oracle Financials Cloud Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle Financials Cloud data by developing a WCF Service Application.
-
Access Live Gong Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Gong data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Back Up MailChimp data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MailChimp. In this article, we will employ an SSIS workflow to populate a database with MailChimp data data.
-
Configure the CData JDBC Driver for QuickBooks in a Connection Pool in Tomcat
Connect to QuickBooks data from a connection pool in Tomcat.
-
Import Slack Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Slack Data and provide access to live Slack data for custom reports in the Power BI Service.
-
Build Dashboards with Azure Analysis Services Data in DBxtra
Create dynamic dashboards and perform analytics based on Azure Analysis Services data in DBxtra.
-
How to Query Live Bullhorn CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Bullhorn CRM data data in natural language using Python.
-
Getting Started with the CData Connect AI Python SDK for IBM Cloud Object Storage
Install the CData Connect AI Python SDK to read live IBM Cloud Object Storage data with standard DB-API 2.0 Python code.
-
Connect to RabbitMQ Data from a Connection Pool in Jetty
The RabbitMQ JDBC Driver supports connection pooling: This article shows how to connect faster to RabbitMQ data from Web apps in Jetty.
-
Connect to SAP Ariba Source from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Ariba Source to connect to SAP Ariba Source data from Web applications running on WebLogic.
-
Create Kintone-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Kintone Data from Klipfolio and build custom visualizations using live Kintone data.
-
Getting Started with the CData JDBC Driver for Pipeline CRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Pipeline CRM.
-
Build AI Agents with Shopify Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Shopify data through CData Connect AI.
-
Build Voice Agents in ElevenLabs with access to Live Power BI XMLA Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Power BI XMLA data.
-
Workday Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Workday facts in real time.
-
Write a Simple Go Application to work with Webflow Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Webflow data.
-
Prepare, Blend, and Analyze Cloudflare Data in Alteryx Designer (ODBC)
Build workflows to access live Cloudflare data for self-service data analytics.
-
Connect to Cohere Data in Jaspersoft Studio
Execute SQL to remote Cohere data in Jaspersoft Studio.
-
Connect to GitLab Data in NetBeans
Connect to GitLab data in NetBeans with the data source configuration wizard.
-
Viewing Jodoo Data in RAD Studio Data Explorer
How to view Jodoo data in RAD Studio Data Explorer using the CData ODBC Driver for Jodoo.
-
Rapidly Develop QuickBooks-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 QuickBooks.
-
Build Google Directory-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Directory Data and create custom apps in Mendix.
-
How to work with ZohoPeople Data in Apache Spark using SQL
Access and process ZohoPeople Data in Apache Spark using the CData Software JDBC Driver.
-
Build Charts with Bugsnag Data in Clear Analytics
Create dynamic charts and perform analytics based on Bugsnag data in Clear Analytics.
-
Connect to Google Sheets Data in RapidMiner
Integrate Google Sheets data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect to Qualaroo Data with Squirrel SQL client
Connect to Qualaroo data and execute queries in the Squirrel SQL Client.
-
Design BIRT Reports on GitLab Data
Provide current GitLab data to your embedded analytics.
-
Integrate Real-Time Access to CSV in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to CSV data in real time.
-
Connecting GenSpark with Samanage Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Samanage data without any replication or custom integration required.
-
LINQ to RabbitMQ 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 RabbitMQ Data Provider.
-
Connecting Pipedream with Azure Analysis Services 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 Azure Analysis Services data in real time.
-
Add Zoho Projects Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoho Projects with the Informatica Enterprise Data Catalog to classify and organize data.
-
Query Discord Data as a SQL Server Database in Node.js
Execute SQL Server queries against Discord data from Node.js.
-
Object-Relational Mapping (ORM) with Basecamp 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 Basecamp data into a Java-based ORM framework, Hibernate.
-
Deploy the ADO.NET Provider for Freshdesk on an SSRS Report Server
Connect to Freshdesk data 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.
-
Integrate Bitly Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Bitly data from Informatica Cloud.
-
Connect to Google Translate Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Translate and the SQL Gateway to access Google Translate data from Google Apps Script.
-
Build AI/ML Models with Live Sendwithus Data using Dataiku
Connect Sendwithus Data with Dataiku using the CData API Driver for JDBC.
-
Rapidly Develop Missive-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 Missive.
-
Build a Singer.io Tap for LinkedIn Ads With the CData Python Connector
Learn how to easily build a Singer.io Tap for live LinkedIn Ads data using the CData Python Connector.
-
Integrate Dify with Live Adobe Analytics Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Adobe Analytics data.
-
Visualize Cloudant Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Cloudant data.
-
Use the CData ODBC Driver for Testmonitor in Microsoft Power Query
You can use the CData Testmonitor ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Testmonitor data into Microsoft Power Query.
-
LINQ to ZohoExpense 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 ZohoExpense Data Provider.
-
Working with Square Data in LINQPad
Execute LINQ queries to Square data in LINQPad.
-
How to Visualize Google Analytics 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 Google Analytics data in Python.
-
Import Real-Time Smartsheet Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Smartsheet data in ColdFusion.
-
Build Impala Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Impala data and build visualizations in Tableau Cloud.
-
Connect to Gmail Data in RazorSQL
Connect to Gmail from wizards and query Gmail data from the GUI in the RazorSQL database management tool.
-
Integrate Google's Vertex AI Agent with Live DocuSign 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 DocuSign data within intelligent workflows.
-
Use Azure AI Foundry to Talk to Your Wistia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Wistia data for you.