CData Software - Knowledge Base
Recent Articles
-
Build Visualizations of eBay Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of eBay in Birst.
-
Feed Short.io Data into FineReport
How to set Short.io as a JDBC data source in FineReport.
-
Build WooCommerce-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for WooCommerce to explore live WooCommerce Data in GitHub Copilot to assist with building WooCommerce-powered applications.
-
Analyze ActiveCampaign Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ActiveCampaign from Power Pivot. You will use the Table Import Wizard to load ActiveCampaign. You can visually build the import query or use any SQL supported by the driver.
-
Migrating data from Autopilot to Databricks using CData SSIS Components.
Easily push Autopilot to Databricks using the CData SSIS Tasks for Autopilot and Databricks.
-
Integrating FreshBooks Data in Talend Cloud Data Management Platform
Connect FreshBooks Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Getting Started with the CData ADO.NET Provider for PivotalTracker
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Rapidly Develop Google Analytics-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 Google Analytics.
-
View Reports on Real-Time ZohoMarketingHub Data in Power BI Report Server
Use the CData ODBC Driver for ZohoMarketingHub to visualize ZohoMarketingHub in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate Missive Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Missive from PowerShell? This article demonstrates how to utilize the Missive Cmdlets for tasks like connecting to Missive, automating operations, downloading data, and more.
-
Create Dynamic Sugar CRM Grids Using the Infragistics XamDataGrid
Learn how you can connect Sugar CRM to Infragistics XamDataGrid to build dynamic grids.
-
Create Informatica Mappings From/To an ODBC Data Source for SingleStore
Create an ODBC connection to SingleStore in Informatica and browse and transfer SingleStore.
-
Analyze SingleStore Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SingleStore and visualize SingleStore in SAP Analytics Cloud.
-
Getting Started with the CData Python Connector for SurveyMonkey
Learn to install and license the CData Python Connector
-
Connect to VWO Data from a Connection Pool in JBoss
Integrate VWO into Java servlets: Use the Management Console in JBoss to install the VWO JDBC Driver.
-
Connect FormSite to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect FormSite with IBM WebSphere for seamless data integration and connectivity.
-
Create Dynamic QuickBooks Grids Using the Infragistics XamDataGrid
Learn how you can connect QuickBooks to Infragistics XamDataGrid to build dynamic grids.
-
Access Live GitLab Data in AWS Lambda (with IntelliJ IDEA)
Connect to live GitLab in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData Excel Add-In for Google Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Analytics.
-
Access Live Jira Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Atlassian Jira through MCP integration.
-
How to connect Amazon QuickSight to Oracle Service Cloud Data
Create a connection to Oracle Service Cloud in CData Connect AI and insert Oracle Service Cloud into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Anaplan 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 Anaplan.
-
How to connect to Figshare Data with Squirrel SQL client
Connect to Figshare and execute queries in the Squirrel SQL Client.
-
How to Connect to Live Amazon DynamoDB 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 Amazon DynamoDB for you.
-
Getting Started with the CData ODBC Driver for Instagram
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Instagram.
-
Automated Continuous SAP HANA XS Advanced Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to OneLake in Microsoft Fabric.
-
Connect to Phoenix Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Phoenix as an External Source in Dremio.
-
Analyze Close Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Close and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Opsgenie Reporting in OBIEE with the Opsgenie JDBC Driver
Deploy the Opsgenie JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Keap Data from a Connection Pool in Jetty
The Keap JDBC Driver supports connection pooling: This article shows how to connect faster to Keap from Web apps in Jetty.
-
Analyze Google Sheets Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Sheets and visualize live Google Sheets in Infragistics Reveal.
-
Visualize Keap Data in TIBCO Spotfire through OData
Integrate Keap into dashboards in TIBCO Spotfire.
-
Visualize Sybase Data in Tableau
The CData ODBC driver for Sybase enables you integrate Sybase into Tableau dashboards.
-
Integrate with Vertica Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Vertica in SnapLogic.
-
Connect Teamwork to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Teamwork with IBM WebSphere for seamless data integration and connectivity.
-
Design BIRT Reports on LinkedIn Data
Provide current LinkedIn to your embedded analytics.
-
DataBind Controls to HubDB Data in C++Builder
DataBind to HubDB in C++Builder with standard components and controls.
-
Easily Integrate VWO Data in Lazarus Pascal IDE
Learn how to easily integrate live VWO in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Hive Data from AWS Glue
Use CData Connect AI to gain access to live Apache Hive from your AWS Glue jobs.
-
Load SAP HANA XS Advanced Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP HANA XS Advanced to a database.
-
Connect to Flowlu Data in Aqua Data Studio
Access Flowlu from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connecting Moonlit Workflow with SAP Ariba Source Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAP Ariba Source in real time.
-
Use Dash to Build to Web Apps on OneNote Data
Create Python applications that use pandas and Dash to build OneNote-connected web apps.
-
How to Connect the Power BI Service to Oracle Service Cloud: Complete Guide
Connect to the CData Software Power BI Connector for Oracle Service Cloud from PowerBI.com to provide real-time Oracle Service Cloud across the organization.
-
Use the CData Software JDBC Driver for ServiceDesk Plus in MicroStrategy Web
Connect to ServiceDesk Plus in MicroStrategy Web using the CData Software JDBC Driver for ServiceDesk Plus.
-
Automated Continuous AfterShip Replication to IBM DB2
Use CData Sync for automated, continuous, customizable AfterShip replication to IBM DB2.
-
Access Live Pipedrive Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Pipedrive from your Excel spreadsheets.
-
Connect to GitLab Data from a Connection Pool in JBoss
Integrate GitLab into Java servlets: Use the Management Console in JBoss to install the GitLab JDBC Driver.
-
Model, Search, and Visualize Live Google Search Results in ThoughtSpot
Use CData Connect AI to connect to live Google Search for modeling, searching, and visualizing.
-
How to Easily Query CircleCI Data in OpenOffice Base
Connect to CircleCI data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
A PostgreSQL Interface for Freshdesk Data (MySQL Remoting via JDBC)
Use the Remoting features of the Freshdesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to QuickBooks Time 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 QuickBooks Time.
-
Connect to Asana from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Asana, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Pipeline CRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Pipeline CRM as an External Source in Dremio.
-
How to Connect Flowise AI Agents to Live Zoom 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 Zoom without replication.
-
Connect to and Query FreshBooks Data in QlikView over ODBC
Create data visualizations with FreshBooks in QlikView.
-
Create GraphQL Dataflows on PowerBI.com
Connect to the CData Power BI Connector for GraphQL from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Work with Oracle Financials Cloud Data in ETL Validator JDBC
Connect to Oracle Financials Cloud from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Instantly to Power BI dashboards. Simply drag and drop Instantly into data visuals on the Power BI canvas.
-
Build Agents in Relevance AI with Access to Live Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Spanner within intelligent agent workflows.
-
Connect to Google Ad Manager Data in Ruby
Connect to Google Ad Manager in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access FreshBooks 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 FreshBooks.
-
How to publish and share Guru Data dashboards with Tableau Server
The CData ODBC driver for Guru enables you integrate Guru into Tableau dashboards.
-
Use JayDeBeApi to access Pipeline CRM Data in Python
Use standard Python scripting and the development environment of your choice to access live Pipeline CRM.
-
Automated Continuous Pingdom Replication to MongoDB
Use CData Sync for automated, continuous, customizable Pingdom replication to MongoDB.
-
Use the CData Software ODBC Driver for Avaza in SAS for Real-Time Reporting and Analytics
Connect to real-time Avaza in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Avaza.
-
Automate Sybase IQ Data Replication to Couchbase
Use CData Sync to Customize and automate Sybase IQ replication to Couchbase.
-
Connect AlloyDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect AlloyDB with IBM WebSphere for seamless data integration and connectivity.
-
Import Real-Time Recurly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Recurly in ColdFusion.
-
Integrating Gumloop with Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Airtable within automated workflows.
-
Visualize PagerDuty Data in TIBCO Spotfire through ADO.NET
Integrate PagerDuty into dashboards in TIBCO Spotfire.
-
Easily Integrate Amazon Marketplace Data in Lazarus Pascal IDE
Learn how to easily integrate live Amazon Marketplace in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to connect to Mode Data from IntelliJ
Integrate connectivity to Mode with wizards in IntelliJ.
-
Natively Connect to Todoist Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Todoist. Leverage the native support for ODBC in PHP.
-
Integrating Claude Code CLI with Bannerbear 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.
-
Create Dynamic CircleCI Grids Using the Infragistics XamDataGrid
Learn how you can connect CircleCI to Infragistics XamDataGrid to build dynamic grids.
-
Analyze Strava Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Strava and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Snapchat Ads Data from AWS Glue
Use CData Connect AI to gain access to live Snapchat Ads from your AWS Glue jobs.
-
Query Gorgias Data as a MySQL Database in Node.js
Execute MySQL queries against Gorgias from Node.js.
-
Operational Reporting on Aweber Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Aweber.
-
Integrating Boomi Agentstudio with API Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to API, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live CouchDB Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Apache CouchDB from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create GetResponse Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time GetResponse data access from reports, embedded analytics, and more.
-
Access Live Salesforce Marketing Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Salesforce Marketing Cloud through MCP integration.
-
How to create an RPA flow for Reckon Data in UiPath Studio
Use the Reckon ODBC Driver to create workflows that access real-time Reckon without any coding.
-
How to Connect to Live HBase Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Apache HBase securely in real time.
-
Analyze Oracle SCM Data in Looker
Use CData Connect AI to connect to Oracle SCM Data from Looker and build custom apps using live Oracle SCM.
-
Connect to Campaigner from Asprova with CData Software ODBC Driver for Campaigner
This article shows how to connect faster to Campaigner data from Asprova.
-
Amazon Marketplace Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Amazon Marketplace through CData Connect AI using different applications and tools.
-
Access Live ChartMogul Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a ChartMogul data source in TIBCO Data Virtualization Studio and gain access to live ChartMogul from your TDV Server.
-
Access Live Zoho Inventory Data in Coginiti Pro
Connect to and query live Zoho Inventory from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Power BI Connector for Planio
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to publish and share Azure Data Catalog Data dashboards with Tableau Server
The CData ODBC driver for Azure Data Catalog enables you integrate Azure Data Catalog into Tableau dashboards.
-
Query Greenhouse Data in DataGrip
Create a Data Source for Greenhouse in DataGrip and use SQL to query live Greenhouse.
-
Connect to Real-Time Sage Intacct Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sage Intacct and Dataflow to import and use Sage Intacct in Power Apps.
-
Connect to Google Forms Data from PowerBuilder via JDBC
This article demonstrates how to access Google Forms from PowerBuilder using the Google Forms JDBC Driver.
-
Access Live Templated Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Templated into the statistical analysis tools available in SAS JMP. This article shows how to use Templated in the Graph Builder and Query Builder.
-
Access Live Pipeline CRM Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Pipeline CRM data source in TIBCO Data Virtualization Studio and gain access to live Pipeline CRM from your TDV Server.
-
Build Microsoft Planner Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Planner and build visualizations in Tableau.
-
How to Easily Query Azure Data Lake Storage Data in OpenOffice Base
Connect to Azure Data Lake Storage data in OpenOffice Base using the CData ODBC Driver for Azure Data Lake Storage and generate reports with live data insights.