CData Software - Knowledge Base
Recent Articles
-
How to Easily Query Square Data in OpenOffice Base
Connect to Square data in OpenOffice Base using the CData ODBC Driver for Square and generate reports with live data insights.
-
Connect to SAP Hybris C4C Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP Hybris C4C data in Airbyte.
-
How to Visualize Email Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Email data in Python.
-
Integrate Goose with Live Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Hive data from within the local AI agent.
-
Create Reports from Presto Data in Looker Studio
Use CData Connect AI to gain access to live Presto data and create custom reports in Looker Studio.
-
Natively Connect to IBM Informix Data in PHP
The CData ODBC driver for IBM Informix enables you to create PHP applications with connectivity to IBM Informix data. Leverage the native support for ODBC in PHP.
-
Create Aweber-Connected Business Apps in AppSheet
Connect to Aweber Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Aweber data.
-
Load Salesloft Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesloft data to a database.
-
Getting Started with the CData ADO.NET Provider for Wave Financial
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Wave Financial.
-
Integrating Boomi Agentstudio with Shippo Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Shippo data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Query Oracle Financials Cloud Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle Financials Cloud data from Node.js.
-
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 Cassandra data.
-
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 data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Validate Egnyte Data with QuerySurge
Access and validate Egnyte data in QuerySurge using the CData JDBC Driver.
-
How to Connect Flowise AI Agents to Live QuickBooks Time 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 QuickBooks Time data without replication.
-
Create EnterpriseDB-Connected Business Apps in AppSheet
Connect to EnterpriseDB Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to EnterpriseDB data.
-
Rapidly Develop Discourse-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 Discourse.
-
Integrate Theia IDE with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Microsoft Dataverse data from within the development environment.
-
Build AI Agents with Presto Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Presto data through CData Connect AI.
-
Connect to ZohoInvoice Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZohoInvoice data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Bitbucket Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Bitbucket data access from reports, embedded analytics, and more.
-
Access MySQL Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MySQL data from your Oracle system.
-
Establish a Live Connection with Teamgate Data using Tableau Bridge
The CData ODBC Driver for Teamgate enables you to integrate live Teamgate data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software JDBC Driver for Rootly in MicroStrategy
Connect to Rootly data in MicroStrategy Developer using the CData Software JDBC Driver for Rootly.
-
Replicate Multiple Bitly Accounts via the CData Sync CLI
Replicate multiple Bitly accounts to one or many databases.
-
Create Datasets from JSON in Domo Workbench and Build Visualizations of JSON Services in Domo
Use the CData Software ODBC Driver for JSON to create datasets from JSON services in Domo Workbench and then build visualizations in the Domo service.
-
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 data in your FileMaker applications.
-
Automate NetSuite SuiteAnalytics Data Replication to Azure Synapse
Use CData Sync to customize and automate NetSuite SuiteAnalytics data replication to Azure Synapse.
-
Analyze Reckon Accounts Hosted Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Reckon Accounts Hosted data and visualize live Reckon Accounts Hosted data in Infragistics Reveal.
-
How to use SQLAlchemy ORM to access Perplexity Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Perplexity data.
-
How to Connect to ScrapingBee Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ScrapingBee data. Leverage the pyodbc module for ODBC in Python.
-
Integrate OpenCode with Live Couchbase Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Couchbase data from within your AI coding agent.
-
Integrate Tavily Data in Pentaho Data Integration
Build ETL pipelines based on Tavily data in the Pentaho Data Integration tool.
-
Use JayDeBeApi to access Exact Online Data in Python
Use standard Python scripting and the development environment of your choice to access live Exact Online data.
-
Integrating Claude Code CLI with Tavily 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 Connect Highrise Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Highrise data in real time using natural language.
-
Automated Continuous Parallel Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Parallel replication to Apache Kafka.
-
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 SharePoint data in real time.
-
Connect to SAP BusinessObjects BI Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP BusinessObjects BI data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP BusinessObjects BI.
-
DataBind Controls to GetResponse Data in C++Builder
DataBind to GetResponse data in C++Builder with standard components and controls.
-
Use the CData Software ODBC Driver for PabblySubscriptions in MicroStrategy
Connect to PabblySubscriptions data in MicroStrategy Developer using the CData Software ODBC Driver for PabblySubscriptions.
-
DataBind Charts to Anaplan Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Anaplan data 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.
-
Visualize Live Freshteam Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Freshteam data.
-
Build an OLAP Cube in SSAS from Clari Data
Establish a connection to Clari data data from SQL Server Analysis Services, and use the Clari Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect to Oracle Financials Cloud Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle Financials Cloud data. Leverage the pyodbc module for ODBC in Python.
-
LINQ to AdRoll 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 AdRoll Data Provider.
-
Getting Started with the CData SSIS Components for Certinia
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Certinia.
-
Connecting GenSpark with Splunk Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Splunk data without any replication or custom integration required.
-
Connect to ShipStation Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ShipStation data in the Denodo Virtual DataPort Administrator.
-
Extract, Transform, and Load SAP Business Warehouse Data in Informatica PowerCenter
Create a simple Workflow for SAP Business Warehouse data in Informatica PowerCenter.
-
Connect to Typeform Data in DBeaver
Use the CData ODBC Driver to connect to Typeform data in DBeaver.
-
Build BigCommerce-Connected Apps in Choreo
Use CData Connect AI to connect to BigCommerce Data from Choreo and build custom apps using live BigCommerce data.
-
Integrate Live SAS Data Sets Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAS Data Sets from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAS Data Sets data.
-
How to connect PolyBase to FreshBooks
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live FreshBooks data.
-
Automated Continuous SpaceX Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SpaceX replication to PostgreSQL.
-
Connect to Stripe Data in JRuby
Create a simple JRuby app with access to live Stripe data.
-
Build Agents in Relevance AI with Access to Live ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ShipStation data within intelligent agent workflows.
-
How to Visualize Notion Data in Python with pandas
Use pandas and other modules to analyze and visualize live Notion data in Python.
-
Feed Jumpseller Data into FineReport
How to set Jumpseller data as a JDBC data source in FineReport.
-
Create Exact Online Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Exact Online from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live YouTube Analytics Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate YouTube Analytics data into the statistical analysis tools available in SAS JMP. This article shows how to use YouTube Analytics data in the Graph Builder and Query Builder.
-
Use the CData Software ODBC Driver for Float in MicroStrategy Desktop
Connect to Float data in MicroStrategy Desktop using the CData Software ODBC Driver for Float.
-
Build Semantic Layer Views for Instagram Data in APOS Live Data Gateway
Use the CData Connector for Instagram in APOS Live Data Gateway to build Semantic Layer Views for Instagram data.
-
How to Build an ETL App for Gong Data in Python with CData
Create ETL applications and real-time data pipelines for Gong data in Python with petl.
-
Build Voice Agents in ElevenLabs with access to Live Mailjet Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Mailjet data.
-
Create Dashboards and Visualize Live ADP Data in Geckoboard
Use CData Connect AI to connect to live ADP data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData Software JDBC Driver for xBase in MicroStrategy Web
Connect to xBase data in MicroStrategy Web using the CData Software JDBC Driver for xBase.
-
Create Dynamic PhantomBuster Grids Using the Infragistics XamDataGrid
Learn how you can connect PhantomBuster to Infragistics XamDataGrid to build dynamic grids.
-
Publish Reports with GetResponse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date GetResponse data.
-
How to Connect to Live Oracle Service Cloud Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Oracle Service Cloud data without replication.
-
Bidirectional Access to WooCommerce Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate WooCommerce data in Filemaker Pro for Mac or Windows.
-
How to Connect to Live Oracle Eloqua 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 Oracle Eloqua data for you.
-
How to Work with Bannerbear Data in ETL Validator JDBC
Connect to Bannerbear from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Power BI Reports on Real-Time Timely Data
Use the CData ODBC Driver for Timely to visualize Timely data in Power BI Desktop.
-
Migrating data from Highrise to Snowflake using CData SSIS Components.
Easily push Highrise data to Snowflake using the CData SSIS Tasks for Highrise and Snowflake.
-
Build Semantic Layer Views for Salesforce Marketing Data in APOS Live Data Gateway
Use the CData Connector for Salesforce Marketing in APOS Live Data Gateway to build Semantic Layer Views for Salesforce Marketing data.
-
Establish a Live Connection with Autopilot Data using Tableau Bridge
The CData ODBC Driver for Autopilot enables you to integrate live Autopilot data into Tableau Cloud dashboards using the Tableau Bridge.
-
Publish Crystal Reports on NetSuite Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date NetSuite data.
-
How to Connect to Live SFTP 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 SFTP data for you.
-
Connect to YouTube Analytics Data as an External Source in Dremio
Use the CData JDBC Driver to connect to YouTube Analytics as an External Source in Dremio.
-
Use Claude to Talk to Your AgileCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your AgileCRM data for you.
-
Use the CData Software ODBC Driver for Datadog in SAS for Real-Time Reporting and Analytics
Connect to real-time Datadog data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Datadog.
-
Connect to SAP Ariba Procurement Data from a Connection Pool in Jetty
The SAP Ariba Procurement JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Ariba Procurement data from Web apps in Jetty.
-
Analyze ActiveCampaign Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ActiveCampaign data in Microsoft R Open.
-
Use CData Connect AI to Access Aweber Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Aweber data in the Power Pivot business intelligence tool.
-
DataBind Microsoft Ads Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Microsoft Ads with the DevExpress Windows Forms and Web controls to provide Microsoft Ads data to a chart.
-
Analyze Raisers Edge NXT Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Raisers Edge NXT data with the CData JDBC Driver for Raisers Edge NXT.
-
Getting Started with the CData Power BI Connector for IBM Informix
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for IBM Informix.
-
Connect to Greenhouse Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Greenhouse and the SQL Gateway to access Greenhouse data from Google Apps Script.
-
Bind Live Bullhorn CRM Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Bullhorn CRM data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Access Adobe Experience Manager Data from MySQL in Amazon QuickSight
Connect to Adobe Experience Manager and build visualizations of Adobe Experience Manager data using a MySQL Connection in Amazon QuickSight.
-
Query Amazon Athena Data in ColdFusion
Write standard ColdFusion data access code to connect to Amazon Athena data.
-
Automated Continuous Shortcut Replication to Databricks
Use CData Sync for automated, continuous, customizable Shortcut replication to Databricks.
-
Bind Live Vault CRM Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Vault CRM data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrating GitHub Copilot with Eventbrite 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.
-
Replicate Jira Assets Data in Heroku for Use in Salesforce Connect
Replicate Jira Assets data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Mocean Data from a Connection Pool in Jetty
The Mocean JDBC Driver supports connection pooling: This article shows how to connect faster to Mocean data from Web apps in Jetty.
-
Automated Continuous Zoho Inventory Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to AlloyDB.
-
Stream Clari Data into Apache Kafka Topics
Access and stream Clari data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.