CData Software - Knowledge Base
Recent Articles
-
Rapidly Develop Helpscout-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 Helpscout.
-
Connect to Real-Time Coda Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Coda data in Power Apps.
-
Integrating Codex with SageHR 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.
-
How to Build an ETL App for Box Data in Python with CData Connect AI
Build ETL pipelines that read and write live Box data in Python with petl and the CData Connect AI Python SDK.
-
Integrate Google Directory Data into Power Automate Desktop using CData Connect
CData Connect for Google Directory Data enables you to integrate Google Directory data into workflows built using Microsoft Power Automate Desktop.
-
Integrating OpenCode with Sage 300 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.
-
Integrating LlamaIndex with ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ZohoExpense data in real time.
-
Integrate Real-Time Access to Dynamics 365 Business Central in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Dynamics 365 Business Central data in real time.
-
How to Connect Flowise AI Agents to Live Confluence 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 Confluence data without replication.
-
Feed SendGrid Data into FineReport
How to set SendGrid data as a JDBC data source in FineReport.
-
Automated Continuous GetResponse Replication to SingleStore
Use CData Sync for automated, continuous, customizable GetResponse replication to SingleStore.
-
Automated Continuous Invoiced Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Invoiced replication to Amazon Redshift.
-
How to create an RPA flow for Superchat Data in UiPath Studio
Use the Superchat ODBC Driver to create workflows that access real-time Superchat data without any coding.
-
Automated Continuous PDFMonkey Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable PDFMonkey replication to Amazon Redshift.
-
Create Reports with JobNimbus Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date JobNimbus data.
-
Connect to AlloyDB Data from PowerBuilder via ADO.NET
This article demonstrates how to access AlloyDB data from Appeon PowerBuilder using the CData ADO.NET Provider for AlloyDB.
-
Import Real-Time HCL Domino Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use HCL Domino data in ColdFusion.
-
Build Data Flows from ScrapingBee to SQL Server using SSIS
Easily back up ScrapingBee data to SQL Server using the SSIS components for ScrapingBee.
-
Access Live Box Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Box data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Front Data in Jaspersoft Studio
Execute SQL to remote Front data in Jaspersoft Studio.
-
LINQ to Google Search Results
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 Google Search Data Provider.
-
Create Dynamic JobNimbus Grids Using the Infragistics XamDataGrid
Learn how you can connect JobNimbus to Infragistics XamDataGrid to build dynamic grids.
-
Configure the CData JDBC Driver for Dynamics 365 Business Central in a Connection Pool in Tomcat
Connect to Dynamics 365 Business Central data from a connection pool in Tomcat.
-
Build MVC Applications with Connectivity to Azure Synapse Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure Synapse from an ASP.NET MVC application.
-
Establish a Live Connection with Eventbrite Data using Tableau Bridge
The CData ODBC Driver for Eventbrite enables you to integrate live Eventbrite data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to ZohoPeople Data in RazorSQL
Connect to ZohoPeople from wizards and query ZohoPeople data from the GUI in the RazorSQL database management tool.
-
Automated Continuous MailChimp Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MailChimp data replication to OneLake in Microsoft Fabric.
-
Build SAS xpt-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAS xpt data and build web apps with connectivity to live SAS xpt data.
-
Connect to Google Sheets Data from PowerBuilder via JDBC
This article demonstrates how to access Google Sheets data from PowerBuilder using the Google Sheets JDBC Driver.
-
How to Connect to Adobe Experience Manager Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Adobe Experience Manager data. Leverage the pyodbc module for ODBC in Python.
-
Build Charts with Accelo Data in Clear Analytics
Create dynamic charts and perform analytics based on Accelo data in Clear Analytics.
-
Build a PostgreSQL Interface for ZohoPeople Data using the CData JDBC Driver
Use the Remoting features of the ZohoPeople JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Azure Synapse Data in HULFT Integrate
Connect to Azure Synapse as a JDBC data source in HULFT Integrate
-
View Reports on Real-Time Asana Data in Power BI Report Server
Use the CData ODBC Driver for Asana to visualize Asana data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Teamgate Data in Aqua Data Studio
Access Teamgate data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use Agno to Talk to Your OneNote 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 OneNote data for you.
-
DataBind Brex Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Brex data to a chart.
-
Write a Simple Go Application to work with Salesforce Data 360 Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Salesforce Data 360 data.
-
How to Access Google Drive Data Using Entity Framework
This article shows how to access Google Drive data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData Software ODBC Driver for MailChimp in MicroStrategy Desktop
Connect to MailChimp data in MicroStrategy Desktop using the CData Software ODBC Driver for MailChimp.
-
Connect Elasticsearch to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Elasticsearch with IBM WebSphere for seamless data integration and connectivity.
-
Integrate OpenWeatherMap with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate OpenWeatherMap with External Services.
-
Extract, Transform, and Load SAP Ariba Source Data in Informatica PowerCenter
Create a simple Workflow for SAP Ariba Source data in Informatica PowerCenter.
-
How to publish and share Salesforce Data 360 Data dashboards with Tableau Server
The CData ODBC driver for Salesforce Data 360 enables you integrate Salesforce Data 360 data into Tableau dashboards.
-
How to Seamlessly Import Coinbase Data into IBM SPSS Modeler
Integrate Coinbase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect Amazon QuickSight to SAS Data Sets Data
Create a connection to SAS Data Sets data in CData Connect AI and insert SAS Data Sets data into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Live Zoom Data in Excel 365 Online (Excel for the web)
Connect to Zoom data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Rebilly Data from MySQL in PHP
Connect to Rebilly through the standard MySQL libraries in PHP.
-
Build Automated Oracle SCM-Connected Workflows in Zapier
Use CData Connect AI to connect to live Oracle SCM data and build automated workflows in Zapier.
-
View Reports on Real-Time Codat Data in Power BI Report Server
Use the CData ODBC Driver for Codat to visualize Codat data in Power BI Desktop and then publish them to Power BI Report Server.
-
A PostgreSQL Interface for Hacker News Data using the CData ODBC Driver
Use the SQL Gateway and Hacker News ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Tanda Data in DBArtisan
Use wizards in DBArtisan to configure Tanda data as a data source.
-
Write a Simple Go Application to work with Oracle Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle data.
-
Access Live Bannerbear Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Bannerbear data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Rapidly Develop SAP HANA XS Advanced-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 SAP HANA XS Advanced.
-
Access Live Gong Data in Coginiti Pro
Connect to and query live Gong data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData JDBC Driver for Amazon Athena
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Amazon Athena.
-
Migrating data from Redis to Google BigQuery using CData SSIS Components.
Easily push Redis data to Google BigQuery using the CData SSIS Tasks for Redis and Google BigQuery.
-
Automated Continuous FHIR Replication to MySQL
Use CData Sync for automated, continuous, customizable FHIR replication to MySQL.
-
Create Reports from QuickBooks Time Data in Looker Studio
Use CData Connect AI to gain access to live QuickBooks Time data and create custom reports in Looker Studio.
-
Query Live Odoo 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 Odoo data directly from the development environment.
-
Connect to Real-Time Auth0 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Auth0 data in Power Apps.
-
How to create an RPA flow for Google Analytics Data in UiPath Studio
Use the Google Analytics ODBC Driver to create workflows that access real-time Google Analytics data without any coding.
-
How to Use a Microsoft Access Database to Update Cloudant Data in Real Time
Update Cloudant data by creating a linked table in Microsoft Access with the CData Cloudant ODBC Driver.
-
Build Elasticsearch Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Elasticsearch data and build visualizations in Tableau Cloud.
-
Create SSAS Tabular Models from PDFMonkey Data
How to build a SQL Server Analysis Service Tabular Model from PDFMonkey data using CData drivers.
-
Replicate VWO Data to Multiple Databases
Replicate VWO data to disparate databases with a point-and-click configuration.
-
Load Avaza Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Avaza data to a database.
-
Getting Started with the CData Power BI Connector for Humanity
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Connect to Demio Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Demio data. Leverage the pyodbc module for ODBC in Python.
-
Analyze Live PostgreSQL Data in SAS Viya
Use CData Connect AI to connect to PostgreSQL data from SAS Viya and deploy self-service analytics using live PostgreSQL data.
-
Automate Box Data Replication to SAP HANA
Use CData Sync to customize and automate Box data replication to SAP HANA.
-
How to Easily Query xBase Data in OpenOffice Base
Connect to xBase data in OpenOffice Base using the CData ODBC Driver for xBase and generate reports with live data insights.
-
Build Semantic Layer Views for MailerLite Data in APOS Live Data Gateway
Use the CData Connector for MailerLite in APOS Live Data Gateway to build Semantic Layer Views for MailerLite data.
-
Automated Continuous Gong Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Gong replication to AlloyDB.
-
Automated Continuous ShipEngine Replication to Databricks
Use CData Sync for automated, continuous, customizable ShipEngine replication to Databricks.
-
Query Pipedrive Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Pipedrive entities in PHP by modeling them as objects.
-
Use CData Connect AI to Access Xero Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Xero data in the Power Pivot business intelligence tool.
-
Create Reports with SendGrid Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SendGrid data.
-
Automated Continuous MongoDB Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MongoDB replication to AlloyDB.
-
Integrate Dify with Live QuickBooks Online Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live QuickBooks Online data.
-
Publish Redis-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Redis data.
-
Automate Supabase Data Replication to Couchbase
Use CData Sync to Customize and automate Supabase data replication to Couchbase.
-
Automated Continuous Salesforce Marketing Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to IBM DB2.
-
Access Live Lakebase Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Lakebase data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect to Live Exact Online Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Exact Online data securely in real time.
-
How to load ZendeskSell data into Elasticsearch via Logstash
Introducing a simple method to load ZendeskSell data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query TaxJar Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume TaxJar entities in PHP by modeling them as objects.
-
How to connect PolyBase to EmailOctopus
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live EmailOctopus data.
-
Getting Started with the CData ADO.NET Provider for ZohoPeople
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Getting Started with the CData ADO.NET Provider for MariaDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for MariaDB.
-
Connect to Splunk Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Splunk data.
-
Integrate Open WebUI with Live Bright Data Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Bright Data data from within the chat interface.
-
Build Oracle SCM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle SCM data and build web apps with connectivity to live Oracle SCM data.
-
Integrating GitHub Copilot with Missive 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.
-
Extract, Transform, and Load Sage 200 Data in Informatica PowerCenter
Create a simple Workflow for Sage 200 data in Informatica PowerCenter.
-
Access Live Teamwork Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Teamwork data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Klaviyo-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Klaviyo Data and create custom apps in Mendix.
-
Create Dynamics CRM-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Dynamics CRM Data from Klipfolio and build custom visualizations using live Dynamics CRM data.
-
Create a Data Access Object for Jira Assets Data using JDBI
A brief overview of creating a SQL Object API for Jira Assets data in JDBI.