CData Software - Knowledge Base
Recent Articles
-
Natively Connect to ConvertKit Data in PHP
The CData ODBC driver for ConvertKit enables you to create PHP applications with connectivity to ConvertKit data. Leverage the native support for ODBC in PHP.
-
Create Reports with Demio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Demio data.
-
Access Live Xero 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 Xero data through MCP integration.
-
LINQ to GraphQL 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 GraphQL Data Provider.
-
Access Raisers Edge NXT Data from MySQL in PHP
Connect to Raisers Edge NXT through the standard MySQL libraries in PHP.
-
A PostgreSQL Interface for Samanage Data using the CData ODBC Driver
Use the SQL Gateway and Samanage ODBC Driver to create a PostgreSQL entry-point for data access.
-
Explore Geographical Relationships in Beeminder Data with Power Map
Create data visualizations with Beeminder data in Power Map.
-
Integrating OpenCode with Mode 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 create an RPA flow for Tavily Data in UiPath Studio
Use the Tavily ODBC Driver to create workflows that access real-time Tavily data without any coding.
-
Connect to Zoho Books Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zoho Books as an External Source in Dremio.
-
Use the CData Software ODBC Driver for Recurly in SAS for Real-Time Reporting and Analytics
Connect to real-time Recurly data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Recurly.
-
Visualize ChartMogul Data in TIBCO Spotfire through ADO.NET
Integrate ChartMogul data into dashboards in TIBCO Spotfire.
-
Integrate with live Office 365 Data in Jitterbit
Use CData Connect AI to connect to and integrate live Office 365 data in Jitterbit.
-
Import and Visualize Phoenix Data in Power View
Create data visualizations based on Phoenix data in Excel.
-
How to load Retently data into Elasticsearch via Logstash
Introducing a simple method to load Retently data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Data Visualizations Based On Office 365 Data in Mode
Use CData Connect AI to connect to Office 365 Data from Mode and build visualizations using live Office 365 data.
-
Link Quaderno with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Quaderno data in Filemaker Pro for Mac or Windows.
-
Access Sendwithus Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sendwithus data from your Oracle system.
-
Connect to Harvest Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Harvest data in the Denodo Virtual DataPort Administrator.
-
Integrate Open WebUI with Live Coda Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Coda data from within the chat interface.
-
Create Dynamic Gong Grids Using the Infragistics XamDataGrid
Learn how you can connect Gong to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Oracle Eloqua Reporting Data to Multiple Databases via the CData Sync CLI
Replicate Oracle Eloqua Reporting data to disparate databases with a single configuration.
-
Access Paddle 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 Paddle data.
-
Connect to IBM Cloud Object Storage Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for IBM Cloud Object Storage and the Script function in FileMaker Pro to connect to IBM Cloud Object Storage and work with IBM Cloud Object Storage data in your FileMaker application.
-
Connect to Azure Data Lake Storage Data in Ruby
Connect to Azure Data Lake Storage data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Sage 300 Data in TIBCO Spotfire through OData
Integrate Sage 300 data into dashboards in TIBCO Spotfire.
-
Automated Continuous Active Directory Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Active Directory replication to delimited files (CSV/TSV).
-
Automated Continuous Kafka Replication to SingleStore
Use CData Sync for automated, continuous, customizable Kafka replication to SingleStore.
-
Automated Continuous Adobe Target Replication to MySQL
Use CData Sync for automated, continuous, customizable Adobe Target replication to MySQL.
-
Use Dash to Build Web Apps on PayPal Data via CData Connect AI
Build interactive Dash web apps on live PayPal data using pandas and the CData Connect AI Python SDK.
-
Replicate Strava Data to Multiple Databases via the CData Sync CLI
Replicate Strava data to disparate databases with a single configuration.
-
Configure the CData JDBC Driver for HelloSign in a Connection Pool in Tomcat
Connect to HelloSign data from a connection pool in Tomcat.
-
How to work with Sendwithus Data in Apache Spark using SQL
Access and process Sendwithus Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Google's Vertex AI Agent with Live Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Jira data within intelligent workflows.
-
Connect to Customer.io Data in Aqua Data Studio
Access Customer.io data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect Trello Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Trello data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Import and Visualize Harvest Data in Power View
Create data visualizations based on Harvest data in Excel.
-
Connect to Salesforce Pardot Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Salesforce Pardot to connect to Salesforce Pardot data and execute queries in PowerBuilder.
-
Build AI/ML Models with Live Samanage Data using Dataiku
Connect Samanage Data with Dataiku using the CData API Driver for JDBC.
-
How to Work with RSS Feeds in ETL Validator JDBC
Connect to RSS from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Datasets from ChartMogul in Domo Workbench and Build Visualizations of ChartMogul Data in Domo
Use the CData Software ODBC Driver for ChartMogul to create datasets from ChartMogul data in Domo Workbench and then build visualizations in the Domo service.
-
Extract, Transform, and Load Calendly Data in Informatica PowerCenter
Create a simple Workflow for Calendly data in Informatica PowerCenter.
-
How to Connect to BambooHR Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to BambooHR data. Leverage the pyodbc module for ODBC in Python.
-
How to Visualize Neo4J 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 Neo4J data in Python.
-
Automated Continuous HelloSign Replication to Snowflake
Use CData Sync for automated, continuous, customizable HelloSign replication to Snowflake.
-
How to Connect to SAP SuccessFactors LMS Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP SuccessFactors LMS data. Leverage the pyodbc module for ODBC in Python.
-
How to Work with Apollo Data in ETL Validator JDBC
Connect to Apollo from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Dashboards and Visualize Live Sybase Data in Geckoboard
Use CData Connect AI to connect to live Sybase data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Google Calendar from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Calendar data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live Microsoft Entra ID Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Entra ID data from your Google Sheets.
-
Automate Smartsheet Data Replication to Couchbase
Use CData Sync to Customize and automate Smartsheet data replication to Couchbase.
-
Connect to Browserless Data in NetBeans
Connect to Browserless data in NetBeans with the data source configuration wizard.
-
How to Work with Nethunt Data in ETL Validator JDBC
Connect to Nethunt from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Omnisend Replication to Vertica
Use CData Sync for automated, continuous, customizable Omnisend replication to Vertica.
-
Access Impala 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 Impala data.
-
Connect to Amazon DynamoDB Data in HULFT Integrate
Connect to Amazon DynamoDB as a JDBC data source in HULFT Integrate
-
Use Dash to Build to Web Apps on SAP Ariba Source Data
Create Python applications that use pandas and Dash to build SAP Ariba Source-connected web apps.
-
Automated Continuous Figshare Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Figshare replication to Apache Cassandra.
-
Connect and Query Live SAP Netweaver Gateway Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP Netweaver Gateway data into Databricks and enable direct, live querying and analysis without replication.
-
Automate Teamgate Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Teamgate data from PowerShell? This article demonstrates how to utilize the Teamgate Cmdlets for tasks like connecting to Teamgate data, automating operations, downloading data, and more.
-
Operational Reporting on FHIR Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote FHIR data.
-
Connect Okta Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Okta data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Model Oracle SCM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Oracle SCM, enabling the direct import of real-time Oracle SCM data.
-
Connect to PostgreSQL Data from a Connection Pool in Jetty
The PostgreSQL JDBC Driver supports connection pooling: This article shows how to connect faster to PostgreSQL data from Web apps in Jetty.
-
Access TaxJar Data from MySQL in Amazon QuickSight
Connect to TaxJar and build visualizations of TaxJar data using a MySQL Connection in Amazon QuickSight.
-
Integrate OpenCode with Live BigCommerce Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live BigCommerce data from within your AI coding agent.
-
Visualize Live Timely Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Timely data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Perplexity Data to Multiple Databases
Replicate Perplexity data to disparate databases with a point-and-click configuration.
-
Greenplum Reporting in OBIEE with the Greenplum JDBC Driver
Deploy the Greenplum JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Getting Started with the CData Tableau Connector for Gmail
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Gmail.
-
How to Work with QuickBooks Online Data in ETL Validator JDBC
Connect to QuickBooks Online from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to LeadDesk Data in RazorSQL
Connect to LeadDesk from wizards and query LeadDesk data from the GUI in the RazorSQL database management tool.
-
How to Build an ETL App for ShipStation Data in Python with CData Connect AI
Extract and transform live ShipStation data in Python with petl and the CData Connect AI Python SDK.
-
How to Build an ETL App for FTP Data in Python with CData
Create ETL applications and real-time data pipelines for FTP data in Python with petl.
-
Publish Oracle SCM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Oracle SCM data.
-
How to Connect to & Open Twilio Data in Microsoft Excel
This article uses the CData ODBC driver for Twilio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dashboards with BenchmarkEmail Data in Dundas BI
Create dynamic dashboards and perform analytics based on BenchmarkEmail data in Dundas BI.
-
Access ZarMoney Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZarMoney data from HeidiSQL.
-
Automated Continuous Google Analytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Analytics replication to PostgreSQL.
-
Getting Started with the CData Tableau Connector for Greenplum
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Greenplum.
-
Integrate Devin with Live Google Directory Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Google Directory data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Deel
Provide connectivity to Deel data through an SAP BusinessObjects universe.
-
Integrate Google's Antigravity Agent with Live SFTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SFTP data using the Model Context Protocol.
-
Validate Notion Data with QuerySurge
Access and validate Notion data in QuerySurge using the CData JDBC Driver.
-
How to connect SharePoint with Pipedrive Data through external lists
Provide Pipedrive data to SharePoint users as an external list.
-
Connect to SAP Netweaver Gateway Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP Netweaver Gateway and the SQL Gateway to access SAP Netweaver Gateway data from Google Apps Script.
-
Visualize Freshteam Data in Tableau
The CData ODBC driver for Freshteam enables you integrate Freshteam data into Tableau dashboards.
-
Getting Started with the CData Python Connector for Wistia
Learn to install and license the CData Python Connector and configure a connection to live Wistia data.
-
Connect to LinkedIn Ads Data in Aqua Data Studio
Access LinkedIn Ads data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connecting Mastra with Couchbase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Couchbase data, no replication required.
-
Getting Started with the CData Excel Add-In for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ScrapingBee.
-
Connect to Testmonitor Data in RazorSQL
Connect to Testmonitor from wizards and query Testmonitor data from the GUI in the RazorSQL database management tool.
-
Choosing the Best Method to Connect JSON to SQL Server: 5 Options Explained
Discover multiple ways to connect and use JSON services from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to QuickBooks Time Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for QuickBooks Time to connect to QuickBooks Time data and execute queries in PowerBuilder.
-
Build SAP Fieldglass Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Fieldglass data and build visualizations in Tableau Cloud.
-
Build Apps with Live Klipfolio data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Klipfolio data into the Adalo platform and build custom mobile and web applications with real-time Klipfolio data.
-
Automated Continuous Dynamics 365 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Amazon S3.
-
Create Oracle Eloqua-Connected Business Apps in AppSheet
Connect to Oracle Eloqua Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle Eloqua data.
-
Choosing the Best Method to Connect Microsoft Dataverse to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Dataverse data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Dynamics NAV Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Dynamics NAV Data and connect to Dynamics NAV data in Akorbi Digital RunMyProcess.