CData Software - Knowledge Base

Recent Articles

---

• «
• 401
• 402
• 403
• 404
• 405
• 406
• 407
• 408
• 409
• 410
• »

• Choosing the Best Method to Connect LightSpeedRetail to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use LightSpeedRetail 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

• Connect to ServiceNow Data in Google Apps Script via Connect AI

  Use CData Connect AI to access ServiceNow in Google Apps Script.

• Use the CData Software JDBC Driver for ZendeskSell in MicroStrategy Web

  Connect to ZendeskSell in MicroStrategy Web using the CData Software JDBC Driver for ZendeskSell.

• Connect to Sybase Data from a Connection Pool in JBoss

  Integrate Sybase 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.

• 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 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 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 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 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 without any coding.

• Connect to ChargeOver Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for ChargeOver in the Denodo Virtual DataPort Administrator.

• Query Avro Data as a SQL Server Database in Node.js

  Execute SQL Server queries against Apache Avro from Node.js.

• Automated Continuous LionDesk Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable LionDesk replication to PostgreSQL.

• 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 Accounting to SQL Server.

• Connect to Clockify Data in JRuby

  Create a simple JRuby app with access to live Clockify.

• Easily Integrate QuickBooks Online Data in Lazarus Pascal IDE

  Learn how to easily integrate live QuickBooks Online 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. Use connectivity to the live data to replicate SendPulse to SQL Server.

• Connect and Query Live Klaviyo Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Klaviyo into Databricks

• 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 by developing a WCF Service Application.

• Bridge Microsoft Exchange Connectivity with Apache NiFi

  Access and process Microsoft Exchange in Apache NiFi using the CData JDBC Driver.

• Use the CData Software JDBC Driver for Mixpanel in MicroStrategy Web

  Connect to Mixpanel in MicroStrategy Web using the CData Software JDBC Driver for Mixpanel.

• 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 from MySQL Workbench.

• How to Query Live Zoho Projects Data in Perplexity MacOS Desktop

  Connect to and query live Zoho Projects Data in Perplexity Desktop using CData MCP Server.

• 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.

• Build Google Ads-Powered Applications in Claude Code with CData MCP Server

  Use the CData MCP Server for Google Ads to explore live Google Ads Data in Claude Code to assist with building Google Ads-powered applications.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed xBase to Power BI dashboards. Simply drag and drop xBase into data visuals on the Power BI canvas.

• Access Live Azure Synapse Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Azure Synapse 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 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 Google AlloyDB.

• 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 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.

• 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 in ColdFusion.

• Use the CData Software JDBC Driver for HCL Domino in MicroStrategy

  Connect to HCL Domino 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 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 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 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 Microsoft SQL Server, 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 Microsoft Dynamics 365 in DBxtra.

• Migrating data from FreshBooks to Google BigQuery using CData SSIS Components.

  Easily push FreshBooks 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

• Deploy the ADO.NET Provider for Splunk on an SSRS Report Server

  Connect to Splunk 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 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 from PowerShell? This article demonstrates how to utilize the Oracle Financials Cloud Cmdlets for tasks like connecting to Oracle Financials Cloud, 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.

• 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 in your FileMaker application.

• Validate Discord Data with QuerySurge

  Access and validate Discord 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 and build automated workflows in Zapier.

• Integrate with Oracle Sales Data in JReport Designer

  Create charts and reports based on Oracle Sales in JReport Designer.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Bullhorn CRM 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 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 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 and execute queries in the Squirrel SQL Client.

• Build Presto Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Presto and build visualizations in Tableau.

• Build Apps with Live Microsoft Entra ID in Adalo using CData Connect AI

  Use CData Connect AI to integrate live Microsoft Entra ID into the Adalo platform and build custom mobile and web applications with real-time Microsoft Entra ID.

• 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 in Domo Workbench and then build visualizations in the Domo service.

• Integrating Kiro CLI 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.

• Automated Continuous Copper Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Copper replication to SingleStore.

• Connect to Avaza Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Avaza 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 through natural language.

• Connect to Reckon Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Reckon to connect to Reckon and execute queries in PowerBuilder.

• Connect to Azure Table Data in CloverDX (formerly CloverETL)

  Transfer Azure Table Storage using the visual workflow in the CloverDX data integration tool.

• 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 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.

• Create a Data Access Object for ScrapingBee Data using JDBI

  A brief overview of creating a SQL Object API for ScrapingBee in JDBI.

• Visualize FormSite Data in TIBCO Spotfire through ADO.NET

  Integrate FormSite into dashboards in TIBCO Spotfire.

• Import and Visualize Bannerbear Data in Power View

  Create data visualizations based on Bannerbear in Excel.

• Build Hive Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Apache Hive and build visualizations in Tableau.

• Automated Continuous Redis Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Redis 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 from your Oracle system.

• Connect to GitHub Data from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live GitHub 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 from HeidiSQL.

• DataBind Controls to ZohoInvoice Data in Delphi

  DataBind to ZohoInvoice 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.

• How to connect to Simplesat Data with Squirrel SQL client

  Connect to Simplesat 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.

• Integrating Antigravity CLI with Delighted via CData CLI

  Connect Delighted to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Create Data Visualizations in Cognos BI with Sage 300 Data

  Access Sage 300 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 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, no replication required.

• Automated Continuous Asana Replication to MySQL

  Use CData Sync for automated, continuous, customizable Asana replication to MySQL.

• How to Work with Office 365 Data in ETL Validator JDBC

  Connect to Office 365 from ETL Validator jobs using the CData Software JDBC Driver.

• How to Visualize ActiveCampaign Data in Python with pandas via CData Connect AI

  Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live ActiveCampaign in Python.

• Getting Started with the CData ADO.NET Provider for Insightly

  Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.

• «
• 401
• 402
• 403
• 404
• 405
• 406
• 407
• 408
• 409
• 410
• »