CData Software - Knowledge Base
Recent Articles
-
Working with Zoom Data in LINQPad
Execute LINQ queries to Zoom in LINQPad.
-
How to Seamlessly Import Blackbaud FE NXT Data into IBM SPSS Modeler
Integrate Blackbaud FE NXT data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Cline with Live WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live WordPress from within your IDE.
-
A PostgreSQL Interface for Procore Data using the CData ODBC Driver
Use the SQL Gateway and Procore ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live Azure Analysis Services Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Azure Analysis Services using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Datasets from LionDesk in Domo Workbench and Build Visualizations of LionDesk Data in Domo
Use the CData Software ODBC Driver for LionDesk to create datasets from LionDesk in Domo Workbench and then build visualizations in the Domo service.
-
How to Visualize BigCommerce Data in Python with pandas
Use pandas and other modules to analyze and visualize live BigCommerce in Python.
-
Build Semantic Layer Views for Amazon Marketplace Data in APOS Live Data Gateway
Use the CData Connector for Amazon Marketplace in APOS Live Data Gateway to build Semantic Layer Views for Amazon Marketplace.
-
Prepare, Blend, and Analyze Cassandra Data in Alteryx Designer (ODBC)
Build workflows to access live Apache Cassandra for self-service data analytics.
-
Visualize Sage 200 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 Sage 200 into TIBCO Spotfire.
-
Build Microsoft Entra ID-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Entra ID.
-
Visualize Live Impala Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Impala.
-
Build a Simple VCL Application for ChartMogul Data
How to build a simple VCL Application to view ChartMogul in RAD Studio using the CData ODBC Driver for ChartMogul.
-
Viewing Azure DevOps Data in RAD Studio Data Explorer
How to view Azure DevOps in RAD Studio Data Explorer using the CData ODBC Driver for Azure DevOps.
-
Automated Continuous Unbounce Replication to MongoDB
Use CData Sync for automated, continuous, customizable Unbounce replication to MongoDB.
-
Integrate Live Microsoft Teams Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Teams to Blue Prism using the CData ODBC Driver for Microsoft Teams to create automated workflows for repetitive business tasks.
-
Publish Reports with Perigon Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Perigon.
-
Use the CData Software JDBC Driver for ZendeskSell in MicroStrategy Desktop
Connect to ZendeskSell in MicroStrategy Desktop using the CData Software JDBC Driver for ZendeskSell.
-
Access Access Data from MySQL in PHP
Connect to Access through the standard MySQL libraries in PHP.
-
Connect to Rootly Data in HULFT Integrate
Connect to Rootly as a JDBC data source in HULFT Integrate
-
Deploy the ADO.NET Provider for Microsoft Teams on an SSRS Report Server
Connect to Microsoft Teams 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.
-
Integrate Insightly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Insightly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Insightly.
-
Integrating Cursor CLI with Zendesk 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.
-
Access Paylocity Data from MySQL in Amazon QuickSight
Connect to Paylocity and build visualizations of Paylocity using a MySQL Connection in Amazon QuickSight.
-
Bidirectional Access to Onfleet Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Onfleet in Filemaker Pro for Mac or Windows.
-
Create SSAS Tabular Models from ServiceNow Data
How to build a SQL Server Analysis Service Tabular Model from ServiceNow using CData drivers.
-
How to Create Power BI Visual Reports with Real-Time Oracle Eloqua Reporting Data
Use CData Power BI Connectors to visualize Oracle Eloqua Reporting in Power BI.
-
Build a PostgreSQL Interface for LDAP Objects using the CData JDBC Driver
Use the Remoting features of the LDAP JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Manus AI to Talk to Your CouchDB 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 Apache CouchDB.
-
LINQ to Productboard 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 Productboard Data Provider.
-
Getting Started with the CData Python Connector for Jira
Learn to install and license the CData Python Connector
-
Integrate Open WebUI with Live Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure Cosmos DB from within the chat interface.
-
How to create an RPA flow for Figshare Data in UiPath Studio
Use the Figshare ODBC Driver to create workflows that access real-time Figshare without any coding.
-
Build Apps with Live Act-On Data Using the Low-Code Development Platform of Mendix
Connect Act-On with Mendix to build apps using the CData JDBC Driver for Act-On.
-
Connect to and Query Paddle Data in QlikView over ODBC
Create data visualizations with Paddle in QlikView.
-
Integrate Supabase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Supabase with External Services.
-
Use the CData ODBC Driver for Zoho Projects from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoho Projects to connect to Zoho Projects from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoho Projects in Excel.
-
Enable the Planio JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Planio.
-
ETL Dotmailer in Oracle Data Integrator
This article shows how to transfer Dotmailer into a data warehouse using Oracle Data Integrator.
-
Connect Auth0 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Auth0 using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Outreach.io-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Outreach.io to explore live Outreach.io Data in GitHub Copilot to assist with building Outreach.io-powered applications.
-
Automated Continuous Xero Replication to SQL Server
Use CData Sync for automated, continuous, customizable Xero replication to SQL Server.
-
Configure the CData JDBC Driver for Hacker News in a Connection Pool in Tomcat
Connect to Hacker News from a connection pool in Tomcat.
-
Moving Data from Azure Synapse to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Azure Synapse data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Authorize.Net Data in Claris FileMaker Pro
Use the CData ODBC Driver for Authorize.Net in FileMaker Pro to connect to Authorize.Net and work with Authorize.Net in your FileMaker applications.
-
Integrate with Productboard Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Productboard to a JSON file on disk.
-
How to Connect to Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics for you.
-
Connect to Procore Data from PowerBuilder via ADO.NET
This article demonstrates how to access Procore from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Getting Started with the CData SSIS Components for Dynamics 365
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Dynamics 365.
-
How to Easily Query Amazon DynamoDB Data in OpenOffice Base
Connect to Amazon DynamoDB data in OpenOffice Base using the CData ODBC Driver for Amazon DynamoDB and generate reports with live data insights.
-
Connect Microsoft Planner to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Planner using the CData Python MCP Server.
-
Access Apify Data from MySQL in Amazon QuickSight
Connect to Apify and build visualizations of Apify using a MySQL Connection in Amazon QuickSight.
-
Load Landbot Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Landbot to a database.
-
Automated Continuous FHIR Replication to MongoDB
Use CData Sync for automated, continuous, customizable FHIR replication to MongoDB.
-
Extract, Transform, and Load Samanage Data in Informatica PowerCenter
Create a simple Workflow for Samanage in Informatica PowerCenter.
-
How to Access Live Instagram Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Instagram enables you to integrate Instagram into workflows built using Microsoft Power Automate Desktop.
-
Replicate Multiple Certinia Accounts
Replicate multiple Certinia accounts to one or many databases.
-
Getting Started with the CData ODBC Driver for Figshare
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Figshare.
-
Access Live SAP Business One Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Business One from your Excel spreadsheets.
-
Build a Singer.io Tap for IBM Cloud Object Storage With the CData Python Connector
Learn how to easily build a Singer.io Tap for live IBM Cloud Object Storage data using
-
Use the CData ODBC Driver for Twitter Ads in Microsoft Power Query
You can use the CData Twitter Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Twitter Ads into Microsoft Power Query.
-
How to Query Opsgenie Data in MySQL Workbench
Execute MySQL queries against live Opsgenie from MySQL Workbench.
-
Consume Sybase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sybase feeds that reflect any changes in SAP Lumira.
-
Create Power BI Reports on Real-Time Google Calendar Data
Use the CData ODBC Driver for Google Calendar to visualize Google Calendar in Power BI Desktop.
-
How to Access Live Act-On Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Act-On enables you to integrate Act-On into workflows built using Microsoft Power Automate Desktop.
-
Excel Spreadsheet Automation on Workday Data with the QUERY Formula
Pull data from Workday, automate spreadsheets, and more with the QUERY formula.
-
Visualize IBM Informix Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to IBM Informix.
-
Use Agno to Talk to Your Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Splunk for you.
-
Connect to Postmark Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Postmark.
-
Create SSAS Tabular Models from Zoom Data
How to build a SQL Server Analysis Service Tabular Model from Zoom using CData drivers.
-
Connect to SingleStore Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SingleStore Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Greenhouse-Connected Business Apps in AppSheet
Connect to Greenhouse Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Greenhouse.
-
Automated Continuous Microsoft OneLake Replication to MySQL
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to MySQL.
-
Connect to Asana Data in DBeaver
Use the CData ODBC Driver to connect to Asana in DBeaver.
-
Replicate Multiple Vault CRM Accounts
Replicate multiple Vault CRM accounts to one or many databases.
-
Import Microsoft Exchange Data Using Azure Data Factory
Use CData Connect AI to connect to Microsoft Exchange Data from Azure Data Factory and import live Microsoft Exchange.
-
How to create an RPA flow for eBay Data in UiPath Studio
Use the eBay ODBC Driver to create workflows that access real-time eBay without any coding.
-
Enable the Amazon Athena JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Amazon Athena.
-
How to connect PolyBase to SpaceX
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SpaceX.
-
Build Dashboards with Front Data in Dundas BI
Create dynamic dashboards and perform analytics based on Front in Dundas BI.
-
Connect to Active Directory Data from PowerBuilder via JDBC
This article demonstrates how to access Active Directory from PowerBuilder using the Active Directory JDBC Driver.
-
Access Live SageHR Data in Coginiti Pro
Connect to and query live SageHR from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Coinbase Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Coinbase facts in real time.
-
Integrate MYOB AccountRight Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to MYOB AccountRight and integrate live MYOB AccountRight into your Power Automate tasks.
-
Integrating Claude Code CLI with Twitter Ads 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.
-
Automated Continuous Avalara AvaTax Replication to Oracle
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Oracle.
-
Connect to Real-Time Zoho Projects Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Zoho Projects and Dataflow to import and use Zoho Projects in Power Apps.
-
Create Dashboards and Visualize Live Act-On Data in Geckoboard
Use CData Connect AI to connect to live Act-On and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect and Visualize Live Spark Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Apache Spark SQL into the Databricks platform and create visualization dashboards with real-time Apache Spark SQL.
-
Connect to Spotify Data in DBeaver
Use the CData ODBC Driver to connect to Spotify in DBeaver.
-
Manage BenchmarkEmail Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for BenchmarkEmail.
-
Visualize Live BambooHR Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live BambooHR.
-
Rapidly Develop ChargeOver-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 ChargeOver.
-
Visualize Live Azure DevOps Data in the Power BI Service
Use CData Connect AI to connect to live Azure DevOps and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Marketo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Marketo from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to CloudConvert Data from PowerBuilder via JDBC
This article demonstrates how to access CloudConvert from PowerBuilder using the CloudConvert JDBC Driver.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Google Calendar actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to Build an ETL App for Dropbox Data in Python with CData
Create ETL applications and real-time data pipelines for Dropbox in Python with petl.
-
Explore Geographical Relationships in Oracle Eloqua Reporting Data with Power Map
Create data visualizations with Oracle Eloqua Reporting in Power Map.
-
Process & Analyze Phoenix Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Phoenix Data.