CData Software - Knowledge Base
Recent Articles
-
Connect Dotmailer Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Dotmailer data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Easily Query eBay Data in OpenOffice Base
Connect to eBay data in OpenOffice Base using the CData ODBC Driver for eBay and generate reports with live data insights.
-
Connect to LaunchDarkly Data from a Connection Pool in Jetty
The LaunchDarkly JDBC Driver supports connection pooling: This article shows how to connect faster to LaunchDarkly data from Web apps in Jetty.
-
Access Live XML Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate XML data into the statistical analysis tools available in SAS JMP. This article shows how to use XML data in the Graph Builder and Query Builder.
-
Use JayDeBeApi to access HBase Data in Python
Use standard Python scripting and the development environment of your choice to access live HBase data.
-
Connect to Freshteam Data in JRuby
Create a simple JRuby app with access to live Freshteam data.
-
Build Charts with VWO Data in Clear Analytics
Create dynamic charts and perform analytics based on VWO data in Clear Analytics.
-
Natively Connect to ShipStation Data in PHP
The CData ODBC driver for ShipStation enables you to create PHP applications with connectivity to ShipStation data. Leverage the native support for ODBC in PHP.
-
Automated Continuous OneNote Replication to AlloyDB
Use CData Sync for automated, continuous, customizable OneNote replication to AlloyDB.
-
Use the CData Software ODBC Driver for Mode in SAS for Real-Time Reporting and Analytics
Connect to real-time Mode data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Mode.
-
Build Google Translate-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Translate data and build web apps with connectivity to live Google Translate data.
-
Use Manus AI to Talk to Your Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Reckon Accounts Hosted data.
-
Use Claude to Talk to Your Adobe Commerce 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 Adobe Commerce data for you.
-
Integrate with Splunk Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Splunk data in SnapLogic.
-
Access Live Presto Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Presto data from your Google Sheets.
-
Use the CData Software JDBC Driver for Google Ad Manager in MicroStrategy Desktop
Connect to Google Ad Manager data in MicroStrategy Desktop using the CData Software JDBC Driver for Google Ad Manager.
-
Automated Continuous Demio Replication to Vertica
Use CData Sync for automated, continuous, customizable Demio replication to Vertica.
-
Analyze Toggl Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Toggl from Power Pivot. You will use the Table Import Wizard to load Toggl data. You can visually build the import query or use any SQL supported by the driver.
-
Import and Visualize Ontraport Data in Power View
Create data visualizations based on Ontraport data in Excel.
-
Use Dash to Build to Web Apps on Templated Data
Create Python applications that use pandas and Dash to build Templated-connected web apps.
-
Getting Started with the CData ADO.NET Provider for Zoom
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access OneNote 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 OneNote data.
-
Build Semantic Layer Views for Zuora Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zuora data.
-
Use Claude to Talk to Your Bitly 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 Bitly data for you.
-
Access SingleStore 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 SingleStore data.
-
Connect to Helpscout from Asprova with CData Software ODBC Driver for Helpscout
This article shows how to connect faster to Helpscout data from Asprova.
-
Configure the CData JDBC Driver for Mailgun in a Connection Pool in Tomcat
Connect to Mailgun data from a connection pool in Tomcat.
-
Getting Started with the CData Tableau Connector for Avaza
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create HubDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for HubDB from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData Power BI Connector for Aha!
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Use a Microsoft Access Database to Update Couchbase Data in Real Time
Update Couchbase data by creating a linked table in Microsoft Access with the CData Couchbase ODBC Driver.
-
Connecting GenSpark with PostgreSQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to PostgreSQL data without any replication or custom integration required.
-
Automated Continuous Parquet Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Parquet replication to Apache Kafka.
-
Create Dynamic Gumroad Grids Using the Infragistics XamDataGrid
Learn how you can connect Gumroad to Infragistics XamDataGrid to build dynamic grids.
-
Query MariaDB Data in ColdFusion
Write standard ColdFusion data access code to connect to MariaDB data.
-
Build a Singer.io Tap for Google Ad Manager With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Ad Manager data using the CData Python Connector.
-
Query Brex Data in ColdFusion
Write standard ColdFusion data access code to connect to Brex data.
-
Query ZohoExpense Data as a MySQL Database in Node.js
Execute MySQL queries against ZohoExpense data from Node.js.
-
Build Voice Agents in ElevenLabs with access to Live Supabase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Supabase data.
-
Visualize Live Salesforce CRM Analytics Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Salesforce CRM Analytics data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to OpenWeatherMap Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for OpenWeatherMap to connect to OpenWeatherMap data and execute queries in PowerBuilder.
-
Integrating Cursor with Smartsheet 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.
-
Connect to HubSpot Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time HubSpot data using standard SQL.
-
Integrate OnePageCrm Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live OnePageCrm data from Informatica Cloud.
-
How to integrate Metabase with SAS xpt Data
Use CData Connect AI to connect to live SAS xpt data and create an interactive dashboard in Metabase from SAS xpt data.
-
Connect to Mailgun Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Mailgun and work with Mailgun data in your FileMaker applications.
-
Connect to Mode Data in Google Apps Script via Connect AI
Use CData Connect AI to access Mode data in Google Apps Script.
-
Build AI/ML Models with Live Printify Data using Dataiku
Connect Printify Data with Dataiku using the CData API Driver for JDBC.
-
Create Azure Data Lake Storage-Connected Dashboards in Grafana
Connect to Azure Data Lake Storage Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Azure Data Lake Storage data.
-
How to Work with Zoho Inventory Data in AWS Glue Jobs Using JDBC
Connect to Zoho Inventory from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Figshare
Provide connectivity to Figshare data through an SAP BusinessObjects universe.
-
Automated Continuous Factorial Replication to SQLite
Use CData Sync for automated, continuous, customizable Factorial replication to SQLite.
-
Visualize Power BI XMLA Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Power BI XMLA data.
-
Provide OData Services of OneNote Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for OneNote data by developing a WCF Service Application.
-
Import Active Directory Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Active Directory Data and provide access to live Active Directory data for custom reports in the Power BI Service.
-
How to update Vault CRM from Excel
This article explains how to transfer data from Excel to Vault CRM using the Excel Add-In for Vault CRM.
-
Integrate Tickspot with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Tickspot with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Tickspot data.
-
Automate Quickbase Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Quickbase data from PowerShell? This article demonstrates how to utilize the Quickbase Cmdlets for tasks like connecting to Quickbase data, automating operations, downloading data, and more.
-
How to use SQLAlchemy ORM to access Landbot Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Landbot data.
-
Access Amazon Marketplace Data from MySQL in PHP
Connect to Amazon Marketplace through the standard MySQL libraries in PHP.
-
How to Connect SAP Concur 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 SAP Concur data in real time using natural language.
-
Automated Continuous Beeminder Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Beeminder data replication to OneLake in Microsoft Fabric.
-
Integrating Printful Data in Talend Cloud Data Management Platform
Connect Printful Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Analyze Live MariaDB Data in SAS Viya
Use CData Connect AI to connect to MariaDB data from SAS Viya and deploy self-service analytics using live MariaDB data.
-
Connect to SurveyMonkey Data in JRuby
Create a simple JRuby app with access to live SurveyMonkey data.
-
Connect to ZendeskSell Data in DBArtisan
Use wizards in DBArtisan to configure ZendeskSell data as a data source.
-
Use Azure AI Foundry to Talk to Your Salesforce Pardot 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 Salesforce Pardot data for you.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP HANA XS Advanced
Create an ODBC connection to SAP HANA XS Advanced in Informatica and browse and transfer SAP HANA XS Advanced data.
-
Connect to Act CRM 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 Act CRM data.
-
Integrating Claude Code CLI with Reckon 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.
-
Connect to TaxJar Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for TaxJar data.
-
Access ClickTime Data from MySQL in Amazon QuickSight
Connect to ClickTime and build visualizations of ClickTime data using a MySQL Connection in Amazon QuickSight.
-
Integrate Open WebUI with Live Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Shopify data from within the chat interface.
-
DataBind Charts to SAP Business Warehouse Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Business Warehouse 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.
-
How to create an RPA flow for Raisers Edge NXT Data in UiPath Studio
Use the Raisers Edge NXT ODBC Driver to create workflows that access real-time Raisers Edge NXT data without any coding.
-
How to Connect to Live Impala Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Impala data for you.
-
Build MVC Applications with Connectivity to Monday.com Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Monday.com from an ASP.NET MVC application.
-
Use CData Connect AI to Access Jira Assets Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Jira Assets data in the Power Pivot business intelligence tool.
-
Create Reports with Bullhorn CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bullhorn CRM data.
-
Create Reports from Active Directory Data in Looker Studio
Use CData Connect AI to gain access to live Active Directory data and create custom reports in Looker Studio.
-
Connect to Sugar CRM Data in RazorSQL
Connect to Sugar CRM from wizards and query Sugar CRM data from the GUI in the RazorSQL database management tool.
-
Build Cosmos DB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Cosmos DB data.
-
Use Databricks Agent Bricks to Talk to Your CouchDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your CouchDB data for you.
-
Use Manus AI to Talk to Your Suadeo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Suadeo data.
-
Create Data Visualizations in Cognos BI with Harvest Data
Access Harvest data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect the Power BI Service to Gong: Complete Guide
Connect to the CData Software Power BI Connector for Gong from PowerBI.com to provide real-time Gong data across the organization.
-
Automate Helpscout Data Replication to Couchbase
Use CData Sync to Customize and automate Helpscout data replication to Couchbase.
-
Connect to and Query Pipedrive Data in QlikView over ODBC
Create data visualizations with Pipedrive data in QlikView.
-
Getting Started with the CData Python Connector for Paymo
Learn to install and license the CData Python Connector and configure a connection to live Paymo data.
-
Publish JSON-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live JSON services.
-
Build Planio-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Planio data and build web apps with connectivity to live Planio data.
-
Automated Continuous GraphQL Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable GraphQL replication to Apache Kafka.
-
Create Dynamic Sage 300 Grids Using the Infragistics XamDataGrid
Learn how you can connect Sage 300 to Infragistics XamDataGrid to build dynamic grids.
-
Load Power BI XMLA Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Power BI XMLA data to a database.
-
How to connect to Placid Data from Spring Boot
Connect to Placid in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Sendwithus Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sendwithus data replication to OneLake in Microsoft Fabric.
-
Create Informatica Mappings From/To a JDBC Data Source for Foursquare
Create Foursquare data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Stripe Data in Sisense
Create an ElastiCube in Sisense app with access to Stripe data.
-
Getting Started with the CData SSIS Components for RabbitMQ
Complete guide to installing, licensing, and connecting with the CData SSIS Components for RabbitMQ.
-
How to connect to Google Drive Data in DBVisualizer
Integrate Google Drive data with visual data analysis tools and data connection wizards in DBVisualizer