CData Software - Knowledge Base
Recent Articles
-
Deploy the ADO.NET Provider for MariaDB on an SSRS Report Server
Connect to MariaDB 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.
-
Manage CouchDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CouchDB.
-
CData SAP Driver Deep Dive: Use SAP Gateway Service Builder for SAP S/4HANA and Set Up OData Service
A guide for using the SAP Gateway Service Builder for SAP S/4 HANA and setting up an SAP OData Service
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed RabbitMQ to Power BI dashboards. Simply drag and drop RabbitMQ into data visuals on the Power BI canvas.
-
Integrate Real-Time Access to Splunk in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Splunk in real time.
-
Access Live Clari Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Clari in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Work with Teamgate Data in ETL Validator JDBC
Connect to Teamgate from ETL Validator jobs using the CData Software JDBC Driver.
-
Import and Visualize Webex Data in Power View
Create data visualizations based on Webex in Excel.
-
Connect to Spark Data from AWS Glue
Use CData Connect AI to gain access to live Apache Spark SQL from your AWS Glue jobs.
-
Spark Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Spark facts in real time.
-
Connect to WooCommerce Data from Crystal Reports
Use CData Connect AI to connect to and report on live WooCommerce from Crystal Reports.
-
DataBind Controls to Sentry Data in C++Builder
DataBind to Sentry in C++Builder with standard components and controls.
-
Use the CData Software ODBC Driver for Oracle Sales in MicroStrategy
Connect to Oracle Sales in MicroStrategy Developer using the CData Software ODBC Driver for Oracle Sales.
-
Automated Continuous Box Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Box replication to IBM DB2.
-
Connect to Raisers Edge NXT Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Raisers Edge NXT and the SQL Gateway to access Raisers Edge NXT from Google Apps Script.
-
Connect to Front Data from a Connection Pool in Jetty
The Front JDBC Driver supports connection pooling: This article shows how to connect faster to Front from Web apps in Jetty.
-
Trigger Google Calendar IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Calendar with standard wizards in Logic Apps.
-
Automated Continuous Avaza Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Avaza replication to AlloyDB.
-
Replicate Rebilly Data from PowerShell
Write a quick PowerShell script to query Rebilly. Use connectivity to the live data to replicate Rebilly to SQL Server.
-
Visualize Placid 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 Placid into TIBCO Spotfire.
-
Getting Started with the CData ADO.NET Provider for Teamgate
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Getting Started with the CData JDBC Driver for Google Ads
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Ads.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Amazon Marketplace using the Model Context Protocol.
-
Automated Continuous Sendwithus Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sendwithus replication to Amazon Redshift.
-
Integrate Real-Time Access to DB2 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to IBM DB2 in real time.
-
Automated Continuous Certinia Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Certinia replication to Amazon Redshift.
-
Choosing the Best Method to Connect Clockify to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Clockify from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build AI/ML Models with Live Sybase IQ Data using Dataiku
Connect Sybase IQ Data with Dataiku using the CData JDBC Driver for Sybase IQ.
-
Automated Continuous Redis Replication to Databricks
Use CData Sync for automated, continuous, customizable Redis replication to Databricks.
-
Connect to CampaignMonitor Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to CampaignMonitor and work with CampaignMonitor in your FileMaker applications.
-
Connect to ZohoExpense Data in JRuby
Create a simple JRuby app with access to live ZohoExpense.
-
Query Moosend Data in ColdFusion
Write standard ColdFusion data access code to connect to Moosend.
-
Publish Crystal Reports on Yelp Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Yelp.
-
How to Work with Snapchat Ads Data in AWS Glue Jobs Using JDBC
Connect to Snapchat Ads from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Snowflake Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Snowflake.
-
Create HCL Domino-Connected Applications in Appsmith
Connect to HCL Domino Data via CData Connect AI in Appsmith and create custom business applications with real-time access to HCL Domino.
-
Integrate with Authorize.Net Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Authorize.Net to a JSON file on disk.
-
Design BIRT Reports on MySQL Data
Provide current MySQL to your embedded analytics.
-
Extract, Transform, and Load SFTP Data in Informatica PowerCenter
Create a simple Workflow for SFTP in Informatica PowerCenter.
-
Natively Connect to EnterpriseDB Data in PHP
The CData ODBC driver for EnterpriseDB enables you to create PHP applications with connectivity to EnterpriseDB. Leverage the native support for ODBC in PHP.
-
How to connect to ZeroBounce Data from IntelliJ
Integrate connectivity to ZeroBounce with wizards in IntelliJ.
-
Integrate Mode Data in the Pentaho Report Designer
Publish reports based on Mode in the Pentaho BI tool.
-
ETL HBase in Oracle Data Integrator
This article shows how to transfer Apache HBase into a data warehouse using Oracle Data Integrator.
-
Integrate with AfterShip Data in JReport Designer
Create charts and reports based on AfterShip in JReport Designer.
-
How to Work with PivotalTracker Data in ETL Validator JDBC
Connect to PivotalTracker from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate Sentry Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Sentry and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Viewing Presto Data in RAD Studio Data Explorer
How to view Presto in RAD Studio Data Explorer using the CData ODBC Driver for Presto.
-
Use Microsoft Copilot Studio to talk to your API 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 API for you.
-
Create Power BI Reports on Real-Time ZarMoney Data
Use the CData ODBC Driver for ZarMoney to visualize ZarMoney in Power BI Desktop.
-
How to connect to Telegram Data from IntelliJ
Integrate connectivity to Telegram with wizards in IntelliJ.
-
How to Connect to Optimizely Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Optimizely. Leverage the pyodbc module for ODBC in Python.
-
Use the CData ODBC Driver for Instantly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Instantly to connect to Instantly from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Instantly in Excel.
-
Connect to and Query YouTube Analytics Data in QlikView over ODBC
Create data visualizations with YouTube Analytics in QlikView.
-
Connect to ZohoDesk Data in RazorSQL
Connect to ZohoDesk from wizards and query ZohoDesk from the GUI in the RazorSQL database management tool.
-
DataBind Charts to Zoho CRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho CRM 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.
-
Import Real-Time Mistral AI Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Mistral AI in ColdFusion.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for BigCommerce
Provide connectivity to BigCommerce through an SAP BusinessObjects universe.
-
Explore Geographical Relationships in Simplesat Data with Power Map
Create data visualizations with Simplesat in Power Map.
-
Working with Adobe Analytics Data in LINQPad
Execute LINQ queries to Adobe Analytics in LINQPad.
-
Connect to EnterpriseDB Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for EnterpriseDB Data and connect to EnterpriseDB in Akorbi Digital RunMyProcess.
-
Integrating Kiro CLI with Oracle HCM 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.
-
Build Suadeo-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Suadeo to explore live Suadeo Data in Cursor to assist with building Suadeo-powered applications.
-
How to Create Power BI Visual Reports with Real-Time Cohere Data
Use CData Power BI Connectors to visualize Cohere in Power BI.
-
How to connect to Azure Table Data from Spring Boot
Connect to Azure Table in a Spring Boot Application using the CData JDBC Driver for Azure
-
Getting Started with the CData ODBC Driver for ZeroBounce
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZeroBounce.
-
Automate Everhour Data Replication to Azure Data Lake
Use CData Sync to customize and automate Everhour replication to Azure Data Lake.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Dynamics 365 to Power BI dashboards. Simply drag and drop Microsoft Dynamics 365 into data visuals on the Power BI canvas.
-
Connect to ChargeOver Data in HULFT Integrate
Connect to ChargeOver as a JDBC data source in HULFT Integrate
-
Connect to Mixpanel Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Mixpanel in the Denodo Virtual DataPort Administrator.
-
View Reports on Real-Time CampaignMonitor Data in Power BI Report Server
Use the CData ODBC Driver for CampaignMonitor to visualize CampaignMonitor in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect to Bitly Data from Spring Boot
Connect to Bitly in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous QuickBooks Time Replication to SingleStore
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to SingleStore.
-
Build Salesforce Marketing-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Salesforce Marketing Cloud.
-
Query Live QuickBooks Time Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live QuickBooks Time directly from the development environment.
-
Connect Zoho Inventory to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho Inventory using the CData Python MCP Server.
-
Automated Continuous Aha! Replication to MongoDB
Use CData Sync for automated, continuous, customizable Aha! replication to MongoDB.
-
Validate Oracle Data with QuerySurge
Access and validate Oracle Database in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live Cvent Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Cvent for you.
-
Consume SAP HANA XS Advanced OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP HANA XS Advanced feeds that reflect any changes in SAP Lumira.
-
Access Live Salesforce CRM Analytics 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 Salesforce CRM Analytics through MCP integration.
-
Getting Started with the CData ODBC Driver for Avaza
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Avaza.
-
Query Google Sheets Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Sheets.
-
Create Dynamic Email Grids Using the Infragistics XamDataGrid
Learn how you can connect Email to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect to CapsuleCRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to CapsuleCRM. Leverage the pyodbc module for ODBC in Python.
-
Easily Integrate Dropbox Data in Lazarus Pascal IDE
Learn how to easily integrate live Dropbox in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Create Power BI Visual Reports with Real-Time Amazon Marketplace Data
Use CData Power BI Connectors to visualize Amazon Marketplace in Power BI.
-
Automated Continuous Reckon Accounts Hosted Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to IBM DB2.
-
Use the CData ODBC Driver for Nethunt in Microsoft Power Query
You can use the CData Nethunt ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Nethunt into Microsoft Power Query.
-
Integrating Kiro 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.
-
Work with Qualaroo Data in FoxPro
Load Qualaroo into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect to Live Cassandra 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 Apache Cassandra through natural language.
-
Connect to Zoho Inventory Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoho Inventory using standard SQL.
-
How to integrate Metabase with Stripe Data
Use CData Connect AI to connect to live Stripe and create an interactive dashboard in Metabase from Stripe.
-
Integrate Cursor with Live Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Adobe Analytics from within the editor.
-
Connect to Box 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 Box.
-
Use ChatGPT to Talk to Your HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your HCL Domino for you.
-
Build an OLAP Cube in SSAS from Zoho Creator Data
Establish a connection to Zoho Creator data from SQL Server Analysis Services, and use the Zoho Creator Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Manus AI to Talk to Your Google Spanner 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 Google Spanner.
-
Automated Continuous Discord Replication to Databricks
Use CData Sync for automated, continuous, customizable Discord replication to Databricks.
-
Access Klipfolio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Klipfolio from HeidiSQL.