CData Software - Knowledge Base
Recent Articles
-
Connect to Timely Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Timely using standard SQL.
-
Create Blackbaud FE NXT-Connected Nintex Workflows
Use CData Connect AI to connect to Blackbaud FE NXT Data from Nintex Workflow Cloud and build custom workflows using live Blackbaud FE NXT.
-
Connect to Demio in SpagoBI
Create reports featuring live Demio in SpagoBI Studio. Host Demio reports on SpagoBI Server.
-
Analyze Sybase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sybase with the CData JDBC Driver for Sybase.
-
Use the CData Software JDBC Driver for Paylocity in MicroStrategy Desktop
Connect to Paylocity in MicroStrategy Desktop using the CData Software JDBC Driver for Paylocity.
-
Connect to Scrapfly Data in HULFT Integrate
Connect to Scrapfly as a JDBC data source in HULFT Integrate
-
Connect to Instagram Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Instagram as an External Source in Dremio.
-
Moving Data from Dynamics 365 Business Central to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Dynamics 365 Business Central data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze Instagram Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Instagram in Microsoft R Open.
-
Connect to ClickUp Data in RapidMiner
Integrate ClickUp with standard components and data source configuration wizards in RapidMiner Studio.
-
Design BIRT Reports on Amplitude Data
Provide current Amplitude to your embedded analytics.
-
Analyze Vault CRM Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Veeva Vault & Vault CRM and visualize live Veeva Vault & Vault CRM in Infragistics Reveal.
-
Build Automated Workflows with Live Sage Cloud Accounting Data in Workato
Use CData Connect AI to connect to live Sage Business Cloud Accounting and build automated workflows in Workato.
-
Build Dashboards with Mode Data in Dundas BI
Create dynamic dashboards and perform analytics based on Mode in Dundas BI.
-
Viewing Basecamp Data in RAD Studio Data Explorer
How to view Basecamp in RAD Studio Data Explorer using the CData ODBC Driver for Basecamp.
-
Getting Started with the CData SSIS Components for Adobe Target
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Adobe Target.
-
Import Trello Data Using Azure Data Factory
Use CData Connect AI to connect to Trello Data from Azure Data Factory and import live Trello.
-
Trigger MarkLogic IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for MarkLogic with standard wizards in Logic Apps.
-
Use Claude to Talk to Your OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft OneNote for you.
-
Connect to EmailOctopus Data in HULFT Integrate
Connect to EmailOctopus as a JDBC data source in HULFT Integrate
-
How to Connect to Live SAP BusinessObjects BI Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your SAP BusinessObjects BI for you.
-
Build JSON-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for JSON Services and create custom apps in Bubble.
-
Connect to and Query Parquet Data in QlikView over ODBC
Create data visualizations with Apache Parquet in QlikView.
-
Getting Started with the CData SSIS Components for Bitbucket
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bitbucket.
-
Viewing Amplitude Data in RAD Studio Data Explorer
How to view Amplitude in RAD Studio Data Explorer using the CData ODBC Driver for Amplitude.
-
Create Dashboards and Visualize Live Asana Data in Geckoboard
Use CData Connect AI to connect to live Asana and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create PostgreSQL-Connected Dashboards in Grafana
Connect to PostgreSQL Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to PostgreSQL.
-
Build AI/ML Models with Live Quickbase Data using Dataiku
Connect Quickbase Data with Dataiku using the CData JDBC Driver for Quickbase.
-
Feed MySQL Data into FineReport
How to set MySQL as a JDBC data source in FineReport.
-
Build Voice Agents in ElevenLabs with access to Live MarkLogic Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live MarkLogic.
-
Create Dynamic Cvent Grids Using the Infragistics XamDataGrid
Learn how you can connect Cvent to Infragistics XamDataGrid to build dynamic grids.
-
Provide OData Services of Google Forms Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Forms by developing a WCF Service Application.
-
Import Cloudant Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Cloudant Data and provide access to live IBM Cloudant for custom reports in the Power BI Service.
-
Use the CData ODBC Driver for Google Contacts from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Contacts to connect to Google Contacts from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Contacts in Excel.
-
Visualize ZendeskSell 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 ZendeskSell into TIBCO Spotfire.
-
Connect to Microsoft Entra ID Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Entra ID in the Denodo Virtual DataPort Administrator.
-
Build Data Flows from SQL Server to Facebook through SSIS
Easily push SQL Server data to Facebook using the CData SSIS Tasks for Facebook.
-
Getting Started with the CData ADO.NET Provider for Cosmos DB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Cosmos DB.
-
Build Semantic Layer Views for Customer.io Data in APOS Live Data Gateway
Use the CData Connector for Customer.io in APOS Live Data Gateway to build Semantic Layer Views for Customer.io.
-
Model OData Services Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and OData, enabling the direct import of real-time OData.
-
Use the CData Software ODBC Driver for Printful in MicroStrategy
Connect to Printful in MicroStrategy Developer using the CData Software ODBC Driver for Printful.
-
Start with CData Sync Part 2: Customizing Replications
Use CData Sync to customize replications.
-
Create Power BI Reports on Real-Time Paylocity Data
Use the CData ODBC Driver for Paylocity to visualize Paylocity in Power BI Desktop.
-
Query Freshdesk Data in DataGrip
Create a Data Source for Freshdesk in DataGrip and use SQL to query live Freshdesk.
-
Replicate Attio Data to Multiple Databases
Replicate Attio to disparate databases with a point-and-click configuration.
-
Build Semantic Layer Views for Zendesk Data in APOS Live Data Gateway
Use the CData Connector for Zendesk in APOS Live Data Gateway to build Semantic Layer Views for Zendesk.
-
Access Live Google Forms Data in Coginiti Pro
Connect to and query live Google Forms from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate MariaDB Data from PowerShell
Write a quick PowerShell script to query MariaDB. Use connectivity to the live data to replicate MariaDB to SQL Server.
-
Connect to Procore Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Procore and work with Procore in your FileMaker applications.
-
Create Azure Synapse Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Azure Synapse from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Apps from Adobe Analytics Data in Qlik Sense Cloud
Use CData Connect AI to connect to Adobe Analytics Data and build apps from live Adobe Analytics in Qlik Sense Cloud.
-
Build Data Flows from SharePoint Excel Services to SQL Server using SSIS
Easily back up SharePoint Excel Services to SQL Server using the SSIS components for SharePoint Excel Services.
-
Integrate Open WebUI with Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live HubSpot from within the chat interface.
-
Build Semantic Layer Views for SAP Ariba Source Data in APOS Live Data Gateway
Use the CData Connector for SAP Ariba Source in APOS Live Data Gateway to build Semantic Layer Views for SAP Ariba Source.
-
How to Build an ETL App for Vertica Data in Python with CData Connect AI
Build ETL pipelines that read and write live Vertica in Python with petl and the CData Connect AI Python SDK.
-
How to Create Power BI Visual Reports with Real-Time Marketo Data
Use CData Power BI Connectors to visualize Marketo in Power BI.
-
Access Live SAS xpt Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAS XPORT into the statistical analysis tools available in SAS JMP. This article shows how to use SAS XPORT in the Graph Builder and Query Builder.
-
Connect to SQL Analysis Services Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SQL Analysis Services in Airbyte.
-
Automated Continuous Microsoft OneLake Replication to Oracle
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Oracle.
-
Automated Continuous Supabase Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Supabase replication to delimited files (CSV/TSV).
-
Integrating Claude Code CLI with Spotify 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 to Apollo Data in NetBeans
Connect to Apollo in NetBeans with the data source configuration wizard.
-
Automated Continuous XML Replication to MySQL
Use CData Sync for automated, continuous, customizable XML replication to MySQL.
-
How to connect and process Pinecone from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pinecone.
-
Extract, Transform, and Load Basecamp Data in Informatica PowerCenter
Create a simple Workflow for Basecamp in Informatica PowerCenter.
-
DataBind Controls to Excel Data in C++Builder
DataBind to Microsoft Excel in C++Builder with standard components and controls.
-
Build Semantic Layer Views for Outlook Data in APOS Live Data Gateway
Use the CData Connector for Outlook in APOS Live Data Gateway to build Semantic Layer Views for Outlook.
-
Viewing NetSuite Data in RAD Studio Data Explorer
How to view NetSuite CRM & ERP in RAD Studio Data Explorer using the CData ODBC Driver for NetSuite.
-
Migrating data from AdRoll to Databricks using CData SSIS Components.
Easily push AdRoll to Databricks using the CData SSIS Tasks for AdRoll and Databricks.
-
Access Live Amazon S3 Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon S3 from your Google Sheets.
-
Prepare, Blend, and Analyze Datadog Data in Alteryx Designer (ODBC)
Build workflows to access live Datadog for self-service data analytics.
-
Build Dashboards with Spark Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apache Spark SQL in Dundas BI.
-
How to Easily Query CouchDB Data in OpenOffice Base
Connect to CouchDB data in OpenOffice Base using the CData ODBC Driver for CouchDB and generate reports with live data insights.
-
Automate HelloSign Data Replication to Azure Synapse
Use CData Sync to customize and automate HelloSign replication to Azure Synapse.
-
Connect and Visualize Live Dropbox Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Dropbox into the Databricks platform and create visualization dashboards with real-time Dropbox.
-
Import Excel Online Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Excel Online Data and provide access to live Microsoft Excel Online for custom reports in the Power BI Service.
-
Build Google Ads-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Ads Data from Zoho Analytics and import live Google Ads.
-
Build Semantic Layer Views for Hacker News Data in APOS Live Data Gateway
Use the CData Connector for Hacker News in APOS Live Data Gateway to build Semantic Layer Views for Hacker News.
-
Access Live Apollo Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Apollo from your Excel spreadsheets.
-
Create SAP SuccessFactors LMS Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP SuccessFactors LMS from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Avaza Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Avaza data access from reports, embedded analytics, and more.
-
Create Apps from Paylocity Data in Qlik Sense Cloud
Use CData Connect AI to connect to Paylocity Data and build apps from live Paylocity in Qlik Sense Cloud.
-
Connecting Mastra with SendGrid 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 SendGrid, no replication required.
-
Working with HBase Data in LINQPad
Execute LINQ queries to Apache HBase in LINQPad.
-
Migrating data from Microsoft Teams to Databricks using CData SSIS Components.
Easily push Microsoft Teams to Databricks using the CData SSIS Tasks for Microsoft Teams and Databricks.
-
Build Reckon-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Reckon to explore live Reckon Data in Cursor to assist with building Reckon-powered applications.
-
Connect to Kintone Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Kintone and the Script function in FileMaker Pro to connect to Kintone and work with Kintone in your FileMaker application.
-
Getting Started with the CData JDBC Driver for JotForm
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for JotForm.
-
Use the CData Software ODBC Driver for Autopilot in SAS for Real-Time Reporting and Analytics
Connect to real-time Autopilot in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Autopilot.
-
Create Data Visualizations in Cognos BI with Customer.io Data
Access Customer.io as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live SurveyMonkey Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SurveyMonkey in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Pipelines with Live Email Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Email from Google Cloud Data Fusion, enabling the integration of live Email into the building and management of effective data pipelines.
-
Replicate Multiple Avalara AvaTax Accounts via the CData Sync CLI
Replicate multiple Avalara AvaTax accounts to one or many databases.
-
Integrate Live IBM Cloud Object Storage Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live IBM Cloud Object Storage to Blue Prism using the CData ODBC Driver for IBM Cloud Object Storage to create automated workflows for repetitive business tasks.
-
Automate Azure Table Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure Table Storage from PowerShell? This article demonstrates how to utilize the Azure Table Cmdlets for tasks like connecting to Azure Table Storage, automating operations, downloading data, and more.
-
Build Confluence-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Confluence to explore live Confluence Data in Claude Code to assist with building Confluence-powered applications.
-
Connect to Google Cloud Storage Data in Aqua Data Studio
Access Google Cloud Storage from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query Gong Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Gong from Node.js.
-
Create Dashboards and Visualize Live Facebook Ads Data in Geckoboard
Use CData Connect AI to connect to live Facebook Ads and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Informatica Mappings From/To a JDBC Data Source for Unbounce
Create Unbounce data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.