CData Software - Knowledge Base
Recent Articles
-
Integrate Theia IDE with Live Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Outreach.io data from within the development environment.
-
Analyze ZohoDesk Data in Cognos Analytics
Use CData Connect AI to connect to ZohoDesk Data from Cognos Analytics and analyze live ZohoDesk data.
-
Query, Visualize, and Share live SAP Business Warehouse Data in Redash
Use CData Connect AI to connect to live SAP Business Warehouse data in Redash for querying, visualizing, and sharing.
-
Integrating LangGraph with PingOne Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on PingOne data within automated workflows.
-
Analyze BambooHR Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze BambooHR data in Microsoft R Open.
-
Use Dash to Build to Web Apps on Dynamics 365 Business Central Data
Create Python applications that use pandas and Dash to build Dynamics 365 Business Central-connected web apps.
-
Create Power BI Reports on Real-Time MYOB AccountRight Data
Use the CData ODBC Driver for MYOB AccountRight to visualize MYOB AccountRight data in Power BI Desktop.
-
Integrating Claude Code CLI with Testmonitor Data 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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SuiteCRM
Provide connectivity to SuiteCRM data through an SAP BusinessObjects universe.
-
Connecting Agentforce with Zuora 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 Zuora data for you.
-
Visualize Greenhouse Data in Tableau
The CData ODBC driver for Greenhouse enables you integrate Greenhouse data into Tableau dashboards.
-
Rapidly Develop Billsby-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Billsby.
-
Automated Continuous Azure Data Catalog Replication to SQL Server
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to SQL Server.
-
Integrating LangChain with TaxJar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on TaxJar data within automated workflows.
-
Moving Data from PostgreSQL to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live PostgreSQL data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connecting Moonlit Workflow with Shortcut Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Shortcut data in real time.
-
Connect to SAP HANA XS Advanced Data from PowerBuilder via JDBC
This article demonstrates how to access SAP HANA XS Advanced data from PowerBuilder using the SAP HANA XS Advanced JDBC Driver.
-
Connect to SAS xpt Data in DBArtisan
Use wizards in DBArtisan to configure SAS xpt data as a data source.
-
Getting Started with the CData JDBC Driver for Dropbox
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dropbox.
-
Build Zoho CRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Zoho CRM data and build web apps with connectivity to live Zoho CRM data.
-
Connect to HelloSign Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time HelloSign data using standard SQL.
-
Build Jumpseller Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Jumpseller data and build visualizations in Tableau.
-
Getting Started with the CData Tableau Connector for ZohoPeople
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to DB2 Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time DB2 data using standard SQL.
-
Integrating Boomi Agentstudio with Greenplum Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Greenplum data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Natively Connect to OneNote Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to OneNote data. Leverage the native support for ODBC in PHP.
-
Seamlessly Bring FHIR Data into Retool Using CData Connect AI
Integrate FHIR data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build a Singer.io Tap for Microsoft Teams With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Microsoft Teams data using the CData Python Connector.
-
Use the CData Software JDBC Driver for OpenWeatherMap in MicroStrategy Desktop
Connect to OpenWeatherMap data in MicroStrategy Desktop using the CData Software JDBC Driver for OpenWeatherMap.
-
How to work with SendPulse Data in Apache Spark using SQL
Access and process SendPulse Data in Apache Spark using the CData Software JDBC Driver.
-
Create Zoho Inventory-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho Inventory Data from Nintex Workflow Cloud and build custom workflows using live Zoho Inventory data.
-
Viewing Notion Data in RAD Studio Data Explorer
How to view Notion data in RAD Studio Data Explorer using the CData ODBC Driver for Notion.
-
How to Easily Query Bugsnag Data in OpenOffice Base
Connect to Bugsnag data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect the Power BI Service to Strava: Complete Guide
Connect to the CData Software Power BI Connector for Strava from PowerBI.com to provide real-time Strava data across the organization.
-
Connect to Salesloft Data in ACL Analytics
Connect to Salesloft data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Salesloft data.
-
Analyze JSON Services in Looker
Use CData Connect AI to connect to JSON Services from Looker and build custom apps using live JSON services.
-
Build Apollo-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Apollo Data from Zoho Analytics and import live Apollo data.
-
Replicate Greenhouse Data from PowerShell
Write a quick PowerShell script to query Greenhouse data. Use connectivity to the live data to replicate Greenhouse data to SQL Server.
-
Connect to Microsoft Ads Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft Ads Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use CData Connect AI to Access Mode Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Mode data in the Power Pivot business intelligence tool.
-
Import and Visualize Outreach.io Data in Power View
Create data visualizations based on Outreach.io data in Excel.
-
Connect Clari Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Clari data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Amazon Athena-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Amazon Athena Data from Zoho Analytics and import live Amazon Athena data.
-
How to work with AdRoll Data in Apache Spark using SQL
Access and process AdRoll Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to & Open HubDB Data in Microsoft Excel
This article uses the CData ODBC driver for HubDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query Everhour Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Everhour data from Node.js.
-
A PostgreSQL Interface for CircleCI Data (MySQL Remoting via JDBC)
Use the Remoting features of the CircleCI JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Databricks in MicroStrategy Web
Connect to Databricks data in MicroStrategy Web using the CData Software JDBC Driver for Databricks.
-
Connect to SAP Hybris C4C Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Hybris C4C to connect to SAP Hybris C4C data and execute queries in PowerBuilder.
-
Connect to and Query MariaDB Data in QlikView over ODBC
Create data visualizations with MariaDB data in QlikView.
-
Connect to Gmail Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Gmail Data and connect to Gmail data in Akorbi Digital RunMyProcess.
-
Build a PostgreSQL Interface for Pipedrive Data using the CData JDBC Driver
Use the Remoting features of the Pipedrive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use CData Connect AI to Access JSON Services in Microsoft Power Pivot
Use CData Connect AI to connect to live JSON services in the Power Pivot business intelligence tool.
-
How to Connect to Live MYOB AccountRight 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 MYOB AccountRight data through natural language.
-
LINQ to ConstantContact Data
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 ConstantContact Data Provider.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Mixpanel
Provide connectivity to Mixpanel data through an SAP BusinessObjects universe.
-
Integrating Gumloop with Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Salesforce Marketing data within automated workflows.
-
Create Data Visualizations in Cognos BI with Datadog Data
Access Datadog data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Using the CData Software ODBC Driver for Azure Synapse in PyCharm
Connect to Azure Synapse as an ODBC data source in PyCharm using the CData Software ODBC Driver for Azure Synapse.
-
Analyze QuickBooks Time Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze QuickBooks Time data with the CData JDBC Driver for QuickBooks Time.
-
Connect to Live Sendwithus Data in MicroStrategy through CData Connect AI
Create a live connection to Sendwithus Data in CData Connect AI and connect to your Sendwithus data from MicroStrategy.
-
Getting Started with the CData SSIS Components for Blackbaud FE NXT
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Blackbaud FE NXT.
-
How to integrate Metabase with Guru Data
Use CData Connect AI to connect to live Guru data and create an interactive dashboard in Metabase from Guru data.
-
Query Live ADP Data 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 ADP data directly from the development environment.
-
Automated Continuous Amazon Marketplace Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Amazon S3.
-
Connect to Typeform in SpagoBI
Create reports featuring live Typeform data in SpagoBI Studio. Host Typeform reports on SpagoBI Server.
-
Import Real-Time Tickspot Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Tickspot data in ColdFusion.
-
DataBind Controls to Marketo Data in Delphi
DataBind to Marketo data in Delphi with standard data access components and controls.
-
Connect to Vimeo Data in RapidMiner
Integrate Vimeo data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect DBeaver to Oracle Sales via a JDBC Driver
Manage Oracle Sales data with visual tools in DBeaver like the query browser.
-
Connect to Avalara AvaTax Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Avalara AvaTax data.
-
Use Claude to Talk to Your Samanage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Samanage data for you.
-
Connect to Office 365 Data in Claris FileMaker Pro
Use the CData ODBC Driver for Office 365 in FileMaker Pro to connect to Office 365 and work with Office 365 data in your FileMaker applications.
-
Replicate Multiple Calendly Accounts via the CData Sync CLI
Replicate multiple Calendly accounts to one or many databases.
-
Integrating Wrike Data in Talend Cloud Data Management Platform
Connect Wrike Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Prepare, Blend, and Analyze SAP Ariba Procurement Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Ariba Procurement data for self-service data analytics.
-
Replicate Aweber Data in Heroku for Use in Salesforce Connect
Replicate Aweber data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to and Visualize Live Google Ad Manager Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Ad Manager data.
-
How to Connect DBeaver to Paylocity via a JDBC Driver
Manage Paylocity data with visual tools in DBeaver like the query browser.
-
Connect to LinkedIn Ads Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for LinkedIn Ads Data and connect to LinkedIn Ads data in Akorbi Digital RunMyProcess.
-
Connect to Adobe Analytics Data in Jaspersoft Studio
Execute SQL to remote Adobe Analytics data in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for Sage Cloud Accounting in MicroStrategy
Connect to Sage Cloud Accounting data in MicroStrategy Developer using the CData Software ODBC Driver for Sage Cloud Accounting.
-
Access SharePoint Data from MySQL in Amazon QuickSight
Connect to SharePoint and build visualizations of SharePoint data using a MySQL Connection in Amazon QuickSight.
-
How to publish and share PayPal Data dashboards with Tableau Server
The CData ODBC driver for PayPal enables you integrate PayPal data into Tableau dashboards.
-
Build Data Flows from HubDB to SQL Server using SSIS
Easily back up HubDB data to SQL Server using the SSIS components for HubDB.
-
Use the CData Software JDBC Driver for Kafka in MicroStrategy
Connect to Kafka data in MicroStrategy Developer using the CData Software JDBC Driver for Kafka.
-
Integrating Antigravity CLI with VWO data via CData CLI
Connect VWO data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use JayDeBeApi to access Google Forms Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Forms data.
-
Getting Started with the CData Power BI Connector for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to FreeAgent Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for FreeAgent data.
-
Build MVC Applications with Connectivity to Odoo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Odoo from an ASP.NET MVC application.
-
Access Hive Data from MySQL in Amazon QuickSight
Connect to Hive and build visualizations of Hive data using a MySQL Connection in Amazon QuickSight.
-
Easily Integrate Greenplum Data in Lazarus Pascal IDE
Learn how to easily integrate live Greenplum data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software JDBC Driver for ChartMogul in MicroStrategy
Connect to ChartMogul data in MicroStrategy Developer using the CData Software JDBC Driver for ChartMogul.
-
Automated Continuous Webex Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Webex replication to Apache Cassandra.
-
Automated Mailjet Data Replication to Teradata
Use CData Sync to Customize and automate Mailjet data replication to Teradata.
-
Migrating data from Square to Snowflake using CData SSIS Components.
Easily push Square data to Snowflake using the CData SSIS Tasks for Square and Snowflake.
-
Build a PostgreSQL Interface for Parallel Data using the CData JDBC Driver
Use the Remoting features of the Parallel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Productboard Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Productboard data in the Denodo Virtual DataPort Administrator.
-
How to Connect to Live SAS Data Sets 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 SAS Data Sets data through natural language.