CData Software - Knowledge Base
Recent Articles
-
Access Live PagerDuty Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PagerDuty data into the statistical analysis tools available in SAS JMP. This article shows how to use PagerDuty data in the Graph Builder and Query Builder.
-
How to Easily Query Hugging Face Data in OpenOffice Base
Connect to Hugging Face data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for EnterpriseDB
Provide connectivity to EnterpriseDB data through an SAP BusinessObjects universe.
-
Integrate Real-Time Access to Xero in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Xero data in real time.
-
Replicate Gmail Data from PowerShell
Write a quick PowerShell script to query Gmail data. Use connectivity to the live data to replicate Gmail data to SQL Server.
-
Connect to Front Data in Ruby
Connect to Front data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Greenplum Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Greenplum data. Leverage the pyodbc module for ODBC in Python.
-
Build Facebook Ads Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Facebook Ads data and build visualizations in Tableau.
-
Integrate Dify with Live Lakebase 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 Lakebase data.
-
Connect to CapsuleCRM Data in CloverDX (formerly CloverETL)
Transfer CapsuleCRM data using the visual workflow in the CloverDX data integration tool.
-
How to Work with Twitter Ads Data in ETL Validator JDBC
Connect to Twitter Ads from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Suadeo Data in JRuby
Create a simple JRuby app with access to live Suadeo data.
-
Create Apps from ConstantContact Data in Qlik Sense Cloud
Use CData Connect AI to connect to ConstantContact Data and build apps from live ConstantContact data in Qlik Sense Cloud.
-
Connecting Mastra with Zendesk Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Zendesk data, no replication required.
-
Connect to Avaza Data in Jaspersoft Studio
Execute SQL to remote Avaza data in Jaspersoft Studio.
-
Establish a Live Connection with Oracle SCM Data using Tableau Bridge
The CData ODBC Driver for Oracle SCM enables you to integrate live Oracle SCM data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Live DocuSign Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live DocuSign data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import and Visualize Kintone Data in Power View
Create data visualizations based on Kintone data in Excel.
-
Integrate Dify with Live Jira 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 Jira data.
-
Integrate Devin with Live Neo4J Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Neo4J data.
-
OnePageCrm Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on OnePageCrm facts in real time.
-
Connect to Phoenix Data from a Connection Pool in JBoss
Integrate Phoenix data into Java servlets: Use the Management Console in JBoss to install the Phoenix JDBC Driver.
-
Build Data Flows from SQL Server to Act-On through SSIS
Easily push SQL Server data to Act-On using the CData SSIS Tasks for Act-On.
-
Create SSAS Tabular Models from SendGrid Data
How to build a SQL Server Analysis Service Tabular Model from SendGrid data using CData drivers.
-
Access Live Bitbucket Data in Coginiti Pro
Connect to and query live Bitbucket data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Connect AI Python SDK for ZohoDesk
Install the CData Connect AI Python SDK to read live ZohoDesk data with standard DB-API 2.0 Python code.
-
Validate SQL Analysis Services Data with QuerySurge
Access and validate SQL Analysis Services data in QuerySurge using the CData JDBC Driver.
-
Integrate HBase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate HBase with External Services.
-
Integrate Theia IDE with Live MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live MailChimp data from within the development environment.
-
Build Semantic Layer Views for QuickBooks Online Data in APOS Live Data Gateway
Use the CData Connector for QuickBooks Online in APOS Live Data Gateway to build Semantic Layer Views for QuickBooks Online data.
-
Create Data Visualizations in Cognos BI with Brex Data
Access Brex data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Aha! Data in Jaspersoft Studio
Execute SQL to remote Aha! data in Jaspersoft Studio.
-
How to create an RPA flow for Couchbase Data in UiPath Studio
Use the Couchbase ODBC Driver to create workflows that access real-time Couchbase data without any coding.
-
Use the CData ODBC Driver for Discord from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Discord to connect to Discord data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Discord data in Excel.
-
Design BIRT Reports on Apify Data
Provide current Apify data to your embedded analytics.
-
Connect to Datadog Data in DBeaver
Use the CData ODBC Driver to connect to Datadog data in DBeaver.
-
Feed Dynamics 365 Business Central Data into FineReport
How to set Dynamics 365 Business Central data as a JDBC data source in FineReport.
-
How to Connect to Live QuickBooks 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 QuickBooks data for you.
-
How to import Redshift Data into Apache Solr
Use the CData Software JDBC Driver for Redshift in Data Import Handler and create an automated import of Redshift data to Apache Solr Enterprise Search platform.
-
RSS Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on RSS facts in real time.
-
How to work with Qualaroo Data in Apache Spark using SQL
Access and process Qualaroo Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Pipeliner CRM in MicroStrategy Web
Connect to Pipeliner CRM data in MicroStrategy Web using the CData Software ODBC Driver for Pipeliner CRM.
-
How to Visualize SharePoint Data in Python with pandas
Use pandas and other modules to analyze and visualize live SharePoint data in Python.
-
Integrate Aweber Data in Pentaho Data Integration
Build ETL pipelines based on Aweber data in the Pentaho Data Integration tool.
-
Create Datasets from Auth0 in Domo Workbench and Build Visualizations of Auth0 Data in Domo
Use the CData Software ODBC Driver for Auth0 to create datasets from Auth0 data in Domo Workbench and then build visualizations in the Domo service.
-
Build Data Flows from SpaceX to SQL Server using SSIS
Easily back up SpaceX data to SQL Server using the SSIS components for SpaceX.
-
Create Dynamic Reckon Accounts Hosted Grids Using the Infragistics XamDataGrid
Learn how you can connect Reckon Accounts Hosted to Infragistics XamDataGrid to build dynamic grids.
-
Import Real-Time Vercel Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Vercel data in ColdFusion.
-
ETL Jumpseller in Oracle Data Integrator
This article shows how to transfer Jumpseller data into a data warehouse using Oracle Data Integrator.
-
Connect to Perplexity Data from PowerBuilder via ADO.NET
This article demonstrates how to access Perplexity data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to integrate Metabase with Impala Data
Use CData Connect AI to connect to live Impala data and create an interactive dashboard in Metabase from Impala data.
-
Use Agno to Talk to Your Greenhouse 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 Greenhouse data for you.
-
Analyze Live Trello Data in SAS Viya
Use CData Connect AI to connect to Trello data from SAS Viya and deploy self-service analytics using live Trello data.
-
LINQ to eBay Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the eBay Data Provider.
-
How to connect to Flowlu Data with Squirrel SQL client
Connect to Flowlu data and execute queries in the Squirrel SQL Client.
-
How to Query Live Sugar CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sugar CRM data data in natural language using Python.
-
Operational Reporting on Planio Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Planio data.
-
Build a PostgreSQL Interface for Microsoft Planner Data using the CData JDBC Driver
Use the Remoting features of the Microsoft Planner JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build SFTP-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SFTP Data and create custom apps in Bubble.
-
Build BigCommerce Visualizations in Tableau Cloud
Use CData Connect AI to connect to live BigCommerce data and build visualizations in Tableau Cloud.
-
Automated Continuous Insightly Replication to MySQL
Use CData Sync for automated, continuous, customizable Insightly replication to MySQL.
-
Use Dash to Build Web Apps on SAP Netweaver Gateway Data via CData Connect AI
Build interactive Dash web apps on live SAP Netweaver Gateway data using pandas and the CData Connect AI Python SDK.
-
Connect to Apollo Data in Jaspersoft Studio
Execute SQL to remote Apollo data in Jaspersoft Studio.
-
Analyze Tally Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Tally data in Microsoft R Open.
-
Access Deel Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Deel data from HeidiSQL.
-
Access CloudConvert Data from MySQL in Amazon QuickSight
Connect to CloudConvert and build visualizations of CloudConvert data using a MySQL Connection in Amazon QuickSight.
-
Connect to Typeform Data in ACL Analytics
Connect to Typeform data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Typeform data.
-
Build Agents in Relevance AI with Access to Live IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on IBM Informix data within intelligent agent workflows.
-
Integrate LibreChat with Live MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live MailChimp data from within the chat interface.
-
How to Visualize SageHR 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 SageHR data in Python.
-
Work with Live SharePoint Data in Power Query
Use CData Connect AI to connect to SharePoint data and work with live SharePoint data in Microsoft Power Query.
-
Analyze Asana Data in Looker
Use CData Connect AI to connect to Asana Data from Looker and build custom apps using live Asana data.
-
Integrating Cursor with SAP Concur 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.
-
Automate Kafka Data Replication to SAP HANA
Use CData Sync to customize and automate Kafka data replication to SAP HANA.
-
Migrating data from Clio to Databricks using CData SSIS Components.
Easily push Clio data to Databricks using the CData SSIS Tasks for Clio and Databricks.
-
How to Create Power BI Visual Reports with Real-Time SAP Fieldglass Data
Use CData Power BI Connectors to visualize SAP Fieldglass data in Power BI.
-
Enable the Flowlu JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Flowlu data.
-
How to Connect to Live Gong 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 Gong data for you.
-
Automate Google Sheets Data Replication to Couchbase
Use CData Sync to Customize and automate Google Sheets data replication to Couchbase.
-
Use Grok to Talk to Your Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Sage Intacct data for you.
-
Analyze WordPress Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze WordPress data in Microsoft R Open.
-
Build Automated Anaplan-Connected Workflows in Zapier
Use CData Connect AI to connect to live Anaplan data and build automated workflows in Zapier.
-
How to Easily Query OnePageCrm Data in OpenOffice Base
Connect to OnePageCrm data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Work with Elorus Data in AWS Glue Jobs Using JDBC
Connect to Elorus from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Voice Agents in ElevenLabs with access to Live Facebook Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Facebook data.
-
Build Dashboards with Trello Data in DBxtra
Create dynamic dashboards and perform analytics based on Trello data in DBxtra.
-
Create Data Visualizations Based On SuiteCRM Data in Mode
Use CData Connect AI to connect to SuiteCRM Data from Mode and build visualizations using live SuiteCRM data.
-
Creating Slack-Connected Applications in Unqork
You can use CData Connect AI to feed Slack data to Unqork and build custom business apps.
-
How to Query Jira Assets Data in MySQL Workbench
Execute MySQL queries against live Jira Assets data from MySQL Workbench.
-
Connect to HelloSign Data in Ruby
Connect to HelloSign data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Dashboards with Power BI XMLA Data in Dundas BI
Create dynamic dashboards and perform analytics based on Power BI XMLA data in Dundas BI.
-
Establish a Live Connection with Zendesk Data using Tableau Bridge
The CData ODBC Driver for Zendesk enables you to integrate live Zendesk data into Tableau Cloud dashboards using the Tableau Bridge.
-
Zoho Books Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Zoho Books data through CData Connect AI using different applications and tools.
-
Query GitHub Data as a MySQL Database in Node.js
Execute MySQL queries against GitHub data from Node.js.
-
How to connect and process EmailOctopus data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live EmailOctopus data.
-
Use the CData Software ODBC Driver for ZohoPeople in SAS for Real-Time Reporting and Analytics
Connect to real-time ZohoPeople data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZohoPeople.
-
Build Dashboards with SAP Business Warehouse Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Business Warehouse data in DBxtra.
-
Integrate with live WooCommerce Data in Jitterbit
Use CData Connect AI to connect to and integrate live WooCommerce data in Jitterbit.
-
Create EnterpriseDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time EnterpriseDB data access from reports, embedded analytics, and more.
-
Integrating Gumloop with ConstantContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ConstantContact data within automated workflows.