CData Software - Knowledge Base
Recent Articles
-
Build a Singer.io Tap for Zendesk With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Zendesk data using
-
How to connect Amazon QuickSight to Google Spanner
Create a connection to Google Spanner in CData Connect AI and insert Google Spanner into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Connect to Live BigQuery from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Google BigQuery through natural language.
-
Stream Calendly into Apache Kafka Topics
Access and stream Calendly in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Coinbase as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Coinbase.
-
Query Live Amazon S3 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 Amazon S3 directly from the development environment.
-
How to Use a Microsoft Access Database to Update Paylocity in Real Time
Update Paylocity data by creating a linked table in Microsoft Access with the CData Paylocity ODBC Driver.
-
Publish Aha!-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Aha!.
-
Create SSAS Tabular Models from Sage 200
How to build a SQL Server Analysis Service Tabular Model from Sage 200 using CData drivers.
-
Analyze Odoo in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Odoo ERP and visualize Odoo ERP in SAP Analytics Cloud.
-
Explore Geographical Relationships in HubDB with Power Map
Create data visualizations with HubDB in Power Map.
-
Visualize Bullhorn CRM in Sisense
Create an ElastiCube in Sisense app with access to Bullhorn CRM.
-
How to connect Amazon QuickSight to Impala
Create a connection to Apache Impala in CData Connect AI and insert Apache Impala into Amazon QuickSight SPICE to build interactive dashboards.
-
How to connect SharePoint with Twilio through external lists
Provide Twilio to SharePoint users as an external list.
-
Back Up ActiveCampaign to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for ActiveCampaign. In this article, we will employ an SSIS workflow to populate a database with ActiveCampaign data.
-
Access Live LinkedIn Ads in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to LinkedIn Ads from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Excel in Google Apps Script via SQL Gateway
Use the ODBC Driver for Excel and the SQL Gateway to access Microsoft Excel from Google Apps Script.
-
Integrate SAP HANA XS Advanced in Pentaho Data Integration
Build ETL pipelines based on SAP HANA XS Advanced in the Pentaho Data Integration tool.
-
LINQ to Tally
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Tally Data Provider.
-
How to Connect to Live Stripe from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Stripe through natural language.
-
Connect to Google Data Catalog from Asprova with CData Software ODBC Driver for Google Data Catalog
This article shows how to connect faster to Google Data Catalog data from Asprova.
-
Integrate Theia IDE with Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Replicate Multiple Raisers Edge NXT Accounts
Replicate multiple Raisers Edge NXT accounts to one or many databases.
-
Edit and Search Harvest External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Harvest to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Harvest objects that you can access from apps and the dashboard.
-
Configure the CData JDBC Driver for Adobe Target in a Connection Pool in Tomcat
Connect to Adobe Target from a connection pool in Tomcat.
-
Create Dynamic Microsoft OneDrive Grids Using the Infragistics XamDataGrid
Learn how you can connect Microsoft OneDrive to Infragistics XamDataGrid to build dynamic grids.
-
Use Microsoft Copilot Studio to talk to your Zoho CRM 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 Zoho CRM for you.
-
Connect to Clio from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Clio using standard SQL.
-
Integrate Salesforce Pardot with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Salesforce Pardot with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Salesforce Pardot.
-
Automated Continuous OneNote Replication to AlloyDB
Use CData Sync for automated, continuous, customizable OneNote replication to AlloyDB.
-
How to connect SharePoint with Facebook Ads through external lists
Provide Facebook Ads to SharePoint users as an external list.
-
How to Connect to & Open Amazon Marketplace in Microsoft Excel
This article uses the CData ODBC driver for Amazon Marketplace to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Google Ad Manager in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous JotForm Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable JotForm replication to Microsoft Access.
-
Import CockroachDB Using Azure Data Factory
Use CData Connect AI to connect to CockroachDB from Azure Data Factory and import live CockroachDB.
-
Use the CData Software ODBC Driver for OData in SAS for Real-Time Reporting and Analytics
Connect to real-time OData in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for OData.
-
Integrate Live Marketo into Blue Prism for Intelligent Robotic Process Automation (RPA)
-