CData Software - Knowledge Base
Recent Articles
-
Build Raisers Edge NXT Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Raisers Edge NXT data and build visualizations in Tableau.
-
LINQ to Egnyte 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 Egnyte Data Provider.
-
Connect to EmailOctopus Data in RazorSQL
Connect to EmailOctopus from wizards and query EmailOctopus data from the GUI in the RazorSQL database management tool.
-
Replicate Multiple Aha! Accounts via the CData Sync CLI
Replicate multiple Aha! accounts to one or many databases.
-
Getting Started with the CData Power BI Connector for Todoist
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
View Reports on Real-Time Oracle Sales Data in Power BI Report Server
Use the CData ODBC Driver for Oracle Sales to visualize Oracle Sales data in Power BI Desktop and then publish them to Power BI Report Server.
-
HDFS Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on HDFS facts in real time.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Parallel
Provide connectivity to Parallel data through an SAP BusinessObjects universe.
-
Analyze Lakebase Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Lakebase data in Microsoft R Open.
-
Build Google Spanner Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Spanner data and build visualizations in Tableau Cloud.
-
Integrate LightSpeedRetail with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate LightSpeedRetail with External Services.
-
Write a Simple Go Application to work with ConvertAPI Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ConvertAPI data.
-
Visualize NetSuite Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load NetSuite data into TIBCO Spotfire.
-
Build MVC Applications with Connectivity to Chargebee Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Chargebee from an ASP.NET MVC application.
-
Automated Continuous Cloudflare Replication to Vertica
Use CData Sync for automated, continuous, customizable Cloudflare replication to Vertica.
-
Analyze Webflow Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Webflow data in Microsoft R Open.
-
Analyze Acumatica Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Acumatica data with the CData JDBC Driver for Acumatica.
-
Automated Zoho Creator Data Replication to Teradata
Use CData Sync to Customize and automate Zoho Creator data replication to Teradata.
-
Integrating Cursor with Factorial 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 Live Kafka Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Kafka data through natural language.
-
Getting Started with the CData Tableau Connector for MessageBird
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate with Marketo Data in JReport Designer
Create charts and reports based on Marketo data in JReport Designer.
-
Use Azure AI Foundry to Talk to Your Google Campaign Manager 360 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 Google Campaign Manager 360 data for you.
-
How to Work with Amazon DynamoDB Data in ETL Validator JDBC
Connect to Amazon DynamoDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to SAP Concur in SpagoBI
Create reports featuring live SAP Concur data in SpagoBI Studio. Host SAP Concur reports on SpagoBI Server.
-
Rapidly Develop Dynamics 365-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Dynamics 365.
-
Integrate with Live xBase Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to xBase from the MuleSoft Anypoint Platform to integrate live xBase data into custom reports and dashboards.
-
Bind Live Salesloft Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Salesloft data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to BigQuery Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for BigQuery and the Script function in FileMaker Pro to connect to BigQuery and work with BigQuery data in your FileMaker application.
-
Access Hubstaff Data from MySQL in Amazon QuickSight
Connect to Hubstaff and build visualizations of Hubstaff data using a MySQL Connection in Amazon QuickSight.
-
Build Semantic Layer Views for Spark Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Spark data.
-
Visualize Dynamics 365 Business Central Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Dynamics 365 Business Central data into TIBCO Spotfire.
-
How to load Recurly data into Elasticsearch via Logstash
Introducing a simple method to load Recurly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Publish Crystal Reports on Testmonitor Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Testmonitor data.
-
How to connect to Airtable Data from Spring Boot
Connect to Airtable in a Spring Boot Application using the CData JDBC Driver for Airtable
-
Bidirectional Access to Acumatica Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Acumatica data in Filemaker Pro for Mac or Windows.
-
Integrate Goose with Live SAP HANA XS Advanced Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP HANA XS Advanced data from within the local AI agent.
-
Connect to Dynamics 365 Business Central Data in ACL Analytics
Connect to Dynamics 365 Business Central data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Dynamics 365 Business Central data.
-
Visualize Pipeliner CRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pipeliner CRM data.
-
How to Connect to Live Zoho Inventory 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 Zoho Inventory data without replication.
-
Publish SendPulse-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SendPulse data.
-
DataBind Controls to EnterpriseDB Data in C++Builder
DataBind to EnterpriseDB data in C++Builder with standard components and controls.
-
Connect to Real-Time Webflow Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Webflow data in Power Apps.
-
Query Oracle HCM Cloud Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle HCM Cloud data from Node.js.
-
Integrating SingleStore Data in Talend Cloud Data Management Platform
Connect SingleStore Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SingleStore.
-
Create Data Visualizations in Cognos BI with SAS Data Sets Data
Access SAS Data Sets data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Amazon Athena Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon Athena data from your Google Sheets.
-
Search External Klipfolio Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Klipfolio data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Klipfolio Data objects that you can access from apps and the dashboard.
-
How to Connect DBeaver to Oracle Service Cloud via a JDBC Driver
Manage Oracle Service Cloud data with visual tools in DBeaver like the query browser.
-
Visualize Adobe Target Data in TIBCO Spotfire through ADO.NET
Integrate Adobe Target data into dashboards in TIBCO Spotfire.
-
Bind Live Google Directory Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Directory data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to load SAP Fieldglass data into Elasticsearch via Logstash
Introducing a simple method to load SAP Fieldglass data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live PingOne Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your PingOne data for you.
-
Integrate Devin with Live Dropbox 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 Dropbox data.
-
Automated Continuous Auth0 Replication to SQL Server
Use CData Sync for automated, continuous, customizable Auth0 replication to SQL Server.
-
Access Todoist Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Todoist data from your Oracle system.
-
How to Connect to Live Microsoft Dataverse Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Microsoft Dataverse data through natural language.
-
Connect to SAP Fieldglass Data in RapidMiner
Integrate SAP Fieldglass data with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate SpaceX Data from PowerShell
Write a quick PowerShell script to query SpaceX data. Use connectivity to the live data to replicate SpaceX data to SQL Server.
-
Automated Continuous JobNimbus Replication to Amazon S3
Use CData Sync for automated, continuous, customizable JobNimbus replication to Amazon S3.
-
How to connect to LaunchDarkly Data from IntelliJ
Integrate connectivity to LaunchDarkly data with wizards in IntelliJ.
-
Connect to OData in SpagoBI
Create reports featuring live OData services in SpagoBI Studio. Host OData reports on SpagoBI Server.
-
Getting Started with the CData ADO.NET Provider for Zoho Inventory
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Zoho Inventory.
-
Integrate Intercom Data in the Pentaho Report Designer
Publish reports based on Intercom data in the Pentaho BI tool.
-
Integrate LibreChat with Live Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Azure Data Catalog data from within the chat interface.
-
Build Semantic Layer Views for HCL Domino Data in APOS Live Data Gateway
Use the CData Connector for HCL Domino in APOS Live Data Gateway to build Semantic Layer Views for HCL Domino data.
-
Connect to Exa Data in DBeaver
Use the CData ODBC Driver to connect to Exa data in DBeaver.
-
Choosing the Best Method to Connect Perplexity to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Perplexity data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Dashboards with Dynamics CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Dynamics CRM data in DBxtra.
-
Integrate Live EnterpriseDB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live EnterpriseDB data to Blue Prism using the CData ODBC Driver for EnterpriseDB to create automated workflows for repetitive business tasks.
-
Connect to Attio Data in Ruby
Connect to Attio data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Sugar CRM Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sugar CRM data and integrate live Sugar CRM data into your Power Automate tasks.
-
Analyze QuickBooks Online Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of QuickBooks Online data and visualize QuickBooks Online data in SAP Analytics Cloud.
-
Connect to HBase Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for HBase Data and connect to HBase data in Akorbi Digital RunMyProcess.
-
Create Data Visualizations Based On GetResponse Data in Mode
Use CData Connect AI to connect to GetResponse Data from Mode and build visualizations using live GetResponse data.
-
How to import SageHR Data into Apache Solr
Use the CData Software JDBC Driver for SageHR in Data Import Handler and create an automated import of SageHR data to Apache Solr Enterprise Search platform.
-
Manage Zoho CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoho CRM.
-
How to Connect to Contentful Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Contentful data. Leverage the pyodbc module for ODBC in Python.
-
Connect to BigCommerce Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live BigCommerce data.
-
DataBind Grafana Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Grafana data to a chart.
-
Analyze Samanage Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Samanage from Power Pivot. You will use the Table Import Wizard to load Samanage data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to SurveyMonkey Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SurveyMonkey Data and connect to SurveyMonkey data in Akorbi Digital RunMyProcess.
-
Create Data Visualizations in Cognos BI with Workday Data
Access Workday data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
DataBind Charts to Oracle SCM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle SCM data 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.
-
Getting Started with the CData Python Connector for FormSite
Learn to install and license the CData Python Connector and configure a connection to live FormSite data.
-
Integrate Invoiced with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Invoiced with External Services.
-
Integrating OpenCode with PhantomBuster 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 Manus AI to Talk to Your Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Databricks data.
-
Viewing Asana Data in RAD Studio Data Explorer
How to view Asana data in RAD Studio Data Explorer using the CData ODBC Driver for Asana.
-
Use the CData Software JDBC Driver for EmailOctopus in MicroStrategy Desktop
Connect to EmailOctopus data in MicroStrategy Desktop using the CData Software JDBC Driver for EmailOctopus.
-
Bind Live Amazon Athena Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Amazon Athena data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrate with Raisers Edge NXT Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Raisers Edge NXT data to a JSON file on disk.
-
DataBind Charts to Excel Online Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Excel Online data 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.
-
Prepare, Blend, and Analyze CSV Data in Alteryx Designer (Connect AI)
Build workflows to access live CSV data for self-service data analytics.
-
Write a Simple Go Application to work with Freshservice Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Freshservice data.
-
Query Act-On Data in DataGrip
Create a Data Source for Act-On in DataGrip and use SQL to query live Act-On data.
-
Build Perplexity-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Perplexity Data and create custom apps in Mendix.
-
Build dashboards that aggregate data from NetSuite and Dynamics CRM using Qlik Sense
Create dashboards to monitor NetSuite saved searches alongside Dynamics CRM.
-
Create a Data Access Object for QuickBooks Data using JDBI
A brief overview of creating a SQL Object API for QuickBooks data in JDBI.
-
Automated Continuous RabbitMQ Replication to MySQL
Use CData Sync for automated, continuous, customizable RabbitMQ replication to MySQL.