CData Software - Knowledge Base
Recent Articles
-
Integrate Nuclia with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Nuclia with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Nuclia.
-
Create a Data Access Object for Calendly Data using JDBI
A brief overview of creating a SQL Object API for Calendly in JDBI.
-
Query Live EnterpriseDB Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live EnterpriseDB directly from the development environment.
-
Enable the Everhour JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Everhour.
-
Automated Continuous Oracle Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Oracle replication to Amazon S3.
-
Enable the Egnyte JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Egnyte.
-
Connect to ChargeOver Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ChargeOver and work with ChargeOver in your FileMaker applications.
-
Query Office 365 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Office 365 entities in PHP by modeling them as objects.
-
Connect to Live Snapchat Ads Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Snapchat Ads in CData Connect AI and connect to your Snapchat Ads from PostgreSQL.
-
How to Connect DBeaver to Trello via a JDBC Driver
Manage Trello with visual tools in DBeaver like the query browser.
-
Migrating data from CampaignMonitor to Snowflake using CData SSIS Components.
Easily push CampaignMonitor to Snowflake using the CData SSIS Tasks for CampaignMonitor and Snowflake.
-
Viewing OData Services in RAD Studio Data Explorer
How to view OData in RAD Studio Data Explorer using the CData ODBC Driver for OData.
-
Validate ZendeskSell Data with QuerySurge
Access and validate ZendeskSell in QuerySurge using the CData JDBC Driver.
-
Query ZohoSubscriptions Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZohoSubscriptions from Node.js.
-
Automated Continuous Samanage Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Samanage replication to IBM DB2.
-
Getting Started with the CData ADO.NET Provider for Google Sheets
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Sheets.
-
Visualize PostgreSQL Data in Sisense
Create an ElastiCube in Sisense app with access to PostgreSQL.
-
Integrating GitHub Copilot CLI with Atlassian Confluence 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.
-
Automated Continuous QuickBooks Time Replication to SQLite
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to SQLite.
-
Getting Started with the CData ADO.NET Provider for Adobe Commerce
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Adobe Commerce.
-
How to publish and share MariaDB Data dashboards with Tableau Server
The CData ODBC driver for MariaDB enables you integrate MariaDB into Tableau dashboards.
-
Getting Started with the CData SSIS Components for Ontraport
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Ontraport.
-
Use the CData Software ODBC Driver for Act-On in MicroStrategy
Connect to Act-On in MicroStrategy Developer using the CData Software ODBC Driver for Act-On.
-
Feed Bitbucket Data into FineReport
How to set Bitbucket as a JDBC data source in FineReport.
-
Connect to Jira Data in CloverDX (formerly CloverETL)
Transfer Atlassian Jira using the visual workflow in the CloverDX data integration tool.
-
Create Power BI XMLA-Connected Nintex Workflows
Use CData Connect AI to connect to Power BI XMLA Data from Nintex Workflow Cloud and build custom workflows using live Power BI XMLA.
-
Query SAS Data Sets Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAS Data Sets from Node.js.
-
Authorize.Net Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Authorize.Net through CData Connect AI using different applications and tools.
-
Integrating Dataiku with Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Box.
-
How to Connect to Live MailChimp 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 MailChimp for you.
-
Edit and Search External CSV Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of CSV/TSV Files to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create CSV Data objects that you can access from apps and the dashboard.
-
Query SAP Netweaver Gateway Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Netweaver Gateway from Node.js.
-
Build an OLAP Cube in SSAS from Lakebase Data
Establish a connection to Lakebase data from SQL Server Analysis Services, and use the Lakebase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Object-Relational Mapping (ORM) with ZohoMarketingHub 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 ZohoMarketingHub into a Java-based ORM framework, Hibernate.
-
Onfleet Reporting in OBIEE with the Onfleet JDBC Driver
Deploy the Onfleet JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use Microsoft Copilot Studio to talk to your PostgreSQL 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 PostgreSQL for you.
-
Build Dashboards with Microsoft Planner Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Planner in Dundas BI.
-
Getting Started with the CData Power BI Connector for Zoho Creator
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Zoho Creator.
-
Publish Crystal Reports on Clari Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Clari.
-
How to Query Webflow Data in MySQL Workbench
Execute MySQL queries against live Webflow from MySQL Workbench.
-
How to connect to Paddle Data from Spring Boot
Connect to Paddle in a Spring Boot Application using the CData API Driver for JDBC
-
Getting Started with the CData Python Connector for Billsby
Learn to install and license the CData Python Connector
-
Easily Integrate Bitly Data in Lazarus Pascal IDE
Learn how to easily integrate live Bitly in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Outreach.io Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Outreach.io replication to Amazon Redshift.
-
Hive Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Apache Hive through CData Connect AI using different applications and tools.
-
Use the CData ODBC Driver for PabblySubscriptions from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PabblySubscriptions to connect to PabblySubscriptions from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PabblySubscriptions in Excel.
-
Integrate Real-Time Access to eBay Analytics in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to eBay Analytics in real time.
-
Integrate Open WebUI with Live Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Directory from within the chat interface.
-
Automated Continuous Everhour Replication to Vertica
Use CData Sync for automated, continuous, customizable Everhour replication to Vertica.
-
Integrating Antigravity CLI with GitLab via CData CLI
Connect GitLab to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Qualaroo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Qualaroo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Qualaroo.
-
Use the CData ODBC Driver for Workday in Microsoft Power Query
You can use the CData Workday ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Workday into Microsoft Power Query.
-
DataBind Controls to ActiveCampaign Data in Delphi
DataBind to ActiveCampaign in Delphi with standard data access components and controls.
-
Create Notion Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Notion data access from reports, embedded analytics, and more.
-
Replicate Aweber Data to Multiple Databases
Replicate Aweber to disparate databases with a point-and-click configuration.
-
Import Real-Time Office 365 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Office 365 in ColdFusion.
-
How to Seamlessly Import PolarTeamPro Data into IBM SPSS Modeler
Integrate PolarTeamPro data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Vercel Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Vercel and the SQL Gateway to access Vercel from Google Apps Script.
-
Validate Wistia Data with QuerySurge
Access and validate Wistia in QuerySurge using the CData JDBC Driver.
-
How to Seamlessly Import Omnisend Data into IBM SPSS Modeler
Integrate Omnisend data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Stripe Data in CloverDX (formerly CloverETL)
Transfer Stripe using the visual workflow in the CloverDX data integration tool.
-
Analyze Procore Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Procore in Microsoft R Open.
-
Use the CData Software JDBC Driver for Pingdom in MicroStrategy Web
Connect to Pingdom in MicroStrategy Web using the CData Software JDBC Driver for Pingdom.
-
Build AI Agents with API 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 API through CData Connect AI.
-
How to integrate Metabase with Zoho Projects Data
Use CData Connect AI to connect to live Zoho Projects and create an interactive dashboard in Metabase from Zoho Projects.
-
Connect to Miro Data in DBeaver
Use the CData ODBC Driver to connect to Miro in DBeaver.
-
Integrate Live Google Calendar Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Calendar and integrate live Google Calendar into apps built in Microsoft Power Apps.
-
How to create Shippo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Shippo in MySQL .
-
Access SendPulse Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SendPulse from your Oracle system.
-
Use Dash to Build to Web Apps on Dynamics 365 Data
Create Python applications that use pandas and Dash to build Dynamics 365-connected web apps.
-
Connect to Productboard Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Productboard.
-
Build Visualizations of Pushbullet Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pushbullet in Birst.
-
Access Live SAP SuccessFactors LMS Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP SuccessFactors LMS from your Excel spreadsheets.
-
DataBind Controls to Airtable Data in C++Builder
DataBind to Airtable in C++Builder with standard components and controls.
-
Integrating Codex CLI with NASA 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.
-
Natively Connect to LinkedIn Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to LinkedIn. Leverage the native support for ODBC in PHP.
-
Integrate Quickbase Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Quickbase and integrate live Quickbase into your Power Automate tasks.
-
Connect to Act-On Data from AWS Glue
Use CData Connect AI to gain access to live Act-On from your AWS Glue jobs.
-
Query Mode Data in DataGrip
Create a Data Source for Mode in DataGrip and use SQL to query live Mode.
-
How to Query Live ActiveCampaign Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ActiveCampaign data in natural language using Python.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Fieldglass using the Model Context Protocol.
-
Integrating Kiro CLI with Cloudant 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.
-
HBase Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on HBase facts in real time.
-
How to Connect to & Open Chargebee Data in Microsoft Excel
This article uses the CData ODBC driver for Chargebee to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Outlook with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Outlook with External Services.
-
Connect to FormSite Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for FormSite in the Denodo Virtual DataPort Administrator.
-
Create Datasets from ZohoSubscriptions in Domo Workbench and Build Visualizations of ZohoSubscriptions Data in Domo
Use the CData Software ODBC Driver for ZohoSubscriptions to create datasets from ZohoSubscriptions in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Smartsheet Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Smartsheet into the statistical analysis tools available in SAS JMP. This article shows how to use Smartsheet in the Graph Builder and Query Builder.
-
Query Timely Data in ColdFusion
Write standard ColdFusion data access code to connect to Timely.
-
Connect to Microsoft Teams from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Teams, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live Contentful Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Contentful into the statistical analysis tools available in SAS JMP. This article shows how to use Contentful in the Graph Builder and Query Builder.
-
Connect Retently Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Retently using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating ServiceDesk Plus Data in Talend Cloud Data Management Platform
Connect ServiceDesk Plus Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Replicate Kintone Data from PowerShell
Write a quick PowerShell script to query Kintone. Use connectivity to the live data to replicate Kintone to SQL Server.
-
Automated Continuous Facebook Replication to Snowflake
Use CData Sync for automated, continuous, customizable Facebook replication to Snowflake.
-
Explore Geographical Relationships in HelloSign Data with Power Map
Create data visualizations with HelloSign in Power Map.
-
Build SurveyMonkey-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SurveyMonkey.
-
How to Query Dynamics NAV Data in MySQL Workbench
Execute MySQL queries against live Microsoft Dynamics NAV from MySQL Workbench.
-
Access Live NetSuite SuiteAnalytics Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live NetSuite SuiteAnalytics from your Excel spreadsheets.
-
Connect to ClickTime Data in DBeaver
Use the CData ODBC Driver to connect to ClickTime in DBeaver.