CData Software - Knowledge Base
Recent Articles
-
How to connect PolyBase to Pushbullet
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Pushbullet.
-
Build an OLAP Cube in SSAS from Active Directory Data
Establish a connection to Active Directory data from SQL Server Analysis Services, and use the Active Directory Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Pinterest Data from a Connection Pool in Jetty
The Pinterest JDBC Driver supports connection pooling: This article shows how to connect faster to Pinterest from Web apps in Jetty.
-
Visualize BambooHR Data in Sisense
Create an ElastiCube in Sisense app with access to BambooHR.
-
Connect to Oracle Financials Cloud Data from Crystal Reports
Use CData Connect AI to connect to and report on live Oracle Financials Cloud from Crystal Reports.
-
How to Build an ETL App for Guru Data in Python with CData
Create ETL applications and real-time data pipelines for Guru in Python with petl.
-
Automated Continuous Reckon Accounts Hosted Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Google Cloud SQL.
-
How to use SQLAlchemy ORM to access Cosmos DB Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Cosmos DB.
-
How to Query Live REST Data in Perplexity MacOS Desktop
Connect to and query live REST Data in Perplexity Desktop using CData MCP Server.
-
Import Real-Time Spark Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apache Spark SQL in ColdFusion.
-
Publish Crystal Reports on Gumroad Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Gumroad.
-
How to Access Live Toggl Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Toggl enables you to integrate Toggl into workflows built using Microsoft Power Automate Desktop.
-
Connect to Todoist Data from a Connection Pool in JBoss
Integrate Todoist into Java servlets: Use the Management Console in JBoss to install the Todoist JDBC Driver.
-
Access Live Monday.com Data in AWS Lambda
Connect to live Monday.com in AWS Lambda using the CData JDBC Driver.
-
Integrate with Oracle Service Cloud Data in JReport Designer
Create charts and reports based on Oracle Service Cloud in JReport Designer.
-
Integrate with Qualaroo Data in JReport Designer
Create charts and reports based on Qualaroo in JReport Designer.
-
Visualize Azure Data Catalog Data in TIBCO Spotfire through ADO.NET
Integrate Azure Data Catalog into dashboards in TIBCO Spotfire.
-
Automated Continuous eBay Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable eBay replication to Apache Kafka.
-
Build Semantic Layer Views for Printful Data in APOS Live Data Gateway
Use the CData Connector for Printful in APOS Live Data Gateway to build Semantic Layer Views for Printful.
-
Object-Relational Mapping (ORM) with LinkedIn Ads 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 LinkedIn Ads into a Java-based ORM framework, Hibernate.
-
Query Google Analytics Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Google Analytics and perform CRUD operations on Google Analytics from Node.js.
-
DataBind Controls to AlloyDB Data in C++Builder
DataBind to Google AlloyDB in C++Builder with standard components and controls.
-
How to Visualize Cassandra 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 Apache Cassandra in Python.
-
Integrating Gumloop with ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ActiveCampaign within automated workflows.
-
Getting Started with the CData Power BI Connector for TigerGraph
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for TigerGraph.
-
How to Work with Aircall Data in ETL Validator JDBC
Connect to Aircall from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Claude Code CLI with OneNote 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.
-
Integrating Codex CLI with Blackbaud FE NXT 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 Work with Nuclia Data in ETL Validator JDBC
Connect to Nuclia from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Clio in SAS for Real-Time Reporting and Analytics
Connect to real-time Clio in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Clio.
-
Use the CData Software ODBC Driver for Discord in MicroStrategy Desktop
Connect to Discord in MicroStrategy Desktop using the CData Software ODBC Driver for Discord.
-
Access Live Airtable 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 Airtable through MCP integration.
-
Build Voice Agents in ElevenLabs with access to Live Lakebase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Lakebase.
-
Integrating Codex CLI with Adobe Commerce 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 Build an ETL App for OData Services in Python with CData Connect AI
Build ETL pipelines that read and write live OData in Python with petl and the CData Connect AI Python SDK.
-
Replicate Multiple ZohoDesk Accounts via the CData Sync CLI
Replicate multiple ZohoDesk accounts to one or many databases.
-
Integrate Google Sheets Data in the Pentaho Report Designer
Publish reports based on Google Sheets in the Pentaho BI tool.
-
Build Basecamp-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Basecamp.
-
Build Visualizations of Slack Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Slack in Birst.
-
Connect to Google Drive Data from a Connection Pool in JBoss
Integrate Google Drive into Java servlets: Use the Management Console in JBoss to install the Google Drive JDBC Driver.
-
How to Easily Query Hive Data in OpenOffice Base
Connect to Hive data in OpenOffice Base using the CData ODBC Driver for Hive and generate reports with live data insights.
-
Connect to Cvent Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Cvent in the Denodo Virtual DataPort Administrator.
-
Integrating Cursor CLI with Procore 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 Intercom Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Intercom.
-
A PostgreSQL Interface for Parallel Data (MySQL Remoting via JDBC)
Use the Remoting features of the Parallel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Real-Time Short.io Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Short.io in ColdFusion.
-
Access Live HubSpot 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 HubSpot through MCP integration.
-
Access Cloudflare Data from MySQL in Amazon QuickSight
Connect to Cloudflare and build visualizations of Cloudflare using a MySQL Connection in Amazon QuickSight.
-
How to Work with Teamgate Data in AWS Glue Jobs Using JDBC
Connect to Teamgate from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query Autopilot Data as a MySQL Database in Node.js
Execute MySQL queries against Autopilot from Node.js.
-
How to Connect the Power BI Service to Kintone: Complete Guide
Connect to the CData Software Power BI Connector for Kintone from PowerBI.com to provide real-time Kintone across the organization.
-
Back Up Greenhouse to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Greenhouse. In this article, we will employ an SSIS workflow to populate a database with Greenhouse data.
-
A PostgreSQL Interface for Teradata Data (MySQL Remoting via JDBC)
Use the Remoting features of the Teradata JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live Paddle Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Paddle using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Keap Data in NetBeans
Connect to Keap in NetBeans with the data source configuration wizard.
-
Access Live Keap Data in Coginiti Pro
Connect to and query live Keap from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze Google Analytics Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Analytics in Microsoft R Open.
-
Build SharePoint-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SharePoint to explore live SharePoint Data in Cursor to assist with building SharePoint-powered applications.
-
Connect to and Query QuickBooks Online Data in QlikView over ODBC
Create data visualizations with QuickBooks Online in QlikView.
-
Natively Connect to Teamgate Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Teamgate. Leverage the native support for ODBC in PHP.
-
Integrating Cursor CLI with Yelp 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 EnterpriseDB Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your EnterpriseDB for you.
-
Validate Splunk Data with QuerySurge
Access and validate Splunk in QuerySurge using the CData JDBC Driver.
-
Create Salesforce-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Salesforce Data from Klipfolio and build custom visualizations using live Salesforce & Force.com.
-
View Reports on Real-Time Paymo Data in Power BI Report Server
Use the CData ODBC Driver for Paymo to visualize Paymo in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect GitLab Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your GitLab using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use Microsoft Copilot Studio to talk to your Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Apache Impala for you.
-
Visualize Live HDFS Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apache HDFS using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Agno to Talk to Your SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SAP SuccessFactors for you.
-
Getting Started with the CData Tableau Connector for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Spark Replication to SQL Server
Use CData Sync for automated, continuous, customizable Spark replication to SQL Server.
-
Visualize Highrise Data in Tableau
The CData ODBC driver for Highrise enables you integrate Highrise CRM into Tableau dashboards.
-
Visualize Live Attio Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Attio using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Natively Connect to BambooHR Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to BambooHR. Leverage the native support for ODBC in PHP.
-
Create Power BI Reports on Real-Time ConvertAPI Data
Use the CData ODBC Driver for ConvertAPI to visualize ConvertAPI in Power BI Desktop.
-
Moving Data from Mode to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Mode data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Publish Reports with Delighted Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Delighted.
-
Object-Relational Mapping (ORM) with Bullhorn CRM 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 Bullhorn CRM into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData Power BI Connector for Pingdom
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Connect to Live Adobe Commerce Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Adobe Commerce for you.
-
View Reports on Real-Time Omnisend Data in Power BI Report Server
Use the CData ODBC Driver for Omnisend to visualize Omnisend in Power BI Desktop and then publish them to Power BI Report Server.
-
How to create Visio diagrams from Act CRM Data
Automatically update Act CRM with the changes you make to Visio master shapes.
-
How to work with Greenhouse Data in Apache Spark using SQL
Access and process Greenhouse Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to ShipStation Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ShipStation and the SQL Gateway to access ShipStation from Google Apps Script.
-
Visualize Live LinkedIn Ads Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live LinkedIn Ads using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automate Paylocity Data Replication to SAP HANA
Use CData Sync to customize and automate Paylocity replication to SAP HANA.
-
Access Live SurveyMonkey Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SurveyMonkey from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Oracle HCM Cloud Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Oracle HCM Cloud and build visualizations in Tableau Cloud.
-
Publish Reports with Flowlu Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Flowlu.
-
Integrating Claude Code CLI with Lakebase 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.
-
Rapidly Develop Mailjet-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 Mailjet.
-
Using the CData Software ODBC Driver for Exact Online in PyCharm
Connect to Exact Online as an ODBC data source in PyCharm using the CData Software ODBC Driver for Exact Online.
-
Getting Started with the CData ODBC Driver for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for CampaignMonitor.
-
Migrating data from ZohoSubscriptions to Databricks using CData SSIS Components.
Easily push ZohoSubscriptions to Databricks using the CData SSIS Tasks for ZohoSubscriptions and Databricks.
-
Connect and Query Live HBase Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Apache HBase into Databricks
-
Stream SageHR Data into Apache Kafka Topics
Access and stream SageHR in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData ODBC Driver for QuickBooks Online in Microsoft Power Query
You can use the CData QuickBooks Online ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import QuickBooks Online into Microsoft Power Query.
-
Automated Continuous SendPulse Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SendPulse replication to PostgreSQL.
-
Build Visualizations of Adobe Experience Manager Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Adobe Experience Manager in Birst.
-
Connect to Dropbox Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Dropbox in Airbyte.