CData Software - Knowledge Base
Recent Articles
-
Deploy the ADO.NET Provider for Phoenix on an SSRS Report Server
Connect to Apache Phoenix 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.
-
Visualize Snapchat Ads Data in Tableau
The CData ODBC driver for Snapchat Ads enables you integrate Snapchat Ads into Tableau dashboards.
-
Access Live SharePoint Excel Services Data in AWS Lambda
Connect to live SharePoint Excel Services in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Suadeo in MicroStrategy Web
Connect to Suadeo in MicroStrategy Web using the CData Software JDBC Driver for Suadeo.
-
Automated Continuous Freshservice Replication to Snowflake
Use CData Sync for automated, continuous, customizable Freshservice replication to Snowflake.
-
Import Real-Time ADP Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ADP in ColdFusion.
-
Use the CData ODBC Driver for Coinbase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Coinbase to connect to Coinbase from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Coinbase in Excel.
-
How to Build an ETL App for Datadog Data in Python with CData
Create ETL applications and real-time data pipelines for Datadog in Python with petl.
-
Getting Started with the CData ADO.NET Provider for SurveyMonkey
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SurveyMonkey.
-
Import SAP Ariba Source Data Using Azure Data Factory
Use CData Connect AI to connect to SAP Ariba Source Data from Azure Data Factory and import live SAP Ariba Source.
-
Automated Continuous Freshsales Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Freshsales replication to Google BigQuery.
-
Connect and Query Live Cvent Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Cvent into Databricks
-
How to Access Live Splunk Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Splunk enables you to integrate Splunk into workflows built using Microsoft Power Automate Desktop.
-
Access Live SharePoint Excel Services Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SharePoint Excel Services data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Accessing QuickBooks with Entity Framework 6
CData ADO.NET Providers make it easy to access data from a variety of sources. In this article we show how to access data from QuickBooks using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Prepare, Blend, and Analyze OpenWeatherMap Data in Alteryx Designer (ODBC)
Build workflows to access live OpenWeatherMap for self-service data analytics.
-
Connect to GitHub Data as an External Source in Dremio
Use the CData JDBC Driver to connect to GitHub as an External Source in Dremio.
-
Provide OData Services of Teradata Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Teradata by developing a WCF Service Application.
-
Connect to and Query Freshservice Data in QlikView over ODBC
Create data visualizations with Freshservice in QlikView.
-
Operational Reporting on WooCommerce Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote WooCommerce.
-
Build Visualizations of Salesforce Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Salesforce & Force.com in Birst.
-
Add Anaplan Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Anaplan with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Anaplan Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Anaplan and the Script function in FileMaker Pro to connect to Anaplan and work with Anaplan in your FileMaker application.
-
Viewing Pipeliner CRM Data in RAD Studio Data Explorer
How to view Pipeliner CRM in RAD Studio Data Explorer using the CData ODBC Driver for Pipeliner CRM.
-
Use the CData Software ODBC Driver for Landbot in MicroStrategy Desktop
Connect to Landbot in MicroStrategy Desktop using the CData Software ODBC Driver for Landbot.
-
Connect to Microsoft Dataverse Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft Dataverse and the SQL Gateway to access Microsoft Dataverse (CDS) from Google Apps Script.
-
Model, Search, and Visualize Live SAP Concur Data in ThoughtSpot
Use CData Connect AI to connect to live SAP Concur for modeling, searching, and visualizing.
-
Connect to Paylocity in SpagoBI
Create reports featuring live Paylocity in SpagoBI Studio. Host Paylocity reports on SpagoBI Server.
-
Bidirectional Access to Tanda Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Tanda in Filemaker Pro for Mac or Windows.
-
How to Connect Flowise AI Agents to Live Paylocity Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Paylocity without replication.
-
Build AI Agents with Gong 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 Gong through CData Connect AI.
-
Connect Spark to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Spark with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for SendInBlue in SAS for Real-Time Reporting and Analytics
Connect to real-time SendInBlue in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SendInBlue.
-
How to Access Live Oracle Financials Cloud Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Oracle Financials Cloud enables you to integrate Oracle Financials Cloud into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData SSIS Components for Discourse
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Discourse.
-
Visualize Excel Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Excel into dashboards in TIBCO Spotfire.
-
How to Build an ETL App for Acumatica Data in Python with CData Connect AI
Build ETL pipelines that read and write live Acumatica ERP in Python with petl and the CData Connect AI Python SDK.
-
How to Connect the Power BI Service to Dynamics 365 Business Central: Complete Guide
Connect to the CData Software Power BI Connector for Dynamics 365 Business Central from PowerBI.com to provide real-time Dynamics 365 Business Central across the organization.
-
Build Sugar CRM-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Sugar CRM to explore live Sugar CRM Data in GitHub Copilot to assist with building Sugar CRM-powered applications.
-
Build an OLAP Cube in SSAS from Azure Data Catalog Data
Establish a connection to Azure Data Catalog data from SQL Server Analysis Services, and use the Azure Data Catalog Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Access Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Access replication to OneLake in Microsoft Fabric.
-
Use Biml to Build SSIS Tasks to Replicate Todoist Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Todoist to SQL Server.
-
Automated Continuous Box Replication to MongoDB
Use CData Sync for automated, continuous, customizable Box replication to MongoDB.
-
Connect to PivotalTracker Data in CloverDX (formerly CloverETL)
Transfer PivotalTracker using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous MySQL Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MySQL replication to PostgreSQL.
-
How to Access Live LionDesk Data in Power Automate Desktop via ODBC
The CData ODBC Driver for LionDesk enables you to integrate LionDesk into workflows built using Microsoft Power Automate Desktop.
-
Integrating Dataiku with NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live NetSuite CRM & ERP.
-
Access Databricks Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Databricks from HeidiSQL.
-
Connect to PhantomBuster Data from a Connection Pool in Jetty
The PhantomBuster JDBC Driver supports connection pooling: This article shows how to connect faster to PhantomBuster from Web apps in Jetty.
-
Connecting Pipedream with SAP Business One Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SAP Business One data in real time.
-
Connect to BigCommerce Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for BigCommerce to connect to BigCommerce and execute queries in PowerBuilder.
-
Automated Continuous Printify Replication to SQLite
Use CData Sync for automated, continuous, customizable Printify replication to SQLite.
-
Use the CData Software JDBC Driver for Miro in MicroStrategy Desktop
Connect to Miro in MicroStrategy Desktop using the CData Software JDBC Driver for Miro.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Slack actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to Easily Query SAP Ariba Source Data in OpenOffice Base
Connect to SAP Ariba Source data in OpenOffice Base using the CData ODBC Driver for SAP Ariba Source and generate reports with live data insights.
-
Connect to Tickspot Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Tickspot as an External Source in Dremio.
-
Query AdRoll Data through ODBC in Node.js
Use node-odbc to execute SQL queries against AdRoll from Node.js.
-
Natively Connect to Postmark Data in PHP
The CData ODBC driver for Postmark enables you to create PHP applications with connectivity to Postmark. Leverage the native support for ODBC in PHP.
-
Moving Data from Google Contacts to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Contacts data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query Amazon S3 Data in ColdFusion
Write standard ColdFusion data access code to connect to Amazon S3.
-
Create Reports with EnterpriseDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date EnterpriseDB.
-
Create Informatica Mappings From/To an ODBC Data Source for Accelo
Create an ODBC connection to Accelo in Informatica and browse and transfer Accelo.
-
Automated Continuous Printful Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Printful replication to AlloyDB.
-
Connect to and Query Elasticsearch Data in QlikView over ODBC
Create data visualizations with Elasticsearch in QlikView.
-
Use ChatGPT to Talk to Your SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAP Ariba Source for you.
-
Visualize Quickbase Data in Sisense
Create an ElastiCube in Sisense app with access to Quickbase.
-
Automated Continuous Shortcut Replication to Vertica
Use CData Sync for automated, continuous, customizable Shortcut replication to Vertica.
-
Import and Visualize SendInBlue Data in Power View
Create data visualizations based on SendInBlue in Excel.
-
Build Charts with SAP HANA XS Advanced Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP HANA XS Advanced in Clear Analytics.
-
Build YouTube Analytics-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for YouTube Analytics to explore live YouTube Analytics Data in Claude Code to assist with building YouTube Analytics-powered applications.
-
Integrate OneNote Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft OneNote in the Pentaho Data Integration tool.
-
Bidirectional Access to Office 365 Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Office 365 in Filemaker Pro for Mac or Windows.
-
Access Aha! Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Aha! from your Oracle system.
-
How to connect SharePoint with ServiceNow Data through external lists
Provide ServiceNow to SharePoint users as an external list.
-
Integrating LangGraph with Zoho Books Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zoho Books within automated workflows.
-
Analyze ADP Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ADP from Power Pivot. You will use the Table Import Wizard to load ADP. You can visually build the import query or use any SQL supported by the driver.
-
Create Informatica Mappings From/To an ODBC Data Source for GraphQL
Create an ODBC connection to GraphQL in Informatica and browse and transfer GraphQL.
-
Integrating Claude Code CLI with Cvent 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.
-
Access Live FreshBooks Data in Excel 365 Online (Excel for the web)
Connect to FreshBooks from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate with Live Zoho Inventory Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Zoho Inventory from the MuleSoft Anypoint Platform to integrate live Zoho Inventory into custom reports and dashboards.
-
Access Live WordPress Data in Excel 365 Online (Excel for the web)
Connect to WordPress from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Visualizations of Parallel Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Parallel in Birst.
-
Build Charts with SAP Business Warehouse Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Business Warehouse in Clear Analytics.
-
Build Kintone-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Kintone and build web apps with connectivity to live Kintone.
-
Integrating Codex CLI with JSON 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.
-
Prepare, Blend, and Analyze Invoiced Data in Alteryx Designer (ODBC)
Build workflows to access live Invoiced for self-service data analytics.
-
Access Splunk Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Splunk from your Oracle system.
-
Build an OLAP Cube in SSAS from BenchmarkEmail Data
Establish a connection to BenchmarkEmail data from SQL Server Analysis Services, and use the BenchmarkEmail Data Provider to build OLAP cubes for use in analytics and reporting.
-
Operational Reporting on PingOne Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PingOne.
-
Visualize Freshdesk Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Freshdesk.
-
Access Live Pipedrive Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Pipedrive through MCP integration.
-
Connect to Brex Data in NetBeans
Connect to Brex in NetBeans with the data source configuration wizard.
-
How to Connect to Live Greenhouse Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Greenhouse for you.
-
Add Opsgenie Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Opsgenie with the Informatica Enterprise Data Catalog to classify and organize data.
-
Visualize Microsoft Exchange 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 Microsoft Exchange into TIBCO Spotfire.
-
DataBind Controls to PDFMonkey Data in C++Builder
DataBind to PDFMonkey in C++Builder with standard components and controls.
-
Getting Started with the CData ODBC Driver for XML
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for XML.
-
Build AI/ML Models with Live Gmail Data using Dataiku
Connect Gmail Data with Dataiku using the CData JDBC Driver for Gmail.
-
Build Semantic Layer Views for Twilio Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Twilio.
-
Choosing the Best Method to Connect Figshare to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Figshare from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.