CData Software - Knowledge Base
Recent Articles
-
Working with Samanage Data in LINQPad
Execute LINQ queries to Samanage data in LINQPad.
-
Build Dashboards with Opsgenie Data in DBxtra
Create dynamic dashboards and perform analytics based on Opsgenie data in DBxtra.
-
How to connect to Suadeo Data in DBVisualizer
Integrate Suadeo data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live Redshift Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Redshift data from your Google Sheets.
-
How to use SQLAlchemy ORM to access SendGrid Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SendGrid data.
-
How to connect to eBay Data with Squirrel SQL client
Connect to eBay data and execute queries in the Squirrel SQL Client.
-
Use the CData Software ODBC Driver for ShipEngine in MicroStrategy
Connect to ShipEngine data in MicroStrategy Developer using the CData Software ODBC Driver for ShipEngine.
-
Create a Data Access Object for ZohoInvoice Data using JDBI
A brief overview of creating a SQL Object API for ZohoInvoice data in JDBI.
-
Build a Singer.io Tap for Billsby With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Billsby data using the CData Python Connector.
-
Automated Continuous ZohoDesk Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Amazon S3.
-
Analyze Postmark Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Postmark data with the CData JDBC Driver for Postmark.
-
Connect to Paymo Data from PowerBuilder via JDBC
This article demonstrates how to access Paymo data from PowerBuilder using the Paymo JDBC Driver.
-
Build Raisers Edge NXT-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Raisers Edge NXT Data and create custom apps in Mendix.
-
Build Apps with Live Omnisend data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Omnisend data into the Adalo platform and build custom mobile and web applications with real-time Omnisend data.
-
Integrate Live Certinia Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Certinia data from within the IDE.
-
Connect to OnePageCrm Data in JRuby
Create a simple JRuby app with access to live OnePageCrm data.
-
Use the CData Software ODBC Driver for Zoho Recruit in MicroStrategy Web
Connect to Zoho Recruit data in MicroStrategy Web using the CData Software ODBC Driver for Zoho Recruit.
-
Replicate Multiple SAP SuccessFactors Accounts via the CData Sync CLI
Replicate multiple SAP SuccessFactors accounts to one or many databases.
-
Process & Analyze Apollo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Apollo Data.
-
Build a PostgreSQL Interface for Vault CRM Data using the CData JDBC Driver
Use the Remoting features of the Vault CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Couchbase from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Couchbase data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Optimizely from Asprova with CData Software ODBC Driver for Optimizely
This article shows how to connect faster to Optimizely data from Asprova.
-
Analyze Highrise Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Highrise data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to and Visualize Live Testmonitor Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Testmonitor data.
-
Integrate Cursor with Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Campaign Manager 360 data from within the editor.
-
How to Use a Microsoft Access Database to Update Salesforce Pardot Data in Real Time
Update Salesforce Pardot data by creating a linked table in Microsoft Access with the CData Salesforce Pardot ODBC Driver.
-
Build Pipedrive-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Pipedrive Data and create custom apps in Bubble.
-
Analyze GraphQL Data in Cognos Analytics
Use CData Connect AI to connect to GraphQL Data from Cognos Analytics and analyze live GraphQL data.
-
Connect and Visualize Live GetResponse Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live GetResponse data into the Databricks platform and create visualization dashboards with real-time GetResponse data.
-
How to Connect the Power BI Service to ShipStation: Complete Guide
Connect to the CData Software Power BI Connector for ShipStation from PowerBI.com to provide real-time ShipStation data across the organization.
-
Build a Simple VCL Application for Attio Data
How to build a simple VCL Application to view Attio data in RAD Studio using the CData ODBC Driver for Attio.
-
Integrate with Klaviyo Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Klaviyo data in SnapLogic.
-
Process & Analyze GitLab Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live GitLab Data.
-
Choosing the Best Method to Connect MailerSend to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MailerSend data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Vercel Data in AWS Lambda
Connect to live Vercel data in AWS Lambda using the CData JDBC Driver.
-
Create ADP-Connected Business Apps in AppSheet
Connect to ADP Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ADP data.
-
Create Datasets from Xero in Domo Workbench and Build Visualizations of Xero Data in Domo
Use the CData Software ODBC Driver for Xero to create datasets from Xero data in Domo Workbench and then build visualizations in the Domo service.
-
Create Power BI Reports on Real-Time SpaceX Data
Use the CData ODBC Driver for SpaceX to visualize SpaceX data in Power BI Desktop.
-
Automated Continuous Stack Exchange Replication to MongoDB
Use CData Sync for automated, continuous, customizable Stack Exchange replication to MongoDB.
-
Integrate PayPal Data into Power Automate Desktop using CData Connect
CData Connect for PayPal Data enables you to integrate PayPal data into workflows built using Microsoft Power Automate Desktop.
-
Build Semantic Layer Views for ADP Data in APOS Live Data Gateway
Use the CData Connector for ADP in APOS Live Data Gateway to build Semantic Layer Views for ADP data.
-
Use the CData Software ODBC Driver for SAP SuccessFactors in MicroStrategy Desktop
Connect to SAP SuccessFactors data in MicroStrategy Desktop using the CData Software ODBC Driver for SAP SuccessFactors.
-
How to import Bullhorn CRM Data into Apache Solr
Use the CData Software JDBC Driver for Bullhorn CRM in Data Import Handler and create an automated import of Bullhorn CRM data to Apache Solr Enterprise Search platform.
-
Integrate PingOne with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PingOne with External Services.
-
Integrate OpenCode with Live Paymo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Paymo data from within your AI coding agent.
-
Create Informatica Mappings From/To a JDBC Data Source for Highrise
Create Highrise data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use Manus AI to Talk to Your Dropbox 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 Dropbox data.
-
Moving Data from Helpscout to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Helpscout data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Xero Replication to Databricks
Use CData Sync for automated, continuous, customizable Xero replication to Databricks.
-
Connect to Eventbrite from a Connection Pool in WebLogic
Use the CData JDBC Driver for Eventbrite to connect to Eventbrite data from Web applications running on WebLogic.
-
How to connect SharePoint with WordPress Data through external lists
Provide WordPress data to SharePoint users as an external list.
-
Build an OLAP Cube in SSAS from ZeroBounce Data
Establish a connection to ZeroBounce data data from SQL Server Analysis Services, and use the ZeroBounce Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Live SparkPost Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SparkPost data and integrate live SparkPost data into apps built in Microsoft Power Apps.
-
Access Live JSON Services 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 JSON services through MCP integration.
-
Connect to Cloudflare Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Cloudflare and work with Cloudflare data in your FileMaker applications.
-
Connect and Visualize Live HDFS Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live HDFS data into the Databricks platform and create visualization dashboards with real-time HDFS data.
-
Use the CData Software ODBC Driver for SAP SuccessFactors LMS in MicroStrategy Web
Connect to SAP SuccessFactors LMS data in MicroStrategy Web using the CData Software ODBC Driver for SAP SuccessFactors LMS.
-
How to Connect to Live OneNote Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your OneNote data for you.
-
Integrate SQL Server Data in the Pentaho Report Designer
Publish reports based on SQL Server data in the Pentaho BI tool.
-
How to Connect to Live Splunk 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 Splunk data without replication.
-
Add Sybase IQ Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Sybase IQ with the Informatica Enterprise Data Catalog to classify and organize data.
-
A PostgreSQL Interface for CircleCI Data using the CData ODBC Driver
Use the SQL Gateway and CircleCI ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Build an ETL App for Jumpseller Data in Python with CData Connect AI
Extract and transform live Jumpseller data in Python with petl and the CData Connect AI Python SDK.
-
Integrating Claude Code CLI with Ontraport 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.
-
DataBind Charts to SAP Hybris C4C Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Hybris C4C 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.
-
Use Biml to Build SSIS Tasks to Replicate Snowflake Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Snowflake data to SQL Server.
-
Create SAP Ariba Source-Connected Nintex Workflows
Use CData Connect AI to connect to SAP Ariba Source Data from Nintex Workflow Cloud and build custom workflows using live SAP Ariba Source data.
-
Getting Started with the CData Power BI Connector for Microsoft Planner
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Microsoft Planner.
-
Enable the SharePoint JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SharePoint data.
-
DataBind Controls to NASA Data in Delphi
DataBind to NASA data in Delphi with standard data access components and controls.
-
Automated Continuous Google Analytics Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Analytics replication to Amazon S3.
-
Automated Continuous LinkedIn Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Amazon S3.
-
Integrate Open WebUI with Live Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Freshdesk data from within the chat interface.
-
How to publish and share ZohoPeople Data dashboards with Tableau Server
The CData ODBC driver for ZohoPeople enables you integrate ZohoPeople data into Tableau dashboards.
-
Configure the CData JDBC Driver for Parallel in a Connection Pool in Tomcat
Connect to Parallel data from a connection pool in Tomcat.
-
Connect to Testmonitor Data in Ruby
Connect to Testmonitor data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
A PostgreSQL Interface for Azure Data Lake Storage Data (MySQL Remoting via JDBC)
Use the Remoting features of the Azure Data Lake Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Pipeliner CRM Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Pipeliner CRM data into TIBCO Spotfire.
-
Use the CData Software ODBC Driver for Trello in MicroStrategy Web
Connect to Trello data in MicroStrategy Web using the CData Software ODBC Driver for Trello.
-
Automate Freshteam Data Replication to Azure Data Lake
Use CData Sync to customize and automate Freshteam data replication to Azure Data Lake.
-
Interact with Live QuickBooks Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live QuickBooks data.
-
Integrate with Slack Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Slack data to a JSON file on disk.
-
Connect to Dropbox Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Dropbox data from Filemaker Pro on Mac.
-
Connect to Lakebase in SpagoBI
Create reports featuring live Lakebase data in SpagoBI Studio. Host Lakebase reports on SpagoBI Server.
-
Analyze Ontraport Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Ontraport data in Microsoft R Open.
-
Create Informatica Mappings From/To an ODBC Data Source for HubDB
Create an ODBC connection to HubDB in Informatica and browse and transfer HubDB data.
-
Connect to Ontraport Data from PowerBuilder via ADO.NET
This article demonstrates how to access Ontraport data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrate Google Ads with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Ads with External Services.
-
Connect to Paymo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Paymo data.
-
Getting Started with the CData Excel Add-In for SAP Netweaver Gateway
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Netweaver Gateway.
-
How to Connect to Twitter Ads Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Twitter Ads data. Leverage the pyodbc module for ODBC in Python.
-
Build Visualizations of Mailjet Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Mailjet data in Birst.
-
How to Work with Coinbase Data in AWS Glue Jobs Using JDBC
Connect to Coinbase 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 Zoho Creator
Provide connectivity to Zoho Creator data through an SAP BusinessObjects universe.
-
Build Charts with AfterShip Data in Clear Analytics
Create dynamic charts and perform analytics based on AfterShip data in Clear Analytics.
-
Visualize Microsoft Entra ID Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Entra ID data.
-
Integrate Cline with Live SparkPost Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SparkPost data from within your IDE.
-
Use the CData Software JDBC Driver for OnePageCrm in MicroStrategy Desktop
Connect to OnePageCrm data in MicroStrategy Desktop using the CData Software JDBC Driver for OnePageCrm.
-
Load Nuclia Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Nuclia data to a database.
-
Replicate Multiple ZeroBounce Accounts
Replicate multiple ZeroBounce accounts to one or many databases.