CData Software - Knowledge Base
Recent Articles
-
Build AI/ML Models with Live Amazon S3 Data using Dataiku
Connect Amazon S3 Data with Dataiku using the CData JDBC Driver for Amazon S3.
-
Connecting Agentforce with ServiceDesk Plus Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your ServiceDesk Plus data for you.
-
Connect to Sage Intacct Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Sage Intacct as an External Source in Dremio.
-
Analyze AfterShip Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze AfterShip data in Microsoft R Open.
-
Connect to Egnyte Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Egnyte data.
-
Automated Continuous Sage 200 Replication to Vertica
Use CData Sync for automated, continuous, customizable Sage 200 replication to Vertica.
-
How to integrate Zoho Creator with Apache Airflow
Access and process Zoho Creator data in Apache Airflow using the CData JDBC Driver.
-
Connect to Exact Online from a Connection Pool in WebLogic
Use the CData JDBC Driver for Exact Online to connect to Exact Online data from Web applications running on WebLogic.
-
Connecting Pipedream with Wistia Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Wistia data in real time.
-
Connecting GenSpark with Zendesk Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Zendesk data without any replication or custom integration required.
-
Build a PostgreSQL Interface for SharePoint Excel Services Data using the CData JDBC Driver
Use the Remoting features of the SharePoint Excel Services JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Azure Synapse Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Azure Synapse data.
-
Model, Search, and Visualize Live WordPress Data in ThoughtSpot
Use CData Connect AI to connect to live WordPress data for modeling, searching, and visualizing.
-
Create Azure Data Lake Storage-Connected Business Apps in AppSheet
Connect to Azure Data Lake Storage Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Azure Data Lake Storage data.
-
Build Apps with Live Clio Data Using the Low-Code Development Platform of Mendix
Connect Clio data with Mendix to build apps using the CData API Driver for JDBC.
-
Trigger Xero IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Xero with standard wizards in Logic Apps.
-
Integrate Live Zuora Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zuora data to Blue Prism using the CData ODBC Driver for Zuora to create automated workflows for repetitive business tasks.
-
Import Real-Time SharePoint Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SharePoint data in ColdFusion.
-
Getting Started with the CData JDBC Driver for Humanity
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Humanity.
-
Integrate OpenCode with Live Sybase Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Sybase data from within your AI coding agent.
-
Visualize Shippo Data in Sisense
Create an ElastiCube in Sisense app with access to Shippo data.
-
Integrate Google's Vertex AI Agent with Live Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zendesk data within intelligent workflows.
-
Create Power BI Reports on Real-Time Oracle Service Cloud Data
Use the CData ODBC Driver for Oracle Service Cloud to visualize Oracle Service Cloud data in Power BI Desktop.
-
Use Dash to Build Web Apps on SAP Ariba Source Data via CData Connect AI
Build interactive Dash web apps on live SAP Ariba Source data using pandas and the CData Connect AI Python SDK.
-
Access Live Nuclia Data in AWS Lambda
Connect to live Nuclia data in AWS Lambda using the CData JDBC Driver.
-
Integrate Trae with Live Microsoft Exchange Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Microsoft Exchange data from within the AI-powered IDE.
-
How to integrate Metabase with PingOne Data
Use CData Connect AI to connect to live PingOne data and create an interactive dashboard in Metabase from PingOne data.
-
Replicate GitLab Data to Multiple Databases
Replicate GitLab data to disparate databases with a point-and-click configuration.
-
How to Connect to & Open Discourse Data in Microsoft Excel
This article uses the CData ODBC driver for Discourse to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Productboard Data from PowerBuilder via ADO.NET
This article demonstrates how to access Productboard data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Connect to & Open EmailOctopus Data in Microsoft Excel
This article uses the CData ODBC driver for EmailOctopus to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to import ZarMoney Data into Apache Solr
Use the CData Software JDBC Driver for ZarMoney in Data Import Handler and create an automated import of ZarMoney data to Apache Solr Enterprise Search platform.
-
Natively Connect to Deel Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Deel data. Leverage the native support for ODBC in PHP.
-
How to import ChartMogul Data into Apache Solr
Use the CData Software JDBC Driver for ChartMogul in Data Import Handler and create an automated import of ChartMogul data to Apache Solr Enterprise Search platform.
-
Create Google Drive Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Drive data access from reports, embedded analytics, and more.
-
Odoo Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Odoo data through CData Connect AI using different applications and tools.
-
Automated Continuous Zoho Recruit Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zoho Recruit replication to Apache Cassandra.
-
Getting Started with the CData JDBC Driver for AfterShip
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for AfterShip.
-
How to Build an ETL App for Neo4J Data in Python with CData
Create ETL applications and real-time data pipelines for Neo4J data in Python with petl.
-
Visualize Live CircleCI Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live CircleCI data.
-
Connect to Anaplan Data in RapidMiner
Integrate Anaplan data with standard components and data source configuration wizards in RapidMiner Studio.
-
Natively Connect to Epicor Kinetic Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Epicor Kinetic data. Leverage the native support for ODBC in PHP.
-
Connect Procore to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Procore data using the CData Python MCP Server.
-
How to Create Power BI Visual Reports with Real-Time Pingdom Data
Use CData Power BI Connectors to visualize Pingdom data in Power BI.
-
Connect Cassandra Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Cassandra data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Instagram Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Instagram data using standard SQL.
-
Build Redshift Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Redshift data and build visualizations in Tableau.
-
How to integrate Metabase with Aweber Data
Use CData Connect AI to connect to live Aweber data and create an interactive dashboard in Metabase from Aweber data.
-
Replicate Paymo Data to Multiple Databases
Replicate Paymo data to disparate databases with a point-and-click configuration.
-
Visualize Certinia Data in TIBCO Spotfire through OData
Integrate Certinia data into dashboards in TIBCO Spotfire.
-
Replicate Multiple Coda Accounts
Replicate multiple Coda accounts to one or many databases.
-
Visualize Shortcut 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 Shortcut data into TIBCO Spotfire.
-
Integrating Kiro with Avaza 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 Query Omnisend Data in MySQL Workbench
Execute MySQL queries against live Omnisend data from MySQL Workbench.
-
Provide OData Services of Blackbaud FE NXT Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Blackbaud FE NXT data by developing a WCF Service Application.
-
Connect to Dynamics NAV Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Dynamics NAV data using standard SQL.
-
Use Grok to Talk to Your SAP SuccessFactors 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 SAP SuccessFactors data for you.
-
Build Dashboards with Snowflake Data in DBxtra
Create dynamic dashboards and perform analytics based on Snowflake data in DBxtra.
-
Back Up Scrapfly data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Scrapfly data data.
-
Using the CData Software ODBC Driver for Google Contacts in PyCharm
Connect to Google Contacts as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Contacts.
-
Automated Continuous Cvent Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Cvent replication to Google BigQuery.
-
Publish Perplexity-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Perplexity data.
-
Build Visualizations of Webflow Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Webflow data in Birst.
-
How to Connect to Amazon DynamoDB Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Amazon DynamoDB data. Leverage the pyodbc module for ODBC in Python.
-
Build AI/ML Models with Live Moosend Data using Dataiku
Connect Moosend Data with Dataiku using the CData API Driver for JDBC.
-
How to connect to Google Sheets Data in DBVisualizer
Integrate Google Sheets data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Wrike Replication to Vertica
Use CData Sync for automated, continuous, customizable Wrike replication to Vertica.
-
Build Google Drive-Connected Apps in Choreo
Use CData Connect AI to connect to Google Drive Data from Choreo and build custom apps using live Google Drive data.
-
Automated Continuous Teradata Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Teradata replication to Amazon S3.
-
Consume IBM Cloud Object Storage OData Feeds in SAP Lumira
Use the API Server to create data visualizations on IBM Cloud Object Storage feeds that reflect any changes in SAP Lumira.
-
Moving Data from CockroachDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live CockroachDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create JotForm Dataflows on PowerBI.com
Connect to the CData Power BI Connector for JotForm from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData Power BI Connector for Authorize.Net
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Authorize.Net.
-
Add OnePageCrm Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for OnePageCrm with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to Live TaxJar Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your TaxJar data for you.
-
Query YouTube Analytics Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume YouTube Analytics entities in PHP by modeling them as objects.
-
Build Dashboards with Workable Data in Dundas BI
Create dynamic dashboards and perform analytics based on Workable data in Dundas BI.
-
Publish Vault CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Vault CRM data.
-
Build Klipfolio-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Klipfolio Data and create custom apps in Mendix.
-
Connecting Agentforce with Pipedrive Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Pipedrive data for you.
-
Integrate Real-Time Access to SAP Ariba Procurement in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Ariba Procurement data in real time.
-
Connecting Mastra with Phoenix 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 Phoenix data, no replication required.
-
Scrapfly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Scrapfly facts in real time.
-
Connect to Insightly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Insightly data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrate Trae with Live CockroachDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live CockroachDB data from within the AI-powered IDE.
-
Connect to Pushbullet from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pushbullet to connect to Pushbullet data from Web applications running on WebLogic.
-
Integrate Open WebUI with Live Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure DevOps data from within the chat interface.
-
Connect to Oracle Financials Cloud from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle Financials Cloud data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Query Aircall Data in DataGrip
Create a Data Source for Aircall in DataGrip and use SQL to query live Aircall data.
-
Access Live Hugging Face Data in Coginiti Pro
Connect to and query live Hugging Face data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to and Visualize Live YouTube Analytics Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live YouTube Analytics data.
-
Build Dashboards with Typeform Data in DBxtra
Create dynamic dashboards and perform analytics based on Typeform data in DBxtra.
-
ETL xBase in Oracle Data Integrator
This article shows how to transfer xBase data into a data warehouse using Oracle Data Integrator.
-
Connect to Microsoft OneDrive Data in Jaspersoft Studio
Execute SQL to remote Microsoft OneDrive data in Jaspersoft Studio.
-
Using the CData Software ODBC Driver for Bugsnag in PyCharm
Connect to Bugsnag as an ODBC data source in PyCharm using the CData Software ODBC Driver for Bugsnag.
-
Integrating Claude Code with Toggl Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Toggl data within assisted coding and automated development workflows.
-
Getting Started with the CData ODBC Driver for Campaigner
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Campaigner.
-
Prepare, Blend, and Analyze Google Ads Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Ads data for self-service data analytics.
-
Access Live Zendesk Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Zendesk data through MCP integration.
-
Consume Stripe OData Feeds in PowerBuilder
This article demonstrates how to consume Stripe data as OData feeds from PowerBuilder using the API Server.