CData Software - Knowledge Base
Recent Articles
-
Build a Simple VCL Application for Sage 50 UK
How to build a simple VCL Application to view Sage 50 UK in RAD Studio using the CData ODBC Driver for Sage 50 UK.
-
Manage Google Data Catalog in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Data Catalog.
-
Use the CData Software ODBC Driver for Amazon DynamoDB in MicroStrategy Desktop
Connect to Amazon DynamoDB in MicroStrategy Desktop using the CData Software ODBC Driver for Amazon DynamoDB.
-
Connect to SFTP from a Connection Pool in JBoss
Integrate SFTP into Java servlets: Use the Management Console in JBoss to install the SFTP JDBC Driver.
-
Connect to MarkLogic in Aqua Data Studio
Access MarkLogic from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Pinterest 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.
-
How to load Couchbase data into Elasticsearch via Logstash
Introducing a simple method to load Couchbase data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to integrate Clio with Apache Airflow
Access and process Clio in Apache Airflow using the CData JDBC Driver.
-
Connect to Airtable from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Airtable using standard SQL.
-
Access SAP Concur from MySQL in PHP
Connect to SAP Concur through the standard MySQL libraries in PHP.
-
Build Automated Workflows with Live Azure Table in Workato
Use CData Connect AI to connect to live Azure Table Storage and build automated workflows in Workato.
-
Connect to Sybase IQ in RapidMiner
Integrate Sybase IQ with standard components and data source configuration wizards in RapidMiner Studio.
-
Rapidly Develop HubDB-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Query SAP SuccessFactors in DataGrip
Create a Data Source for SAP SuccessFactors in DataGrip and use SQL to query live SAP SuccessFactors.
-
Use the CData Software ODBC Driver for Printful in MicroStrategy Web
Connect to Printful in MicroStrategy Web using the CData Software ODBC Driver for Printful.
-
How to Connect to Live WooCommerce 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 WooCommerce for you.
-
How to Query Live Square in Claude Desktop
Connect to and query live Square in Claude Desktop using the CData MCP Server.
-
How to integrate Oracle Eloqua Reporting with Apache Airflow
Access and process Oracle Eloqua Reporting in Apache Airflow using the CData JDBC Driver.
-
Process & Analyze HubSpot in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live HubSpot .
-
Import Real-Time ClickUp via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ClickUp in ColdFusion.
-
Analyze Zoho Inventory in Looker
Use CData Connect AI to connect to Zoho Inventory from Looker and build custom apps using live Zoho Inventory.
-
Connecting GenSpark with SAP HANA via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Getting Started with the CData SSIS Components for MailChimp
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MailChimp.
-
Create Reports with Twilio in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twilio.
-
Excel Spreadsheet Automation on JotForm with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect to Zoom in JRuby
Create a simple JRuby app with access to live Zoom.
-
Create Data Visualizations Based On WordPress in Mode
Use CData Connect AI to connect to WordPress from Mode and build visualizations using live
-
Connect to ADP in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for ADP in Airbyte.
-
Feed DocuSign into FineReport
How to set DocuSign as a JDBC data source in FineReport.
-
Build Apps with Live Zendesk in Adalo using CData Connect AI
Use CData Connect AI to integrate live Zendesk into the Adalo platform and build custom mobile and web applications with real-time Zendesk.
-
Bidirectional Access to YouTube Analytics from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate YouTube Analytics in Filemaker Pro for Mac or Windows.
-
Automated Continuous JSON Replication to Amazon S3
Use CData Sync for automated, continuous, customizable JSON replication to Amazon S3.
-
Build DocuSign Visualizations in Tableau Desktop
Use CData Connect AI to connect to live DocuSign and build visualizations in Tableau.
-
DataBind Controls to MariaDB in Delphi
DataBind to MariaDB in Delphi with standard data access components and controls.
-
Excel Spreadsheet Automation on YouTube Analytics with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Access Odoo from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Odoo ERP from HeidiSQL.
-
Write a Simple Go Application to work with Google Calendar on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Calendar.
-
Create Power BI Reports on Real-Time Salesforce Data Cloud
Use the CData ODBC Driver for Salesforce Data Cloud to visualize Salesforce Data Cloud in Power BI Desktop.
-
How to Connect to Live NetSuite 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 NetSuite CRM & ERP for you.
-
Explore Geographical Relationships in Odoo with Power Map
Create data visualizations with Odoo ERP in Power Map.
-
How to Query Live SharePoint Excel Services in Perplexity MacOS Desktop
Connect to and query live SharePoint Excel Services in Perplexity Desktop using the CData MCP Server.
-
How to Connect to Live Google Contacts Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Contacts securely in real time.
-
Import Google Spanner Using Azure Data Factory
Use CData Connect AI to connect to Google Spanner from Azure Data Factory and import live Google Spanner.
-
Create Hive-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Hive from OutSystems and build custom enterprise apps using live Apache Hive.
-
View Reports on Real-Time HubDB in Power BI Report Server
Use the CData ODBC Driver for HubDB to visualize HubDB in Power BI Desktop and then publish them to Power BI Report Server.
-
Create a Data Access Object for Wave Financial using JDBI
A brief overview of creating a SQL Object API for Wave Financial in JDBI.
-
Build Visualizations of Workday in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Workday in Birst.
-
How to Import Data from Couchbase into Google Sheets
Import Couchbase into a Google spreadsheet that is automatically refreshed.
-
Publish Crystal Reports on Tableau CRM Analytics
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Tableau CRM Analytics.
-
How to update Box from Excel
This article explains how to transfer data from Excel to Box using the Excel Add-In for Box.
-
How to update Zoho Inventory from Excel
This article explains how to transfer data from Excel to Zoho Inventory using the Excel Add-In for Zoho Inventory.
-
Create Power BI Reports on Real-Time Monday.com
Use the CData ODBC Driver for Monday.com to visualize Monday.com in Power BI Desktop.
-
How to Connect to Live Zuora in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Zuora without replication.
-
Automate Sage Intacct Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Sage Intacct and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use Biml to Build SSIS Tasks to Replicate Zoho Books to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Books to SQL Server.
-
How to connect to JDBC-ODBC Bridge with Squirrel SQL client
Connect to JDBC-ODBC Bridge and execute queries in the Squirrel SQL Client.
-
Add Smartsheet to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Smartsheet with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Cosmos DB in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Azure Cosmos DB in Airbyte.
-
How to connect to Greenhouse from IntelliJ
Integrate connectivity to Greenhouse with wizards in IntelliJ.
-
Build Adobe Target-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Adobe Target and build web apps with connectivity to live Adobe Target.
-
Replicate Snowflake from PowerShell
Write a quick PowerShell script to query Snowflake. Use connectivity to the live data to replicate Snowflake to SQL Server.
-
Build Google Drive Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Drive and build visualizations in Tableau.
-
Connect to Microsoft Exchange in HULFT Integrate
Connect to Microsoft Exchange as a JDBC data source in HULFT Integrate
-
Build Data Flows from SQL Server to Salesforce Marketing through SSIS
Easily push SQL Server data to Salesforce Marketing using the CData SSIS Tasks for Salesforce Marketing.
-
Import Salesforce Using Azure Data Factory
Use CData Connect AI to connect to Salesforce from Azure Data Factory and import live Salesforce & Force.com.
-
Automated Continuous Salesloft Replication to MongoDB
Use CData Sync for automated, continuous, customizable Salesloft replication to MongoDB.
-
Replicate Multiple Dynamics NAV Accounts via the CData Sync CLI
Replicate multiple Dynamics NAV accounts to one or many databases.
-
Build an OLAP Cube in SSAS from Azure Data Catalog
Establish a connection to Azure Data Catalog data from SQL Server Analysis Services, and use the Azure Data Catalog Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build a PostgreSQL Interface for JDBC-ODBC Bridge using the CData JDBC Driver
Use the Remoting features of the JDBC-ODBC Bridge JDBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the Zoho Books JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zoho Books.
-
How to Work with Zoom in ETL Validator JDBC
Connect to Zoom from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Dynamics CRM Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Microsoft Access.
-
Connect to Slack through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Slack using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Easily Query SAS Data Sets in OpenOffice Base
-