CData Software - Knowledge Base
Recent Articles
-
Kintone Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Kintone through CData Connect AI using different applications and tools.
-
Integrate with Adobe Commerce Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Adobe Commerce to a JSON file on disk.
-
Connect to Codat Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Codat and the SQL Gateway to access Codat from Google Apps Script.
-
Process & Analyze SendPulse Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SendPulse Data.
-
Trigger Google Contacts IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Contacts with standard wizards in Logic Apps.
-
Bidirectional Access to Superchat Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Superchat in Filemaker Pro for Mac or Windows.
-
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.
-
Replicate Zoho Books Data to Multiple Databases
Replicate Zoho Books to disparate databases with a point-and-click configuration.
-
Build an OLAP Cube in SSAS from HubDB Data
Establish a connection to HubDB data from SQL Server Analysis Services, and use the HubDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Phoenix Data in Claris FileMaker Pro
Use the CData ODBC Driver for Phoenix in FileMaker Pro to connect to Phoenix and work with Apache Phoenix in your FileMaker applications.
-
Connect to Float Data in JRuby
Create a simple JRuby app with access to live Float.
-
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 a Singer.io Tap for SAP BusinessObjects BI With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP BusinessObjects BI data using
-
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.
-
Replicate Monday.com Data to Multiple Databases
Replicate Monday.com to disparate databases with a point-and-click configuration.
-
Visualize Live Redshift Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Amazon Redshift.
-
Operational Reporting on QuickBooks Online Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote QuickBooks Online.
-
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.
-
Connect to Amazon Marketplace Data from a Connection Pool in JBoss
Integrate Amazon Marketplace into Java servlets: Use the Management Console in JBoss to install the Amazon Marketplace JDBC Driver.
-
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.
-
Explore Geographical Relationships in Couchbase Data with Power Map
Create data visualizations with Couchbase in Power Map.
-
Access Dynamics 365 Data from MySQL in PHP
Connect to Dynamics 365 through the standard MySQL libraries in PHP.
-
Analyze Acumatica Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Acumatica ERP and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous SparkPost Replication to Vertica
Use CData Sync for automated, continuous, customizable SparkPost replication to Vertica.
-
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.
-
Visualize PayPal Data in TIBCO Spotfire through ADO.NET
Integrate PayPal into dashboards in TIBCO Spotfire.
-
Connect to Redshift Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Amazon Redshift using standard SQL.
-
Automated Continuous Zoho Projects Replication to SQLite
Use CData Sync for automated, continuous, customizable Zoho Projects replication to SQLite.
-
Integrate RSS with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate RSS with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to RSS Feeds.
-
Certinia Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Certinia facts in real time.
-
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.
-
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.
-
Connect to Placid Data in HULFT Integrate
Connect to Placid as a JDBC data source in HULFT Integrate
-
Connect to and Visualize Live Typeform Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Typeform.
-
Create SSAS Tabular Models from Sage 300 Data
How to build a SQL Server Analysis Service Tabular Model from Sage 300 using CData drivers.
-
Integrate Theia IDE with Live Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating Kiro CLI with BigQuery 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.
-
Access Live Cvent Data in Excel 365 Online (Excel for the web)
Connect to Cvent from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Snapchat Ads Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Snapchat Ads facts in real time.
-
Integrating Codex CLI with MySQL 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.
-
Create Reports with MYOB AccountRight Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MYOB AccountRight.
-
Create a Data Access Object for ShipStation Data using JDBI
A brief overview of creating a SQL Object API for ShipStation in JDBI.
-
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.
-
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.
-
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.
-
Integrating Boomi Agentstudio with Salesforce Pardot Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Salesforce Pardot, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
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.
-
How to Connect Flowise AI Agents to Live Apollo 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 Apollo without replication.
-
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.
-
Connect to Salesforce CRM Analytics Data from AWS Glue
Use CData Connect AI to gain access to live Salesforce CRM Analytics from your AWS Glue jobs.
-
Connecting Mastra with SAP BusinessObjects BI 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 SAP BusinessObjects BI, no replication required.
-
Access Live Hubstaff Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Hubstaff in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Campaigner Data in NetBeans
Connect to Campaigner in NetBeans with the data source configuration wizard.
-
Use the CData Software ODBC Driver for Oracle Sales in MicroStrategy Desktop
Connect to Oracle Sales in MicroStrategy Desktop using the CData Software ODBC Driver for Oracle Sales.
-
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.
-
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.
-
Add Mailjet Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Mailjet with the Informatica Enterprise Data Catalog to classify and organize data.
-
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 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.
-
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.
-
Automated Continuous MessageBird Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MessageBird replication to delimited files (CSV/TSV).
-
Analyze Wrike Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Wrike from Power Pivot. You will use the Table Import Wizard to load Wrike. You can visually build the import query or use any SQL supported by the driver.
-
How to connect PolyBase to Grafana
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Grafana.
-
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.
-
A PostgreSQL Interface for Keap Data using the CData ODBC Driver
Use the SQL Gateway and Keap ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Guru Data in AWS Lambda
Connect to live Guru in AWS Lambda using the CData JDBC Driver.
-
Manage MariaDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MariaDB.
-
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.
-
Create Data Visualizations Based On Amazon Athena Data in Mode
Use CData Connect AI to connect to Amazon Athena Data from Mode and build visualizations using live
-
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.
-
Optimizing SAP ERP Performance
In this entry, you will find several methods for improving the performance of the SAP ERP (Netweaver) driver.
-
Deploy the ADO.NET Provider for Airtable on an SSRS Report Server
Connect to Airtable 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.
-
How to work with Access Data in Apache Spark using SQL
Access and process Access Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect to Dotmailer Data from IntelliJ
Integrate connectivity to Dotmailer with wizards in IntelliJ.
-
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.
-
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.
-
Publish Printify-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Printify.
-
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.
-
Build Trello-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Trello.
-
Automated Continuous Salesloft Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Salesloft replication to Google BigQuery.
-
Integrate Theia IDE with Live SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build Slack-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Slack to explore live Slack Data in Claude Code to assist with building Slack-powered applications.
-
Build Google Sheets-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Sheets Data and create custom apps in Bubble.
-
How to create Scrapfly federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Scrapfly in MySQL .
-
Design BIRT Reports on Sage Intacct Data
Provide current Sage Intacct to your embedded analytics.