CData Software - Knowledge Base
Recent Articles
-
Connect to Salesforce Marketing Data in DBeaver
Use the CData ODBC Driver to connect to Salesforce Marketing data in DBeaver.
-
Build an OLAP Cube in SSAS from SurveyMonkey Data
Establish a connection to SurveyMonkey data data from SQL Server Analysis Services, and use the SurveyMonkey Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Live Exa Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Exa data and integrate live Exa data into apps built in Microsoft Power Apps.
-
Connect to Freshdesk Data from a Connection Pool in JBoss
Integrate Freshdesk data into Java servlets: Use the Management Console in JBoss to install the Freshdesk JDBC Driver.
-
Access Eventbrite Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Eventbrite data from HeidiSQL.
-
Connect to Mouseflow Data in HULFT Integrate
Connect to Mouseflow as a JDBC data source in HULFT Integrate
-
Integrating LangChain with Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Couchbase data within automated workflows.
-
Build Charts with ZohoExpense Data in Clear Analytics
Create dynamic charts and perform analytics based on ZohoExpense data in Clear Analytics.
-
Creating Oracle SCM-Connected Applications in Unqork
You can use CData Connect AI to feed Oracle SCM data to Unqork and build custom business apps.
-
Integrate Bitly Data in the Pentaho Report Designer
Publish reports based on Bitly data in the Pentaho BI tool.
-
Integrating Kiro with SharePoint Excel Services 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.
-
Viewing TaxJar Data in RAD Studio Data Explorer
How to view TaxJar data in RAD Studio Data Explorer using the CData ODBC Driver for TaxJar.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Vercel
Provide connectivity to Vercel data through an SAP BusinessObjects universe.
-
Query SAP Fieldglass Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Fieldglass data from Node.js.
-
How to Connect to & Open Excel Online Data in Microsoft Excel
This article uses the CData ODBC driver for Excel Online to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Building Dynamic Web Pages with Presto Data Using AngularJS
Create single-page applications with live connectivity to Presto using the CData API Server.
-
Add Excel Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Excel with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish Reports with HubDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HubDB data.
-
How to Visualize SAS Data Sets Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SAS Data Sets data in Python.
-
Connect and Query Live Dynamics 365 Business Central Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Dynamics 365 Business Central data into Databricks and enable direct, live querying and analysis without replication.
-
Use the CData Software ODBC Driver for Office 365 in MicroStrategy
Connect to Office 365 data in MicroStrategy Developer using the CData Software ODBC Driver for Office 365.
-
How to Work with Pinterest Data in ETL Validator JDBC
Connect to Pinterest from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Snapchat Ads Data in Pentaho Data Integration
Build ETL pipelines based on Snapchat Ads data in the Pentaho Data Integration tool.
-
How to Connect Perplexity Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Perplexity data in real time using natural language.
-
Use Biml to Build SSIS Tasks to Replicate Ontraport Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Ontraport data to SQL Server.
-
Access Zuora Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zuora data from your Oracle system.
-
How to connect to FTP Data from IntelliJ
Integrate connectivity to FTP data with wizards in IntelliJ.
-
Access Hive Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Hive data.
-
Getting Started with the CData Power BI Connector for Printify
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build LinkedIn Ads-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live LinkedIn Ads data and build LinkedIn Ads-connected web apps with Axios.
-
How to connect and process Flowlu data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Flowlu data.
-
Connect to VWO Data as an External Source in Dremio
Use the CData JDBC Driver to connect to VWO as an External Source in Dremio.
-
Excel Spreadsheet Automation on Flowlu Data with the QUERY Formula
Pull data from Flowlu, automate spreadsheets, and more with the QUERY formula.
-
Prepare, Blend, and Analyze Certinia Data in Alteryx Designer (Connect AI)
Build workflows to access live Certinia data for self-service data analytics.
-
Integrate Trae with Live SAP Business Warehouse Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SAP Business Warehouse data from within the AI-powered IDE.
-
Connect to NetSuite SuiteAnalytics Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with NetSuite SuiteAnalytics Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Easily Query Contentful Data in OpenOffice Base
Connect to Contentful data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Bitbucket Data from PowerBuilder via ADO.NET
This article demonstrates how to access Bitbucket data from Appeon PowerBuilder using the CData ADO.NET Provider for Bitbucket.
-
How to connect to Supabase Data in DBVisualizer
Integrate Supabase data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated HDFS Data Replication to Teradata
Use CData Sync to Customize and automate HDFS data replication to Teradata.
-
Integrate Theia IDE with Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Monday.com data from within the development environment.
-
How to Access Live Tally Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Tally enables you to integrate Tally data into workflows built using Microsoft Power Automate Desktop.
-
Build Semantic Layer Views for Cohere Data in APOS Live Data Gateway
Use the CData Connector for Cohere in APOS Live Data Gateway to build Semantic Layer Views for Cohere data.
-
How to Connect to Live Dynamics 365 Business Central Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Dynamics 365 Business Central data for you.
-
Work with Live SageHR Data in Power Query
Use CData Connect AI to connect to SageHR data and work with live SageHR data in Microsoft Power Query.
-
Integrate with Live MongoDB Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to MongoDB from the MuleSoft Anypoint Platform to integrate live MongoDB data into custom reports and dashboards.
-
Validate Outlook Data with QuerySurge
Access and validate Outlook data in QuerySurge using the CData JDBC Driver.
-
Stream Workable Data into Apache Kafka Topics
Access and stream Workable data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Paymo 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 Paymo data through MCP integration.
-
Connect to Parquet Data in DBeaver
Use the CData ODBC Driver to connect to Parquet data in DBeaver.
-
Establish a Live Connection with FormSite Data using Tableau Bridge
The CData ODBC Driver for FormSite enables you to integrate live FormSite data into Tableau Cloud dashboards using the Tableau Bridge.
-
Write a Simple Go Application to work with Microsoft Teams Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Teams data.
-
Integrate Devin with Live Monday.com 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 Monday.com data.
-
Use Biml to Build SSIS Tasks to Replicate Google Ad Manager Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Ad Manager data to SQL Server.
-
Integrate Google's Vertex AI Agent with Live Bannerbear Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Bannerbear data within intelligent workflows.
-
Analyze SuiteCRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SuiteCRM data in Microsoft R Open.
-
Access Live ZohoInvoice Data in Coginiti Pro
Connect to and query live ZohoInvoice data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build a Singer.io Tap for Zoho Recruit With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Zoho Recruit data using the CData Python Connector.
-
Write a Simple Go Application to work with Rebilly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Rebilly data.
-
Use the CData Software JDBC Driver for Campaigner in MicroStrategy Web
Connect to Campaigner data in MicroStrategy Web using the CData Software JDBC Driver for Campaigner.
-
How to connect to Eventbrite Data from IntelliJ
Integrate connectivity to Eventbrite data with wizards in IntelliJ.
-
Interact with Live Azure Data Catalog Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Azure Data Catalog data.
-
Moving Data from QuickBooks Online to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live QuickBooks Online data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Publish Teamwork-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Teamwork data.
-
Access Teamwork Data from MySQL in Amazon QuickSight
Connect to Teamwork and build visualizations of Teamwork data using a MySQL Connection in Amazon QuickSight.
-
Import WordPress Data Using Azure Data Factory
Use CData Connect AI to connect to WordPress Data from Azure Data Factory and import live WordPress data.
-
LINQ to JobNimbus 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 JobNimbus Data Provider.
-
Publish SAP Fieldglass-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Fieldglass data.
-
Integrate SingleStore Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SingleStore data and integrate live SingleStore data into your Power Automate tasks.
-
Automated Continuous Outreach.io Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Outreach.io replication to Azure SQL Database.
-
Load Microsoft Entra ID Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Entra ID data to a database.
-
Build Automated Workflows with Live ADP Data in Workato
Use CData Connect AI to connect to live ADP data and build automated workflows in Workato.
-
A PostgreSQL Interface for Zoho Recruit Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho Recruit JDBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the Webflow JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Webflow data.
-
Integrating GitHub Copilot with ActiveCampaign 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 Miro Data in Talend Cloud Data Management Platform
Connect Miro Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create a Data Access Object for Elasticsearch Data using JDBI
A brief overview of creating a SQL Object API for Elasticsearch data in JDBI.
-
Analyze MYOB AccountRight Data in Cognos Analytics
Use CData Connect AI to connect to MYOB AccountRight Data from Cognos Analytics and analyze live MYOB AccountRight data.
-
Import Real-Time QuickBooks Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use QuickBooks data in ColdFusion.
-
How to use SQLAlchemy ORM to access Placid Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Placid data.
-
SAP Fieldglass Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Fieldglass facts in real time.
-
Connect to Nuclia Data in DBArtisan
Use wizards in DBArtisan to configure Nuclia data as a data source.
-
Replicate Multiple Aircall Accounts via the CData Sync CLI
Replicate multiple Aircall accounts to one or many databases.
-
Connect to HubDB in SpagoBI
Create reports featuring live HubDB data in SpagoBI Studio. Host HubDB reports on SpagoBI Server.
-
Connecting Pipedream with CouchDB 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 CouchDB data in real time.
-
Enable the VWO JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with VWO data.
-
Manage Basecamp Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Basecamp.
-
How to load Klipfolio data into Elasticsearch via Logstash
Introducing a simple method to load Klipfolio data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Live Tavily Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Tavily data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to ZendeskSell from Asprova with CData Software ODBC Driver for ZendeskSell
This article shows how to connect faster to ZendeskSell data from Asprova.
-
Bridge Raisers Edge NXT Connectivity with Apache NiFi
Access and process Raisers Edge NXT data in Apache NiFi using the CData JDBC Driver.
-
A PostgreSQL Interface for SAP Ariba Procurement Data using the CData ODBC Driver
Use the SQL Gateway and SAP Ariba Procurement ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import and Visualize Sage 300 Data in Power View
Create data visualizations based on Sage 300 data in Excel.
-
Visualize SFTP Data in Sisense
Create an ElastiCube in Sisense app with access to SFTP data.
-
Automate Moosend Data Replication to Azure Synapse
Use CData Sync to customize and automate Moosend data replication to Azure Synapse.
-
Visualize Close Data in Sisense
Create an ElastiCube in Sisense app with access to Close data.
-
Use the CData Software ODBC Driver for Customer.io in MicroStrategy
Connect to Customer.io data in MicroStrategy Developer using the CData Software ODBC Driver for Customer.io.
-
Getting Started with the CData SSIS Components for Perplexity
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Perplexity.
-
Automate SuiteCRM Data Replication to Azure Synapse
Use CData Sync to customize and automate SuiteCRM data replication to Azure Synapse.
-
How to integrate Reckon Accounts Hosted with Apache Airflow
Access and process Reckon Accounts Hosted data in Apache Airflow using the CData JDBC Driver.