CData Software - Knowledge Base
Recent Articles
-
Access Live Microsoft Exchange Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft Exchange data from your Excel spreadsheets.
-
Replicate OData Services to Multiple Databases via the CData Sync CLI
Replicate OData services to disparate databases with a single configuration.
-
Automate Splunk Data Replication to SAP HANA
Use CData Sync to customize and automate Splunk data replication to SAP HANA.
-
How to Seamlessly Import Copper Data into IBM SPSS Modeler
Integrate Copper data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Office 365 Data in Excel 365 Online (Excel for the web)
Connect to Office 365 data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Rapidly Develop AfterShip-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 AfterShip.
-
Build ZohoMarketingHub-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ZohoMarketingHub data.
-
Connect to and Query EmailOctopus Data in QlikView over ODBC
Create data visualizations with EmailOctopus data in QlikView.
-
Visualize Live ClickUp Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ClickUp data.
-
How to Query Live Confluence Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Confluence data data in natural language using Python.
-
Getting Started with the CData Tableau Connector for Paylocity
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Paylocity.
-
Choosing the Best Method to Connect Browserless to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Browserless data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live API Data in Excel 365 Online (Excel for the web)
Connect to API data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Visualize Live Sugar CRM Data in the Power BI Service
Use CData Connect AI to connect to live Sugar CRM data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Egnyte-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Egnyte data.
-
Trigger SAP HANA IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAP HANA with standard wizards in Logic Apps.
-
Create Datasets from Datadog in Domo Workbench and Build Visualizations of Datadog Data in Domo
Use the CData Software ODBC Driver for Datadog to create datasets from Datadog data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate with MailChimp Data in SnapLogic
Use CData Connect AI to connect to and integrate with live MailChimp data in SnapLogic.
-
A PostgreSQL Interface for Dynamics NAV Data using the CData ODBC Driver
Use the SQL Gateway and Dynamics NAV ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Multiple Zoho Creator Accounts via the CData Sync CLI
Replicate multiple Zoho Creator accounts to one or many databases.
-
Connect to Amazon Athena Data in Aqua Data Studio
Access Amazon Athena data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData ODBC Driver for Codat from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Codat to connect to Codat data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Codat data in Excel.
-
Getting Started with the CData ADO.NET Provider for Copper
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Live Bullhorn CRM Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Bullhorn CRM in CData Connect AI and connect to your Bullhorn CRM data from PostgreSQL.
-
Build Charts with Clari Data in Clear Analytics
Create dynamic charts and perform analytics based on Clari data in Clear Analytics.
-
Building Dynamic Web Pages with HDFS Data Using AngularJS
Create single-page applications with live connectivity to HDFS using the CData API Server.
-
Use Biml to Build SSIS Tasks to Replicate Trello Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Trello data to SQL Server.
-
Integrating PDFMonkey Data in Talend Cloud Data Management Platform
Connect PDFMonkey Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Creating Sugar CRM-Connected Applications in Unqork
You can use CData Connect AI to feed Sugar CRM data to Unqork and build custom business apps.
-
Getting Started with the CData Power BI Connector for SAP Fieldglass
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Fieldglass.
-
Build MVC Applications with Connectivity to ClickTime Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ClickTime from an ASP.NET MVC application.
-
Automated Continuous MailChimp Replication to SQL Server
Use CData Sync for automated, continuous, customizable MailChimp replication to SQL Server.
-
Visualize Reckon Data in TIBCO Spotfire through ADO.NET
Integrate Reckon data into dashboards in TIBCO Spotfire.
-
Build YouTube Analytics-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live YouTube Analytics data.
-
Integrate Goose with Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Procore data from within the local AI agent.
-
Deploy the ADO.NET Provider for Microsoft OneDrive on an SSRS Report Server
Connect to Microsoft OneDrive 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 Live Facebook Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Facebook data and integrate live Facebook data into apps built in Microsoft Power Apps.
-
Integrate Live Basecamp Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Basecamp data from within the IDE.
-
Getting Started with the CData Power BI Connector for HCL Domino
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for HCL Domino.
-
Connect to Mailgun Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Mailgun data using standard SQL.
-
Integrating Boomi Agentstudio with Elasticsearch Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Elasticsearch data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to work with ADP Data in Apache Spark using SQL
Access and process ADP Data in Apache Spark using the CData Software JDBC Driver.
-
How to import Redis Data into Apache Solr
Use the CData Software JDBC Driver for Redis in Data Import Handler and create an automated import of Redis data to Apache Solr Enterprise Search platform.
-
Build QuickBooks-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live QuickBooks data without replication.
-
Build a Simple VCL Application for Office 365 Data
How to build a simple VCL Application to view Office 365 data in RAD Studio using the CData ODBC Driver for Office 365.
-
Use the CData Software ODBC Driver for ZohoDesk in MicroStrategy Desktop
Connect to ZohoDesk data in MicroStrategy Desktop using the CData Software ODBC Driver for ZohoDesk.
-
Getting Started with the CData Excel Add-In for Auth0
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Auth0.
-
Visualize Live Raisers Edge NXT Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Raisers Edge NXT data.
-
Consume SAP HANA XS Advanced OData Feeds in PowerBuilder
This article demonstrates how to consume SAP HANA XS Advanced data as OData feeds from PowerBuilder using the API Server.
-
Connect to SingleStore Data in DBeaver
Use the CData ODBC Driver to connect to SingleStore data in DBeaver.
-
Perform Batch Operations with CockroachDB Data in Apache NiFi
Connect to CockroachDB data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access AdRoll Data from MySQL in Amazon QuickSight
Connect to AdRoll and build visualizations of AdRoll data using a MySQL Connection in Amazon QuickSight.
-
Build MVC Applications with Connectivity to Access Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Access from an ASP.NET MVC application.
-
Connecting Mastra with ConstantContact Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time ConstantContact data, no replication required.
-
Visualize IBM Cloud Object Storage Data in Tableau
The CData ODBC driver for IBM Cloud Object Storage enables you integrate IBM Cloud Object Storage data into Tableau dashboards.
-
Integrate with JDBC-ODBC Bridge Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy JDBC-ODBC Bridge data to a JSON file on disk.
-
Use the CData Software JDBC Driver for Microsoft Ads in MicroStrategy Web
Connect to Microsoft Ads data in MicroStrategy Web using the CData Software JDBC Driver for Microsoft Ads.
-
Connect Discord to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Discord with IBM WebSphere for seamless data integration and connectivity.
-
Stream Presto Data into Apache Kafka Topics
Access and stream Presto data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData Tableau Connector for JotForm
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Cohere Replication to Databricks
Use CData Sync for automated, continuous, customizable Cohere replication to Databricks.
-
Back Up Sage 300 data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sage 300. In this article, we will employ an SSIS workflow to populate a database with Sage 300 data data.
-
Import Real-Time Pinecone Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Pinecone data in ColdFusion.
-
How to Connect to & Open Strava Data in Microsoft Excel
This article uses the CData ODBC driver for Strava to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Raisers Edge NXT Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Raisers Edge NXT data using standard SQL.
-
How to connect to Outlook Data with Squirrel SQL client
Connect to Outlook data and execute queries in the Squirrel SQL Client.
-
Integrate with live Greenplum Data in Jitterbit
Use CData Connect AI to connect to and integrate live Greenplum data in Jitterbit.
-
Use the CData Software JDBC Driver for CSV in MicroStrategy
Connect to CSV data in MicroStrategy Developer using the CData Software JDBC Driver for CSV.
-
Work with Live WooCommerce Data in Power Query
Use CData Connect AI to connect to WooCommerce data and work with live WooCommerce data in Microsoft Power Query.
-
Create Data Visualizations Based On Sybase IQ Data in Mode
Use CData Connect AI to connect to Sybase IQ Data from Mode and build visualizations using live Sybase IQ data.
-
Automated Continuous Apollo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Apollo replication to SingleStore.
-
Automate Wrike Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Wrike data from PowerShell? This article demonstrates how to utilize the Wrike Cmdlets for tasks like connecting to Wrike data, automating operations, downloading data, and more.
-
Integrate Goose with Live Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Asana data from within the local AI agent.
-
Connect to and Query ElevenLabs Data in QlikView over ODBC
Create data visualizations with ElevenLabs data in QlikView.
-
Analyze ConvertKit Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ConvertKit data with the CData JDBC Driver for ConvertKit.
-
Create Data Visualizations Based On Zoho Projects Data in Mode
Use CData Connect AI to connect to Zoho Projects Data from Mode and build visualizations using live Zoho Projects data.
-
Configure the CData JDBC Driver for PagerDuty in a Connection Pool in Tomcat
Connect to PagerDuty data from a connection pool in Tomcat.
-
Query Spotify Data in ColdFusion
Write standard ColdFusion data access code to connect to Spotify data.
-
Integrating GitHub Copilot with MarkLogic 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.
-
Build Certinia-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Certinia data.
-
Establish a Live Connection with Parquet Data using Tableau Bridge
The CData ODBC Driver for Parquet enables you to integrate live Parquet data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate with Microsoft Dataverse Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Dataverse data to a JSON file on disk.
-
Provide OData Services of Brex Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Brex data by developing a WCF Service Application.
-
Replicate Multiple SageHR Accounts via the CData Sync CLI
Replicate multiple SageHR accounts to one or many databases.
-
Migrating data from PostgreSQL to Snowflake using CData SSIS Components.
Easily push PostgreSQL data to Snowflake using the CData SSIS Tasks for PostgreSQL and Snowflake.
-
Work with Wave Financial Data in FoxPro
Load Wave Financial data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Consume SingleStore OData Feeds in PowerBuilder
This article demonstrates how to consume SingleStore data as OData feeds from PowerBuilder using the API Server.
-
How to Connect the Power BI Service to XML: Complete Guide
Connect to the CData Software Power BI Connector for XML from PowerBI.com to provide real-time XML data across the organization.
-
Connect to Highrise Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Highrise data.
-
Connect to ZohoMarketingHub Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ZohoMarketingHub and work with ZohoMarketingHub data in your FileMaker applications.
-
Query Zoho CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Zoho CRM data.
-
Connect to Shippo Data in JRuby
Create a simple JRuby app with access to live Shippo data.
-
Stream Freshservice Data into Apache Kafka Topics
Access and stream Freshservice data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Autopilot Data in DBeaver
Use the CData ODBC Driver to connect to Autopilot data in DBeaver.
-
Integrating GitHub Copilot with Paymo 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 Coda Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Coda data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query Act CRM Data in DataGrip
Create a Data Source for Act CRM in DataGrip and use SQL to query live Act CRM data.
-
Automated Continuous MYOB AccountRight Replication to MongoDB
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to MongoDB.
-
How to integrate Metabase with HDFS Data
Use CData Connect AI to connect to live HDFS data and create an interactive dashboard in Metabase from HDFS data.
-
How to Access Live Wrike Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Wrike enables you to integrate Wrike data into workflows built using Microsoft Power Automate Desktop.