CData Software - Knowledge Base
Recent Articles
-
Use Databricks Agent Bricks to Talk to Your Bitbucket Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Bitbucket data for you.
-
Visualize Kintone Data in Sisense
Create an ElastiCube in Sisense app with access to Kintone data.
-
Deploy the ADO.NET Provider for HCL Domino on an SSRS Report Server
Connect to HCL Domino 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.
-
Connect to Dynamics CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Dynamics CRM data from PowerBuilder using the Dynamics CRM JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Microsoft Dataverse Data
Use CData Power BI Connectors to visualize Microsoft Dataverse data in Power BI.
-
Analyze Presto Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Presto data in Microsoft R Open.
-
How to Connect to Live Exa Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Exa data without replication.
-
Connect to Kintone Data from Crystal Reports
Use CData Connect AI to connect to and report on live Kintone data from Crystal Reports.
-
Integrating GitHub Copilot with Anaplan 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.
-
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 data from within your IDE.
-
Create RSS-Connected Applications in Appsmith
Connect to RSS Feeds via CData Connect AI in Appsmith and create custom business applications with real-time access to RSS feeds.
-
ETL Square in Oracle Data Integrator
This article shows how to transfer Square data into a data warehouse using Oracle Data Integrator.
-
Use the CData ODBC Driver for Quickbase in Microsoft Power Query
You can use the CData Quickbase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Quickbase data into Microsoft Power Query.
-
Replicate Email Data from PowerShell
Write a quick PowerShell script to query Email data. Use connectivity to the live data to replicate Email data to SQL Server.
-
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 data.
-
Query, Visualize, and Share live Zuora Data in Redash
Use CData Connect AI to connect to live Zuora data in Redash for querying, visualizing, and sharing.
-
Connect to Klaviyo Data in RapidMiner
Integrate Klaviyo data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live Dynamics NAV Data in Excel 365 Online (Excel for the web)
Connect to Dynamics NAV data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Prepare, Blend, and Analyze Cassandra Data in Alteryx Designer (ODBC)
Build workflows to access live Cassandra data for self-service data analytics.
-
Bind Live DB2 Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live DB2 data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Visualize SuiteCRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SuiteCRM data.
-
Integrating LangChain with AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on AlloyDB data within automated workflows.
-
Visualize ZendeskSell Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZendeskSell data.
-
Access Live Shortcut Data in Excel 365 Online (Excel for the web)
Connect to Shortcut data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect to Live Grafana 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 Grafana data for you.
-
How to work with Jira Assets Data in Apache Spark using SQL
Access and process Jira Assets Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating Antigravity CLI with Short.io data via CData CLI
Connect Short.io data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Analyze Discord Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Discord data and visualize Discord data in SAP Analytics Cloud.
-
Facebook Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Facebook facts in real time.
-
How to Connect to & Open Oracle Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build a Singer.io Tap for CircleCI With the CData Python Connector
Learn how to easily build a Singer.io Tap for live CircleCI data using the CData Python Connector.
-
Build Semantic Layer Views for Lakebase Data in APOS Live Data Gateway
Use the CData Connector for Lakebase in APOS Live Data Gateway to build Semantic Layer Views for Lakebase data.
-
Visualize Live Sendwithus Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sendwithus data.
-
Connect to BenchmarkEmail Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for BenchmarkEmail data in Airbyte.
-
Integrate Real-Time Access to Google Contacts in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Contacts data in real time.
-
Link Onfleet with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Onfleet data in Filemaker Pro for Mac or Windows.
-
Visualize ClickTime Data in Sisense
Create an ElastiCube in Sisense app with access to ClickTime data.
-
Replicate ADP Data from PowerShell
Write a quick PowerShell script to query ADP data. Use connectivity to the live data to replicate ADP data to SQL Server.
-
Feed Authorize.Net Data into FineReport
How to set Authorize.Net data as a JDBC data source in FineReport.
-
Integrate Trae with Live Bright Data Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Bright Data data from within the AI-powered IDE.
-
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.
-
Query, Visualize, and Share live Elasticsearch Data in Redash
Use CData Connect AI to connect to live Elasticsearch data in Redash for querying, visualizing, and sharing.
-
Create Dashboards and Visualize Live MariaDB Data in Geckoboard
Use CData Connect AI to connect to live MariaDB data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Getting Started with the CData Python Connector for Jira
Learn to install and license the CData Python Connector and configure a connection to live Jira data.
-
Connect Bitbucket to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Bitbucket data using the CData Python MCP Server.
-
Build Discord-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Discord Data and create custom apps in Mendix.
-
Publish Crystal Reports on Zendesk Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zendesk data.
-
Establish a Live Connection with CircleCI Data using Tableau Bridge
The CData ODBC Driver for CircleCI enables you to integrate live CircleCI data into Tableau Cloud dashboards using the Tableau Bridge.
-
Design BIRT Reports on ClickUp Data
Provide current ClickUp data to your embedded analytics.
-
Build Apps with Live Act-On Data Using the Low-Code Development Platform of Mendix
Connect Act-On data with Mendix to build apps using the CData JDBC Driver for Act-On.
-
Connect to Float Data from PowerBuilder via JDBC
This article demonstrates how to access Float data from PowerBuilder using the Float JDBC Driver.
-
Connect HubSpot to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HubSpot with IBM WebSphere for seamless data integration and connectivity.
-
Work with Ontraport Data in FoxPro
Load Ontraport data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Presto-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Presto Data from Zoho Analytics and import live Presto data.
-
Prepare, Blend, and Analyze Azure Analysis Services Data in Alteryx Designer (ODBC)
Build workflows to access live Azure Analysis Services data for self-service data analytics.
-
Create SSAS Tabular Models from Facebook Data
How to build a SQL Server Analysis Service Tabular Model from Facebook data using CData drivers.
-
Automate Airtable Data Replication to SAP HANA
Use CData Sync to customize and automate Airtable data replication to SAP HANA.
-
Establish a Live Connection with MySQL Data using Tableau Bridge
The CData ODBC Driver for MySQL enables you to integrate live MySQL data into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live Sybase IQ Data in Excel 365 Online (Excel for the web)
Connect to Sybase IQ data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Live Google Search Results in Coginiti Pro
Connect to and query live Google Search results from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Toggl Data from AWS Glue
Use CData Connect AI to gain access to live Toggl data from your AWS Glue jobs.
-
Build Data Flows from Demio to SQL Server using SSIS
Easily back up Demio data to SQL Server using the SSIS components for Demio.
-
Build a PostgreSQL Interface for Quickbase Data using the CData JDBC Driver
Use the Remoting features of the Quickbase JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to create Onfleet federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Onfleet data in MySQL .
-
Use the CData Software ODBC Driver for Pinterest in SAS for Real-Time Reporting and Analytics
Connect to real-time Pinterest data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pinterest.
-
Migrating data from ClickUp to Databricks using CData SSIS Components.
Easily push ClickUp data to Databricks using the CData SSIS Tasks for ClickUp and Databricks.
-
How to connect to LDAP Objects from Spring Boot
Connect to LDAP in a Spring Boot Application using the CData JDBC Driver for LDAP
-
DataBind Controls to Billsby Data in Delphi
DataBind to Billsby data in Delphi with standard data access components and controls.
-
Automated Continuous FreeAgent Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable FreeAgent replication to delimited files (CSV/TSV).
-
Analyze Sugar CRM Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sugar CRM data and visualize live Sugar CRM data in Infragistics Reveal.
-
How to connect to Freshdesk Data with Squirrel SQL client
Connect to Freshdesk data and execute queries in the Squirrel SQL Client.
-
Connect to Insightly in SpagoBI
Create reports featuring live Insightly data in SpagoBI Studio. Host Insightly reports on SpagoBI Server.
-
How to integrate Sendwithus with Apache Airflow
Access and process Sendwithus data in Apache Airflow using the CData JDBC Driver.
-
Integrating Kiro with Auth0 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.
-
Publish Crystal Reports on Bugsnag Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Bugsnag data.
-
Integrate with Live SAP Business Warehouse Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP Business Warehouse from the MuleSoft Anypoint Platform to integrate live SAP Business Warehouse data into custom reports and dashboards.
-
How to connect SharePoint with NetSuite Data through external lists
Provide NetSuite data to SharePoint users as an external list.
-
Query Mocean Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Mocean data from Node.js.
-
DataBind Controls to Stripe Data in Delphi
DataBind to Stripe data in Delphi with standard data access components and controls.
-
Build GitLab Visualizations in Tableau Cloud
Use CData Connect AI to connect to live GitLab data and build visualizations in Tableau Cloud.
-
Build Confluence-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Confluence data.
-
Migrating data from Missive to Snowflake using CData SSIS Components.
Easily push Missive data to Snowflake using the CData SSIS Tasks for Missive and Snowflake.
-
How to connect Amazon QuickSight to Azure Data Lake Storage Data
Create a connection to Azure Data Lake Storage data in CData Connect AI and insert Azure Data Lake Storage data into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Live SAP HANA Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP HANA data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP HANA data in the Graph Builder and Query Builder.
-
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 data into workflows built using Microsoft Power Automate Desktop.
-
Migrating data from Grafana to Google BigQuery using CData SSIS Components.
Easily push Grafana data to Google BigQuery using the CData SSIS Tasks for Grafana and Google BigQuery.
-
Access Trello Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Trello data from HeidiSQL.
-
Excel Spreadsheet Automation on Workday Data with the QUERY Formula
Pull data from Workday, automate spreadsheets, and more with the QUERY formula.
-
How to Connect to Live Stripe Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Stripe data securely in real time.
-
Integrate Live Databricks Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Databricks from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Databricks data.
-
Query Live IBM Informix Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live IBM Informix data through a conversational interface.
-
DataBind Charts to CouchDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to CouchDB 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.
-
Access Live PingOne Data in AWS Lambda
Connect to live PingOne data in AWS Lambda using the CData JDBC Driver.
-
Connect to Act-On Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Act-On data.
-
Automated Continuous PDFMonkey Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable PDFMonkey replication to PostgreSQL.
-
Connect to Real-Time Wrike Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Wrike data in Power Apps.
-
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 data.
-
How to connect to Cloudflare Data in DBVisualizer
Integrate Cloudflare data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate with live Google Spanner Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Spanner data in Jitterbit.
-
Build MVC Applications with Connectivity to RabbitMQ Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access RabbitMQ from an ASP.NET MVC application.