CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Deel
Provide connectivity to Deel through an SAP BusinessObjects universe.
-
Publish Autopilot-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Autopilot.
-
Integrate Theia IDE with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automated Azure Synapse Data Replication to Teradata
Use CData Sync to Customize and automate Azure Synapse replication to Teradata.
-
Integrating Cursor CLI with GetResponse 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.
-
Getting Started with the CData JDBC Driver for Drift
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Drift.
-
Build Agents in Relevance AI with Access to Live AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google AlloyDB within intelligent agent workflows.
-
Connect to SAP Netweaver Gateway Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP Netweaver Gateway and the SQL Gateway to access SAP Netweaver Gateway from Google Apps Script.
-
Visualize Freshteam Data in Tableau
The CData ODBC driver for Freshteam enables you integrate Freshteam into Tableau dashboards.
-
Getting Started with the CData Excel Add-In for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ScrapingBee.
-
Replicate Multiple Airtable Accounts via the CData Sync CLI
Replicate multiple Airtable accounts to one or many databases.
-
Access Live Azure Synapse Data in Excel 365 Online (Excel for the web)
Connect to Azure Synapse from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate Opsgenie Data to Multiple Databases via the CData Sync CLI
Replicate Opsgenie to disparate databases with a single configuration.
-
How to Access HubDB Data Using Entity Framework
This article shows how to access HubDB using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Choosing the Best Method to Connect Microsoft Dataverse to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Dataverse (CDS) from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze TigerGraph Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze TigerGraph with the CData JDBC Driver for TigerGraph.
-
Operational Reporting on Telegram Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Telegram.
-
How to Visualize PayPal Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live PayPal in Python.
-
Provide OData Services of Zendesk Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zendesk by developing a WCF Service Application.
-
How to Access Live Reckon Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Reckon enables you to integrate Reckon into workflows built using Microsoft Power Automate Desktop.
-
Analyze Nethunt Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Nethunt from Power Pivot. You will use the Table Import Wizard to load Nethunt. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Quickbase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Quickbase.
-
How to Connect to Live Okta Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Okta for you.
-
View Reports on Real-Time Klaviyo Data in Power BI Report Server
Use the CData ODBC Driver for Klaviyo to visualize Klaviyo in Power BI Desktop and then publish them to Power BI Report Server.
-
Easily Integrate ChargeOver Data in Lazarus Pascal IDE
Learn how to easily integrate live ChargeOver in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Microsoft Planner Data in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Planner in FileMaker Pro to connect to Microsoft Planner and work with Microsoft Planner in your FileMaker applications.
-
How to Connect to & Open Cvent Data in Microsoft Excel
This article uses the CData ODBC driver for Cvent to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Highrise Data from AWS Glue
Use CData Connect AI to gain access to live Highrise CRM from your AWS Glue jobs.
-
Access Sage Cloud Accounting Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage Business Cloud Accounting from your Oracle system.
-
Integrate Goose with Live SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SurveyMonkey from within the local AI agent.
-
Access Live SAP ByDesign Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Business ByDesign from your Google Sheets.
-
Build AI Agents with QuickBooks Time Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live QuickBooks Time through CData Connect AI.
-
Visualize SharePoint Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft SharePoint.
-
Use the CData Software ODBC Driver for Email in MicroStrategy
Connect to Email in MicroStrategy Developer using the CData Software ODBC Driver for Email.
-
Build MVC Applications with Connectivity to Sage 300 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sage 300 from an ASP.NET MVC application.
-
Visualize Aweber Data in TIBCO Spotfire through ADO.NET
Integrate Aweber into dashboards in TIBCO Spotfire.
-
Create Reports with Freshdesk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshdesk.
-
Build AI Agents with SAP Netweaver Gateway Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SAP Netweaver Gateway through CData Connect AI.
-
Connect to Customer.io Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Customer.io to connect to Customer.io and execute queries in PowerBuilder.
-
Build Charts with Azure Analysis Services Data in Clear Analytics
Create dynamic charts and perform analytics based on Azure Analysis Services in Clear Analytics.
-
Process & Analyze Cosmos DB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Cosmos DB Data.
-
Automated Continuous Azure Data Lake Storage Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Amazon S3.
-
Validate Reply.io Data with QuerySurge
Access and validate Reply.io in QuerySurge using the CData JDBC Driver.
-
Create Email Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Email data access from reports, embedded analytics, and more.
-
Integrate with Pushbullet Data in JReport Designer
Create charts and reports based on Pushbullet in JReport Designer.
-
Connect to Live Confluence Data in MicroStrategy through CData Connect AI
Create a live connection to Confluence Data in CData Connect AI and connect to your Atlassian Confluence from MicroStrategy.
-
Rapidly Develop Workday-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 Workday.
-
Bridge Phoenix Connectivity with Apache NiFi
Access and process Apache Phoenix in Apache NiFi using the CData JDBC Driver.
-
Build Automated Snapchat Ads-Connected Workflows in Zapier
Use CData Connect AI to connect to live Snapchat Ads and build automated workflows in Zapier.
-
Publish Google Tasks-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Tasks.
-
How to Work with Miro Data in AWS Glue Jobs Using JDBC
Connect to Miro from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for Codat in MicroStrategy Web
Connect to Codat in MicroStrategy Web using the CData Software ODBC Driver for Codat.
-
How to Visualize Jodoo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Jodoo in Python.
-
Connect to Elasticsearch Data in Aqua Data Studio
Access Elasticsearch from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Import Real-Time Clockify Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Clockify in ColdFusion.
-
Automated Continuous Power BI XMLA Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Amazon S3.
-
How to Seamlessly Import Reckon Accounts Hosted Data into IBM SPSS Modeler
Integrate Reckon Accounts Hosted data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Easily Query Landbot Data in OpenOffice Base
Connect to Landbot data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
A PostgreSQL Interface for Suadeo Data using the CData ODBC Driver
Use the SQL Gateway and Suadeo ODBC Driver to create a PostgreSQL entry-point for data access.
-
Back Up Discord 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 Discord data.
-
Connect to ZarMoney Data in CloverDX (formerly CloverETL)
Transfer ZarMoney using the visual workflow in the CloverDX data integration tool.
-
Validate RSS Feeds with QuerySurge
Access and validate RSS Feeds in QuerySurge using the CData JDBC Driver.
-
How to Connect Flowise AI Agents to Live Snapchat Ads Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Snapchat Ads without replication.
-
How to Connect Microsoft Planner Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Microsoft Planner data in real time using natural language.
-
Migrating data from Okta to Snowflake using CData SSIS Components.
Easily push Okta to Snowflake using the CData SSIS Tasks for Okta and Snowflake.
-
Integrating Gumloop with Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Planner within automated workflows.
-
How to Build an ETL App for Reckon Accounts Hosted Data in Python with CData
Create ETL applications and real-time data pipelines for Reckon Accounts Hosted in Python with petl.
-
Connect to Live Sybase IQ Data in MicroStrategy through CData Connect AI
Create a live connection to Sybase IQ Data in CData Connect AI and connect to your Sybase IQ from MicroStrategy.
-
How to Create Power BI Visual Reports with Real-Time FTP Data
Use CData Power BI Connectors to visualize FTP Servers in Power BI.
-
Connect to SharePoint Data in Jaspersoft Studio
Execute SQL to remote Microsoft SharePoint in Jaspersoft Studio.
-
Automated Continuous Oracle Financials Cloud Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to delimited files (CSV/TSV).
-
Connect to CockroachDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live CockroachDB.
-
How to connect and process Ontraport from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Ontraport.
-
Using the CData Software ODBC Driver for Square in PyCharm
Connect to Square as an ODBC data source in PyCharm using the CData Software ODBC Driver for Square.
-
Integrating Boomi Agentstudio with Dropbox Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Dropbox, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create Power BI Reports on Real-Time Mouseflow Data
Use the CData ODBC Driver for Mouseflow to visualize Mouseflow in Power BI Desktop.
-
Automate Twitter Ads Data Replication to Azure Data Lake
Use CData Sync to customize and automate Twitter Ads replication to Azure Data Lake.
-
How to import Zoho Recruit Data into Apache Solr
Use the CData Software JDBC Driver for Zoho Recruit in Data Import Handler and create an automated import of Zoho Recruit to Apache Solr Enterprise Search platform.
-
Analyze Reckon Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Reckon in Microsoft R Open.
-
Build Agents in Relevance AI with Access to Live Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sage Intacct within intelligent agent workflows.
-
Build SAP Business One-Connected Apps in Choreo
Use CData Connect AI to connect to SAP Business One Data from Choreo and build custom apps using live SAP Business One.
-
How to Query Printful Data in MySQL Workbench
Execute MySQL queries against live Printful from MySQL Workbench.
-
How to Query Postmark Data in MySQL Workbench
Execute MySQL queries against live Postmark from MySQL Workbench.
-
DataBind Controls to Databricks Data in Delphi
DataBind to Databricks in Delphi with standard data access components and controls.
-
Integrating Sage 200 Data in Talend Cloud Data Management Platform
Connect Sage 200 Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sage 200.
-
Feed Invoiced Data into FineReport
How to set Invoiced as a JDBC data source in FineReport.
-
How to Connect DBeaver to Jira via a JDBC Driver
Manage Atlassian Jira with visual tools in DBeaver like the query browser.
-
Automated Continuous Outreach.io Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Outreach.io replication to Amazon S3.
-
Connect to Azure Table Data from PowerBuilder via JDBC
This article demonstrates how to access Azure Table Storage from PowerBuilder using the Azure Table JDBC Driver.
-
How to Connect the Power BI Service to ZarMoney: Complete Guide
Connect to the CData Software Power BI Connector for ZarMoney from PowerBI.com to provide real-time ZarMoney across the organization.
-
Visualize Live Greenhouse Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Greenhouse.
-
Create SQL Server Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SQL Server data access from reports, embedded analytics, and more.
-
Create Power BI Reports on Real-Time Google Spanner Data
Use the CData ODBC Driver for Google Spanner to visualize Google Spanner in Power BI Desktop.
-
Getting Started with the CData Tableau Connector for Avalara AvaTax
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Avalara AvaTax.
-
Connect to HubDB Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for HubDB to connect to HubDB and execute queries in PowerBuilder.
-
Bridge WordPress Connectivity with Apache NiFi
Access and process WordPress in Apache NiFi using the CData JDBC Driver.
-
How to work with SFTP Data in Apache Spark using SQL
Access and process SFTP Data in Apache Spark using the CData Software JDBC Driver.
-
Bridge Tanda Connectivity with Apache NiFi
Access and process Tanda in Apache NiFi using the CData JDBC Driver.
-
How to Design Microsoft Ads Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Microsoft Ads from mobile and tablet Power Apps.
-
Use Manus AI to Talk to Your WordPress 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 WordPress.