CData Software - Knowledge Base
Recent Articles
-
Connect to BambooHR Data from PowerBuilder via JDBC
This article demonstrates how to access BambooHR from PowerBuilder using the BambooHR JDBC Driver.
-
Create Data Visualizations Based On Lakebase Data in Mode
Use CData Connect AI to connect to Lakebase Data from Mode and build visualizations using live
-
Query Oracle Sales Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Oracle Sales and perform CRUD operations on Oracle Sales from Node.js.
-
Connect to Cohere Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Cohere using standard SQL.
-
Access Todoist Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Todoist from your Oracle system.
-
A Performance Comparison of Drivers for MongoDB
An article comparing the read performance of CData Software Drivers for MongoDB.
-
Connect to MongoDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from MongoDB, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connecting Agentforce with Confluence Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Atlassian Confluence for you.
-
How to Connect to Live Microsoft Dataverse Data 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 Microsoft Dataverse (CDS) through natural language.
-
Build Agents in Relevance AI with Access to Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Xero Accounting within intelligent agent workflows.
-
Integrate Intercom Data in the Pentaho Report Designer
Publish reports based on Intercom in the Pentaho BI tool.
-
Build Semantic Layer Views for HCL Domino Data in APOS Live Data Gateway
Use the CData Connector for HCL Domino in APOS Live Data Gateway to build Semantic Layer Views for HCL Domino.
-
Connect to Exa Data in DBeaver
Use the CData ODBC Driver to connect to Exa in DBeaver.
-
Build Dashboards with Dynamics CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Dynamics CRM in DBxtra.
-
Integrate Live Google Analytics Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Analytics from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Analytics.
-
Build Tavily-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Tavily Data in Cursor to assist with building Tavily-powered applications.
-
Connect to Procore Data from a Connection Pool in JBoss
Integrate Procore into Java servlets: Use the Management Console in JBoss to install the Procore JDBC Driver.
-
Replicate Azure Blob Storage Data in Heroku for Use in Salesforce Connect
Replicate Azure Blob Storage to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Sugar CRM Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sugar CRM and integrate live Sugar CRM into your Power Automate tasks.
-
Use the CData ODBC Driver for Vault CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Vault CRM to connect to Veeva Vault & Vault CRM from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Veeva Vault & Vault CRM in Excel.
-
Build Avalara AvaTax-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Avalara to explore live Avalara AvaTax Data in Cursor to assist with building Avalara AvaTax-powered applications.
-
How to Connect to Contentful Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Contentful. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData Tableau Connector for Outreach.io
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Outreach.io.
-
Process & Analyze Delighted Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Delighted Data.
-
Import Guru Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Guru. In this article, you will use the OData format to import Guru into Microsoft Power Query.
-
Building Dynamic Web Pages with Mistral AI Data Using AngularJS
Create single-page applications with live connectivity to Mistral AI using the CData API Server.
-
Getting Started with the CData ODBC Driver for Elorus
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Elorus.
-
Create Data Visualizations in Cognos BI with Workday Data
Access Workday as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData Excel Add-In for Databricks
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Databricks.
-
Integrate with Shopify Data in JReport Designer
Create charts and reports based on Shopify in JReport Designer.
-
Integrating Zoho Creator Data in Talend Cloud Data Management Platform
Connect Zoho Creator Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Zoho Creator.
-
Getting Started with the CData Python Connector for FormSite
Learn to install and license the CData Python Connector
-
Integrate Invoiced with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Invoiced with External Services.
-
Use Manus AI to Talk to Your Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Databricks.
-
Viewing Asana Data in RAD Studio Data Explorer
How to view Asana in RAD Studio Data Explorer using the CData ODBC Driver for Asana.
-
Bind Live Amazon Athena Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Amazon Athena data
-
How to Connect to Foursquare Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Foursquare. Leverage the pyodbc module for ODBC in Python.
-
DataBind Charts to Excel Online Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Excel Online from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Visualize Contentful Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Contentful.
-
Integrate Intercom with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Intercom with External Services.
-
Connect to Google Ads Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Ads using standard SQL.
-
Connect to XML Data in Jaspersoft Studio
Execute SQL to remote XML Files in Jaspersoft Studio.
-
Natively Connect to Salesforce CRM Analytics Data in PHP
The CData ODBC driver for Salesforce CRM Analytics enables you to create PHP applications with connectivity to Salesforce CRM Analytics. Leverage the native support for ODBC in PHP.
-
Automated Continuous Adobe Commerce Replication to Oracle
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Oracle.
-
How to Visualize SAP Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP ERP/NetWeaver in Python.
-
How to connect SharePoint with Paylocity Data through external lists
Provide Paylocity to SharePoint users as an external list.
-
Automate Moosend Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Moosend from PowerShell? This article demonstrates how to utilize the Moosend Cmdlets for tasks like connecting to Moosend, automating operations, downloading data, and more.
-
How to use SQLAlchemy ORM to access Zoho Books Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoho Books.
-
How to load Mocean data into Elasticsearch via Logstash
Introducing a simple method to load Mocean data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData Tableau Connector for ZohoMarketingHub
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Model, Search, and Visualize Live Microsoft Exchange Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Exchange for modeling, searching, and visualizing.
-
Access Live Kintone Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Kintone from your Google Sheets.
-
Use the CData ODBC Driver for Salesforce Pardot in Microsoft Power Query
You can use the CData Salesforce Pardot ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Salesforce Pardot into Microsoft Power Query.
-
Access Live QuickBooks Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrate with Live BambooHR Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to BambooHR from the MuleSoft Anypoint Platform to integrate live BambooHR into custom reports and dashboards.
-
Connect to WordPress Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for WordPress and the SQL Gateway to access WordPress from Google Apps Script.
-
Stream LeadDesk Data into Apache Kafka Topics
Access and stream LeadDesk in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
ActiveCampaign Reporting in OBIEE with the ActiveCampaign JDBC Driver
Deploy the ActiveCampaign JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Choosing the Best Method to Connect Sage Intacct to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sage Intacct from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Crystal Reports on AdRoll Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date AdRoll.
-
Connect to Oracle Financials Cloud Data in HULFT Integrate
Connect to Oracle Financials Cloud as a JDBC data source in HULFT Integrate
-
Automated Continuous Copper Replication to SQL Server
Use CData Sync for automated, continuous, customizable Copper replication to SQL Server.
-
Access Live Microsoft OneDrive Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft OneDrive from your Excel spreadsheets.
-
Build a PostgreSQL Interface for Figshare Data using the CData JDBC Driver
Use the Remoting features of the Figshare JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live SAP Fieldglass 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 SAP Fieldglass for you.
-
Getting Started with the CData ODBC Driver for Google Contacts
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Contacts.
-
Visualize SAS Data Sets Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAS Data Sets.
-
Connect to FormSite Data from PowerBuilder via ADO.NET
This article demonstrates how to access FormSite from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Oracle actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CloudConvert
Provide connectivity to CloudConvert through an SAP BusinessObjects universe.
-
Connect to SharePoint Excel Services Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SharePoint Excel Services using standard SQL.
-
Access Impala Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Apache Impala from HeidiSQL.
-
Create Jira Assets-Connected Applications in Appsmith
Connect to Jira Assets Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Jira Assets.
-
Connect to Jumpseller in SpagoBI
Create reports featuring live Jumpseller in SpagoBI Studio. Host Jumpseller reports on SpagoBI Server.
-
Automated Continuous Campaigner Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Campaigner replication to Google BigQuery.
-
Strava Reporting in OBIEE with the Strava JDBC Driver
Deploy the Strava JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating GitHub Copilot CLI with Google Ads 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.
-
Automated Continuous Moosend Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Moosend replication to Amazon S3.
-
Create Informatica Mappings From/To an ODBC Data Source for WordPress
Create an ODBC connection to WordPress in Informatica and browse and transfer WordPress.
-
Use the CData ODBC Driver for SAP Concur in Microsoft Power Query
You can use the CData SAP Concur ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Concur into Microsoft Power Query.
-
Bridge Google Sheets Connectivity with Apache NiFi
Access and process Google Sheets in Apache NiFi using the CData JDBC Driver.
-
Access Live Pipeliner CRM Data in AWS Lambda
Connect to live Pipeliner CRM in AWS Lambda using the CData JDBC Driver.
-
Build Google Contacts-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Contacts Data and create custom apps in Mendix.
-
Use the CData Software ODBC Driver for Marketo in MicroStrategy Desktop
Connect to Marketo in MicroStrategy Desktop using the CData Software ODBC Driver for Marketo.
-
Connect to Mode Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Mode and the SQL Gateway to access Mode from Google Apps Script.
-
How to Access Live Google Directory Data in Visual Studio Code via Cline
Run CData MCP Server for Google Directory on Windows Subsytem for Linux (WSL) and connect to live Google Directory from the Cline extension in Visual Studio Code.
-
Connect to Retently Data in RapidMiner
Integrate Retently with standard components and data source configuration wizards in RapidMiner Studio.
-
Provide OData Services of NetSuite Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for NetSuite CRM & ERP by developing a WCF Service Application.
-
Back Up Bitly to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Bitly data.
-
Connect to Google Tasks Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Tasks from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Query Live Cosmos DB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure Cosmos DB data in natural language using Python.
-
Build a Simple VCL Application for Sybase IQ Data
How to build a simple VCL Application to view Sybase IQ in RAD Studio using the CData ODBC Driver for Sybase IQ.
-
How to Query Zoho CRM Data in MySQL Workbench
Execute MySQL queries against live Zoho CRM from MySQL Workbench.
-
Visualize Facebook Data in Sisense
Create an ElastiCube in Sisense app with access to Facebook.
-
Automated Continuous LionDesk Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LionDesk replication to OneLake in Microsoft Fabric.
-
Add SAP ByDesign Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP ByDesign with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Seamlessly Import Parquet Data into IBM SPSS Modeler
Integrate Parquet data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to Apollo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apollo. Leverage the pyodbc module for ODBC in Python.
-
Natively Connect to Sage Intacct Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sage Intacct. Leverage the native support for ODBC in PHP.
-
Build Apps with Live Microsoft Exchange Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Exchange with Mendix to build apps using the CData JDBC Driver for Exchange.