CData Software - Knowledge Base
Recent Articles
-
Import and Visualize Strava Data in Power View
Create data visualizations based on Strava in Excel.
-
Build Apps with Live Chargebee Data Using the Low-Code Development Platform of Mendix
Connect Chargebee with Mendix to build apps using the CData API Driver for JDBC.
-
How to Easily Query QuickBooks Data in OpenOffice Base
Connect to QuickBooks data in OpenOffice Base using the CData ODBC Driver for QuickBooks and generate reports with live data insights.
-
Build a Simple VCL Application for Aircall Data
How to build a simple VCL Application to view Aircall in RAD Studio using the CData ODBC Driver for Aircall.
-
Connect to Printful Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Printful.
-
Build Charts with FTP Data in Clear Analytics
Create dynamic charts and perform analytics based on FTP Servers in Clear Analytics.
-
How to Create Power BI Visual Reports with Real-Time Helpscout Data
Use CData Power BI Connectors to visualize Helpscout in Power BI.
-
Use Grok to Talk to Your Excel Online 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 Microsoft Excel Online for you.
-
Create SSAS Tabular Models from Hacker News Data
How to build a SQL Server Analysis Service Tabular Model from Hacker News using CData drivers.
-
Analyze Trello Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Trello and visualize live Trello in Infragistics Reveal.
-
Query SAP Ariba Procurement Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Ariba Procurement.
-
Import Real-Time Kafka Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Apache Kafka in ColdFusion.
-
Automated Continuous BigCommerce Replication to Databricks
Use CData Sync for automated, continuous, customizable BigCommerce replication to Databricks.
-
Query Oracle SCM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle SCM from Node.js.
-
Connect to Freshteam Data in RazorSQL
Connect to Freshteam from wizards and query Freshteam from the GUI in the RazorSQL database management tool.
-
Use the CData Software ODBC Driver for Bullhorn CRM in MicroStrategy
Connect to Bullhorn CRM in MicroStrategy Developer using the CData Software ODBC Driver for Bullhorn CRM.
-
Connect to OnePageCrm Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for OnePageCrm and the SQL Gateway to access OnePageCrm from Google Apps Script.
-
How to connect to LeadDesk Data from IntelliJ
Integrate connectivity to LeadDesk with wizards in IntelliJ.
-
Replicate Asana Data in Heroku for Use in Salesforce Connect
Replicate Asana to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Blackbaud FE NXT Data from PowerBuilder via ADO.NET
This article demonstrates how to access Blackbaud FE NXT from Appeon PowerBuilder using the CData ADO.NET Provider for Blackbaud FE NXT.
-
How to Connect to Live Sybase IQ 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 Sybase IQ for you.
-
Connect to Qualaroo Data in Jaspersoft Studio
Execute SQL to remote Qualaroo in Jaspersoft Studio.
-
How to Connect to Mailgun Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mailgun. Leverage the pyodbc module for ODBC in Python.
-
Connect to Toggl Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Toggl and work with Toggl in your FileMaker applications.
-
How to connect to SAP Business Warehouse Data from Spring Boot
Connect to SAP Business Warehouse in a Spring Boot Application using the CData JDBC Driver for SAP Business Warehouse
-
Prepare, Blend, and Analyze Amplitude Data in Alteryx Designer (ODBC)
Build workflows to access live Amplitude for self-service data analytics.
-
Build Apps with Live SendPulse Data Using the Low-Code Development Platform of Mendix
Connect SendPulse with Mendix to build apps using the CData API Driver for JDBC.
-
How to use SQLAlchemy ORM to access Hubstaff Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Hubstaff.
-
How to Access Live Google Spanner Data in Visual Studio Code via Cline
Run CData MCP Server for Google Spanner on Windows Subsytem for Linux (WSL) and connect to live Google Spanner from the Cline extension in Visual Studio Code.
-
Visualize Live Neo4J Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Neo4J using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Demio Data from PowerShell
Write a quick PowerShell script to query Demio. Use connectivity to the live data to replicate Demio to SQL Server.
-
Getting Started with the CData Tableau Connector for SAP Ariba Procurement
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Ariba Procurement.
-
Use the CData Software JDBC Driver for Printful in MicroStrategy
Connect to Printful in MicroStrategy Developer using the CData Software JDBC Driver for Printful.
-
Connecting Moonlit Workflow with EnterpriseDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your EnterpriseDB in real time.
-
Connect to Power BI XMLA Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Power BI XMLA to connect to Power BI XMLA and execute queries in PowerBuilder.
-
View Reports on Real-Time Trello Data in Power BI Report Server
Use the CData ODBC Driver for Trello to visualize Trello in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Dataiku with Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Oracle Eloqua.
-
Okta Reporting in OBIEE with the Okta JDBC Driver
Deploy the Okta JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Zoho Creator Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zoho Creator from Node.js.
-
How to Import Data from Sugar CRM into Google Sheets
Import Sugar CRM into a Google spreadsheet that is automatically refreshed.
-
Choosing the Best Method to Connect LinkedIn to SQL Server: 5 Options Explained
Discover multiple ways to connect and use LinkedIn from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Google Sheets with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Sheets with External Services.
-
How to Query Delighted Data in MySQL Workbench
Execute MySQL queries against live Delighted from MySQL Workbench.
-
Connect to Lakebase Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Lakebase Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to SQL Server Data in HULFT Integrate
Connect to SQL Server as a JDBC data source in HULFT Integrate
-
Connect to SQL Analysis Services Data in Aqua Data Studio
Access SQL Analysis Services from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Viewing OpenWeatherMap Data in RAD Studio Data Explorer
How to view OpenWeatherMap in RAD Studio Data Explorer using the CData ODBC Driver for OpenWeatherMap.
-
How to Connect to Live MongoDB Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live MongoDB securely in real time.
-
Connect to Auth0 Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Auth0 in the Denodo Virtual DataPort Administrator.
-
Access Live SparkPost Data in Coginiti Pro
Connect to and query live SparkPost from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for Exact Online in MicroStrategy Web
Connect to Exact Online in MicroStrategy Web using the CData Software ODBC Driver for Exact Online.
-
Publish Crystal Reports on Azure Data Lake Storage Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Azure Data Lake Storage.
-
Connect to Email Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Email and the Script function in FileMaker Pro to connect to Email and work with Email in your FileMaker application.
-
Choosing the Best Method to Connect Perigon to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Perigon from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Databricks Agent Bricks to Talk to Your SAP Hybris C4C Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Hybris C4C for you.
-
Connect to Nethunt Data in JRuby
Create a simple JRuby app with access to live Nethunt.
-
Integrate with Live Authorize.Net Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Authorize.Net from the MuleSoft Anypoint Platform to integrate live Authorize.Net into custom reports and dashboards.
-
How to integrate ChartMogul with Apache Airflow
Access and process ChartMogul in Apache Airflow using the CData JDBC Driver.
-
Integrating LangChain with Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Avalara AvaTax within automated workflows.
-
Integrate Stack Exchange with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Stack Exchange with External Services.
-
Feed Xero Data into FineReport
How to set Xero Accounting as a JDBC data source in FineReport.
-
Automated Continuous SAP Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP replication to Apache Kafka.
-
How to Seamlessly Import Mouseflow Data into IBM SPSS Modeler
Integrate Mouseflow data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous SAP Hybris C4C Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Amazon Redshift.
-
Use Azure AI Foundry to Talk to Your Google Calendar 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 Google Calendar for you.
-
Bridge LightSpeedRetail Connectivity with Apache NiFi
Access and process LightSpeedRetail in Apache NiFi using the CData JDBC Driver.
-
How to integrate Metabase with Airtable Data
Use CData Connect AI to connect to live Airtable and create an interactive dashboard in Metabase from Airtable.
-
Automated ZohoInvoice Data Replication to Teradata
Use CData Sync to Customize and automate ZohoInvoice replication to Teradata.
-
Work with Live CSV Data in Power Query
Use CData Connect AI to connect to CSV/TSV Files and work with live CSV/TSV Files in Microsoft Power Query.
-
Build an OLAP Cube in SSAS from Azure DevOps Data
Establish a connection to Azure DevOps data from SQL Server Analysis Services, and use the Azure DevOps Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect to Helpscout Data in DBVisualizer
Integrate Helpscout with visual data analysis tools and data connection wizards in DBVisualizer
-
DataBind Eventbrite Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Eventbrite to a chart.
-
Query Live Microsoft OneDrive 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 Microsoft OneDrive directly from the development environment.
-
Access Live CouchDB Data in AWS Lambda
Connect to live Apache CouchDB in AWS Lambda using the CData JDBC Driver.
-
Visualize Live Delighted Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Delighted using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate LibreChat with Live IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live IBM Cloud Object Storage from within the chat interface.
-
Connect to Real-Time Salesloft Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Salesloft and Dataflow to import and use Salesloft in Power Apps.
-
Build Semantic Layer Views for Drip Data in APOS Live Data Gateway
Use the CData Connector for Drip in APOS Live Data Gateway to build Semantic Layer Views for Drip.
-
A PostgreSQL Interface for Sage Intacct Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sage Intacct JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create MailChimp-Connected Nintex Workflows
Use CData Connect AI to connect to MailChimp Data from Nintex Workflow Cloud and build custom workflows using live MailChimp.
-
Create Dynamic HubSpot Grids Using the Infragistics XamDataGrid
Learn how you can connect HubSpot to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData ODBC Driver for Sybase IQ
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sybase IQ.
-
Access Live Google Search Results 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 Google Search through MCP integration.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Sage Business Cloud Accounting to Power BI dashboards. Simply drag and drop Sage Business Cloud Accounting into data visuals on the Power BI canvas.
-
Feed Workable Data into FineReport
How to set Workable as a JDBC data source in FineReport.
-
Integrate Reckon Data in Pentaho Data Integration
Build ETL pipelines based on Reckon in the Pentaho Data Integration tool.
-
Build AI/ML Models with Live Elorus Data using Dataiku
Connect Elorus Data with Dataiku using the CData API Driver for JDBC.
-
Stream Avalara AvaTax Data into Apache Kafka Topics
Access and stream Avalara AvaTax in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Opsgenie-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Opsgenie and build web apps with connectivity to live Opsgenie.
-
Connect to SQL Server Data in Claris FileMaker Pro
Use the CData ODBC Driver for SQL Server in FileMaker Pro to connect to SQL Server and work with Microsoft SQL Server in your FileMaker applications.
-
How to Connect DBeaver to JobNimbus via a JDBC Driver
Manage JobNimbus with visual tools in DBeaver like the query browser.
-
Trigger Gmail IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Gmail with standard wizards in Logic Apps.
-
Connect to Airtable Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Airtable.
-
Design BIRT Reports on ZendeskSell Data
Provide current ZendeskSell to your embedded analytics.
-
How to Connect to HCL Domino Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to HCL Domino. Leverage the pyodbc module for ODBC in Python.
-
Create Datasets from Google Search in Domo Workbench and Build Visualizations of Google Search Results in Domo
Use the CData Software ODBC Driver for Google Search to create datasets from Google Search in Domo Workbench and then build visualizations in the Domo service.
-
Build SAS Data Sets Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAS Data Sets and build visualizations in Tableau.
-
Import Real-Time Omnisend Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Omnisend in ColdFusion.
-
Connect and Visualize Live Microsoft Planner Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Planner into the Databricks platform and create visualization dashboards with real-time Microsoft Planner.
-
Query GraphQL Data as a MySQL Database in Node.js
Execute MySQL queries against GraphQL from Node.js.