CData Software - Knowledge Base
Recent Articles
-
How to connect to NetSuite Data from IntelliJ
Integrate connectivity to NetSuite CRM & ERP with wizards in IntelliJ.
-
Build IBM Cloud Object Storage-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live IBM Cloud Object Storage.
-
Automate Jira Assets Data Replication to Couchbase
Use CData Sync to Customize and automate Jira Assets replication to Couchbase.
-
Import Paylocity Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Paylocity. In this article, you will use the OData format to import Paylocity into Microsoft Power Query.
-
Operational Reporting on SAP SuccessFactors LMS Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP SuccessFactors LMS.
-
Connect Sentry to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sentry using the CData Python MCP Server.
-
Integrate Amplitude with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Amplitude with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Amplitude.
-
Create Informatica Mappings From/To an ODBC Data Source for Couchbase
Create an ODBC connection to Couchbase in Informatica and browse and transfer Couchbase.
-
Natively Connect to Dynamics 365 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Dynamics 365. Leverage the native support for ODBC in PHP.
-
Connect ZohoSubscriptions Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ZohoSubscriptions using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to PolarTeamPro Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PolarTeamPro.
-
Build Trello-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Trello Data and create custom apps in Bubble.
-
Use JayDeBeApi to access Blackbaud FE NXT Data in Python
Use standard Python scripting and the development environment of your choice to access live Blackbaud FE NXT.
-
Microsoft OneDrive Reporting in OBIEE with the Microsoft OneDrive JDBC Driver
Deploy the Microsoft OneDrive JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Zoho Books-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Zoho Books and build web apps with connectivity to live Zoho Books.
-
Manage ZendeskSell Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ZendeskSell.
-
Build MVC Applications with Connectivity to HDFS Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access HDFS from an ASP.NET MVC application.
-
Getting Started with the CData Power BI Connector for Moosend
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Connect to WordPress Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to WordPress. Leverage the pyodbc module for ODBC in Python.
-
Connect to Apify Data in Aqua Data Studio
Access Apify from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Slack Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Slack replication to PostgreSQL.
-
Integrate Real-Time Access to GraphQL in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to GraphQL in real time.
-
Integrate Real-Time Access to Amazon S3 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon S3 in real time.
-
Integrating MySQL Data in Talend Cloud Data Management Platform
Connect MySQL Data with Talend Cloud Data Management Platform using the CData JDBC Driver for MySQL.
-
Feed Printful Data into FineReport
How to set Printful as a JDBC data source in FineReport.
-
Build AI Agents with Microsoft OneDrive Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Microsoft OneDrive through CData Connect AI.
-
Use Biml to Build SSIS Tasks to Replicate Hubstaff Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Hubstaff to SQL Server.
-
Automated Continuous Avaza Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Avaza replication to IBM DB2.
-
Edit and Search External Salesforce Pardot Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Salesforce Pardot to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Salesforce Pardot Data objects that you can access from apps and the dashboard.
-
Analyze Facebook Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Facebook from Power Pivot. You will use the Table Import Wizard to load Facebook. You can visually build the import query or use any SQL supported by the driver.
-
Access Live SurveyMonkey 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 SurveyMonkey through MCP integration.
-
Integrate Live Adobe Commerce Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Adobe Commerce from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Adobe Commerce.
-
Getting Started with the CData SSIS Components for Wistia
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Wistia.
-
Access Live HubSpot Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live HubSpot data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Real-Time Freshsales Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Freshsales in Power Apps.
-
Automated Continuous Egnyte Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Egnyte replication to Azure SQL Database.
-
Publish OData-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live OData.
-
Build Agents in Relevance AI with Access to Live HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on HCL Domino within intelligent agent workflows.
-
Easily Integrate ShipEngine Data in Lazarus Pascal IDE
Learn how to easily integrate live ShipEngine in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to import MailChimp Data into Apache Solr
Use the CData Software JDBC Driver for MailChimp in Data Import Handler and create an automated import of MailChimp to Apache Solr Enterprise Search platform.
-
Create Reports from Google Ad Manager Data in Looker Studio
Use CData Connect AI to gain access to live Google Ad Manager and create custom reports in Looker Studio.
-
Automated Continuous Xero Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Xero replication to Apache Kafka.
-
How to connect Amazon QuickSight to Microsoft Exchange Data
Create a connection to Microsoft Exchange in CData Connect AI and insert Microsoft Exchange into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated WordPress Data Replication to Teradata
Use CData Sync to Customize and automate WordPress replication to Teradata.
-
Connect to GitHub Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for GitHub to connect to GitHub and execute queries in PowerBuilder.
-
Publish Reports with Cassandra Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Cassandra.
-
Connect to SingleStore Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SingleStore to connect to SingleStore and execute queries in PowerBuilder.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Azure Data Catalog to Power BI dashboards. Simply drag and drop Azure Data Catalog into data visuals on the Power BI canvas.
-
Use JayDeBeApi to access Sybase Data in Python
Use standard Python scripting and the development environment of your choice to access live Sybase.
-
Working with ConvertAPI Data in LINQPad
Execute LINQ queries to ConvertAPI in LINQPad.
-
How to Connect DBeaver to ZohoExpense via a JDBC Driver
Manage ZohoExpense with visual tools in DBeaver like the query browser.
-
Automated Continuous GitLab Replication to Databricks
Use CData Sync for automated, continuous, customizable GitLab replication to Databricks.
-
Connect to Xero from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Xero Accounting, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to connect to SAP SuccessFactors Data in DBVisualizer
Integrate SAP SuccessFactors with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Cursor with Live Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Presto from within the editor.
-
Integrating LlamaIndex with Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Elasticsearch in real time.
-
Use Dash to Build to Web Apps on Datadog Data
Create Python applications that use pandas and Dash to build Datadog-connected web apps.
-
Visualize EnterpriseDB Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to EnterpriseDB.
-
No code, no problem: AI agents for your daily data workflow using CData CLI
Build a reusable morning briefing agent that connects to Asana, Google Drive, and Google Calendar using Claude Code and the CData CLI, with no application code required.
-
Build a PostgreSQL Interface for JotForm Data using the CData JDBC Driver
Use the Remoting features of the JotForm JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Opsgenie Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Opsgenie using standard SQL.
-
Access Productboard Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Productboard from HeidiSQL.
-
How to Connect the Power BI Service to Salesloft: Complete Guide
Connect to the CData Software Power BI Connector for Salesloft from PowerBI.com to provide real-time Salesloft across the organization.
-
Build SQL Server-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft SQL Server and build SQL Server-connected web apps with Axios.
-
Viewing Freshservice Data in RAD Studio Data Explorer
How to view Freshservice in RAD Studio Data Explorer using the CData ODBC Driver for Freshservice.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Bullhorn CRM within intelligent workflows.
-
How to Connect to Zendesk Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zendesk. Leverage the pyodbc module for ODBC in Python.
-
Connect to ClickTime Data in CloverDX (formerly CloverETL)
Transfer ClickTime using the visual workflow in the CloverDX data integration tool.
-
Connect to ShipStation Data from a Connection Pool in Jetty
The ShipStation JDBC Driver supports connection pooling: This article shows how to connect faster to ShipStation from Web apps in Jetty.
-
DataBind Controls to Moosend Data in Delphi
DataBind to Moosend in Delphi with standard data access components and controls.
-
Connect CSV to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect CSV with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Live Vault CRM Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Veeva Vault & Vault CRM for you.
-
How to Visualize Monday.com Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Monday.com in Python.
-
Trigger ActiveCampaign IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for ActiveCampaign with standard wizards in Logic Apps.
-
Publish Reports with Airtable Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Airtable.
-
Integrate with Freshsales Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Freshsales to a JSON file on disk.
-
How to integrate Metabase with Azure Table Data
Use CData Connect AI to connect to live Azure Table Storage and create an interactive dashboard in Metabase from Azure Table Storage.
-
Integrating OpenCode Terminal with Oracle Sales 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.
-
Build Visualizations of Telegram Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Telegram in Birst.
-
Publish SAP Business Warehouse-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP Business Warehouse.
-
Create SQL Analysis Services Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SQL Analysis Services data access from reports, embedded analytics, and more.
-
Use the CData API Server to Access PostgreSQL Data in Microsoft PowerPivot
Use the CData API Server to connect to live PostgreSQL in the Power Pivot business intelligence tool.
-
Create Gmail-Connected Applications in Appsmith
Connect to Gmail Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Gmail.
-
Build Charts with Blackbaud FE NXT Data in Clear Analytics
Create dynamic charts and perform analytics based on Blackbaud FE NXT in Clear Analytics.
-
Connect to Hubstaff Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Hubstaff to connect to Hubstaff and execute queries in PowerBuilder.
-
How to Work with ZeroBounce Data in ETL Validator JDBC
Connect to ZeroBounce from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to Coinbase Data in DBVisualizer
Integrate Coinbase with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Informatica Mappings From/To an ODBC Data Source for Act CRM
Create an ODBC connection to Act CRM in Informatica and browse and transfer Act CRM.
-
Import SQL Analysis Services Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SQL Analysis Services Data and provide access to live SQL Analysis Services for custom reports in the Power BI Service.
-
Build Salesforce Marketing-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Salesforce Marketing Data and create custom apps in Bubble.
-
How to Query Live Datadog Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Datadog data in natural language using Python.
-
Automate Paylocity Data Replication to Azure Data Lake
Use CData Sync to customize and automate Paylocity replication to Azure Data Lake.
-
Integrating Gumloop with Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoho Inventory within automated workflows.
-
Connect to ZohoExpense Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect HubDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live HubDB using the CData Python MCP Server.
-
Connecting Mastra with Klaviyo 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 Klaviyo, no replication required.
-
Create SSAS Tabular Models from ZendeskSell Data
How to build a SQL Server Analysis Service Tabular Model from ZendeskSell using CData drivers.
-
A PostgreSQL Interface for ADP Data (MySQL Remoting via JDBC)
Use the Remoting features of the ADP JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Live Anaplan Data in Visual Studio Code via Cline
Run CData MCP Server for Anaplan on Windows Subsytem for Linux (WSL) and connect to live Anaplan from the Cline extension in Visual Studio Code.
-
Connect to Google Sheets Data in JRuby
Create a simple JRuby app with access to live Google Sheets.