CData Software - Knowledge Base
Recent Articles
-
How to create Quickbase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Quickbase in MySQL .
-
Viewing Basecamp Data in RAD Studio Data Explorer
How to view Basecamp in RAD Studio Data Explorer using the CData ODBC Driver for Basecamp.
-
Replicate Multiple QuickBooks Online Accounts
Replicate multiple QuickBooks Online accounts to one or many databases.
-
Import Trello Data Using Azure Data Factory
Use CData Connect AI to connect to Trello Data from Azure Data Factory and import live Trello.
-
Trigger MarkLogic IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for MarkLogic with standard wizards in Logic Apps.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed BambooHR to Power BI dashboards. Simply drag and drop BambooHR into data visuals on the Power BI canvas.
-
Connect to OpenWeatherMap Data in CloverDX (formerly CloverETL)
Transfer OpenWeatherMap using the visual workflow in the CloverDX data integration tool.
-
How to Access Live Adobe Commerce Data in Visual Studio Code via Cline
Run CData MCP Server for Adobe Commerce on Windows Subsytem for Linux (WSL) and connect to live Adobe Commerce from the Cline extension in Visual Studio Code.
-
Access Raisers Edge NXT 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 Raisers Edge NXT.
-
Getting Started with the CData SSIS Components for Bitbucket
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bitbucket.
-
Automated Continuous Zuora Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zuora replication to AlloyDB.
-
Create MYOB AccountRight-Connected Business Apps in AppSheet
Connect to MYOB AccountRight Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MYOB AccountRight.
-
Connect to Dotmailer Data from a Connection Pool in JBoss
Integrate Dotmailer into Java servlets: Use the Management Console in JBoss to install the Dotmailer JDBC Driver.
-
Create Dashboards and Visualize Live Asana Data in Geckoboard
Use CData Connect AI to connect to live Asana and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build AI/ML Models with Live Quickbase Data using Dataiku
Connect Quickbase Data with Dataiku using the CData JDBC Driver for Quickbase.
-
Getting Started with the CData JDBC Driver for Wistia
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Wistia.
-
Connect to SAP HANA from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP HANA to connect to SAP HANA from Web applications running on WebLogic.
-
Visualize ZendeskSell 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 ZendeskSell into TIBCO Spotfire.
-
Build Semantic Layer Views for Customer.io Data in APOS Live Data Gateway
Use the CData Connector for Customer.io in APOS Live Data Gateway to build Semantic Layer Views for Customer.io.
-
HCL Domino Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to HCL Domino through CData Connect AI using different applications and tools.
-
Query JotForm Data in ColdFusion
Write standard ColdFusion data access code to connect to JotForm.
-
Query Freshdesk Data in DataGrip
Create a Data Source for Freshdesk in DataGrip and use SQL to query live Freshdesk.
-
Replicate Attio Data to Multiple Databases
Replicate Attio to disparate databases with a point-and-click configuration.
-
Build Semantic Layer Views for Zendesk Data in APOS Live Data Gateway
Use the CData Connector for Zendesk in APOS Live Data Gateway to build Semantic Layer Views for Zendesk.
-
Build MVC Applications with Connectivity to Autopilot Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Autopilot from an ASP.NET MVC application.
-
Connect to Procore Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Procore and work with Procore in your FileMaker applications.
-
Create Apps from Adobe Analytics Data in Qlik Sense Cloud
Use CData Connect AI to connect to Adobe Analytics Data and build apps from live Adobe Analytics in Qlik Sense Cloud.
-
Connect to SharePoint Excel Services Data in HULFT Integrate
Connect to SharePoint Excel Services as a JDBC data source in HULFT Integrate
-
Integrate Open WebUI with Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live HubSpot from within the chat interface.
-
Build Semantic Layer Views for SAP Ariba Source Data in APOS Live Data Gateway
Use the CData Connector for SAP Ariba Source in APOS Live Data Gateway to build Semantic Layer Views for SAP Ariba Source.
-
Access Live SAS xpt Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAS XPORT into the statistical analysis tools available in SAS JMP. This article shows how to use SAS XPORT in the Graph Builder and Query Builder.
-
Automated Continuous Microsoft OneLake Replication to Oracle
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Oracle.
-
Explore Geographical Relationships in Salesforce Data with Power Map
Create data visualizations with Salesforce & Force.com in Power Map.
-
Connect to Apollo Data in NetBeans
Connect to Apollo in NetBeans with the data source configuration wizard.
-
Visualize Jira Data in TIBCO Spotfire through OData
Integrate Atlassian Jira into dashboards in TIBCO Spotfire.
-
Automated Continuous XML Replication to MySQL
Use CData Sync for automated, continuous, customizable XML replication to MySQL.
-
Connect Azure Analysis Services Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Azure Analysis Services using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect and process Pinecone from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pinecone.
-
Extract, Transform, and Load Basecamp Data in Informatica PowerCenter
Create a simple Workflow for Basecamp in Informatica PowerCenter.
-
Migrating data from AdRoll to Databricks using CData SSIS Components.
Easily push AdRoll to Databricks using the CData SSIS Tasks for AdRoll and Databricks.
-
Consume ServiceNow OData Feeds in SAP Lumira
Use the API Server to create data visualizations on ServiceNow feeds that reflect any changes in SAP Lumira.
-
Build Dashboards with Spark Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apache Spark SQL in Dundas BI.
-
How to Easily Query CouchDB Data in OpenOffice Base
Connect to CouchDB data in OpenOffice Base using the CData ODBC Driver for CouchDB and generate reports with live data insights.
-
Automate HelloSign Data Replication to Azure Synapse
Use CData Sync to customize and automate HelloSign replication to Azure Synapse.
-
Build Grafana-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Grafana Data in GitHub Copilot to assist with building Grafana-powered applications.
-
Automated Continuous Teamgate Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Teamgate replication to Google Cloud SQL.
-
Build Agents in Relevance AI with Access to Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Concur within intelligent agent workflows.
-
Visualize Live Greenplum Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pivotal GreenPlum using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Google Ads-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Ads Data from Zoho Analytics and import live Google Ads.
-
Integrating GitHub Copilot CLI with Unbounce 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.
-
Access Live Apollo Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Apollo from your Excel spreadsheets.
-
Create SAP SuccessFactors LMS Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP SuccessFactors LMS from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Live Google Ad Manager Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Ad Manager from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Ad Manager.
-
Build a Simple VCL Application for SAP Concur Data
How to build a simple VCL Application to view SAP Concur in RAD Studio using the CData ODBC Driver for SAP Concur.
-
Create Avaza Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Avaza data access from reports, embedded analytics, and more.
-
Connect to SAP Business One Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Business One.
-
Automated Continuous Google Sheets Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Sheets replication to Amazon Redshift.
-
Connecting Mastra with SendGrid 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 SendGrid, no replication required.
-
Working with HBase Data in LINQPad
Execute LINQ queries to Apache HBase in LINQPad.
-
Build Brex-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Brex Data in Gemini Code Assist to assist with building Brex-powered applications.
-
Migrating data from Microsoft Teams to Databricks using CData SSIS Components.
Easily push Microsoft Teams to Databricks using the CData SSIS Tasks for Microsoft Teams and Databricks.
-
Getting Started with the CData Tableau Connector for CloudConvert
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Reckon-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Reckon to explore live Reckon Data in Cursor to assist with building Reckon-powered applications.
-
Connect to Kintone Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Kintone and the Script function in FileMaker Pro to connect to Kintone and work with Kintone in your FileMaker application.
-
Use the CData Software ODBC Driver for Autopilot in SAS for Real-Time Reporting and Analytics
Connect to real-time Autopilot in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Autopilot.
-
Automated Continuous ZohoDesk Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZohoDesk replication to AlloyDB.
-
Build Pipelines with Live Email Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Email from Google Cloud Data Fusion, enabling the integration of live Email into the building and management of effective data pipelines.
-
Replicate Multiple Avalara AvaTax Accounts via the CData Sync CLI
Replicate multiple Avalara AvaTax accounts to one or many databases.
-
Integrate Live IBM Cloud Object Storage Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live IBM Cloud Object Storage to Blue Prism using the CData ODBC Driver for IBM Cloud Object Storage to create automated workflows for repetitive business tasks.
-
Automate Azure Table Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure Table Storage from PowerShell? This article demonstrates how to utilize the Azure Table Cmdlets for tasks like connecting to Azure Table Storage, automating operations, downloading data, and more.
-
Build Confluence-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Confluence to explore live Confluence Data in Claude Code to assist with building Confluence-powered applications.
-
Connect to Google Cloud Storage Data in Aqua Data Studio
Access Google Cloud Storage from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query Gong Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Gong from Node.js.
-
Connect to Azure DevOps Data from a Connection Pool in Jetty
The Azure DevOps JDBC Driver supports connection pooling: This article shows how to connect faster to Azure DevOps from Web apps in Jetty.
-
How to Connect DBeaver to Azure Data Catalog via a JDBC Driver
Manage Azure Data Catalog with visual tools in DBeaver like the query browser.
-
Connect to Real-Time Grafana Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Grafana in Power Apps.
-
Create Dashboards and Visualize Live Facebook Ads Data in Geckoboard
Use CData Connect AI to connect to live Facebook Ads and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Tanda
Provide connectivity to Tanda through an SAP BusinessObjects universe.
-
Build Dashboards with Aircall Data in DBxtra
Create dynamic dashboards and perform analytics based on Aircall in DBxtra.
-
Access Acumatica Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Acumatica ERP from your Oracle system.
-
How to create Teamwork federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Teamwork in MySQL .
-
Create Drip Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Drip from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Design Sage Cloud Accounting Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Sage Cloud Accounting from mobile and tablet Power Apps.
-
View Reports on Real-Time Tanda Data in Power BI Report Server
Use the CData ODBC Driver for Tanda to visualize Tanda in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Reports from Odoo Data in Looker Studio
Use CData Connect AI to gain access to live Odoo ERP and create custom reports in Looker Studio.
-
Visualize JobNimbus Data in TIBCO Spotfire through OData
Integrate JobNimbus into dashboards in TIBCO Spotfire.
-
Build AI Agents with JSON 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 JSON through CData Connect AI.
-
Feed Stripe Data into FineReport
How to set Stripe as a JDBC data source in FineReport.
-
Connect to ActiveCampaign Data from PowerBuilder via ADO.NET
This article demonstrates how to access ActiveCampaign from Appeon PowerBuilder using the CData ADO.NET Provider for ActiveCampaign.
-
Build a Singer.io Tap for PabblySubscriptions With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PabblySubscriptions data using
-
How to connect to Pinecone Data with Squirrel SQL client
Connect to Pinecone and execute queries in the Squirrel SQL Client.
-
How to Query Live Azure Table Data in Perplexity MacOS Desktop
Connect to and query live Azure Table Data in Perplexity Desktop using CData MCP Server.
-
Access Live Google Ads Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Ads from your Google Sheets.
-
Analyze Humanity Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Humanity and visualize live Humanity in Infragistics Reveal.
-
How to Create Power BI Visual Reports with Real-Time BambooHR Data
Use CData Power BI Connectors to visualize BambooHR in Power BI.
-
Use the CData Software JDBC Driver for Zoho Inventory in MicroStrategy
Connect to Zoho Inventory in MicroStrategy Developer using the CData Software JDBC Driver for Zoho Inventory.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed ZohoInvoice to Power BI dashboards. Simply drag and drop ZohoInvoice into data visuals on the Power BI canvas.
-
Connect Instantly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Instantly with IBM WebSphere for seamless data integration and connectivity.
-
Query Dropbox Data as a SQL Server Database in Node.js
Execute SQL Server queries against Dropbox from Node.js.
-
Connect to PayPal Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PayPal using standard SQL.