CData Software - Knowledge Base
Recent Articles
-
Automated HubSpot Data Replication to Teradata
Use CData Sync to Customize and automate HubSpot replication to Teradata.
-
How to Build an ETL App for Vault CRM Data in Python with CData
Create ETL applications and real-time data pipelines for Veeva Vault & Vault CRM in Python with petl.
-
How to create an RPA flow for Coinbase Data in UiPath Studio
Use the Coinbase ODBC Driver to create workflows that access real-time Coinbase without any coding.
-
Connect to and Query IBM Cloud Object Storage Data in QlikView over ODBC
Create data visualizations with IBM Cloud Object Storage in QlikView.
-
Build AI/ML Models with Live QuickBooks Data using Dataiku
Connect QuickBooks Data with Dataiku using the CData JDBC Driver for QuickBooks.
-
Analyze Procore Data in Looker
Use CData Connect AI to connect to Procore Data from Looker and build custom apps using live Procore.
-
Connect to Printful Data in JRuby
Create a simple JRuby app with access to live Printful.
-
How to Connect to Live SurveyMonkey Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SurveyMonkey securely in real time.
-
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.
-
Connect and Visualize Live Phoenix Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Apache Phoenix into the Databricks platform and create visualization dashboards with real-time Apache Phoenix.
-
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
-
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.
-
How to Connect Flowise AI Agents to Live Vertica 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 Vertica without replication.
-
Spark Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Spark facts in real time.
-
Replicate Cassandra Data in Heroku for Use in Salesforce Connect
Replicate Apache Cassandra to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
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 API Server to Access XML Data in Microsoft PowerPivot
Use the CData API Server to connect to live XML Files in the Power Pivot business intelligence tool.
-
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.
-
Integrate Real-Time Access to Blackbaud FE NXT in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Blackbaud FE NXT in real time.
-
Query Slack Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Slack and perform CRUD operations on Slack from Node.js.
-
Automated Continuous Avaza Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Avaza replication to AlloyDB.
-
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.
-
Automated Continuous Certinia Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Certinia replication to Amazon Redshift.
-
Create Reports with Active Directory Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Active Directory.
-
Write a Simple Go Application to work with Retently Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Retently.
-
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.
-
Creating Azure Table-Connected Applications in Unqork
You can use CData Connect AI to feed Azure Table Storage to Unqork and build custom business apps.
-
Connect to ZohoExpense Data in JRuby
Create a simple JRuby app with access to live ZohoExpense.
-
Build Semantic Layer Views for SAP Fieldglass Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Fieldglass.
-
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.
-
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.
-
Analyze Microsoft Teams Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Teams and visualize Microsoft Teams in SAP Analytics Cloud.
-
How to Connect to & Open Pingdom Data in Microsoft Excel
This article uses the CData ODBC driver for Pingdom to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
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.
-
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 Query Live Presto Data in Perplexity MacOS Desktop
Connect to and query live Presto Data in Perplexity Desktop using CData MCP Server.
-
Integrate with AfterShip Data in JReport Designer
Create charts and reports based on AfterShip in JReport Designer.
-
Integrating Cursor CLI with CampaignMonitor 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.
-
How to connect to Mixpanel Data from IntelliJ
Integrate connectivity to Mixpanel with wizards in IntelliJ.
-
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.
-
How to connect to Telegram Data from IntelliJ
Integrate connectivity to Telegram with wizards in IntelliJ.
-
Build Cvent Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Cvent and build visualizations in Tableau.
-
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.
-
Create Amazon Marketplace-Connected Applications in Appsmith
Connect to Amazon Marketplace Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Amazon Marketplace.
-
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.
-
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.
-
Getting Started with the CData ODBC Driver for ZeroBounce
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZeroBounce.
-
Access Clari 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 Clari.
-
Automate Everhour Data Replication to Azure Data Lake
Use CData Sync to customize and automate Everhour replication to Azure Data Lake.
-
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.
-
How to Query Live Microsoft Dataverse Data in Claude Desktop
Connect to and query live Microsoft Dataverse Data in Claude Desktop using CData MCP 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
-
Integrate Goose with Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Veeva Vault & Vault CRM from within the local AI agent.
-
Visualize ZohoDesk Data in Sisense
Create an ElastiCube in Sisense app with access to ZohoDesk.
-
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.
-
Query Google Sheets Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Sheets.
-
Creating Microsoft Dataverse-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft Dataverse (CDS) to Unqork and build custom business apps.
-
How to Connect to & Open Bright Data Data in Microsoft Excel
This article uses the CData ODBC driver for Bright Data to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Dynamic Email Grids Using the Infragistics XamDataGrid
Learn how you can connect Email to Infragistics XamDataGrid to build dynamic grids.
-
Access Live AgileCRM Data in AWS Lambda
Connect to live AgileCRM in AWS Lambda using the CData JDBC Driver.
-
Integrating Boomi Agentstudio with Zoho CRM Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Zoho CRM, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
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.
-
How to connect to SAP Ariba Procurement Data with Squirrel SQL client
Connect to SAP Ariba Procurement and execute queries in the Squirrel SQL Client.
-
Visualize Printify Data in Sisense
Create an ElastiCube in Sisense app with access to Printify.
-
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.
-
Build Dashboards with Jumpseller Data in DBxtra
Create dynamic dashboards and perform analytics based on Jumpseller in DBxtra.
-
Build Data Flows from Quickbase to SQL Server using SSIS
Easily back up Quickbase to SQL Server using the SSIS components for Quickbase.
-
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 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.
-
Build LinkedIn Ads-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for LinkedIn Ads to explore live LinkedIn Ads Data in GitHub Copilot to assist with building LinkedIn Ads-powered applications.
-
Create a Data Access Object for Chargebee Data using JDBI
A brief overview of creating a SQL Object API for Chargebee in JDBI.
-
Build Azure Data Catalog-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Azure Data Catalog to explore live Azure Data Catalog Data in GitHub Copilot to assist with building Azure Data Catalog-powered applications.
-
Integrating Kiro CLI with Twitter Ads 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 Google Campaign Manager 360-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Google Campaign Manager 360 to explore live Google Campaign Manager 360 Data in GitHub Copilot to assist with building Google Campaign Manager 360-powered applications.
-
How to connect to Google Analytics Data from Spring Boot
Connect to Google Analytics in a Spring Boot Application using the CData JDBC Driver for Google Analytics
-
Automated Oracle Financials Cloud Data Replication to Teradata
Use CData Sync to Customize and automate Oracle Financials Cloud replication to Teradata.
-
Connect to Zuora Data from PowerBuilder via JDBC
This article demonstrates how to access Zuora from PowerBuilder using the Zuora JDBC Driver.
-
Automated Continuous BigCommerce Replication to Amazon S3
Use CData Sync for automated, continuous, customizable BigCommerce replication to Amazon S3.
-
Stream ClickUp Data into Apache Kafka Topics
Access and stream ClickUp in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Salesforce Data from Spring Boot
Connect to Salesforce in a Spring Boot Application using the CData JDBC Driver for Salesforce
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Freshservice
Provide connectivity to Freshservice through an SAP BusinessObjects universe.
-
How to Connect to & Open PostgreSQL Data in Microsoft Excel
This article uses the CData ODBC driver for PostgreSQL to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze Monday.com Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Monday.com and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build a PostgreSQL Interface for HDFS Data using the CData JDBC Driver
Use the Remoting features of the HDFS JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bind Live Power BI XMLA Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Power BI XMLA data
-
Automate Calendly Data Replication to Azure Data Lake
Use CData Sync to customize and automate Calendly replication to Azure Data Lake.