CData Software - Knowledge Base
Recent Articles
-
Automate Tasks in Power Automate Using the CData API Server
Automate Redis actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to Easily Query SAP Fieldglass Data in OpenOffice Base
Connect to SAP Fieldglass data in OpenOffice Base using the CData ODBC Driver for SAP Fieldglass and generate reports with live data insights.
-
Create Datasets from Mailgun in Domo Workbench and Build Visualizations of Mailgun Data in Domo
Use the CData Software ODBC Driver for Mailgun to create datasets from Mailgun in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Pipeline CRM Data in Coginiti Pro
Connect to and query live Pipeline CRM from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Datasets from VWO in Domo Workbench and Build Visualizations of VWO Data in Domo
Use the CData Software ODBC Driver for VWO to create datasets from VWO in Domo Workbench and then build visualizations in the Domo service.
-
How to connect SharePoint with Okta Data through external lists
Provide Okta to SharePoint users as an external list.
-
Work with Snowflake Data in FoxPro
Load Snowflake into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to load Perplexity data into Elasticsearch via Logstash
Introducing a simple method to load Perplexity data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect DBeaver to Google Calendar via a JDBC Driver
Manage Google Calendar with visual tools in DBeaver like the query browser.
-
Build Data Flows from Wave Financial to SQL Server using SSIS
Easily back up Wave Financial to SQL Server using the SSIS components for Wave Financial.
-
Provide OData Services of Toggl Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Toggl by developing a WCF Service Application.
-
Build Dashboards with SparkPost Data in DBxtra
Create dynamic dashboards and perform analytics based on SparkPost in DBxtra.
-
Visualize Retently 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 Retently into TIBCO Spotfire.
-
Connect to and Query SurveyMonkey Data in QlikView over ODBC
Create data visualizations with SurveyMonkey in QlikView.
-
Establish a Live Connection with Zuora Data using Tableau Bridge
The CData ODBC Driver for Zuora enables you to integrate live Zuora into Tableau Cloud dashboards using the Tableau Bridge.
-
How to publish and share Everhour Data dashboards with Tableau Server
The CData ODBC driver for Everhour enables you integrate Everhour into Tableau dashboards.
-
Connect to Dotmailer Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Dotmailer as an External Source in Dremio.
-
How to work with Azure Synapse Data in Apache Spark using SQL
Access and process Azure Synapse Data in Apache Spark using the CData Software JDBC Driver.
-
How to Work with SAP Netweaver Gateway Data in AWS Glue Jobs Using JDBC
Connect to SAP Netweaver Gateway from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to SAP Hybris C4C Data in DBArtisan
Use wizards in DBArtisan to configure SAP Hybris C4C as a data source.
-
Import Real-Time Flowlu Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Flowlu in ColdFusion.
-
Integrate Highrise with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Highrise with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Highrise CRM.
-
Integrating LangChain with Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Excel Online within automated workflows.
-
Access Yelp Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Yelp from HeidiSQL.
-
Build SAP BusinessObjects BI-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP BusinessObjects BI and build web apps with connectivity to live SAP BusinessObjects BI.
-
Create Apps from GitHub Data in Qlik Sense Cloud
Use CData Connect AI to connect to GitHub Data and build apps from live GitHub in Qlik Sense Cloud.
-
Visualize SAP Business One Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Business One.
-
Visualize LeadDesk Data in Sisense
Create an ElastiCube in Sisense app with access to LeadDesk.
-
How to Connect to Live Phoenix Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Apache Phoenix securely in real time.
-
Create Reports with Flowlu Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Flowlu.
-
Connect to Jira Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Atlassian Jira in the Denodo Virtual DataPort Administrator.
-
Connecting Agentforce with Snapchat Ads 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 Snapchat Ads for you.
-
Adobe Experience Manager Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Adobe Experience Manager facts in real time.
-
Excel Spreadsheet Automation on CouchDB Data with the QUERY Formula
Pull data from CouchDB, automate spreadsheets, and more with the QUERY formula.
-
Add Google Directory Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Directory with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Sage Cloud Accounting Data from MySQL in Amazon QuickSight
Connect to Sage Cloud Accounting and build visualizations of Sage Business Cloud Accounting using a MySQL Connection in Amazon QuickSight.
-
How to Work with Acumatica Data in AWS Glue Jobs Using JDBC
Connect to Acumatica from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Voice Agents in ElevenLabs with access to Live Apollo Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Apollo.
-
How to Connect to Live QuickBooks Time 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 QuickBooks Time without replication.
-
Visualize Postmark Data in Tableau
The CData ODBC driver for Postmark enables you integrate Postmark into Tableau dashboards.
-
Create OData-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to OData Services from Klipfolio and build custom visualizations using live OData.
-
How to connect PolyBase to Certinia
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Certinia.
-
Integrate LibreChat with Live FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live FHIR from within the chat interface.
-
Replicate eBay Data to Multiple Databases via the CData Sync CLI
Replicate eBay to disparate databases with a single configuration.
-
Build Visualizations of Notion Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Notion in Birst.
-
Automated Continuous SparkPost Replication to Databricks
Use CData Sync for automated, continuous, customizable SparkPost replication to Databricks.
-
Build a PostgreSQL Interface for Google Directory Data using the CData JDBC Driver
Use the Remoting features of the Google Directory JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Biml to Build SSIS Tasks to Replicate CloudConvert Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate CloudConvert to SQL Server.
-
Access Live Splunk Data in Coginiti Pro
Connect to and query live Splunk from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Charts with Adobe Target Data in Clear Analytics
Create dynamic charts and perform analytics based on Adobe Target in Clear Analytics.
-
Create Workday-Connected Nintex Workflows
Use CData Connect AI to connect to Workday Data from Nintex Workflow Cloud and build custom workflows using live Workday.
-
Getting Started with the CData Excel Add-In for Quaderno
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Quaderno.
-
Connect to Samanage Data in CloverDX (formerly CloverETL)
Transfer Samanage using the visual workflow in the CloverDX data integration tool.
-
Integrate Open WebUI with Live Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Zoho Inventory from within the chat interface.
-
Automated Continuous Email Replication to SingleStore
Use CData Sync for automated, continuous, customizable Email replication to SingleStore.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PayPal
Provide connectivity to PayPal through an SAP BusinessObjects universe.
-
How to load Tally data into Elasticsearch via Logstash
Introducing a simple method to load Tally data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
A PostgreSQL Interface for MailerSend Data using the CData ODBC Driver
Use the SQL Gateway and MailerSend ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Excel Data in NetBeans
Connect to Microsoft Excel in NetBeans with the data source configuration wizard.
-
How to create ClickTime federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ClickTime in MySQL .
-
Create Power BI Reports on Real-Time ZohoDesk Data
Use the CData ODBC Driver for ZohoDesk to visualize ZohoDesk in Power BI Desktop.
-
Connect to Microsoft Planner Data in ACL Analytics
Connect to Microsoft Planner via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Planner.
-
How to Connect to Live Dynamics 365 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 Microsoft Dynamics 365 for you.
-
Use the CData Software ODBC Driver for Helpscout in MicroStrategy Web
Connect to Helpscout in MicroStrategy Web using the CData Software ODBC Driver for Helpscout.
-
Integrating Cursor CLI with SAP 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.
-
Automated Continuous Redis Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Redis replication to AlloyDB.
-
Connect to Bullhorn CRM Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bullhorn CRM to connect to Bullhorn CRM and execute queries in PowerBuilder.
-
Create Dynamic Discourse Grids Using the Infragistics XamDataGrid
Learn how you can connect Discourse to Infragistics XamDataGrid to build dynamic grids.
-
Access Live IBM Cloud Object Storage Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live IBM Cloud Object Storage from your Google Sheets.
-
Integrate ZohoPeople Data in Pentaho Data Integration
Build ETL pipelines based on ZohoPeople in the Pentaho Data Integration tool.
-
Build Dashboards with PDFMonkey Data in DBxtra
Create dynamic dashboards and perform analytics based on PDFMonkey in DBxtra.
-
Replicate Multiple Copper Accounts
Replicate multiple Copper accounts to one or many databases.
-
Rapidly Develop Jira-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 Jira.
-
Build Semantic Layer Views for Phoenix Data in APOS Live Data Gateway
Use the CData Connector for Phoenix in APOS Live Data Gateway to build Semantic Layer Views for Apache Phoenix.
-
Publish Crystal Reports on Freshdesk Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Freshdesk.
-
Import Real-Time Microsoft Teams Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Teams in ColdFusion.
-
Use the CData Software JDBC Driver for SAS Data Sets in MicroStrategy Web
Connect to SAS Data Sets in MicroStrategy Web using the CData Software JDBC Driver for SAS Data Sets.
-
Integrating Claude Code CLI with Email 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.
-
Build Semantic Layer Views for Presto Data in APOS Live Data Gateway
Use the CData Connector for Presto in APOS Live Data Gateway to build Semantic Layer Views for Presto.
-
Connect to Phoenix Data in RapidMiner
Integrate Apache Phoenix with standard components and data source configuration wizards in RapidMiner Studio.
-
Validate Webex Data with QuerySurge
Access and validate Webex in QuerySurge using the CData JDBC Driver.
-
Object-Relational Mapping (ORM) with Sage Cloud Accounting 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 Sage Business Cloud Accounting into a Java-based ORM framework, Hibernate.
-
How to Access Live Missive Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Missive enables you to integrate Missive into workflows built using Microsoft Power Automate Desktop.
-
Connect to Zoho Recruit 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 Zoho Recruit and work with Zoho Recruit in your FileMaker application.
-
Automated Continuous Jira Replication to SingleStore
Use CData Sync for automated, continuous, customizable Jira replication to SingleStore.
-
Access GetResponse Data from MySQL in PHP
Connect to GetResponse through the standard MySQL libraries in PHP.
-
Access Live Odoo Data in Excel 365 Online (Excel for the web)
Connect to Odoo ERP from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData Tableau Connector for Bannerbear
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate Live SendInBlue Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SendInBlue to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate with AlloyDB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google AlloyDB to a JSON file on disk.
-
Access Live Facebook Ads Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Facebook Ads from your Google Sheets.
-
Automate Copper Data Replication to Couchbase
Use CData Sync to Customize and automate Copper replication to Couchbase.
-
Write a Simple Go Application to work with OData Services on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to OData.
-
Integrate Live Wistia Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Wistia to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous Reckon Accounts Hosted Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Azure SQL Database.
-
How to create an RPA flow for Mailgun Data in UiPath Studio
Use the Mailgun ODBC Driver to create workflows that access real-time Mailgun without any coding.
-
Connect to Gmail Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Gmail Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Adobe Experience Manager Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Adobe Experience Manager and the Script function in FileMaker Pro to connect to Adobe Experience Manager and work with Adobe Experience Manager in your FileMaker application.
-
Use the CData Software ODBC Driver for JobNimbus in MicroStrategy Web
Connect to JobNimbus in MicroStrategy Web using the CData Software ODBC Driver for JobNimbus.
-
Build Charts with SAP Ariba Source Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Ariba Source in Clear Analytics.