CData Software - Knowledge Base
Recent Articles
-
Connecting GenSpark with GitHub Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to GitHub data without any replication or custom integration required.
-
Use the CData ODBC Driver for Exact Online in Microsoft Power Query
You can use the CData Exact Online ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Exact Online data into Microsoft Power Query.
-
Build Dashboards with Exact Online Data in Dundas BI
Create dynamic dashboards and perform analytics based on Exact Online data in Dundas BI.
-
Use the CData Software ODBC Driver for OneNote in MicroStrategy
Connect to OneNote data in MicroStrategy Developer using the CData Software ODBC Driver for OneNote.
-
Choosing the Best Method to Connect LightSpeedRetail to SQL Server: 5 Options Explained
Discover multiple ways to connect and use LightSpeedRetail data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Live SAP Fieldglass 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 SAP Fieldglass data from within the IDE.
-
Connect to ServiceNow Data in Google Apps Script via Connect AI
Use CData Connect AI to access ServiceNow data in Google Apps Script.
-
Use the CData Software JDBC Driver for ZendeskSell in MicroStrategy Web
Connect to ZendeskSell data in MicroStrategy Web using the CData Software JDBC Driver for ZendeskSell.
-
Connect to Sybase Data from a Connection Pool in JBoss
Integrate Sybase data into Java servlets: Use the Management Console in JBoss to install the Sybase JDBC Driver.
-
Publish Crystal Reports on SAP Hybris C4C Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Hybris C4C data.
-
Provide OData Services of QuickBooks Online Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for QuickBooks Online data by developing a WCF Service Application.
-
How to Visualize JotForm Data in Python with pandas
Use pandas and other modules to analyze and visualize live JotForm data in Python.
-
Automated Continuous AfterShip Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable AfterShip replication to Apache Kafka.
-
How to Connect the Power BI Service to Microsoft Teams: Complete Guide
Connect to the CData Software Power BI Connector for Microsoft Teams from PowerBI.com to provide real-time Microsoft Teams data across the organization.
-
Seamlessly Bring FreshBooks Data into Retool Using CData Connect AI
Integrate FreshBooks data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Create Data Visualizations in Cognos BI with SAP SuccessFactors LMS Data
Access SAP SuccessFactors LMS data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to create an RPA flow for Perplexity Data in UiPath Studio
Use the Perplexity ODBC Driver to create workflows that access real-time Perplexity data without any coding.
-
Connect to ChargeOver Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ChargeOver data in the Denodo Virtual DataPort Administrator.
-
Query Avro Data as a SQL Server Database in Node.js
Execute SQL Server queries against Avro data from Node.js.
-
Use Biml to Build SSIS Tasks to Replicate Xero Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Xero data to SQL Server.
-
Connect to Clockify Data in JRuby
Create a simple JRuby app with access to live Clockify data.
-
Easily Integrate QuickBooks Online Data in Lazarus Pascal IDE
Learn how to easily integrate live QuickBooks Online data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Replicate SendPulse Data from PowerShell
Write a quick PowerShell script to query SendPulse data. Use connectivity to the live data to replicate SendPulse data to SQL Server.
-
Connect and Query Live Klaviyo Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Klaviyo data into Databricks and enable direct, live querying and analysis without replication.
-
Provide OData Services of Avaza Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Avaza data by developing a WCF Service Application.
-
Bridge Microsoft Exchange Connectivity with Apache NiFi
Access and process Microsoft Exchange data in Apache NiFi using the CData JDBC Driver.
-
Build Apps with Live SageHR data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SageHR data into the Adalo platform and build custom mobile and web applications with real-time SageHR data.
-
Use the CData Software JDBC Driver for Mixpanel in MicroStrategy Web
Connect to Mixpanel data in MicroStrategy Web using the CData Software JDBC Driver for Mixpanel.
-
How to Connect Flowise AI Agents to Live Sendwithus 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 Sendwithus data without replication.
-
Connecting Pipedream with Microsoft OneDrive Data 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 Microsoft OneDrive data in real time.
-
How to Query SAS Data Sets Data in MySQL Workbench
Execute MySQL queries against live SAS Data Sets data from MySQL Workbench.
-
How to Easily Query ClickUp Data in OpenOffice Base
Connect to ClickUp data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Live Azure Synapse Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure Synapse data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Prepare, Blend, and Analyze SAP BusinessObjects BI Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP BusinessObjects BI data for self-service data analytics.
-
Create MessageBird Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MessageBird from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build AlloyDB-Connected Apps in Choreo
Use CData Connect AI to connect to AlloyDB Data from Choreo and build custom apps using live AlloyDB data.
-
Object-Relational Mapping (ORM) with Jira Assets Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Jira Assets data into a Java-based ORM framework, Hibernate.
-
Create Reports with Wave Financial Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Wave Financial data.
-
Import Real-Time Google Ad Manager Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Ad Manager data in ColdFusion.
-
Use the CData Software JDBC Driver for HCL Domino in MicroStrategy
Connect to HCL Domino data in MicroStrategy Developer using the CData Software JDBC Driver for HCL Domino.
-
Prepare, Blend, and Analyze SendInBlue Data in Alteryx Designer (ODBC)
Build workflows to access live SendInBlue data for self-service data analytics.
-
Automated Continuous Typeform Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Typeform replication to delimited files (CSV/TSV).
-
How to Access Live SAP Hybris C4C Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Hybris C4C enables you to integrate SAP Hybris C4C data into workflows built using Microsoft Power Automate Desktop.
-
How to Use a Microsoft Access Database to Update Pipedrive Data in Real Time
Update Pipedrive data by creating a linked table in Microsoft Access with the CData Pipedrive ODBC Driver.
-
Automated Continuous Confluence Replication to MongoDB
Use CData Sync for automated, continuous, customizable Confluence replication to MongoDB.
-
Connect to CapsuleCRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for CapsuleCRM to connect to CapsuleCRM data from Web applications running on WebLogic.
-
Integrating Boomi Agentstudio with SQL Server Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SQL Server data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Dashboards with Dynamics 365 Data in DBxtra
Create dynamic dashboards and perform analytics based on Dynamics 365 data in DBxtra.
-
Migrating data from FreshBooks to Google BigQuery using CData SSIS Components.
Easily push FreshBooks data to Google BigQuery using the CData SSIS Tasks for FreshBooks and Google BigQuery.
-
Getting Started with the CData Python Connector for ZohoDesk
Learn to install and license the CData Python Connector and configure a connection to live ZohoDesk data.
-
Deploy the ADO.NET Provider for Splunk on an SSRS Report Server
Connect to Splunk 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 Real-Time Google Analytics Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Analytics and Dataflow to import and use Google Analytics data in Power Apps.
-
Automate Oracle Financials Cloud Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Oracle Financials Cloud data from PowerShell? This article demonstrates how to utilize the Oracle Financials Cloud Cmdlets for tasks like connecting to Oracle Financials Cloud data, automating operations, downloading data, and more.
-
Connect to Google Drive Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Drive data.
-
Connect to FreeAgent 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 FreeAgent and work with FreeAgent data in your FileMaker application.
-
Validate Discord Data with QuerySurge
Access and validate Discord data in QuerySurge using the CData JDBC Driver.
-
Using the CData Software ODBC Driver for Greenplum in PyCharm
Connect to Greenplum as an ODBC data source in PyCharm using the CData Software ODBC Driver for Greenplum.
-
Build Automated Freshservice-Connected Workflows in Zapier
Use CData Connect AI to connect to live Freshservice data and build automated workflows in Zapier.
-
Integrate with Oracle Sales Data in JReport Designer
Create charts and reports based on Oracle Sales data in JReport Designer.
-
Integrate Google's Antigravity Agent with Live Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Bullhorn CRM data using the Model Context Protocol.
-
Automated Continuous iContact Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable iContact replication to Azure SQL Database.
-
Automated Continuous AlloyDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable AlloyDB replication to Google Cloud SQL.
-
Feed GraphQL Data into FineReport
How to set GraphQL data as a JDBC data source in FineReport.
-
Visualize Shopify 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 Shopify data into TIBCO Spotfire.
-
LINQ to MailerLite 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 MailerLite Data Provider.
-
How to connect to Adobe Experience Manager Data with Squirrel SQL client
Connect to Adobe Experience Manager data and execute queries in the Squirrel SQL Client.
-
Build Presto Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Presto data and build visualizations in Tableau.
-
Build Apps with Live Microsoft Entra ID data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Microsoft Entra ID data into the Adalo platform and build custom mobile and web applications with real-time Microsoft Entra ID data.
-
Create Datasets from Apollo in Domo Workbench and Build Visualizations of Apollo Data in Domo
Use the CData Software ODBC Driver for Apollo to create datasets from Apollo data in Domo Workbench and then build visualizations in the Domo service.
-
Integrating Kiro with Cassandra 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 Semantic Layer Views for Mode Data in APOS Live Data Gateway
Use the CData Connector for Mode in APOS Live Data Gateway to build Semantic Layer Views for Mode data.
-
Automated Continuous Copper Replication to SingleStore
Use CData Sync for automated, continuous, customizable Copper replication to SingleStore.
-
Build Semantic Layer Views for SparkPost Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SparkPost data.
-
Connect to Avaza Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Avaza data using standard SQL.
-
How to Connect to Live Sugar CRM Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Sugar CRM data through natural language.
-
Build Samanage-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Samanage Data and create custom apps in Mendix.
-
Connect to Reckon Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Reckon to connect to Reckon data and execute queries in PowerBuilder.
-
Connect to Azure Table Data in CloverDX (formerly CloverETL)
Transfer Azure Table data using the visual workflow in the CloverDX data integration tool.
-
Create Azure Data Catalog-Connected Nintex Workflows
Use CData Connect AI to connect to Azure Data Catalog Data from Nintex Workflow Cloud and build custom workflows using live Azure Data Catalog data.
-
Manage Redis Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Redis.
-
Visualize Live ZohoMarketingHub Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZohoMarketingHub data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Write a Simple Go Application to work with Tavily Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Tavily data.
-
Create a Data Access Object for ScrapingBee Data using JDBI
A brief overview of creating a SQL Object API for ScrapingBee data in JDBI.
-
Visualize FormSite Data in TIBCO Spotfire through ADO.NET
Integrate FormSite data into dashboards in TIBCO Spotfire.
-
Import and Visualize Bannerbear Data in Power View
Create data visualizations based on Bannerbear data in Excel.
-
Build Hive Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Hive data and build visualizations in Tableau.
-
Automated Continuous Redis Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Redis data replication to OneLake in Microsoft Fabric.
-
How to update Dynamics CRM from Excel
This article explains how to transfer data from Excel to Dynamics CRM using the Excel Add-In for Dynamics CRM.
-
Access Zoho Projects Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho Projects data from your Oracle system.
-
Connect to GitHub Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live GitHub data from Filemaker Pro on Mac.
-
Access Google Contacts Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Contacts data from HeidiSQL.
-
DataBind Controls to ZohoInvoice Data in Delphi
DataBind to ZohoInvoice data in Delphi with standard data access components and controls.
-
How to connect to Quaderno Data from Spring Boot
Connect to Quaderno in a Spring Boot Application using the CData API Driver for JDBC
-
Create Reports with Productboard Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Productboard data.
-
How to connect to Simplesat Data with Squirrel SQL client
Connect to Simplesat data and execute queries in the Squirrel SQL Client.
-
Rapidly Develop Exact Online-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 Exact Online.
-
Create Data Visualizations in Cognos BI with Sage 300 Data
Access Sage 300 data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Google Sheets Data in AWS Lambda
Connect to live Google Sheets data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Clockify Replication to Oracle
Use CData Sync for automated, continuous, customizable Clockify replication to Oracle.
-
Connecting Mastra with ServiceNow 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 ServiceNow data, no replication required.