CData Software - Knowledge Base
Recent Articles
-
Choosing the Best Method to Connect Smartsheet to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Smartsheet data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to EmailOctopus in SpagoBI
Create reports featuring live EmailOctopus data in SpagoBI Studio. Host EmailOctopus reports on SpagoBI Server.
-
Integrating Antigravity CLI with REST data via CData CLI
Connect REST data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Live TaxJar Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to TaxJar from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live TaxJar data.
-
Connect to Discord Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Discord.
-
Build Voice Agents in ElevenLabs with access to Live Testmonitor Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Testmonitor data.
-
Access AlloyDB 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 AlloyDB data.
-
Build Automated Workflows with Live Sugar CRM Data in Workato
Use CData Connect AI to connect to live Sugar CRM data and build automated workflows in Workato.
-
Connect to Nuclia in SpagoBI
Create reports featuring live Nuclia data in SpagoBI Studio. Host Nuclia reports on SpagoBI Server.
-
Build MVC Applications with Connectivity to SAP HANA XS Advanced Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP HANA XS Advanced from an ASP.NET MVC application.
-
Build AI Agents with Jumpseller 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 Jumpseller data through CData Connect AI.
-
Integrate Dify with Live Smartsheet 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 Smartsheet data.
-
Build Visualizations of ChartMogul Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ChartMogul data in Birst.
-
Integrate Real-Time Access to Twilio in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Twilio data in real time.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LeadDesk
Provide connectivity to LeadDesk data through an SAP BusinessObjects universe.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Ariba Procurement
Provide connectivity to SAP Ariba Procurement data through an SAP BusinessObjects universe.
-
Create Sugar CRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Sugar CRM data access from reports, embedded analytics, and more.
-
Automated Continuous Helpscout Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Helpscout replication to Apache Cassandra.
-
Automated Cassandra Data Replication to Teradata
Use CData Sync to Customize and automate Cassandra data replication to Teradata.
-
Stream Cloudflare Data into Apache Kafka Topics
Access and stream Cloudflare data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Google Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Ads replication to SQL Server.
-
Automated Continuous Oracle Replication to Snowflake
Use CData Sync for automated, continuous, customizable Oracle replication to Snowflake.
-
Automated Continuous DB2 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable DB2 replication to Amazon Redshift.
-
Getting Started with the CData Excel Add-In for Templated
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Templated.
-
Connect to Bitly from a Connection Pool in WebLogic
Use the CData JDBC Driver for Bitly to connect to Bitly data from Web applications running on WebLogic.
-
Getting Started with the CData ODBC Driver for Google Directory
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Directory.
-
Automated Continuous Campaigner Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Campaigner replication to Amazon S3.
-
Access Live Testmonitor 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 Testmonitor data through MCP integration.
-
Use Dash to Build to Web Apps on CapsuleCRM Data
Create Python applications that use pandas and Dash to build CapsuleCRM-connected web apps.
-
Integrate with Apollo Data in JReport Designer
Create charts and reports based on Apollo data in JReport Designer.
-
Query DocuSign Data as a SQL Server Database in Node.js
Execute SQL Server queries against DocuSign data from Node.js.
-
Connect PagerDuty to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live PagerDuty data using the CData Python MCP Server.
-
Validate Epicor Kinetic Data with QuerySurge
Access and validate Epicor Kinetic data in QuerySurge using the CData JDBC Driver.
-
How to connect to Cvent Data from Spring Boot
Connect to Cvent in a Spring Boot Application using the CData JDBC Driver for Cvent
-
Query Wave Financial Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Wave Financial data from Node.js.
-
Create Power BI Reports on Real-Time Printify Data
Use the CData ODBC Driver for Printify to visualize Printify data in Power BI Desktop.
-
Getting Started with the CData SSIS Components for SharePoint Excel Services
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SharePoint Excel Services.
-
How to connect to Salesforce Data 360 Data with Squirrel SQL client
Connect to Salesforce Data 360 data and execute queries in the Squirrel SQL Client.
-
Connect to Mixpanel Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Mixpanel.
-
Load Xero Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Xero data to a database.
-
Create Jira Assets-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Jira Assets Data from OutSystems and build custom enterprise apps using live Jira Assets data.
-
How to Connect to Live Airtable 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 Airtable data for you.
-
Bind Live Teradata Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Teradata data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Object-Relational Mapping (ORM) with Rebilly 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 Rebilly data into a Java-based ORM framework, Hibernate.
-
Use the CData ODBC Driver for Datadog from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Datadog to connect to Datadog data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Datadog data in Excel.
-
Operational Reporting on Odoo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Odoo data.
-
Integrate Open WebUI with Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Sheets data from within the chat interface.
-
Replicate Outlook Data in Heroku for Use in Salesforce Connect
Replicate Outlook data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to Clockify Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Clockify data. Leverage the pyodbc module for ODBC in Python.
-
Automate Guru Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Guru data from PowerShell? This article demonstrates how to utilize the Guru Cmdlets for tasks like connecting to Guru data, automating operations, downloading data, and more.
-
Choosing the Best Method to Connect Reply.io to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Reply.io data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to & Open Oracle SCM Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle SCM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to VWO Data in DBArtisan
Use wizards in DBArtisan to configure VWO data as a data source.
-
Create Data Visualizations Based On Google Campaign Manager 360 Data in Mode
Use CData Connect AI to connect to Google Campaign Manager 360 Data from Mode and build visualizations using live Google Campaign Manager 360 data.
-
Integrate Live SAP HANA Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP HANA data and integrate live SAP HANA data into apps built in Microsoft Power Apps.
-
Automated Continuous BenchmarkEmail Replication to Databricks
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Databricks.
-
Configure the CData JDBC Driver for SuiteCRM in a Connection Pool in Tomcat
Connect to SuiteCRM data from a connection pool in Tomcat.
-
Automated Continuous SAP Fieldglass Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to SQL Server.
-
DataBind Controls to Bugsnag Data in C++Builder
DataBind to Bugsnag data in C++Builder with standard components and controls.
-
Write a Simple Go Application to work with PayPal Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to PayPal data.
-
Integrate Goose with Live Toggl Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Toggl data from within the local AI agent.
-
How to Build an ETL App for EnterpriseDB Data in Python with CData
Create ETL applications and real-time data pipelines for EnterpriseDB data in Python with petl.
-
Replicate Teamgate Data to Multiple Databases via the CData Sync CLI
Replicate Teamgate data to disparate databases with a single configuration.
-
Connect to Oracle Eloqua Reporting Data in Aqua Data Studio
Access Oracle Eloqua Reporting data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous ElevenLabs Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ElevenLabs replication to Google Cloud SQL.
-
Access ShipEngine Data from MySQL in Amazon QuickSight
Connect to ShipEngine and build visualizations of ShipEngine data using a MySQL Connection in Amazon QuickSight.
-
How to Build an ETL App for Power BI XMLA Data in Python with CData
Create ETL applications and real-time data pipelines for Power BI XMLA data in Python with petl.
-
How to Connect Flowise AI Agents to Live HubSpot 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 HubSpot data without replication.
-
How to import Templated Data into Apache Solr
Use the CData Software JDBC Driver for Templated in Data Import Handler and create an automated import of Templated data to Apache Solr Enterprise Search platform.
-
Getting Started with the CData JDBC Driver for Productboard
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Productboard.
-
Build Automated Workflows with Live Tally Data in Workato
Use CData Connect AI to connect to live Tally data and build automated workflows in Workato.
-
How to connect to Adobe Experience Manager Data in DBVisualizer
Integrate Adobe Experience Manager data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Samanage Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Samanage and work with Samanage data in your FileMaker applications.
-
Analyze ZohoExpense Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZohoExpense data in Microsoft R Open.
-
Visualize Mode 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 Mode data into TIBCO Spotfire.
-
Import Real-Time Shortcut Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Shortcut data in ColdFusion.
-
Choosing the Best Method to Connect Quickbase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Quickbase data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Manus AI to Talk to Your Omnisend 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 Omnisend data.
-
Connect to Everhour Data in Ruby
Connect to Everhour data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating LangGraph with Amazon Marketplace Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Amazon Marketplace data within automated workflows.
-
Build Semantic Layer Views for SAP HANA Data in APOS Live Data Gateway
Use the CData Connector for SAP HANA in APOS Live Data Gateway to build Semantic Layer Views for SAP HANA data.
-
Integrate Xero Data into Power Automate Desktop using CData Connect
CData Connect for Xero Data enables you to integrate Xero data into workflows built using Microsoft Power Automate Desktop.
-
How to import Zoho CRM Data into Apache Solr
Use the CData Software JDBC Driver for Zoho CRM in Data Import Handler and create an automated import of Zoho CRM data to Apache Solr Enterprise Search platform.
-
Natively Connect to Wistia Data in PHP
The CData ODBC driver for Wistia enables you to create PHP applications with connectivity to Wistia data. Leverage the native support for ODBC in PHP.
-
How to connect to Opsgenie Data from Spring Boot
Connect to Opsgenie in a Spring Boot Application using the CData API Driver for JDBC
-
How to Work with Optimizely Data in ETL Validator JDBC
Connect to Optimizely from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous DocuSign Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable DocuSign replication to Apache Kafka.
-
Operational Reporting on SAP Ariba Procurement Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Ariba Procurement data.
-
Use Agno to Talk to Your SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SQL Server data for you.
-
Automated Continuous Zoom Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zoom replication to delimited files (CSV/TSV).
-
Access Live Mailgun Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Mailgun data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Prepare, Blend, and Analyze BigCommerce Data in Alteryx Designer (ODBC)
Build workflows to access live BigCommerce data for self-service data analytics.
-
How to Connect Flowise AI Agents to Live Impala 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 Impala data without replication.
-
Visualize Live ClickTime Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ClickTime data.
-
Use Claude to Talk to Your GitLab 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 GitLab data for you.
-
Build AI Agents with Greenplum 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 Greenplum data through CData Connect AI.
-
Use Azure AI Foundry to Talk to Your VWO 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 VWO data for you.
-
Import Real-Time Perplexity Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Perplexity data in ColdFusion.
-
How to Work with GitHub Data in ETL Validator JDBC
Connect to GitHub from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Datasets from SFTP in Domo Workbench and Build Visualizations of SFTP Data in Domo
Use the CData Software ODBC Driver for SFTP to create datasets from SFTP data in Domo Workbench and then build visualizations in the Domo service.