CData Software - Knowledge Base
Recent Articles
-
Connect to Copper from Asprova with CData Software ODBC Driver for Copper
This article shows how to connect faster to Copper data from Asprova.
-
Prepare, Blend, and Analyze SAP BusinessObjects BI Data in Alteryx Designer (ODBC)
Build workflows to access live SAP BusinessObjects BI for self-service data analytics.
-
Explore Geographical Relationships in ADP Data with Power Map
Create data visualizations with ADP in Power Map.
-
Connect to Google Ad Manager Data from a Connection Pool in Jetty
The Google Ad Manager JDBC Driver supports connection pooling: This article shows how to connect faster to Google Ad Manager from Web apps in Jetty.
-
Create Reckon Accounts Hosted Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Reckon Accounts Hosted data access from reports, embedded analytics, and more.
-
Connect to Clio Data in Aqua Data Studio
Access Clio from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build SAS Data Sets-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAS Data Sets.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP
Provide connectivity to SAP ERP/NetWeaver through an SAP BusinessObjects universe.
-
Automated Continuous Microsoft Entra ID Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to MongoDB.
-
How to integrate ZohoMarketingHub with Apache Airflow
Access and process ZohoMarketingHub in Apache Airflow using the CData JDBC Driver.
-
Automate Freshservice Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Freshservice and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Analyze LaunchDarkly Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of LaunchDarkly and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Connect to Live SAP Business One 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 SAP Business One for you.
-
Use Agno to Talk to Your Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Google Analytics for you.
-
Creating Zoho Books-Connected Applications in Unqork
You can use CData Connect AI to feed Zoho Books to Unqork and build custom business apps.
-
Build MVC Applications with Connectivity to MailerSend Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MailerSend from an ASP.NET MVC application.
-
Build Qualaroo-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Qualaroo.
-
Migrating data from Quaderno to Databricks using CData SSIS Components.
Easily push Quaderno to Databricks using the CData SSIS Tasks for Quaderno and Databricks.
-
Build Quickbase-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Quickbase Data and create custom apps in Bubble.
-
Automate Microsoft Ads Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Ads and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous SparkPost Replication to Vertica
Use CData Sync for automated, continuous, customizable SparkPost replication to Vertica.
-
Create Data Visualizations in Cognos BI with Facebook Data
Access Facebook as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Bidirectional Access to Browserless Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Browserless in Filemaker Pro for Mac or Windows.
-
Connect DocuSign Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your DocuSign using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Intercom Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Intercom and the SQL Gateway to access Intercom from Google Apps Script.
-
Getting Started with the CData Python Connector for PhantomBuster
Learn to install and license the CData Python Connector
-
Access Zoho Projects Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zoho Projects from HeidiSQL.
-
Create OpenWeatherMap Dataflows on PowerBI.com
Connect to the CData Power BI Connector for OpenWeatherMap from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Visualizations of TaxJar Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of TaxJar in Birst.
-
Connect to SAP Ariba Source Data from a Connection Pool in JBoss
Integrate SAP Ariba Source into Java servlets: Use the Management Console in JBoss to install the SAP Ariba Source JDBC Driver.
-
Visualize Gmail Data in TIBCO Spotfire through ADO.NET
Integrate Gmail into dashboards in TIBCO Spotfire.
-
Create SSAS Tabular Models from ZohoDesk Data
How to build a SQL Server Analysis Service Tabular Model from ZohoDesk using CData drivers.
-
How to create Zoho Books federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho Books in MySQL .
-
Build AI Agents with Oracle HCM Cloud 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 Oracle HCM Cloud through CData Connect AI.
-
DataBind Charts to GetResponse Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to GetResponse 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.
-
Automated Continuous Twitter Ads Replication to Snowflake
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Snowflake.
-
Connect to Everhour Data from PowerBuilder via ADO.NET
This article demonstrates how to access Everhour from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Publish Reports with Redshift Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon Redshift.
-
Build a Singer.io Tap for Hacker News With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Hacker News data using
-
Work with Placid Data in FoxPro
Load Placid into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to integrate GetResponse with Apache Airflow
Access and process GetResponse in Apache Airflow using the CData JDBC Driver.
-
Configure the CData JDBC Driver for HCL Domino in a Connection Pool in Tomcat
Connect to HCL Domino from a connection pool in Tomcat.
-
How to Query Live Microsoft OneDrive Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft OneDrive data in natural language using Python.
-
Connect to Zoho Creator Data from PowerBuilder via JDBC
This article demonstrates how to access Zoho Creator from PowerBuilder using the Zoho Creator JDBC Driver.
-
Query PolarTeamPro Data in DataGrip
Create a Data Source for PolarTeamPro in DataGrip and use SQL to query live PolarTeamPro.
-
Snapchat Ads Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Snapchat Ads facts in real time.
-
Connect and Query Live MailChimp Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live MailChimp into Databricks
-
Work with SAP SuccessFactors Data in FoxPro
Load SAP SuccessFactors into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create a Data Access Object for ShipStation Data using JDBI
A brief overview of creating a SQL Object API for ShipStation in JDBI.
-
Create MariaDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MariaDB data access from reports, embedded analytics, and more.
-
How to load Quickbase data into Elasticsearch via Logstash
Introducing a simple method to load Quickbase data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use Microsoft Copilot Studio to talk to your Google Spanner 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 Google Spanner for you.
-
Access Live Google Cloud Storage Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Cloud Storage from your Google Sheets.
-
Create Reports with Aweber Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Aweber.
-
Connect to Exa Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Exa to connect to Exa and execute queries in PowerBuilder.
-
Create SSAS Tabular Models from Perplexity Data
How to build a SQL Server Analysis Service Tabular Model from Perplexity using CData drivers.
-
Migrating data from Telegram to Snowflake using CData SSIS Components.
Easily push Telegram to Snowflake using the CData SSIS Tasks for Telegram and Snowflake.
-
Automate AlloyDB Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google AlloyDB and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Front Data in NetBeans
Connect to Front in NetBeans with the data source configuration wizard.
-
Integrate Short.io Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Short.io from Informatica Cloud.
-
Query CampaignMonitor Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume CampaignMonitor entities in PHP by modeling them as objects.
-
Validate MessageBird Data with QuerySurge
Access and validate MessageBird in QuerySurge using the CData JDBC Driver.
-
Integrate with Marketo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Marketo to a JSON file on disk.
-
Connect to Campaigner Data in NetBeans
Connect to Campaigner in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Excel Add-In for Deel
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Deel.
-
Manage Typeform Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Typeform.
-
Connect to Neo4J Data from a Connection Pool in JBoss
Integrate Neo4J into Java servlets: Use the Management Console in JBoss to install the Neo4J JDBC Driver.
-
Connect to CloudConvert Data in DBeaver
Use the CData ODBC Driver to connect to CloudConvert in DBeaver.
-
Extend Google Sheets with ZohoSubscriptions Data
Make calls to ZohoSubscriptions from Google Apps Script via the API Server.
-
Visualize Retently Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Retently.
-
Create Data Visualizations in Cognos BI with SAP Ariba Procurement Data
Access SAP Ariba Procurement as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Zoho Recruit from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zoho Recruit to connect to Zoho Recruit from Web applications running on WebLogic.
-
Connect to and Query Exact Online Data in QlikView over ODBC
Create data visualizations with Exact Online in QlikView.
-
Enable the Quaderno JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Quaderno.
-
Connecting Agentforce with SQL Server Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Microsoft SQL Server for you.
-
How to Query Live Google Directory Data in Perplexity MacOS Desktop
Connect to and query live Google Directory Data in Perplexity Desktop using CData MCP Server.
-
Create Data Visualizations in Cognos BI with Webex Data
Access Webex as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
LINQ to Salesforce CRM Analytics Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Salesforce CRM Analytics Data Provider.
-
How to connect to BenchmarkEmail Data from Spring Boot
Connect to BenchmarkEmail in a Spring Boot Application using the CData API Driver for JDBC
-
Connecting Mastra with Gmail 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 Gmail, no replication required.
-
Automated Continuous Planio Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Planio replication to Apache Cassandra.
-
Getting Started with the CData ODBC Driver for Eventbrite
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Eventbrite.
-
Write a Simple Go Application to work with Google Calendar Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Calendar.
-
Automate Figshare Data Replication to SAP HANA
Use CData Sync to customize and automate Figshare replication to SAP HANA.
-
Connect to YouTube Analytics Data from a Connection Pool in Jetty
The YouTube Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to YouTube Analytics from Web apps in Jetty.
-
Use the CData Software ODBC Driver for Google Calendar in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Calendar in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Calendar.
-
Use the CData Software ODBC Driver for Nethunt in SAS for Real-Time Reporting and Analytics
Connect to real-time Nethunt in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Nethunt.
-
How to Connect DBeaver to Monday.com via a JDBC Driver
Manage Monday.com with visual tools in DBeaver like the query browser.
-
A PostgreSQL Interface for Microsoft Exchange Data using the CData ODBC Driver
Use the SQL Gateway and Microsoft Exchange ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Reports with ZohoInvoice Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoInvoice.
-
How to Access Live LaunchDarkly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for LaunchDarkly enables you to integrate LaunchDarkly into workflows built using Microsoft Power Automate Desktop.
-
Build Charts with Hacker News Data in Clear Analytics
Create dynamic charts and perform analytics based on Hacker News in Clear Analytics.
-
Use the CData Software ODBC Driver for Instagram in MicroStrategy Web
Connect to Instagram in MicroStrategy Web using the CData Software ODBC Driver for Instagram.
-
How to Access Live ZendeskSell Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live ZendeskSell from the Cline extension in Visual Studio Code.
-
Build Reply.io-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Reply.io Data in Cursor to assist with building Reply.io-powered applications.
-
Publish Printify-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Printify.
-
Analyze Live eBay Data in SAS Viya
Use CData Connect AI to connect to eBay from SAS Viya and deploy self-service analytics using live eBay.
-
Integrate Live Zendesk Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Access Live NetSuite Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live NetSuite CRM & ERP from your Google Sheets.
-
Automated Continuous Salesloft Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Salesloft replication to Google BigQuery.