CData Software - Knowledge Base
Recent Articles
-
Build a PostgreSQL Interface for ZohoPeople Data using the CData JDBC Driver
Use the Remoting features of the ZohoPeople JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Crystal Reports on Typeform Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Typeform data.
-
How to Connect to Live Kintone Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Kintone data without replication.
-
Integrate with Bullhorn CRM Data in JReport Designer
Create charts and reports based on Bullhorn CRM data in JReport Designer.
-
Bridge LightSpeedRetail Connectivity with Apache NiFi
Access and process LightSpeedRetail data in Apache NiFi using the CData JDBC Driver.
-
Use Agno to Talk to Your OneNote 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 OneNote data for you.
-
Use the CData ODBC Driver for Gumroad in Microsoft Power Query
You can use the CData Gumroad ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Gumroad data into Microsoft Power Query.
-
Query Bitly Data as a MySQL Database in Node.js
Execute MySQL queries against Bitly data from Node.js.
-
Integrate Cursor with Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zoho Books data from within the editor.
-
Build an OLAP Cube in SSAS from Azure DevOps Data
Establish a connection to Azure DevOps data data from SQL Server Analysis Services, and use the Azure DevOps Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect to Helpscout Data in DBVisualizer
Integrate Helpscout data with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Google Campaign Manager 360 Data in Sisense
Create an ElastiCube in Sisense app with access to Google Campaign Manager 360 data.
-
Integrating Codex with ConstantContact 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.
-
Moving Data from Harvest to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Harvest data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Workable Data from MySQL in Amazon QuickSight
Connect to Workable and build visualizations of Workable data using a MySQL Connection in Amazon QuickSight.
-
Build Dashboards with SAP Concur Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Concur data in DBxtra.
-
Build Automated Workflows with Live Tavily Data in Workato
Use CData Connect AI to connect to live Tavily data and build automated workflows in Workato.
-
Access Live CouchDB Data in AWS Lambda
Connect to live CouchDB data in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for LinkedIn Ads in MicroStrategy Web
Connect to LinkedIn Ads data in MicroStrategy Web using the CData Software ODBC Driver for LinkedIn Ads.
-
How to create an RPA flow for BambooHR Data in UiPath Studio
Use the BambooHR ODBC Driver to create workflows that access real-time BambooHR data without any coding.
-
Connect to Lakebase Data in Jaspersoft Studio
Execute SQL to remote Lakebase data in Jaspersoft Studio.
-
Automated Continuous Jumpseller Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Jumpseller replication to Amazon S3.
-
Create Power BI Reports on Real-Time Mailjet Data
Use the CData ODBC Driver for Mailjet to visualize Mailjet data in Power BI Desktop.
-
How to Seamlessly Import Coinbase Data into IBM SPSS Modeler
Integrate Coinbase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Real-Time Salesloft Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Salesloft and Dataflow to import and use Salesloft data in Power Apps.
-
Back Up Salesforce data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Salesforce. In this article, we will employ an SSIS workflow to populate a database with Salesforce data data.
-
Analyze Clari Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Clari data with the CData JDBC Driver for Clari.
-
Access Live Zoom Data in Excel 365 Online (Excel for the web)
Connect to Zoom data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Apps with Live SAP BusinessObjects BI Data Using the Low-Code Development Platform of Mendix
Connect SAP BusinessObjects BI data with Mendix to build apps using the CData JDBC Driver for SAP BusinessObjects BI.
-
Access Rebilly Data from MySQL in PHP
Connect to Rebilly through the standard MySQL libraries in PHP.
-
Use the CData ODBC Driver for Google Calendar from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Calendar to connect to Google Calendar data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Calendar data in Excel.
-
Connect to SQL Server Data in Claris FileMaker Pro
Use the CData ODBC Driver for SQL Server in FileMaker Pro to connect to SQL Server and work with SQL Server data in your FileMaker applications.
-
How to Connect DBeaver to JobNimbus via a JDBC Driver
Manage JobNimbus data with visual tools in DBeaver like the query browser.
-
Automated Continuous Placid Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Placid replication to delimited files (CSV/TSV).
-
Connect to Vercel from Asprova with CData Software ODBC Driver for Vercel
This article shows how to connect faster to Vercel data from Asprova.
-
How to Access Live Helpscout Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Helpscout enables you to integrate Helpscout data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Elorus Data from PowerShell
Write a quick PowerShell script to query Elorus data. Use connectivity to the live data to replicate Elorus data to SQL Server.
-
Automated Continuous FHIR Replication to MySQL
Use CData Sync for automated, continuous, customizable FHIR replication to MySQL.
-
Analyze Live Kafka Data in SAS Viya
Use CData Connect AI to connect to Kafka data from SAS Viya and deploy self-service analytics using live Kafka data.
-
Create Reports from QuickBooks Time Data in Looker Studio
Use CData Connect AI to gain access to live QuickBooks Time data and create custom reports in Looker Studio.
-
How to create an RPA flow for Google Analytics Data in UiPath Studio
Use the Google Analytics ODBC Driver to create workflows that access real-time Google Analytics data without any coding.
-
Build SAS Data Sets Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAS Data Sets data and build visualizations in Tableau.
-
Create Databricks Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Databricks data access from reports, embedded analytics, and more.
-
Integrating Claude Code CLI with JDBC-ODBC Bridge 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.
-
Use Microsoft Copilot Studio to talk to your Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Phoenix data for you.
-
Integrating Antigravity CLI with XML data via CData CLI
Connect XML data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Sugar CRM from Asprova with CData Software ODBC Driver for Sugar CRM
This article shows how to connect faster to Sugar CRM data from Asprova.
-
Import Highrise Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Highrise Data and provide access to live Highrise data for custom reports in the Power BI Service.
-
Load Avaza Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Avaza data to a database.
-
Create Informatica Mappings From/To a JDBC Data Source for WordPress
Create WordPress data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Boomi Agentstudio with CockroachDB Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to CockroachDB data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Onfleet Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Onfleet replication to Apache Kafka.
-
Access Live Oracle Service Cloud Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Service Cloud data from your Excel spreadsheets.
-
Create SSAS Tabular Models from SAP Hybris C4C Data
How to build a SQL Server Analysis Service Tabular Model from SAP Hybris C4C data using CData drivers.
-
Connect to Quaderno Data from a Connection Pool in JBoss
Integrate Quaderno data into Java servlets: Use the Management Console in JBoss to install the Quaderno JDBC Driver.
-
Migrating data from LDAP to Databricks using CData SSIS Components.
Easily push LDAP objects to Databricks using the CData SSIS Tasks for LDAP and Databricks.
-
Build Teradata-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Teradata Data and create custom apps in Mendix.
-
Migrating data from Elorus to Google BigQuery using CData SSIS Components.
Easily push Elorus data to Google BigQuery using the CData SSIS Tasks for Elorus and Google BigQuery.
-
Query Excel Data in ColdFusion
Write standard ColdFusion data access code to connect to Excel data.
-
Automated Continuous Odoo Replication to Vertica
Use CData Sync for automated, continuous, customizable Odoo replication to Vertica.
-
How to Connect to Live PolarTeamPro Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live PolarTeamPro data without replication.
-
Easily Integrate Power BI XMLA Data in Lazarus Pascal IDE
Learn how to easily integrate live Power BI XMLA data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Add Paymo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Paymo with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Visualize FHIR Data in Python with pandas
Use pandas and other modules to analyze and visualize live FHIR data in Python.
-
Replicate Multiple PayPal Accounts via the CData Sync CLI
Replicate multiple PayPal accounts to one or many databases.
-
Connect to Amazon S3 Data in CloverDX (formerly CloverETL)
Transfer Amazon S3 data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Jira Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Jira replication to Apache Cassandra.
-
Connect to SAP Hybris C4C Data in NetBeans
Connect to SAP Hybris C4C data in NetBeans with the data source configuration wizard.
-
Build a Singer.io Tap for Timely With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Timely data using the CData Python Connector.
-
Create Campaigner-Connected Nintex Workflows
Use CData Connect AI to connect to Campaigner Data from Nintex Workflow Cloud and build custom workflows using live Campaigner data.
-
Use Microsoft Copilot Studio to talk to your Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Kintone data for you.
-
Write a Simple Go Application to work with ZeroBounce Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZeroBounce data.
-
Access Live ZohoSubscriptions Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ZohoSubscriptions data into the statistical analysis tools available in SAS JMP. This article shows how to use ZohoSubscriptions data in the Graph Builder and Query Builder.
-
Deploy the ADO.NET Provider for Zoho Inventory on an SSRS Report Server
Connect to Zoho Inventory 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.
-
Integrate with Everhour Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Everhour data to a JSON file on disk.
-
Analyze ZohoInvoice Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ZohoInvoice data and visualize ZohoInvoice data in SAP Analytics Cloud.
-
Use the CData Software ODBC Driver for Instagram in SAS for Real-Time Reporting and Analytics
Connect to real-time Instagram data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Instagram.
-
Replicate Multiple Codat Accounts via the CData Sync CLI
Replicate multiple Codat accounts to one or many databases.
-
How to load ZendeskSell data into Elasticsearch via Logstash
Introducing a simple method to load ZendeskSell data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect PolyBase to EmailOctopus
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live EmailOctopus data.
-
Automated Continuous Strava Replication to Vertica
Use CData Sync for automated, continuous, customizable Strava replication to Vertica.
-
Query Factorial Data as a MySQL Database in Node.js
Execute MySQL queries against Factorial data from Node.js.
-
A PostgreSQL Interface for Smartsheet Data (MySQL Remoting via JDBC)
Use the Remoting features of the Smartsheet JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Pipeliner CRM Data Replication to Couchbase
Use CData Sync to Customize and automate Pipeliner CRM data replication to Couchbase.
-
Connect to Splunk Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Splunk data.
-
How to create SparkPost federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SparkPost data in MySQL .
-
Automated Continuous Access Replication to MongoDB
Use CData Sync for automated, continuous, customizable Access replication to MongoDB.
-
Integrating GitHub Copilot with Missive 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.
-
Visualize Live Notion Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Notion data into custom reports in Power BI.
-
Access Jira Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Jira data from your Oracle system.
-
Feed HCL Domino Data into FineReport
How to set HCL Domino data as a JDBC data source in FineReport.
-
Replicate Acumatica Data to Multiple Databases via the CData Sync CLI
Replicate Acumatica data to disparate databases with a single configuration.
-
Write a Simple Go Application to work with Greenhouse Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Greenhouse data.
-
How to Connect the Power BI Service to IBM Cloud Object Storage: Complete Guide
Connect to the CData Software Power BI Connector for IBM Cloud Object Storage from PowerBI.com to provide real-time IBM Cloud Object Storage data across the organization.
-
Build Agents in Relevance AI with Access to Live Discord Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Discord data within intelligent agent workflows.
-
Build LinkedIn Ads Visualizations in Tableau Cloud
Use CData Connect AI to connect to live LinkedIn Ads data and build visualizations in Tableau Cloud.
-
Replicate Zoho Creator Data in Heroku for Use in Salesforce Connect
Replicate Zoho Creator data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Excel Spreadsheet Automation on GetResponse Data with the QUERY Formula
Pull data from GetResponse, automate spreadsheets, and more with the QUERY formula.
-
Perform Batch Operations with SharePoint Data in Apache NiFi
Connect to SharePoint data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Xero Replication to SingleStore
Use CData Sync for automated, continuous, customizable Xero replication to SingleStore.