CData Software - Knowledge Base
Recent Articles
-
How to Import Data from Databricks into Google Sheets
Import Databricks into a Google spreadsheet that is automatically refreshed.
-
Replicate Omnisend Data to Multiple Databases via the CData Sync CLI
Replicate Omnisend to disparate databases with a single configuration.
-
Getting Started with the CData Power BI Connector for YouTube Analytics
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for YouTube Analytics.
-
How to Access Live Email Data in Visual Studio Code via Cline
Run CData MCP Server for Email on Windows Subsytem for Linux (WSL) and connect to live Email from the Cline extension in Visual Studio Code.
-
Visualize WooCommerce Data in Tableau
The CData ODBC driver for WooCommerce enables you integrate WooCommerce into Tableau dashboards.
-
Replicate Multiple Act CRM Accounts
Replicate multiple Act CRM accounts to one or many databases.
-
Migrating data from Toggl to Snowflake using CData SSIS Components.
Easily push Toggl to Snowflake using the CData SSIS Tasks for Toggl and Snowflake.
-
Use the CData Software ODBC Driver for RSS in MicroStrategy Desktop
Connect to RSS Feeds in MicroStrategy Desktop using the CData Software ODBC Driver for RSS.
-
Visualize Live Amazon S3 Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Amazon S3.
-
DataBind Elorus Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Elorus to a chart.
-
Connect to Zoho Creator Data in RazorSQL
Connect to Zoho Creator from wizards and query Zoho Creator from the GUI in the RazorSQL database management tool.
-
Query Live Trello 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 Trello directly from the development environment.
-
Use the CData Software JDBC Driver for ScrapingBee in MicroStrategy
Connect to ScrapingBee in MicroStrategy Developer using the CData Software JDBC Driver for ScrapingBee.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Dynamics 365 Business Central to Power BI dashboards. Simply drag and drop Dynamics 365 Business Central into data visuals on the Power BI canvas.
-
Create Power BI Reports on Real-Time Jodoo Data
Use the CData ODBC Driver for Jodoo to visualize Jodoo in Power BI Desktop.
-
Access Live MailChimp Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live MailChimp through MCP integration.
-
Consume Mailgun OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Mailgun feeds that reflect any changes in SAP Lumira.
-
Integrating Dataiku with ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ServiceNow.
-
Access Kafka 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 Apache Kafka.
-
How to Query Live FreshBooks Data in Perplexity MacOS Desktop
Connect to and query live FreshBooks Data in Perplexity Desktop using CData MCP Server.
-
Integrating Cursor CLI with FreshBooks 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.
-
Integrate Live MarkLogic Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live MarkLogic to Blue Prism using the CData ODBC Driver for MarkLogic to create automated workflows for repetitive business tasks.
-
Build Freshservice-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Freshservice Data and create custom apps in Bubble.
-
Integrating Claude Code CLI with Google Sheets 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 Connect to & Open Sentry Data in Microsoft Excel
This article uses the CData ODBC driver for Sentry to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Import Data from Oracle Service Cloud into Google Sheets
Import Oracle Service Cloud into a Google spreadsheet that is automatically refreshed.
-
Use the CData Software ODBC Driver for Dynamics 365 Business Central in MicroStrategy Desktop
Connect to Dynamics 365 Business Central in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics 365 Business Central.
-
Establish a Live Connection with Superchat Data using Tableau Bridge
The CData ODBC Driver for Superchat enables you to integrate live Superchat into Tableau Cloud dashboards using the Tableau Bridge.
-
Build an OLAP Cube in SSAS from Twitter Ads Data
Establish a connection to Twitter Ads data from SQL Server Analysis Services, and use the Twitter Ads Data Provider to build OLAP cubes for use in analytics and reporting.
-
Import and Visualize Bullhorn CRM Data in Power View
Create data visualizations based on Bullhorn CRM in Excel.
-
Getting Started with the CData Power BI Connector for SAP Netweaver Gateway
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Netweaver Gateway.
-
Use JayDeBeApi to access Keap Data in Python
Use standard Python scripting and the development environment of your choice to access live Keap.
-
Easily Integrate ZohoDesk Data in Lazarus Pascal IDE
Learn how to easily integrate live ZohoDesk in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Live Apollo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Apollo into custom reports in Power BI.
-
Build Automated Oracle Service Cloud-Connected Workflows in Zapier
Use CData Connect AI to connect to live Oracle Service Cloud and build automated workflows in Zapier.
-
Use the CData API Server to Access Google Directory Data in Microsoft PowerPivot
Use the CData API Server to connect to live Google Directory in the Power Pivot business intelligence tool.
-
Access SAP HANA XS Advanced Data from MySQL in PHP
Connect to SAP HANA XS Advanced through the standard MySQL libraries in PHP.
-
Edit and Search Gmail External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Gmail to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Gmail objects that you can access from apps and the dashboard.
-
Connect to Aha! Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Aha! and the SQL Gateway to access Aha! from Google Apps Script.
-
Use the CData Software JDBC Driver for Redis in MicroStrategy
Connect to Redis in MicroStrategy Developer using the CData Software JDBC Driver for Redis.
-
Connect to Dynamics NAV Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Dynamics NAV as an External Source in Dremio.
-
Access Live Zendesk Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zendesk from your Excel spreadsheets.
-
How to Access Live GitHub Data in Visual Studio Code via Cline
Run CData MCP Server for GitHub on Windows Subsytem for Linux (WSL) and connect to live GitHub from the Cline extension in Visual Studio Code.
-
Visualize Presto Data in Tableau
The CData ODBC driver for Presto enables you integrate Presto into Tableau dashboards.
-
Trigger Blackbaud FE NXT IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Blackbaud FE NXT with standard wizards in Logic Apps.
-
How to connect and process Missive from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Missive.
-
Use the CData Software JDBC Driver for SpaceX in MicroStrategy Web
Connect to SpaceX in MicroStrategy Web using the CData Software JDBC Driver for SpaceX.
-
Build Dashboards with ActiveCampaign Data in DBxtra
Create dynamic dashboards and perform analytics based on ActiveCampaign in DBxtra.
-
Connect to Facebook Ads Data in JRuby
Create a simple JRuby app with access to live Facebook Ads.
-
How to Seamlessly Import Xero Data into IBM SPSS Modeler
Integrate Xero data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to Live Zuora 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 Zuora for you.
-
Access Accelo 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 Accelo.
-
Import and Visualize NetSuite Data in Power View
Create data visualizations based on NetSuite CRM & ERP in Excel.
-
Consume Beeminder OData Feeds in PowerBuilder
This article demonstrates how to consume Beeminder as OData feeds from PowerBuilder using the API Server.
-
Getting Started with the CData JDBC Driver for Jumpseller
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Jumpseller.
-
Connect to Hugging Face Data in NetBeans
Connect to Hugging Face in NetBeans with the data source configuration wizard.
-
Consume Sendwithus OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sendwithus feeds that reflect any changes in SAP Lumira.
-
Oracle Service Cloud Reporting in OBIEE with the Oracle Service Cloud JDBC Driver
Deploy the Oracle Service Cloud JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Close Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build a PostgreSQL Interface for MailChimp Data using the CData JDBC Driver
Use the Remoting features of the MailChimp JDBC Driver to create a PostgreSQL entry-point for data access.
-
Excel Spreadsheet Automation on Oracle Eloqua Data with the QUERY Formula
Pull data from Oracle Eloqua, automate spreadsheets, and more with the QUERY formula.
-
Analyze Dropbox Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Dropbox from Power Pivot. You will use the Table Import Wizard to load Dropbox. You can visually build the import query or use any SQL supported by the driver.
-
Automated Figshare Data Replication to Teradata
Use CData Sync to Customize and automate Figshare replication to Teradata.
-
Integrating Antigravity CLI with ServiceDesk Plus via CData CLI
Connect ServiceDesk Plus to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect to & Open Shippo Data in Microsoft Excel
This article uses the CData ODBC driver for Shippo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Microsoft Entra ID Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Entra ID from PowerShell? This article demonstrates how to utilize the Microsoft Entra ID Cmdlets for tasks like connecting to Microsoft Entra ID, automating operations, downloading data, and more.
-
Connect to Excel Online Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Excel Online to connect to Microsoft Excel Online and execute queries in PowerBuilder.
-
Build Data Flows from Reckon to SQL Server using SSIS
Easily back up Reckon to SQL Server using the SSIS components for Reckon.
-
Analyze IBM Informix Data in Cognos Analytics
Use CData Connect AI to connect to IBM Informix Data from Cognos Analytics and analyze live IBM Informix.
-
Create a Data Access Object for JSON Services using JDBI
A brief overview of creating a SQL Object API for JSON in JDBI.
-
Use the CData Software ODBC Driver for ZendeskSell in SAS for Real-Time Reporting and Analytics
Connect to real-time ZendeskSell in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZendeskSell.
-
How to Connect to Live Office 365 Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft Office 365 securely in real time.
-
Getting Started with the CData Python Connector for Elasticsearch
Learn to install and license the CData Python Connector
-
DataBind Controls to IBM Cloud Object Storage Data in C++Builder
DataBind to IBM Cloud Object Storage in C++Builder with standard components and controls.
-
Build MVC Applications with Connectivity to Aircall Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Aircall from an ASP.NET MVC application.
-
Query ZeroBounce Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZeroBounce from Node.js.
-
Create Informatica Mappings From/To a JDBC Data Source for Square
Create Square data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use Biml to Build SSIS Tasks to Replicate Zoho Inventory Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Inventory to SQL Server.
-
Integrating Codex CLI with Invoiced 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.
-
Consume Google Drive OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Drive feeds that reflect any changes in SAP Lumira.
-
Integrate Facebook Ads Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Facebook Ads from Informatica Cloud.
-
Use the CData ODBC Driver for Rebilly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Rebilly to connect to Rebilly from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Rebilly in Excel.
-
Import Real-Time SAP SuccessFactors LMS Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP SuccessFactors LMS in ColdFusion.
-
How to Easily Query Scrapfly Data in OpenOffice Base
Connect to Scrapfly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData ODBC Driver for REST from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for REST to connect to REST from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring REST in Excel.
-
Design BIRT Reports on Zoho Recruit Data
Provide current Zoho Recruit to your embedded analytics.
-
Integrate Gong Data in the Pentaho Report Designer
Publish reports based on Gong in the Pentaho BI tool.
-
Import Real-Time Printify Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Printify in ColdFusion.
-
Access Live Testmonitor Data in Coginiti Pro
Connect to and query live Testmonitor from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for ADP in MicroStrategy
Connect to ADP in MicroStrategy Developer using the CData Software ODBC Driver for ADP.
-
Validate Accelo Data with QuerySurge
Access and validate Accelo in QuerySurge using the CData JDBC Driver.
-
Build SAP SuccessFactors LMS-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP SuccessFactors LMS and build web apps with connectivity to live SAP SuccessFactors LMS.
-
Connect Optimizely to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Optimizely using the CData Python MCP Server.
-
Configure the CData JDBC Driver for Customer.io in a Connection Pool in Tomcat
Connect to Customer.io from a connection pool in Tomcat.
-
How to connect to Stack Exchange Data in DBVisualizer
Integrate Stack Exchange with visual data analysis tools and data connection wizards in DBVisualizer
-
Work with MailerSend Data in FoxPro
Load MailerSend into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Cursor with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Azure Synapse from within the editor.
-
Connect VWO to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect VWO with IBM WebSphere for seamless data integration and connectivity.
-
Connect to SAP ByDesign Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP Business ByDesign in Airbyte.
-
Establish a Live Connection with Outreach.io Data using Tableau Bridge
The CData ODBC Driver for Outreach.io enables you to integrate live Outreach.io into Tableau Cloud dashboards using the Tableau Bridge.