CData Software - Knowledge Base
Recent Articles
-
Analyze Odoo Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Odoo ERP and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Enable the MailerSend JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MailerSend.
-
Automated Continuous Aircall Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Aircall replication to OneLake in Microsoft Fabric.
-
Access Live Pipedrive Data in TIBCO Data Virtualization
Use the Pipedrive Tibco DV Adapter to create a Pipedrive data source in TIBCO Data Virtualization Studio and gain access to live Pipedrive from your TDV Server.
-
Bind Live Snapchat Ads Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Snapchat Ads data
-
How to Visualize Amazon S3 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Amazon S3 in Python.
-
Bridge Instagram Connectivity with Apache NiFi
Access and process Instagram in Apache NiFi using the CData JDBC Driver.
-
Connect to Power BI XMLA Data from a Connection Pool in Jetty
The Power BI XMLA JDBC Driver supports connection pooling: This article shows how to connect faster to Power BI XMLA from Web apps in Jetty.
-
Build Semantic Layer Views for Okta Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Okta.
-
Connect to Samanage Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Samanage in the Denodo Virtual DataPort Administrator.
-
Integrating Claude Code CLI with Mailjet 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 a Simple VCL Application for Greenhouse Data
How to build a simple VCL Application to view Greenhouse in RAD Studio using the CData ODBC Driver for Greenhouse.
-
Create Cassandra-Connected Business Apps in AppSheet
Connect to Cassandra Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Apache Cassandra.
-
Visualize Live Facebook Ads Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Facebook Ads.
-
Connect to Microsoft OneDrive from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft OneDrive, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Import and Visualize Vercel Data in Power View
Create data visualizations based on Vercel in Excel.
-
Replicate Zoho Projects Data to Multiple Databases via the CData Sync CLI
Replicate Zoho Projects to disparate databases with a single configuration.
-
Connect to BenchmarkEmail Data in CloverDX (formerly CloverETL)
Transfer BenchmarkEmail using the visual workflow in the CloverDX data integration tool.
-
Connect to Gumroad Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Gumroad and the SQL Gateway to access Gumroad from Google Apps Script.
-
Publish Authorize.Net-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Authorize.Net.
-
Access Aha! Data from MySQL in Amazon QuickSight
Connect to Aha! and build visualizations of Aha! using a MySQL Connection in Amazon QuickSight.
-
Edit and Search External Splunk Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Splunk to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Splunk Data objects that you can access from apps and the dashboard.
-
Connect to Chargebee in SpagoBI
Create reports featuring live Chargebee in SpagoBI Studio. Host Chargebee reports on SpagoBI Server.
-
Connect to Foursquare Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Foursquare and work with Foursquare in your FileMaker applications.
-
How to Query Avalara AvaTax Data in MySQL Workbench
Execute MySQL queries against live Avalara AvaTax from MySQL Workbench.
-
Connect to LinkedIn Ads Data from HeidiSQL
Use CData Connect AI to connect to and query live LinkedIn Ads from HeidiSQL.
-
Build AI/ML Models with Live ZohoSubscriptions Data using Dataiku
Connect ZohoSubscriptions Data with Dataiku using the CData API Driver for JDBC.
-
Establish a Live Connection with FreeAgent Data using Tableau Bridge
The CData ODBC Driver for FreeAgent enables you to integrate live FreeAgent into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Humanity Data in Aqua Data Studio
Access Humanity from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating Planio Data in Talend Cloud Data Management Platform
Connect Planio Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to publish and share Discord Data dashboards with Tableau Server
The CData ODBC driver for Discord enables you integrate Discord into Tableau dashboards.
-
Connect to Greenplum Data from PowerBuilder via ADO.NET
This article demonstrates how to access Pivotal GreenPlum from Appeon PowerBuilder using the CData ADO.NET Provider for Greenplum.
-
Connect to Marketo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Marketo to connect to Marketo from Web applications running on WebLogic.
-
Access Figshare 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 Figshare.
-
Design BIRT Reports on Jodoo Data
Provide current Jodoo to your embedded analytics.
-
Natively Connect to Microsoft Entra ID Data in PHP
The CData ODBC driver for Microsoft Entra ID enables you to create PHP applications with connectivity to Microsoft Entra ID. Leverage the native support for ODBC in PHP.
-
Bridge Oracle Eloqua Connectivity with Apache NiFi
Access and process Oracle Eloqua in Apache NiFi using the CData JDBC Driver.
-
Provide OData Services of Aha! Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Aha! by developing a WCF Service Application.
-
Import and Visualize SharePoint Excel Services Data in Power View
Create data visualizations based on SharePoint Excel Services in Excel.
-
Build MYOB AccountRight-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live MYOB AccountRight.
-
Automate SharePoint Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft SharePoint replication to Azure Data Lake.
-
Connect to Telegram Data in RazorSQL
Connect to Telegram from wizards and query Telegram from the GUI in the RazorSQL database management tool.
-
Connect to Amazon S3 Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Amazon S3 in the Denodo Virtual DataPort Administrator.
-
Bind Live QuickBooks Online Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks Online data
-
Integrate with live Instagram Data in Jitterbit
Use CData Connect AI to connect to and integrate live Instagram in Jitterbit.
-
Connect to SendPulse Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SendPulse and the SQL Gateway to access SendPulse from Google Apps Script.
-
Automated Continuous Oracle Service Cloud Replication to Oracle
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Oracle.
-
Integrate Real-Time Access to SharePoint in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft SharePoint in real time.
-
Integrating Claude Code CLI with GetResponse 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.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Azure Synapse using the Model Context Protocol.
-
Design BIRT Reports on Cosmos DB Data
Provide current Azure Cosmos DB to your embedded analytics.
-
Integrate ShipEngine with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ShipEngine with External Services.
-
Build Visualizations of ZendeskSell Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZendeskSell in Birst.
-
DataBind Charts to Anaplan Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Anaplan 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.
-
Connect to ElevenLabs Data in RapidMiner
Integrate ElevenLabs with standard components and data source configuration wizards in RapidMiner Studio.
-
Automate BigQuery Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google BigQuery and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use the CData API Server to Access Google Ad Manager Data in Microsoft PowerPivot
Use the CData API Server to connect to live Google Ad Manager in the Power Pivot business intelligence tool.
-
Integrate with Live Oracle HCM Cloud Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle HCM Cloud from the MuleSoft Anypoint Platform to integrate live Oracle HCM Cloud into custom reports and dashboards.
-
Automated Continuous Microsoft Ads Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to IBM DB2.
-
Automated Continuous QuickBooks Time Replication to Snowflake
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Snowflake.
-
Stream Aweber Data into Apache Kafka Topics
Access and stream Aweber in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Live SharePoint Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SharePoint in CData Connect AI and connect to your Microsoft SharePoint from PostgreSQL.
-
Build Dashboards with ZeroBounce Data in Dundas BI
Create dynamic dashboards and perform analytics based on ZeroBounce in Dundas BI.
-
How to Enable Write Operations on Sage Intacct with CData and Embedded Credentials
Learn how to enable write operations in Sage Intacct using embedded credentials.
-
Connect to Oracle Sales Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Sales and the Script function in FileMaker Pro to connect to Oracle Sales and work with Oracle Sales in your FileMaker application.
-
Automated Continuous Google Forms Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Forms replication to Google Cloud SQL.
-
How to Work with Oracle SCM Data in ETL Validator JDBC
Connect to Oracle SCM from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Guru in SAS for Real-Time Reporting and Analytics
Connect to real-time Guru in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Guru.
-
Automated Continuous SpaceX Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SpaceX replication to PostgreSQL.
-
Integrating GitHub Copilot CLI with JSON 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 Easily Query Hugging Face Data in OpenOffice Base
Connect to Hugging Face data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to use SQLAlchemy ORM to access BambooHR Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of BambooHR.
-
Connect to Clio Data in CloverDX (formerly CloverETL)
Transfer Clio using the visual workflow in the CloverDX data integration tool.
-
Integrating Antigravity CLI with Superchat via CData CLI
Connect Superchat to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Bridge Landbot Connectivity with Apache NiFi
Access and process Landbot in Apache NiFi using the CData JDBC Driver.
-
Integrate Real-Time Access to Xero in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Xero Accounting in real time.
-
How to Connect to Greenplum Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Pivotal GreenPlum. Leverage the pyodbc module for ODBC in Python.
-
Connect SparkPost Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SparkPost using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Work with Klaviyo Data in AWS Glue Jobs Using JDBC
Connect to Klaviyo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Work with Twitter Ads Data in ETL Validator JDBC
Connect to Twitter Ads from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Suadeo Data in JRuby
Create a simple JRuby app with access to live Suadeo.
-
Create Dashboards and Visualize Live ADP Data in Geckoboard
Use CData Connect AI to connect to live ADP and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Object-Relational Mapping (ORM) with Salesforce 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 Salesforce & Force.com into a Java-based ORM framework, Hibernate.
-
How to load Adobe Commerce data into Elasticsearch via Logstash
Introducing a simple method to load Adobe Commerce data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect PolyBase to HCL Domino
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live HCL Domino.
-
Build Semantic Layer Views for Facebook Ads Data in APOS Live Data Gateway
Use the CData Connector for Facebook Ads in APOS Live Data Gateway to build Semantic Layer Views for Facebook Ads.
-
Establish a Live Connection with SAP Fieldglass Data using Tableau Bridge
The CData ODBC Driver for SAP Fieldglass enables you to integrate live SAP Fieldglass into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Visualize Google Drive Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Drive in Python.
-
Publish Reports with GetResponse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date GetResponse.
-
Add eBay Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for eBay with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to and Query ZarMoney Data in QlikView over ODBC
Create data visualizations with ZarMoney in QlikView.
-
How to Connect to Live HBase 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 HBase through natural language.
-
Connect to Zoom Data from a Connection Pool in Jetty
The Zoom JDBC Driver supports connection pooling: This article shows how to connect faster to Zoom from Web apps in Jetty.
-
View Reports on Real-Time Impala Data in Power BI Report Server
Use the CData ODBC Driver for Impala to visualize Apache Impala in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Data Flows from SQL Server to Act-On through SSIS
Easily push SQL Server data to Act-On using the CData SSIS Tasks for Act-On.
-
Create SSAS Tabular Models from SendGrid Data
How to build a SQL Server Analysis Service Tabular Model from SendGrid using CData drivers.
-
Visualize Simplesat 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 Simplesat into TIBCO Spotfire.
-
Create Data Visualizations in Cognos BI with ChartMogul Data
Access ChartMogul as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize Google Sheets Data in Sisense
Create an ElastiCube in Sisense app with access to Google Sheets.
-
Integrate LibreChat with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Sybase IQ from within the chat interface.