CData Software - Knowledge Base
Recent Articles
-
Connect to Zoom Data in HULFT Integrate
Connect to Zoom as a JDBC data source in HULFT Integrate
-
Connect to Chargebee Data in JRuby
Create a simple JRuby app with access to live Chargebee.
-
Access Live Oracle Service Cloud Data in Coginiti Pro
Connect to and query live Oracle Service Cloud from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous HubSpot Replication to MongoDB
Use CData Sync for automated, continuous, customizable HubSpot replication to MongoDB.
-
Integrating Dataiku with Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Snowflake.
-
Getting Started with the CData Excel Add-In for Microsoft Planner
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft Planner.
-
Build Zoho Creator Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zoho Creator and build visualizations in Tableau Cloud.
-
Build Sugar CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sugar CRM Data and create custom apps in Mendix.
-
Integrate Sybase IQ with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sybase IQ with External Services.
-
Build Charts with Quaderno Data in Clear Analytics
Create dynamic charts and perform analytics based on Quaderno in Clear Analytics.
-
How to Connect to Live Microsoft Planner 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 Microsoft Planner for you.
-
Automate Highrise Data Replication to Couchbase
Use CData Sync to Customize and automate Highrise CRM replication to Couchbase.
-
Connect to ShipEngine Data in NetBeans
Connect to ShipEngine in NetBeans with the data source configuration wizard.
-
Use Manus AI to Talk to Your SQL Server 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 Microsoft SQL Server.
-
Model Google Drive Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Drive, enabling the direct import of real-time Google Drive.
-
Choosing the Best Method to Connect Freshservice to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Freshservice from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Dashboards with Guru Data in DBxtra
Create dynamic dashboards and perform analytics based on Guru in DBxtra.
-
How to Connect to Live SharePoint Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Microsoft SharePoint for you.
-
How to Query Live Azure Analysis Services Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure Analysis Services data in natural language using Python.
-
How to Easily Query SAP Netweaver Gateway Data in OpenOffice Base
Connect to SAP Netweaver Gateway data in OpenOffice Base using the CData ODBC Driver for SAP Netweaver Gateway and generate reports with live data insights.
-
Integrate Typeform with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Typeform with External Services.
-
Integrate Jira Assets with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Jira Assets with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Jira Assets.
-
Edit and Search External Excel Online Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Excel Online to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Excel Online Data objects that you can access from apps and the dashboard.
-
Integrating LangGraph with Tally Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Tally ERP within automated workflows.
-
Use Biml to Build SSIS Tasks to Replicate Delighted Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Delighted to SQL Server.
-
Build Dashboards with Grafana Data in Dundas BI
Create dynamic dashboards and perform analytics based on Grafana in Dundas BI.
-
Use the CData Software ODBC Driver for Bullhorn CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Bullhorn CRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Bullhorn CRM.
-
Working with Oracle Data in LINQPad
Execute LINQ queries to Oracle Database in LINQPad.
-
Getting Started with the CData Excel Add-In for Aircall
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Aircall.
-
Provide OData Services of Amazon Marketplace Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Amazon Marketplace by developing a WCF Service Application.
-
Use the CData Software JDBC Driver for Instantly in MicroStrategy
Connect to Instantly in MicroStrategy Developer using the CData Software JDBC Driver for Instantly.
-
Load PostgreSQL Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PostgreSQL to a database.
-
Visualize Live SendInBlue Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SendInBlue.
-
Integrate Authorize.Net with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Authorize.Net with External Services.
-
Building Dynamic Web Pages with Stripe Data Using AngularJS
Create single-page applications with live connectivity to Stripe using the CData API Server.
-
Connect Parquet to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Parquet with IBM WebSphere for seamless data integration and connectivity.
-
How to integrate Metabase with Redshift Data
Use CData Connect AI to connect to live Amazon Redshift and create an interactive dashboard in Metabase from Amazon Redshift.
-
Replicate Harvest Data to Multiple Databases via the CData Sync CLI
Replicate Harvest to disparate databases with a single configuration.
-
Connect to Sage 300 Data in DBeaver
Use the CData ODBC Driver to connect to Sage 300 in DBeaver.
-
Visualize Live SAS xpt Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAS XPORT into custom reports in Power BI.
-
Process & Analyze Pipeliner CRM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Pipeliner CRM Data.
-
Create Spark-Connected Dashboards in Grafana
Connect to Spark Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Apache Spark SQL.
-
Integrate Beeminder Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Beeminder from Informatica Cloud.
-
Use Dash to Build to Web Apps on Google Contacts Data
Create Python applications that use pandas and Dash to build Google Contacts-connected web apps.
-
Create Data Visualizations in Cognos BI with Mailjet Data
Access Mailjet as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create SSAS Tabular Models from ZohoExpense Data
How to build a SQL Server Analysis Service Tabular Model from ZohoExpense using CData drivers.
-
Build Datadog-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Datadog and build web apps with connectivity to live Datadog.
-
Create Reports with Rebilly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Rebilly.
-
How to Query Coda Data in MySQL Workbench
Execute MySQL queries against live Coda from MySQL Workbench.
-
Visualize Act CRM Data in TIBCO Spotfire through ADO.NET
Integrate Act CRM into dashboards in TIBCO Spotfire.
-
Visualize SAP Ariba Source 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 SAP Ariba Source into TIBCO Spotfire.
-
Integrating LangGraph with Facebook Ads Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Facebook Ads within automated workflows.
-
Stream Testmonitor Data into Apache Kafka Topics
Access and stream Testmonitor in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Exa Data in RapidMiner
Integrate Exa with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData JDBC Driver for Clio
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Clio.
-
Connect to SageHR in SpagoBI
Create reports featuring live SageHR in SpagoBI Studio. Host SageHR reports on SpagoBI Server.
-
Build a Singer.io Tap for FreeAgent With the CData Python Connector
Learn how to easily build a Singer.io Tap for live FreeAgent data using
-
Build Agents in Relevance AI with Access to Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Exchange within intelligent agent workflows.
-
Access Live EmailOctopus Data in Coginiti Pro
Connect to and query live EmailOctopus from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Oracle Eloqua-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Oracle Eloqua to explore live Oracle Eloqua Data in GitHub Copilot to assist with building Oracle Eloqua-powered applications.
-
Connect to ADP Data from PowerBuilder via ADO.NET
This article demonstrates how to access ADP from Appeon PowerBuilder using the CData ADO.NET Provider for ADP.
-
Import Real-Time Presto Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Presto in ColdFusion.
-
Query SAP HANA XS Advanced Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP HANA XS Advanced and perform CRUD operations on SAP HANA XS Advanced from Node.js.
-
Visualize Google Translate Data in TIBCO Spotfire through ADO.NET
Integrate Google Translate into dashboards in TIBCO Spotfire.
-
Access Live Redis Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Redis from your Google Sheets.
-
Automated Continuous Confluence Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Confluence replication to Amazon S3.
-
How to Query Live Shopify Data in Perplexity MacOS Desktop
Connect to and query live Shopify Data in Perplexity Desktop using CData MCP Server.
-
Build Automated Sugar CRM-Connected Workflows in Zapier
Use CData Connect AI to connect to live Sugar CRM and build automated workflows in Zapier.
-
How to Seamlessly Import Adobe Commerce Data into IBM SPSS Modeler
Integrate Adobe Commerce data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to & Open CockroachDB Data in Microsoft Excel
This article uses the CData ODBC driver for CockroachDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Dropbox Data in CloverDX (formerly CloverETL)
Transfer Dropbox using the visual workflow in the CloverDX data integration tool.
-
Migrating data from Trello to Snowflake using CData SSIS Components.
Easily push Trello to Snowflake using the CData SSIS Tasks for Trello and Snowflake.
-
Integrate with Zoho CRM Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Zoho CRM in SnapLogic.
-
Use the CData Software ODBC Driver for Marketo in MicroStrategy Web
Connect to Marketo in MicroStrategy Web using the CData Software ODBC Driver for Marketo.
-
Getting Started with the CData Python Connector for SAP HANA XS Advanced
Learn to install and license the CData Python Connector
-
Getting Started with the CData ADO.NET Provider for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Query Twilio Data in ColdFusion
Write standard ColdFusion data access code to connect to Twilio.
-
Use JayDeBeApi to access iContact Data in Python
Use standard Python scripting and the development environment of your choice to access live iContact.
-
Automated Continuous CockroachDB Replication to AlloyDB
Use CData Sync for automated, continuous, customizable CockroachDB replication to AlloyDB.
-
Integrating EnterpriseDB Data in Talend Cloud Data Management Platform
Connect EnterpriseDB Data with Talend Cloud Data Management Platform using the CData JDBC Driver for EnterpriseDB.
-
Use Dash to Build to Web Apps on Jira Assets Data
Create Python applications that use pandas and Dash to build Jira Assets-connected web apps.
-
Process & Analyze Productboard Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Productboard Data.
-
Integrating LangGraph with Klaviyo Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Klaviyo within automated workflows.
-
How to Query Oracle Financials Cloud Data in MySQL Workbench
Execute MySQL queries against live Oracle Financials Cloud from MySQL Workbench.
-
Connect to Pushbullet Data in DBArtisan
Use wizards in DBArtisan to configure Pushbullet as a data source.
-
Use the CData Software ODBC Driver for Shortcut in SAS for Real-Time Reporting and Analytics
Connect to real-time Shortcut in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Shortcut.
-
Build Kintone-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Kintone and build Kintone-connected web apps with Axios.
-
Use Biml to Build SSIS Tasks to Replicate Supabase Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Supabase to SQL Server.
-
Visualize Live Yelp Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Yelp.
-
How to Build an ETL App for Google Drive Data in Python with CData
Create ETL applications and real-time data pipelines for Google Drive in Python with petl.
-
How to connect to Facebook Ads Data in DBVisualizer
Integrate Facebook Ads with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating GitHub Copilot CLI with ScrapingBee 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.
-
Connect to Omnisend from a Connection Pool in WebLogic
Use the CData JDBC Driver for Omnisend to connect to Omnisend from Web applications running on WebLogic.
-
Visualize Ontraport Data in Tableau
The CData ODBC driver for Ontraport enables you integrate Ontraport into Tableau dashboards.
-
Automated Continuous Tickspot Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Tickspot replication to PostgreSQL.
-
Integrate Live LinkedIn Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Visualize QuickBooks Time Data in TIBCO Spotfire through ADO.NET
Integrate QuickBooks Time into dashboards in TIBCO Spotfire.
-
Automated Continuous Sendwithus Replication to Vertica
Use CData Sync for automated, continuous, customizable Sendwithus replication to Vertica.
-
How to Connect Flowise AI Agents to Live GitLab 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 GitLab without replication.
-
ETL Perplexity in Oracle Data Integrator
This article shows how to transfer Perplexity into a data warehouse using Oracle Data Integrator.