CData Software - Knowledge Base
Recent Articles
-
Create Power BI Reports on Real-Time Tally Data
Use the CData ODBC Driver for Tally to visualize Tally ERP in Power BI Desktop.
-
Integrate Real-Time Access to Microsoft Exchange in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Exchange in real time.
-
Access HBase 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 HBase.
-
Automated Continuous Adobe Analytics Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to IBM DB2.
-
Explore Geographical Relationships in HBase Data with Power Map
Create data visualizations with Apache HBase in Power Map.
-
Migrating data from SAP BusinessObjects BI to Google BigQuery using CData SSIS Components.
Easily push SAP BusinessObjects BI to Google BigQuery using the CData SSIS Tasks for SAP BusinessObjects BI and Google BigQuery.
-
Build MVC Applications with Connectivity to Datadog Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Datadog from an ASP.NET MVC application.
-
How to Seamlessly Import Microsoft Entra ID Data into IBM SPSS Modeler
Integrate Microsoft Entra ID data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize PagerDuty Data in Tableau
The CData ODBC driver for PagerDuty enables you integrate PagerDuty into Tableau dashboards.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Impala
Provide connectivity to Apache Impala through an SAP BusinessObjects universe.
-
Use the CData ODBC Driver for MailChimp in Microsoft Power Query
You can use the CData MailChimp ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MailChimp into Microsoft Power Query.
-
Automate Planio Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Planio from PowerShell? This article demonstrates how to utilize the Planio Cmdlets for tasks like connecting to Planio, automating operations, downloading data, and more.
-
Use Microsoft Copilot Studio to talk to your Sage 200 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 Sage 200 for you.
-
How to import RSS Feeds into Apache Solr
Use the CData Software JDBC Driver for RSS in Data Import Handler and create an automated import of RSS Feeds to Apache Solr Enterprise Search platform.
-
Integrating Cursor CLI with Mailjet 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 OpenCode Terminal with ZohoMarketingHub 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 Query Live Dynamics 365 Business Central Data in Claude Desktop
Connect to and query live Dynamics 365 Business Central Data in Claude Desktop using CData MCP Server.
-
Connect NASA to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live NASA using the CData Python MCP Server.
-
How to Connect DBeaver to ConvertKit via a JDBC Driver
Manage ConvertKit with visual tools in DBeaver like the query browser.
-
Integrating LlamaIndex with Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Highrise CRM in real time.
-
Import Real-Time Clio Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Clio in ColdFusion.
-
Publish Reports with Slack Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Slack.
-
Build Data Flows from Google Directory to SQL Server using SSIS
Easily back up Google Directory to SQL Server using the SSIS components for Google Directory.
-
Connect to Drip Data in NetBeans
Connect to Drip in NetBeans with the data source configuration wizard.
-
Create SSAS Tabular Models from Zoho Inventory Data
How to build a SQL Server Analysis Service Tabular Model from Zoho Inventory using CData drivers.
-
Automated Continuous ZohoDesk Replication to Oracle
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Oracle.
-
Create Informatica Mappings From/To a JDBC Data Source for LeadDesk
Create LeadDesk data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Working with Excel Data in LINQPad
Execute LINQ queries to Microsoft Excel in LINQPad.
-
Integrate Microsoft Teams with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Microsoft Teams with External Services.
-
Build MVC Applications with Connectivity to Microsoft Entra ID Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Microsoft Entra ID from an ASP.NET MVC application.
-
Operational Reporting on Azure Data Catalog Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Azure Data Catalog.
-
LightSpeedRetail Reporting in OBIEE with the LightSpeedRetail JDBC Driver
Deploy the LightSpeedRetail JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Dashboards with Printful Data in DBxtra
Create dynamic dashboards and perform analytics based on Printful in DBxtra.
-
Import Sugar CRM Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Sugar CRM Data and provide access to live Sugar CRM for custom reports in the Power BI Service.
-
Getting Started with the CData Excel Add-In for VWO
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for VWO.
-
Migrating data from Facebook to Snowflake using CData SSIS Components.
Easily push Facebook to Snowflake using the CData SSIS Tasks for Facebook and Snowflake.
-
Connect and Query Live Workday Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Workday into Databricks
-
Connect to Okta Data from PowerBuilder via ADO.NET
This article demonstrates how to access Okta from Appeon PowerBuilder using the CData ADO.NET Provider for Okta.
-
How to connect SharePoint with eBay Analytics Data through external lists
Provide eBay Analytics to SharePoint users as an external list.
-
Automate Mouseflow Data Replication to SAP HANA
Use CData Sync to customize and automate Mouseflow replication to SAP HANA.
-
Create Confluence-Connected Dashboards in Grafana
Connect to Confluence Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Atlassian Confluence.
-
Build an OLAP Cube in SSAS from Parquet Data
Establish a connection to Apache Parquet data from SQL Server Analysis Services, and use the Parquet Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Live SAP SuccessFactors LMS Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Driver Guide: Marketing Analytics Predefined Reports
A basic overview of CData marketing analytics connectivity, including predefined reports for easier access to data.
-
How to integrate Metabase with Oracle Sales Data
Use CData Connect AI to connect to live Oracle Sales and create an interactive dashboard in Metabase from Oracle Sales.
-
Connect SAP Ariba Source to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Ariba Source using the CData Python MCP Server.
-
Connect to GitHub from a Connection Pool in WebLogic
Use the CData JDBC Driver for GitHub to connect to GitHub from Web applications running on WebLogic.
-
Create Informatica Mappings From/To a JDBC Data Source for Deel
Create Deel data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating PagerDuty Data in Talend Cloud Data Management Platform
Connect PagerDuty Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Twilio Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Twilio replication to Google BigQuery.
-
Access Live Excel Online Data in TIBCO Data Virtualization
Use the Excel Online Tibco DV Adapter to create a Microsoft Excel Online data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Excel Online from your TDV Server.
-
Connect to JSON Services in HULFT Integrate
Connect to JSON as a JDBC data source in HULFT Integrate
-
Integrate with live Dropbox Data in Jitterbit
Use CData Connect AI to connect to and integrate live Dropbox in Jitterbit.
-
Configure the CData JDBC Driver for Quaderno in a Connection Pool in Tomcat
Connect to Quaderno from a connection pool in Tomcat.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Beeminder
Provide connectivity to Beeminder through an SAP BusinessObjects universe.
-
Access Instagram Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Instagram from your Oracle system.
-
Use the CData ODBC Driver for Zoho Books in Microsoft Power Query
You can use the CData Zoho Books ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoho Books into Microsoft Power Query.
-
Moving Data from Raisers Edge NXT to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Raisers Edge NXT data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect PolyBase to Superchat
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Superchat.
-
Create Outreach.io-Connected Dashboards in Grafana
Connect to Outreach.io Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Outreach.io.
-
Automated Continuous Elasticsearch Replication to Vertica
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Vertica.
-
DataBind ADP Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for ADP with the DevExpress Windows Forms and Web controls to provide ADP to a chart.
-
ETL Dynamics 365 in Oracle Data Integrator
This article shows how to transfer Microsoft Dynamics 365 into a data warehouse using Oracle Data Integrator.
-
Use Azure AI Foundry to Talk to Your SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAP Business ByDesign for you.
-
Connecting GenSpark with Dynamics 365 Business Central Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Dynamics 365 Business Central without any replication or custom integration required.
-
Integrate with Square Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Square in SnapLogic.
-
Design BIRT Reports on Twilio Data
Provide current Twilio to your embedded analytics.
-
Getting Started with the CData Power BI Connector for NetSuite
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for NetSuite.
-
Build Dashboards with Sendwithus Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sendwithus in Dundas BI.
-
Use Azure AI Foundry to Talk to Your MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your MYOB AccountRight for you.
-
Connect to CSV Data in JRuby
Create a simple JRuby app with access to live CSV/TSV Files.
-
Integrate Cursor with Live BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live BambooHR from within the editor.
-
Use the CData API Server to Access Amazon Athena Data in Microsoft PowerPivot
Use the CData API Server to connect to live Amazon Athena in the Power Pivot business intelligence tool.
-
Use Microsoft Copilot Studio to talk to your SAS xpt 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 SAS XPORT for you.
-
Create Apps from SharePoint Data in Qlik Sense Cloud
Use CData Connect AI to connect to SharePoint Data and build apps from live Microsoft SharePoint in Qlik Sense Cloud.
-
How to connect to Close Data from IntelliJ
Integrate connectivity to Close with wizards in IntelliJ.
-
Connect to Missive in SpagoBI
Create reports featuring live Missive in SpagoBI Studio. Host Missive reports on SpagoBI Server.
-
How to Create Power BI Visual Reports with Real-Time ServiceDesk Plus Data
Use CData Power BI Connectors to visualize ServiceDesk Plus in Power BI.
-
Visualize CapsuleCRM Data in Sisense
Create an ElastiCube in Sisense app with access to CapsuleCRM.
-
Design BIRT Reports on Todoist Data
Provide current Todoist to your embedded analytics.
-
Connect to Cloudflare Data in HULFT Integrate
Connect to Cloudflare as a JDBC data source in HULFT Integrate
-
Getting Started with the CData Excel Add-In for Autopilot
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Autopilot.
-
Add Suadeo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Suadeo with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Power BI Reports on Real-Time Microsoft OneDrive Data
Use the CData ODBC Driver for Microsoft OneDrive to visualize Microsoft OneDrive in Power BI Desktop.
-
Connect to AlloyDB Data in Claris FileMaker Pro
Use the CData ODBC Driver for AlloyDB in FileMaker Pro to connect to AlloyDB and work with Google AlloyDB in your FileMaker applications.
-
Connect to Deel Data in Ruby
Connect to Deel in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Seamlessly Bring ServiceNow Data into Retool Using CData Connect AI
Integrate ServiceNow data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Deploy the ADO.NET Provider for PabblySubscriptions on an SSRS Report Server
Connect to PabblySubscriptions 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.
-
Connect to Moosend Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Moosend to connect to Moosend and execute queries in PowerBuilder.
-
A PostgreSQL Interface for PagerDuty Data using the CData ODBC Driver
Use the SQL Gateway and PagerDuty ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Live QuickBooks Time Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Zoho Creator Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Zoho Creator through CData Connect AI using different applications and tools.
-
Query Kintone Data as a SQL Server Database in Node.js
Execute SQL Server queries against Kintone from Node.js.
-
Connect to Perigon Data from a Connection Pool in JBoss
Integrate Perigon into Java servlets: Use the Management Console in JBoss to install the Perigon JDBC Driver.
-
Visualize Yelp Data in Tableau
The CData ODBC driver for Yelp enables you integrate Yelp into Tableau dashboards.
-
Bidirectional Access to Helpscout Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Helpscout in Filemaker Pro for Mac or Windows.
-
Migrating data from MYOB AccountRight to Databricks using CData SSIS Components.
Easily push MYOB AccountRight to Databricks using the CData SSIS Tasks for MYOB AccountRight and Databricks.
-
Integrating Antigravity CLI with Amplitude via CData CLI
Connect Amplitude to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate with Zoho Inventory Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Zoho Inventory in SnapLogic.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Productboard
Provide connectivity to Productboard through an SAP BusinessObjects universe.