CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with Accelo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Accelo.
-
Sentry Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sentry facts in real time.
-
Create Reports from Oracle Sales Data in Looker Studio
Use CData Connect AI to gain access to live Oracle Sales and create custom reports in Looker Studio.
-
How to Query Live Azure Data Lake Storage Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure Data Lake Storage data in natural language using Python.
-
Integrate Real-Time Access to Jira Assets in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Jira Assets in real time.
-
Automated Continuous LightSpeedRetail Replication to Vertica
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Vertica.
-
Working with Delighted Data in LINQPad
Execute LINQ queries to Delighted in LINQPad.
-
Connect to Live Zoom Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Zoom in CData Connect AI and connect to your Zoom from PostgreSQL.
-
Excel Spreadsheet Automation on Monday.com Data with the QUERY Formula
Pull data from Monday.com, automate spreadsheets, and more with the QUERY formula.
-
How to Work with Tally Data in ETL Validator JDBC
Connect to Tally from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Automated Azure Data Lake Storage-Connected Workflows in Zapier
Use CData Connect AI to connect to live Azure Data Lake Storage and build automated workflows in Zapier.
-
Build MVC Applications with Connectivity to Hubstaff Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Hubstaff from an ASP.NET MVC application.
-
How to Query Live Guru Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Guru data in natural language using Python.
-
A PostgreSQL Interface for Autopilot Data (MySQL Remoting via JDBC)
Use the Remoting features of the Autopilot JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Live Facebook Ads Data in SAS Viya
Use CData Connect AI to connect to Facebook Ads from SAS Viya and deploy self-service analytics using live Facebook Ads.
-
How to import Calendly Data into Apache Solr
Use the CData Software JDBC Driver for Calendly in Data Import Handler and create an automated import of Calendly to Apache Solr Enterprise Search platform.
-
Build a Singer.io Tap for SAP HANA XS Advanced With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP HANA XS Advanced data using
-
Connect to Amazon DynamoDB Data from PowerBuilder via JDBC
This article demonstrates how to access Amazon DynamoDB from PowerBuilder using the Amazon DynamoDB JDBC Driver.
-
Use the CData Software ODBC Driver for CapsuleCRM in MicroStrategy
Connect to CapsuleCRM in MicroStrategy Developer using the CData Software ODBC Driver for CapsuleCRM.
-
Connect to ClickUp Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ClickUp in the Denodo Virtual DataPort Administrator.
-
Connect to SAS Data Sets Data from a Connection Pool in JBoss
Integrate SAS Data Sets into Java servlets: Use the Management Console in JBoss to install the SAS Data Sets JDBC Driver.
-
Replicate Avaza Data from PowerShell
Write a quick PowerShell script to query Avaza. Use connectivity to the live data to replicate Avaza to SQL Server.
-
Create Informatica Mappings From/To a JDBC Data Source for Elorus
Create Elorus data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Migrating data from Zoho Books to Databricks using CData SSIS Components.
Easily push Zoho Books to Databricks using the CData SSIS Tasks for Zoho Books and Databricks.
-
Connect to Paylocity Data in Google Apps Script via Connect AI
Use CData Connect AI to access Paylocity in Google Apps Script.
-
Integrate MySQL with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate MySQL with External Services.
-
Connect to and Visualize Live Pipeline CRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pipeline CRM.
-
Connect to Parallel in SpagoBI
Create reports featuring live Parallel in SpagoBI Studio. Host Parallel reports on SpagoBI Server.
-
How to Query Slack Data in MySQL Workbench
Execute MySQL queries against live Slack from MySQL Workbench.
-
Back Up Twilio to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Twilio. In this article, we will employ an SSIS workflow to populate a database with Twilio data.
-
Import Real-Time Azure DevOps Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Azure DevOps in ColdFusion.
-
Configure the CData JDBC Driver for Figshare in a Connection Pool in Tomcat
Connect to Figshare from a connection pool in Tomcat.
-
Natively Connect to Adobe Analytics Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Adobe Analytics. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Google Ad Manager 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 Ad Manager for you.
-
Automated Continuous Shortcut Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Shortcut replication to Apache Kafka.
-
Analyze Slack Data in Looker
Use CData Connect AI to connect to Slack Data from Looker and build custom apps using live Slack.
-
Automate Amazon Marketplace Data Replication to Couchbase
Use CData Sync to Customize and automate Amazon Marketplace replication to Couchbase.
-
Automated Continuous PabblySubscriptions Replication to SQL Server
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to SQL Server.
-
Analyze JSON Services in R via JDBC
Use standard R functions and the development environment of your choice to analyze JSON with the CData JDBC Driver for JSON.
-
Access SAP ByDesign Data from MySQL in PHP
Connect to SAP ByDesign through the standard MySQL libraries in PHP.
-
Integrating GitHub Copilot CLI with FreshBooks 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.
-
Add CapsuleCRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for CapsuleCRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect to Outreach.io Data in DBVisualizer
Integrate Outreach.io with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Live Unbounce Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Unbounce using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to VWO Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for VWO.
-
Bind Live CockroachDB Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live CockroachDB data
-
Connect Exact Online Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Exact Online using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate SAP Fieldglass Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Fieldglass from Informatica Cloud.
-
Consume Salesforce OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Salesforce feeds that reflect any changes in SAP Lumira.
-
Publish ElevenLabs-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ElevenLabs.
-
DataBind Superchat Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Superchat to a chart.
-
Build Apps with Live Templated Data Using the Low-Code Development Platform of Mendix
Connect Templated with Mendix to build apps using the CData API Driver for JDBC.
-
Access Live Amazon DynamoDB Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon DynamoDB from your Excel spreadsheets.
-
Connect to Live Facebook Ads Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Facebook Ads in CData Connect AI and connect to your Facebook Ads from PostgreSQL.
-
Visualize WordPress Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to WordPress.
-
Access FreshBooks Data from MySQL in Amazon QuickSight
Connect to FreshBooks and build visualizations of FreshBooks using a MySQL Connection in Amazon QuickSight.
-
Feed Highrise Data into FineReport
How to set Highrise CRM as a JDBC data source in FineReport.
-
How to load xBase data into Elasticsearch via Logstash
Introducing a simple method to load xBase data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
DataBind Controls to SAP SuccessFactors Data in Delphi
DataBind to SAP SuccessFactors in Delphi with standard data access components and controls.
-
Integrating Boomi Agentstudio with SQL Analysis Services Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SQL Analysis Services, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Google Directory in SpagoBI
Create reports featuring live Google Directory in SpagoBI Studio. Host Google Directory reports on SpagoBI Server.
-
Build SAP BusinessObjects BI-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP BusinessObjects BI Data and create custom apps in Bubble.
-
Use the CData Software ODBC Driver for Highrise in MicroStrategy Web
Connect to Highrise CRM in MicroStrategy Web using the CData Software ODBC Driver for Highrise.
-
Viewing ClickTime Data in RAD Studio Data Explorer
How to view ClickTime in RAD Studio Data Explorer using the CData ODBC Driver for ClickTime.
-
Use JayDeBeApi to access AgileCRM Data in Python
Use standard Python scripting and the development environment of your choice to access live AgileCRM.
-
Visualize Attio Data in TIBCO Spotfire through ADO.NET
Integrate Attio into dashboards in TIBCO Spotfire.
-
Automated Continuous JotForm Replication to AlloyDB
Use CData Sync for automated, continuous, customizable JotForm replication to AlloyDB.
-
Getting Started with the CData JDBC Driver for Oracle SCM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Oracle SCM.
-
Replicate Intercom Data to Multiple Databases via the CData Sync CLI
Replicate Intercom to disparate databases with a single configuration.
-
Access Live SAP Business One Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Business One from your Excel spreadsheets.
-
Build SAP Ariba Source-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP Ariba Source Data and create custom apps in Bubble.
-
Build Voice Agents in ElevenLabs with access to Live HCL Domino Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live HCL Domino.
-
Natively Connect to Qualaroo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Qualaroo. Leverage the native support for ODBC in PHP.
-
Build Visualizations of SharePoint Excel Services Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SharePoint Excel Services in Birst.
-
Trigger Dropbox IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Dropbox with standard wizards in Logic Apps.
-
Migrating data from Gmail to Databricks using CData SSIS Components.
Easily push Gmail to Databricks using the CData SSIS Tasks for Gmail and Databricks.
-
How to Work with CircleCI Data in ETL Validator JDBC
Connect to CircleCI from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Vimeo Data
Use CData Power BI Connectors to visualize Vimeo in Power BI.
-
How to Connect to Live Microsoft Planner 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 Planner for you.
-
Access Live Freshservice Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Freshservice from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Replicate Amazon DynamoDB Data from PowerShell
Write a quick PowerShell script to query Amazon DynamoDB. Use connectivity to the live data to replicate Amazon DynamoDB to SQL Server.
-
Analyze SAP Ariba Source Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Ariba Source and visualize live SAP Ariba Source in Infragistics Reveal.
-
Feed GetResponse Data into FineReport
How to set GetResponse as a JDBC data source in FineReport.
-
Analyze GitLab Data in Cognos Analytics
Use CData Connect AI to connect to GitLab Data from Cognos Analytics and analyze live GitLab.
-
Configure the CData JDBC Driver for Google Tasks in a Connection Pool in Tomcat
Connect to Google Tasks from a connection pool in Tomcat.
-
Integrating LangGraph with NetSuite Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on NetSuite CRM & ERP within automated workflows.
-
Build MVC Applications with Connectivity to Dynamics 365 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dynamics 365 from an ASP.NET MVC application.
-
Use the CData Software JDBC Driver for AlloyDB in MicroStrategy
Connect to Google AlloyDB in MicroStrategy Developer using the CData Software JDBC Driver for AlloyDB.
-
Process & Analyze Adobe Target Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Adobe Target Data.
-
Analyze Xero Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Xero Accounting and visualize live Xero Accounting in Infragistics Reveal.
-
Use Dash to Build Web Apps on SendGrid Data via CData Connect AI
Build interactive Dash web apps on live SendGrid using pandas and the CData Connect AI Python SDK.
-
Build Data Flows from SQL Server to Redshift through SSIS
Easily push SQL Server data to Redshift using the CData SSIS Tasks for Redshift.
-
Integrating Claude Code with Snowflake Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Snowflake within assisted coding and automated development workflows.
-
Prepare, Blend, and Analyze SharePoint Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft SharePoint for self-service data analytics.
-
Analyze Live SAP Ariba Procurement Data in SAS Viya
Use CData Connect AI to connect to SAP Ariba Procurement from SAS Viya and deploy self-service analytics using live SAP Ariba Procurement.
-
Integrate LibreChat with Live NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live NetSuite CRM & ERP from within the chat interface.
-
How to integrate Metabase with Google Analytics Data
Use CData Connect AI to connect to live Google Analytics and create an interactive dashboard in Metabase from Google Analytics.
-
Consume Lakebase OData Feeds in PowerBuilder
This article demonstrates how to consume Lakebase as OData feeds from PowerBuilder using the API Server.
-
Visualize Instantly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Instantly.
-
Automated Continuous LaunchDarkly Replication to Vertica
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Vertica.