CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build Web Apps on FHIR Data via CData Connect AI
Build interactive Dash web apps on live FHIR using pandas and the CData Connect AI Python SDK.
-
Visualize Okta 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 Okta into TIBCO Spotfire.
-
Edit and Search Salesforce Marketing External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Salesforce Marketing Cloud to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Salesforce Marketing objects that you can access from apps and the dashboard.
-
Connect to SAS Data Sets Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAS Data Sets in the Denodo Virtual DataPort Administrator.
-
Model Google Ads Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Ads, enabling the direct import of real-time Google Ads.
-
Build MVC Applications with Connectivity to Short.io Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Short.io from an ASP.NET MVC application.
-
Query Active Directory Data in DataGrip
Create a Data Source for Active Directory in DataGrip and use SQL to query live Active Directory.
-
Integrating IBM Informix Data in Talend Cloud Data Management Platform
Connect IBM Informix Data with Talend Cloud Data Management Platform using the CData JDBC Driver for IBM Informix.
-
Enable the Amazon DynamoDB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Amazon DynamoDB.
-
How to import SAP HANA XS Advanced Data into Apache Solr
Use the CData Software JDBC Driver for SAP HANA XS Advanced in Data Import Handler and create an automated import of SAP HANA XS Advanced to Apache Solr Enterprise Search platform.
-
Connect to SparkPost from Asprova with CData Software ODBC Driver for SparkPost
This article shows how to connect faster to SparkPost data from Asprova.
-
Use Biml to Build SSIS Tasks to Replicate Sendwithus Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sendwithus to SQL Server.
-
Create Informatica Mappings From/To a JDBC Data Source for Opsgenie
Create Opsgenie data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to CircleCI Data in JRuby
Create a simple JRuby app with access to live CircleCI.
-
How to connect to Templated Data in DBVisualizer
Integrate Templated with visual data analysis tools and data connection wizards in DBVisualizer
-
How to work with Accelo Data in Apache Spark using SQL
Access and process Accelo Data in Apache Spark using the CData Software JDBC Driver.
-
Access Shortcut 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 Shortcut.
-
Build Zoom-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Zoom.
-
Automated Continuous Shortcut Replication to SingleStore
Use CData Sync for automated, continuous, customizable Shortcut replication to SingleStore.
-
Create Reports from Act CRM Data in Looker Studio
Use CData Connect AI to gain access to live Act CRM and create custom reports in Looker Studio.
-
Integrate Open WebUI with Live Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Gmail from within the chat interface.
-
Automated Continuous Freshdesk Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Freshdesk replication to Amazon Redshift.
-
Create Asana Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Asana data access from reports, embedded analytics, and more.
-
Validate Oracle Eloqua Data with QuerySurge
Access and validate Oracle Eloqua in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Notion Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Notion replication to delimited files (CSV/TSV).
-
How to Query Live Oracle Data in Perplexity MacOS Desktop
Connect to and query live Oracle Data in Perplexity Desktop using CData MCP Server.
-
Build AI/ML Models with Live Toggl Data using Dataiku
Connect Toggl Data with Dataiku using the CData API Driver for JDBC.
-
Coda Reporting in OBIEE with the Coda JDBC Driver
Deploy the Coda JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Visualize QuickBooks Time Data in Python with pandas
Use pandas and other modules to analyze and visualize live QuickBooks Time in Python.
-
Access Live ChartMogul Data in Coginiti Pro
Connect to and query live ChartMogul from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to create eBay federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for eBay in MySQL .
-
Create Dynamic DocuSign Grids Using the Infragistics XamDataGrid
Learn how you can connect DocuSign to Infragistics XamDataGrid to build dynamic grids.
-
Extend Google Sheets with LinkedIn Ads Data
Make calls to LinkedIn Ads from Google Apps Script via the API Server.
-
Analyze Demio Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Demio with the CData JDBC Driver for Demio.
-
Visualize Zoho Projects 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 Zoho Projects into TIBCO Spotfire.
-
How to Access Live SAS Data Sets Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAS Data Sets enables you to integrate SAS Data Sets into workflows built using Microsoft Power Automate Desktop.
-
How to publish and share ClickUp Data dashboards with Tableau Server
The CData ODBC driver for ClickUp enables you integrate ClickUp into Tableau dashboards.
-
Load Templated Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Templated to a database.
-
Visualize Dynamics CRM Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Dynamics CRM into dashboards in TIBCO Spotfire.
-
Integrate LibreChat with Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Sheets from within the chat interface.
-
Visualize Basecamp Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Basecamp.
-
How to Create Power BI Visual Reports with Real-Time CloudConvert Data
Use CData Power BI Connectors to visualize CloudConvert in Power BI.
-
Connect to SurveyMonkey Data from a Connection Pool in Jetty
The SurveyMonkey JDBC Driver supports connection pooling: This article shows how to connect faster to SurveyMonkey from Web apps in Jetty.
-
Connect to Templated in SpagoBI
Create reports featuring live Templated in SpagoBI Studio. Host Templated reports on SpagoBI Server.
-
A Comparison of Database Drivers for SQL Server
A performance comparison of the CData JDBC Driver for SQL Server and the native JDBC Driver for SQL Server (updated May 2020)
-
Integrating Cursor CLI with Samanage 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.
-
Integrate with live AlloyDB Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google AlloyDB in Jitterbit.
-
How to work with Google Drive Data in Apache Spark using SQL
Access and process Google Drive Data in Apache Spark using the CData Software JDBC Driver.
-
Configure the CData JDBC Driver for Delighted in a Connection Pool in Tomcat
Connect to Delighted from a connection pool in Tomcat.
-
Deploy the ADO.NET Provider for Nuclia on an SSRS Report Server
Connect to Nuclia from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Object-Relational Mapping (ORM) with Oracle Service Cloud 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 Oracle Service Cloud into a Java-based ORM framework, Hibernate.
-
Import and Visualize Oracle Data in Power View
Create data visualizations based on Oracle Database in Excel.
-
Manage JDBC-ODBC Bridge Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for JDBC-ODBC Bridge.
-
Use CData Connect AI to Access CouchDB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Apache CouchDB in the Power Pivot business intelligence tool.
-
Integrate Real-Time Access to SharePoint Excel Services in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SharePoint Excel Services in real time.
-
How to Easily Query Bullhorn CRM Data in OpenOffice Base
Connect to Bullhorn CRM data in OpenOffice Base using the CData ODBC Driver for Bullhorn CRM and generate reports with live data insights.
-
Use Dash to Build Web Apps on ShipStation Data via CData Connect AI
Build interactive Dash web apps on live ShipStation using pandas and the CData Connect AI Python SDK.
-
Access ScrapingBee Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ScrapingBee from your Oracle system.
-
How to Design Kafka Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Kafka from mobile and tablet Power Apps.
-
Integrating OpenCode Terminal with EnterpriseDB 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.
-
How to integrate Metabase with Jira Data
Use CData Connect AI to connect to live Atlassian Jira and create an interactive dashboard in Metabase from Atlassian Jira.
-
How to Query Live Oracle Sales Data in Perplexity MacOS Desktop
Connect to and query live Oracle Sales Data in Perplexity Desktop using CData MCP Server.
-
Integrating Claude Code CLI with Brex 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.
-
Manage Bannerbear Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Bannerbear.
-
Natively Connect to LeadDesk Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to LeadDesk. Leverage the native support for ODBC in PHP.
-
ETL Quickbase in Oracle Data Integrator
This article shows how to transfer Quickbase into a data warehouse using Oracle Data Integrator.
-
Build Dashboards with SAP ByDesign Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Business ByDesign in Dundas BI.
-
Getting Started with the CData Tableau Connector for Cloudflare
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Google Ads-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Google Ads to explore live Google Ads Data in GitHub Copilot to assist with building Google Ads-powered applications.
-
Natively Connect to Moosend Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Moosend. Leverage the native support for ODBC in PHP.
-
Build DB2-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for DB2 to explore live DB2 Data in Cursor to assist with building DB2-powered applications.
-
Integrate with Clio Data in JReport Designer
Create charts and reports based on Clio in JReport Designer.
-
Integrating Cursor CLI with Chargebee 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.
-
Getting Started with the CData SSIS Components for Jumpseller
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Jumpseller.
-
Replicate Multiple Act-On Accounts
Replicate multiple Act-On accounts to one or many databases.
-
Query JotForm Data through ODBC in Node.js
Use node-odbc to execute SQL queries against JotForm from Node.js.
-
Use Microsoft Copilot Studio to talk to your Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Google Drive for you.
-
Create Apps from Freshdesk Data in Qlik Sense Cloud
Use CData Connect AI to connect to Freshdesk Data and build apps from live Freshdesk in Qlik Sense Cloud.
-
Work with Freshservice Data in FoxPro
Load Freshservice into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use Dash to Build to Web Apps on Sugar CRM Data
Create Python applications that use pandas and Dash to build Sugar CRM-connected web apps.
-
Use Grok to Talk to Your Procore 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 Procore for you.
-
Integrate Azure Synapse with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Azure Synapse with External Services.
-
Visualize Live Google Directory Data in the Power BI Service
Use CData Connect AI to connect to live Google Directory and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous iContact Replication to AlloyDB
Use CData Sync for automated, continuous, customizable iContact replication to AlloyDB.
-
Integrate LibreChat with Live Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Square from within the chat interface.
-
Connect to CloudConvert Data from a Connection Pool in Jetty
The CloudConvert JDBC Driver supports connection pooling: This article shows how to connect faster to CloudConvert from Web apps in Jetty.
-
Easily Integrate Odoo Data in Lazarus Pascal IDE
Learn how to easily integrate live Odoo ERP in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Bridge Oracle Financials Cloud Connectivity with Apache NiFi
Access and process Oracle Financials Cloud in Apache NiFi using the CData JDBC Driver.
-
Work with Azure DevOps Data in FoxPro
Load Azure DevOps into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software JDBC Driver for Mocean in MicroStrategy Desktop
Connect to Mocean in MicroStrategy Desktop using the CData Software JDBC Driver for Mocean.
-
Migrating data from Amazon Marketplace to Google BigQuery using CData SSIS Components.
Easily push Amazon Marketplace to Google BigQuery using the CData SSIS Tasks for Amazon Marketplace and Google BigQuery.
-
Operational Reporting on Impala Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache Impala.
-
Access Live Azure Data Lake Storage Data in Excel 365 Online (Excel for the web)
Connect to Azure Data Lake Storage from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Live Office 365 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 Microsoft Office 365 through MCP integration.
-
Replicate CampaignMonitor Data in Heroku for Use in Salesforce Connect
Replicate CampaignMonitor to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Google Analytics Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Analytics and visualize Google Analytics in SAP Analytics Cloud.
-
Access Live Dropbox Data in Excel 365 Online (Excel for the web)
Connect to Dropbox from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect DBeaver to BambooHR via a JDBC Driver
Manage BambooHR with visual tools in DBeaver like the query browser.
-
Access Live Google Ads Data in TIBCO Data Virtualization
Use the Google Ads Tibco DV Adapter to create a Google Ads data source in TIBCO Data Virtualization Studio and gain access to live Google Ads from your TDV Server.
-
Trigger SAP SuccessFactors IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAP SuccessFactors with standard wizards in Logic Apps.