CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for HubSpot in MicroStrategy Desktop
Connect to HubSpot in MicroStrategy Desktop using the CData Software ODBC Driver for HubSpot.
-
Consume Spark OData Feeds in PowerBuilder
This article demonstrates how to consume Apache Spark SQL as OData feeds from PowerBuilder using the API Server.
-
Access Live Reckon Accounts Hosted Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Reckon Accounts Hosted from your Google Sheets.
-
Getting Started with the CData Python Connector for Google Translate
Learn to install and license the CData Python Connector
-
Query Onfleet Data as a MySQL Database in Node.js
Execute MySQL queries against Onfleet from Node.js.
-
Easily Integrate YouTube Analytics Data in Lazarus Pascal IDE
Learn how to easily integrate live YouTube Analytics in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Data Visualizations in Cognos BI with Webflow Data
Access Webflow as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Factorial
Provide connectivity to Factorial through an SAP BusinessObjects universe.
-
Integrate Live Tally Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Tally ERP and integrate live Tally ERP into apps built in Microsoft Power Apps.
-
How to Query Live Excel Online Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Excel Online data in natural language using Python.
-
Visualize Live Freshteam Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Freshteam using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live Azure Table Data in the Power BI Service
Use CData Connect AI to connect to live Azure Table Storage and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to FormSite Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Amplitude Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Amplitude in the Denodo Virtual DataPort Administrator.
-
Build SQL Analysis Services-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SQL Analysis Services to explore live SQL Analysis Services Data in GitHub Copilot to assist with building SQL Analysis Services-powered applications.
-
Access Salesforce Pardot Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Salesforce Pardot from your Oracle system.
-
Analyze Google Forms Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Forms with the CData JDBC Driver for Google Forms.
-
Create QuickBooks Online-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to QuickBooks Online Data from Klipfolio and build custom visualizations using live QuickBooks Online.
-
Integrating LlamaIndex with Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Marketo in real time.
-
Integrating Google Translate Data in Talend Cloud Data Management Platform
Connect Google Translate Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Microsoft Ads Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Ads using standard SQL.
-
Create Informatica Mappings From/To an ODBC Data Source for SharePoint
Create an ODBC connection to SharePoint in Informatica and browse and transfer Microsoft SharePoint.
-
Analyze Elorus Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Elorus with the CData JDBC Driver for Elorus.
-
Integrate with live SAP Business One Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP Business One in Jitterbit.
-
Build an OLAP Cube in SSAS from Google Spanner Data
Establish a connection to Google Spanner data from SQL Server Analysis Services, and use the Google Spanner Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Design Box Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Box from mobile and tablet Power Apps.
-
Connect to Bright Data in SpagoBI
Create reports featuring live Bright Data in SpagoBI Studio. Host Bright Data reports on SpagoBI Server.
-
Operational Reporting on Wave Financial Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Wave Financial.
-
How to load Hive data into Elasticsearch via Logstash
Introducing a simple method to load Hive data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Oracle SCM Replication to Databricks
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Databricks.
-
Connect to Dynamics NAV Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Dynamics NAV as a data source.
-
Create Raisers Edge NXT-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Raisers Edge NXT Data from OutSystems and build custom enterprise apps using live Raisers Edge NXT.
-
Process & Analyze FHIR Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live FHIR Data.
-
Use the CData ODBC Driver for SAP HANA from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP HANA to connect to SAP HANA from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP HANA in Excel.
-
How to connect and process xBase from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live xBase.
-
Build Apps with Live Cosmos DB Data Using the Low-Code Development Platform of Mendix
Connect Azure Cosmos DB with Mendix to build apps using the CData JDBC Driver for Cosmos DB.
-
Integrate Live Pipeline CRM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Pipeline CRM to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate ZohoPeople Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZohoPeople from Informatica Cloud.
-
Build an OLAP Cube in SSAS from Dotmailer Data
Establish a connection to Dotmailer data from SQL Server Analysis Services, and use the Dotmailer Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Redis-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Redis Data and create custom apps in Bubble.
-
Rapidly Develop Jodoo-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 Jodoo.
-
Access Live Google Spanner Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Spanner from your Excel spreadsheets.
-
Build an OLAP Cube in SSAS from Phoenix Data
Establish a connection to Apache Phoenix data from SQL Server Analysis Services, and use the Phoenix Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access SQL Analysis Services Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SQL Analysis Services from HeidiSQL.
-
Access Live Amazon DynamoDB Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Amazon DynamoDB into the statistical analysis tools available in SAS JMP. This article shows how to use Amazon DynamoDB in the Graph Builder and Query Builder.
-
DataBind Mocean Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Mocean to a chart.
-
Connect to Microsoft Planner Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Planner.
-
LINQ to CircleCI 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 CircleCI Data Provider.
-
Add Authorize.Net Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Authorize.Net with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to GraphQL Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for GraphQL and the Script function in FileMaker Pro to connect to GraphQL and work with GraphQL in your FileMaker application.
-
Integrate Live Facebook Ads Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Facebook Ads and integrate live Facebook Ads into apps built in Microsoft Power Apps.
-
Consume MongoDB OData Feeds in PowerBuilder
This article demonstrates how to consume MongoDB as OData feeds from PowerBuilder using the API Server.
-
Visualize SpaceX Data in Tableau
The CData ODBC driver for SpaceX enables you integrate SpaceX into Tableau dashboards.
-
How to Visualize Microsoft Dataverse 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 Microsoft Dataverse (CDS) in Python.
-
Create Power BI Reports on Real-Time Sage Cloud Accounting Data
Use the CData ODBC Driver for Sage Cloud Accounting to visualize Sage Business Cloud Accounting in Power BI Desktop.
-
Create Anaplan Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Anaplan from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software ODBC Driver for Clockify in MicroStrategy Web
Connect to Clockify in MicroStrategy Web using the CData Software ODBC Driver for Clockify.
-
How to connect PolyBase to Pinecone
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Pinecone.
-
Integrating Claude Code CLI with Parallel 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.
-
Automate Sage Cloud Accounting Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sage Business Cloud Accounting from PowerShell? This article demonstrates how to utilize the Sage Cloud Accounting Cmdlets for tasks like connecting to Sage Business Cloud Accounting, automating operations, downloading data, and more.
-
Visualize YouTube Analytics Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to YouTube Analytics.
-
How to update Greenplum from Excel
This article explains how to transfer data from Excel to Greenplum using the Excel Add-In for Greenplum.
-
Automate QuickBooks Online Data Replication to Azure Data Lake
Use CData Sync to customize and automate QuickBooks Online replication to Azure Data Lake.
-
Import Real-Time Bannerbear Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Bannerbear in ColdFusion.
-
Model, Search, and Visualize Live Twilio Data in ThoughtSpot
Use CData Connect AI to connect to live Twilio for modeling, searching, and visualizing.
-
Integrating Boomi Agentstudio with SingleStore Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SingleStore, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData Software JDBC Driver for ZohoMarketingHub in MicroStrategy Desktop
Connect to ZohoMarketingHub in MicroStrategy Desktop using the CData Software JDBC Driver for ZohoMarketingHub.
-
Provide OData Services of SurveyMonkey Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SurveyMonkey by developing a WCF Service Application.
-
Integrate Live Greenplum Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Greenplum from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Pivotal GreenPlum.
-
Query, Visualize, and Share live Google Search Results in Redash
Use CData Connect AI to connect to live Google Search in Redash for querying, visualizing, and sharing.
-
Visualize Freshdesk Data in Tableau
The CData ODBC driver for Freshdesk enables you integrate Freshdesk into Tableau dashboards.
-
Analyze Oracle Sales Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Oracle Sales and visualize live Oracle Sales in Infragistics Reveal.
-
Build Apps with Live REST Data Using the Low-Code Development Platform of Mendix
Connect REST with Mendix to build apps using the CData JDBC Driver for REST.
-
Use the CData Software ODBC Driver for LionDesk in MicroStrategy
Connect to LionDesk in MicroStrategy Developer using the CData Software ODBC Driver for LionDesk.
-
Choosing the Best Method to Connect Apify to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apify from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Write a Simple Go Application to work with Discord Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Discord.
-
Design BIRT Reports on OpenWeatherMap Data
Provide current OpenWeatherMap to your embedded analytics.
-
Query Adobe Experience Manager Data as a MySQL Database in Node.js
Execute MySQL queries against Adobe Experience Manager from Node.js.
-
Integrate Live Smartsheet Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Smartsheet from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Smartsheet.
-
How to publish and share PhantomBuster Data dashboards with Tableau Server
The CData ODBC driver for PhantomBuster enables you integrate PhantomBuster into Tableau dashboards.
-
Build Charts with Power BI XMLA Data in Clear Analytics
Create dynamic charts and perform analytics based on Power BI XMLA in Clear Analytics.
-
Validate SAP Concur Data with QuerySurge
Access and validate SAP Concur in QuerySurge using the CData JDBC Driver.
-
Natively Connect to FormSite Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to FormSite. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Wrike in MicroStrategy Desktop
Connect to Wrike in MicroStrategy Desktop using the CData Software JDBC Driver for Wrike.
-
Connect to Greenhouse Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Greenhouse Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Seamlessly Import Todoist Data into IBM SPSS Modeler
Integrate Todoist data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Design BIRT Reports on Copper Data
Provide current Copper to your embedded analytics.
-
Build MVC Applications with Connectivity to Superchat Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Superchat from an ASP.NET MVC application.
-
How to load MarkLogic data into Elasticsearch via Logstash
Introducing a simple method to load MarkLogic data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating GitHub Copilot CLI with Factorial 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.
-
DataBind Controls to Reckon Accounts Hosted Data in Delphi
DataBind to Reckon Accounts Hosted in Delphi with standard data access components and controls.
-
Build AI/ML Models with Live Mouseflow Data using Dataiku
Connect Mouseflow Data with Dataiku using the CData API Driver for JDBC.
-
Access Live Lakebase Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Lakebase in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate with live Active Directory Data in Jitterbit
Use CData Connect AI to connect to and integrate live Active Directory in Jitterbit.
-
How to Easily Query XML Data in OpenOffice Base
Connect to XML data in OpenOffice Base using the CData ODBC Driver for XML and generate reports with live data insights.
-
Integrating Antigravity CLI with SingleStore via CData CLI
Connect SingleStore to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to SharePoint Excel Services Data in Jaspersoft Studio
Execute SQL to remote SharePoint Excel Services in Jaspersoft Studio.
-
Connect to MySQL Data in Ruby
Connect to MySQL in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Manage HubSpot Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for HubSpot.
-
LINQ to Excel Online 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 Excel Online Data Provider.