CData Software - Knowledge Base
Recent Articles
-
Connect to Quickbase as an External Source in Dremio
Use the CData JDBC Driver to connect to Quickbase as an External Source in Dremio.
-
Connect to Outreach.io in Jaspersoft Studio
Execute SQL to remote Outreach.io in Jaspersoft Studio.
-
How to integrate HubDB with Apache Airflow
Access and process HubDB in Apache Airflow using the CData JDBC Driver.
-
How to create Google Spanner federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Spanner in MySQL .
-
Connect to Sage Cloud Accounting in NetBeans
Connect to Sage Business Cloud Accounting in NetBeans with the data source configuration wizard.
-
Connect to WordPress in RazorSQL
Connect to WordPress from wizards and query WordPress from the GUI in the RazorSQL database management tool.
-
Integrate with SAP SuccessFactors in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP SuccessFactors in SnapLogic.
-
Build an OLAP Cube in SSAS from Jira Assets
Establish a connection to Jira Assets data from SQL Server Analysis Services, and use the Jira Assets Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Manus AI to Talk to Your HubSpot 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 HubSpot.
-
Visualize EventBrite from Tableau
Use the Tableau Desktop business intelligence tool to connect to Eventbrite.
-
Access Live OneNote in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft OneNote from your Excel spreadsheets.
-
Analyze Google Search Results in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Search and visualize Google Search in SAP Analytics Cloud.
-
Import OneNote into the Power BI Service for Visualizations
Use CData Connect AI to connect to OneNote and provide access to live Microsoft OneNote for custom reports in the Power BI Service.
-
How to Design Spark Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
How to Query Live Salesforce Data Cloud in Perplexity MacOS Desktop
Connect to and query live Salesforce Data Cloud in Perplexity Desktop using CData Code Assist MCP.
-
Access Live SharePoint in Coginiti Pro
Connect to and query live Microsoft SharePoint from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use JayDeBeApi to access ServiceNow in Python
Use standard Python scripting and the development environment of your choice to access live ServiceNow.
-
DataBind Paylocity to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Paylocity with the DevExpress Windows Forms and Web controls to provide Paylocity to a chart.
-
Build Jira-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Atlassian Jira and build web apps with connectivity to live Atlassian Jira.
-
Build Visualizations of Outreach.io in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Outreach.io in Birst.
-
Consume Microsoft Planner OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Planner as OData feeds from PowerBuilder using the API Server.
-
Import ShipStation Using Azure Data Factory
Use CData Connect AI to connect to ShipStation from Azure Data Factory and import live ShipStation.
-
Analyze Bitbucket in R via JDBC
Use standard R functions and the development environment of your choice to analyze Bitbucket with the CData JDBC Driver for Bitbucket.
-
How to Connect the Power BI Service to SAP HANA: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Getting Started with the CData Excel Add-In for Google Directory
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Directory.
-
Connect to Stripe in Google Apps Script via SQL Gateway
Use the ODBC Driver for Stripe and the SQL Gateway to access Stripe from Google Apps Script.
-
How to Visualize Oracle SCM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle SCM in Python.
-
Automated Continuous Microsoft Dataverse Replication to Oracle
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Oracle.
-
Automated Continuous Amazon Marketplace Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to IBM DB2.
-
Query Google Campaign Manager 360 using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Campaign Manager 360 entities in PHP by modeling them as objects.
-
Visualize Live Todoist of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Todoist using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import Azure Analysis Services into the Power BI Service for Visualizations
Use CData Connect AI to connect to Azure Analysis Services and provide access to live Azure Analysis Services for custom reports in the Power BI Service.
-
Build Dashboards with REST in DBxtra
Create dynamic dashboards and perform analytics based on REST in DBxtra.
-
Query IBM Informix from Node.js
Use the OData endpoint of the CData API Server to connect to your IBM Informix and perform CRUD operations on IBM Informix from Node.js.
-
Build a PostgreSQL Interface for HubDB using the CData JDBC Driver
Use the Remoting features of the HubDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Epicor Kinetic Replication to Oracle
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Oracle.
-
Create Monday.com-Connected Business Apps in AppSheet
Connect to Monday.com via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Monday.com.
-
Use the CData Software ODBC Driver for MarkLogic in MicroStrategy
Connect to MarkLogic in MicroStrategy Developer using the CData Software ODBC Driver for MarkLogic.
-
Extend Google Sheets with YouTube Analytics
Make calls to the API Server from Google Apps Script.
-
Using the CData Software ODBC Driver for GitHub in PyCharm
Connect to GitHub as an ODBC data source in PyCharm using the CData Software ODBC Driver for GitHub.
-
Automated Continuous WooCommerce Replication to SingleStore
Use CData Sync for automated, continuous, customizable WooCommerce replication to SingleStore.
-
Build a PostgreSQL Interface for ActiveCampaign using the CData JDBC Driver
Use the Remoting features of the ActiveCampaign JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Exact Online 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 Exact Online for you.
-
Use the CData API Server to Access SAP ByDesign in Microsoft PowerPivot
Use the CData API Server to connect to live SAP Business ByDesign in the Power Pivot business intelligence tool.
-
Publish Reports with Azure Data Lake Storage in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure Data Lake Storage.
-
Build Bing Ads-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Bing Ads from Zoho Analytics and import live Bing Ads.
-
How to import FTP into Apache Solr
Use the CData Software JDBC Driver for FTP in Data Import Handler and create an automated import of FTP Servers to Apache Solr Enterprise Search platform.
-
Getting Started with the CData ADO.NET Provider for Google Directory
-