CData Software - Knowledge Base
Recent Articles
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Apache Avro to Power BI dashboards. Simply drag and drop Apache Avro into data visuals on the Power BI canvas.
-
Configure the CData JDBC Driver for GetResponse in a Connection Pool in Tomcat
Connect to GetResponse from a connection pool in Tomcat.
-
How to Design HubDB Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to HubDB from mobile and tablet Power Apps.
-
How to Connect to Live Oracle SCM 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 Oracle SCM for you.
-
Build Data Flows from SQL Server to Reckon through SSIS
Easily push SQL Server data to Reckon using the CData SSIS Tasks for Reckon.
-
Integrating GitHub Copilot CLI with PhantomBuster 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 Claude Code CLI with Wrike 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 and Visualize Live EmailOctopus Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live EmailOctopus.
-
How to Connect to Live Tally Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Tally ERP for you.
-
How to connect to Zoho Recruit Data in DBVisualizer
Integrate Zoho Recruit with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Claude to Talk to Your GitHub 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 GitHub for you.
-
Build AI Agents with Neo4J 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 Neo4J through CData Connect AI.
-
Create SSAS Tabular Models from OpenWeatherMap Data
How to build a SQL Server Analysis Service Tabular Model from OpenWeatherMap using CData drivers.
-
How to Query Live ServiceDesk Plus Data in Claude Desktop
Connect to and query live ServiceDesk Plus Data in Claude Desktop using CData MCP Server.
-
Replicate Multiple Google Analytics Accounts via the CData Sync CLI
Replicate multiple Google Analytics accounts to one or many databases.
-
DataBind eBay Analytics Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for eBay Analytics with the DevExpress Windows Forms and Web controls to provide eBay Analytics to a chart.
-
Connect to OData Services in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for OData in Airbyte.
-
How to Connect DBeaver to Productboard via a JDBC Driver
Manage Productboard with visual tools in DBeaver like the query browser.
-
How to Build an ETL App for Helpscout Data in Python with CData
Create ETL applications and real-time data pipelines for Helpscout in Python with petl.
-
How to Seamlessly Import Paddle Data into IBM SPSS Modeler
Integrate Paddle data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Import Real-Time Google Ads Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Ads in ColdFusion.
-
Build Pipelines with Live Office 365 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Office 365 from Google Cloud Data Fusion, enabling the integration of live Microsoft Office 365 into the building and management of effective data pipelines.
-
Use the CData API Server to Access Deel Data in Microsoft PowerPivot
Use the CData API Server to connect to live Deel in the Power Pivot business intelligence tool.
-
Viewing BenchmarkEmail Data in RAD Studio Data Explorer
How to view BenchmarkEmail in RAD Studio Data Explorer using the CData ODBC Driver for BenchmarkEmail.
-
How to Connect to & Open Drip Data in Microsoft Excel
This article uses the CData ODBC driver for Drip to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Query Live Timely Data in Claude Desktop
Connect to and query live Timely Data in Claude Desktop using CData MCP Server.
-
Migrating data from Salesforce Marketing to Snowflake using CData SSIS Components.
Easily push Salesforce Marketing Cloud to Snowflake using the CData SSIS Tasks for Salesforce Marketing and Snowflake.
-
Getting Started with the CData Power BI Connector for Apify
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Live SAP HANA Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP HANA from your Excel spreadsheets.
-
A PostgreSQL Interface for Rootly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Rootly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to GitHub Data in CloverDX (formerly CloverETL)
Transfer GitHub using the visual workflow in the CloverDX data integration tool.
-
How to connect PolyBase to Elorus
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Elorus.
-
Migrating data from Google Tasks to Snowflake using CData SSIS Components.
Easily push Google Tasks to Snowflake using the CData SSIS Tasks for Google Tasks and Snowflake.
-
How to connect SharePoint with Jumpseller Data through external lists
Provide Jumpseller to SharePoint users as an external list.
-
Create Informatica Mappings From/To an ODBC Data Source for OData
Create an ODBC connection to OData in Informatica and browse and transfer OData.
-
Analyze CockroachDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of CockroachDB and visualize CockroachDB in SAP Analytics Cloud.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Act CRM
Provide connectivity to Act CRM through an SAP BusinessObjects universe.
-
Migrating data from Mixpanel to Google BigQuery using CData SSIS Components.
Easily push Mixpanel to Google BigQuery using the CData SSIS Tasks for Mixpanel and Google BigQuery.
-
Write a Simple Go Application to work with Todoist Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Todoist.
-
How to Query Live iContact Data in Perplexity MacOS Desktop
Connect to and query live iContact Data in Perplexity Desktop using CData MCP Server.
-
Use the CData Software JDBC Driver for Salesforce in MicroStrategy Web
Connect to Salesforce & Force.com in MicroStrategy Web using the CData Software JDBC Driver for Salesforce.
-
Marketo Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Marketo through CData Connect AI using different applications and tools.
-
Access Live Redshift Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Amazon Redshift in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Query Amplitude Data in MySQL Workbench
Execute MySQL queries against live Amplitude from MySQL Workbench.
-
Connect to NetSuite Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for NetSuite to connect to NetSuite CRM & ERP and execute queries in PowerBuilder.
-
How to Connect to & Open Dynamics CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Dynamics CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Dropbox Data in TIBCO Spotfire through OData
Integrate Dropbox into dashboards in TIBCO Spotfire.
-
Access Live Insightly Data in AWS Lambda
Connect to live Insightly in AWS Lambda using the CData JDBC Driver.
-
Integrate Live Lakebase Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build Visualizations of Suadeo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Suadeo in Birst.
-
Excel Add-In Getting Started Guide
A basic guide to connecting Excel to data from anywhere using the CData Excel Add-In.
-
Visualize Live Office 365 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Office 365 using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Omnisend
Provide connectivity to Omnisend through an SAP BusinessObjects universe.
-
Edit and Search Avro External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Apache Avro to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Avro objects that you can access from apps and the dashboard.
-
Building Dynamic Web Pages with Browserless Data Using AngularJS
Create single-page applications with live connectivity to Browserless using the CData API Server.
-
Connect to Samanage Data in NetBeans
Connect to Samanage in NetBeans with the data source configuration wizard.
-
Integrate Theia IDE with Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Pipeline CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pipeline CRM to connect to Pipeline CRM from Web applications running on WebLogic.
-
Create Wave Financial Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Wave Financial from PowerBI.com to create Power BI Dataflows with real-time data.
-
Migrating data from HDFS to Databricks using CData SSIS Components.
Easily push Apache HDFS to Databricks using the CData SSIS Tasks for HDFS and Databricks.
-
Connect to BigQuery Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google BigQuery in Airbyte.
-
Integrating Kiro CLI with Scrapfly 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.
-
Bridge Outreach.io Connectivity with Apache NiFi
Access and process Outreach.io in Apache NiFi using the CData JDBC Driver.
-
Connect to Eventbrite Data in JRuby
Create a simple JRuby app with access to live Eventbrite.
-
Access ShipEngine Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ShipEngine from HeidiSQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Everhour
Provide connectivity to Everhour through an SAP BusinessObjects universe.
-
Automated Continuous HDFS Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable HDFS replication to Google Cloud SQL.
-
Build Productboard-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Productboard Data in Gemini Code Assist to assist with building Productboard-powered applications.
-
Automated Continuous Freshsales Replication to Databricks
Use CData Sync for automated, continuous, customizable Freshsales replication to Databricks.
-
Back Up Accelo to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Accelo data.
-
Analyze Apollo Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apollo and visualize live Apollo in Infragistics Reveal.
-
How to load Sage 300 data into Elasticsearch via Logstash
Introducing a simple method to load Sage 300 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to publish and share Bright Data Data dashboards with Tableau Server
The CData ODBC driver for Bright Data enables you integrate Bright Data into Tableau dashboards.
-
Replicate Multiple PagerDuty Accounts via the CData Sync CLI
Replicate multiple PagerDuty accounts to one or many databases.
-
Build Automated Workflows with Live SAP Fieldglass Data in Workato
Use CData Connect AI to connect to live SAP Fieldglass and build automated workflows in Workato.
-
How to Query Live Reckon Data in Claude Desktop
Connect to and query live Reckon Data in Claude Desktop using CData MCP Server.
-
Integrating LlamaIndex with GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on GitHub in real time.
-
Connect and Visualize Live JSON Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live JSON into the Databricks platform and create visualization dashboards with real-time JSON.
-
Choosing the Best Method to Connect Bright Data to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Bright Data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to EnterpriseDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from EnterpriseDB, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to ServiceDesk Plus Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ServiceDesk Plus and the SQL Gateway to access ServiceDesk Plus from Google Apps Script.
-
DataBind Charts to Impala Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Impala 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.
-
Bind Live Paymo Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Paymo data
-
Automated Continuous Google Calendar Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Calendar replication to Google Cloud SQL.
-
How to Import Data from Drip into Google Sheets
Import Drip into a Google spreadsheet that is automatically refreshed.
-
View Reports on Real-Time Landbot Data in Power BI Report Server
Use the CData ODBC Driver for Landbot to visualize Landbot in Power BI Desktop and then publish them to Power BI Report Server.
-
Replicate SageHR Data to Multiple Databases
Replicate SageHR to disparate databases with a point-and-click configuration.
-
DataBind Controls to Salesloft Data in C++Builder
DataBind to Salesloft in C++Builder with standard components and controls.
-
Replicate Multiple Wistia Accounts via the CData Sync CLI
Replicate multiple Wistia accounts to one or many databases.
-
Create Marketo-Connected Business Apps in AppSheet
Connect to Marketo Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Marketo.
-
Query Jira Assets Data as a MySQL Database in Node.js
Execute MySQL queries against Jira Assets from Node.js.
-
Access Live Odoo Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Odoo ERP from your Excel spreadsheets.
-
Access Live Redshift Data in AWS Lambda
Connect to live Amazon Redshift in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Zoho Inventory Replication to SQLite
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to SQLite.
-
Choosing the Best Method to Connect Gorgias to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Gorgias from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build an OLAP Cube in SSAS from ZohoExpense Data
Establish a connection to ZohoExpense data from SQL Server Analysis Services, and use the ZohoExpense Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automate Odoo Data Replication to Couchbase
Use CData Sync to Customize and automate Odoo ERP replication to Couchbase.
-
Access Live Reckon Accounts Hosted Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Reckon Accounts Hosted data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Semantic Layer Views for Hive Data in APOS Live Data Gateway
Use the CData Connector for Hive in APOS Live Data Gateway to build Semantic Layer Views for Apache Hive.
-
Import Kintone Data Using Azure Data Factory
Use CData Connect AI to connect to Kintone Data from Azure Data Factory and import live Kintone.