CData Software - Knowledge Base
Recent Articles
-
Object-Relational Mapping (ORM) with BenchmarkEmail 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 BenchmarkEmail into a Java-based ORM framework, Hibernate.
-
Build Visualizations of SharePoint Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft SharePoint in Birst.
-
Use the CData Software JDBC Driver for Microsoft Dataverse in MicroStrategy Desktop
Connect to Microsoft Dataverse (CDS) in MicroStrategy Desktop using the CData Software JDBC Driver for Microsoft Dataverse.
-
Use the CData Software ODBC Driver for Cohere in MicroStrategy
Connect to Cohere in MicroStrategy Developer using the CData Software ODBC Driver for Cohere.
-
Automated Continuous Confluence Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Confluence replication to IBM DB2.
-
Automated Continuous Google Campaign Manager 360 Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to SingleStore.
-
How to create an RPA flow for Google Directory Data in UiPath Studio
Use the Google Directory ODBC Driver to create workflows that access real-time Google Directory without any coding.
-
Create Microsoft Planner-Connected Applications in Appsmith
Connect to Microsoft Planner Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft Planner.
-
How to integrate Metabase with Google Sheets Data
Use CData Connect AI to connect to live Google Sheets and create an interactive dashboard in Metabase from Google Sheets.
-
How to connect PolyBase to BenchmarkEmail
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live BenchmarkEmail.
-
Use CData Connect AI to Access Splunk Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Splunk in the Power Pivot business intelligence tool.
-
How to Easily Query TaxJar Data in OpenOffice Base
Connect to TaxJar data in OpenOffice Base using the CData ODBC Driver for TaxJar and generate reports with live data insights.
-
Connect Autopilot Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Autopilot using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Dropbox Data in DBArtisan
Use wizards in DBArtisan to configure Dropbox as a data source.
-
Build Excel Online Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Excel Online and build visualizations in Tableau.
-
Validate Everhour Data with QuerySurge
Access and validate Everhour in QuerySurge using the CData JDBC Driver.
-
Easily Integrate Excel Online Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft Excel Online in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Building Dynamic Web Pages with BigCommerce Data Using AngularJS
Create single-page applications with live connectivity to BigCommerce using the CData API Server.
-
Object-Relational Mapping (ORM) with Eventbrite 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 Eventbrite into a Java-based ORM framework, Hibernate.
-
Connect to Zuora Data in JRuby
Create a simple JRuby app with access to live Zuora.
-
Getting Started with the CData Tableau Connector for Amazon Marketplace
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Amazon Marketplace.
-
Automated Continuous WordPress Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable WordPress replication to Apache Cassandra.
-
How to Connect Flowise AI Agents to Live SAP Ariba Procurement 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 SAP Ariba Procurement without replication.
-
Connect to BenchmarkEmail Data in DBArtisan
Use wizards in DBArtisan to configure BenchmarkEmail as a data source.
-
How to Query Perplexity Data in MySQL Workbench
Execute MySQL queries against live Perplexity from MySQL Workbench.
-
Use CData Connect AI to Access Amazon DynamoDB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Amazon DynamoDB in the Power Pivot business intelligence tool.
-
Automated Continuous Workday Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Workday replication to Azure SQL Database.
-
Create Data Visualizations Based On Dynamics 365 Data in Mode
Use CData Connect AI to connect to Dynamics 365 Data from Mode and build visualizations using live
-
DataBind Controls to OpenWeatherMap Data in Delphi
DataBind to OpenWeatherMap in Delphi with standard data access components and controls.
-
Connect to Google Search Results as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Google Search.
-
Automated Continuous SAP ByDesign Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Amazon Redshift.
-
Visualize Microsoft Ads Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Ads into dashboards in TIBCO Spotfire.
-
Replicate Amazon Marketplace Data in Heroku for Use in Salesforce Connect
Replicate Amazon Marketplace to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Supabase Replication to MongoDB
Use CData Sync for automated, continuous, customizable Supabase replication to MongoDB.
-
Build a Simple VCL Application for Asana Data
How to build a simple VCL Application to view Asana in RAD Studio using the CData ODBC Driver for Asana.
-
Analyze Rebilly Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Rebilly in Microsoft R Open.
-
How to integrate Elasticsearch with Apache Airflow
Access and process Elasticsearch in Apache Airflow using the CData JDBC Driver.
-
Integrating Claude Code CLI with HCL Domino 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.
-
Creating Reckon Accounts Hosted-Connected Applications in Unqork
You can use CData Connect AI to feed Reckon Accounts Hosted to Unqork and build custom business apps.
-
Use the CData Software ODBC Driver for FreeAgent in SAS for Real-Time Reporting and Analytics
Connect to real-time FreeAgent in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for FreeAgent.
-
Connect to Wave Financial Data in Aqua Data Studio
Access Wave Financial from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Clockify Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Clockify as an External Source in Dremio.
-
Connect to Airtable from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Airtable, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Work with Paddle Data in FoxPro
Load Paddle into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Avaza
Provide connectivity to Avaza through an SAP BusinessObjects universe.
-
Use JayDeBeApi to access XML Data in Python
Use standard Python scripting and the development environment of your choice to access live XML Files.
-
Replicate Google Tasks Data from PowerShell
Write a quick PowerShell script to query Google Tasks. Use connectivity to the live data to replicate Google Tasks to SQL Server.
-
Access ClickTime Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for ClickTime.
-
Import Microsoft Dataverse Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Microsoft Dataverse Data and provide access to live Microsoft Dataverse (CDS) for custom reports in the Power BI Service.
-
View Reports on Real-Time Spotify Data in Power BI Report Server
Use the CData ODBC Driver for Spotify to visualize Spotify in Power BI Desktop and then publish them to Power BI Report Server.
-
Query IBM Cloud Object Storage Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume IBM Cloud Object Storage entities in PHP by modeling them as objects.
-
Integrate with Live SAP HANA Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP HANA from the MuleSoft Anypoint Platform to integrate live SAP HANA into custom reports and dashboards.
-
Extract, Transform, and Load Bright Data Data in Informatica PowerCenter
Create a simple Workflow for Bright Data in Informatica PowerCenter.
-
Integrating LlamaIndex with YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on YouTube Analytics in real time.
-
Access Live Slack Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Slack from your Excel spreadsheets.
-
Create Reports with Cvent Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Cvent.
-
Import Real-Time Amazon DynamoDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Amazon DynamoDB in ColdFusion.
-
Automated Microsoft Ads Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft Ads replication to Teradata.
-
Connecting Agentforce with Gong Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Gong for you.
-
Operational Reporting on Google Search Results from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Search.
-
Getting Started with the CData ODBC Driver for Perigon
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Perigon.
-
Automate ConvertKit Data Replication to SAP HANA
Use CData Sync to customize and automate ConvertKit replication to SAP HANA.
-
View Reports on Real-Time TigerGraph Data in Power BI Report Server
Use the CData ODBC Driver for TigerGraph to visualize TigerGraph in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Data Visualizations in Cognos BI with QuickBooks Data
Access QuickBooks Desktop as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData ODBC Driver for Sendwithus from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sendwithus to connect to Sendwithus from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sendwithus in Excel.
-
Add Salesloft Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Salesloft with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous MailerLite Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MailerLite replication to OneLake in Microsoft Fabric.
-
Connect to Adobe Analytics from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Adobe Analytics, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrating Cursor CLI with Oracle Service Cloud 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.
-
Create Apps from Google Search Results in Qlik Sense Cloud
Use CData Connect AI to connect to Google Search Results and build apps from live Google Search in Qlik Sense Cloud.
-
Automated Continuous JotForm Replication to Oracle
Use CData Sync for automated, continuous, customizable JotForm replication to Oracle.
-
Access Live Google Calendar Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Calendar from your Excel spreadsheets.
-
Build an OLAP Cube in SSAS from Trello Data
Establish a connection to Trello data from SQL Server Analysis Services, and use the Trello Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to ClickUp in SpagoBI
Create reports featuring live ClickUp in SpagoBI Studio. Host ClickUp reports on SpagoBI Server.
-
Connect to and Visualize Live SFTP Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SFTP.
-
Integrate Drift Data in Pentaho Data Integration
Build ETL pipelines based on Drift in the Pentaho Data Integration tool.
-
Integrating Cursor CLI with LDAP Objects 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.
-
Integrate Workday Data in Pentaho Data Integration
Build ETL pipelines based on Workday in the Pentaho Data Integration tool.
-
How to Connect to Live Highrise Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Highrise CRM securely in real time.
-
Integrate Real-Time Access to Shopify in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Shopify in real time.
-
Query JSON Services as a SQL Server Database in Node.js
Execute SQL Server queries against JSON from Node.js.
-
Integrating Antigravity CLI with LinkedIn via CData CLI
Connect LinkedIn to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Bannerbear
Provide connectivity to Bannerbear through an SAP BusinessObjects universe.
-
Build an OLAP Cube in SSAS from BigQuery Data
Establish a connection to Google BigQuery data from SQL Server Analysis Services, and use the BigQuery Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Data Flows from Redis to SQL Server using SSIS
Easily back up Redis to SQL Server using the SSIS components for Redis.
-
Natively Connect to ADP Data in PHP
The CData ODBC driver for ADP enables you to create PHP applications with connectivity to ADP. Leverage the native support for ODBC in PHP.
-
View Reports on Real-Time Marketo Data in Power BI Report Server
Use the CData ODBC Driver for Marketo to visualize Marketo in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Excel Add-In for Google Calendar
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Calendar.
-
How to Build an ETL App for Snowflake Data in Python with CData Connect AI
Build ETL pipelines that read and write live Snowflake in Python with petl and the CData Connect AI Python SDK.
-
Use Databricks Agent Bricks to Talk to Your GitHub Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your GitHub for you.
-
Consume Sage 300 OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sage 300 feeds that reflect any changes in SAP Lumira.
-
Query Amazon S3 Data as a MySQL Database in Node.js
Execute MySQL queries against Amazon S3 from Node.js.
-
How to Query ElevenLabs Data in MySQL Workbench
Execute MySQL queries against live ElevenLabs from MySQL Workbench.
-
Integrating Boomi Agentstudio with Jira Assets Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Jira Assets, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to connect and process Sybase IQ from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sybase IQ.
-
How to Connect to Pinecone Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Pinecone. Leverage the pyodbc module for ODBC in Python.
-
Connect to IBM Informix Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for IBM Informix Data and connect to IBM Informix in Akorbi Digital RunMyProcess.
-
Query Square Data as a MySQL Database in Node.js
Execute MySQL queries against Square from Node.js.
-
Connect Microsoft OneDrive Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft OneDrive using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query Bannerbear Data in DataGrip
Create a Data Source for Bannerbear in DataGrip and use SQL to query live Bannerbear.