CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Auth0 in SAS for Real-Time Reporting and Analytics
Connect to real-time Auth0 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Auth0.
-
Integrate with Live Google Contacts Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Contacts from the MuleSoft Anypoint Platform to integrate live Google Contacts into custom reports and dashboards.
-
Publish Reports with HBase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache HBase.
-
Build Charts with Instantly Data in Clear Analytics
Create dynamic charts and perform analytics based on Instantly in Clear Analytics.
-
Validate SAP Business One Data with QuerySurge
Access and validate SAP Business One in QuerySurge using the CData JDBC Driver.
-
Use the CData ODBC Driver for Odoo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Odoo to connect to Odoo ERP from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Odoo ERP in Excel.
-
Configure the CData JDBC Driver for Foursquare in a Connection Pool in Tomcat
Connect to Foursquare from a connection pool in Tomcat.
-
Integrate Nuclia with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Nuclia with External Services.
-
Configure the CData JDBC Driver for LinkedIn in a Connection Pool in Tomcat
Connect to LinkedIn from a connection pool in Tomcat.
-
Use ChatGPT to Talk to Your Highrise 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 Highrise CRM for you.
-
Access Live Google Tasks Data in AWS Lambda
Connect to live Google Tasks in AWS Lambda using the CData JDBC Driver.
-
Add PabblySubscriptions Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PabblySubscriptions with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to PolarTeamPro Data in JRuby
Create a simple JRuby app with access to live PolarTeamPro.
-
Build Pipelines with Live Certinia Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Certinia from Google Cloud Data Fusion, enabling the integration of live Certinia into the building and management of effective data pipelines.
-
Prepare, Blend, and Analyze FHIR Data in Alteryx Designer (ODBC)
Build workflows to access live FHIR for self-service data analytics.
-
Build Charts with Teamgate Data in Clear Analytics
Create dynamic charts and perform analytics based on Teamgate in Clear Analytics.
-
Getting Started with the CData ODBC Driver for Todoist
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Todoist.
-
Connect to Sage 300 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Sage 300 and the SQL Gateway to access Sage 300 from Google Apps Script.
-
Connect to Sendwithus in SpagoBI
Create reports featuring live Sendwithus in SpagoBI Studio. Host Sendwithus reports on SpagoBI Server.
-
Use Dash to Build Web Apps on Epicor Kinetic Data via CData Connect AI
Build interactive Dash web apps on live Epicor Kinetic using pandas and the CData Connect AI Python SDK.
-
Query Spark Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Apache Spark SQL and perform CRUD operations on Spark from Node.js.
-
Integrating Claude Code CLI with Bright Data 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.
-
Integrate with Mailgun Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Mailgun to a JSON file on disk.
-
Build Monday.com-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Monday.com and build web apps with connectivity to live Monday.com.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LaunchDarkly
Provide connectivity to LaunchDarkly through an SAP BusinessObjects universe.
-
How to load SAP Concur data into Elasticsearch via Logstash
Introducing a simple method to load SAP Concur data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query Excel Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Excel entities in PHP by modeling them as objects.
-
Create Microsoft OneDrive-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft OneDrive Data from Nintex Workflow Cloud and build custom workflows using live Microsoft OneDrive.
-
Replicate Monday.com Data to Multiple Databases via the CData Sync CLI
Replicate Monday.com to disparate databases with a single configuration.
-
Access Live Vault CRM Data in TIBCO Data Virtualization
Use the Vault CRM Tibco DV Adapter to create a Veeva Vault & Vault CRM data source in TIBCO Data Virtualization Studio and gain access to live Veeva Vault & Vault CRM from your TDV Server.
-
Build Demio-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Demio.
-
Object-Relational Mapping (ORM) with SAP BusinessObjects BI 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 SAP BusinessObjects BI into a Java-based ORM framework, Hibernate.
-
Create Stripe Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Stripe data access from reports, embedded analytics, and more.
-
Use the CData ODBC Driver for AdRoll from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for AdRoll to connect to AdRoll from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring AdRoll in Excel.
-
Connect to Impala Data in DBeaver
Use the CData ODBC Driver to connect to Apache Impala in DBeaver.
-
Build a PostgreSQL Interface for SAP HANA Data using the CData JDBC Driver
Use the Remoting features of the SAP HANA JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to MYOB AccountRight Data in RazorSQL
Connect to MYOB AccountRight from wizards and query MYOB AccountRight from the GUI in the RazorSQL database management tool.
-
Connecting GenSpark with Monday.com Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Monday.com without any replication or custom integration required.
-
Connect to Snapchat Ads Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Snapchat Ads from Filemaker Pro on Mac.
-
How to Access Live Amazon Marketplace Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Amazon Marketplace enables you to integrate Amazon Marketplace into workflows built using Microsoft Power Automate Desktop.
-
Visualize Live SAP Hybris C4C Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Hybris C4C into custom reports in Power BI.
-
Add iContact Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for iContact with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Manus AI to Talk to Your Zoom 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 Zoom.
-
Model, Search, and Visualize Live Presto Data in ThoughtSpot
Use CData Connect AI to connect to live Presto for modeling, searching, and visualizing.
-
Connect to Asana Data from HeidiSQL
Use CData Connect AI to connect to and query live Asana from HeidiSQL.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Cvent actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Stream HubDB Data into Apache Kafka Topics
Access and stream HubDB in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Billsby Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Billsby replication to OneLake in Microsoft Fabric.
-
Viewing Placid Data in RAD Studio Data Explorer
How to view Placid in RAD Studio Data Explorer using the CData ODBC Driver for Placid.
-
Import Real-Time PingOne Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PingOne in ColdFusion.
-
Automated Continuous ServiceNow Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ServiceNow replication to PostgreSQL.
-
Integrate with Live Paylocity Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Paylocity from the MuleSoft Anypoint Platform to integrate live Paylocity into custom reports and dashboards.
-
Automated Continuous MailerLite Replication to MongoDB
Use CData Sync for automated, continuous, customizable MailerLite replication to MongoDB.
-
Publish NASA-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live NASA.
-
Use Dash to Build Web Apps on MailChimp Data via CData Connect AI
Build interactive Dash web apps on live MailChimp using pandas and the CData Connect AI Python SDK.
-
Integrating Codex CLI with SendInBlue 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.
-
Extract, Transform, and Load Recurly Data in Informatica PowerCenter
Create a simple Workflow for Recurly in Informatica PowerCenter.
-
Integrate Amazon Athena Data in the Pentaho Report Designer
Publish reports based on Amazon Athena in the Pentaho BI tool.
-
Analyze Marketo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Marketo from Power Pivot. You will use the Table Import Wizard to load Marketo. You can visually build the import query or use any SQL supported by the driver.
-
Build a PostgreSQL Interface for Exact Online Data using the CData JDBC Driver
Use the Remoting features of the Exact Online JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Teamgate Data in RazorSQL
Connect to Teamgate from wizards and query Teamgate from the GUI in the RazorSQL database management tool.
-
How to connect to Google Calendar Data with Squirrel SQL client
Connect to Google Calendar and execute queries in the Squirrel SQL Client.
-
Integrating Antigravity CLI with Splunk via CData CLI
Connect Splunk to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to publish and share Google Contacts Data dashboards with Tableau Server
The CData ODBC driver for Google Contacts enables you integrate Google Contacts into Tableau dashboards.
-
Connect to Sybase Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Sybase in Airbyte.
-
Connect to Insightly Data from PowerBuilder via JDBC
This article demonstrates how to access Insightly from PowerBuilder using the Insightly JDBC Driver.
-
Bridge MailerSend Connectivity with Apache NiFi
Access and process MailerSend in Apache NiFi using the CData JDBC Driver.
-
How to update Office 365 from Excel
This article explains how to transfer data from Excel to Office 365 using the Excel Add-In for Office 365.
-
Integrating Oracle Eloqua Reporting Data in Talend Cloud Data Management Platform
Connect Oracle Eloqua Reporting Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle Eloqua Reporting.
-
Pingdom Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Pingdom facts in real time.
-
Build AI Agents with Microsoft Entra ID Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Microsoft Entra ID through CData Connect AI.
-
Analyze Google Calendar Data in Looker
Use CData Connect AI to connect to Google Calendar Data from Looker and build custom apps using live Google Calendar.
-
Manage BambooHR Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for BambooHR.
-
Connect to Retently Data in NetBeans
Connect to Retently in NetBeans with the data source configuration wizard.
-
Back Up Neo4J to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Neo4J. In this article, we will employ an SSIS workflow to populate a database with Neo4J data.
-
Connect to NASA Data from PowerBuilder via JDBC
This article demonstrates how to access NASA from PowerBuilder using the NASA JDBC Driver.
-
How to Query Live Reckon Accounts Hosted Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Reckon Accounts Hosted data in natural language using Python.
-
Connect to ZohoPeople Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZohoPeople as an External Source in Dremio.
-
Integrating Claude Code with Zendesk Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zendesk within assisted coding and automated development workflows.
-
Connect to Klaviyo Data in NetBeans
Connect to Klaviyo in NetBeans with the data source configuration wizard.
-
Consume Xero OData Feeds in PowerBuilder
This article demonstrates how to consume Xero Accounting as OData feeds from PowerBuilder using the API Server.
-
How to Connect to Live SingleStore Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SingleStore for you.
-
Prepare, Blend, and Analyze Webflow Data in Alteryx Designer (ODBC)
Build workflows to access live Webflow for self-service data analytics.
-
Getting Started with the CData JDBC Driver for Neo4J
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Neo4J.
-
Connect to Gumroad Data in Ruby
Connect to Gumroad in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Natively Connect to Facebook Data in PHP
The CData ODBC driver for Facebook enables you to create PHP applications with connectivity to Facebook. Leverage the native support for ODBC in PHP.
-
Build Visualizations of Clockify Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Clockify in Birst.
-
How to connect SharePoint with XML Data through external lists
Provide XML Files to SharePoint users as an external list.
-
Connect to Zoho Books Data from AWS Glue
Use CData Connect AI to gain access to live Zoho Books from your AWS Glue jobs.
-
DataBind Controls to FormSite Data in C++Builder
DataBind to FormSite in C++Builder with standard components and controls.
-
Build Adobe Target-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Adobe Target to explore live Adobe Target Data in Gemini Code Assist to assist with building Adobe Target-powered applications.
-
Prepare, Blend, and Analyze Todoist Data in Alteryx Designer (ODBC)
Build workflows to access live Todoist for self-service data analytics.
-
Edit and Search Salesforce Data 360 External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Salesforce Data 360 to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Salesforce Data 360 objects that you can access from apps and the dashboard.
-
Feed Spotify Data into FineReport
How to set Spotify as a JDBC data source in FineReport.
-
Build Data Flows from ChargeOver to SQL Server using SSIS
Easily back up ChargeOver to SQL Server using the SSIS components for ChargeOver.
-
How to load SAP Netweaver Gateway data into Elasticsearch via Logstash
Introducing a simple method to load SAP Netweaver Gateway data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Seamlessly Import HubSpot Data into IBM SPSS Modeler
Integrate HubSpot data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use Claude to Talk to Your SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SAP Concur for you.
-
Access Azure Analysis Services Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Azure Analysis Services from HeidiSQL.
-
Connect to ShipStation Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ShipStation as an External Source in Dremio.