CData Software - Knowledge Base
Recent Articles
-
Connect to Asana Data from a Connection Pool in Jetty
The Asana JDBC Driver supports connection pooling: This article shows how to connect faster to Asana data from Web apps in Jetty.
-
Getting Started with the CData Power BI Connector for ADP
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for ADP.
-
Replicate Recurly Data from PowerShell
Write a quick PowerShell script to query Recurly data. Use connectivity to the live data to replicate Recurly data to SQL Server.
-
Create Power BI Reports on Real-Time Sage Cloud Accounting Data
Use the CData ODBC Driver for Sage Cloud Accounting to visualize Sage Cloud Accounting data in Power BI Desktop.
-
Connect to Quickbase Data from AWS Glue
Use CData Connect AI to gain access to live Quickbase data from your AWS Glue jobs.
-
How to create Visio diagrams from SQL Server Data
Automatically update SQL Server data with the changes you make to Visio master shapes.
-
Build Data Flows from SAP SuccessFactors to SQL Server using SSIS
Easily back up SAP SuccessFactors data to SQL Server using the SSIS components for SAP SuccessFactors.
-
Getting Started with the CData Connect AI Python SDK for Vertica
Install the CData Connect AI Python SDK to read and write live Vertica data with standard DB-API 2.0 Python code.
-
How to Create Power BI Visual Reports with Real-Time ConvertAPI Data
Use CData Power BI Connectors to visualize ConvertAPI data in Power BI.
-
Analyze Hacker News Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Hacker News data with the CData JDBC Driver for Hacker News.
-
Extract, Transform, and Load Eventbrite Data in Informatica PowerCenter
Create a simple Workflow for Eventbrite data in Informatica PowerCenter.
-
How to Work with Instantly Data in ETL Validator JDBC
Connect to Instantly from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live HCL Domino Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live HCL Domino data from your Excel spreadsheets.
-
Import Real-Time Bannerbear Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Bannerbear data in ColdFusion.
-
Connect to SFTP Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SFTP data from Filemaker Pro on Mac.
-
How to integrate CSV with Apache Airflow
Access and process CSV data in Apache Airflow using the CData JDBC Driver.
-
Add ChargeOver Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ChargeOver with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Coinbase Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Coinbase data using standard SQL.
-
Integrate with live Jumpseller Data in Jitterbit
Use CData Connect AI to connect to and integrate live Jumpseller data in Jitterbit.
-
Build a PostgreSQL Interface for Pushbullet Data using the CData JDBC Driver
Use the Remoting features of the Pushbullet JDBC Driver to create a PostgreSQL entry-point for data access.
-
LINQ to Stack Exchange 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 Stack Exchange Data Provider.
-
Query, Visualize, and Share live Google Search Results in Redash
Use CData Connect AI to connect to live Google Search results in Redash for querying, visualizing, and sharing.
-
Visualize Freshdesk Data in Tableau
The CData ODBC driver for Freshdesk enables you integrate Freshdesk data into Tableau dashboards.
-
Integrating Cursor with Dynamics NAV 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.
-
Connect to Avro Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Avro data.
-
Create Power BI Reports on Real-Time Rebilly Data
Use the CData ODBC Driver for Rebilly to visualize Rebilly data in Power BI Desktop.
-
Access Live Azure Table Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Azure Table data from your Excel spreadsheets.
-
Load Codat Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Codat data to a database.
-
Write a Simple Go Application to work with Discord Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Discord data.
-
Integrating Salesforce CRM Analytics Data in Talend Cloud Data Management Platform
Connect Salesforce CRM Analytics Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Salesforce CRM Analytics.
-
How to Connect to Live iContact 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 iContact data for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ScrapingBee
Provide connectivity to ScrapingBee data through an SAP BusinessObjects universe.
-
How to import LaunchDarkly Data into Apache Solr
Use the CData Software JDBC Driver for LaunchDarkly in Data Import Handler and create an automated import of LaunchDarkly data to Apache Solr Enterprise Search platform.
-
DataBind Spark Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Spark with the DevExpress Windows Forms and Web controls to provide Spark data to a chart.
-
How to Query SAP SuccessFactors LMS Data in MySQL Workbench
Execute MySQL queries against live SAP SuccessFactors LMS data from MySQL Workbench.
-
Integrate Live Databricks 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 Databricks data from within the IDE.
-
Integrate with ZarMoney Data in JReport Designer
Create charts and reports based on ZarMoney data in JReport Designer.
-
Design BIRT Reports on Copper Data
Provide current Copper data to your embedded analytics.
-
Build MVC Applications with Connectivity to Superchat Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Superchat from an ASP.NET MVC application.
-
Using the CData Software ODBC Driver for Presto in PyCharm
Connect to Presto as an ODBC data source in PyCharm using the CData Software ODBC Driver for Presto.
-
Getting Started with the CData Power BI Connector for Salesloft
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Salesloft.
-
Access Live SharePoint Data in TIBCO Data Virtualization
Use the SharePoint Tibco DV Adapter to create a SharePoint data data source in TIBCO Data Virtualization Studio and gain access to live SharePoint data from your TDV Server.
-
How to Easily Query XML Data in OpenOffice Base
Connect to XML data in OpenOffice Base using the CData ODBC Driver for XML and generate reports with live data insights.
-
Trigger Dynamics CRM IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Dynamics CRM with standard wizards in Logic Apps.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ScrapingBee
Provide connectivity to ScrapingBee data through an SAP BusinessObjects universe.
-
Connecting Mastra with WordPress Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time WordPress data, no replication required.
-
Analyze XML Data in Looker
Use CData Connect AI to connect to XML Data from Looker and build custom apps using live XML data.
-
Model ConstantContact Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ConstantContact, enabling the direct import of real-time ConstantContact data.
-
Extract, Transform, and Load Databricks Data in Informatica PowerCenter
Create a simple Workflow for Databricks data in Informatica PowerCenter.
-
Visualize Live Adobe Experience Manager Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Adobe Experience Manager data.
-
Integrating Claude Code CLI with Gorgias 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.
-
Build Azure Data Catalog-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Data Catalog data.
-
Connect to SparkPost Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SparkPost data.
-
Process & Analyze Rebilly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Rebilly Data.
-
Use Microsoft Copilot Studio to talk to your Typeform Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Typeform data for you.
-
Use the CData Software JDBC Driver for ShipEngine in MicroStrategy
Connect to ShipEngine data in MicroStrategy Developer using the CData Software JDBC Driver for ShipEngine.
-
Import Real-Time Procore Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Procore data in ColdFusion.
-
A PostgreSQL Interface for Yelp Data using the CData ODBC Driver
Use the SQL Gateway and Yelp ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect GitHub Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your GitHub data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Validate Google Campaign Manager 360 Data with QuerySurge
Access and validate Google Campaign Manager 360 data in QuerySurge using the CData JDBC Driver.
-
Publish Klaviyo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Klaviyo data.
-
Create MariaDB-Connected Business Apps in AppSheet
Connect to MariaDB Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MariaDB data.
-
Create Reports from CapsuleCRM Data in Looker Studio
Use CData Connect AI to gain access to live CapsuleCRM data and create custom reports in Looker Studio.
-
Build Dashboards with Wrike Data in Dundas BI
Create dynamic dashboards and perform analytics based on Wrike data in Dundas BI.
-
Connect to Google Cloud Storage Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Cloud Storage Data and connect to Google Cloud Storage data in Akorbi Digital RunMyProcess.
-
Connecting Agentforce with ServiceNow 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 ServiceNow data for you.
-
Getting Started with the CData Excel Add-In for Cvent
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Cvent.
-
How to create an RPA flow for Aha! Data in UiPath Studio
Use the Aha! ODBC Driver to create workflows that access real-time Aha! data without any coding.
-
Replicate Multiple Printify Accounts
Replicate multiple Printify accounts to one or many databases.
-
Automated Continuous Avro Replication to Snowflake
Use CData Sync for automated, continuous, customizable Avro replication to Snowflake.
-
Connect to iContact Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live iContact data from Filemaker Pro on Mac.
-
Access Live CapsuleCRM Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live CapsuleCRM data through MCP integration.
-
Build an OLAP Cube in SSAS from Dynamics 365 Data
Establish a connection to Dynamics 365 data data from SQL Server Analysis Services, and use the Dynamics 365 Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Semantic Layer Views for ConstantContact Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ConstantContact data.
-
How to Build an ETL App for FreshBooks Data in Python with CData
Create ETL applications and real-time data pipelines for FreshBooks data in Python with petl.
-
Connect to Amplitude Data from a Connection Pool in JBoss
Integrate Amplitude data into Java servlets: Use the Management Console in JBoss to install the Amplitude JDBC Driver.
-
How to Query Live Jira Assets Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Jira Assets data data in natural language using Python.
-
How to Connect the Power BI Service to TaxJar: Complete Guide
Connect to the CData Software Power BI Connector for TaxJar from PowerBI.com to provide real-time TaxJar data across the organization.
-
Visualize Live Presto Data in the Power BI Service
Use CData Connect AI to connect to live Presto data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Codex with Yelp 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 BigCommerce Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live BigCommerce data from HeidiSQL.
-
Create Raisers Edge NXT-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Raisers Edge NXT Data from Klipfolio and build custom visualizations using live Raisers Edge NXT data.
-
Replicate Okta Data from PowerShell
Write a quick PowerShell script to query Okta data. Use connectivity to the live data to replicate Okta data to SQL Server.
-
Query, Visualize, and Share live Adobe Commerce Data in Redash
Use CData Connect AI to connect to live Adobe Commerce data in Redash for querying, visualizing, and sharing.
-
Visualize Live GraphQL Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live GraphQL data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Xero: HTTP 503 Rate Limit Exceeded.
What does this mean?
-
Contentful Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Contentful facts in real time.
-
Visualize Live Reckon Accounts Hosted Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Reckon Accounts Hosted data.
-
How to Query Nethunt Data in MySQL Workbench
Execute MySQL queries against live Nethunt data from MySQL Workbench.
-
Connect to SharePoint Data from Crystal Reports
Use CData Connect AI to connect to and report on live SharePoint data from Crystal Reports.
-
Integrate Open WebUI with Live SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SQL Analysis Services data from within the chat interface.
-
Use the CData Software JDBC Driver for Cloudflare in MicroStrategy Web
Connect to Cloudflare data in MicroStrategy Web using the CData Software JDBC Driver for Cloudflare.
-
Query JSON Services through ODBC in Node.js
Use node-odbc to execute SQL queries against JSON services from Node.js.
-
Stream Quickbase Data into Apache Kafka Topics
Access and stream Quickbase data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build SingleStore-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SingleStore data.
-
Getting Started with the CData Excel Add-In for Avaza
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Avaza.
-
Seamlessly Bring WordPress Data into Retool Using CData Connect AI
Integrate WordPress data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build MVC Applications with Connectivity to Oracle SCM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle SCM from an ASP.NET MVC application.
-
Create ZohoExpense-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to ZohoExpense Data from OutSystems and build custom enterprise apps using live ZohoExpense data.
-
Connecting Pipedream with Google Search Results via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Google Search data in real time.