CData Software - Knowledge Base
Recent Articles
-
Integrate Google Analytics with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Analytics with External Services.
-
How to Query Live Highrise in Claude Desktop
Connect to and query live Highrise in Claude Desktop using the CData MCP Server.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Airtable within intelligent workflows.
-
How to pipe Couchbase to CSV in PowerShell
Use standard PowerShell cmdlets to access Couchbase tables.
-
Build a PostgreSQL Interface for MariaDB using the CData JDBC Driver
Use the Remoting features of the MariaDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Monday.com Replication to Vertica
Use CData Sync for automated, continuous, customizable Monday.com replication to Vertica.
-
Connect to Email in Jaspersoft Studio
Execute SQL to remote Email in Jaspersoft Studio.
-
Analyze Zoho Projects with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho Projects from Power Pivot. You will use the Table Import Wizard to load Zoho Projects. You can visually build the import query or use any SQL supported by the driver.
-
Publish Crystal Reports on Square
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Square.
-
How to work with OData Services in Apache Spark using SQL
Access and process OData Services in Apache Spark using the CData Software JDBC Driver.
-
Integrate Oracle Sales into Power Automate Desktop using CData Connect
CData Connect for Oracle Sales enables you to integrate Oracle Sales into workflows built using Microsoft Power Automate Desktop.
-
How to Connect the Power BI Service to SAP BusinessObjects BI: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Use the CData Software JDBC Driver for Google Calendar in MicroStrategy Web
Connect to Google Calendar in MicroStrategy Web using the CData Software JDBC Driver for Google Calendar.
-
Query NetSuite through ODBC in Node.js
Use node-odbc to execute SQL queries against NetSuite CRM & ERP from Node.js.
-
Connect to Slack in the Denodo Platform
Use CData driver technologies to create a virtual data source for Slack in the Denodo Virtual DataPort Administrator.
-
Create Reports with Act CRM in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Act CRM.
-
How to Import Data from QuickBooks Online into Google Sheets
Import QuickBooks Online into a Google spreadsheet that is automatically refreshed.
-
Build Automated Presto-Connected Workflows in Zapier
Use CData Connect AI to connect to live Presto and build automated workflows in Zapier.
-
Build Amazon DynamoDB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Amazon DynamoDB and build Amazon DynamoDB-connected web apps with Axios.
-
Create API-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to API from Klipfolio and build custom visualizations using live API.
-
Operational Reporting on Vault CRM from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Veeva Vault & Vault CRM.
-
How to Query Live EventBrite Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Eventbrite data in natural language using Python.
-
Create SSAS Tabular Models from Google Analytics
How to build a SQL Server Analysis Service Tabular Model from Google Analytics using CData drivers.
-
Bidirectional Access to MongoDB from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate MongoDB in Filemaker Pro for Mac or Windows.
-
Analyze QuickBooks Time in Cognos Analytics
Use CData Connect AI to connect to QuickBooks Time from Cognos Analytics and analyze live QuickBooks Time.
-
Access SAP SuccessFactors in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for SAP SuccessFactors.
-
How to import Confluence into Apache Solr
Use the CData Software JDBC Driver for Confluence in Data Import Handler and create an automated import of Atlassian Confluence to Apache Solr Enterprise Search platform.
-
Access Act CRM as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Act CRM from your Oracle system.
-
Build Dashboards with Paylocity in Dundas BI
Create dynamic dashboards and perform analytics based on Paylocity in Dundas BI.
-
PowerShell Scripting to Replicate FHIR to MySQL
Write a simple PowerShell script to replicate FHIR to a MySQL database.
-
Automate ActiveCampaign Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live ActiveCampaign and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Oracle Service Cloud as an External Source in Dremio
Use the CData JDBC Driver to connect to Oracle Service Cloud as an External Source in Dremio.
-
Publish Amazon S3-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Amazon S3.
-
Publish Oracle SCM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Oracle SCM.
-
Build Agents in Relevance AI with Access to Live Sage 200 via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sage 200 within intelligent agent workflows.
-
How to Connect to Live Office 365 in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Microsoft Office 365 for you.
-
Integrate with Acumatica in SnapLogic
Use CData Connect AI to connect to and integrate with live Acumatica ERP in SnapLogic.
-
Bidirectional Access to Twilio from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Twilio in Filemaker Pro for Mac or Windows.
-
Extend Google Sheets with Redis
Make calls to the API Server from Google Apps Script.
-
A Performance Comparison of Drivers for NoSQL
An article comparing the read performance of CData Software Drivers for MongoDB.
-
Use Dash to Build to Web Apps on MongoDB
Create Python applications that use pandas and Dash to build MongoDB-connected web apps.
-
Integrate Live Adobe Commerce into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Adobe Commerce from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Adobe Commerce.
-
Create a Data Access Object for Shopify using JDBI
A brief overview of creating a SQL Object API for Shopify in JDBI.
-
Query Zendesk through ODBC in Node.js
Use node-odbc to execute SQL queries against Zendesk from Node.js.
-
Connect to Databricks in CloverDX (formerly CloverETL)
Transfer Databricks using the visual workflow in the CloverDX data integration tool.
-
Build AI Agents with Zoho Creator Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
How to create Confluence federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Atlassian Confluence in MySQL .
-
How to Easily Query FTP in OpenOffice Base
-