CData Software - Knowledge Base
Recent Articles
-
Visualize Live ZohoInvoice Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ZohoInvoice data into custom reports in Power BI.
-
Connect to Excel Online Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Excel Online to connect to Excel Online data and execute queries in PowerBuilder.
-
Integrate Templated with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Templated with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Templated data.
-
Extract, Transform, and Load Codat Data in Informatica PowerCenter
Create a simple Workflow for Codat data in Informatica PowerCenter.
-
Query HCL Domino Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume HCL Domino entities in PHP by modeling them as objects.
-
Analyze REST Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of REST data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to use SQLAlchemy ORM to access Oracle Eloqua Reporting Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Eloqua Reporting data.
-
Connect to QuickBooks Online Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for QuickBooks Online and the Script function in FileMaker Pro to connect to QuickBooks Online and work with QuickBooks Online data in your FileMaker application.
-
Use the CData Software ODBC Driver for ZendeskSell in SAS for Real-Time Reporting and Analytics
Connect to real-time ZendeskSell data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZendeskSell.
-
Integrating GitHub Copilot with Sage 200 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.
-
DataBind Controls to IBM Cloud Object Storage Data in C++Builder
DataBind to IBM Cloud Object Storage data in C++Builder with standard components and controls.
-
How to Connect the Power BI Service to BigQuery: Complete Guide
Connect to the CData Software Power BI Connector for BigQuery from PowerBI.com to provide real-time BigQuery data across the organization.
-
Integrating Kiro with Gmail 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.
-
Publish Crystal Reports on Azure Data Catalog Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Azure Data Catalog data.
-
Query ZeroBounce Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZeroBounce data from Node.js.
-
Extract, Transform, and Load OneNote Data in Informatica PowerCenter
Create a simple Workflow for OneNote data in Informatica PowerCenter.
-
Replicate Multiple Confluence Accounts via the CData Sync CLI
Replicate multiple Confluence accounts to one or many databases.
-
Automated Continuous Azure Data Catalog Replication to MongoDB
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to MongoDB.
-
Connect to ActiveCampaign Data in Jaspersoft Studio
Execute SQL to remote ActiveCampaign data in Jaspersoft Studio.
-
Consume Google Drive OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Drive feeds that reflect any changes in SAP Lumira.
-
Automated Continuous SAP Ariba Source Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to SQLite.
-
Integrate Facebook Ads Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Facebook Ads data from Informatica Cloud.
-
Create SSAS Tabular Models from WooCommerce Data
How to build a SQL Server Analysis Service Tabular Model from WooCommerce data using CData drivers.
-
Bidirectional Access to DB2 Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate DB2 data in Filemaker Pro for Mac or Windows.
-
Access Live BigCommerce Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live BigCommerce data from your Excel spreadsheets.
-
Zuora Reporting in OBIEE with the Zuora JDBC Driver
Deploy the Zuora JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Google Campaign Manager 360 Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Campaign Manager 360 data and build visualizations in Tableau Cloud.
-
How to Easily Query Scrapfly Data in OpenOffice Base
Connect to Scrapfly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Devin with Live ZohoDesk Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live ZohoDesk data.
-
How to create an RPA flow for Splunk Data in UiPath Studio
Use the Splunk ODBC Driver to create workflows that access real-time Splunk data without any coding.
-
Rapidly Develop Outlook-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 Outlook.
-
How to connect and process Airtable data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Airtable data.
-
Use the CData Software ODBC Driver for ADP in MicroStrategy
Connect to ADP data in MicroStrategy Developer using the CData Software ODBC Driver for ADP.
-
Validate Accelo Data with QuerySurge
Access and validate Accelo data in QuerySurge using the CData JDBC Driver.
-
Integrate Elorus Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Elorus data from Informatica Cloud.
-
Connect to YouTube Analytics Data in JRuby
Create a simple JRuby app with access to live YouTube Analytics data.
-
Connecting Moonlit Workflow with Amazon DynamoDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Amazon DynamoDB data in real time.
-
Create Data Visualizations Based On Omnisend Data in Mode
Use CData Connect AI to connect to Omnisend Data from Mode and build visualizations using live Omnisend data.
-
Build Automated MailChimp-Connected Workflows in Zapier
Use CData Connect AI to connect to live MailChimp data and build automated workflows in Zapier.
-
Create MariaDB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to MariaDB Data from OutSystems and build custom enterprise apps using live MariaDB data.
-
Integrating Antigravity CLI with Templated data via CData CLI
Connect Templated data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Todoist Data from PowerBuilder via ADO.NET
This article demonstrates how to access Todoist data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Highrise Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Highrise Data and connect to Highrise data in Akorbi Digital RunMyProcess.
-
Write a Simple Go Application to work with LinkedIn Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LinkedIn data.
-
Connect VWO to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect VWO with IBM WebSphere for seamless data integration and connectivity.
-
SAP Hybris C4C Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Hybris C4C facts in real time.
-
Integrate with live Mode Data in Jitterbit
Use CData Connect AI to connect to and integrate live Mode data in Jitterbit.
-
Build Apps with Live Mode Data Using the Low-Code Development Platform of Mendix
Connect Mode data with Mendix to build apps using the CData API Driver for JDBC.
-
A PostgreSQL Interface for HBase Data using the CData ODBC Driver
Use the SQL Gateway and HBase ODBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for Sendwithus Data using the CData ODBC Driver
Use the SQL Gateway and Sendwithus ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Blackbaud FE NXT Data in MySQL Workbench
Execute MySQL queries against live Blackbaud FE NXT data from MySQL Workbench.
-
Create Data Visualizations in Cognos BI with Tavily Data
Access Tavily data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Enable the Google Drive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Drive data.
-
Connect to LinkedIn Ads Data from PowerBuilder via ADO.NET
This article demonstrates how to access LinkedIn Ads data from Appeon PowerBuilder using the CData ADO.NET Provider for LinkedIn Ads.
-
Connect LinkedIn Ads to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live LinkedIn Ads data using the CData Python MCP Server.
-
Operational Reporting on Pinecone Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pinecone data.
-
Integrate Trae with Live Box Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Box data from within the AI-powered IDE.
-
Connect to MailerLite Data in RapidMiner
Integrate MailerLite data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Pipelines with Live Google Ad Manager Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Ad Manager from Google Cloud Data Fusion, enabling the integration of live Google Ad Manager data into the building and management of effective data pipelines.
-
Connect to Live Google Sheets Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Sheets in CData Connect AI and connect to your Google Sheets data from PostgreSQL.
-
Connect to Clio Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Clio data in the Denodo Virtual DataPort Administrator.
-
Query GetResponse Data through ODBC in Node.js
Use node-odbc to execute SQL queries against GetResponse data from Node.js.
-
Integrating GitHub Copilot with Google Analytics 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 Automated DocuSign-Connected Workflows in Zapier
Use CData Connect AI to connect to live DocuSign data and build automated workflows in Zapier.
-
Build Charts with Figshare Data in Clear Analytics
Create dynamic charts and perform analytics based on Figshare data in Clear Analytics.
-
Automated Continuous Retently Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Retently replication to Apache Cassandra.
-
Integrating Claude Code CLI with OnePageCrm 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 to Procore Data 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 Procore data.
-
Create Reports from Jira Assets Data in Looker Studio
Use CData Connect AI to gain access to live Jira Assets data and create custom reports in Looker Studio.
-
Bind Live Cloudant Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Cloudant data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
CData SAP Driver Deep Dive: How to Create SAP RFC Module and Access from CData Driver for SAP
A guide for how to call the generic modules and RFCs that form the core of the CData SAP ERP Driver
-
Visualize WordPress Data in Tableau
The CData ODBC driver for WordPress enables you integrate WordPress data into Tableau dashboards.
-
Connecting Mastra with Zoho CRM 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 Zoho CRM data, no replication required.
-
Visualize Zoho Creator 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 Zoho Creator data into TIBCO Spotfire.
-
Access Omnisend Data from MySQL in PHP
Connect to Omnisend through the standard MySQL libraries in PHP.
-
How to connect to Google Search Results in DBVisualizer
Integrate Google Search results with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live Stripe Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Stripe data through MCP integration.
-
Build a Simple VCL Application for CircleCI Data
How to build a simple VCL Application to view CircleCI data in RAD Studio using the CData ODBC Driver for CircleCI.
-
Configure the CData JDBC Driver for Xero in a Connection Pool in Tomcat
Connect to Xero data from a connection pool in Tomcat.
-
Integrate with Amazon Marketplace Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Amazon Marketplace data to a JSON file on disk.
-
Connect to Templated Data in Jaspersoft Studio
Execute SQL to remote Templated data in Jaspersoft Studio.
-
Seamlessly Bring GitHub Data into Retool Using CData Connect AI
Integrate GitHub data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate Cline with Live AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live AlloyDB data from within your IDE.
-
Build an OLAP Cube in SSAS from JobNimbus Data
Establish a connection to JobNimbus data data from SQL Server Analysis Services, and use the JobNimbus Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze Gmail Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Gmail data in Microsoft R Open.
-
Connect to Amazon Athena Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Amazon Athena and the SQL Gateway to access Amazon Athena data from Google Apps Script.
-
Use the CData Software JDBC Driver for Sentry in MicroStrategy
Connect to Sentry data in MicroStrategy Developer using the CData Software JDBC Driver for Sentry.
-
Build Charts with SAP Business One Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Business One data in Clear Analytics.
-
Analyze Elasticsearch Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Elasticsearch data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Live SAP Ariba Source Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Ariba Source data and integrate live SAP Ariba Source data into apps built in Microsoft Power Apps.
-
Replicate Multiple SAP ByDesign Accounts
Replicate multiple SAP ByDesign accounts to one or many databases.
-
Create Datasets from Grafana in Domo Workbench and Build Visualizations of Grafana Data in Domo
Use the CData Software ODBC Driver for Grafana to create datasets from Grafana data in Domo Workbench and then build visualizations in the Domo service.
-
Deploy the ADO.NET Provider for Browserless on an SSRS Report Server
Connect to Browserless 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.
-
Use JayDeBeApi to access Amazon S3 Data in Python
Use standard Python scripting and the development environment of your choice to access live Amazon S3 data.
-
Visualize Live Kafka Data in the Power BI Service
Use CData Connect AI to connect to live Kafka data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Freshdesk Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Freshdesk with the DevExpress Windows Forms and Web controls to provide Freshdesk data to a chart.
-
Connect to Browserless Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Browserless data using standard SQL.
-
Connect to ShipStation Data in JRuby
Create a simple JRuby app with access to live ShipStation data.
-
Prepare, Blend, and Analyze eBay Data in Alteryx Designer (Connect AI)
Build workflows to access live eBay data for self-service data analytics.
-
Build a PostgreSQL Interface for Highrise Data using the CData JDBC Driver
Use the Remoting features of the Highrise JDBC Driver to create a PostgreSQL entry-point for data access.