CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Hubstaff in SAS for Real-Time Reporting and Analytics
Connect to real-time Hubstaff data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Hubstaff.
-
Connect to Box Data from AWS Glue
Use CData Connect AI to gain access to live Box data from your AWS Glue jobs.
-
Integrating Claude Code with Highrise Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Highrise data within assisted coding and automated development workflows.
-
Connect to SharePoint 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 SharePoint data.
-
How to integrate Facebook with Apache Airflow
Access and process Facebook data in Apache Airflow using the CData JDBC Driver.
-
Connecting Pipedream with Apollo Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Apollo data in real time.
-
Build AI/ML Models with Live Zoho Books Data using Dataiku
Connect Zoho Books Data with Dataiku using the CData JDBC Driver for Zoho Books.
-
Integrate with ShipEngine Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ShipEngine data in SnapLogic.
-
How to Easily Query Databricks Data in OpenOffice Base
Connect to Databricks data in OpenOffice Base using the CData ODBC Driver for Databricks and generate reports with live data insights.
-
Connect to Mailjet from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Mailjet data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automate Gumroad Data Replication to Couchbase
Use CData Sync to Customize and automate Gumroad data replication to Couchbase.
-
Manage Zuora Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zuora.
-
Automate SAP Fieldglass Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP Fieldglass data replication to Azure Synapse.
-
Create Reports from Typeform Data in Looker Studio
Use CData Connect AI to gain access to live Typeform data and create custom reports in Looker Studio.
-
Automated Continuous SendInBlue Replication to Databricks
Use CData Sync for automated, continuous, customizable SendInBlue replication to Databricks.
-
How to Connect to Live SAP HANA XS Advanced 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 SAP HANA XS Advanced data for you.
-
Build Oracle Financials Cloud Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Oracle Financials Cloud data and build visualizations in Tableau Cloud.
-
Connect to Trello from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Trello data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Link Twitter Ads with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Twitter Ads data in Filemaker Pro for Mac or Windows.
-
Analyze Microsoft Teams Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Teams data with the CData JDBC Driver for Microsoft Teams.
-
Prepare, Blend, and Analyze Monday.com Data in Alteryx Designer (ODBC)
Build workflows to access live Monday.com data for self-service data analytics.
-
Connect to Couchbase from a Connection Pool in WebLogic
Use the CData JDBC Driver for Couchbase to connect to Couchbase data from Web applications running on WebLogic.
-
Bridge SharePoint Connectivity with Apache NiFi
Access and process SharePoint data in Apache NiFi using the CData JDBC Driver.
-
Replicate Todoist Data in Heroku for Use in Salesforce Connect
Replicate Todoist data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Extract, Transform, and Load Dynamics 365 Data in Informatica PowerCenter
Create a simple Workflow for Dynamics 365 data in Informatica PowerCenter.
-
Automated Continuous Google Ad Manager Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to delimited files (CSV/TSV).
-
Import MailChimp Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to MailChimp Data and provide access to live MailChimp data for custom reports in the Power BI Service.
-
Build Dashboards with Brex Data in DBxtra
Create dynamic dashboards and perform analytics based on Brex data in DBxtra.
-
Integrate HubSpot Data in Pentaho Data Integration
Build ETL pipelines based on HubSpot data in the Pentaho Data Integration tool.
-
Create Reports from Highrise Data in Looker Studio
Use CData Connect AI to gain access to live Highrise data and create custom reports in Looker Studio.
-
Use Claude to Talk to Your Splunk 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 Splunk data for you.
-
Connect to Live Authorize.Net Data in MicroStrategy through CData Connect AI
Create a live connection to Authorize.Net Data in CData Connect AI and connect to your Authorize.Net data from MicroStrategy.
-
Create Oracle Eloqua-Connected Applications in Appsmith
Connect to Oracle Eloqua Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle Eloqua data.
-
Automated Continuous Opsgenie Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Opsgenie replication to IBM DB2.
-
Connect and Query Live Sugar CRM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Sugar CRM data into Databricks and enable direct, live querying and analysis without replication.
-
Provide OData Services of Vimeo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Vimeo data by developing a WCF Service Application.
-
Connect to TigerGraph Data in JRuby
Create a simple JRuby app with access to live TigerGraph data.
-
Work with Live Avro Data in Power Query
Use CData Connect AI to connect to Avro data and work with live Avro data in Microsoft Power Query.
-
Moving Data from Aircall to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Aircall data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Dynamic Webflow Grids Using the Infragistics XamDataGrid
Learn how you can connect Webflow to Infragistics XamDataGrid to build dynamic grids.
-
How to import SAP Ariba Procurement Data into Apache Solr
Use the CData Software JDBC Driver for SAP Ariba Procurement in Data Import Handler and create an automated import of SAP Ariba Procurement data to Apache Solr Enterprise Search platform.
-
Automated Continuous Oracle Financials Cloud Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to AlloyDB.
-
Use Databricks Agent Bricks to Talk to Your eBay Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your eBay data for you.
-
Extract, Transform, and Load Paddle Data in Informatica PowerCenter
Create a simple Workflow for Paddle data in Informatica PowerCenter.
-
Integrate Dify with Live Google Search Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Google Search results.
-
Visualize CockroachDB Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to CockroachDB data.
-
Work with Aircall Data in FoxPro
Load Aircall data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData Connect AI Python SDK for CockroachDB
Install the CData Connect AI Python SDK to read and write live CockroachDB data with standard DB-API 2.0 Python code.
-
Replicate SendGrid Data in Heroku for Use in Salesforce Connect
Replicate SendGrid data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use JayDeBeApi to access Sage Intacct Data in Python
Use standard Python scripting and the development environment of your choice to access live Sage Intacct data.
-
Build Zendesk-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zendesk data.
-
Deploy the ADO.NET Provider for Sage 300 on an SSRS Report Server
Connect to Sage 300 data 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.
-
Use the CData Software JDBC Driver for Kafka in MicroStrategy Web
Connect to Kafka data in MicroStrategy Web using the CData Software JDBC Driver for Kafka.
-
Visualize AgileCRM 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 AgileCRM data into TIBCO Spotfire.
-
Connect to BambooHR Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for BambooHR Data and connect to BambooHR data in Akorbi Digital RunMyProcess.
-
Access Azure Data Lake Storage Data from MySQL in PHP
Connect to Azure Data Lake Storage through the standard MySQL libraries in PHP.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Greenplum
Provide connectivity to Greenplum data through an SAP BusinessObjects universe.
-
View Reports on Real-Time Microsoft Teams Data in Power BI Report Server
Use the CData ODBC Driver for Microsoft Teams to visualize Microsoft Teams data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Presto-Connected Business Apps in AppSheet
Connect to Presto Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Presto data.
-
Connect to Tavily Data in CloverDX (formerly CloverETL)
Transfer Tavily data using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData Connect AI Python SDK for Zoho Books
Install the CData Connect AI Python SDK to read live Zoho Books data with standard DB-API 2.0 Python code.
-
Connect and Query Live Marketo Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Marketo data into Databricks and enable direct, live querying and analysis without replication.
-
Perform Batch Operations with Elasticsearch Data in Apache NiFi
Connect to Elasticsearch data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build Automated Workflows with Live MySQL Data in Workato
Use CData Connect AI to connect to live MySQL data and build automated workflows in Workato.
-
Access Paddle Data from MySQL in Amazon QuickSight
Connect to Paddle and build visualizations of Paddle data using a MySQL Connection in Amazon QuickSight.
-
Analyze Trello Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Trello data in Microsoft R Open.
-
Build a Singer.io Tap for Cohere With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Cohere data using the CData Python Connector.
-
Rapidly Develop Bugsnag-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Bugsnag.
-
Build Pipelines with Live Active Directory Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Active Directory from Google Cloud Data Fusion, enabling the integration of live Active Directory data into the building and management of effective data pipelines.
-
Automated Continuous Oracle SCM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Amazon Redshift.
-
Access Live Float Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Float data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Interact with Live Oracle HCM Cloud Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Oracle HCM Cloud data.
-
Visualize Presto 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 Presto data into TIBCO Spotfire.
-
Connect to Asana Data in RazorSQL
Connect to Asana from wizards and query Asana data from the GUI in the RazorSQL database management tool.
-
Replicate Multiple Sugar CRM Accounts via the CData Sync CLI
Replicate multiple Sugar CRM accounts to one or many databases.
-
How to Seamlessly Import ZohoInvoice Data into IBM SPSS Modeler
Integrate ZohoInvoice data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Amazon Marketplace Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Amazon Marketplace facts in real time.
-
Build Reckon-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Reckon data and build Reckon-connected web apps with Axios.
-
Creating Adobe Analytics-Connected Applications in Unqork
You can use CData Connect AI to feed Adobe Analytics data to Unqork and build custom business apps.
-
Connect to QuickBooks Time Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for QuickBooks Time data in the Denodo Virtual DataPort Administrator.
-
Load Tavily Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Tavily data to a database.
-
Visualize SharePoint Excel Services Data in Sisense
Create an ElastiCube in Sisense app with access to SharePoint Excel Services data.
-
Integrate OpenCode with Live Zoho Inventory Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Zoho Inventory data from within your AI coding agent.
-
Build Charts with Hugging Face Data in Clear Analytics
Create dynamic charts and perform analytics based on Hugging Face data in Clear Analytics.
-
Connect to IBM Informix Data in Jaspersoft Studio
Execute SQL to remote IBM Informix data in Jaspersoft Studio.
-
Automate Toggl Data Replication to Azure Synapse
Use CData Sync to customize and automate Toggl data replication to Azure Synapse.
-
Automated Continuous TaxJar Replication to IBM DB2
Use CData Sync for automated, continuous, customizable TaxJar replication to IBM DB2.
-
Analyze Dropbox Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Dropbox data and visualize Dropbox data in SAP Analytics Cloud.
-
Getting Started with the CData Connect AI Python SDK for VWO
Install the CData Connect AI Python SDK to read live VWO data with standard DB-API 2.0 Python code.
-
Connect to Xero Data from a Connection Pool in JBoss
Integrate Xero data into Java servlets: Use the Management Console in JBoss to install the Xero JDBC Driver.
-
Create Data Visualizations Based On ServiceDesk Plus Data in Mode
Use CData Connect AI to connect to ServiceDesk Plus Data from Mode and build visualizations using live ServiceDesk Plus data.
-
Visualize Moosend Data in Tableau
The CData ODBC driver for Moosend enables you integrate Moosend data into Tableau dashboards.
-
Replicate Multiple Campaigner Accounts via the CData Sync CLI
Replicate multiple Campaigner accounts to one or many databases.
-
Import Real-Time Anaplan Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Anaplan data in ColdFusion.
-
How to publish and share Timely Data dashboards with Tableau Server
The CData ODBC driver for Timely enables you integrate Timely data into Tableau dashboards.
-
Asana Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Asana data through CData Connect AI using different applications and tools.
-
Automated Continuous Vertica Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Vertica replication to Google Cloud SQL.
-
Bridge Paddle Connectivity with Apache NiFi
Access and process Paddle data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Exa Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Exa replication to IBM DB2.
-
Visualize Zoho Recruit Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoho Recruit data.