CData Software - Knowledge Base
Recent Articles
-
Object-Relational Mapping (ORM) with Recurly 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 Recurly data into a Java-based ORM framework, Hibernate.
-
View Reports on Real-Time Redis Data in Power BI Report Server
Use the CData ODBC Driver for Redis to visualize Redis data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Coda Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Coda data from Informatica Cloud.
-
How to connect to Amazon Marketplace Data from IntelliJ
Integrate connectivity to Amazon Marketplace data with wizards in IntelliJ.
-
Model Kintone Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Kintone, enabling the direct import of real-time Kintone data.
-
How to Connect to Live Excel Online Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Excel Online data for you.
-
Analyze Odoo Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Odoo data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to publish and share Sybase IQ Data dashboards with Tableau Server
The CData ODBC driver for Sybase IQ enables you integrate Sybase IQ data into Tableau dashboards.
-
Viewing Zoho Inventory Data in RAD Studio Data Explorer
How to view Zoho Inventory data in RAD Studio Data Explorer using the CData ODBC Driver for Zoho Inventory.
-
Use Databricks Agent Bricks to Talk to Your Epicor Kinetic Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Epicor Kinetic data for you.
-
Integrate Live MarkLogic Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MarkLogic data and integrate live MarkLogic data into apps built in Microsoft Power Apps.
-
Connect to SQL Server from a Connection Pool in WebLogic
Use the CData JDBC Driver for SQL Server to connect to SQL Server data from Web applications running on WebLogic.
-
Connect to Google Ads Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Google Ads.
-
Integrating Cursor with Dotmailer 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.
-
Model SurveyMonkey Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SurveyMonkey, enabling the direct import of real-time SurveyMonkey data.
-
Create a Data Access Object for Factorial Data using JDBI
A brief overview of creating a SQL Object API for Factorial data in JDBI.
-
Connect to MailerLite from a Connection Pool in WebLogic
Use the CData JDBC Driver for MailerLite to connect to MailerLite data from Web applications running on WebLogic.
-
Replicate TaxJar Data to Multiple Databases via the CData Sync CLI
Replicate TaxJar data to disparate databases with a single configuration.
-
How to use SQLAlchemy ORM to access Toggl Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Toggl data.
-
Use the CData Software JDBC Driver for SAP SuccessFactors LMS in MicroStrategy Web
Connect to SAP SuccessFactors LMS data in MicroStrategy Web using the CData Software JDBC Driver for SAP SuccessFactors LMS.
-
Connect to ServiceNow Data in Jaspersoft Studio
Execute SQL to remote ServiceNow data in Jaspersoft Studio.
-
Analyze Amazon Athena Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Amazon Athena data and visualize Amazon Athena data in SAP Analytics Cloud.
-
Visualize Live Facebook Ads Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Facebook Ads data.
-
Access Microsoft Entra ID Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Entra ID data from HeidiSQL.
-
Access Live Kintone Data in Coginiti Pro
Connect to and query live Kintone data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Azure AI Foundry to Talk to Your Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Bullhorn CRM data for you.
-
Integrating Antigravity CLI with Accelo data via CData CLI
Connect Accelo data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Import and Visualize Vercel Data in Power View
Create data visualizations based on Vercel data in Excel.
-
Replicate Zoho Projects Data to Multiple Databases via the CData Sync CLI
Replicate Zoho Projects data to disparate databases with a single configuration.
-
Connect to BenchmarkEmail Data in CloverDX (formerly CloverETL)
Transfer BenchmarkEmail data using the visual workflow in the CloverDX data integration tool.
-
How to Connect to Live Dynamics NAV Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Dynamics NAV data for you.
-
Build a PostgreSQL Interface for ChargeOver Data using the CData JDBC Driver
Use the Remoting features of the ChargeOver JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live GitHub Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to GitHub data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous CouchDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable CouchDB replication to delimited files (CSV/TSV).
-
Access Live QuickBooks Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to QuickBooks data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to use SQLAlchemy ORM to access Amazon S3 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Amazon S3 data.
-
DataBind Controls to Adobe Analytics Data in C++Builder
DataBind to Adobe Analytics data in C++Builder with standard components and controls.
-
How to Query Avalara AvaTax Data in MySQL Workbench
Execute MySQL queries against live Avalara AvaTax data from MySQL Workbench.
-
Connect to LinkedIn Ads Data from HeidiSQL
Use CData Connect AI to connect to and query live LinkedIn Ads data from HeidiSQL.
-
Bidirectional Access to SAP Hybris C4C Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Hybris C4C data in Filemaker Pro for Mac or Windows.
-
Moving Data from DocuSign to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live DocuSign data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build AI/ML Models with Live ZohoSubscriptions Data using Dataiku
Connect ZohoSubscriptions Data with Dataiku using the CData API Driver for JDBC.
-
Access HelloSign 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 HelloSign data.
-
Integrating LlamaIndex with ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ServiceNow data in real time.
-
Visualize Amazon DynamoDB 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 Amazon DynamoDB data into TIBCO Spotfire.
-
Integrating Planio Data in Talend Cloud Data Management Platform
Connect Planio Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use Biml to Build SSIS Tasks to Replicate Authorize.Net Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Authorize.Net data to SQL Server.
-
Create SSAS Tabular Models from Oracle HCM Cloud Data
How to build a SQL Server Analysis Service Tabular Model from Oracle HCM Cloud data using CData drivers.
-
Import Real-Time Wistia Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Wistia data in ColdFusion.
-
Integrate Cline with Live Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Cloudant data from within your IDE.
-
Connect to Marketo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Marketo to connect to Marketo data from Web applications running on WebLogic.
-
Access Figshare 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 Figshare data.
-
Connect to Smartsheet Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Smartsheet and the SQL Gateway to access Smartsheet data from Google Apps Script.
-
How to Connect PayPal Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live PayPal data in real time using natural language.
-
How to Create Power BI Visual Reports with Real-Time Reckon Data
Use CData Power BI Connectors to visualize Reckon data in Power BI.
-
Automate SharePoint Data Replication to Azure Data Lake
Use CData Sync to customize and automate SharePoint data replication to Azure Data Lake.
-
Create a Data Access Object for Redis Data using JDBI
A brief overview of creating a SQL Object API for Redis data in JDBI.
-
Integrate ServiceDesk Plus Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ServiceDesk Plus data from Informatica Cloud.
-
Build Charts with Discord Data in Clear Analytics
Create dynamic charts and perform analytics based on Discord data in Clear Analytics.
-
Connect to SendPulse Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SendPulse and the SQL Gateway to access SendPulse data from Google Apps Script.
-
Create Informatica Mappings From/To a JDBC Data Source for Cloudflare
Create Cloudflare data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Redis-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Redis Data from Klipfolio and build custom visualizations using live Redis data.
-
Design BIRT Reports on Cosmos DB Data
Provide current Cosmos DB data to your embedded analytics.
-
Build Semantic Layer Views for Marketo Data in APOS Live Data Gateway
Use the CData Connector for Marketo in APOS Live Data Gateway to build Semantic Layer Views for Marketo data.
-
Access Oracle HCM Cloud Data from MySQL in Amazon QuickSight
Connect to Oracle HCM Cloud and build visualizations of Oracle HCM Cloud data using a MySQL Connection in Amazon QuickSight.
-
Model Microsoft Dataverse Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft Dataverse, enabling the direct import of real-time Microsoft Dataverse data.
-
Build Optimizely-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Optimizely Data and create custom apps in Mendix.
-
Access Stack Exchange Data from MySQL in Amazon QuickSight
Connect to Stack Exchange and build visualizations of Stack Exchange data using a MySQL Connection in Amazon QuickSight.
-
How to Work with Cosmos DB Data in ETL Validator JDBC
Connect to Cosmos DB from ETL Validator jobs using the CData Software JDBC Driver.
-
Bind Live Exact Online Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Exact Online data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Import Real-Time Oracle SCM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Oracle SCM data in ColdFusion.
-
Integrate with Paylocity Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Paylocity data in SnapLogic.
-
Feed LinkedIn Ads Data into FineReport
How to set LinkedIn Ads data as a JDBC data source in FineReport.
-
Use Databricks Agent Bricks to Talk to Your Act CRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Act CRM data for you.
-
Integrate Real-Time Access to Vault CRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Vault CRM data in real time.
-
Getting Started with the CData Power BI Connector for Bannerbear
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Visualize AdRoll Data in Tableau
The CData ODBC driver for AdRoll enables you integrate AdRoll data into Tableau dashboards.
-
Viewing Smartsheet Data in RAD Studio Data Explorer
How to view Smartsheet data in RAD Studio Data Explorer using the CData ODBC Driver for Smartsheet.
-
Connect to Adobe Target Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Adobe Target Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating Boomi Agentstudio with MariaDB Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to MariaDB data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create Dynamic Amplitude Grids Using the Infragistics XamDataGrid
Learn how you can connect Amplitude to Infragistics XamDataGrid to build dynamic grids.
-
Analyze ServiceNow Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ServiceNow from Power Pivot. You will use the Table Import Wizard to load ServiceNow data. You can visually build the import query or use any SQL supported by the driver.
-
How to create Zendesk federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zendesk data in MySQL .
-
Prepare, Blend, and Analyze MarkLogic Data in Alteryx Designer (Connect AI)
Build workflows to access live MarkLogic data for self-service data analytics.
-
Object-Relational Mapping (ORM) with Salesforce 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 Salesforce data into a Java-based ORM framework, Hibernate.
-
How to load Adobe Commerce data into Elasticsearch via Logstash
Introducing a simple method to load Adobe Commerce data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to create an RPA flow for Paylocity Data in UiPath Studio
Use the Paylocity ODBC Driver to create workflows that access real-time Paylocity data without any coding.
-
Build Semantic Layer Views for Facebook Ads Data in APOS Live Data Gateway
Use the CData Connector for Facebook Ads in APOS Live Data Gateway to build Semantic Layer Views for Facebook Ads data.
-
How to Visualize Google Drive Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Drive data in Python.
-
Automate NetSuite Data Replication to SAP HANA
Use CData Sync to customize and automate NetSuite data replication to SAP HANA.
-
Connect to and Query ZarMoney Data in QlikView over ODBC
Create data visualizations with ZarMoney data in QlikView.
-
How to Query Azure DevOps Data in MySQL Workbench
Execute MySQL queries against live Azure DevOps data from MySQL Workbench.
-
Use the CData Software JDBC Driver for Pipedrive in MicroStrategy Web
Connect to Pipedrive data in MicroStrategy Web using the CData Software JDBC Driver for Pipedrive.
-
Access Live Slack Data in TIBCO Data Virtualization
Use the Slack Tibco DV Adapter to create a Slack data data source in TIBCO Data Virtualization Studio and gain access to live Slack data from your TDV Server.
-
Getting Started with the CData Python Connector for Square
Learn to install and license the CData Python Connector and configure a connection to live Square data.
-
Write a Simple Go Application to work with ZohoDesk Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZohoDesk data.
-
Access Zendesk 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 Zendesk data.
-
Build Semantic Layer Views for Google Cloud Storage Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Cloud Storage data.
-
Integrating LangGraph with Dynamics 365 Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Dynamics 365 data within automated workflows.
-
Connect to Live Gmail Data in MicroStrategy through CData Connect AI
Create a live connection to Gmail Data in CData Connect AI and connect to your Gmail data from MicroStrategy.