CData Software - Knowledge Base
Recent Articles
-
Create Datasets from Gong in Domo Workbench and Build Visualizations of Gong Data in Domo
Use the CData Software ODBC Driver for Gong to create datasets from Gong data in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to Live Kafka 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 Kafka data through natural language.
-
Getting Started with the CData Tableau Connector for MessageBird
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use Azure AI Foundry to Talk to Your Greenplum 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 Greenplum data for you.
-
Integrate OData with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate OData with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to OData services.
-
Use Azure AI Foundry to Talk to Your Google Campaign Manager 360 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 Google Campaign Manager 360 data for you.
-
Connect to SAP HANA XS Advanced Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP HANA XS Advanced data in Airbyte.
-
How to Work with Amazon DynamoDB Data in ETL Validator JDBC
Connect to Amazon DynamoDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Dash to Build to Web Apps on Zuora Data
Create Python applications that use pandas and Dash to build Zuora-connected web apps.
-
Build Dashboards with MailerLite Data in Dundas BI
Create dynamic dashboards and perform analytics based on MailerLite data in Dundas BI.
-
How to Work with ServiceDesk Plus Data in ETL Validator JDBC
Connect to ServiceDesk Plus from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData SSIS Components for SparkPost
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SparkPost.
-
Bind Live Salesloft Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Salesloft data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connecting Pipedream with HBase 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 HBase data in real time.
-
Integrate with Printful Data in JReport Designer
Create charts and reports based on Printful data in JReport Designer.
-
Connecting Mastra with Microsoft Exchange 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 Microsoft Exchange data, no replication required.
-
Integrate Square Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Square data and integrate live Square data into your Power Automate tasks.
-
Create Dynamic NASA Grids Using the Infragistics XamDataGrid
Learn how you can connect NASA to Infragistics XamDataGrid to build dynamic grids.
-
Connect and Query Live Smartsheet Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Smartsheet data into Databricks and enable direct, live querying and analysis without replication.
-
Connecting Agentforce with Dropbox Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Dropbox data for you.
-
Bugsnag Reporting in OBIEE with the Bugsnag JDBC Driver
Deploy the Bugsnag JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Slack Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Slack replication to Azure SQL Database.
-
How to integrate Metabase with Klipfolio Data
Use CData Connect AI to connect to live Klipfolio data and create an interactive dashboard in Metabase from Klipfolio data.
-
Creating Microsoft Ads-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft Ads data to Unqork and build custom business apps.
-
How to Connect to Live Shippo 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 Shippo data for you.
-
Connect to SAS xpt Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAS xpt as an External Source in Dremio.
-
Edit and Search External Kafka Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Kafka data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Kafka Data objects that you can access from apps and the dashboard.
-
Extract, Transform, and Load Reply.io Data in Informatica PowerCenter
Create a simple Workflow for Reply.io data in Informatica PowerCenter.
-
Query Oracle HCM Cloud Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle HCM Cloud data from Node.js.
-
Query Salesforce CRM Analytics Data in DataGrip
Create a Data Source for Salesforce CRM Analytics in DataGrip and use SQL to query live Salesforce CRM Analytics data.
-
Connect and Visualize Live HBase Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live HBase data into the Databricks platform and create visualization dashboards with real-time HBase data.
-
Build Voice Agents in ElevenLabs with access to Live Smartsheet Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Smartsheet data.
-
Automated Continuous Intercom Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Intercom replication to Google BigQuery.
-
Integrate Google Search Results into Power Automate Desktop using CData Connect
CData Connect for Google Search Results enables you to integrate Google Search results into workflows built using Microsoft Power Automate Desktop.
-
Connect to BambooHR Data from PowerBuilder via JDBC
This article demonstrates how to access BambooHR data from PowerBuilder using the BambooHR JDBC Driver.
-
Integrate Cursor with Live Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Apollo data from within the editor.
-
Use Dash to Build to Web Apps on MailerLite Data
Create Python applications that use pandas and Dash to build MailerLite-connected web apps.
-
Access Salesforce Data from MySQL in Amazon QuickSight
Connect to Salesforce and build visualizations of Salesforce data using a MySQL Connection in Amazon QuickSight.
-
Analyze Google Campaign Manager 360 Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Campaign Manager 360 data with the CData JDBC Driver for Google Campaign Manager 360.
-
A Performance Comparison of Drivers for MongoDB
An article comparing the read performance of CData Software Drivers for MongoDB.
-
Connect to MongoDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from MongoDB data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connecting Agentforce with Confluence Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Confluence data for you.
-
Connect to Sentry Data from a Connection Pool in Jetty
The Sentry JDBC Driver supports connection pooling: This article shows how to connect faster to Sentry data from Web apps in Jetty.
-
Working with ZohoPeople Data in LINQPad
Execute LINQ queries to ZohoPeople data in LINQPad.
-
Analyze Vault CRM Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Vault CRM data with the CData JDBC Driver for Vault CRM.
-
Automated Continuous Wrike Replication to SQL Server
Use CData Sync for automated, continuous, customizable Wrike replication to SQL Server.
-
Build Agents in Relevance AI with Access to Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Xero data within intelligent agent workflows.
-
Connect to Tally Data in Ruby
Connect to Tally data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate LibreChat with Live Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Azure Data Catalog data from within the chat interface.
-
Connect to Exa Data in DBeaver
Use the CData ODBC Driver to connect to Exa data in DBeaver.
-
Visualize Live Elorus Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Elorus data.
-
Build Dashboards with Dynamics CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Dynamics CRM data in DBxtra.
-
Connect to Invoiced Data in JRuby
Create a simple JRuby app with access to live Invoiced data.
-
Replicate Azure Blob Storage Data in Heroku for Use in Salesforce Connect
Replicate Azure Blob Storage data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate with live Lakebase Data in Jitterbit
Use CData Connect AI to connect to and integrate live Lakebase data in Jitterbit.
-
Integrate Sugar CRM Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sugar CRM data and integrate live Sugar CRM data into your Power Automate tasks.
-
Visualize Adobe Commerce Data in TIBCO Spotfire through ADO.NET
Integrate Adobe Commerce data into dashboards in TIBCO Spotfire.
-
How to Seamlessly Import ZeroBounce Data into IBM SPSS Modeler
Integrate ZeroBounce data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect Figshare 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 Figshare data in real time using natural language.
-
Publish Keap-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Keap data.
-
How to Connect to Contentful Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Contentful data. Leverage the pyodbc module for ODBC in Python.
-
Create Samanage-Connected Applications in Appsmith
Connect to Samanage Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Samanage data.
-
Getting Started with the CData ODBC Driver for Elorus
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Elorus.
-
Integrate with Shopify Data in JReport Designer
Create charts and reports based on Shopify data in JReport Designer.
-
Build Pipelines with Live Cosmos DB Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Cosmos DB from Google Cloud Data Fusion, enabling the integration of live Cosmos DB data into the building and management of effective data pipelines.
-
Integrating Zoho Creator Data in Talend Cloud Data Management Platform
Connect Zoho Creator Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Zoho Creator.
-
Create a Data Access Object for MailerLite Data using JDBI
A brief overview of creating a SQL Object API for MailerLite data in JDBI.
-
How to create Bitbucket federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Bitbucket data in MySQL .
-
How to Connect to Live Zoho CRM Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Zoho CRM data for you.
-
Use Manus AI to Talk to Your Databricks 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 Databricks data.
-
Bind Live Amazon Athena Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Amazon Athena data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Visualize Contentful Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Contentful data.
-
Access Jira Assets 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 Jira Assets data.
-
View Reports on Real-Time Adobe Target Data in Power BI Report Server
Use the CData ODBC Driver for Adobe Target to visualize Adobe Target data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Everhour Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Everhour data using standard SQL.
-
Integrate with live SFTP Data in Jitterbit
Use CData Connect AI to connect to and integrate live SFTP data in Jitterbit.
-
Replicate Outreach.io Data from PowerShell
Write a quick PowerShell script to query Outreach.io data. Use connectivity to the live data to replicate Outreach.io data to SQL Server.
-
Replicate Cloudant Data in Heroku for Use in Salesforce Connect
Replicate Cloudant data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Operational Reporting on Clio Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Clio data.
-
How to Visualize GraphQL 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 GraphQL data in Python.
-
Prepare, Blend, and Analyze HBase Data in Alteryx Designer (ODBC)
Build workflows to access live HBase data for self-service data analytics.
-
Build Apps with Live Aweber data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Aweber data into the Adalo platform and build custom mobile and web applications with real-time Aweber data.
-
Automated Continuous Adobe Commerce Replication to Oracle
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Oracle.
-
How to Visualize SAP Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP data in Python.
-
How to connect SharePoint with Paylocity Data through external lists
Provide Paylocity data to SharePoint users as an external list.
-
Build Apps with Live Airtable Data Using the Low-Code Development Platform of Mendix
Connect Airtable data with Mendix to build apps using the CData JDBC Driver for Airtable.
-
Getting Started with the CData Power BI Connector for SAP Business Warehouse
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Business Warehouse.
-
How to use SQLAlchemy ORM to access Zoho Books Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoho Books data.
-
How to load Mocean data into Elasticsearch via Logstash
Introducing a simple method to load Mocean data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Model, Search, and Visualize Live Microsoft Exchange Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Exchange data for modeling, searching, and visualizing.
-
Access Live Kintone Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Kintone data from your Google Sheets.
-
How to integrate Metabase with CockroachDB Data
Use CData Connect AI to connect to live CockroachDB data and create an interactive dashboard in Metabase from CockroachDB data.
-
How to Seamlessly Import Facebook Ads Data into IBM SPSS Modeler
Integrate Facebook Ads data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automate Highrise Data Replication to Azure Synapse
Use CData Sync to customize and automate Highrise data replication to Azure Synapse.
-
Create Klipfolio-Connected Dashboards in Grafana
Connect to Klipfolio Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Klipfolio data.
-
How to Connect to Live AlloyDB 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 AlloyDB data for you.
-
Analyze Planio Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Planio from Power Pivot. You will use the Table Import Wizard to load Planio data. You can visually build the import query or use any SQL supported by the driver.
-
Automated CircleCI Data Replication to Teradata
Use CData Sync to Customize and automate CircleCI data replication to Teradata.
-
Build Data Flows from SageHR to SQL Server using SSIS
Easily back up SageHR data to SQL Server using the SSIS components for SageHR.
-
How to connect to ServiceNow Data with Squirrel SQL client
Connect to ServiceNow data and execute queries in the Squirrel SQL Client.