CData Software - Knowledge Base
Recent Articles
-
How to Connect to SAP Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP ERP/NetWeaver. Leverage the pyodbc module for ODBC in Python.
-
Know Your LLM (Series): ChatGPT
Comprehensive guide to ChatGPT models for enterprise AI. Learn integration patterns with CData Connect AI, model selection criteria, security compliance, and industry use cases for natural-language-to-SQL generation.
-
Automate Aweber Data Replication to SAP HANA
Use CData Sync to customize and automate Aweber replication to SAP HANA.
-
How to Query Live Google Search Results in Claude Desktop
Connect to and query live Google Search Results in Claude Desktop using CData MCP Server.
-
Automated Continuous Teamgate Replication to Oracle
Use CData Sync for automated, continuous, customizable Teamgate replication to Oracle.
-
Build Amazon Marketplace-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Amazon Marketplace to explore live Amazon Marketplace Data in Cursor to assist with building Amazon Marketplace-powered applications.
-
Connect to Excel Online Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Excel Online from your AWS Glue jobs.
-
Connect to BenchmarkEmail in SpagoBI
Create reports featuring live BenchmarkEmail in SpagoBI Studio. Host BenchmarkEmail reports on SpagoBI Server.
-
A PostgreSQL Interface for Confluence Data using the CData ODBC Driver
Use the SQL Gateway and Confluence ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SuiteCRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access SuiteCRM from Appeon PowerBuilder using the CData ADO.NET Provider for SuiteCRM.
-
Automate Facebook Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Facebook and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Validate Figshare Data with QuerySurge
Access and validate Figshare in QuerySurge using the CData JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Marketo
Create Marketo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to integrate Metabase with Cassandra Data
Use CData Connect AI to connect to live Apache Cassandra and create an interactive dashboard in Metabase from Apache Cassandra.
-
Bridge HelloSign Connectivity with Apache NiFi
Access and process HelloSign in Apache NiFi using the CData JDBC Driver.
-
Configure the CData JDBC Driver for Neo4J in a Connection Pool in Tomcat
Connect to Neo4J from a connection pool in Tomcat.
-
Connect to FTP Data in Jaspersoft Studio
Execute SQL to remote FTP Servers in Jaspersoft Studio.
-
Integrate ADP Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ADP from Informatica Cloud.
-
How to integrate Aircall with Apache Airflow
Access and process Aircall in Apache Airflow using the CData JDBC Driver.
-
Connect to and Visualize Live Office 365 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Office 365.
-
Import and Visualize Google Cloud Storage Data in Power View
Create data visualizations based on Google Cloud Storage in Excel.
-
Build Apps with Live OneNote Data Using the Low-Code Development Platform of Mendix
Connect Microsoft OneNote with Mendix to build apps using the CData JDBC Driver for OneNote.
-
Visualize Zoho Inventory Data in Sisense
Create an ElastiCube in Sisense app with access to Zoho Inventory.
-
Integrating Cursor CLI with Recurly 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 Visualize Google Sheets Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Sheets in Python.
-
How to Connect the Power BI Service to Asana: Complete Guide
Connect to the CData Software Power BI Connector for Asana from PowerBI.com to provide real-time Asana across the organization.
-
Automated Continuous SAP Ariba Procurement Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Amazon S3.
-
Integrate LibreChat with Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAS XPORT from within the chat interface.
-
Publish PivotalTracker-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live PivotalTracker.
-
Integrating Boomi Agentstudio with Microsoft Entra ID Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Entra ID, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Analyze ZarMoney Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZarMoney from Power Pivot. You will use the Table Import Wizard to load ZarMoney. You can visually build the import query or use any SQL supported by the driver.
-
Access Shopify Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Shopify from HeidiSQL.
-
Visualize Salesloft Data in TIBCO Spotfire through OData
Integrate Salesloft into dashboards in TIBCO Spotfire.
-
Migrating data from Coda to Google BigQuery using CData SSIS Components.
Easily push Coda to Google BigQuery using the CData SSIS Tasks for Coda and Google BigQuery.
-
Connect to Bannerbear Data from a Connection Pool in Jetty
The Bannerbear JDBC Driver supports connection pooling: This article shows how to connect faster to Bannerbear from Web apps in Jetty.
-
Connect to Adobe Commerce Data in DBArtisan
Use wizards in DBArtisan to configure Adobe Commerce as a data source.
-
Migrating data from Freshdesk to Databricks using CData SSIS Components.
Easily push Freshdesk to Databricks using the CData SSIS Tasks for Freshdesk and Databricks.
-
Choosing the Best Method to Connect ZohoMarketingHub to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZohoMarketingHub from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Claude to Talk to Your SendGrid 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 SendGrid for you.
-
How to Import Data from Salesforce CRM Analytics into Google Sheets
Import Salesforce CRM Analytics into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous Certinia Replication to Vertica
Use CData Sync for automated, continuous, customizable Certinia replication to Vertica.
-
Query YouTube Analytics Data through ODBC in Node.js
Use node-odbc to execute SQL queries against YouTube Analytics from Node.js.
-
Access Bright Data 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 Bright Data.
-
Create a Data Access Object for Lakebase Data using JDBI
A brief overview of creating a SQL Object API for Lakebase in JDBI.
-
Create JSON-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to JSON Services from OutSystems and build custom enterprise apps using live JSON.
-
How to Visualize Oracle Service Cloud 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 Oracle Service Cloud in Python.
-
Access AdRoll Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access AdRoll from your Oracle system.
-
Bidirectional Access to ZeroBounce Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZeroBounce in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData Python Connector for Salesforce
Learn to install and license the CData Python Connector
-
How to connect to Parquet Data from IntelliJ
Integrate connectivity to Apache Parquet with wizards in IntelliJ.
-
Query Google Cloud Storage Data as a MySQL Database in Node.js
Execute MySQL queries against Google Cloud Storage from Node.js.
-
Create Salesforce Pardot Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Salesforce Pardot from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Vercel Data in RazorSQL
Connect to Vercel from wizards and query Vercel from the GUI in the RazorSQL database management tool.
-
Connect to and Visualize Live Brex Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Brex.
-
How to Work with Oracle HCM Cloud Data in ETL Validator JDBC
Connect to Oracle HCM Cloud from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Short.io in MicroStrategy Web
Connect to Short.io in MicroStrategy Web using the CData Software ODBC Driver for Short.io.
-
Automate SQL Server Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft SQL Server replication to Couchbase.
-
Automate Google Ad Manager Data Replication to SAP HANA
Use CData Sync to customize and automate Google Ad Manager replication to SAP HANA.
-
Deploy the ADO.NET Provider for Excel Online on an SSRS Report Server
Connect to Microsoft Excel Online from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Working with Pinterest Data in LINQPad
Execute LINQ queries to Pinterest in LINQPad.
-
Work with Productboard Data in FoxPro
Load Productboard into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to SAP HANA XS Advanced Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP HANA XS Advanced from Appeon PowerBuilder using the CData ADO.NET Provider for SAP HANA XS Advanced.
-
How to Visualize Zuora 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 Zuora in Python.
-
Integrating OpenCode Terminal with Clari 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 Oracle SCM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle SCM from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle SCM.
-
Use Claude to Talk to Your Smartsheet 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 Smartsheet for you.
-
Connect to FreeAgent Data in JRuby
Create a simple JRuby app with access to live FreeAgent.
-
How to Easily Query Tanda Data in OpenOffice Base
Connect to Tanda data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Live JDBC-ODBC Bridge Data in Coginiti Pro
Connect to and query live JDBC-ODBC Bridge from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Float Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Float replication to Azure SQL Database.
-
Connecting Mastra with SAP ByDesign 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 SAP Business ByDesign, no replication required.
-
How to Connect Flowise AI Agents to Live Cosmos DB 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 Azure Cosmos DB without replication.
-
Automate Mode Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Mode from PowerShell? This article demonstrates how to utilize the Mode Cmdlets for tasks like connecting to Mode, automating operations, downloading data, and more.
-
Build ShipStation Visualizations in Tableau Cloud
Use CData Connect AI to connect to live ShipStation and build visualizations in Tableau Cloud.
-
DataBind Charts to Landbot Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Landbot 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 Shortcut Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Shortcut in the Denodo Virtual DataPort Administrator.
-
Build Apps with Live Optimizely Data Using the Low-Code Development Platform of Mendix
Connect Optimizely with Mendix to build apps using the CData API Driver for JDBC.
-
Access Live ServiceNow 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 ServiceNow through MCP integration.
-
Enable the Snapchat Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Snapchat Ads.
-
Connect to Real-Time PingOne Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for PingOne and Dataflow to import and use PingOne in Power Apps.
-
How to Connect to Live Monday.com 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 Monday.com for you.
-
Getting Started with the CData Excel Add-In for Jira
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Jira.
-
Use Dash to Build to Web Apps on Rootly Data
Create Python applications that use pandas and Dash to build Rootly-connected web apps.
-
Connect to IBM Cloud Object Storage Data from Crystal Reports
Use CData Connect AI to connect to and report on live IBM Cloud Object Storage from Crystal Reports.
-
How to Connect DBeaver to XML via a JDBC Driver
Manage XML Files with visual tools in DBeaver like the query browser.
-
Choosing the Best Method to Connect xBase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use xBase from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connecting GenSpark with Greenplum Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Pivotal GreenPlum without any replication or custom integration required.
-
Integrating Kiro CLI with FHIR 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.
-
Access Live xBase Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate xBase into the statistical analysis tools available in SAS JMP. This article shows how to use xBase in the Graph Builder and Query Builder.
-
Create Informatica Mappings From/To a JDBC Data Source for Harvest
Create Harvest data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData ODBC Driver for Miro in Microsoft Power Query
You can use the CData Miro ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Miro into Microsoft Power Query.
-
Connect to Live CockroachDB Data in MicroStrategy through CData Connect AI
Create a live connection to CockroachDB Data in CData Connect AI and connect to your CockroachDB from MicroStrategy.
-
Build SharePoint-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SharePoint to explore live SharePoint Data in Claude Code to assist with building SharePoint-powered applications.
-
Integrate with Teamwork Data in JReport Designer
Create charts and reports based on Teamwork in JReport Designer.
-
ETL Flowlu in Oracle Data Integrator
This article shows how to transfer Flowlu into a data warehouse using Oracle Data Integrator.
-
Build Charts with Square Data in Clear Analytics
Create dynamic charts and perform analytics based on Square in Clear Analytics.
-
How to Easily Query Avaza Data in OpenOffice Base
Connect to Avaza data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Mode Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Mode facts in real time.
-
Connect to CSV from a Connection Pool in WebLogic
Use the CData JDBC Driver for CSV to connect to CSV/TSV Files from Web applications running on WebLogic.
-
How to Work with Jodoo Data in ETL Validator JDBC
Connect to Jodoo from ETL Validator jobs using the CData Software JDBC Driver.