CData Software - Knowledge Base
Recent Articles
-
Work with Parquet in FoxPro
Load Apache Parquet into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Twitter Ads in TIBCO Spotfire through OData
Integrate Twitter Ads into dashboards in TIBCO Spotfire.
-
Connecting GenSpark with Smartsheet 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.
-
How to Import Data from Microsoft Dataverse into Google Sheets
Import Microsoft Dataverse (CDS) into a Google spreadsheet that is automatically refreshed.
-
Connect to SAP BusinessObjects BI from a Connection Pool in Jetty
The SAP BusinessObjects BI JDBC Driver supports connection pooling: This article shows how to connect faster to SAP BusinessObjects BI from Web apps in Jetty.
-
Connect to Hive in JRuby
Create a simple JRuby app with access to live Apache Hive.
-
Use the CData Software ODBC Driver for Clio in MicroStrategy
Connect to Clio in MicroStrategy Developer using the CData Software ODBC Driver for Clio.
-
Connect to Azure Synapse in Google Apps Script via Connect AI
Use CData Connect AI to access Azure Synapse in Google Apps Script.
-
Import GitHub into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access GitHub. In this article, you will use the OData format to import GitHub into Microsoft Power Query.
-
Connect to Microsoft Exchange in DBArtisan
Use wizards in DBArtisan to configure Microsoft Exchange as a data source.
-
Access Box 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 Box.
-
Connect to SAP Fieldglass in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP Fieldglass and the SQL Gateway to access SAP Fieldglass from Google Apps Script.
-
Automated Continuous HubSpot Replication to SingleStore
Use CData Sync for automated, continuous, customizable HubSpot replication to SingleStore.
-
Build Dashboards with SAP Ariba Source in DBxtra
Create dynamic dashboards and perform analytics based on SAP Ariba Source in DBxtra.
-
Connect to WooCommerce in DBeaver
Use the CData ODBC Driver to connect to WooCommerce in DBeaver.
-
Connect to Klaviyo from a Connection Pool in Jetty
The Klaviyo JDBC Driver supports connection pooling: This article shows how to connect faster to Klaviyo from Web apps in Jetty.
-
Automated Continuous ADP Replication to SingleStore
Use CData Sync for automated, continuous, customizable ADP replication to SingleStore.
-
Connect to SAP HANA in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP HANA and connect to SAP HANA in Akorbi Digital RunMyProcess.
-
Automated Continuous Oracle Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle Database replication to OneLake in Microsoft Fabric.
-
Connect to Redis from PowerBuilder via ADO.NET
This article demonstrates how to access Redis from Appeon PowerBuilder using the CData ADO.NET Provider for Redis.
-
How to create Act-On federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Act-On in MySQL .
-
Use the CData Software ODBC Driver for Office 365 in MicroStrategy Web
Connect to Microsoft Office 365 in MicroStrategy Web using the CData Software ODBC Driver for Office 365.
-
Connect to IBM Informix as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live IBM Informix.
-
How to Query Live Coinbase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Coinbase data in natural language using Python.
-
Connect to Basecamp in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Query Blackbaud FE NXT from Node.js
Use the OData endpoint of the CData API Server to connect to your Blackbaud FE NXT and perform CRUD operations on Blackbaud FE NXT from Node.js.
-
ETL Box in Oracle Data Integrator
This article shows how to transfer Box into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Bullhorn CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to SingleStore.
-
Extend Google Sheets with Wave Financial
Make calls to the API Server from Google Apps Script.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Connect to Zoho Creator in DBArtisan
Use wizards in DBArtisan to configure Zoho Creator as a data source.
-
Integrate Cline with Live Microsoft Project Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Project from within your IDE.
-
Integrating Dataiku with Azure Synapse via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure Synapse.
-
Replicate JotForm in Heroku for Use in Salesforce Connect
Replicate JotForm to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build FHIR-Powered Applications in Claude Code with CData Code Assist MCP
-