CData Software - Knowledge Base
Recent Articles
-
Validate Redshift Data with QuerySurge
Access and validate Redshift data in QuerySurge using the CData JDBC Driver.
-
Connect to Hacker News Data in JRuby
Create a simple JRuby app with access to live Hacker News data.
-
Connect to Okta Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Okta data from Filemaker Pro on Mac.
-
Access Live WordPress Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live WordPress data from your Excel spreadsheets.
-
How to integrate ConstantContact with Apache Airflow
Access and process ConstantContact data in Apache Airflow using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for FTP on an SSRS Report Server
Connect to FTP data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connecting GenSpark with SuiteCRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SuiteCRM data without any replication or custom integration required.
-
Integrate with DocuSign Data in SnapLogic
Use CData Connect AI to connect to and integrate with live DocuSign data in SnapLogic.
-
Access Instantly Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Instantly data from HeidiSQL.
-
Connect to Clari Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Clari.
-
Connect to Real-Time Sybase IQ Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sybase IQ and Dataflow to import and use Sybase IQ data in Power Apps.
-
Moving Data from Autopilot to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Autopilot data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Short.io Data from PowerBuilder via ADO.NET
This article demonstrates how to access Short.io data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData Software JDBC Driver for Humanity in MicroStrategy Desktop
Connect to Humanity data in MicroStrategy Desktop using the CData Software JDBC Driver for Humanity.
-
Integrate with Printify Data in JReport Designer
Create charts and reports based on Printify data in JReport Designer.
-
How to Connect to Live Mailgun Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Mailgun data for you.
-
Integrate MailChimp Data into Power Automate Desktop using CData Connect
CData Connect for MailChimp Data enables you to integrate MailChimp data into workflows built using Microsoft Power Automate Desktop.
-
Analyze Live Amazon Athena Data in SAS Viya
Use CData Connect AI to connect to Amazon Athena data from SAS Viya and deploy self-service analytics using live Amazon Athena data.
-
LINQ to Microsoft Dataverse 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 Microsoft Dataverse Data Provider.
-
Use the CData Software JDBC Driver for Float in MicroStrategy
Connect to Float data in MicroStrategy Developer using the CData Software JDBC Driver for Float.
-
DataBind Charts to Zuora Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zuora 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.
-
Freshsales Reporting in OBIEE with the Freshsales JDBC Driver
Deploy the Freshsales JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Live Salesforce Pardot 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 Salesforce Pardot data directly from the development environment.
-
Automate Codat Data Replication to SAP HANA
Use CData Sync to customize and automate Codat data replication to SAP HANA.
-
Connect to Real-Time Opsgenie Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Opsgenie data in Power Apps.
-
Replicate Multiple SAP ByDesign Accounts via the CData Sync CLI
Replicate multiple SAP ByDesign accounts to one or many databases.
-
Getting Started with the CData Connect AI Python SDK for SurveyMonkey
Install the CData Connect AI Python SDK to read live SurveyMonkey data with standard DB-API 2.0 Python code.
-
Automate NASA Data Replication to Azure Data Lake
Use CData Sync to customize and automate NASA data replication to Azure Data Lake.
-
Getting Started with the CData Python Connector for QuickBooks
Learn to install and license the CData Python Connector and configure a connection to live QuickBooks data.
-
Replicate Multiple Google Spanner Accounts via the CData Sync CLI
Replicate multiple Google Spanner accounts to one or many databases.
-
Integrate Devin with Live Salesforce 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 Salesforce data.
-
How to Visualize HCL Domino 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 HCL Domino data in Python.
-
Integrate HubDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate HubDB with External Services.
-
Use ChatGPT to Talk to Your Raisers Edge NXT 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 Raisers Edge NXT data for you.
-
Create Outreach.io-Connected Nintex Workflows
Use CData Connect AI to connect to Outreach.io Data from Nintex Workflow Cloud and build custom workflows using live Outreach.io data.
-
How to publish and share IBM Cloud Object Storage Data dashboards with Tableau Server
The CData ODBC driver for IBM Cloud Object Storage enables you integrate IBM Cloud Object Storage data into Tableau dashboards.
-
Create Power BI Reports on Real-Time Drip Data
Use the CData ODBC Driver for Drip to visualize Drip data in Power BI Desktop.
-
Connect to Codat Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Codat to connect to Codat data and execute queries in PowerBuilder.
-
Connect to JSON from Asprova with CData Software ODBC Driver for JSON
This article shows how to connect faster to JSON data from Asprova.
-
Enable the Pinterest JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Pinterest data.
-
How to Seamlessly Import JSON Data into IBM SPSS Modeler
Integrate JSON data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build PostgreSQL-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PostgreSQL data and build web apps with connectivity to live PostgreSQL data.
-
Integrate Theia IDE with Live Oracle SCM 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 Oracle SCM data from within the development environment.
-
Connect to Azure Analysis Services Data in DBArtisan
Use wizards in DBArtisan to configure Azure Analysis Services data as a data source.
-
Integrating LangGraph with Oracle Sales Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle Sales data within automated workflows.
-
DataBind Controls to Productboard Data in Delphi
DataBind to Productboard data in Delphi with standard data access components and controls.
-
DataBind Sybase Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Sybase with the DevExpress Windows Forms and Web controls to provide Sybase data to a chart.
-
Use the CData ODBC Driver for Wistia from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Wistia to connect to Wistia data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Wistia data in Excel.
-
How to Access Shortcut Data Using Entity Framework
This article shows how to access Shortcut data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Consume Zoho CRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Zoho CRM feeds that reflect any changes in SAP Lumira.
-
Connect to AfterShip Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to AfterShip and work with AfterShip data in your FileMaker application.
-
Interact with Live OneNote Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live OneNote data.
-
Visualize Eventbrite Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Eventbrite data.
-
Use the CData SSIS Components to Insert New or Update Existing BigCommerce Records from SQL Server
Easily push SQL Server data to BigCommerce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into BigCommerce or update existing records with data from a SQL Server database.
-
Visualize Live ZohoExpense Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ZohoExpense data.
-
HCL Domino REST API Part 4: Connecting from Tableau using CData Tableau Connector
The last article in an article series that goes over the HCL Domino REST API. This article is an overview and guide for the CData HCL Domino Drivers and Connectors.
-
Access Amazon DynamoDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Amazon DynamoDB data from your Oracle system.
-
Connect to Act CRM Data in RazorSQL
Connect to Act CRM from wizards and query Act CRM data from the GUI in the RazorSQL database management tool.
-
Add Oracle Eloqua Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle Eloqua with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect DBeaver to Anaplan via a JDBC Driver
Manage Anaplan data with visual tools in DBeaver like the query browser.
-
How to connect SharePoint with Act-On Data through external lists
Provide Act-On data to SharePoint users as an external list.
-
Getting Started with the CData JDBC Driver for ClickUp
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ClickUp.
-
Visualize Live Microsoft Ads Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Ads data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Hacker News in SpagoBI
Create reports featuring live Hacker News data in SpagoBI Studio. Host Hacker News reports on SpagoBI Server.
-
Replicate ClickTime Data to Multiple Databases via the CData Sync CLI
Replicate ClickTime data to disparate databases with a single configuration.
-
How to create Figshare federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Figshare data in MySQL .
-
Automated Continuous SpaceX Replication to Oracle
Use CData Sync for automated, continuous, customizable SpaceX replication to Oracle.
-
Build MarkLogic-Connected Apps in Choreo
Use CData Connect AI to connect to MarkLogic Data from Choreo and build custom apps using live MarkLogic data.
-
Automated Continuous Elasticsearch Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Google Cloud SQL.
-
Integrate Cursor with Live Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Shopify data from within the editor.
-
How to Connect DBeaver to MessageBird via a JDBC Driver
Manage MessageBird data with visual tools in DBeaver like the query browser.
-
Access SAP ByDesign Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP ByDesign data from your Oracle system.
-
Access Live LinkedIn Ads Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live LinkedIn Ads data from your Excel spreadsheets.
-
Establish a Live Connection with Instagram Data using Tableau Bridge
The CData ODBC Driver for Instagram enables you to integrate live Instagram data into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live LinkedIn Ads Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to LinkedIn Ads data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Dashboards and Visualize Live SAP SuccessFactors LMS Data in Geckoboard
Use CData Connect AI to connect to live SAP SuccessFactors LMS data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
AlloyDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on AlloyDB facts in real time.
-
Extract, Transform, and Load Front Data in Informatica PowerCenter
Create a simple Workflow for Front data in Informatica PowerCenter.
-
Provide OData Services of Testmonitor Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Testmonitor data by developing a WCF Service Application.
-
Replicate Google Analytics Data from PowerShell
Write a quick PowerShell script to query Google Analytics data. Use connectivity to the live data to replicate Google Analytics data to SQL Server.
-
Build Pinterest-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Pinterest Data and create custom apps in Bubble.
-
How to Connect to Live Microsoft Teams 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 Microsoft Teams data for you.
-
How to Connect to Live CouchDB Data 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 CouchDB data for you.
-
Use the CData Software ODBC Driver for Wistia in MicroStrategy
Connect to Wistia data in MicroStrategy Developer using the CData Software ODBC Driver for Wistia.
-
Import Real-Time Exact Online Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Exact Online data in ColdFusion.
-
Create Dashboards and Visualize Live CapsuleCRM Data in Geckoboard
Use CData Connect AI to connect to live CapsuleCRM data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Reckon Data in Claris FileMaker Pro
Use the CData ODBC Driver for Reckon in FileMaker Pro to connect to Reckon and work with Reckon data in your FileMaker applications.
-
Rapidly Develop Unbounce-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 Unbounce.
-
Visualize PolarTeamPro Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load PolarTeamPro data into TIBCO Spotfire.
-
Integrate LibreChat with Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Instagram data from within the chat interface.
-
How to integrate Office 365 with Apache Airflow
Access and process Office 365 data in Apache Airflow using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Google Sheets in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Sheets data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Sheets.
-
Build Pipelines with Live SurveyMonkey Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SurveyMonkey from Google Cloud Data Fusion, enabling the integration of live SurveyMonkey data into the building and management of effective data pipelines.
-
Integrating Cursor with Jira 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.
-
Query Discord Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Discord data from Node.js.
-
Connect to Odoo Data from HeidiSQL
Use CData Connect AI to connect to and query live Odoo data from HeidiSQL.
-
Choosing the Best Method to Connect Jira Assets to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Jira Assets data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Dash to Build to Web Apps on Brex Data
Create Python applications that use pandas and Dash to build Brex-connected web apps.
-
Integrate Devin with Live Sage Cloud Accounting 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 Sage Cloud Accounting data.
-
Create Apps from SAP HANA Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP HANA Data and build apps from live SAP HANA data in Qlik Sense Cloud.