CData Software - Knowledge Base
Recent Articles
-
Integrate LibreChat with Live Wistia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Wistia data from within the chat interface.
-
Migrating data from iContact to Databricks using CData SSIS Components.
Easily push iContact data to Databricks using the CData SSIS Tasks for iContact and Databricks.
-
Integrate Live Slack 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 Slack data from within the IDE.
-
Extract, Transform, and Load Microsoft Exchange Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Exchange data in Informatica PowerCenter.
-
Automated Continuous SAP BusinessObjects BI Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Amazon Redshift.
-
Analyze Smartsheet Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Smartsheet data and visualize live Smartsheet data in Infragistics Reveal.
-
Object-Relational Mapping (ORM) with HDFS Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to HDFS data into a Java-based ORM framework, Hibernate.
-
Integrate OpenCode with Live AfterShip Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live AfterShip data from within your AI coding agent.
-
Bridge SAP Fieldglass Connectivity with Apache NiFi
Access and process SAP Fieldglass data in Apache NiFi using the CData JDBC Driver.
-
Query IBM Cloud Object Storage Data through ODBC in Node.js
Use node-odbc to execute SQL queries against IBM Cloud Object Storage data from Node.js.
-
Use JayDeBeApi to access AfterShip Data in Python
Use standard Python scripting and the development environment of your choice to access live AfterShip data.
-
Access Live Quickbase Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Quickbase data from your Google Sheets.
-
Integrate Stripe Data into Power Automate Desktop using CData Connect
CData Connect for Stripe Data enables you to integrate Stripe data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for Nuclia in MicroStrategy
Connect to Nuclia data in MicroStrategy Developer using the CData Software JDBC Driver for Nuclia.
-
Integrating Dataiku with Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Vault CRM data.
-
Integrate Cline with Live Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Workday data from within your IDE.
-
Build Automated Workflows with Live SparkPost Data in Workato
Use CData Connect AI to connect to live SparkPost data and build automated workflows in Workato.
-
Access Live Mailjet Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Mailjet data through MCP integration.
-
Automated Continuous Shortcut Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Shortcut replication to AlloyDB.
-
Integrate Salesloft Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Salesloft data from Informatica Cloud.
-
Back Up Twitter Ads data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Twitter Ads. In this article, we will employ an SSIS workflow to populate a database with Twitter Ads data data.
-
Visualize Toggl Data in Sisense
Create an ElastiCube in Sisense app with access to Toggl data.
-
Create Omnisend-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Omnisend Data from OutSystems and build custom enterprise apps using live Omnisend data.
-
Automate ConvertAPI Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ConvertAPI data from PowerShell? This article demonstrates how to utilize the ConvertAPI Cmdlets for tasks like connecting to ConvertAPI data, automating operations, downloading data, and more.
-
DataBind Charts to Shortcut Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Shortcut 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.
-
Replicate Teamgate Data from PowerShell
Write a quick PowerShell script to query Teamgate data. Use connectivity to the live data to replicate Teamgate data to SQL Server.
-
Integrate Trae with Live SparkPost Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SparkPost data from within the AI-powered IDE.
-
Build a Simple VCL Application for Egnyte Data
How to build a simple VCL Application to view Egnyte data in RAD Studio using the CData ODBC Driver for Egnyte.
-
Use CData Connect AI to Access XML Data in Microsoft Power Pivot
Use CData Connect AI to connect to live XML data in the Power Pivot business intelligence tool.
-
Access Live SAP Hybris C4C Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Hybris C4C data from your Excel spreadsheets.
-
Interact with Live Highrise Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Highrise data.
-
Integrate Azure Synapse Data into Power Automate Desktop using CData Connect
CData Connect for Azure Synapse Data enables you to integrate Azure Synapse data into workflows built using Microsoft Power Automate Desktop.
-
Send Messages to a Specified Microsoft Teams Channel with CData Drivers
Learn how to load CSV files into Airtable through CData Airtable SyncCSV stored procedure in DBeaver.
-
DataBind Controls to Hugging Face Data in Delphi
DataBind to Hugging Face data in Delphi with standard data access components and controls.
-
Connect to Freshdesk from Asprova with CData Software ODBC Driver for Freshdesk
This article shows how to connect faster to Freshdesk data from Asprova.
-
Stream Cosmos DB Data into Apache Kafka Topics
Access and stream Cosmos DB data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Easily Query Productboard Data in OpenOffice Base
Connect to Productboard data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Coda Data in Google Apps Script via Connect AI
Use CData Connect AI to access Coda data in Google Apps Script.
-
Build AI Agents with Oracle 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 Oracle data through CData Connect AI.
-
Connect to Real-Time Avaza Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Avaza data in Power Apps.
-
Integrate with SFTP Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SFTP data to a JSON file on disk.
-
Build Dashboards with Browserless Data in DBxtra
Create dynamic dashboards and perform analytics based on Browserless data in DBxtra.
-
Excel Spreadsheet Automation on Pinterest Data with the QUERY Formula
Pull data from Pinterest, automate spreadsheets, and more with the QUERY formula.
-
How to Work with Oracle Sales Data in ETL Validator JDBC
Connect to Oracle Sales from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate AdRoll Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate AdRoll data to SQL Server.
-
Connect to Nuclia Data in RapidMiner
Integrate Nuclia data with standard components and data source configuration wizards in RapidMiner Studio.
-
Work with Live DocuSign Data in Power Query
Use CData Connect AI to connect to DocuSign data and work with live DocuSign data in Microsoft Power Query.
-
Integrate Codat Data in Pentaho Data Integration
Build ETL pipelines based on Codat data in the Pentaho Data Integration tool.
-
Integrate with Live Phoenix Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Phoenix from the MuleSoft Anypoint Platform to integrate live Phoenix data into custom reports and dashboards.
-
Connect to Zoho Projects Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoho Projects data.
-
Build Certinia-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Certinia Data from Zoho Analytics and import live Certinia data.
-
Building Dynamic Web Pages with HBase Data Using AngularJS
Create single-page applications with live connectivity to HBase using the CData API Server.
-
Publish Quaderno-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Quaderno data.
-
Connect to Scrapfly Data in DBArtisan
Use wizards in DBArtisan to configure Scrapfly data as a data source.
-
How to Visualize Nethunt Data in Python with pandas
Use pandas and other modules to analyze and visualize live Nethunt data in Python.
-
Build Jumpseller Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Jumpseller data and build visualizations in Tableau Cloud.
-
Automated Continuous Zoom Replication to SQLite
Use CData Sync for automated, continuous, customizable Zoom replication to SQLite.
-
Use Databricks Agent Bricks to Talk to Your Sage Cloud Accounting Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Sage Cloud Accounting data for you.
-
Connect to Zoho Projects Data from Crystal Reports
Use CData Connect AI to connect to and report on live Zoho Projects data from Crystal Reports.
-
Access Live Hive Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Hive data from your Google Sheets.
-
Access Live eBay Data in Excel 365 Online (Excel for the web)
Connect to eBay data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to QuickBooks Data in DBArtisan
Use wizards in DBArtisan to configure QuickBooks data as a data source.
-
Replicate SurveyMonkey Data from PowerShell
Write a quick PowerShell script to query SurveyMonkey data. Use connectivity to the live data to replicate SurveyMonkey data to SQL Server.
-
Operational Reporting on Elorus Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Elorus data.
-
DataBind Controls to Aha! Data in Delphi
DataBind to Aha! data in Delphi with standard data access components and controls.
-
Connect to and Query Facebook Data in QlikView over ODBC
Create data visualizations with Facebook data in QlikView.
-
Analyze Jira Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Jira data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Visualize Sage Intacct Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sage Intacct data.
-
Import Real-Time MailerSend Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MailerSend data in ColdFusion.
-
Build Sybase-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Sybase data.
-
A PostgreSQL Interface for Google Calendar Data using the CData ODBC Driver
Use the SQL Gateway and Google Calendar ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Notion Data in Google Apps Script via Connect AI
Use CData Connect AI to access Notion data in Google Apps Script.
-
Integrate Live Snowflake Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Snowflake data to Blue Prism using the CData ODBC Driver for Snowflake to create automated workflows for repetitive business tasks.
-
Bridge Azure Data Catalog Connectivity with Apache NiFi
Access and process Azure Data Catalog data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Cloudant Replication to Snowflake
Use CData Sync for automated, continuous, customizable Cloudant replication to Snowflake.
-
Import and Visualize Webex Data in Power View
Create data visualizations based on Webex data in Excel.
-
Integrate Zoho Projects Data into Power Automate Desktop using CData Connect
CData Connect for Zoho Projects Data enables you to integrate Zoho Projects data into workflows built using Microsoft Power Automate Desktop.
-
Connect to FreshBooks Data as an External Source in Dremio
Use the CData JDBC Driver to connect to FreshBooks as an External Source in Dremio.
-
Build JSON-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to JSON services and build web apps with connectivity to live JSON services.
-
Integrate CSV Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to CSV data and integrate live CSV data into your Power Automate tasks.
-
Connect to Raisers Edge NXT Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Raisers Edge NXT and the SQL Gateway to access Raisers Edge NXT data from Google Apps Script.
-
Access SingleStore Data from MySQL in Amazon QuickSight
Connect to SingleStore and build visualizations of SingleStore data using a MySQL Connection in Amazon QuickSight.
-
Build Automated Workflows with Live XML Data in Workato
Use CData Connect AI to connect to live XML data and build automated workflows in Workato.
-
Replicate Rebilly Data from PowerShell
Write a quick PowerShell script to query Rebilly data. Use connectivity to the live data to replicate Rebilly data to SQL Server.
-
LINQ to Raisers Edge NXT 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 Raisers Edge NXT Data Provider.
-
How to connect PolyBase to Bugsnag
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Bugsnag data.
-
Build Agents in Relevance AI with Access to Live MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on MongoDB data within intelligent agent workflows.
-
Getting Started with the CData ADO.NET Provider for Teamgate
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Analyze Front Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Front from Power Pivot. You will use the Table Import Wizard to load Front data. You can visually build the import query or use any SQL supported by the driver.
-
Migrating data from Wave Financial to Google BigQuery using CData SSIS Components.
Easily push Wave Financial data to Google BigQuery using the CData SSIS Tasks for Wave Financial and Google BigQuery.
-
Choosing the Best Method to Connect Workday to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Workday data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect and process Amazon S3 data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Amazon S3 data.
-
Access Live OneNote Data in Excel 365 Online (Excel for the web)
Connect to OneNote data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Azure Synapse Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Azure Synapse to connect to Azure Synapse data and execute queries in PowerBuilder.
-
Integrate Goose with Live ZohoMarketingHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ZohoMarketingHub data from within the local AI agent.
-
Build Timely-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Timely data.
-
Build AI/ML Models with Live Sybase IQ Data using Dataiku
Connect Sybase IQ Data with Dataiku using the CData JDBC Driver for Sybase IQ.
-
Consume LinkedIn Ads OData Feeds in PowerBuilder
This article demonstrates how to consume LinkedIn Ads data as OData feeds from PowerBuilder using the API Server.
-
Analyze Live Bullhorn CRM Data in SAS Viya
Use CData Connect AI to connect to Bullhorn CRM data from SAS Viya and deploy self-service analytics using live Bullhorn CRM data.
-
Query Moosend Data in ColdFusion
Write standard ColdFusion data access code to connect to Moosend data.