CData Software - Knowledge Base
Recent Articles
-
Build Apps with Live Stack Exchange Data Using the Low-Code Development Platform of Mendix
Connect Stack Exchange with Mendix to build apps using the CData API Driver for JDBC.
-
How to connect Amazon QuickSight to Freshservice Data
Create a connection to Freshservice in CData Connect AI and insert Freshservice into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Real-Time Access to PostgreSQL in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to PostgreSQL in real time.
-
Automated Continuous PostgreSQL Replication to Vertica
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Vertica.
-
Integrating Kiro CLI with Google Tasks 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 DBeaver to SAP Ariba Source via a JDBC Driver
Manage SAP Ariba Source with visual tools in DBeaver like the query browser.
-
How to Query Live Raisers Edge NXT Data in Perplexity MacOS Desktop
Connect to and query live Raisers Edge NXT Data in Perplexity Desktop using CData MCP Server.
-
How to Use a Microsoft Access Database to Update Bullhorn CRM Data in Real Time
Update Bullhorn CRM data by creating a linked table in Microsoft Access with the CData Bullhorn CRM ODBC Driver.
-
Build Microsoft Planner-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft Planner Data from Choreo and build custom apps using live Microsoft Planner.
-
Build Google Ads-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Ads and build web apps with connectivity to live Google Ads.
-
Access Gorgias Data from MySQL in Amazon QuickSight
Connect to Gorgias and build visualizations of Gorgias using a MySQL Connection in Amazon QuickSight.
-
Using the CData Software ODBC Driver for Teamgate in PyCharm
Connect to Teamgate as an ODBC data source in PyCharm using the CData Software ODBC Driver for Teamgate.
-
Natively Connect to Stripe Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Stripe. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for SpaceX in MicroStrategy Desktop
Connect to SpaceX in MicroStrategy Desktop using the CData Software JDBC Driver for SpaceX.
-
Access Campaigner Data from MySQL in Amazon QuickSight
Connect to Campaigner and build visualizations of Campaigner using a MySQL Connection in Amazon QuickSight.
-
Integrating GitHub Copilot CLI with Azure Synapse 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 Dotmailer Data in CloverDX (formerly CloverETL)
Transfer Dotmailer using the visual workflow in the CloverDX data integration tool.
-
Build a PostgreSQL Interface for Power BI XMLA Data using the CData JDBC Driver
Use the Remoting features of the Power BI XMLA JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live GitLab Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live GitLab through MCP integration.
-
Back Up Apache Impala to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Impala. In this article, we will employ an SSIS workflow to populate a database with Apache Impala data.
-
Validate Salesforce CRM Analytics Data with QuerySurge
Access and validate Salesforce CRM Analytics in QuerySurge using the CData JDBC Driver.
-
Query Gumroad Data as a MySQL Database in Node.js
Execute MySQL queries against Gumroad from Node.js.
-
ETL ZohoMarketingHub in Oracle Data Integrator
This article shows how to transfer ZohoMarketingHub into a data warehouse using Oracle Data Integrator.
-
Automate Workday Data Replication to Azure Data Lake
Use CData Sync to customize and automate Workday replication to Azure Data Lake.
-
How to Use a Microsoft Access Database to Update Vault CRM Data in Real Time
Update Vault CRM data by creating a linked table in Microsoft Access with the CData Vault CRM ODBC Driver.
-
How to load Productboard data into Elasticsearch via Logstash
Introducing a simple method to load Productboard data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Short.io Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Short.io.
-
Use the CData Software ODBC Driver for BenchmarkEmail in MicroStrategy
Connect to BenchmarkEmail in MicroStrategy Developer using the CData Software ODBC Driver for BenchmarkEmail.
-
How to Create Power BI Visual Reports with Real-Time Foursquare Data
Use CData Power BI Connectors to visualize Foursquare in Power BI.
-
Connect to and Visualize Live Airtable Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Airtable.
-
How to connect to Azure Table Data from IntelliJ
Integrate connectivity to Azure Table Storage with wizards in IntelliJ.
-
Automated Continuous Freshteam Replication to SingleStore
Use CData Sync for automated, continuous, customizable Freshteam replication to SingleStore.
-
Object-Relational Mapping (ORM) with Google Translate Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Google Translate into a Java-based ORM framework, Hibernate.
-
Integrate Cursor with Live Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft Teams from within the editor.
-
Connect to FormSite Data in NetBeans
Connect to FormSite in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Python Connector for Superchat
Learn to install and license the CData Python Connector
-
How to publish and share CockroachDB Data dashboards with Tableau Server
The CData ODBC driver for CockroachDB enables you integrate CockroachDB into Tableau dashboards.
-
Create a Data Access Object for Printful Data using JDBI
A brief overview of creating a SQL Object API for Printful in JDBI.
-
Getting Started with the CData SSIS Components for OnePageCrm
Complete guide to installing, licensing, and connecting with the CData SSIS Components for OnePageCrm.
-
Extract, Transform, and Load SAP SuccessFactors LMS Data in Informatica PowerCenter
Create a simple Workflow for SAP SuccessFactors LMS in Informatica PowerCenter.
-
Access Live Tally Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Tally ERP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Working with Zoho Inventory Data in LINQPad
Execute LINQ queries to Zoho Inventory in LINQPad.
-
SAP SuccessFactors LMS Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP SuccessFactors LMS facts in real time.
-
Automate Microsoft Teams Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Teams replication to Azure Data Lake.
-
Connect to Hacker News Data in DBArtisan
Use wizards in DBArtisan to configure Hacker News as a data source.
-
Integrate Live Odoo Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Odoo from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Odoo ERP.
-
Publish Phoenix-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apache Phoenix.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dotmailer
Provide connectivity to Dotmailer through an SAP BusinessObjects universe.
-
How to Build an ETL App for ScrapingBee Data in Python with CData
Create ETL applications and real-time data pipelines for ScrapingBee in Python with petl.
-
Automated Continuous Sendwithus Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Sendwithus replication to IBM DB2.
-
Connect Adobe Commerce Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Adobe Commerce using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Tableau Connector for SAP ByDesign
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP ByDesign.
-
How to Query ZeroBounce Data in MySQL Workbench
Execute MySQL queries against live ZeroBounce from MySQL Workbench.
-
Configure the CData JDBC Driver for Wistia in a Connection Pool in Tomcat
Connect to Wistia from a connection pool in Tomcat.
-
Back Up Google Tasks 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 Google Tasks data.
-
Integrate Real-Time Access to HubSpot in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to HubSpot in real time.
-
Build Pipelines with Live Oracle Sales Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle Sales from Google Cloud Data Fusion, enabling the integration of live Oracle Sales into the building and management of effective data pipelines.
-
Operational Reporting on Perigon Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Perigon.
-
Integrate Outlook Data in Pentaho Data Integration
Build ETL pipelines based on Outlook in the Pentaho Data Integration tool.
-
Integrate Open WebUI with Live Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Blackbaud FE NXT from within the chat interface.
-
Use the CData Software JDBC Driver for QuickBooks Online in MicroStrategy
Connect to QuickBooks Online in MicroStrategy Developer using the CData Software JDBC Driver for QuickBooks Online.
-
Visualize Printful Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Printful.
-
Integrate OpenWeatherMap Data in Pentaho Data Integration
Build ETL pipelines based on OpenWeatherMap in the Pentaho Data Integration tool.
-
Connect to and Visualize Live Strava Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Strava.
-
Use the CData Software ODBC Driver for Power BI XMLA in MicroStrategy Web
Connect to Power BI XMLA in MicroStrategy Web using the CData Software ODBC Driver for Power BI XMLA.
-
Automated Continuous Freshsales Replication to MySQL
Use CData Sync for automated, continuous, customizable Freshsales replication to MySQL.
-
Visualize Microsoft Entra ID Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Entra ID into dashboards in TIBCO Spotfire.
-
Replicate API Data to Multiple Databases via the CData Sync CLI
Replicate API to disparate databases with a single configuration.
-
Import Real-Time Mode Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Mode in ColdFusion.
-
How to Visualize Databricks Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Databricks in Python.
-
Automated Continuous PagerDuty Replication to Amazon S3
Use CData Sync for automated, continuous, customizable PagerDuty replication to Amazon S3.
-
DataBind Controls to Printify Data in C++Builder
DataBind to Printify in C++Builder with standard components and controls.
-
View Reports on Real-Time Mouseflow Data in Power BI Report Server
Use the CData ODBC Driver for Mouseflow to visualize Mouseflow in Power BI Desktop and then publish them to Power BI Report Server.
-
How to load Xero data into Elasticsearch via Logstash
Introducing a simple method to load Xero data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Cloudant Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live IBM Cloudant from your Excel spreadsheets.
-
Deploy the ADO.NET Provider for Zoom on an SSRS Report Server
Connect to Zoom 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.
-
How to Query Live MariaDB Data in Claude Desktop
Connect to and query live MariaDB Data in Claude Desktop using CData MCP Server.
-
Access Live AgileCRM Data in Coginiti Pro
Connect to and query live AgileCRM from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Migrating data from Mode to Google BigQuery using CData SSIS Components.
Easily push Mode to Google BigQuery using the CData SSIS Tasks for Mode and Google BigQuery.
-
Consume PostgreSQL OData Feeds in SAP Lumira
Use the API Server to create data visualizations on PostgreSQL feeds that reflect any changes in SAP Lumira.
-
Build SAP-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAP to explore live SAP Data in Claude Code to assist with building SAP-powered applications.
-
Publish Crystal Reports on VWO Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date VWO.
-
Connect to BenchmarkEmail Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for BenchmarkEmail.
-
Create Microsoft Teams Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Microsoft Teams data access from reports, embedded analytics, and more.
-
Visualize Dynamics 365 Data in Tableau
The CData ODBC driver for Dynamics 365 enables you integrate Microsoft Dynamics 365 into Tableau dashboards.
-
Automated Continuous Trello Replication to Databricks
Use CData Sync for automated, continuous, customizable Trello replication to Databricks.
-
Automated Continuous Adobe Target Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Adobe Target replication to Azure SQL Database.
-
Connect to Live Elasticsearch Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Elasticsearch in CData Connect AI and connect to your Elasticsearch from PostgreSQL.
-
Create SSAS Tabular Models from Strava Data
How to build a SQL Server Analysis Service Tabular Model from Strava using CData drivers.
-
Build Automated Twilio-Connected Workflows in Zapier
Use CData Connect AI to connect to live Twilio and build automated workflows in Zapier.
-
How to integrate HelloSign with Apache Airflow
Access and process HelloSign in Apache Airflow using the CData JDBC Driver.
-
How to import ZeroBounce Data into Apache Solr
Use the CData Software JDBC Driver for ZeroBounce in Data Import Handler and create an automated import of ZeroBounce to Apache Solr Enterprise Search platform.
-
How to integrate Gmail with Apache Airflow
Access and process Gmail in Apache Airflow using the CData JDBC Driver.
-
How to Query Live Teradata Data in Perplexity MacOS Desktop
Connect to and query live Teradata Data in Perplexity Desktop using CData MCP Server.
-
Automated Google Cloud Storage Data Replication to Teradata
Use CData Sync to Customize and automate Google Cloud Storage replication to Teradata.
-
How to Connect DBeaver to LightSpeedRetail via a JDBC Driver
Manage LightSpeedRetail with visual tools in DBeaver like the query browser.
-
Getting Started with the CData ODBC Driver for AlloyDB
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for AlloyDB.
-
Integrating Kiro CLI with Apify 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.
-
Create Datasets from Gorgias in Domo Workbench and Build Visualizations of Gorgias Data in Domo
Use the CData Software ODBC Driver for Gorgias to create datasets from Gorgias in Domo Workbench and then build visualizations in the Domo service.
-
How to Import Data from PayPal into Google Sheets
Import PayPal into a Google spreadsheet that is automatically refreshed.