CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData JDBC Driver for Act CRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Act CRM.
-
Connect to Parallel Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Parallel.
-
Analyze SendGrid Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SendGrid from Power Pivot. You will use the Table Import Wizard to load SendGrid. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Hugging Face Data in DBeaver
Use the CData ODBC Driver to connect to Hugging Face in DBeaver.
-
Connect to Dynamics 365 Data in JRuby
Create a simple JRuby app with access to live Microsoft Dynamics 365.
-
Visualize ZohoDesk Data in Tableau
The CData ODBC driver for ZohoDesk enables you integrate ZohoDesk into Tableau dashboards.
-
Easily Integrate WooCommerce Data in Lazarus Pascal IDE
Learn how to easily integrate live WooCommerce in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software JDBC Driver for Oracle Sales in MicroStrategy
Connect to Oracle Sales in MicroStrategy Developer using the CData Software JDBC Driver for Oracle Sales.
-
Query Reckon Accounts Hosted Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Reckon Accounts Hosted and perform CRUD operations on Reckon Accounts Hosted from Node.js.
-
How to Easily Query LeadDesk Data in OpenOffice Base
Connect to LeadDesk data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData Software ODBC Driver for HBase in MicroStrategy Web
Connect to Apache HBase in MicroStrategy Web using the CData Software ODBC Driver for HBase.
-
Automate FormSite Data Replication to SAP HANA
Use CData Sync to customize and automate FormSite replication to SAP HANA.
-
Access Live Google Cloud Storage Data in Coginiti Pro
Connect to and query live Google Cloud Storage from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Live Adobe Commerce Data in the Power BI Service
Use CData Connect AI to connect to live Adobe Commerce and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Choosing the Best Method to Connect Aha! to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Aha! from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate with live Google Calendar Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Calendar in Jitterbit.
-
Integrating Antigravity CLI with Adobe Commerce via CData CLI
Connect Adobe Commerce to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Hive Data in RapidMiner
Integrate Apache Hive with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous HCL Domino Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HCL Domino replication to Amazon Redshift.
-
Bridge Exact Online Connectivity with Apache NiFi
Access and process Exact Online in Apache NiFi using the CData JDBC Driver.
-
Access Live WooCommerce 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 WooCommerce through MCP integration.
-
Changelog: Driver Update 2024.2
Review the driver-specific changes from the 2024.2 CData Driver release.
-
Connect to HCL Domino from Asprova with CData Software ODBC Driver for HCL Domino
This article shows how to connect faster to HCL Domino data from Asprova.
-
Connect to DocuSign Data in Claris FileMaker Pro
Use the CData ODBC Driver for DocuSign in FileMaker Pro to connect to DocuSign and work with DocuSign in your FileMaker applications.
-
A PostgreSQL Interface for Clockify Data (MySQL Remoting via JDBC)
Use the Remoting features of the Clockify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Zoho Creator Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho Creator from Node.js.
-
Build a Simple VCL Application for WooCommerce Data
How to build a simple VCL Application to view WooCommerce in RAD Studio using the CData ODBC Driver for WooCommerce.
-
Use the CData ODBC Driver for SageHR in Microsoft Power Query
You can use the CData SageHR ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SageHR into Microsoft Power Query.
-
How to Connect to Live Adobe Commerce 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 Adobe Commerce for you.
-
How to Seamlessly Import Intercom Data into IBM SPSS Modeler
Integrate Intercom data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Extract, Transform, and Load Quaderno Data in Informatica PowerCenter
Create a simple Workflow for Quaderno in Informatica PowerCenter.
-
Teamgate Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Teamgate facts in real time.
-
Connect to and Visualize Live Okta Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Okta.
-
Automated Continuous SendInBlue Replication to SQL Server
Use CData Sync for automated, continuous, customizable SendInBlue replication to SQL Server.
-
Integrating Avro Data in Talend Cloud Data Management Platform
Connect Avro Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Avro.
-
Create Informatica Mappings From/To a JDBC Data Source for QuickBooks Online
Create QuickBooks Online data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Validate Email Data with QuerySurge
Access and validate Email in QuerySurge using the CData JDBC Driver.
-
Analyze Salesforce Pardot Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce Pardot and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Work with ZohoDesk Data in AWS Glue Jobs Using JDBC
Connect to ZohoDesk from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to Live Exact Online 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 Exact Online for you.
-
Access Live FreeAgent Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate FreeAgent into the statistical analysis tools available in SAS JMP. This article shows how to use FreeAgent in the Graph Builder and Query Builder.
-
Visualize Live Chargebee Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Chargebee using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Apps with Live Apache Hive in Adalo using CData Connect AI
Use CData Connect AI to integrate live Apache Hive into the Adalo platform and build custom mobile and web applications with real-time Apache Hive.
-
Getting Started with the CData SSIS Components for ZarMoney
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZarMoney.
-
Access SpaceX Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SpaceX from HeidiSQL.
-
Integrating Codex CLI with WordPress 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.
-
Integrate IBM Informix Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live IBM Informix from Informatica Cloud.
-
Connect to IBM Informix Data in RazorSQL
Connect to IBM Informix from wizards and query IBM Informix from the GUI in the RazorSQL database management tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Paylocity
Provide connectivity to Paylocity through an SAP BusinessObjects universe.
-
Helpscout Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Helpscout facts in real time.
-
Natively Connect to Mode Data in PHP
The CData ODBC driver for Mode enables you to create PHP applications with connectivity to Mode. Leverage the native support for ODBC in PHP.
-
Connect Pipeliner CRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Pipeliner CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating Claude Code with SharePoint Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft SharePoint within assisted coding and automated development workflows.
-
How to connect to SuiteCRM Data in DBVisualizer
Integrate SuiteCRM with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Productboard Data in the Pentaho Report Designer
Publish reports based on Productboard in the Pentaho BI tool.
-
A PostgreSQL Interface for Zoho CRM Data using the CData ODBC Driver
Use the SQL Gateway and Zoho CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Shippo Data in Heroku for Use in Salesforce Connect
Replicate Shippo to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData ODBC Driver for Dynamics NAV from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Dynamics NAV to connect to Microsoft Dynamics NAV from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Dynamics NAV in Excel.
-
Build a Singer.io Tap for LinkedIn With the CData Python Connector
Learn how to easily build a Singer.io Tap for live LinkedIn data using
-
Edit and Search Google Campaign Manager 360 External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Campaign Manager 360 to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Campaign Manager 360 objects that you can access from apps and the dashboard.
-
Build Sybase IQ-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Sybase IQ and build Sybase IQ-connected web apps with Axios.
-
How to Connect to Live Acumatica Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Acumatica ERP securely in real time.
-
A PostgreSQL Interface for NetSuite Data using the CData ODBC Driver
Use the SQL Gateway and NetSuite ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Python Connector for BenchmarkEmail
Learn to install and license the CData Python Connector
-
Model MarkLogic Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MarkLogic, enabling the direct import of real-time MarkLogic.
-
Automate Odoo Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Odoo ERP and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build GitHub-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for GitHub to explore live GitHub Data in Cursor to assist with building GitHub-powered applications.
-
How to Query Live xBase Data in Claude Desktop
Connect to and query live xBase Data in Claude Desktop using CData MCP Server.
-
How to Connect to Live Google Sheets 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 Google Sheets for you.
-
Build Visualizations of Teamgate Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Teamgate in Birst.
-
Getting Started with the CData ODBC Driver for Teamwork
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Teamwork.
-
Design BIRT Reports on PabblySubscriptions Data
Provide current PabblySubscriptions to your embedded analytics.
-
Automated Continuous Invoiced Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Invoiced replication to Azure SQL Database.
-
Edit and Search External BigCommerce Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of BigCommerce to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create BigCommerce Data objects that you can access from apps and the dashboard.
-
Create a Data Access Object for Dynamics 365 Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Dynamics 365 in JDBI.
-
Publish Greenplum-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Pivotal GreenPlum.
-
Automated Continuous Quaderno Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Quaderno replication to Google BigQuery.
-
Integrate Live Dynamics 365 Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Dynamics 365 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Dynamics 365.
-
Access Zendesk Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zendesk from HeidiSQL.
-
Access Live CockroachDB 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 CockroachDB through MCP integration.
-
How to create Drip federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Drip in MySQL .
-
Connect to Acumatica Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Acumatica Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to and Query ZohoSubscriptions Data in QlikView over ODBC
Create data visualizations with ZohoSubscriptions in QlikView.
-
How to import Deel Data into Apache Solr
Use the CData Software JDBC Driver for Deel in Data Import Handler and create an automated import of Deel to Apache Solr Enterprise Search platform.
-
Integrate LibreChat with Live SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP Hybris C4C from within the chat interface.
-
Connect to Active Directory Data in RazorSQL
Connect to Active Directory from wizards and query Active Directory from the GUI in the RazorSQL database management tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Square
Create an ODBC connection to Square in Informatica and browse and transfer Square.
-
Integrate Open WebUI with Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Dynamics CRM from within the chat interface.
-
Build AlloyDB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to AlloyDB Data from Zoho Analytics and import live Google AlloyDB.
-
Visualize Productboard Data in Tableau
The CData ODBC driver for Productboard enables you integrate Productboard into Tableau dashboards.
-
How to connect and process ConvertAPI from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ConvertAPI.
-
Use Databricks Agent Bricks to Talk to Your Dropbox Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Dropbox for you.
-
Build AI Agents with SAS xpt 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 SAS XPORT through CData Connect AI.
-
Integrate with Live FreshBooks Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to FreshBooks from the MuleSoft Anypoint Platform to integrate live FreshBooks into custom reports and dashboards.
-
Use the CData Software JDBC Driver for Retently in MicroStrategy Desktop
Connect to Retently in MicroStrategy Desktop using the CData Software JDBC Driver for Retently.
-
Snowflake Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Snowflake through CData Connect AI using different applications and tools.
-
Natively Connect to MailerSend Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MailerSend. Leverage the native support for ODBC in PHP.
-
Automated Continuous SAP SuccessFactors Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to MySQL.
-
Create Reports with Shortcut Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Shortcut.
-
Use the CData Software JDBC Driver for ZohoSubscriptions in MicroStrategy
Connect to ZohoSubscriptions in MicroStrategy Developer using the CData Software JDBC Driver for ZohoSubscriptions.