CData Software - Knowledge Base
Recent Articles
-
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, 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 Atlassian Confluence 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 from Web apps in Jetty.
-
Working with ZohoPeople Data in LINQPad
Execute LINQ queries to ZohoPeople in LINQPad.
-
Analyze Vault CRM Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Veeva Vault & Vault CRM 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 Accounting within intelligent agent workflows.
-
Connect to Tally Data in Ruby
Connect to Tally ERP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Exa Data in DBeaver
Use the CData ODBC Driver to connect to Exa in DBeaver.
-
Visualize Live Elorus Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Elorus.
-
Build Dashboards with Dynamics CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Dynamics CRM in DBxtra.
-
Connect to Invoiced Data in JRuby
Create a simple JRuby app with access to live Invoiced.
-
Replicate Azure Blob Storage Data in Heroku for Use in Salesforce Connect
Replicate Azure Blob Storage 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 in Jitterbit.
-
Integrate Sugar CRM Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sugar CRM and integrate live Sugar CRM into your Power Automate tasks.
-
Visualize Adobe Commerce Data in TIBCO Spotfire through ADO.NET
Integrate Adobe Commerce 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.
-
Publish Keap-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Keap.
-
How to Connect to Contentful Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Contentful. Leverage the pyodbc module for ODBC in Python.
-
Process & Analyze Delighted Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Delighted Data.
-
How to Query Live Certinia Data in Perplexity MacOS Desktop
Connect to and query live Certinia Data in Perplexity Desktop using CData MCP Server.
-
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 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 Azure Cosmos DB 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 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 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 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.
-
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
-
Build Reckon-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Reckon to explore live Reckon Data in GitHub Copilot to assist with building Reckon-powered applications.
-
Visualize Contentful Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Contentful.
-
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.
-
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 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 using standard SQL.
-
Replicate Outreach.io Data from PowerShell
Write a quick PowerShell script to query Outreach.io. Use connectivity to the live data to replicate Outreach.io to SQL Server.
-
Replicate Cloudant Data in Heroku for Use in Salesforce Connect
Replicate IBM Cloudant 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.
-
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 in Python.
-
Prepare, Blend, and Analyze HBase Data in Alteryx Designer (ODBC)
Build workflows to access live Apache HBase for self-service data analytics.
-
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 ERP/NetWeaver in Python.
-
How to connect SharePoint with Paylocity Data through external lists
Provide Paylocity to SharePoint users as an external list.
-
Build Apps with Live Airtable Data Using the Low-Code Development Platform of Mendix
Connect Airtable 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.
-
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 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 from your Google Sheets.
-
How to integrate Metabase with CockroachDB Data
Use CData Connect AI to connect to live CockroachDB and create an interactive dashboard in Metabase from CockroachDB.
-
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 CRM replication to Azure Synapse.
-
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 Google AlloyDB 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. You can visually build the import query or use any SQL supported by the driver.
-
Build Data Flows from SageHR to SQL Server using SSIS
Easily back up SageHR to SQL Server using the SSIS components for SageHR.
-
How to connect to ServiceNow Data with Squirrel SQL client
Connect to ServiceNow and execute queries in the Squirrel SQL Client.
-
ActiveCampaign Reporting in OBIEE with the ActiveCampaign JDBC Driver
Deploy the ActiveCampaign JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Publish Crystal Reports on AdRoll Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date AdRoll.
-
Connect to Oracle Financials Cloud Data in HULFT Integrate
Connect to Oracle Financials Cloud as a JDBC data source in HULFT Integrate
-
Automated Continuous Copper Replication to SQL Server
Use CData Sync for automated, continuous, customizable Copper replication to SQL Server.
-
Access Live Microsoft OneDrive Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft OneDrive from your Excel spreadsheets.
-
Back Up Apache HBase to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for HBase. In this article, we will employ an SSIS workflow to populate a database with Apache HBase data.
-
Getting Started with the CData ODBC Driver for Google Contacts
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Contacts.
-
How to Connect to Live HubSpot 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 HubSpot for you.
-
Connect to PagerDuty from a Connection Pool in WebLogic
Use the CData JDBC Driver for PagerDuty to connect to PagerDuty from Web applications running on WebLogic.
-
Rapidly Develop Onfleet-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 Onfleet.
-
Build an OLAP Cube in SSAS from Raisers Edge NXT Data
Establish a connection to Raisers Edge NXT data from SQL Server Analysis Services, and use the Raisers Edge NXT Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize SAS Data Sets Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAS Data Sets.
-
Automated Continuous Stack Exchange Replication to Vertica
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Vertica.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP SuccessFactors LMS using the Model Context Protocol.
-
Connect to FormSite Data from PowerBuilder via ADO.NET
This article demonstrates how to access FormSite from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Adobe Analytics Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Adobe Analytics Data and connect to Adobe Analytics in Akorbi Digital RunMyProcess.
-
Connect to SharePoint Excel Services Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SharePoint Excel Services using standard SQL.
-
Access Impala Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Apache Impala from HeidiSQL.
-
Build Automated Workflows with Live Avalara AvaTax Data in Workato
Use CData Connect AI to connect to live Avalara AvaTax and build automated workflows in Workato.
-
Connect to Jumpseller in SpagoBI
Create reports featuring live Jumpseller in SpagoBI Studio. Host Jumpseller reports on SpagoBI Server.
-
Connect to Short.io in SpagoBI
Create reports featuring live Short.io in SpagoBI Studio. Host Short.io reports on SpagoBI Server.
-
Building Dynamic Web Pages with OneNote Data Using AngularJS
Create single-page applications with live connectivity to OneNote using the CData API Server.
-
Use Claude to Talk to Your Spark 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 Apache Spark SQL for you.
-
How to Connect to GetResponse Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to GetResponse. Leverage the pyodbc module for ODBC in Python.
-
Bridge Google Sheets Connectivity with Apache NiFi
Access and process Google Sheets in Apache NiFi using the CData JDBC Driver.
-
How to Connect Flowise AI Agents to Live Oracle Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Oracle Database without replication.
-
Using the CData Software ODBC Driver for Demio in PyCharm
Connect to Demio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Demio.
-
Getting Started with the CData Python Connector for Guru
Learn to install and license the CData Python Connector
-
Use the CData Software ODBC Driver for Marketo in MicroStrategy Desktop
Connect to Marketo in MicroStrategy Desktop using the CData Software ODBC Driver for Marketo.
-
How to Access Live Google Directory Data in Visual Studio Code via Cline
Run CData MCP Server for Google Directory on Windows Subsytem for Linux (WSL) and connect to live Google Directory from the Cline extension in Visual Studio Code.
-
Connect to LionDesk Data from a Connection Pool in Jetty
The LionDesk JDBC Driver supports connection pooling: This article shows how to connect faster to LionDesk from Web apps in Jetty.
-
Connect to Retently Data in RapidMiner
Integrate Retently with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData ADO.NET Provider for Google Campaign Manager 360
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Campaign Manager 360.
-
Connecting Pipedream with API 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 API data in real time.
-
Back Up Bitly to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Bitly data.
-
Connect to Google Tasks Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Tasks from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Query Live Cosmos DB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure Cosmos DB data in natural language using Python.
-
Visualize Facebook Data in Sisense
Create an ElastiCube in Sisense app with access to Facebook.
-
Automated Continuous LionDesk Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LionDesk replication to OneLake in Microsoft Fabric.
-
Enable the XML JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with XML Files.
-
Connect to PolarTeamPro 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 PolarTeamPro and work with PolarTeamPro in your FileMaker application.
-
Natively Connect to Sage Intacct Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sage Intacct. Leverage the native support for ODBC in PHP.
-
Build Apps with Live Microsoft Exchange Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Exchange with Mendix to build apps using the CData JDBC Driver for Microsoft Exchange.