CData Software - Knowledge Base
Recent Articles
-
Connect to Procore from Asprova with CData Software ODBC Driver for Procore
This article shows how to connect faster to Procore data from Asprova.
-
Connect to Google Spanner Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Spanner from Filemaker Pro on Mac.
-
Moving Data from YouTube Analytics to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live YouTube Analytics data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Apps from Greenhouse Data in Qlik Sense Cloud
Use CData Connect AI to connect to Greenhouse Data and build apps from live Greenhouse in Qlik Sense Cloud.
-
Integrate LibreChat with Live GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live GraphQL from within the chat interface.
-
Prepare, Blend, and Analyze Neo4J Data in Alteryx Designer (Connect AI)
Build workflows to access live Neo4J for self-service data analytics.
-
Connect and Query Live Epicor Kinetic Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Epicor Kinetic into Databricks
-
Connect to QuickBooks Time Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Sugar CRM within intelligent workflows.
-
Replicate Cosmos DB Data to Multiple Databases
Replicate Azure Cosmos DB to disparate databases with a point-and-click configuration.
-
How to Connect DBeaver to Microsoft Teams via a JDBC Driver
Manage Microsoft Teams with visual tools in DBeaver like the query browser.
-
Add SAP BusinessObjects BI Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP BusinessObjects BI with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to Live GitHub 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 GitHub for you.
-
How to connect to SAP Fieldglass Data from IntelliJ
Integrate connectivity to SAP Fieldglass with wizards in IntelliJ.
-
How to Connect to Live Zoom 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 Zoom for you.
-
Build Jira Assets-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Jira Assets Data and create custom apps in Mendix.
-
Choosing the Best Method to Connect AgileCRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use AgileCRM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate MySQL Data in Pentaho Data Integration
Build ETL pipelines based on MySQL in the Pentaho Data Integration tool.
-
Create SSAS Tabular Models from Microsoft Ads Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Ads using CData drivers.
-
How to Visualize Tickspot Data in Python with pandas
Use pandas and other modules to analyze and visualize live Tickspot in Python.
-
Access Live Zuora Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zuora into the statistical analysis tools available in SAS JMP. This article shows how to use Zuora in the Graph Builder and Query Builder.
-
How to Work with ZohoInvoice Data in ETL Validator JDBC
Connect to ZohoInvoice from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Optimizely Data from PowerBuilder via JDBC
This article demonstrates how to access Optimizely from PowerBuilder using the Optimizely JDBC Driver.
-
Integrate Workable with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Workable with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Workable.
-
Access Live Azure Table Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Azure Table data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Load SAP BusinessObjects BI Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP BusinessObjects BI to a database.
-
How to use SQLAlchemy ORM to access Discourse Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Discourse.
-
Integrate Open WebUI with Live SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP Fieldglass from within the chat interface.
-
Build Square-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Square to explore live Square Data in GitHub Copilot to assist with building Square-powered applications.
-
Connect to and Visualize Live Freshdesk Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Freshdesk.
-
Build Visualizations of Perigon Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Perigon in Birst.
-
Using the CData Software ODBC Driver for MailerLite in PyCharm
Connect to MailerLite as an ODBC data source in PyCharm using the CData Software ODBC Driver for MailerLite.
-
Connect to Sybase IQ Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Sybase IQ in the Denodo Virtual DataPort Administrator.
-
Connect to MailerLite Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MailerLite and the SQL Gateway to access MailerLite from Google Apps Script.
-
Connect to Real-Time ZohoMarketingHub Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZohoMarketingHub in Power Apps.
-
Analyze OData Services in Infragistics Reveal
Use the CData API Server to create an OData API on top of OData and visualize live OData in Infragistics Reveal.
-
How to Connect Cassandra Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Cassandra data in real time using natural language.
-
Visualize Landbot Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Landbot.
-
How to Query Live Phoenix Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apache Phoenix data in natural language using Python.
-
How to Visualize PingOne Data in Python with pandas
Use pandas and other modules to analyze and visualize live PingOne in Python.
-
Manage Epicor Kinetic Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Epicor Kinetic.
-
Connect to Xero Data in DBeaver
Use the CData ODBC Driver to connect to Xero Accounting in DBeaver.
-
Access Live Webflow Data in AWS Lambda
Connect to live Webflow in AWS Lambda using the CData JDBC Driver.
-
Access Live CampaignMonitor Data in AWS Lambda
Connect to live CampaignMonitor in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous eBay Analytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Azure SQL Database.
-
Extract, Transform, and Load Avalara AvaTax Data in Informatica PowerCenter
Create a simple Workflow for Avalara AvaTax in Informatica PowerCenter.
-
Integrate Live Zoom Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Zoom and integrate live Zoom into apps built in Microsoft Power Apps.
-
Query Cohere Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Cohere from Node.js.
-
Integrate Webex Data in the Pentaho Report Designer
Publish reports based on Webex in the Pentaho BI tool.
-
How to import ZohoExpense Data into Apache Solr
Use the CData Software JDBC Driver for ZohoExpense in Data Import Handler and create an automated import of ZohoExpense to Apache Solr Enterprise Search platform.
-
Connect to Live SAP Ariba Procurement Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP Ariba Procurement in CData Connect AI and connect to your SAP Ariba Procurement from PostgreSQL.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Campaign Manager 360
Create Google Campaign Manager 360 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Import Data from Google Spanner into Google Sheets
Import Google Spanner into a Google spreadsheet that is automatically refreshed.
-
Integrate Live Gong Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Gong and integrate live Gong into apps built in Microsoft Power Apps.
-
Create Adobe Commerce-Connected Nintex Workflows
Use CData Connect AI to connect to Adobe Commerce Data from Nintex Workflow Cloud and build custom workflows using live Adobe Commerce.
-
Automated Continuous CampaignMonitor Replication to Amazon S3
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Amazon S3.
-
Connect PingOne to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live PingOne using the CData Python MCP Server.
-
Integrating OpenCode Terminal with ServiceDesk Plus 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.
-
Import and Visualize Apollo Data in Power View
Create data visualizations based on Apollo in Excel.
-
Access SendInBlue 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 SendInBlue.
-
Automate Notion Data Replication to Azure Data Lake
Use CData Sync to customize and automate Notion replication to Azure Data Lake.
-
How to update Zendesk from Excel
This article explains how to transfer data from Excel to Zendesk using the Excel Add-In for Zendesk.
-
Create Google Cloud Storage-Connected Business Apps in AppSheet
Connect to Google Cloud Storage Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Cloud Storage.
-
How to Query Live Clari Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Clari data in natural language using Python.
-
Integrating Boomi Agentstudio with SAP ByDesign Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP Business ByDesign, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automate CockroachDB Data Replication to Azure Data Lake
Use CData Sync to customize and automate CockroachDB replication to Azure Data Lake.
-
Visualize Brex Data in Tableau
The CData ODBC driver for Brex enables you integrate Brex into Tableau dashboards.
-
How to create Optimizely federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Optimizely in MySQL .
-
Back Up Google Ad Manager to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Ad Manager. In this article, we will employ an SSIS workflow to populate a database with Google Ad Manager data.
-
Natively Connect to Webflow Data in PHP
The CData ODBC driver for Webflow enables you to create PHP applications with connectivity to Webflow. Leverage the native support for ODBC in PHP.
-
Connect to WooCommerce Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for WooCommerce.
-
Creating Tally-Connected Applications in Unqork
You can use CData Connect AI to feed Tally ERP to Unqork and build custom business apps.
-
How to Easily Query Figshare Data in OpenOffice Base
Connect to Figshare data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Airtable to Power BI dashboards. Simply drag and drop Airtable into data visuals on the Power BI canvas.
-
Create Workable Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Workable data access from reports, embedded analytics, and more.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ConvertAPI
Provide connectivity to ConvertAPI through an SAP BusinessObjects universe.
-
Automate Keap Data Replication to Azure Data Lake
Use CData Sync to customize and automate Keap replication to Azure Data Lake.
-
Create Informatica Mappings From/To a JDBC Data Source for ShipStation
Create ShipStation data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Design BIRT Reports on REST Data
Provide current REST to your embedded analytics.
-
Establish a Live Connection with Shortcut Data using Tableau Bridge
The CData ODBC Driver for Shortcut enables you to integrate live Shortcut into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Avalara AvaTax with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Avalara AvaTax with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Avalara AvaTax.
-
Use Claude to Talk to Your MYOB AccountRight 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 MYOB AccountRight for you.
-
Connect to SAP BusinessObjects BI 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 BusinessObjects BI.
-
Establish a Live Connection with Wave Financial Data using Tableau Bridge
The CData ODBC Driver for Wave Financial enables you to integrate live Wave Financial into Tableau Cloud dashboards using the Tableau Bridge.
-
DataBind Controls to BenchmarkEmail Data in Delphi
DataBind to BenchmarkEmail in Delphi with standard data access components and controls.
-
Getting Started with the CData Power BI Connector for Google Drive
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Drive.
-
Working with Sage 200 Data in LINQPad
Execute LINQ queries to Sage 200 in LINQPad.
-
Visualize Codat 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 Codat into TIBCO Spotfire.
-
Connect to Microsoft Exchange Data from a Connection Pool in JBoss
Integrate Microsoft Exchange into Java servlets: Use the Management Console in JBoss to install the Microsoft Exchange JDBC Driver.
-
Use the CData Software ODBC Driver for SAP HANA XS Advanced in MicroStrategy Desktop
Connect to SAP HANA XS Advanced in MicroStrategy Desktop using the CData Software ODBC Driver for SAP HANA XS Advanced.
-
A PostgreSQL Interface for Zuora Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zuora JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Todoist in MicroStrategy Desktop
Connect to Todoist in MicroStrategy Desktop using the CData Software ODBC Driver for Todoist.
-
Connect to SAP Fieldglass Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP Fieldglass and the SQL Gateway to access SAP Fieldglass from Google Apps Script.
-
Automated Continuous DB2 Replication to MySQL
Use CData Sync for automated, continuous, customizable DB2 replication to MySQL.
-
Integrating Cursor CLI with Amplitude 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 Vault CRM Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Veeva Vault & Vault CRM in SnapLogic.
-
Connect to SAP HANA XS Advanced Data in DBArtisan
Use wizards in DBArtisan to configure SAP HANA XS Advanced as a data source.
-
Connect to Cassandra Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Cassandra from Appeon PowerBuilder using the CData ADO.NET Provider for Cassandra.
-
Integrating OpenCode Terminal with eBay 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 Datadog Data in JReport Designer
Create charts and reports based on Datadog in JReport Designer.