CData Software - Knowledge Base
Recent Articles
-
Visualize Avro Data in Tableau
The CData ODBC driver for Avro enables you integrate Apache Avro into Tableau dashboards.
-
Use Dash to Build Web Apps on Sybase IQ Data via CData Connect AI
Build interactive Dash web apps on live Sybase IQ using pandas and the CData Connect AI Python SDK.
-
Configure the CData JDBC Driver for Oracle Eloqua in a Connection Pool in Tomcat
Connect to Oracle Eloqua from a connection pool in Tomcat.
-
Integrating Kiro CLI with Outreach.io 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 Reckon Data in DBVisualizer
Integrate Reckon with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Visualizations of Todoist Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Todoist in Birst.
-
Use Azure AI Foundry to Talk to Your HubSpot 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 HubSpot for you.
-
Access Live Box Data in TIBCO Data Virtualization
Use the Box Tibco DV Adapter to create a Box data source in TIBCO Data Virtualization Studio and gain access to live Box from your TDV Server.
-
Design BIRT Reports on FormSite Data
Provide current FormSite to your embedded analytics.
-
Getting Started with the CData Tableau Connector for FreeAgent
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Access Live Freshsales Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Freshsales into the statistical analysis tools available in SAS JMP. This article shows how to use Freshsales in the Graph Builder and Query Builder.
-
Build Zoho Inventory-Connected Apps in Choreo
Use CData Connect AI to connect to Zoho Inventory Data from Choreo and build custom apps using live Zoho Inventory.
-
Publish Crystal Reports on Google Translate Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Translate.
-
Integrate with AgileCRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy AgileCRM to a JSON file on disk.
-
Build a Singer.io Tap for Asana With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Asana data using
-
Automated Continuous Recurly Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Recurly replication to Amazon Redshift.
-
How to Connect SQL Server 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 SQL Server data in real time using natural language.
-
Visualize Bannerbear 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 Bannerbear into TIBCO Spotfire.
-
Stream NetSuite Data into Apache Kafka Topics
Access and stream NetSuite CRM & ERP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Work with Trello Data in ETL Validator JDBC
Connect to Trello from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate with live eBay Data in Jitterbit
Use CData Connect AI to connect to and integrate live eBay in Jitterbit.
-
Design BIRT Reports on Contentful Data
Provide current Contentful to your embedded analytics.
-
How to Access Live Zoho Projects Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoho Projects enables you to integrate Zoho Projects into workflows built using Microsoft Power Automate Desktop.
-
Access Live Xero 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 Xero Accounting through MCP integration.
-
Integrate NetSuite Data into Power Automate Desktop using CData Connect
CData Connect for NetSuite Data enables you to integrate NetSuite CRM & ERP into workflows built using Microsoft Power Automate Desktop.
-
Use Claude to Talk to Your Microsoft OneDrive 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 Microsoft OneDrive for you.
-
Query VWO Data in DataGrip
Create a Data Source for VWO in DataGrip and use SQL to query live VWO.
-
Build AI/ML Models with Live Templated Data using Dataiku
Connect Templated Data with Dataiku using the CData API Driver for JDBC.
-
Use Microsoft Copilot Studio to talk to your IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your IBM Informix for you.
-
Create Power BI Reports on Real-Time SAS Data Sets Data
Use the CData ODBC Driver for SAS Data Sets to visualize SAS Data Sets in Power BI Desktop.
-
Connect to Google Search Results from a Connection Pool in Jetty
The Google Search JDBC Driver supports connection pooling: This article shows how to connect faster to Google Search from Web apps in Jetty.
-
Automated Continuous Freshdesk Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Freshdesk replication to Apache Cassandra.
-
Automated Continuous Amplitude Replication to MySQL
Use CData Sync for automated, continuous, customizable Amplitude replication to MySQL.
-
Connect to Humanity Data in DBArtisan
Use wizards in DBArtisan to configure Humanity as a data source.
-
How to connect Amazon QuickSight to Vertica Data
Create a connection to Vertica in CData Connect AI and insert Vertica into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect and Visualize Live Dynamics 365 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Dynamics 365 into the Databricks platform and create visualization dashboards with real-time Microsoft Dynamics 365.
-
Getting Started with the CData JDBC Driver for Microsoft Dataverse
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Microsoft Dataverse.
-
Add Supabase Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Supabase with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live Bullhorn CRM Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Bullhorn CRM and integrate live Bullhorn CRM into apps built in Microsoft Power Apps.
-
Integrating Cursor CLI with Tickspot 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.
-
Connecting to Any ODBC Data Source as a Linked Server
Use the TDS Remoting feature of the SQL Gateway to set up a linked server for any CData ODBC data source.
-
Create Datasets from Sendwithus in Domo Workbench and Build Visualizations of Sendwithus Data in Domo
Use the CData Software ODBC Driver for Sendwithus to create datasets from Sendwithus in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Avro Replication to Vertica
Use CData Sync for automated, continuous, customizable Avro replication to Vertica.
-
Visualize QuickBooks Online Data in TIBCO Spotfire through ADO.NET
Integrate QuickBooks Online into dashboards in TIBCO Spotfire.
-
Stream Brex Data into Apache Kafka Topics
Access and stream Brex in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Voice Agents in ElevenLabs with access to Live Cassandra Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Apache Cassandra.
-
DataBind Charts to Intercom Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Intercom 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.
-
How to Connect to Live Smartsheet 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 Smartsheet for you.
-
Access Live WooCommerce Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live WooCommerce data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use Dash to Build to Web Apps on Tickspot Data
Create Python applications that use pandas and Dash to build Tickspot-connected web apps.
-
Create Google Sheets-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Sheets Data from Klipfolio and build custom visualizations using live Google Sheets.
-
Create Informatica Mappings From/To a JDBC Data Source for Okta
Create Okta data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Edit and Search Suadeo External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Suadeo to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Suadeo objects that you can access from apps and the dashboard.
-
LINQ to Blackbaud FE NXT 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 Blackbaud FE NXT Data Provider.
-
Connect to Mailjet in SpagoBI
Create reports featuring live Mailjet in SpagoBI Studio. Host Mailjet reports on SpagoBI Server.
-
How to Connect to Live Zoom 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 Zoom without replication.
-
Import Real-Time Clari Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Clari in ColdFusion.
-
Use JayDeBeApi to access Zoho Books Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoho Books.
-
How to connect to Paddle Data with Squirrel SQL client
Connect to Paddle and execute queries in the Squirrel SQL Client.
-
Query Parquet Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Apache Parquet from Node.js.
-
Integrate Cursor with Live Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Directory from within the editor.
-
Create Informatica Mappings From/To an ODBC Data Source for Zoom
Create an ODBC connection to Zoom in Informatica and browse and transfer Zoom.
-
Getting Started with the CData Tableau Connector for Salesforce Marketing
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Salesforce Marketing.
-
Query Zoho Inventory Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zoho Inventory from Node.js.
-
Automated Continuous Sage Intacct Replication to SQLite
Use CData Sync for automated, continuous, customizable Sage Intacct replication to SQLite.
-
Visualize Helpscout Data in TIBCO Spotfire through ADO.NET
Integrate Helpscout into dashboards in TIBCO Spotfire.
-
Integrating LlamaIndex with Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Calendar in real time.
-
Edit and Search SAP Fieldglass External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAP Fieldglass to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP Fieldglass objects that you can access from apps and the dashboard.
-
How to Query Live Twilio Data in Perplexity MacOS Desktop
Connect to and query live Twilio Data in Perplexity Desktop using CData MCP Server.
-
Access Live SendGrid Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SendGrid in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Live Marketo Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Marketo directly from the development environment.
-
Access Live BigQuery Data in TIBCO Data Virtualization
Use the BigQuery Tibco DV Adapter to create a Google BigQuery data source in TIBCO Data Virtualization Studio and gain access to live Google BigQuery from your TDV Server.
-
How to Connect DBeaver to Asana via a JDBC Driver
Manage Asana with visual tools in DBeaver like the query browser.
-
Build Agents in Relevance AI with Access to Live Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zoho CRM within intelligent agent workflows.
-
Analyze Xero Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Xero Accounting with the CData JDBC Driver for Xero.
-
A PostgreSQL Interface for Deel Data using the CData ODBC Driver
Use the SQL Gateway and Deel ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Zendesk Data from MySQL in Amazon QuickSight
Connect to Zendesk and build visualizations of Zendesk using a MySQL Connection in Amazon QuickSight.
-
Access OpenWeatherMap Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access OpenWeatherMap from your Oracle system.
-
Integrate Trello Data in the Pentaho Report Designer
Publish reports based on Trello in the Pentaho BI tool.
-
Automated Continuous Splunk Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Splunk replication to PostgreSQL.
-
Analyze SAP Ariba Source Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Ariba Source from Power Pivot. You will use the Table Import Wizard to load SAP Ariba Source. You can visually build the import query or use any SQL supported by the driver.
-
Write a Simple Go Application to work with Microsoft Planner Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Planner.
-
Automated Continuous Zoho Creator Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Google BigQuery.
-
Getting Started with the CData ADO.NET Provider for Reckon
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Reckon.
-
Integrate LibreChat with Live Google Cloud Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Cloud Storage from within the chat interface.
-
Connect to EmailOctopus Data in JRuby
Create a simple JRuby app with access to live EmailOctopus.
-
Connect to SAP Fieldglass Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAP Fieldglass Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use CData Connect AI to Access Workday Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Workday in the Power Pivot business intelligence tool.
-
Build MVC Applications with Connectivity to Couchbase Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Couchbase from an ASP.NET MVC application.
-
Use Dash to Build to Web Apps on SAP Netweaver Gateway Data
Create Python applications that use pandas and Dash to build SAP Netweaver Gateway-connected web apps.
-
How to Connect to & Open RabbitMQ Data in Microsoft Excel
This article uses the CData ODBC driver for RabbitMQ to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Excel-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Excel and build web apps with connectivity to live Microsoft Excel.
-
How to Access Live Facebook Ads Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Facebook Ads enables you to integrate Facebook Ads into workflows built using Microsoft Power Automate Desktop.
-
How to use SQLAlchemy ORM to access Klaviyo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Klaviyo.
-
Use Biml to Build SSIS Tasks to Replicate Drift Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Drift to SQL Server.
-
Connect Scrapfly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Scrapfly with IBM WebSphere for seamless data integration and connectivity.
-
How to load Nuclia data into Elasticsearch via Logstash
Introducing a simple method to load Nuclia data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Datasets from MongoDB in Domo Workbench and Build Visualizations of MongoDB Data in Domo
Use the CData Software ODBC Driver for MongoDB to create datasets from MongoDB in Domo Workbench and then build visualizations in the Domo service.
-
LINQ to Notion 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 Notion Data Provider.
-
Migrating data from Active Directory to Databricks using CData SSIS Components.
Easily push Active Directory to Databricks using the CData SSIS Tasks for Active Directory and Databricks.