CData Software - Knowledge Base
Recent Articles
-
Publish Billsby-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Billsby.
-
Build Vimeo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Vimeo and build web apps with connectivity to live Vimeo.
-
Visualize Live EnterpriseDB Data in the Power BI Service
Use CData Connect AI to connect to live EnterpriseDB and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for Jodoo in MicroStrategy Web
Connect to Jodoo in MicroStrategy Web using the CData Software ODBC Driver for Jodoo.
-
Edit and Search External Blackbaud FE NXT Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Blackbaud FE NXT to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Blackbaud FE NXT Data objects that you can access from apps and the dashboard.
-
How to connect and process Shopify from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Shopify.
-
Publish Crystal Reports on Power BI XMLA Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Power BI XMLA.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SFTP to Power BI dashboards. Simply drag and drop SFTP into data visuals on the Power BI canvas.
-
Extract, Transform, and Load MailerSend Data in Informatica PowerCenter
Create a simple Workflow for MailerSend in Informatica PowerCenter.
-
Working with Zoho Creator Data in LINQPad
Execute LINQ queries to Zoho Creator in LINQPad.
-
Access Superchat Data from MySQL in Amazon QuickSight
Connect to Superchat and build visualizations of Superchat using a MySQL Connection in Amazon QuickSight.
-
How to connect to JSON Services with Squirrel SQL client
Connect to JSON and execute queries in the Squirrel SQL Client.
-
Access OpenWeatherMap 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 OpenWeatherMap.
-
Connect to ClickUp Data in Aqua Data Studio
Access ClickUp from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Consume Box OData Feeds in PowerBuilder
This article demonstrates how to consume Box as OData feeds from PowerBuilder using the API Server.
-
Analyze DB2 Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of IBM DB2 and visualize live IBM DB2 in Infragistics Reveal.
-
Process & Analyze Cohere Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Cohere Data.
-
Access Live SQL Server 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 Microsoft SQL Server through MCP integration.
-
Build a Simple VCL Application for Acumatica Data
How to build a simple VCL Application to view Acumatica ERP in RAD Studio using the CData ODBC Driver for Acumatica.
-
Create Vault CRM-Connected Nintex Workflows
Use CData Connect AI to connect to Vault CRM Data from Nintex Workflow Cloud and build custom workflows using live Veeva Vault & Vault CRM.
-
Seamlessly Bring Basecamp Data into Retool Using CData Connect AI
Integrate Basecamp data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use the CData ODBC Driver for SendPulse from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SendPulse to connect to SendPulse from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SendPulse in Excel.
-
Automated Continuous Unbounce Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Unbounce replication to Amazon Redshift.
-
Access Live Odoo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Odoo ERP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software ODBC Driver for LeadDesk in MicroStrategy Web
Connect to LeadDesk in MicroStrategy Web using the CData Software ODBC Driver for LeadDesk.
-
Integrating Claude Code with GitHub Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on GitHub within assisted coding and automated development workflows.
-
Automate GetResponse Integration Tasks from PowerShell
Are you in search of a quick and easy way to access GetResponse from PowerShell? This article demonstrates how to utilize the GetResponse Cmdlets for tasks like connecting to GetResponse, automating operations, downloading data, and more.
-
Visualize Dynamics NAV Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Dynamics NAV.
-
Build MVC Applications with Connectivity to SAP Business One Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Business One from an ASP.NET MVC application.
-
Build OneNote-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft OneNote.
-
Prepare, Blend, and Analyze Oracle Financials Cloud Data in Alteryx Designer (Connect AI)
Build workflows to access live Oracle Financials Cloud for self-service data analytics.
-
Automated Continuous IBM Cloud Object Storage Replication to MongoDB
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to MongoDB.
-
Create Okta-Connected Business Apps in AppSheet
Connect to Okta Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Okta.
-
Use the CData Software JDBC Driver for CloudConvert in MicroStrategy
Connect to CloudConvert in MicroStrategy Developer using the CData Software JDBC Driver for CloudConvert.
-
Connect to FreeAgent Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for FreeAgent to connect to FreeAgent and execute queries in PowerBuilder.
-
Integrate Live ServiceNow Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to ServiceNow from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live ServiceNow.
-
Excel Spreadsheet Automation on MongoDB Data with the QUERY Formula
Pull data from MongoDB, automate spreadsheets, and more with the QUERY formula.
-
How to connect Amazon QuickSight to SAP Netweaver Gateway Data
Create a connection to SAP Netweaver Gateway in CData Connect AI and insert SAP Netweaver Gateway into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Tableau Connector for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Dynamics CRM.
-
Process & Analyze Oracle Eloqua Reporting Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle Eloqua Reporting Data.
-
Build a Simple VCL Application for SingleStore Data
How to build a simple VCL Application to view SingleStore in RAD Studio using the CData ODBC Driver for SingleStore.
-
Automated Continuous BambooHR Replication to SQLite
Use CData Sync for automated, continuous, customizable BambooHR replication to SQLite.
-
Create Power BI Reports on Real-Time Smartsheet Data
Use the CData ODBC Driver for Smartsheet to visualize Smartsheet in Power BI Desktop.
-
Integrate HBase Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache HBase from Informatica Cloud.
-
Load Parallel Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Parallel to a database.
-
Create Microsoft Entra ID-Connected Dashboards in Grafana
Connect to Microsoft Entra ID Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft Entra ID.
-
Automated Dynamics 365 Business Central Data Replication to Teradata
Use CData Sync to Customize and automate Dynamics 365 Business Central replication to Teradata.
-
How to Access Live Aha! Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Aha! enables you to integrate Aha! into workflows built using Microsoft Power Automate Desktop.
-
Connect to ADP Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ADP using standard SQL.
-
Connect to ConvertKit Data in RapidMiner
Integrate ConvertKit with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Flowlu Data from a Connection Pool in Jetty
The Flowlu JDBC Driver supports connection pooling: This article shows how to connect faster to Flowlu from Web apps in Jetty.
-
Use Azure AI Foundry to Talk to Your ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your ActiveCampaign for you.
-
Integrating Cursor CLI with RSS Feeds 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.
-
Create Optimizely Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Optimizely data access from reports, embedded analytics, and more.
-
Create Data Visualizations in Cognos BI with Cloudflare Data
Access Cloudflare as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Tally Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Tally ERP in the Denodo Virtual DataPort Administrator.
-
Edit and Search External SAP Fieldglass Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Fieldglass to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Fieldglass Data objects that you can access from apps and the dashboard.
-
Use the CData Software JDBC Driver for MongoDB in MicroStrategy Desktop
Connect to MongoDB in MicroStrategy Desktop using the CData Software JDBC Driver for MongoDB.
-
Build Dashboards with Unbounce Data in Dundas BI
Create dynamic dashboards and perform analytics based on Unbounce in Dundas BI.
-
Use the CData Software ODBC Driver for Klipfolio in MicroStrategy Web
Connect to Klipfolio in MicroStrategy Web using the CData Software ODBC Driver for Klipfolio.
-
Import EnterpriseDB Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to EnterpriseDB Data and provide access to live EnterpriseDB for custom reports in the Power BI Service.
-
Create Power BI Reports on Real-Time Perplexity Data
Use the CData ODBC Driver for Perplexity to visualize Perplexity in Power BI Desktop.
-
How to integrate Sybase IQ with Apache Airflow
Access and process Sybase IQ in Apache Airflow using the CData JDBC Driver.
-
Access Live Office 365 Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Office 365 data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Connect to Live Elasticsearch 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 Elasticsearch for you.
-
Automated Continuous Authorize.Net Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Google BigQuery.
-
Integrate LibreChat with Live Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Zoho CRM from within the chat interface.
-
Prepare, Blend, and Analyze WordPress Data in Alteryx Designer (ODBC)
Build workflows to access live WordPress for self-service data analytics.
-
Working with ZendeskSell Data in LINQPad
Execute LINQ queries to ZendeskSell in LINQPad.
-
Connect to Miro Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Miro and the SQL Gateway to access Miro from Google Apps Script.
-
Visualize Live Sage 200 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sage 200 into custom reports in Power BI.
-
Access Timely 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 Timely.
-
Connect to Kintone Data in Jaspersoft Studio
Execute SQL to remote Kintone in Jaspersoft Studio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MailerSend
Provide connectivity to MailerSend through an SAP BusinessObjects universe.
-
Replicate Drift Data to Multiple Databases
Replicate Drift to disparate databases with a point-and-click configuration.
-
How to Visualize ClickUp Data in Python with pandas
Use pandas and other modules to analyze and visualize live ClickUp in Python.
-
Build AI/ML Models with Live Asana Data using Dataiku
Connect Asana Data with Dataiku using the CData JDBC Driver for Asana.
-
Connect to Paylocity Data from HeidiSQL
Use CData Connect AI to connect to and query live Paylocity from HeidiSQL.
-
Use the CData Software JDBC Driver for Demio in MicroStrategy
Connect to Demio in MicroStrategy Developer using the CData Software JDBC Driver for Demio.
-
Automated Continuous SAP Netweaver Gateway Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to SQL Server.
-
Automated Continuous Printful Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Printful replication to PostgreSQL.
-
How to connect to Shortcut Data from Spring Boot
Connect to Shortcut in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Oracle HCM Cloud Data into Power Automate Desktop using CData Connect
CData Connect for Oracle HCM Cloud Data enables you to integrate Oracle HCM Cloud into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Flowlu Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Flowlu replication to Google Cloud SQL.
-
Analyze Google Analytics Data in Looker
Use CData Connect AI to connect to Google Analytics Data from Looker and build custom apps using live Google Analytics.
-
Connect to Superchat Data from a Connection Pool in Jetty
The Superchat JDBC Driver supports connection pooling: This article shows how to connect faster to Superchat from Web apps in Jetty.
-
Use the CData Software ODBC Driver for Scrapfly in MicroStrategy Web
Connect to Scrapfly in MicroStrategy Web using the CData Software ODBC Driver for Scrapfly.
-
Connect to Mailgun Data in RazorSQL
Connect to Mailgun from wizards and query Mailgun from the GUI in the RazorSQL database management tool.
-
Connect to Act CRM Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Act CRM Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Xero from a Connection Pool in WebLogic
Use the CData JDBC Driver for Xero to connect to Xero Accounting from Web applications running on WebLogic.
-
Connect to Highrise Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Connect to & Open Amazon Athena Data in Microsoft Excel
This article uses the CData ODBC driver for Amazon Athena to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Natively Connect to Sage 200 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sage 200. Leverage the native support for ODBC in PHP.
-
Create Dynamic GetResponse Grids Using the Infragistics XamDataGrid
Learn how you can connect GetResponse to Infragistics XamDataGrid to build dynamic grids.
-
Import Real-Time Postmark Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Postmark in ColdFusion.
-
Connect to CockroachDB Data in RazorSQL
Connect to CockroachDB from wizards and query CockroachDB from the GUI in the RazorSQL database management tool.
-
Query Live Twilio 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 Twilio directly from the development environment.
-
Getting Started with the CData ADO.NET Provider for AlloyDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for AlloyDB.
-
Connect to Facebook Ads Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Facebook Ads in the Denodo Virtual DataPort Administrator.
-
Replicate DocuSign Data in Heroku for Use in Salesforce Connect
Replicate DocuSign to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.