CData Software - Knowledge Base
Recent Articles
-
Connect to ZohoInvoice Data in HULFT Integrate
Connect to ZohoInvoice as a JDBC data source in HULFT Integrate
-
Connect to MailerLite Data in Ruby
Connect to MailerLite in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Live NetSuite Data in Coginiti Pro
Connect to and query live NetSuite CRM & ERP from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Back Up Insightly to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Insightly data.
-
Replicate Multiple Smartsheet Accounts
Replicate multiple Smartsheet accounts to one or many databases.
-
Connect to HubDB from a Connection Pool in WebLogic
Use the CData JDBC Driver for HubDB to connect to HubDB from Web applications running on WebLogic.
-
Stream QuickBooks Online Data into Apache Kafka Topics
Access and stream QuickBooks Online in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Create Power BI Visual Reports with Real-Time ActiveCampaign Data
Use CData Power BI Connectors to visualize ActiveCampaign in Power BI.
-
How to connect Amazon QuickSight to Oracle HCM Cloud Data
Create a connection to Oracle HCM Cloud in CData Connect AI and insert Oracle HCM Cloud into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Adobe Commerce Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Adobe Commerce from your Oracle system.
-
Connect to Amazon S3 Data in JRuby
Create a simple JRuby app with access to live Amazon S3.
-
Seamlessly Bring Acumatica Data into Retool Using CData Connect AI
Integrate Acumatica data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Analyze Gumroad Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Gumroad with the CData JDBC Driver for Gumroad.
-
Connect to Jira in SpagoBI
Create reports featuring live Atlassian Jira in SpagoBI Studio. Host Jira reports on SpagoBI Server.
-
Integrate Databricks Data into Power Automate Desktop using CData Connect
CData Connect for Databricks Data enables you to integrate Databricks into workflows built using Microsoft Power Automate Desktop.
-
Edit and Search Azure DevOps External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Azure DevOps to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Azure DevOps objects that you can access from apps and the dashboard.
-
Create ServiceDesk Plus Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ServiceDesk Plus from PowerBI.com to create Power BI Dataflows with real-time data.
-
Excel Spreadsheet Automation on OData Services with the QUERY Formula
Pull data from OData, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Mailjet Replication to Snowflake
Use CData Sync for automated, continuous, customizable Mailjet replication to Snowflake.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live FHIR using the Model Context Protocol.
-
Build a Simple VCL Application for xBase Data
How to build a simple VCL Application to view xBase in RAD Studio using the CData ODBC Driver for xBase.
-
Automated Continuous SAP Business One Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Business One replication to PostgreSQL.
-
Automated Continuous Dynamics CRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Apache Cassandra.
-
Automated Continuous Xero Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Xero replication to Amazon S3.
-
Automated Continuous Typeform Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Typeform replication to IBM DB2.
-
How to Build an ETL App for Jumpseller Data in Python with CData
Create ETL applications and real-time data pipelines for Jumpseller in Python with petl.
-
Create Informatica Mappings From/To a JDBC Data Source for Oracle
Create Oracle data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Amplitude Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Amplitude into the statistical analysis tools available in SAS JMP. This article shows how to use Amplitude in the Graph Builder and Query Builder.
-
Connect Superchat to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Superchat with IBM WebSphere for seamless data integration and connectivity.
-
Create Data Visualizations Based On Trello Data in Mode
Use CData Connect AI to connect to Trello Data from Mode and build visualizations using live
-
How to Build an ETL App for SAP Ariba Source Data in Python with CData
Create ETL applications and real-time data pipelines for SAP Ariba Source in Python with petl.
-
How to connect SharePoint with OneNote Data through external lists
Provide Microsoft OneNote to SharePoint users as an external list.
-
Connect to Impala Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Freshservice Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Freshservice and the SQL Gateway to access Freshservice from Google Apps Script.
-
Integrate with HBase Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Apache HBase in SnapLogic.
-
Build Charts with NetSuite Data in Clear Analytics
Create dynamic charts and perform analytics based on NetSuite CRM & ERP in Clear Analytics.
-
Build Data Flows from SQL Server to Active Directory through SSIS
Easily push SQL Server data to Active Directory using the CData SSIS Tasks for Active Directory.
-
Publish QuickBooks-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live QuickBooks Desktop.
-
Integrating Antigravity CLI with Azure Data Catalog via CData CLI
Connect Azure Data Catalog to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to and Visualize Live Vault CRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Veeva Vault & Vault CRM.
-
Connect to NetSuite from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from NetSuite CRM & ERP, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Viewing MongoDB Data in RAD Studio Data Explorer
How to view MongoDB in RAD Studio Data Explorer using the CData ODBC Driver for MongoDB.
-
Build Apps with Live Atlassian Confluence in Adalo using CData Connect AI
Use CData Connect AI to integrate live Atlassian Confluence into the Adalo platform and build custom mobile and web applications with real-time Atlassian Confluence.
-
Establish a Live Connection with LeadDesk Data using Tableau Bridge
The CData ODBC Driver for LeadDesk enables you to integrate live LeadDesk into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous ZendeskSell Replication to MongoDB
Use CData Sync for automated, continuous, customizable ZendeskSell replication to MongoDB.
-
Query Live Monday.com Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Monday.com directly from the development environment.
-
Build Apps with Live Twitter Ads Data Using the Low-Code Development Platform of Mendix
Connect Twitter Ads with Mendix to build apps using the CData JDBC Driver for Twitter Ads.
-
Access Dynamics NAV Data from MySQL in PHP
Connect to Dynamics NAV through the standard MySQL libraries in PHP.
-
Integrating Antigravity CLI with HelloSign via CData CLI
Connect HelloSign to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Informatica Mappings From/To an ODBC Data Source for Jira Assets
Create an ODBC connection to Jira Assets in Informatica and browse and transfer Jira Assets.
-
Create SAP Fieldglass-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Fieldglass Data from OutSystems and build custom enterprise apps using live SAP Fieldglass.
-
Getting Started with the CData Python Connector for AgileCRM
Learn to install and license the CData Python Connector
-
Building Dynamic Web Pages with OData Services Using AngularJS
Create single-page applications with live connectivity to OData using the CData API Server.
-
Feed Salesforce Data into FineReport
How to set Salesforce & Force.com as a JDBC data source in FineReport.
-
Build SAP Fieldglass-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP Fieldglass.
-
Build Semantic Layer Views for SuiteCRM Data in APOS Live Data Gateway
Use the CData Connector for SuiteCRM in APOS Live Data Gateway to build Semantic Layer Views for SuiteCRM.
-
Connect to PivotalTracker Data in HULFT Integrate
Connect to PivotalTracker as a JDBC data source in HULFT Integrate
-
Getting Started with the CData ADO.NET Provider for eBay Analytics
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for eBay Analytics.
-
Connect to Sugar CRM Data in CloverDX (formerly CloverETL)
Transfer Sugar CRM using the visual workflow in the CloverDX data integration tool.
-
How to integrate Metabase with EnterpriseDB Data
Use CData Connect AI to connect to live EnterpriseDB and create an interactive dashboard in Metabase from EnterpriseDB.
-
Bridge Placid Connectivity with Apache NiFi
Access and process Placid in Apache NiFi using the CData JDBC Driver.
-
Build Slack-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Slack to explore live Slack Data in Gemini Code Assist to assist with building Slack-powered applications.
-
Replicate Tickspot Data in Heroku for Use in Salesforce Connect
Replicate Tickspot to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating Claude Code with NetSuite Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on NetSuite CRM & ERP within assisted coding and automated development workflows.
-
Integrating Kiro CLI with Spotify 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.
-
Integrating GitHub Copilot CLI with Zoom 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 Easily Query CloudConvert Data in OpenOffice Base
Connect to CloudConvert data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Stream GraphQL Data into Apache Kafka Topics
Access and stream GraphQL in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Amplitude Replication to SQL Server
Use CData Sync for automated, continuous, customizable Amplitude replication to SQL Server.
-
Access Live Oracle Financials Cloud Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Oracle Financials Cloud from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Import Real-Time LeadDesk Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use LeadDesk in ColdFusion.
-
Connect to CockroachDB Data as an External Source in Dremio
Use the CData JDBC Driver to connect to CockroachDB as an External Source in Dremio.
-
Establish a Live Connection with Samanage Data using Tableau Bridge
The CData ODBC Driver for Samanage enables you to integrate live Samanage into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Access Live Adobe Analytics Data in Visual Studio Code via Cline
Run CData MCP Server for Adobe Analytics on Windows Subsytem for Linux (WSL) and connect to live Adobe Analytics from the Cline extension in Visual Studio Code.
-
Analyze Live QuickBooks Time Data in SAS Viya
Use CData Connect AI to connect to QuickBooks Time from SAS Viya and deploy self-service analytics using live QuickBooks Time.
-
Query SageHR Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SageHR from Node.js.
-
Write a Simple Go Application to work with Bitly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Bitly.
-
Publish xBase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live xBase.
-
Access Cosmos DB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Azure Cosmos DB from HeidiSQL.
-
Manage Amplitude Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Amplitude.
-
How to Build an ETL App for MongoDB Data in Python with CData Connect AI
Build ETL pipelines that read and write live MongoDB in Python with petl and the CData Connect AI Python SDK.
-
Visualize Azure Data Lake Storage Data in TIBCO Spotfire through OData
Integrate Azure Data Lake Storage into dashboards in TIBCO Spotfire.
-
Viewing SQL Analysis Services Data in RAD Studio Data Explorer
How to view SQL Analysis Services in RAD Studio Data Explorer using the CData ODBC Driver for SQL Analysis Services.
-
Use the CData API Server to Access Xero Data in Microsoft PowerPivot
Use the CData API Server to connect to live Xero Accounting in the Power Pivot business intelligence tool.
-
Easily Integrate Salesforce Marketing Data in Lazarus Pascal IDE
Learn how to easily integrate live Salesforce Marketing Cloud in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to connect SharePoint with Microsoft Planner Data through external lists
Provide Microsoft Planner to SharePoint users as an external list.
-
DataBind Charts to LDAP Objects
Use the standard ADO.NET procedures for databinding to provide bidirectional access to LDAP 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.
-
Enable the OpenWeatherMap JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with OpenWeatherMap.
-
Use CData Connect AI to Access Excel Online Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Microsoft Excel Online in the Power Pivot business intelligence tool.
-
Getting Started with the CData JDBC Driver for Coda
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Coda.
-
How to connect to EmailOctopus Data with Squirrel SQL client
Connect to EmailOctopus and execute queries in the Squirrel SQL Client.
-
Visualize Paddle Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Paddle.
-
Visualize Bright Data Data in Sisense
Create an ElastiCube in Sisense app with access to Bright Data.
-
How to Query Live Notion Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Notion data in natural language using Python.
-
Analyze Typeform Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Typeform in Microsoft R Open.
-
Connect to eBay Data in NetBeans
Connect to eBay in NetBeans with the data source configuration wizard.
-
How to Connect to Discourse Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Discourse. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Drip Replication to MongoDB
Use CData Sync for automated, continuous, customizable Drip replication to MongoDB.
-
Add BigCommerce Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for BigCommerce with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Quaderno Data in Talend Cloud Data Management Platform
Connect Quaderno Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.