CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SAS xpt Replication to Oracle
Use CData Sync for automated, continuous, customizable SAS xpt replication to Oracle.
-
Connect to Microsoft Planner Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Planner data from Filemaker Pro on Mac.
-
ETL Avaza in Oracle Data Integrator
This article shows how to transfer Avaza data into a data warehouse using Oracle Data Integrator.
-
Replicate ZendeskSell Data to Multiple Databases
Replicate ZendeskSell data to disparate databases with a point-and-click configuration.
-
Establish a Live Connection with Dotmailer Data using Tableau Bridge
The CData ODBC Driver for Dotmailer enables you to integrate live Dotmailer data into Tableau Cloud dashboards using the Tableau Bridge.
-
Import Real-Time Zendesk Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zendesk data in ColdFusion.
-
Getting Started with the CData JDBC Driver for Onfleet
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Onfleet.
-
Getting Started with the CData Tableau Connector for Drip
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connecting GenSpark with Lakebase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Lakebase data without any replication or custom integration required.
-
DataBind Charts to Microsoft Exchange Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Exchange 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.
-
Build a Singer.io Tap for Nethunt With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Nethunt data using the CData Python Connector.
-
Automated Continuous Pinterest Replication to SQL Server
Use CData Sync for automated, continuous, customizable Pinterest replication to SQL Server.
-
Excel Spreadsheet Automation on AdRoll Data with the QUERY Formula
Pull data from AdRoll, automate spreadsheets, and more with the QUERY formula.
-
How to Access ClickUp Data Using Entity Framework
This article shows how to access ClickUp data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Twilio Data in the Pentaho Report Designer
Publish reports based on Twilio data in the Pentaho BI tool.
-
How to Connect to Live Notion Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Notion data securely in real time.
-
Visualize Live GraphQL Data in the Power BI Service
Use CData Connect AI to connect to live GraphQL data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Helpscout Data in Tableau
The CData ODBC driver for Helpscout enables you integrate Helpscout data into Tableau dashboards.
-
Use the CData ODBC Driver for Recurly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Recurly to connect to Recurly data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Recurly data in Excel.
-
Integrate Devin with Live SAP HANA XS Advanced Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SAP HANA XS Advanced data.
-
Create Power BI Reports on Real-Time Kintone Data
Use the CData ODBC Driver for Kintone to visualize Kintone data in Power BI Desktop.
-
How to Build an ETL App for Amazon Marketplace Data in Python with CData
Create ETL applications and real-time data pipelines for Amazon Marketplace data in Python with petl.
-
Build BigCommerce-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to BigCommerce data and build web apps with connectivity to live BigCommerce data.
-
Build Oracle Sales Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle Sales data and build visualizations in Tableau.
-
Access Live Oracle Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle data into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle data in the Graph Builder and Query Builder.
-
DataBind Charts to Sybase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sybase 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.
-
Integrate Open WebUI with Live Bitly Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Bitly data from within the chat interface.
-
How to Connect Flowise AI Agents to Live Confluence 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 Confluence data without replication.
-
Connect to Highrise Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Highrise data.
-
Access Live Figshare Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Figshare data from your Google Sheets.
-
ETL Onfleet in Oracle Data Integrator
This article shows how to transfer Onfleet data into a data warehouse using Oracle Data Integrator.
-
Create Data Visualizations Based On ZohoMarketingHub Data in Mode
Use CData Connect AI to connect to ZohoMarketingHub Data from Mode and build visualizations using live ZohoMarketingHub data.
-
Connect to Perplexity Data from Crystal Reports
Use CData Connect AI to connect to and report on live Perplexity data from Crystal Reports.
-
Work with Todoist Data in FoxPro
Load Todoist data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Bridge Accelo Connectivity with Apache NiFi
Access and process Accelo data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous VWO Replication to Amazon S3
Use CData Sync for automated, continuous, customizable VWO replication to Amazon S3.
-
Visualize Google Campaign Manager 360 Data in Tableau
The CData ODBC driver for Google Campaign Manager 360 enables you integrate Google Campaign Manager 360 data into Tableau dashboards.
-
Create Presto Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Presto from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Hive Data in Ruby
Connect to Hive data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData ODBC Driver for Nethunt
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Nethunt.
-
Provide OData Services of Office 365 Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Office 365 data by developing a WCF Service Application.
-
Replicate ClickTime Data in Heroku for Use in Salesforce Connect
Replicate ClickTime data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Natively Connect to Slack Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Slack data. Leverage the native support for ODBC in PHP.
-
How to connect to Tickspot Data with Squirrel SQL client
Connect to Tickspot data and execute queries in the Squirrel SQL Client.
-
Use CData Connect AI to Access SAP Business Warehouse Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Business Warehouse data in the Power Pivot business intelligence tool.
-
Connect to Zendesk from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zendesk data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Coda Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Coda and work with Coda data in your FileMaker application.
-
Choosing the Best Method to Connect Bullhorn CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Bullhorn CRM data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to create Cvent federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Cvent data in MySQL .
-
Access Active Directory Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Active Directory data from your Oracle system.
-
Visualize Salesforce CRM Analytics Data in TIBCO Spotfire through ADO.NET
Integrate Salesforce CRM Analytics data into dashboards in TIBCO Spotfire.
-
Connect to Twitter Ads Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Twitter Ads.
-
Query Live CouchDB Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live CouchDB data through a conversational interface.
-
Access Live Box Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Box data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to CSV Data in RapidMiner
Integrate CSV data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate with Wistia Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Wistia data in SnapLogic.
-
Connect to Front Data in Jaspersoft Studio
Execute SQL to remote Front data in Jaspersoft Studio.
-
Automate ZarMoney Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZarMoney data from PowerShell? This article demonstrates how to utilize the ZarMoney Cmdlets for tasks like connecting to ZarMoney data, automating operations, downloading data, and more.
-
Integrating OpenCode with Front 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 load Toggl data into Elasticsearch via Logstash
Introducing a simple method to load Toggl data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Import Real-Time BambooHR Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use BambooHR data in ColdFusion.
-
Build MVC Applications with Connectivity to Azure Synapse Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure Synapse from an ASP.NET MVC application.
-
Create Informatica Mappings From/To an ODBC Data Source for Opsgenie
Create an ODBC connection to Opsgenie in Informatica and browse and transfer Opsgenie data.
-
Integrate Live Redshift 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 Redshift data from within the IDE.
-
Connect to Mocean Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Mocean data in the Denodo Virtual DataPort Administrator.
-
Use Dash to Build to Web Apps on ClickTime Data
Create Python applications that use pandas and Dash to build ClickTime-connected web apps.
-
Query Notion Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Notion data from Node.js.
-
How to import SAP SuccessFactors LMS Data into Apache Solr
Use the CData Software JDBC Driver for SAP SuccessFactors LMS in Data Import Handler and create an automated import of SAP SuccessFactors LMS data to Apache Solr Enterprise Search platform.
-
Connect to Avalara AvaTax Data in DBArtisan
Use wizards in DBArtisan to configure Avalara AvaTax data as a data source.
-
Design BIRT Reports on PhantomBuster Data
Provide current PhantomBuster data to your embedded analytics.
-
Getting Started with the CData Excel Add-In for Google Tasks
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Tasks.
-
Automated Continuous Zoho Recruit Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zoho Recruit replication to delimited files (CSV/TSV).
-
Creating GitLab-Connected Applications in Unqork
You can use CData Connect AI to feed GitLab data to Unqork and build custom business apps.
-
Choosing the Best Method to Connect Jodoo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Jodoo data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Tanda Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Tanda replication to Azure SQL Database.
-
Automated Continuous MailChimp Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MailChimp data replication to OneLake in Microsoft Fabric.
-
How to integrate FormSite with Apache Airflow
Access and process FormSite data in Apache Airflow using the CData JDBC Driver.
-
Connect Auth0 to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Auth0 with IBM WebSphere for seamless data integration and connectivity.
-
Connect to ClickTime Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ClickTime and work with ClickTime data in your FileMaker application.
-
Access Live Facebook Data in AWS Lambda
Connect to live Facebook data in AWS Lambda using the CData JDBC Driver.
-
Access Live Jumpseller Data in AWS Lambda
Connect to live Jumpseller data in AWS Lambda using the CData JDBC Driver.
-
Replicate Multiple Access Accounts via the CData Sync CLI
Replicate multiple Access accounts to one or many databases.
-
Connect to Google Sheets Data from PowerBuilder via JDBC
This article demonstrates how to access Google Sheets data from PowerBuilder using the Google Sheets JDBC Driver.
-
Integrating Dataiku with Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Salesforce data.
-
Integrate Apollo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Apollo with External Services.
-
Integrate Jumpseller with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Jumpseller with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Jumpseller data.
-
Connect to Azure Synapse Data in HULFT Integrate
Connect to Azure Synapse as a JDBC data source in HULFT Integrate
-
Query Live Greenplum Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Greenplum data through a conversational interface.
-
Build AI Agents with Salesloft Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Salesloft data through CData Connect AI.
-
Automated Continuous HCL Domino Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable HCL Domino data replication to OneLake in Microsoft Fabric.
-
DataBind Brex Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Brex data to a chart.
-
Access Live Google Contacts 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 Google Contacts data through MCP integration.
-
Use the CData Software ODBC Driver for MailChimp in MicroStrategy Desktop
Connect to MailChimp data in MicroStrategy Desktop using the CData Software ODBC Driver for MailChimp.
-
Query Live AlloyDB 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 AlloyDB data directly from the development environment.
-
Build Automated Greenhouse-Connected Workflows in Zapier
Use CData Connect AI to connect to live Greenhouse data and build automated workflows in Zapier.
-
Import Real-Time Zuora Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zuora data in ColdFusion.
-
How to Query Act-On Data in MySQL Workbench
Execute MySQL queries against live Act-On data from MySQL Workbench.
-
Migrating data from Google Tasks to Databricks using CData SSIS Components.
Easily push Google Tasks data to Databricks using the CData SSIS Tasks for Google Tasks and Databricks.
-
Build Anaplan-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Anaplan data and build Anaplan-connected web apps with Axios.
-
How to Query Live Drip Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Drip data data in natural language using Python.