CData Software - Knowledge Base
Recent Articles
-
Build Salesforce Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Salesforce & Force.com and build visualizations in Tableau Cloud.
-
Configure the CData JDBC Driver for Google Sheets in a Connection Pool in Tomcat
Connect to Google Sheets from a connection pool in Tomcat.
-
Connect to Rebilly Data from PowerBuilder via JDBC
This article demonstrates how to access Rebilly from PowerBuilder using the Rebilly JDBC Driver.
-
Excel Spreadsheet Automation on ServiceNow Data with the QUERY Formula
Pull data from ServiceNow, automate spreadsheets, and more with the QUERY formula.
-
Use Dash to Build to Web Apps on MongoDB Data
Create Python applications that use pandas and Dash to build MongoDB-connected web apps.
-
How to Connect to Live Microsoft Entra ID Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Microsoft Entra ID for you.
-
Build Pipedrive-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Pipedrive.
-
Connect to Avro Data in NetBeans
Connect to Apache Avro in NetBeans with the data source configuration wizard.
-
Automated Continuous Email Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Email replication to Google Cloud SQL.
-
Operational Reporting on Zoom Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zoom.
-
Automate Aweber Data Replication to Azure Data Lake
Use CData Sync to customize and automate Aweber replication to Azure Data Lake.
-
Use Dash to Build to Web Apps on ScrapingBee Data
Create Python applications that use pandas and Dash to build ScrapingBee-connected web apps.
-
Publish Reports with Strava Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Strava.
-
Visualize HBase Data in TIBCO Spotfire through ADO.NET
Integrate Apache HBase into dashboards in TIBCO Spotfire.
-
How to Work with ShipEngine Data in AWS Glue Jobs Using JDBC
Connect to ShipEngine from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Query Live Mocean Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mocean data in natural language using Python.
-
How to connect to Exa Data with Squirrel SQL client
Connect to Exa and execute queries in the Squirrel SQL Client.
-
Build Semantic Layer Views for Zoom Data in APOS Live Data Gateway
Use the CData Connector for Zoom in APOS Live Data Gateway to build Semantic Layer Views for Zoom.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Excel
Provide connectivity to Microsoft Excel through an SAP BusinessObjects universe.
-
How to use SQLAlchemy ORM to access Okta Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Okta.
-
Use Dash to Build to Web Apps on Missive Data
Create Python applications that use pandas and Dash to build Missive-connected web apps.
-
Connect to ZohoInvoice Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZohoInvoice in the Denodo Virtual DataPort Administrator.
-
Visualize Live Zoho Creator Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho Creator.
-
Create Power BI Reports on Real-Time Rootly Data
Use the CData ODBC Driver for Rootly to visualize Rootly in Power BI Desktop.
-
Create Informatica Mappings From/To a JDBC Data Source for Adobe Experience Manager
Create Adobe Experience Manager data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect to Google Translate Data from Spring Boot
Connect to Google Translate in a Spring Boot Application using the CData API Driver for JDBC
-
Connect Redshift to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Redshift with IBM WebSphere for seamless data integration and connectivity.
-
Operational Reporting on ShipStation Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ShipStation.
-
Integrating Antigravity CLI with Amazon Athena via CData CLI
Connect Amazon Athena to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Google Calendar Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Calendar and integrate live Google Calendar into your Power Automate tasks.
-
Create Reports with SpaceX Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SpaceX.
-
Build Voice Agents in ElevenLabs with access to Live Azure DevOps Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Azure DevOps.
-
How to load Mistral AI data into Elasticsearch via Logstash
Introducing a simple method to load Mistral AI data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Datasets from ZohoInvoice in Domo Workbench and Build Visualizations of ZohoInvoice Data in Domo
Use the CData Software ODBC Driver for ZohoInvoice to create datasets from ZohoInvoice in Domo Workbench and then build visualizations in the Domo service.
-
Connect to SAP SuccessFactors LMS Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SAP SuccessFactors LMS.
-
Integrating Cursor CLI with Dynamics 365 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.
-
Connect to ConstantContact Data from a Connection Pool in JBoss
Integrate ConstantContact into Java servlets: Use the Management Console in JBoss to install the ConstantContact JDBC Driver.
-
Create Datasets from Office 365 in Domo Workbench and Build Visualizations of Office 365 Data in Domo
Use the CData Software ODBC Driver for Office 365 to create datasets from Microsoft Office 365 in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Live JobNimbus Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live JobNimbus.
-
Use Claude to Talk to Your Microsoft Ads 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 Microsoft Ads for you.
-
Automated Continuous Google Cloud Storage Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to delimited files (CSV/TSV).
-
How to connect SharePoint with Rootly Data through external lists
Provide Rootly to SharePoint users as an external list.
-
Create Dynamic Foursquare Grids Using the Infragistics XamDataGrid
Learn how you can connect Foursquare to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Dotmailer Data from PowerShell
Write a quick PowerShell script to query Dotmailer. Use connectivity to the live data to replicate Dotmailer to SQL Server.
-
How to Query Live SAP Business Warehouse Data in Perplexity MacOS Desktop
Connect to and query live SAP Business Warehouse Data in Perplexity Desktop using CData MCP Server.
-
Creating DB2-Connected Applications in Unqork
You can use CData Connect AI to feed IBM DB2 to Unqork and build custom business apps.
-
Query Wistia Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Wistia entities in PHP by modeling them as objects.
-
Replicate Multiple Box Accounts via the CData Sync CLI
Replicate multiple Box accounts to one or many databases.
-
Getting Started with the CData Excel Add-In for Azure Data Catalog
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Azure Data Catalog.
-
Create Epicor Kinetic-Connected Business Apps in AppSheet
Connect to Epicor Kinetic Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Epicor Kinetic.
-
Getting Started with the CData ODBC Driver for QuickBooks
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for QuickBooks.
-
How to create Visio diagrams from Smartsheet Data
Automatically update Smartsheet with the changes you make to Visio master shapes.
-
Integrate SendGrid Data in Pentaho Data Integration
Build ETL pipelines based on SendGrid in the Pentaho Data Integration tool.
-
Use the CData Software JDBC Driver for Confluence in MicroStrategy Desktop
Connect to Atlassian Confluence in MicroStrategy Desktop using the CData Software JDBC Driver for Confluence.
-
Operational Reporting on Elasticsearch Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Elasticsearch.
-
How to connect to AgileCRM Data from IntelliJ
Integrate connectivity to AgileCRM with wizards in IntelliJ.
-
How to Import Data from Outreach.io into Google Sheets
Import Outreach.io into a Google spreadsheet that is automatically refreshed.
-
Integrate Dynamics NAV with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Dynamics NAV with External Services.
-
Getting Started with the CData ODBC Driver for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for CapsuleCRM.
-
Build Data Flows from SQL Server to Klaviyo through SSIS
Easily push SQL Server data to Klaviyo using the CData SSIS Tasks for Klaviyo.
-
Access Salesforce Data 360 Data from MySQL in PHP
Connect to Salesforce Data 360 through the standard MySQL libraries in PHP.
-
Build Cloudant-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for IBM Cloudant to explore live Cloudant Data in GitHub Copilot to assist with building Cloudant-powered applications.
-
Integrating Gumloop with Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoho Projects within automated workflows.
-
How to use SQLAlchemy ORM to access Beeminder Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Beeminder.
-
Integrate with Oracle HCM Cloud Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Oracle HCM Cloud to a JSON file on disk.
-
Automate Paymo Data Replication to Azure Synapse
Use CData Sync to customize and automate Paymo replication to Azure Synapse.
-
Connect to RabbitMQ Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for RabbitMQ and the SQL Gateway to access RabbitMQ from Google Apps Script.
-
Automated Continuous HBase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable HBase replication to Amazon S3.
-
How to load Paymo data into Elasticsearch via Logstash
Introducing a simple method to load Paymo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Parallel Data from PowerBuilder via JDBC
This article demonstrates how to access Parallel from PowerBuilder using the Parallel JDBC Driver.
-
Use the CData SSIS Components to Insert New or Update Existing Excel Records from SQL Server
Easily push SQL Server data to Excel using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Excel or update existing records with data from a SQL Server database.
-
Connect to CouchDB Data in ACL Analytics
Connect to Apache CouchDB via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apache CouchDB.
-
Connect to Live Cloudant Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Cloudant in CData Connect AI and connect to your IBM Cloudant from PostgreSQL.
-
Integrating GitHub Copilot CLI with Demio 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.
-
Extract, Transform, and Load FormSite Data in Informatica PowerCenter
Create a simple Workflow for FormSite in Informatica PowerCenter.
-
How to publish and share Marketo Data dashboards with Tableau Server
The CData ODBC driver for Marketo enables you integrate Marketo into Tableau dashboards.
-
Connect to Quickbase Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Quickbase using standard SQL.
-
How to Query Live Oracle Eloqua Reporting Data in Claude Desktop
Connect to and query live Oracle Eloqua Reporting Data in Claude Desktop using CData MCP Server.
-
Access Live Microsoft Teams Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Teams from your Google Sheets.
-
MariaDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MariaDB facts in real time.
-
Connect and Query Live Oracle Financials Cloud Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Oracle Financials Cloud into Databricks
-
Visualize Paymo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Paymo.
-
Analyze Google Cloud Storage Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Cloud Storage and visualize Google Cloud Storage in SAP Analytics Cloud.
-
Analyze Anaplan Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Anaplan and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Auth0 Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Auth0 from Informatica Cloud.
-
Create Data Visualizations in Cognos BI with Salesforce Data
This article describes how to use the CData ODBC Driver for Salesforce in Cognos BI.
-
How to import Impala Data into Apache Solr
Use the CData Software JDBC Driver for Impala in Data Import Handler and create an automated import of Apache Impala to Apache Solr Enterprise Search platform.
-
Natively Connect to QuickBooks Data in PHP
The CData ODBC driver for QuickBooks enables you to create PHP applications with connectivity to QuickBooks Desktop. Leverage the native support for ODBC in PHP.
-
Create Vimeo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Vimeo from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Anaplan Data in Tableau
The CData ODBC driver for Anaplan enables you integrate Anaplan into Tableau dashboards.
-
Load Gumroad Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Gumroad to a database.
-
Publish MailerSend-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live MailerSend.
-
Using the CData Software ODBC Driver for Browserless in PyCharm
Connect to Browserless as an ODBC data source in PyCharm using the CData Software ODBC Driver for Browserless.
-
Connect to Oracle Sales Data from a Connection Pool in JBoss
Integrate Oracle Sales into Java servlets: Use the Management Console in JBoss to install the Oracle Sales JDBC Driver.
-
Build Semantic Layer Views for EnterpriseDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for EnterpriseDB.
-
Integrating Claude Code CLI with LaunchDarkly 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.
-
Connect to Zendesk from Asprova with CData Software ODBC Driver for Zendesk
This article shows how to connect faster to Zendesk data from Asprova.
-
Load SAP Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP ERP/NetWeaver to a database.
-
Query Elasticsearch Data as a MySQL Database in Node.js
Execute MySQL queries against Elasticsearch from Node.js.
-
Visualize GetResponse Data in TIBCO Spotfire through OData
Integrate GetResponse into dashboards in TIBCO Spotfire.