CData Software - Knowledge Base
Recent Articles
-
Build Apps with Live Strava Data Using the Low-Code Development Platform of Mendix
Connect Strava data with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize HCL Domino Data in Tableau
The CData ODBC driver for HCL Domino enables you integrate HCL Domino data into Tableau dashboards.
-
Integrate SAP HANA Data in the Pentaho Report Designer
Publish reports based on SAP HANA data in the Pentaho BI tool.
-
Analyze Toggl Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Toggl data with the CData JDBC Driver for Toggl.
-
Use Biml to Build SSIS Tasks to Replicate QuickBooks Time Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate QuickBooks Time data to SQL Server.
-
Query MYOB AccountRight Data in DataGrip
Create a Data Source for MYOB AccountRight in DataGrip and use SQL to query live MYOB AccountRight data.
-
How to Access Live Microsoft Dataverse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Microsoft Dataverse enables you to integrate Microsoft Dataverse data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Dropbox Data in the Pentaho Report Designer
Publish reports based on Dropbox data in the Pentaho BI tool.
-
Connect to and Visualize Live Pinterest Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pinterest data.
-
Build Charts with Wistia Data in Clear Analytics
Create dynamic charts and perform analytics based on Wistia data in Clear Analytics.
-
Build Trello Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Trello data and build visualizations in Tableau.
-
Connect GetResponse to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect GetResponse with IBM WebSphere for seamless data integration and connectivity.
-
Create a Data Access Object for Gumroad Data using JDBI
A brief overview of creating a SQL Object API for Gumroad data in JDBI.
-
Create Reports from Notion Data in Looker Studio
Use CData Connect AI to gain access to live Notion data and create custom reports in Looker Studio.
-
Replicate BenchmarkEmail Data in Heroku for Use in Salesforce Connect
Replicate BenchmarkEmail data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous ChartMogul Replication to SQLite
Use CData Sync for automated, continuous, customizable ChartMogul replication to SQLite.
-
Query Mistral AI Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Mistral AI data from Node.js.
-
Integrate Open WebUI with Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Confluence data from within the chat interface.
-
Integrate Live Redshift Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Redshift data to Blue Prism using the CData ODBC Driver for Redshift to create automated workflows for repetitive business tasks.
-
Integrating Antigravity CLI with SAP SuccessFactors LMS data via CData CLI
Connect SAP SuccessFactors LMS data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use ChatGPT to Talk to Your Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Campaign Manager 360 data for you.
-
Connecting Moonlit Workflow with SAP Business One 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 SAP Business One data in real time.
-
Build an OLAP Cube in SSAS from Qualaroo Data
Establish a connection to Qualaroo data data from SQL Server Analysis Services, and use the Qualaroo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Facebook Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Facebook replication to Google Cloud SQL.
-
How to Visualize Datadog Data in Python with pandas
Use pandas and other modules to analyze and visualize live Datadog data in Python.
-
Integrate LibreChat with Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Xero data from within the chat interface.
-
Choosing the Best Method to Connect Sybase IQ to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sybase IQ data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Devin with Live Splunk Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Splunk data.
-
Build AI/ML Models with Live Auth0 Data using Dataiku
Connect Auth0 Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Samanage Replication to Snowflake
Use CData Sync for automated, continuous, customizable Samanage replication to Snowflake.
-
Choosing the Best Method to Connect Helpscout to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Helpscout data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate SurveyMonkey Data into Power Automate Desktop using CData Connect
CData Connect for SurveyMonkey Data enables you to integrate SurveyMonkey data into workflows built using Microsoft Power Automate Desktop.
-
Import and Visualize QuickBooks Data in Power View
Create data visualizations based on QuickBooks data in Excel.
-
How to Easily Query Freshservice Data in OpenOffice Base
Connect to Freshservice data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Manage Active Directory Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Active Directory.
-
Create Avalara AvaTax-Connected Applications in Appsmith
Connect to Avalara AvaTax Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Avalara AvaTax data.
-
Connect to Marketo Data in NetBeans
Connect to Marketo data in NetBeans with the data source configuration wizard.
-
Getting Started with the CData ADO.NET Provider for Tickspot
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
DataBind Charts to Azure Analysis Services Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Azure Analysis Services data 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.
-
Automated ServiceNow Data Replication to Teradata
Use CData Sync to Customize and automate ServiceNow data replication to Teradata.
-
Connect to Snowflake Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Snowflake data from Filemaker Pro on Mac.
-
Analyze Freshdesk Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Freshdesk from Power Pivot. You will use the Table Import Wizard to load Freshdesk data. You can visually build the import query or use any SQL supported by the driver.
-
Build a PostgreSQL Interface for Azure Data Lake Storage Data using the CData JDBC Driver
Use the Remoting features of the Azure Data Lake Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Apps with Live Microsoft Entra ID Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Entra ID data with Mendix to build apps using the CData JDBC Driver for Microsoft Entra ID.
-
Analyze Stripe Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Stripe from Power Pivot. You will use the Table Import Wizard to load Stripe data. You can visually build the import query or use any SQL supported by the driver.
-
A PostgreSQL Interface for Everhour Data using the CData ODBC Driver
Use the SQL Gateway and Everhour ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Microsoft Teams Data from PowerShell
Write a quick PowerShell script to query Microsoft Teams data. Use connectivity to the live data to replicate Microsoft Teams data to SQL Server.
-
Back Up Teradata data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Teradata. In this article, we will employ an SSIS workflow to populate a database with Teradata data data.
-
Easily Integrate NASA Data in Lazarus Pascal IDE
Learn how to easily integrate live NASA data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Apps from YouTube Analytics Data in Qlik Sense Cloud
Use CData Connect AI to connect to YouTube Analytics Data and build apps from live YouTube Analytics data in Qlik Sense Cloud.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Redis
Provide connectivity to Redis data through an SAP BusinessObjects universe.
-
Integrate Live DB2 Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live DB2 data from within the IDE.
-
Automated Continuous Contentful Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Contentful replication to delimited files (CSV/TSV).
-
Build ZohoMarketingHub-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for ZohoMarketingHub Data and create custom apps in Mendix.
-
Visualize SAP Business Warehouse Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Business Warehouse data.
-
Integrate Theia IDE with Live Dynamics 365 Business Central 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 Dynamics 365 Business Central data from within the development environment.
-
Explore Geographical Relationships in Discord Data with Power Map
Create data visualizations with Discord data in Power Map.
-
Process & Analyze Recurly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Recurly Data.
-
How to Query Live HelloSign Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live HelloSign data data in natural language using Python.
-
Use the CData Software ODBC Driver for Postmark in MicroStrategy Web
Connect to Postmark data in MicroStrategy Web using the CData Software ODBC Driver for Postmark.
-
Build Agents in Relevance AI with Access to Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ADP data within intelligent agent workflows.
-
How to Access Live Notion Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Notion enables you to integrate Notion data into workflows built using Microsoft Power Automate Desktop.
-
Create Reports from Omnisend Data in Looker Studio
Use CData Connect AI to gain access to live Omnisend data and create custom reports in Looker Studio.
-
Use the CData ODBC Driver for ElevenLabs from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ElevenLabs to connect to ElevenLabs data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ElevenLabs data in Excel.
-
Getting Started with the CData Tableau Connector for SAP HANA
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP HANA.
-
Connect to RSS Feeds through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with RSS Feeds using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Excel Online Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Excel Online data from your Oracle system.
-
Analyze Toggl Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Toggl data and visualize Toggl data in SAP Analytics Cloud.
-
Getting Started with the CData Connect AI Python SDK for Google Contacts
Install the CData Connect AI Python SDK to read and write live Google Contacts data with standard DB-API 2.0 Python code.
-
Access SharePoint Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SharePoint data from HeidiSQL.
-
How to Connect to Zoho Projects Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoho Projects data. Leverage the pyodbc module for ODBC in Python.
-
Building Dynamic D3.js Apps with Database Data
Use the API Server and D3.js to Build Dynamic Web Apps with Live Database Data.
-
Connect to Microsoft Planner Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Planner and the Script function in FileMaker Pro to connect to Microsoft Planner and work with Microsoft Planner data in your FileMaker application.
-
Connect to Oracle Financials Cloud Data from AWS Glue
Use CData Connect AI to gain access to live Oracle Financials Cloud data from your AWS Glue jobs.
-
Establish a Live Connection with Bright Data Data using Tableau Bridge
The CData ODBC Driver for Bright Data enables you to integrate live Bright Data data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize SharePoint Data in Sisense
Create an ElastiCube in Sisense app with access to SharePoint data.
-
Build a PostgreSQL Interface for Certinia Data using the CData JDBC Driver
Use the Remoting features of the Certinia JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to create an RPA flow for Jira Assets Data in UiPath Studio
Use the Jira Assets ODBC Driver to create workflows that access real-time Jira Assets data without any coding.
-
How to Work with Mouseflow Data in ETL Validator JDBC
Connect to Mouseflow from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Box Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Box data in the Denodo Virtual DataPort Administrator.
-
Access Dynamics 365 Business Central Data from MySQL in Amazon QuickSight
Connect to Dynamics 365 Business Central and build visualizations of Dynamics 365 Business Central data using a MySQL Connection in Amazon QuickSight.
-
Replicate EmailOctopus Data to Multiple Databases via the CData Sync CLI
Replicate EmailOctopus data to disparate databases with a single configuration.
-
Build QuickBooks-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live QuickBooks data.
-
Natively Connect to Drip Data in PHP
The CData ODBC driver for Drip enables you to create PHP applications with connectivity to Drip data. Leverage the native support for ODBC in PHP.
-
Link Apify with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apify data in Filemaker Pro for Mac or Windows.
-
How to Work with Timely Data in ETL Validator JDBC
Connect to Timely from ETL Validator jobs using the CData Software JDBC Driver.
-
Process & Analyze Perplexity Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Perplexity Data.
-
How to Build an ETL App for Confluence Data in Python with CData Connect AI
Extract and transform live Confluence data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Gorgias Data from PowerBuilder via ADO.NET
This article demonstrates how to access Gorgias data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous MessageBird Replication to SQLite
Use CData Sync for automated, continuous, customizable MessageBird replication to SQLite.
-
How to Connect to Live API Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your API data for you.
-
Access Live HubSpot Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live HubSpot data from your Google Sheets.
-
Connect to Amazon DynamoDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Amazon DynamoDB data.
-
Analyze Live Basecamp Data in SAS Viya
Use CData Connect AI to connect to Basecamp data from SAS Viya and deploy self-service analytics using live Basecamp data.
-
Use JayDeBeApi to access Microsoft Exchange Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Exchange data.
-
Integrating Codex with Amplitude 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.
-
How to connect PolyBase to Adobe Experience Manager
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Adobe Experience Manager data.
-
Model, Search, and Visualize Live Suadeo Data in ThoughtSpot
Use CData Connect AI to connect to live Suadeo data for modeling, searching, and visualizing.
-
Operational Reporting on PostgreSQL Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PostgreSQL data.
-
Visualize Live Salesloft Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Salesloft data.