CData Software - Knowledge Base
Recent Articles
-
Connect to Adobe Experience Manager Data from a Connection Pool in JBoss
Integrate Adobe Experience Manager into Java servlets: Use the Management Console in JBoss to install the Adobe Experience Manager JDBC Driver.
-
How to Connect DBeaver to Wave Financial via a JDBC Driver
Manage Wave Financial with visual tools in DBeaver like the query browser.
-
Prepare, Blend, and Analyze Hugging Face Data in Alteryx Designer (ODBC)
Build workflows to access live Hugging Face for self-service data analytics.
-
Create Dynamic Couchbase Grids Using the Infragistics XamDataGrid
Learn how you can connect Couchbase to Infragistics XamDataGrid to build dynamic grids.
-
How to Build an ETL App for Twitter Ads Data in Python with CData
Create ETL applications and real-time data pipelines for Twitter Ads in Python with petl.
-
Create Reports from Avro Data in Looker Studio
Use CData Connect AI to gain access to live Apache Avro and create custom reports in Looker Studio.
-
Enable the Sugar CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Sugar CRM.
-
Connect to Oracle Eloqua from Asprova with CData Software ODBC Driver for Oracle Eloqua
This article shows how to connect faster to Oracle Eloqua data from Asprova.
-
How to Import Data from BigCommerce into Google Sheets
Import BigCommerce into a Google spreadsheet that is automatically refreshed.
-
Build Tally-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Tally to explore live Tally Data in GitHub Copilot to assist with building Tally-powered applications.
-
How to Easily Query CockroachDB Data in OpenOffice Base
Connect to CockroachDB data in OpenOffice Base using the CData ODBC Driver for CockroachDB and generate reports with live data insights.
-
How to Connect to Live Cosmos DB Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Azure Cosmos DB securely in real time.
-
Build Pipelines with Live SAS Data Sets Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAS Data Sets from Google Cloud Data Fusion, enabling the integration of live SAS Data Sets into the building and management of effective data pipelines.
-
Build FHIR-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live FHIR and build FHIR-connected web apps with Axios.
-
How to connect to BenchmarkEmail Data from IntelliJ
Integrate connectivity to BenchmarkEmail with wizards in IntelliJ.
-
Create Dynamic Autopilot Grids Using the Infragistics XamDataGrid
Learn how you can connect Autopilot to Infragistics XamDataGrid to build dynamic grids.
-
Analyze ServiceNow Data in Cognos Analytics
Use CData Connect AI to connect to ServiceNow Data from Cognos Analytics and analyze live ServiceNow.
-
Create Datasets from Presto in Domo Workbench and Build Visualizations of Presto Data in Domo
Use the CData Software ODBC Driver for Presto to create datasets from Presto in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Printful Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Printful replication to Apache Cassandra.
-
Integrating Kiro CLI with Sage 300 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.
-
Access Live Zendesk Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Zendesk data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Connect to & Open Jira Data in Microsoft Excel
This article uses the CData ODBC driver for Jira to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Import Data from Databricks into Google Sheets
Import Databricks into a Google spreadsheet that is automatically refreshed.
-
Getting Started with the CData Power BI Connector for YouTube Analytics
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for YouTube Analytics.
-
Connect to Jira Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Atlassian Jira.
-
Design BIRT Reports on Parallel Data
Provide current Parallel to your embedded analytics.
-
Natively Connect to Dotmailer Data in PHP
The CData ODBC driver for Dotmailer enables you to create PHP applications with connectivity to Dotmailer. Leverage the native support for ODBC in PHP.
-
Visualize WooCommerce Data in Tableau
The CData ODBC driver for WooCommerce enables you integrate WooCommerce into Tableau dashboards.
-
Publish CouchDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apache CouchDB.
-
Use the CData Software ODBC Driver for RSS in MicroStrategy Desktop
Connect to RSS Feeds in MicroStrategy Desktop using the CData Software ODBC Driver for RSS.
-
Integrate Freshteam Data in Pentaho Data Integration
Build ETL pipelines based on Freshteam in the Pentaho Data Integration tool.
-
Work with SendPulse Data in FoxPro
Load SendPulse into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Dashboards and Visualize Live Elasticsearch Data in Geckoboard
Use CData Connect AI to connect to live Elasticsearch and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Goose with Live Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Redis from within the local AI agent.
-
Visualize Live Amazon S3 Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Amazon S3.
-
Build FHIR-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for FHIR Data and create custom apps in Mendix.
-
Query Live Trello Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Trello directly from the development environment.
-
Create Power BI Reports on Real-Time Jodoo Data
Use the CData ODBC Driver for Jodoo to visualize Jodoo in Power BI Desktop.
-
Access Live MailChimp 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 MailChimp through MCP integration.
-
Integrating Cursor CLI with FreshBooks 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 Dropbox with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Dropbox with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Dropbox.
-
Integrate Live MarkLogic Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live MarkLogic to Blue Prism using the CData ODBC Driver for MarkLogic to create automated workflows for repetitive business tasks.
-
Build Freshservice-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Freshservice Data and create custom apps in Bubble.
-
Connect to Salesforce Marketing Data in ACL Analytics
Connect to Salesforce Marketing Cloud via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Salesforce Marketing Cloud.
-
Integrating Claude Code CLI with Google Sheets 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.
-
Visualize Amazon Marketplace Data in TIBCO Spotfire through ADO.NET
Integrate Amazon Marketplace into dashboards in TIBCO Spotfire.
-
How to Work with AlloyDB Data in AWS Glue Jobs Using JDBC
Connect to AlloyDB from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Scrapfly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Scrapfly from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Short.io Data in JRuby
Create a simple JRuby app with access to live Short.io.
-
Build Semantic Layer Views for Amazon Athena Data in APOS Live Data Gateway
Use the CData Connector for Amazon Athena in APOS Live Data Gateway to build Semantic Layer Views for Amazon Athena.
-
Visualize Live Cvent Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Cvent into custom reports in Power BI.
-
How to Create Power BI Visual Reports with Real-Time Mouseflow Data
Use CData Power BI Connectors to visualize Mouseflow in Power BI.
-
How to Import Data from Oracle Service Cloud into Google Sheets
Import Oracle Service Cloud into a Google spreadsheet that is automatically refreshed.
-
Use JayDeBeApi to access Keap Data in Python
Use standard Python scripting and the development environment of your choice to access live Keap.
-
Connect to Dynamics CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Dynamics CRM to connect to Microsoft Dynamics CRM from Web applications running on WebLogic.
-
Visualize Live Apollo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Apollo into custom reports in Power BI.
-
How to Create Power BI Visual Reports with Real-Time SharePoint Excel Services Data
Use CData Power BI Connectors to visualize SharePoint Excel Services in Power BI.
-
Build Automated Oracle Service Cloud-Connected Workflows in Zapier
Use CData Connect AI to connect to live Oracle Service Cloud and build automated workflows in Zapier.
-
Connect to Jumpseller Data in RapidMiner
Integrate Jumpseller with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Apps from QuickBooks Time Data in Qlik Sense Cloud
Use CData Connect AI to connect to QuickBooks Time Data and build apps from live QuickBooks Time in Qlik Sense Cloud.
-
Import and Visualize ShipEngine Data in Power View
Create data visualizations based on ShipEngine in Excel.
-
Getting Started with the CData ADO.NET Provider for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Dynamics CRM.
-
Edit and Search Gmail External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Gmail to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Gmail objects that you can access from apps and the dashboard.
-
Replicate Intercom Data in Heroku for Use in Salesforce Connect
Replicate Intercom to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Dynamics NAV Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Dynamics NAV as an External Source in Dremio.
-
How to Access Live GitHub Data in Visual Studio Code via Cline
Run CData MCP Server for GitHub on Windows Subsytem for Linux (WSL) and connect to live GitHub from the Cline extension in Visual Studio Code.
-
Use Dash to Build to Web Apps on Outlook Data
Create Python applications that use pandas and Dash to build Outlook-connected web apps.
-
Stream Cassandra Data into Apache Kafka Topics
Access and stream Apache Cassandra in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Publish SAP HANA-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP HANA.
-
Feed Cohere Data into FineReport
How to set Cohere as a JDBC data source in FineReport.
-
Connect Amplitude Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Amplitude using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query Dynamics 365 Business Central Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Dynamics 365 Business Central entities in PHP by modeling them as objects.
-
ETL Adobe Target in Oracle Data Integrator
This article shows how to transfer Adobe Target into a data warehouse using Oracle Data Integrator.
-
Build YouTube Analytics-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for YouTube Analytics Data and create custom apps in Mendix.
-
How to Seamlessly Import Xero Data into IBM SPSS Modeler
Integrate Xero data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Accelo 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 Accelo.
-
Consume MySQL OData Feeds in PowerBuilder
This article demonstrates how to consume MySQL as OData feeds from PowerBuilder using the API Server.
-
Connect to Access Data from a Connection Pool in Jetty
The Access JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Access from Web apps in Jetty.
-
Publish Google Directory-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Directory.
-
Access PolarTeamPro Data from MySQL in PHP
Connect to PolarTeamPro through the standard MySQL libraries in PHP.
-
Import and Visualize NetSuite Data in Power View
Create data visualizations based on NetSuite CRM & ERP in Excel.
-
Build Data Flows from Workable to SQL Server using SSIS
Easily back up Workable to SQL Server using the SSIS components for Workable.
-
Work with ClickUp Data in FoxPro
Load ClickUp into a FoxPro database. This article includes full code and a walk-through of the process.
-
Extract, Transform, and Load Salesforce Marketing Data in Informatica PowerCenter
Create a simple Workflow for Salesforce Marketing Cloud in Informatica PowerCenter.
-
How to Query Live Asana Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Asana data in natural language using Python.
-
Configure the CData JDBC Driver for Adobe Experience Manager in a Connection Pool in Tomcat
Connect to Adobe Experience Manager from a connection pool in Tomcat.
-
Start with CData Sync Part 3: Creating a Transformation Job
Use CData Sync to create a transformation job to manipulate your data.
-
Getting Started with the CData ADO.NET Provider for Quickbase
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Quickbase.
-
Integrate Amazon DynamoDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Amazon DynamoDB with External Services.
-
How to Build an ETL App for MailChimp Data in Python with CData
Create ETL applications and real-time data pipelines for MailChimp in Python with petl.
-
How to Build an ETL App for Freshservice Data in Python with CData Connect AI
Build ETL pipelines that read and write live Freshservice in Python with petl and the CData Connect AI Python SDK.
-
How to Connect Flowise AI Agents to Live Google Drive Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Google Drive without replication.
-
How to Query Live CSV Data in Claude Desktop
Connect to and query live CSV Data in Claude Desktop using CData MCP Server.
-
Automated Figshare Data Replication to Teradata
Use CData Sync to Customize and automate Figshare replication to Teradata.
-
Create Google Ads Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Ads from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Antigravity CLI with ServiceDesk Plus via CData CLI
Connect ServiceDesk Plus to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Excel Online Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Excel Online to connect to Microsoft Excel Online and execute queries in PowerBuilder.
-
Analyze Adobe Commerce Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Adobe Commerce and visualize live Adobe Commerce in Infragistics Reveal.
-
Build Data Flows from Reckon to SQL Server using SSIS
Easily back up Reckon to SQL Server using the SSIS components for Reckon.
-
Create a Data Access Object for JSON Services using JDBI
A brief overview of creating a SQL Object API for JSON in JDBI.