CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Excel Add-In for JotForm
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for JotForm.
-
How to integrate SAP Concur with Apache Airflow
Access and process SAP Concur in Apache Airflow using the CData JDBC Driver.
-
A PostgreSQL Interface for SharePoint Excel Services Data (MySQL Remoting via JDBC)
Use the Remoting features of the SharePoint Excel Services JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze ZohoDesk Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZohoDesk with the CData JDBC Driver for ZohoDesk.
-
DataBind Charts to Keap Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Keap 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.
-
Automated Ontraport Data Replication to Teradata
Use CData Sync to Customize and automate Ontraport replication to Teradata.
-
Use Dash to Build to Web Apps on CockroachDB Data
Create Python applications that use pandas and Dash to build CockroachDB-connected web apps.
-
Integrate Goose with Live Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Email from within the local AI agent.
-
Connect to Freshteam Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Freshteam and work with Freshteam in your FileMaker applications.
-
How to Access SendGrid Data Using Entity Framework
This article shows how to access SendGrid using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Work with Hubstaff Data in ETL Validator JDBC
Connect to Hubstaff from ETL Validator jobs using the CData Software JDBC Driver.
-
Query Dotmailer Data in ColdFusion
Write standard ColdFusion data access code to connect to Dotmailer.
-
Migrating data from Splunk to Google BigQuery using CData SSIS Components.
Easily push Splunk to Google BigQuery using the CData SSIS Tasks for Splunk and Google BigQuery.
-
Visualize Mouseflow Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Mouseflow.
-
Access Sugar CRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sugar CRM from your Oracle system.
-
Integrating OpenCode Terminal with MessageBird 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.
-
Automated Continuous EnterpriseDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to IBM DB2.
-
Access Amazon Marketplace Data from MySQL in Amazon QuickSight
Connect to Amazon Marketplace and build visualizations of Amazon Marketplace using a MySQL Connection in Amazon QuickSight.
-
Use the CData API Server to Access CockroachDB Data in Microsoft PowerPivot
Use the CData API Server to connect to live CockroachDB in the Power Pivot business intelligence tool.
-
Query Zuora Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Zuora entities in PHP by modeling them as objects.
-
Create SSAS Tabular Models from Okta Data
How to build a SQL Server Analysis Service Tabular Model from Okta using CData drivers.
-
Integrate Zoho Creator Data into Power Automate Desktop using CData Connect
CData Connect for Zoho Creator Data enables you to integrate Zoho Creator into workflows built using Microsoft Power Automate Desktop.
-
Connect to Zoho CRM Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Zoho CRM Data and connect to Zoho CRM in Akorbi Digital RunMyProcess.
-
Create SSAS Tabular Models from Mouseflow Data
How to build a SQL Server Analysis Service Tabular Model from Mouseflow using CData drivers.
-
Use Claude to Talk to Your Klaviyo 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 Klaviyo for you.
-
Working with MessageBird Data in LINQPad
Execute LINQ queries to MessageBird in LINQPad.
-
Build EnterpriseDB-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for EnterpriseDB to explore live EnterpriseDB Data in Gemini Code Assist to assist with building EnterpriseDB-powered applications.
-
Access Live Dynamics CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Dynamics CRM from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to connect SharePoint with Dropbox Data through external lists
Provide Dropbox to SharePoint users as an external list.
-
How to connect to Box Data in DBVisualizer
Integrate Box with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to OpenWeatherMap Data in HULFT Integrate
Connect to OpenWeatherMap as a JDBC data source in HULFT Integrate
-
Connecting Moonlit Workflow with Oracle Sales Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Oracle Sales in real time.
-
How to Access Live Dotmailer Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Dotmailer enables you to integrate Dotmailer into workflows built using Microsoft Power Automate Desktop.
-
Connect to Coda Data in RazorSQL
Connect to Coda from wizards and query Coda from the GUI in the RazorSQL database management tool.
-
Automated Continuous Jira Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Jira replication to Amazon S3.
-
Integrating OpenCode Terminal with Eventbrite 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 Real-Time QuickBooks Time Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for QuickBooks Time and Dataflow to import and use QuickBooks Time in Power Apps.
-
Connect to Avro Data in Aqua Data Studio
Access Apache Avro from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Visualizations of SendInBlue Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SendInBlue in Birst.
-
Analyze Salesforce CRM Analytics Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesforce CRM Analytics with the CData JDBC Driver for Salesforce CRM Analytics.
-
How to Visualize Webex Data in Python with pandas
Use pandas and other modules to analyze and visualize live Webex in Python.
-
Connect SAP Business Warehouse to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Business Warehouse with IBM WebSphere for seamless data integration and connectivity.
-
Create ServiceNow-Connected Applications in Appsmith
Connect to ServiceNow Data via CData Connect AI in Appsmith and create custom business applications with real-time access to ServiceNow.
-
Write a Simple Go Application to work with SAP Business One Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Business One.
-
Visualize OneNote 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 Microsoft OneNote into TIBCO Spotfire.
-
Analyze QuickBooks Online Data in Looker
Use CData Connect AI to connect to QuickBooks Online Data from Looker and build custom apps using live QuickBooks Online.
-
Automated Continuous LaunchDarkly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Amazon S3.
-
Build MVC Applications with Connectivity to Tally Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Tally from an ASP.NET MVC application.
-
Build Data Flows from Vimeo to SQL Server using SSIS
Easily back up Vimeo to SQL Server using the SSIS components for Vimeo.
-
Manage Keap Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Keap.
-
Integrating LangGraph with Quickbase Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Quickbase within automated workflows.
-
How to Connect to Live Sugar CRM Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Sugar CRM for you.
-
Automated Continuous DocuSign Replication to Snowflake
Use CData Sync for automated, continuous, customizable DocuSign replication to Snowflake.
-
LINQ to Timely Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Timely Data Provider.
-
Automated Continuous Moosend Replication to SingleStore
Use CData Sync for automated, continuous, customizable Moosend replication to SingleStore.
-
Use the CData Software ODBC Driver for Outreach.io in MicroStrategy
Connect to Outreach.io in MicroStrategy Developer using the CData Software ODBC Driver for Outreach.io.
-
Connect Bullhorn CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Bullhorn CRM using the CData Python MCP Server.
-
Integrating OpenCode Terminal with LightSpeedRetail 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.
-
Build Dashboards with CloudConvert Data in Dundas BI
Create dynamic dashboards and perform analytics based on CloudConvert in Dundas BI.
-
How to publish and share Oracle Data dashboards with Tableau Server
The CData ODBC driver for Oracle enables you integrate Oracle Database into Tableau dashboards.
-
Access Live ZohoDesk Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ZohoDesk in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect DBeaver to Float via a JDBC Driver
Manage Float with visual tools in DBeaver like the query browser.
-
Build Voice Agents in ElevenLabs with access to Live Azure Analysis Services Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Azure Analysis Services.
-
Getting Started with the CData JDBC Driver for Discourse
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Discourse.
-
Load Google Campaign Manager 360 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Campaign Manager 360 to a database.
-
Automated Continuous MarkLogic Replication to MySQL
Use CData Sync for automated, continuous, customizable MarkLogic replication to MySQL.
-
Connect to Brex in SpagoBI
Create reports featuring live Brex in SpagoBI Studio. Host Brex reports on SpagoBI Server.
-
How to connect PolyBase to Workable
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Workable.
-
ETL CampaignMonitor in Oracle Data Integrator
This article shows how to transfer CampaignMonitor into a data warehouse using Oracle Data Integrator.
-
Prepare, Blend, and Analyze Google Drive Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Drive for self-service data analytics.
-
Build Pipelines with Live Excel Online Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Excel Online from Google Cloud Data Fusion, enabling the integration of live Microsoft Excel Online into the building and management of effective data pipelines.
-
Access Live Sybase Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sybase from your Google Sheets.
-
How to import Dynamics 365 Data into Apache Solr
Use the CData Software JDBC Driver for Dynamics 365 in Data Import Handler and create an automated import of Microsoft Dynamics 365 to Apache Solr Enterprise Search platform.
-
Enable the AgileCRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with AgileCRM.
-
Analyze Flowlu Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Flowlu with the CData JDBC Driver for Flowlu.
-
Use Dash to Build to Web Apps on Teamgate Data
Create Python applications that use pandas and Dash to build Teamgate-connected web apps.
-
Add Workable Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Workable with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Adobe Target Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Adobe Target into the statistical analysis tools available in SAS JMP. This article shows how to use Adobe Target in the Graph Builder and Query Builder.
-
Replicate Clio Data in Heroku for Use in Salesforce Connect
Replicate Clio to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Design BIRT Reports on Bright Data Data
Provide current Bright Data to your embedded analytics.
-
Integrating Gumloop with Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Paylocity within automated workflows.
-
Integrate Act CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Act CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Act CRM.
-
Establish a Live Connection with Toggl Data using Tableau Bridge
The CData ODBC Driver for Toggl enables you to integrate live Toggl into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Visualize Dynamics 365 Business Central Data in Python with pandas
Use pandas and other modules to analyze and visualize live Dynamics 365 Business Central in Python.
-
Publish Crystal Reports on Odoo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Odoo ERP.
-
Automated Continuous Mailjet Replication to MongoDB
Use CData Sync for automated, continuous, customizable Mailjet replication to MongoDB.
-
Integrating Kiro CLI with SAP ByDesign 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.
-
Query Live Microsoft Entra ID 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 Microsoft Entra ID directly from the development environment.
-
Integrating Grafana Data in Talend Cloud Data Management Platform
Connect Grafana Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Visualize Blackbaud FE NXT Data in Python with pandas
Use pandas and other modules to analyze and visualize live Blackbaud FE NXT in Python.
-
Excel Spreadsheet Automation on FreshBooks Data with the QUERY Formula
Pull data from FreshBooks, automate spreadsheets, and more with the QUERY formula.
-
Back Up XML Files to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for XML. In this article, we will employ an SSIS workflow to populate a database with XML Files data.
-
How to connect Amazon QuickSight to MailChimp Data
Create a connection to MailChimp in CData Connect AI and insert MailChimp into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Reports with Mode Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mode.
-
Access Live Acumatica Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Acumatica ERP from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to create Salesforce federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesforce & Force.com in MySQL .
-
Seamlessly Bring Oracle Sales Data into Retool Using CData Connect AI
Integrate Oracle Sales data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Excel Spreadsheet Automation on Placid Data with the QUERY Formula
Pull data from Placid, automate spreadsheets, and more with the QUERY formula.
-
Connect to and Query Authorize.Net Data in QlikView over ODBC
Create data visualizations with Authorize.Net in QlikView.
-
Visualize Live SAP Business One Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Business One using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.