CData Software - Knowledge Base
Recent Articles
-
Connect to Azure DevOps Data in CloverDX (formerly CloverETL)
Transfer Azure DevOps using the visual workflow in the CloverDX data integration tool.
-
Connect Insightly Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Insightly using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Bind Live Adobe Commerce Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Adobe Commerce data
-
Getting Started with the CData ODBC Driver for SAS xpt
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAS xpt.
-
Build Microsoft Ads-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Microsoft Ads Data and create custom apps in Bubble.
-
Build a PostgreSQL Interface for Snowflake Data using the CData JDBC Driver
Use the Remoting features of the Snowflake JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build a Simple VCL Application for Beeminder Data
How to build a simple VCL Application to view Beeminder in RAD Studio using the CData ODBC Driver for Beeminder.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SAP HANA to Power BI dashboards. Simply drag and drop SAP HANA into data visuals on the Power BI canvas.
-
Connect to Google Contacts Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Contacts Data and connect to Google Contacts in Akorbi Digital RunMyProcess.
-
Prepare, Blend, and Analyze Stripe Data in Alteryx Designer (Connect AI)
Build workflows to access live Stripe for self-service data analytics.
-
Create Informatica Mappings From/To a JDBC Data Source for Active Directory
Create Active Directory data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Informatica Mappings From/To a JDBC Data Source for MongoDB
Create MongoDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Stack Exchange Data in DataGrip
Create a Data Source for Stack Exchange in DataGrip and use SQL to query live Stack Exchange.
-
Automated Continuous Spark Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Spark replication to Amazon Redshift.
-
Access Templated 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 Templated.
-
Access Live ZohoDesk Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ZohoDesk into the statistical analysis tools available in SAS JMP. This article shows how to use ZohoDesk in the Graph Builder and Query Builder.
-
Getting Started with the CData Connect AI Python SDK for MarkLogic
Install the CData Connect AI Python SDK to read and write live MarkLogic with standard DB-API 2.0 Python code.
-
Create Informatica Mappings From/To an ODBC Data Source for Humanity
Create an ODBC connection to Humanity in Informatica and browse and transfer Humanity.
-
How to Create Power BI Visual Reports with Real-Time Keap Data
Use CData Power BI Connectors to visualize Keap in Power BI.
-
View Reports on Real-Time Invoiced Data in Power BI Report Server
Use the CData ODBC Driver for Invoiced to visualize Invoiced in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData JDBC Driver for Codat
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Codat.
-
Connecting Agentforce with SAP HANA 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 SAP HANA for you.
-
Integrating OpenCode Terminal with SAS xpt 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.
-
Connect to ConstantContact Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ConstantContact in the Denodo Virtual DataPort Administrator.
-
Explore Geographical Relationships in Adobe Experience Manager Data with Power Map
Create data visualizations with Adobe Experience Manager in Power Map.
-
Build Tally Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Tally ERP and build visualizations in Tableau.
-
Create Data Visualizations in Cognos BI with Helpscout Data
Access Helpscout as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize Mixpanel Data in Tableau
The CData ODBC driver for Mixpanel enables you integrate Mixpanel into Tableau dashboards.
-
Use the CData Software ODBC Driver for LeadDesk in MicroStrategy
Connect to LeadDesk in MicroStrategy Developer using the CData Software ODBC Driver for LeadDesk.
-
How to Connect Flowise AI Agents to Live Azure Analysis Services Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Azure Analysis Services without replication.
-
DataBind Controls to Deel Data in C++Builder
DataBind to Deel in C++Builder with standard components and controls.
-
Integrate Open WebUI with Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Adobe Commerce from within the chat interface.
-
Integrating LangGraph with Avro Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Apache Avro within automated workflows.
-
How to connect to Parallel Data in DBVisualizer
Integrate Parallel with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live SAP Ariba Source Data in Coginiti Pro
Connect to and query live SAP Ariba Source from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData ODBC Driver for DB2 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for DB2 to connect to IBM DB2 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring IBM DB2 in Excel.
-
Connect to LionDesk Data in JRuby
Create a simple JRuby app with access to live LionDesk.
-
Excel Spreadsheet Automation on Cohere Data with the QUERY Formula
Pull data from Cohere, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData JDBC Driver for Reckon
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Reckon.
-
Automated Continuous ActiveCampaign Replication to Vertica
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Vertica.
-
Build ZohoExpense-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZohoExpense.
-
Connecting Pipedream with Power BI XMLA 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 Power BI XMLA data in real time.
-
Build ServiceDesk Plus-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ServiceDesk Plus and build web apps with connectivity to live ServiceDesk Plus.
-
Edit and Search Sage 300 External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Sage 300 to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Sage 300 objects that you can access from apps and the dashboard.
-
Rapidly Develop Foursquare-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Foursquare.
-
Build IBM Informix-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for IBM Informix to explore live IBM Informix Data in GitHub Copilot to assist with building IBM Informix-powered applications.
-
Build SAP BusinessObjects BI-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP BusinessObjects BI.
-
How to connect to Auth0 Data from IntelliJ
Integrate connectivity to Auth0 with wizards in IntelliJ.
-
Query Stripe Data as a SQL Server Database in Node.js
Execute SQL Server queries against Stripe from Node.js.
-
Enable the GitHub JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with GitHub.
-
How to Query Yelp Data in MySQL Workbench
Execute MySQL queries against live Yelp from MySQL Workbench.
-
Access Confluence Data from MySQL in PHP
Connect to Confluence through the standard MySQL libraries in PHP.
-
DataBind Tanda Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Tanda to a chart.
-
Integrate Live YouTube Analytics Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to YouTube Analytics from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live YouTube Analytics.
-
Back Up PolarTeamPro 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 PolarTeamPro data.
-
How to Connect to Live Zoho Projects 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 Zoho Projects for you.
-
Create Reports from Azure Synapse Data in Looker Studio
Use CData Connect AI to gain access to live Azure Synapse and create custom reports in Looker Studio.
-
How to Connect to Live GitHub Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your GitHub through natural language.
-
How to Access Live FHIR Data in Power Automate Desktop via ODBC
The CData ODBC Driver for FHIR enables you to integrate FHIR into workflows built using Microsoft Power Automate Desktop.
-
How to integrate SAS xpt with Apache Airflow
Access and process SAS XPORT in Apache Airflow using the CData JDBC Driver.
-
Connect to Sendwithus Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Sendwithus in the Denodo Virtual DataPort Administrator.
-
Connect Printify Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Printify using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData SSIS Components to Insert New or Update Existing Presto Records from SQL Server
Easily push SQL Server data to Presto using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Presto or update existing records with data from a SQL Server database.
-
Analyze Google Campaign Manager 360 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Campaign Manager 360 in Microsoft R Open.
-
Connect to PhantomBuster Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PhantomBuster.
-
Analyze HBase Data in Cognos Analytics
Use CData Connect AI to connect to HBase Data from Cognos Analytics and analyze live Apache HBase.
-
Automate Shopify Data Replication to SAP HANA
Use CData Sync to customize and automate Shopify replication to SAP HANA.
-
Build AI/ML Models with Live Browserless Data using Dataiku
Connect Browserless Data with Dataiku using the CData API Driver for JDBC.
-
Write a Simple Go Application to work with SendGrid Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SendGrid.
-
How to publish and share Reckon Data dashboards with Tableau Server
The CData ODBC driver for Reckon enables you integrate Reckon into Tableau dashboards.
-
How to connect and process Workday from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Workday.
-
Automated Continuous Google Sheets Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Sheets replication to SQL Server.
-
Explore Geographical Relationships in OnePageCrm Data with Power Map
Create data visualizations with OnePageCrm in Power Map.
-
Access EmailOctopus Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access EmailOctopus from your Oracle system.
-
How to Access Spotify Data Using Entity Framework
This article shows how to access Spotify using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Oracle Financials Cloud-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle Financials Cloud and build web apps with connectivity to live Oracle Financials Cloud.
-
Connect and Query Live SAS xpt Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAS XPORT into Databricks
-
Build Mixpanel-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Mixpanel.
-
Automated Continuous Sage Cloud Accounting Replication to Databricks
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Databricks.
-
Integrate Live IBM Cloud Object Storage Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to IBM Cloud Object Storage and integrate live IBM Cloud Object Storage into apps built in Microsoft Power Apps.
-
Build Automated Jira-Connected Workflows in Zapier
Use CData Connect AI to connect to live Atlassian Jira and build automated workflows in Zapier.
-
Access Pipedrive Data from MySQL in PHP
Connect to Pipedrive through the standard MySQL libraries in PHP.
-
Analyze Google Drive Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Drive and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Semantic Layer Views for HubSpot Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for HubSpot.
-
Perform Batch Operations with SAP Concur Data in Apache NiFi
Connect to SAP Concur and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrating Codex CLI with Samanage 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.
-
Connect to Active Directory in SpagoBI
Create reports featuring live Active Directory in SpagoBI Studio. Host Active Directory reports on SpagoBI Server.
-
How to Connect DBeaver to Mixpanel via a JDBC Driver
Manage Mixpanel with visual tools in DBeaver like the query browser.
-
Access Live ActiveCampaign 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 ActiveCampaign through MCP integration.
-
Build Semantic Layer Views for Quickbase Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Quickbase.
-
Analyze Live Adobe Commerce Data in SAS Viya
Use CData Connect AI to connect to Adobe Commerce from SAS Viya and deploy self-service analytics using live Adobe Commerce.
-
Build ScrapingBee-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ScrapingBee and build web apps with connectivity to live ScrapingBee.
-
Deploy the ADO.NET Provider for CircleCI on an SSRS Report Server
Connect to CircleCI from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Access Live Keap Data in AWS Lambda
Connect to live Keap in AWS Lambda using the CData JDBC Driver.
-
Connect to FTP Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for FTP Servers.
-
A PostgreSQL Interface for LightSpeedRetail Data (MySQL Remoting via JDBC)
Use the Remoting features of the LightSpeedRetail JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Helpscout Data from MySQL in Amazon QuickSight
Connect to Helpscout and build visualizations of Helpscout using a MySQL Connection in Amazon QuickSight.
-
Connect to Typeform Data from PowerBuilder via JDBC
This article demonstrates how to access Typeform from PowerBuilder using the Typeform JDBC Driver.
-
Analyze Stack Exchange Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Stack Exchange with the CData JDBC Driver for Stack Exchange.
-
Integrating Cursor CLI with LeadDesk 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.