CData Software - Knowledge Base
Recent Articles
-
Publish MessageBird-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MessageBird.
-
Visualize Live Pingdom Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Pingdom.
-
How to Connect DBeaver to SAP via a JDBC Driver
Manage SAP ERP/NetWeaver with visual tools in DBeaver like the query browser.
-
Operational Reporting on GetResponse Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote GetResponse.
-
Analyze Monday.com Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Monday.com and visualize Monday.com in SAP Analytics Cloud.
-
Build Dropbox-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Dropbox Data from Zoho Analytics and import live Dropbox.
-
Integrate SAP Business Warehouse Data in Pentaho Data Integration
Build ETL pipelines based on SAP Business Warehouse in the Pentaho Data Integration tool.
-
Getting Started with the CData Tableau Connector for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Replicate Multiple Shopify Accounts via the CData Sync CLI
Replicate multiple Shopify accounts to one or many databases.
-
Connect to Real-Time Gong Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Gong in Power Apps.
-
Create SAP BusinessObjects BI-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP BusinessObjects BI Data from OutSystems and build custom enterprise apps using live SAP BusinessObjects BI.
-
Validate Auth0 Data with QuerySurge
Access and validate Auth0 in QuerySurge using the CData JDBC Driver.
-
Create SSAS Tabular Models from Oracle Eloqua Reporting Data
How to build a SQL Server Analysis Service Tabular Model from Oracle Eloqua Reporting using CData drivers.
-
Connect to Mocean Data in JRuby
Create a simple JRuby app with access to live Mocean.
-
Visualize Recurly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Recurly.
-
Connect to OData Services from Crystal Reports
Use CData Connect AI to connect to and report on live OData from Crystal Reports.
-
How to Connect to Live Adobe Analytics 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 Adobe Analytics for you.
-
DataBind Controls to Zendesk Data in Delphi
DataBind to Zendesk in Delphi with standard data access components and controls.
-
Integrate Open WebUI with Live Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Ad Manager from within the chat interface.
-
Automated Continuous Sage Intacct Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Google BigQuery.
-
Using the CData Software ODBC Driver for Google Directory in PyCharm
Connect to Google Directory as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Directory.
-
Replicate Multiple SendGrid Accounts
Replicate multiple SendGrid accounts to one or many databases.
-
Create JSON-Connected Business Apps in AppSheet
Connect to JSON Services via CData Connect AI in Google AppSheet and create custom business applications with real-time access to JSON.
-
Access Live SurveyMonkey Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SurveyMonkey data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Building Dynamic Web Pages with Teradata Data Using AngularJS
Create single-page applications with live connectivity to Teradata using the CData API Server.
-
How to Connect to Live DB2 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 IBM DB2 for you.
-
Access QuickBooks Data from MySQL in Amazon QuickSight
Connect to QuickBooks and build visualizations of QuickBooks Desktop using a MySQL Connection in Amazon QuickSight.
-
Publish Strava-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Strava.
-
Integrate Live Google Spanner Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to CockroachDB 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 CockroachDB.
-
Build Coinbase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Coinbase and build web apps with connectivity to live Coinbase.
-
How to Access Live BigQuery Data in Power Automate Desktop via ODBC
The CData ODBC Driver for BigQuery enables you to integrate Google BigQuery into workflows built using Microsoft Power Automate Desktop.
-
Create Power BI Reports on Real-Time Typeform Data
Use the CData ODBC Driver for Typeform to visualize Typeform in Power BI Desktop.
-
Provide OData Services of Impala Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apache Impala by developing a WCF Service Application.
-
Choosing the Best Method to Connect SAP ByDesign to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Business ByDesign from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Query ClickTime Data in DataGrip
Create a Data Source for ClickTime in DataGrip and use SQL to query live ClickTime.
-
Access FTP Data from MySQL in Amazon QuickSight
Connect to FTP and build visualizations of FTP Servers using a MySQL Connection in Amazon QuickSight.
-
Connect to Oracle Data in DBeaver
Use the CData ODBC Driver to connect to Oracle Database in DBeaver.
-
Validate Tally Data with QuerySurge
Access and validate Tally ERP in QuerySurge using the CData JDBC Driver.
-
Connect to SurveyMonkey Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Zendesk to Power BI dashboards. Simply drag and drop Zendesk into data visuals on the Power BI canvas.
-
Getting Started with the CData ODBC Driver for Everhour
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Everhour.
-
Use Biml to Build SSIS Tasks to Replicate SharePoint Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft SharePoint to SQL Server.
-
Automated Continuous Reckon Accounts Hosted Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Amazon S3.
-
Object-Relational Mapping (ORM) with Presto 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 Presto into a Java-based ORM framework, Hibernate.
-
Automate Marketo Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Marketo and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Object-Relational Mapping (ORM) with RabbitMQ 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 RabbitMQ into a Java-based ORM framework, Hibernate.
-
View Reports on Real-Time ZeroBounce Data in Power BI Report Server
Use the CData ODBC Driver for ZeroBounce to visualize ZeroBounce in Power BI Desktop and then publish them to Power BI Report Server.
-
Replicate Phoenix Data to Multiple Databases
Replicate Apache Phoenix to disparate databases with a point-and-click configuration.
-
Automated Continuous eBay Analytics Replication to MySQL
Use CData Sync for automated, continuous, customizable eBay Analytics replication to MySQL.
-
Connect to Redshift Data from a Connection Pool in JBoss
Integrate Amazon Redshift into Java servlets: Use the Management Console in JBoss to install the Redshift JDBC Driver.
-
Explore Geographical Relationships in Parallel Data with Power Map
Create data visualizations with Parallel in Power Map.
-
Replicate Multiple Amazon Marketplace Accounts via the CData Sync CLI
Replicate multiple Amazon Marketplace accounts to one or many databases.
-
Access Live HubSpot Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live HubSpot from your Excel spreadsheets.
-
Integrating Kiro CLI with Bullhorn CRM 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 Query Live Azure Data Catalog Data in Perplexity MacOS Desktop
Connect to and query live Azure Data Catalog Data in Perplexity Desktop using CData MCP Server.
-
How to connect to Yelp Data from Spring Boot
Connect to Yelp in a Spring Boot Application using the CData API Driver for JDBC
-
How to create an RPA flow for eBay Analytics Data in UiPath Studio
Use the eBay Analytics ODBC Driver to create workflows that access real-time eBay Analytics without any coding.
-
Visualize ZohoExpense Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoExpense.
-
Connect to Basecamp Data in Aqua Data Studio
Access Basecamp from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Extend Google Sheets with SAP BusinessObjects BI Data
Make calls to SAP BusinessObjects BI from Google Apps Script via the API Server.
-
Explore Geographical Relationships in Instagram Data with Power Map
Create data visualizations with Instagram in Power Map.
-
Replicate Mailjet Data from PowerShell
Write a quick PowerShell script to query Mailjet. Use connectivity to the live data to replicate Mailjet to SQL Server.
-
Use the CData Software ODBC Driver for HubDB in SAS for Real-Time Reporting and Analytics
Connect to real-time HubDB in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for HubDB.
-
Access Live MongoDB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live MongoDB from your Excel spreadsheets.
-
Automated Continuous Google Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Ads replication to SQLite.
-
How to Access Live Epicor Kinetic Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Epicor Kinetic enables you to integrate Epicor Kinetic into workflows built using Microsoft Power Automate Desktop.
-
Build Dashboards with Hubstaff Data in Dundas BI
Create dynamic dashboards and perform analytics based on Hubstaff in Dundas BI.
-
Natively Connect to Insightly Data in PHP
The CData ODBC driver for Insightly enables you to create PHP applications with connectivity to Insightly. Leverage the native support for ODBC in PHP.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Anaplan
Provide connectivity to Anaplan through an SAP BusinessObjects universe.
-
Access Redis Data from MySQL in PHP
Connect to Redis through the standard MySQL libraries in PHP.
-
DataBind FTP Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for FTP with the DevExpress Windows Forms and Web controls to provide FTP Servers to a chart.
-
Connect to Live Microsoft Planner Data in MicroStrategy through CData Connect AI
Create a live connection to Microsoft Planner Data in CData Connect AI and connect to your Microsoft Planner from MicroStrategy.
-
Connect to Live Google Search Results in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Search in CData Connect AI and connect to your Google Search from PostgreSQL.
-
Validate Facebook Ads Data with QuerySurge
Access and validate Facebook Ads in QuerySurge using the CData JDBC Driver.
-
Connect to Dynamics 365 Data in NetBeans
Connect to Microsoft Dynamics 365 in NetBeans with the data source configuration wizard.
-
Create Google Forms Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Forms data access from reports, embedded analytics, and more.
-
Easily Integrate Microsoft Dataverse Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft Dataverse (CDS) in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connecting Agentforce with Salesforce CRM Analytics 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 Salesforce CRM Analytics for you.
-
Migrating data from Cloudflare to Databricks using CData SSIS Components.
Easily push Cloudflare to Databricks using the CData SSIS Tasks for Cloudflare and Databricks.
-
Build NetSuite Visualizations in Tableau Cloud
Use CData Connect AI to connect to live NetSuite CRM & ERP and build visualizations in Tableau Cloud.
-
Add Freshsales Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Freshsales with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Webex Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create a Data Access Object for Avro Data using JDBI
A brief overview of creating a SQL Object API for Apache Avro in JDBI.
-
Connect to ChargeOver from a Connection Pool in WebLogic
Use the CData JDBC Driver for ChargeOver to connect to ChargeOver from Web applications running on WebLogic.
-
Integrate Deel Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Deel from Informatica Cloud.
-
Automated Continuous Oracle Eloqua Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Azure SQL Database.
-
Build SQL Analysis Services-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SQL Analysis Services Data from Zoho Analytics and import live SQL Analysis Services.
-
Use Microsoft Copilot Studio to talk to your Bullhorn CRM 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 Bullhorn CRM for you.
-
Work with Slack Data in FoxPro
Load Slack into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Exact Online Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Exact Online Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Replicate SAS xpt Data to Multiple Databases
Replicate SAS XPORT to disparate databases with a point-and-click configuration.
-
Connect to AlloyDB Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google AlloyDB in Google Apps Script.
-
Connect to Redshift Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Amazon Redshift.
-
Automated Continuous Pinterest Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Pinterest replication to Apache Cassandra.
-
Automated Continuous SingleStore Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SingleStore replication to Apache Cassandra.
-
Integrate Live Yelp Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Yelp to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build AI/ML Models with Live Neo4J Data using Dataiku
Connect Neo4J Data with Dataiku using the CData JDBC Driver for Neo4J.
-
Natively Connect to ShipEngine Data in PHP
The CData ODBC driver for ShipEngine enables you to create PHP applications with connectivity to ShipEngine. Leverage the native support for ODBC in PHP.
-
How to Query Live Outreach.io Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Outreach.io data in natural language using Python.