CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SharePoint Excel Services Replication to SQLite
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to SQLite.
-
How to Query Live Recurly Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Recurly data data in natural language using Python.
-
Use Microsoft Copilot Studio to talk to your SuiteCRM 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 SuiteCRM data for you.
-
How to work with Webex Data in Apache Spark using SQL
Access and process Webex Data in Apache Spark using the CData Software JDBC Driver.
-
Build Visualizations of Freshteam Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Freshteam data in Birst.
-
How to connect to MailChimp Data with Squirrel SQL client
Connect to MailChimp data and execute queries in the Squirrel SQL Client.
-
Excel Spreadsheet Automation on Printify Data with the QUERY Formula
Pull data from Printify, automate spreadsheets, and more with the QUERY formula.
-
Use Microsoft Copilot Studio to talk to your FreshBooks 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 FreshBooks data for you.
-
Integrate Live PingOne 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 PingOne data from within the IDE.
-
Publish Crystal Reports on Everhour Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Everhour data.
-
Create Tanda Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Tanda from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Access Live Google Forms Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Forms enables you to integrate Google Forms data into workflows built using Microsoft Power Automate Desktop.
-
Import Real-Time Salesforce Pardot Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesforce Pardot data in ColdFusion.
-
Publish Wrike-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Wrike data.
-
Access Live Active Directory Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Active Directory data from your Excel spreadsheets.
-
Build Dashboards with Redis Data in DBxtra
Create dynamic dashboards and perform analytics based on Redis data in DBxtra.
-
Model Azure Data Catalog Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Azure Data Catalog, enabling the direct import of real-time Azure Data Catalog data.
-
Integrating Nuclia Data in Talend Cloud Data Management Platform
Connect Nuclia Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Google Ad Manager Data from a Connection Pool in JBoss
Integrate Google Ad Manager data into Java servlets: Use the Management Console in JBoss to install the Google Ad Manager JDBC Driver.
-
DataBind Rootly Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Rootly data to a chart.
-
Import Real-Time Act-On Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Act-On data in ColdFusion.
-
Access Live Google Analytics Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Analytics data from your Excel spreadsheets.
-
Getting Started with the CData SSIS Components for SAP Netweaver Gateway
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Netweaver Gateway.
-
Connect to Sage 200 Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Sage 200 data using standard SQL.
-
Add Invoiced Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Invoiced with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Calendly Data in RazorSQL
Connect to Calendly from wizards and query Calendly data from the GUI in the RazorSQL database management tool.
-
Analyze Live JSON Services in SAS Viya
Use CData Connect AI to connect to JSON services from SAS Viya and deploy self-service analytics using live JSON services.
-
Connect Excel Online Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Excel Online data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Live SAP SuccessFactors 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 SAP SuccessFactors data without replication.
-
Use the CData Software ODBC Driver for LinkedIn in MicroStrategy Web
Connect to LinkedIn data in MicroStrategy Web using the CData Software ODBC Driver for LinkedIn.
-
Work with ZohoPeople Data in FoxPro
Load ZohoPeople data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating LangGraph with AgileCRM Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on AgileCRM data within automated workflows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Excel Online
Provide connectivity to Excel Online data through an SAP BusinessObjects universe.
-
Use the CData ODBC Driver for Qualaroo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Qualaroo to connect to Qualaroo data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Qualaroo data in Excel.
-
Analyze Stripe Data in Cognos Analytics
Use CData Connect AI to connect to Stripe Data from Cognos Analytics and analyze live Stripe data.
-
Use the CData ODBC Driver for Certinia in Microsoft Power Query
You can use the CData Certinia ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Certinia data into Microsoft Power Query.
-
Integrating Claude Code with GraphQL Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on GraphQL data within assisted coding and automated development workflows.
-
Build Apps with Live SAP Business Warehouse data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Business Warehouse data into the Adalo platform and build custom mobile and web applications with real-time SAP Business Warehouse data.
-
Query HBase Data in DataGrip
Create a Data Source for HBase in DataGrip and use SQL to query live HBase data.
-
Use Microsoft Copilot Studio to talk to your Act CRM 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 Act CRM data for you.
-
Create Data Visualizations Based On Google Search Results in Mode
Use CData Connect AI to connect to Google Search Results from Mode and build visualizations using live Google Search results.
-
Choosing the Best Method to Connect Mistral AI to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Mistral AI data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Adobe Commerce Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Apache Cassandra.
-
Establish a Live Connection with JobNimbus Data using Tableau Bridge
The CData ODBC Driver for JobNimbus enables you to integrate live JobNimbus data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Okta Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Okta data and build visualizations in Tableau Cloud.
-
Connect to Coda Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Coda data in the Denodo Virtual DataPort Administrator.
-
ScrapingBee Reporting in OBIEE with the ScrapingBee JDBC Driver
Deploy the ScrapingBee JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build a PostgreSQL Interface for Salesloft Data using the CData JDBC Driver
Use the Remoting features of the Salesloft JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect PolyBase to Sage Cloud Accounting
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sage Cloud Accounting data.
-
Connect to Oracle Data from a Connection Pool in Jetty
The Oracle JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle data from Web apps in Jetty.
-
Visualize Customer.io Data in Tableau
The CData ODBC driver for Customer.io enables you integrate Customer.io data into Tableau dashboards.
-
Connect to Microsoft Exchange Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Exchange data.
-
Import Real-Time ScrapingBee Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ScrapingBee data in ColdFusion.
-
Import and Visualize SAS xpt Data in Power View
Create data visualizations based on SAS xpt data in Excel.
-
Access Live Salesforce Marketing Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Salesforce Marketing data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate Adobe Target Data Replication to SAP HANA
Use CData Sync to customize and automate Adobe Target data replication to SAP HANA.
-
How to connect to Nethunt Data from Spring Boot
Connect to Nethunt in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Cosmos DB Data in JRuby
Create a simple JRuby app with access to live Cosmos DB data.
-
Use the CData Software ODBC Driver for Customer.io in MicroStrategy Web
Connect to Customer.io data in MicroStrategy Web using the CData Software ODBC Driver for Customer.io.
-
Automated Continuous Jira Replication to Vertica
Use CData Sync for automated, continuous, customizable Jira replication to Vertica.
-
Automated Continuous Twilio Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Twilio replication to Apache Cassandra.
-
Create Pinecone Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Pinecone data access from reports, embedded analytics, and more.
-
Connect to Shopify Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Shopify and the SQL Gateway to access Shopify data from Google Apps Script.
-
Getting Started with the CData ADO.NET Provider for Pinterest
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Pinterest.
-
Build MVC Applications with Connectivity to Redshift Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Redshift from an ASP.NET MVC application.
-
Integrate Live FreshBooks Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to FreshBooks from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live FreshBooks data.
-
Prepare, Blend, and Analyze Spotify Data in Alteryx Designer (ODBC)
Build workflows to access live Spotify data for self-service data analytics.
-
Working with iContact Data in LINQPad
Execute LINQ queries to iContact data in LINQPad.
-
Query CampaignMonitor Data in DataGrip
Create a Data Source for CampaignMonitor in DataGrip and use SQL to query live CampaignMonitor data.
-
DataBind Charts to ZohoPeople Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZohoPeople 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.
-
Create Splunk-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Splunk Data from OutSystems and build custom enterprise apps using live Splunk data.
-
DataBind Controls to ServiceNow Data in C++Builder
DataBind to ServiceNow data in C++Builder with standard components and controls.
-
Visualize LaunchDarkly 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 LaunchDarkly data into TIBCO Spotfire.
-
Import YouTube Analytics Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to YouTube Analytics Data and provide access to live YouTube Analytics data for custom reports in the Power BI Service.
-
Integrating Claude Code CLI with QuickBooks Time 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 HelloSign to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HelloSign with IBM WebSphere for seamless data integration and connectivity.
-
Replicate Google Spanner Data from PowerShell
Write a quick PowerShell script to query Google Spanner data. Use connectivity to the live data to replicate Google Spanner data to SQL Server.
-
Viewing Zuora Data in RAD Studio Data Explorer
How to view Zuora data in RAD Studio Data Explorer using the CData ODBC Driver for Zuora.
-
Connect to Pushbullet Data in RazorSQL
Connect to Pushbullet from wizards and query Pushbullet data from the GUI in the RazorSQL database management tool.
-
Wave Financial Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Wave Financial facts in real time.
-
Getting Started with the CData Power BI Connector for Wave Financial
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Wave Financial.
-
Consume Google Campaign Manager 360 OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Campaign Manager 360 feeds that reflect any changes in SAP Lumira.
-
Build Apps with Live Planio Data Using the Low-Code Development Platform of Mendix
Connect Planio data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Amazon Marketplace Data in CloverDX (formerly CloverETL)
Transfer Amazon Marketplace data using the visual workflow in the CloverDX data integration tool.
-
Rapidly Develop SendInBlue-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 SendInBlue.
-
Create Data Visualizations in Cognos BI with GraphQL Data
Access GraphQL data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to ConstantContact Data in RazorSQL
Connect to ConstantContact from wizards and query ConstantContact data from the GUI in the RazorSQL database management tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Discord
Provide connectivity to Discord data through an SAP BusinessObjects universe.
-
Access Live Tally Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Tally data from your Excel spreadsheets.
-
Consume Salesforce Marketing OData Feeds in PowerBuilder
This article demonstrates how to consume Salesforce Marketing data as OData feeds from PowerBuilder using the API Server.
-
Load Impala Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Impala data to a database.
-
How to create Visio diagrams from Amazon Athena Data
Automatically update Amazon Athena data with the changes you make to Visio master shapes.
-
Build Voice Agents in ElevenLabs with access to Live NetSuite SuiteAnalytics Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live NetSuite SuiteAnalytics data.
-
Access Live Google Analytics Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Analytics data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use Agno to Talk to Your MySQL 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 MySQL data for you.
-
How to Build an ETL App for AlloyDB Data in Python with CData Connect AI
Build ETL pipelines that read and write live AlloyDB data in Python with petl and the CData Connect AI Python SDK.
-
Connect to SharePoint Excel Services Data in RazorSQL
Connect to SharePoint Excel Services from wizards and query SharePoint Excel Services data from the GUI in the RazorSQL database management tool.
-
Use Manus AI to Talk to Your Supabase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Supabase data.
-
Create Dashboards and Visualize Live Amazon Athena Data in Geckoboard
Use CData Connect AI to connect to live Amazon Athena data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automate Placid Data Replication to Azure Data Lake
Use CData Sync to customize and automate Placid data replication to Azure Data Lake.