CData Software - Knowledge Base
Recent Articles
-
Build SAP Business One-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP Business One and build web apps with connectivity to live SAP Business One.
-
Integrate Live SAS Data Sets Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAS Data Sets to Blue Prism using the CData ODBC Driver for SAS Data Sets to create automated workflows for repetitive business tasks.
-
Use the CData Software ODBC Driver for Brex in SAS for Real-Time Reporting and Analytics
Connect to real-time Brex in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Brex.
-
Connect to Aircall Data in RazorSQL
Connect to Aircall from wizards and query Aircall from the GUI in the RazorSQL database management tool.
-
Query Slack Data as a MySQL Database in Node.js
Execute MySQL queries against Slack from Node.js.
-
Connect to Couchbase Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Couchbase to connect to Couchbase and execute queries in PowerBuilder.
-
Access Live HDFS Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live HDFS data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrating Claude Code with Azure DevOps Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Azure DevOps within assisted coding and automated development workflows.
-
Build Dashboards with LinkedIn Data in DBxtra
Create dynamic dashboards and perform analytics based on LinkedIn in DBxtra.
-
Create Data Visualizations in Cognos BI with xBase Data
Access xBase as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Real-Time Access to Amazon DynamoDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon DynamoDB in real time.
-
Automate Facebook Ads Data Replication to Azure Data Lake
Use CData Sync to customize and automate Facebook Ads replication to Azure Data Lake.
-
Extend Google Sheets with Sybase Data
Make calls to Sybase from Google Apps Script via the API Server.
-
Connect to Redis Data in HULFT Integrate
Connect to Redis as a JDBC data source in HULFT Integrate
-
Use Dash to Build to Web Apps on Adobe Analytics Data
Create Python applications that use pandas and Dash to build Adobe Analytics-connected web apps.
-
Connect Omnisend to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Omnisend with IBM WebSphere for seamless data integration and connectivity.
-
Using the CData Software ODBC Driver for Greenhouse in PyCharm
Connect to Greenhouse as an ODBC data source in PyCharm using the CData Software ODBC Driver for Greenhouse.
-
Access Live Slack 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 Slack through MCP integration.
-
Build MVC Applications with Connectivity to Bitly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Bitly from an ASP.NET MVC application.
-
Connect to Beeminder Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Beeminder and work with Beeminder in your FileMaker applications.
-
Create Microsoft Entra ID-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Microsoft Entra ID Data from OutSystems and build custom enterprise apps using live Microsoft Entra ID.
-
Connect to Oracle HCM Cloud Data from PowerBuilder via JDBC
This article demonstrates how to access Oracle HCM Cloud from PowerBuilder using the Oracle HCM Cloud JDBC Driver.
-
Query Reckon Data as a MySQL Database in Node.js
Execute MySQL queries against Reckon from Node.js.
-
Access Live MYOB AccountRight Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MYOB AccountRight from your Google Sheets.
-
How to Create Power BI Visual Reports with Real-Time AlloyDB Data
Use CData Power BI Connectors to visualize Google AlloyDB in Power BI.
-
Connect to Square Data in JRuby
Create a simple JRuby app with access to live Square.
-
Connect to AgileCRM Data from PowerBuilder via JDBC
This article demonstrates how to access AgileCRM from PowerBuilder using the AgileCRM JDBC Driver.
-
A PostgreSQL Interface for LaunchDarkly Data (MySQL Remoting via JDBC)
Use the Remoting features of the LaunchDarkly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Moving Data from CSV to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live CSV data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous SAP Business One Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP Business One replication to Oracle.
-
Connect Workday Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Workday using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build a Singer.io Tap for Google Translate With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Translate data using
-
Integrating Codex CLI with Google BigQuery 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 an SAP BusinessObjects Universe on the CData ODBC Driver for Freshsales
Provide connectivity to Freshsales through an SAP BusinessObjects universe.
-
Replicate Multiple Trello Accounts
Replicate multiple Trello accounts to one or many databases.
-
Getting Started with the CData SSIS Components for NASA
Complete guide to installing, licensing, and connecting with the CData SSIS Components for NASA.
-
Connect to Real-Time REST Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for REST and Dataflow to import and use REST in Power Apps.
-
Migrating data from Spotify to Google BigQuery using CData SSIS Components.
Easily push Spotify to Google BigQuery using the CData SSIS Tasks for Spotify and Google BigQuery.
-
Build AI/ML Models with Live Brex Data using Dataiku
Connect Brex Data with Dataiku using the CData API Driver for JDBC.
-
Connect to Hive Data in NetBeans
Connect to Apache Hive in NetBeans with the data source configuration wizard.
-
How to Create Power BI Visual Reports with Real-Time RSS Feeds
Use CData Power BI Connectors to visualize RSS Feeds in Power BI.
-
Query Kafka Data in DataGrip
Create a Data Source for Kafka in DataGrip and use SQL to query live Apache Kafka.
-
Automate Adobe Commerce Data Replication to Azure Synapse
Use CData Sync to customize and automate Adobe Commerce replication to Azure Synapse.
-
Process & Analyze Act-On Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Act-On Data.
-
Build AI/ML Models with Live Dynamics 365 Data using Dataiku
Connect Dynamics 365 Data with Dataiku using the CData JDBC Driver for Dynamics 365.
-
Integrating Authorize.Net Data in Talend Cloud Data Management Platform
Connect Authorize.Net Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Authorize.Net.
-
How to Connect DBeaver to Todoist via a JDBC Driver
Manage Todoist with visual tools in DBeaver like the query browser.
-
Integrating Cursor CLI with Adobe Analytics 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.
-
How to Connect to Live Outreach.io 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 Outreach.io for you.
-
Model, Search, and Visualize Live Dynamics CRM Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Dynamics CRM for modeling, searching, and visualizing.
-
Use the CData Software JDBC Driver for MarkLogic in MicroStrategy Desktop
Connect to MarkLogic in MicroStrategy Desktop using the CData Software JDBC Driver for MarkLogic.
-
Consume Power BI XMLA OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Power BI XMLA feeds that reflect any changes in SAP Lumira.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Teradata actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Integrate Cursor with Live SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP HANA from within the editor.
-
Connecting Moonlit Workflow with SharePoint 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 Microsoft SharePoint in real time.
-
Visualize Live Drift Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Drift using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to import MariaDB Data into Apache Solr
Use the CData Software JDBC Driver for MariaDB in Data Import Handler and create an automated import of MariaDB to Apache Solr Enterprise Search platform.
-
Migrating data from MariaDB to Snowflake using CData SSIS Components.
Easily push MariaDB to Snowflake using the CData SSIS Tasks for MariaDB and Snowflake.
-
Bidirectional Access to Foursquare Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Foursquare in Filemaker Pro for Mac or Windows.
-
Connect to Real-Time Sendwithus Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Sendwithus in Power Apps.
-
Connect to Retently Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Retently and the SQL Gateway to access Retently from Google Apps Script.
-
Explore Geographical Relationships in Customer.io Data with Power Map
Create data visualizations with Customer.io in Power Map.
-
Automated Continuous MYOB AccountRight Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Apache Kafka.
-
Connect to SAS xpt Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAS xpt to connect to SAS XPORT and execute queries in PowerBuilder.
-
Use Dash to Build to Web Apps on EnterpriseDB Data
Create Python applications that use pandas and Dash to build EnterpriseDB-connected web apps.
-
Connect to MySQL Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for MySQL in the Denodo Virtual DataPort Administrator.
-
Bridge Supabase Connectivity with Apache NiFi
Access and process Supabase in Apache NiFi using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with Ontraport Data
Access Ontraport as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData JDBC Driver for Highrise
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Highrise.
-
Connect to Adobe Analytics Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Adobe Analytics in the Denodo Virtual DataPort Administrator.
-
Build Visualizations of JotForm Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of JotForm in Birst.
-
Build Voice Agents in ElevenLabs with access to Live CouchDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Apache CouchDB.
-
Import Real-Time Presto Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Presto in ColdFusion.
-
Automate Front Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Front from PowerShell? This article demonstrates how to utilize the Front Cmdlets for tasks like connecting to Front, automating operations, downloading data, and more.
-
Build DocuSign-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live DocuSign.
-
Getting Started with the CData SSIS Components for Microsoft Ads
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Microsoft Ads.
-
Build Semantic Layer Views for Presto Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Presto.
-
How to use SQLAlchemy ORM to access PhantomBuster Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of PhantomBuster.
-
Access Live PayPal Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PayPal from your Excel spreadsheets.
-
Automate SAP HANA XS Advanced Data Replication to Couchbase
Use CData Sync to Customize and automate SAP HANA XS Advanced replication to Couchbase.
-
Connect to eBay Analytics Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for eBay Analytics in the Denodo Virtual DataPort Administrator.
-
Access Live Vimeo Data in Coginiti Pro
Connect to and query live Vimeo from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to integrate Stack Exchange with Apache Airflow
Access and process Stack Exchange in Apache Airflow using the CData JDBC Driver.
-
How to connect PolyBase to Teamgate
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Teamgate.
-
Create Data Visualizations in Cognos BI with Yelp Data
Access Yelp as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate Multiple LightSpeedRetail Accounts via the CData Sync CLI
Replicate multiple LightSpeedRetail accounts to one or many databases.
-
Access Live Postmark Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Postmark into the statistical analysis tools available in SAS JMP. This article shows how to use Postmark in the Graph Builder and Query Builder.
-
Rapidly Develop Vimeo-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 Vimeo.
-
Automated Invoiced Data Replication to Teradata
Use CData Sync to Customize and automate Invoiced replication to Teradata.
-
Automate ZohoInvoice Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZohoInvoice from PowerShell? This article demonstrates how to utilize the ZohoInvoice Cmdlets for tasks like connecting to ZohoInvoice, automating operations, downloading data, and more.
-
Create MailerLite Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MailerLite data access from reports, embedded analytics, and more.
-
How to create Tavily federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Tavily in MySQL .
-
Query eBay Data through ODBC in Node.js
Use node-odbc to execute SQL queries against eBay from Node.js.
-
Integrating GitHub Copilot CLI with Gong 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.
-
How to Access Live SAP SuccessFactors Data in Visual Studio Code via Cline
Run CData MCP Server for SAP SuccessFactors on Windows Subsytem for Linux (WSL) and connect to live SAP SuccessFactors from the Cline extension in Visual Studio Code.
-
Connect to Microsoft Entra ID Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Entra ID.
-
How to create an RPA flow for SFTP Data in UiPath Studio
Use the SFTP ODBC Driver to create workflows that access real-time SFTP without any coding.
-
Create Informatica Mappings From/To a JDBC Data Source for Teamwork
Create Teamwork data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Grafana Data in Tableau
The CData ODBC driver for Grafana enables you integrate Grafana into Tableau dashboards.
-
Easily Integrate Templated Data in Lazarus Pascal IDE
Learn how to easily integrate live Templated in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.