CData Software - Knowledge Base
Recent Articles
-
Create SSAS Tabular Models from PostgreSQL Data
How to build a SQL Server Analysis Service Tabular Model from PostgreSQL using CData drivers.
-
Connect to HBase Data in Ruby
Connect to Apache HBase in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Multiple SingleStore Accounts
Replicate multiple SingleStore accounts to one or many databases.
-
How to Connect to Live Kintone Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Kintone for you.
-
Build Apps with Live Jumpseller Data Using the Low-Code Development Platform of Mendix
Connect Jumpseller with Mendix to build apps using the CData API Driver for JDBC.
-
Rapidly Develop Microsoft Exchange-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Microsoft Exchange.
-
How to Connect the Power BI Service to Exact Online: Complete Guide
Connect to the CData Software Power BI Connector for Exact Online from PowerBI.com to provide real-time Exact Online across the organization.
-
Edit and Search External Sugar CRM Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Sugar CRM to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Sugar CRM Data objects that you can access from apps and the dashboard.
-
Automate Todoist Data Replication to Azure Data Lake
Use CData Sync to customize and automate Todoist replication to Azure Data Lake.
-
Access Live Couchbase Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Couchbase in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate LeadDesk Data Replication to Couchbase
Use CData Sync to Customize and automate LeadDesk replication to Couchbase.
-
Use the CData Software JDBC Driver for PingOne in MicroStrategy
Connect to PingOne in MicroStrategy Developer using the CData Software JDBC Driver for PingOne.
-
ETL Shortcut in Oracle Data Integrator
This article shows how to transfer Shortcut into a data warehouse using Oracle Data Integrator.
-
How to Work with Amazon Athena Data in ETL Validator JDBC
Connect to Amazon Athena from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Greenhouse in SpagoBI
Create reports featuring live Greenhouse in SpagoBI Studio. Host Greenhouse reports on SpagoBI Server.
-
Access Live MySQL Data in AWS Lambda
Connect to live MySQL in AWS Lambda using the CData JDBC Driver.
-
Visualize AlloyDB Data in TIBCO Spotfire through OData
Integrate Google AlloyDB into dashboards in TIBCO Spotfire.
-
Add Exa Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Exa with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to ZohoPeople Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZohoPeople in the Denodo Virtual DataPort Administrator.
-
Integrate with Spark Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apache Spark SQL to a JSON file on disk.
-
Connect to Postmark Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Postmark and work with Postmark in your FileMaker applications.
-
How to Query Workday Data in MySQL Workbench
Execute MySQL queries against live Workday from MySQL Workbench.
-
How to connect and process Datadog from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Datadog.
-
Create SSAS Tabular Models from Templated Data
How to build a SQL Server Analysis Service Tabular Model from Templated using CData drivers.
-
Integrate Freshteam Data in the Pentaho Report Designer
Publish reports based on Freshteam in the Pentaho BI tool.
-
How to connect PolyBase to CouchDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache CouchDB.
-
How to Connect the Power BI Service to Hugging Face: Complete Guide
Connect to the CData Software Power BI Connector for Hugging Face from PowerBI.com to provide real-time Hugging Face across the organization.
-
Create SSAS Tabular Models from Printify Data
How to build a SQL Server Analysis Service Tabular Model from Printify using CData drivers.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesforce Pardot
Provide connectivity to Salesforce Pardot through an SAP BusinessObjects universe.
-
Connecting GenSpark with Google Sheets Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Sheets without any replication or custom integration required.
-
Analyze NetSuite Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze NetSuite CRM & ERP with the CData JDBC Driver for NetSuite.
-
A PostgreSQL Interface for Access Data using the CData ODBC Driver
Use the SQL Gateway and Access ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Azure Data Catalog in MicroStrategy Web
Connect to Azure Data Catalog in MicroStrategy Web using the CData Software JDBC Driver for Azure Data Catalog.
-
Explore Geographical Relationships in Google Directory Data with Power Map
Create data visualizations with Google Directory in Power Map.
-
Connect to Elorus Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Elorus to connect to Elorus and execute queries in PowerBuilder.
-
Object-Relational Mapping (ORM) with VWO 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 VWO into a Java-based ORM framework, Hibernate.
-
Connect to ServiceDesk Plus from a Connection Pool in WebLogic
Use the CData JDBC Driver for ServiceDesk Plus to connect to ServiceDesk Plus from Web applications running on WebLogic.
-
Access Google Ads Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Ads from your Oracle system.
-
Migrating data from Printful to Databricks using CData SSIS Components.
Easily push Printful to Databricks using the CData SSIS Tasks for Printful and Databricks.
-
Query Attio Data in DataGrip
Create a Data Source for Attio in DataGrip and use SQL to query live Attio.
-
Connect to Google Ads Data from PowerBuilder via JDBC
This article demonstrates how to access Google Ads from PowerBuilder using the Google Ads JDBC Driver.
-
Integrating Kiro CLI with ZohoMarketingHub 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.
-
Use Azure AI Foundry to Talk to Your Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Microsoft Excel Online for you.
-
Automated Continuous Oracle Sales Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle Sales replication to IBM DB2.
-
Use the CData Software ODBC Driver for JSON in SAS for Real-Time Reporting and Analytics
Connect to real-time JSON in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for JSON.
-
Automate Omnisend Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Omnisend and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create Dynamic Slack Grids Using the Infragistics XamDataGrid
Learn how you can connect Slack to Infragistics XamDataGrid to build dynamic grids.
-
How to connect to TaxJar Data with Squirrel SQL client
Connect to TaxJar and execute queries in the Squirrel SQL Client.
-
Connect to and Query PhantomBuster Data in QlikView over ODBC
Create data visualizations with PhantomBuster in QlikView.
-
How to Visualize Timely Data in Python with pandas
Use pandas and other modules to analyze and visualize live Timely in Python.
-
Integrate with Live Exact Online Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Exact Online from the MuleSoft Anypoint Platform to integrate live Exact Online into custom reports and dashboards.
-
Replicate Multiple Exa Accounts
Replicate multiple Exa accounts to one or many databases.
-
Use Azure AI Foundry to Talk to Your SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAP Netweaver Gateway for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Bullhorn CRM
Provide connectivity to Bullhorn CRM through an SAP BusinessObjects universe.
-
How to Import Data from Google Analytics into Google Sheets
Import Google Analytics into a Google spreadsheet that is automatically refreshed.
-
Connect to ServiceDesk Plus Data from PowerBuilder via JDBC
This article demonstrates how to access ServiceDesk Plus from PowerBuilder using the ServiceDesk Plus JDBC Driver.
-
Build Blackbaud FE NXT-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Blackbaud FE NXT to explore live Blackbaud FE NXT Data in Claude Code to assist with building Blackbaud FE NXT-powered applications.
-
Connect to Google Search Results in RapidMiner
Integrate Google Search with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Vimeo Data in DBArtisan
Use wizards in DBArtisan to configure Vimeo as a data source.
-
Build a PostgreSQL Interface for Google Tasks Data using the CData JDBC Driver
Use the Remoting features of the Google Tasks JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate SuiteCRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate SuiteCRM replication to Azure Data Lake.
-
Connect to Oracle Eloqua Reporting Data in NetBeans
Connect to Oracle Eloqua Reporting in NetBeans with the data source configuration wizard.
-
Establish a Live Connection with REST Data using Tableau Bridge
The CData ODBC Driver for REST enables you to integrate live REST into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate Spark Data to Multiple Databases via the CData Sync CLI
Replicate Apache Spark SQL to disparate databases with a single configuration.
-
Visualize FreshBooks Data in Sisense
Create an ElastiCube in Sisense app with access to FreshBooks.
-
LINQ to Adobe 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 Adobe Analytics Data Provider.
-
Import Real-Time Brex Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Brex in ColdFusion.
-
Connect to Mailgun Data in Jaspersoft Studio
Execute SQL to remote Mailgun in Jaspersoft Studio.
-
How to connect PolyBase to Simplesat
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Simplesat.
-
Integrating Cursor CLI with Strava 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.
-
Query Discord Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Discord and perform CRUD operations on Discord from Node.js.
-
Use the CData API Server to Access Vercel Data in Microsoft PowerPivot
Use the CData API Server to connect to live Vercel in the Power Pivot business intelligence tool.
-
Automated Continuous Asana Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Asana replication to Google BigQuery.
-
Query Freshdesk Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Freshdesk from Node.js.
-
Analyze Zoho Creator Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho Creator from Power Pivot. You will use the Table Import Wizard to load Zoho Creator. You can visually build the import query or use any SQL supported by the driver.
-
How to Seamlessly Import SingleStore Data into IBM SPSS Modeler
Integrate SingleStore data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Natively Connect to Outlook Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Outlook. Leverage the native support for ODBC in PHP.
-
Integrating Antigravity CLI with SendInBlue via CData CLI
Connect SendInBlue to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Live Insightly Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Insightly data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Telegram Data in HULFT Integrate
Connect to Telegram as a JDBC data source in HULFT Integrate
-
Analyze SAP Fieldglass Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Fieldglass from Power Pivot. You will use the Table Import Wizard to load SAP Fieldglass. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Tableau Connector for SAP Ariba Source
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Ariba Source.
-
Provide OData Services of Authorize.Net Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Authorize.Net by developing a WCF Service Application.
-
Automated Continuous ServiceNow Replication to SQLite
Use CData Sync for automated, continuous, customizable ServiceNow replication to SQLite.
-
How to connect and process Quaderno from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Quaderno.
-
Connect to PagerDuty Data from PowerBuilder via JDBC
This article demonstrates how to access PagerDuty from PowerBuilder using the PagerDuty JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live QuickBooks Time using the Model Context Protocol.
-
Access Live Google Directory Data in TIBCO Data Virtualization
Use the Google Directory Tibco DV Adapter to create a Google Directory data source in TIBCO Data Virtualization Studio and gain access to live Google Directory from your TDV Server.
-
Publish Oracle Eloqua Reporting-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Oracle Eloqua Reporting.
-
Integrating GitHub Copilot CLI with TigerGraph 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 Klaviyo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Klaviyo data in natural language using Python.
-
How to Easily Query BenchmarkEmail Data in OpenOffice Base
Connect to BenchmarkEmail data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build a Simple VCL Application for Google Analytics Data
How to build a simple VCL Application to view Google Analytics in RAD Studio using the CData ODBC Driver for Google Analytics.
-
Automated Continuous Perplexity Replication to SQL Server
Use CData Sync for automated, continuous, customizable Perplexity replication to SQL Server.
-
Extend Google Sheets with Snapchat Ads Data
Make calls to Snapchat Ads from Google Apps Script via the API Server.
-
How to load OpenWeatherMap data into Elasticsearch via Logstash
Introducing a simple method to load OpenWeatherMap data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Pipeline CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Snowflake.
-
Connect to Salesforce Pardot Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Salesforce Pardot Data and connect to Salesforce Pardot in Akorbi Digital RunMyProcess.
-
Create SAP Concur-Connected Dashboards in Grafana
Connect to SAP Concur Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Concur.
-
Automated Continuous SAP Hybris C4C Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Apache Cassandra.