CData Software - Knowledge Base
Recent Articles
-
Build SAP Concur Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP Concur and build visualizations in Tableau.
-
Connect to Azure DevOps from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Azure DevOps, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to and Query Azure DevOps in QlikView over ODBC
Create data visualizations with Azure DevOps in QlikView.
-
Standards-Based Access to NoSQL Data Sources
Create a schema to access MongoDB objects from any CData driver technology.
-
Automated Continuous Airtable Replication to SQLite
Use CData Sync for automated, continuous, customizable Airtable replication to SQLite.
-
Viewing Access in RAD Studio Data Explorer
How to view Microsoft Access in RAD Studio Data Explorer using the CData ODBC Driver for Access.
-
How to Query Redshift in MySQL Workbench
Execute MySQL queries against live Amazon Redshift from MySQL Workbench.
-
How to Work with SurveyMonkey in AWS Glue Jobs Using JDBC
Connect to SurveyMonkey from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to SAP Ariba Procurement in DBArtisan
Use wizards in DBArtisan to configure SAP Ariba Procurement as a data source.
-
Connect to Elasticsearch from Asprova with CData Software ODBC Driver for Elasticsearch
This article shows how to connect faster to Elasticsearch data from Asprova.
-
Connect Authorize.Net to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Authorize.Net with IBM WebSphere for seamless data integration and connectivity.
-
Connect to ShipStation from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ShipStation to connect to ShipStation and execute queries in PowerBuilder.
-
Perform Batch Operations with Microsoft Planner in Apache NiFi
Connect to Microsoft Planner and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Choosing the Best Method to Connect Printify to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Printify from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData Python Connector for JSON
Learn to install and license the CData Python Connector
-
Create Zoom Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Process & Analyze QuickBooks Time in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live QuickBooks Time .
-
Access Smartsheet from MySQL in Amazon QuickSight
Connect to Smartsheet and build visualizations of Smartsheet using a MySQL Connection in Amazon QuickSight.
-
NetSuite Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on NetSuite facts in real time.
-
Analyze HCL Domino in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze HCL Domino in Microsoft R Open.
-
How to integrate Azure Active Directory with Apache Airflow
Access and process Azure Active Directory in Apache Airflow using the CData JDBC Driver.
-
Connect to Pinterest from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pinterest to connect to Pinterest and execute queries in PowerBuilder.
-
Connecting Agentforce with Quickbase 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 Quickbase for you.
-
Connect Zoho Books to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho Books using the CData Python MCP Server.
-
Query, Visualize, and Share live Greenplum in Redash
Use CData Connect AI to connect to live Pivotal GreenPlum in Redash for querying, visualizing, and sharing.
-
A Comparison of JDBC & ODBC Drivers for Amazon Athena
A performance comparison of the CData JDBC Driver and ODBC Driver for Amazon Athena and the Amazon-supported Athena JDBC Driver and ODBC Driver.
-
Build Visualizations of GraphQL in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of GraphQL in Birst.
-
Bind Live Bullhorn CRM Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Bullhorn CRM data
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Exact Online within intelligent workflows.
-
Build a PostgreSQL Interface for Unbounce using the CData JDBC Driver
Use the Remoting features of the Unbounce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze Reckon in Alteryx Designer (ODBC)
Build workflows to access live Reckon for self-service data analytics.
-
Create Datasets from MySQL in Domo Workbench and Build Visualizations of MySQL in Domo
Use the CData Software ODBC Driver for MySQL to create datasets from MySQL in Domo Workbench and then build visualizations in the Domo service.
-
Build Automated Office 365-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Office 365 and build automated workflows in Zapier.
-
Integrate Real-Time Access to Trello in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Trello in real time.
-
Analyze Stripe in Infragistics Reveal
Use the CData API Server to create an OData API on top of Stripe and visualize live Stripe in Infragistics Reveal.
-
Prepare, Blend, and Analyze Google Sheets in Alteryx Designer (Connect AI)
Build workflows to access live Google Sheets for self-service data analytics.
-
Analyze Zuora in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zuora and visualize Zuora in SAP Analytics Cloud.
-
Connect to Zendesk in JRuby
Create a simple JRuby app with access to live Zendesk.
-
Connect to Quickbase as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Quickbase.
-
Connect to Azure Data Catalog in RazorSQL
Connect to Azure Data Catalog from wizards and query Azure Data Catalog from the GUI in the RazorSQL database management tool.
-
Connect to Zoho Creator as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoho Creator.
-
Validate MariaDB with QuerySurge
Access and validate MariaDB in QuerySurge using the CData JDBC Driver.
-
Visualize Live SAS xpt in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAS XPORT.
-
Build Avalara AvaTax-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Avalara AvaTax and create custom apps in Bubble.
-
How to Import Data from Cassandra into Google Sheets
Import Apache Cassandra into a Google spreadsheet that is automatically refreshed.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Paylocity within intelligent workflows.
-
How to Work with QuickBooks Online in ETL Validator JDBC
Connect to QuickBooks Online from ETL Validator jobs using the CData Software JDBC Driver.
-
Use CData Connect AI to Access Gmail in Microsoft Power Pivot
Use CData Connect AI to connect to live Gmail in the Power Pivot business intelligence tool.
-
How to create Greenhouse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Greenhouse in MySQL .
-
How to connect and process Shippo from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Shippo.
-
How to Connect to Live Redshift 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 Amazon Redshift through natural language.
-
Visualize Live Freshdesk in the Power BI Service
Use CData Connect AI to connect to live Freshdesk and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Sage 300 Replication to Vertica
Use CData Sync for automated, continuous, customizable Sage 300 replication to Vertica.
-
Integrating Dataiku with Spark via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Apache Spark SQL.
-
Integrating DB2 in Talend Cloud Data Management Platform
-