CData Software - Knowledge Base
Recent Articles
-
Automate Odoo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Odoo ERP from PowerShell? This article demonstrates how to utilize the Odoo Cmdlets for tasks like connecting to Odoo ERP, automating operations, downloading data, and more.
-
Automated Continuous ClickTime Replication to SQLite
Use CData Sync for automated, continuous, customizable ClickTime replication to SQLite.
-
Publish QuickBooks-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live QuickBooks Desktop.
-
Automated Continuous Salesforce Pardot Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Azure SQL Database.
-
Connect to BigCommerce Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for BigCommerce and the SQL Gateway to access BigCommerce from Google Apps Script.
-
Automated Continuous Hive Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Hive replication to delimited files (CSV/TSV).
-
Use Agno to Talk to Your Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Zuora for you.
-
How to Design Oracle Eloqua Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Oracle Eloqua from mobile and tablet Power Apps.
-
Integrate Microsoft OneDrive Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft OneDrive in the Pentaho Data Integration tool.
-
Analyze Cassandra Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apache Cassandra in Microsoft R Open.
-
How to Query Live Workable Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Workable data in natural language using Python.
-
How to connect to Teradata Data with Squirrel SQL client
Connect to Teradata and execute queries in the Squirrel SQL Client.
-
Use CData Connect AI to Access GraphQL Data in Microsoft Power Pivot
Use CData Connect AI to connect to live GraphQL in the Power Pivot business intelligence tool.
-
Connect to Exact Online from Asprova with CData Software ODBC Driver for Exact Online
This article shows how to connect faster to Exact Online data from Asprova.
-
Connect to and Visualize Live Reply.io Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Reply.io.
-
Object-Relational Mapping (ORM) with Typeform Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Typeform into a Java-based ORM framework, Hibernate.
-
Use the CData Software JDBC Driver for PDFMonkey in MicroStrategy Desktop
Connect to PDFMonkey in MicroStrategy Desktop using the CData Software JDBC Driver for PDFMonkey.
-
Access Live Box Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Box in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to connect PolyBase to Sybase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sybase.
-
Integrate Azure DevOps Data in the Pentaho Report Designer
Publish reports based on Azure DevOps in the Pentaho BI tool.
-
Create SQL Analysis Services-Connected Business Apps in AppSheet
Connect to SQL Analysis Services Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SQL Analysis Services.
-
How to work with Acumatica Data in Apache Spark using SQL
Access and process Acumatica Data in Apache Spark using the CData Software JDBC Driver.
-
Stream Oracle Sales Data into Apache Kafka Topics
Access and stream Oracle Sales in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect PolyBase to Samanage
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Samanage.
-
Getting Started with the CData SSIS Components for Optimizely
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Optimizely.
-
How to Seamlessly Import Azure DevOps Data into IBM SPSS Modeler
Integrate Azure DevOps data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
FreshBooks Reporting in OBIEE with the FreshBooks JDBC Driver
Deploy the FreshBooks JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze Microsoft OneDrive Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft OneDrive and visualize Microsoft OneDrive in SAP Analytics Cloud.
-
How to integrate Drip with Apache Airflow
Access and process Drip in Apache Airflow using the CData JDBC Driver.
-
Build AI/ML Models with Live Outlook Data using Dataiku
Connect Outlook Data with Dataiku using the CData API Driver for JDBC.
-
Connect to eBay Analytics Data as an External Source in Dremio
Use the CData JDBC Driver to connect to eBay Analytics as an External Source in Dremio.
-
How to integrate Testmonitor with Apache Airflow
Access and process Testmonitor in Apache Airflow using the CData JDBC Driver.
-
How to Access Live FTP Data in Power Automate Desktop via ODBC
The CData ODBC Driver for FTP enables you to integrate FTP Servers into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData ODBC Driver for ZohoExpense
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZohoExpense.
-
Validate HDFS Data with QuerySurge
Access and validate Apache HDFS in QuerySurge using the CData JDBC Driver.
-
Quickbase Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Quickbase facts in real time.
-
Connect Reckon to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Reckon with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Stack Exchange Replication to SQLite
Use CData Sync for automated, continuous, customizable Stack Exchange replication to SQLite.
-
Ontraport Reporting in OBIEE with the Ontraport JDBC Driver
Deploy the Ontraport JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Establish a Live Connection with Campaigner Data using Tableau Bridge
The CData ODBC Driver for Campaigner enables you to integrate live Campaigner into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Zoom in SpagoBI
Create reports featuring live Zoom in SpagoBI Studio. Host Zoom reports on SpagoBI Server.
-
Integrate Excel Online Data into Power Automate Desktop using CData Connect
CData Connect for Excel Online Data enables you to integrate Microsoft Excel Online into workflows built using Microsoft Power Automate Desktop.
-
Visualize Live MailerSend Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MailerSend using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Import Data from HDFS into Google Sheets
Import Apache HDFS into a Google spreadsheet that is automatically refreshed.
-
Building Dynamic Web Pages with SAP HANA Data Using AngularJS
Create single-page applications with live connectivity to SAP HANA using the CData API Server.
-
Replicate Pipedrive Data to Multiple Databases
Replicate Pipedrive to disparate databases with a point-and-click configuration.
-
Integrating OpenCode Terminal with Tally 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.
-
Integrate Live Amazon Athena Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to SharePoint Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SharePoint Data and connect to Microsoft SharePoint in Akorbi Digital RunMyProcess.
-
How to connect to Twitter Ads Data with Squirrel SQL client
Connect to Twitter Ads and execute queries in the Squirrel SQL Client.
-
Build SFTP-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SFTP to explore live SFTP Data in Claude Code to assist with building SFTP-powered applications.
-
Connect to CSV Data as an External Source in Dremio
Use the CData JDBC Driver to connect to CSV as an External Source in Dremio.
-
Consume SurveyMonkey OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SurveyMonkey feeds that reflect any changes in SAP Lumira.
-
Integrating Codex CLI with OData 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.
-
Integrate WordPress Data into Power Automate Desktop using CData Connect
CData Connect for WordPress Data enables you to integrate WordPress into workflows built using Microsoft Power Automate Desktop.
-
Build Dashboards with QuickBooks Data in Dundas BI
Create dynamic dashboards and perform analytics based on QuickBooks Desktop in Dundas BI.
-
Connect to Todoist Data in RapidMiner
Integrate Todoist with standard components and data source configuration wizards in RapidMiner Studio.
-
Stream Dotmailer Data into Apache Kafka Topics
Access and stream Dotmailer in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access JobNimbus Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access JobNimbus from your Oracle system.
-
How to Use a Microsoft Access Database to Update Salesforce Data in Real Time
Update Salesforce data by creating a linked table in Microsoft Access with the CData Salesforce ODBC Driver.
-
Automated Continuous Toggl Replication to SingleStore
Use CData Sync for automated, continuous, customizable Toggl replication to SingleStore.
-
Use the CData Software ODBC Driver for Smartsheet in MicroStrategy Web
Connect to Smartsheet in MicroStrategy Web using the CData Software ODBC Driver for Smartsheet.
-
Getting Started with the CData Excel Add-In for Aweber
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Aweber.
-
Trigger DB2 IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for DB2 with standard wizards in Logic Apps.
-
Connect to Google Tasks Data in DBeaver
Use the CData ODBC Driver to connect to Google Tasks in DBeaver.
-
Feed Cosmos DB Data into FineReport
How to set Azure Cosmos DB as a JDBC data source in FineReport.
-
Visualize Live Spark Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Spark SQL.
-
Extend Google Sheets with Cvent Data
Make calls to Cvent from Google Apps Script via the API Server.
-
Connect to SendPulse Data in RapidMiner
Integrate SendPulse with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software JDBC Driver for QuickBooks in MicroStrategy
Connect to QuickBooks Desktop in MicroStrategy Developer using the CData Software JDBC Driver for QuickBooks.
-
Connect to ServiceDesk Plus Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ServiceDesk Plus to connect to ServiceDesk Plus and execute queries in PowerBuilder.
-
Connect to Google Forms Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Forms in the Denodo Virtual DataPort Administrator.
-
Create Informatica Mappings From/To an ODBC Data Source for REST
Create an ODBC connection to REST in Informatica and browse and transfer REST.
-
How to Visualize Float Data in Python with pandas
Use pandas and other modules to analyze and visualize live Float in Python.
-
Integrating Kiro CLI with Snapchat Ads 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 Greenhouse Data in CloverDX (formerly CloverETL)
Transfer Greenhouse using the visual workflow in the CloverDX data integration tool.
-
eBay Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to eBay through CData Connect AI using different applications and tools.
-
Query, Visualize, and Share live Azure DevOps Data in Redash
Use CData Connect AI to connect to live Azure DevOps in Redash for querying, visualizing, and sharing.
-
Connect to Google Ad Manager Data in RazorSQL
Connect to Google Ad Manager from wizards and query Google Ad Manager from the GUI in the RazorSQL database management tool.
-
Visualize Coda 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 Coda into TIBCO Spotfire.
-
Object-Relational Mapping (ORM) with Couchbase Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Couchbase into a Java-based ORM framework, Hibernate.
-
Easily Integrate SAP SuccessFactors Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP SuccessFactors in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Power BI Connector for MailerLite
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create SSAS Tabular Models from NASA Data
How to build a SQL Server Analysis Service Tabular Model from NASA using CData drivers.
-
Use Azure AI Foundry to Talk to Your MySQL 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 MySQL for you.
-
Connecting Agentforce with Oracle Eloqua Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Oracle Eloqua for you.
-
Integrate Apollo Data in Pentaho Data Integration
Build ETL pipelines based on Apollo in the Pentaho Data Integration tool.
-
Connect to SAP Ariba Procurement Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Ariba Procurement and the Script function in FileMaker Pro to connect to SAP Ariba Procurement and work with SAP Ariba Procurement in your FileMaker application.
-
Import Real-Time Placid Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Placid in ColdFusion.
-
Visualize Reckon Data in TIBCO Spotfire through OData
Integrate Reckon into dashboards in TIBCO Spotfire.
-
Automated Continuous BambooHR Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable BambooHR replication to Google Cloud SQL.
-
A PostgreSQL Interface for Sage 300 Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sage 300 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Reports from Bullhorn CRM Data in Looker Studio
Use CData Connect AI to gain access to live Bullhorn CRM and create custom reports in Looker Studio.
-
Connect to Perplexity from Asprova with CData Software ODBC Driver for Perplexity
This article shows how to connect faster to Perplexity data from Asprova.
-
How to Connect to BenchmarkEmail Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to BenchmarkEmail. Leverage the pyodbc module for ODBC in Python.
-
Access Live TaxJar Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live TaxJar data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Getting Started with the CData Excel Add-In for Hacker News
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Hacker News.
-
Getting Started with the CData ADO.NET Provider for LinkedIn Ads
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for LinkedIn Ads.
-
Use ChatGPT to Talk to Your Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Databricks for you.
-
Connect to ScrapingBee Data in RazorSQL
Connect to ScrapingBee from wizards and query ScrapingBee from the GUI in the RazorSQL database management tool.