CData Software - Knowledge Base
Recent Articles
-
Use Microsoft Copilot Studio to talk to your Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Azure Data Lake Storage data for you.
-
Add Bannerbear Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Bannerbear with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating LangChain with API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on API data within automated workflows.
-
Build Dashboards with Nuclia Data in Dundas BI
Create dynamic dashboards and perform analytics based on Nuclia data in Dundas BI.
-
Query ZohoMarketingHub Data in DataGrip
Create a Data Source for ZohoMarketingHub in DataGrip and use SQL to query live ZohoMarketingHub data.
-
Use CData Connect AI to Access Elasticsearch Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Elasticsearch data in the Power Pivot business intelligence tool.
-
Connect to FHIR Data in CloverDX (formerly CloverETL)
Transfer FHIR data using the visual workflow in the CloverDX data integration tool.
-
Connect to MessageBird Data in Aqua Data Studio
Access MessageBird data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Design BIRT Reports on Oracle Service Cloud Data
Provide current Oracle Service Cloud data to your embedded analytics.
-
Query FTP Data in ColdFusion
Write standard ColdFusion data access code to connect to FTP data.
-
Build SAP HANA-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP HANA data and build web apps with connectivity to live SAP HANA data.
-
How to Connect to Live SAP Business Warehouse Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Business Warehouse data securely in real time.
-
Natively Connect to FTP Data in PHP
The CData ODBC driver for FTP enables you to create PHP applications with connectivity to FTP data. Leverage the native support for ODBC in PHP.
-
Connect to Campaigner Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Campaigner data.
-
Getting Started with the CData ODBC Driver for Procore
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Procore.
-
Choosing the Best Method to Connect Salesforce to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Salesforce data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Dash to Build Web Apps on Zoho Creator Data via CData Connect AI
Build interactive Dash web apps on live Zoho Creator data using pandas and the CData Connect AI Python SDK.
-
How to connect to Redis Data from Spring Boot
Connect to Redis in a Spring Boot Application using the CData JDBC Driver for Redis
-
Integrate Live Salesforce CRM Analytics Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Salesforce CRM Analytics data and integrate live Salesforce CRM Analytics data into apps built in Microsoft Power Apps.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP HANA XS Advanced
Provide connectivity to SAP HANA XS Advanced data through an SAP BusinessObjects universe.
-
Integrate LibreChat with Live Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Office 365 data from within the chat interface.
-
Establish a Live Connection with PayPal Data using Tableau Bridge
The CData ODBC Driver for PayPal enables you to integrate live PayPal data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Access Live Yelp Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Yelp enables you to integrate Yelp data into workflows built using Microsoft Power Automate Desktop.
-
Moving Data from Azure Data Catalog to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Azure Data Catalog data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Dynamic Pushbullet Grids Using the Infragistics XamDataGrid
Learn how you can connect Pushbullet to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Vimeo Data in Aqua Data Studio
Access Vimeo data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Access Vimeo Data Using Entity Framework
This article shows how to access Vimeo data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize Simplesat Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Simplesat data.
-
Connect to Twilio Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Twilio data in the Denodo Virtual DataPort Administrator.
-
Import Real-Time Optimizely Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Optimizely data in ColdFusion.
-
Access Dotmailer Data from MySQL in Amazon QuickSight
Connect to Dotmailer and build visualizations of Dotmailer data using a MySQL Connection in Amazon QuickSight.
-
Use Manus AI to Talk to Your Dynamics 365 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 Dynamics 365 data.
-
Connect to Real-Time ServiceNow Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for ServiceNow and Dataflow to import and use ServiceNow data in Power Apps.
-
How to connect Amazon QuickSight to Epicor Kinetic Data
Create a connection to Epicor Kinetic data in CData Connect AI and insert Epicor Kinetic data into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize Live Trello Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Trello data.
-
Integrate Real-Time Access to Acumatica in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Acumatica data in real time.
-
DataBind ZohoMarketingHub Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZohoMarketingHub data to a chart.
-
Create Power BI Reports on Real-Time Email Data
Use the CData ODBC Driver for Email to visualize Email data in Power BI Desktop.
-
Integrating Claude Code CLI with Pinecone 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 the CData Software JDBC Driver for Telegram in MicroStrategy Web
Connect to Telegram data in MicroStrategy Web using the CData Software JDBC Driver for Telegram.
-
Build Apps with Live Excel Online Data Using the Low-Code Development Platform of Mendix
Connect Excel Online data with Mendix to build apps using the CData JDBC Driver for Excel Online.
-
Getting Started with the CData Power BI Connector for ConvertAPI
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrate Reckon Accounts Hosted Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Reckon Accounts Hosted data from Informatica Cloud.
-
Automate Basecamp Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Basecamp data from PowerShell? This article demonstrates how to utilize the Basecamp Cmdlets for tasks like connecting to Basecamp data, automating operations, downloading data, and more.
-
Use CData Connect AI to Access SageHR Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SageHR data in the Power Pivot business intelligence tool.
-
Integrate with Live Salesforce Pardot Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Salesforce Pardot from the MuleSoft Anypoint Platform to integrate live Salesforce Pardot data into custom reports and dashboards.
-
Access Live BambooHR Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to BambooHR data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Dashboards with Slack Data in Dundas BI
Create dynamic dashboards and perform analytics based on Slack data in Dundas BI.
-
Use Biml to Build SSIS Tasks to Replicate ServiceDesk Plus Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ServiceDesk Plus data to SQL Server.
-
Integrate Redis Data in the Pentaho Report Designer
Publish reports based on Redis data in the Pentaho BI tool.
-
Working with Box Data in LINQPad
Execute LINQ queries to Box data in LINQPad.
-
Publish Reports with Google Cloud Storage Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Cloud Storage data.
-
Integrate ConvertKit Data in Pentaho Data Integration
Build ETL pipelines based on ConvertKit data in the Pentaho Data Integration tool.
-
Visualize JSON Services from Tableau
Use the Tableau Desktop business intelligence tool to connect to JSON services.
-
Replicate Splunk Data in Heroku for Use in Salesforce Connect
Replicate Splunk data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Query Presto Data in MySQL Workbench
Execute MySQL queries against live Presto data from MySQL Workbench.
-
Build a PostgreSQL Interface for Pinecone Data using the CData JDBC Driver
Use the Remoting features of the Pinecone JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SurveyMonkey Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SurveyMonkey data.
-
Link Front with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Front data in Filemaker Pro for Mac or Windows.
-
Use the CData Software JDBC Driver for JotForm in MicroStrategy
Connect to JotForm data in MicroStrategy Developer using the CData Software JDBC Driver for JotForm.
-
Build Semantic Layer Views for QuickBooks Time Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for QuickBooks Time data.
-
Automated Continuous Hubstaff Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Hubstaff replication to Google BigQuery.
-
Build Dashboards with Unbounce Data in DBxtra
Create dynamic dashboards and perform analytics based on Unbounce data in DBxtra.
-
Creating Salesforce-Connected Applications in Unqork
You can use CData Connect AI to feed Salesforce data to Unqork and build custom business apps.
-
Automated Continuous ChartMogul Replication to MongoDB
Use CData Sync for automated, continuous, customizable ChartMogul replication to MongoDB.
-
Integrate LibreChat with Live Optimizely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Optimizely data from within the chat interface.
-
Enable the LinkedIn Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with LinkedIn Ads data.
-
How to Connect DBeaver to Postmark via a JDBC Driver
Manage Postmark data with visual tools in DBeaver like the query browser.
-
Object-Relational Mapping (ORM) with SpaceX 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 SpaceX data into a Java-based ORM framework, Hibernate.
-
Visualize Aircall 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 Aircall data into TIBCO Spotfire.
-
LINQ to Adobe Commerce 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 Adobe Commerce Data Provider.
-
Create Apps from eBay Data in Qlik Sense Cloud
Use CData Connect AI to connect to eBay Data and build apps from live eBay data in Qlik Sense Cloud.
-
How to Connect Exact Online Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Exact Online data in real time using natural language.
-
Connect to LightSpeedRetail Data in NetBeans
Connect to LightSpeedRetail data in NetBeans with the data source configuration wizard.
-
Use the CData Software ODBC Driver for Epicor Kinetic in MicroStrategy Desktop
Connect to Epicor Kinetic data in MicroStrategy Desktop using the CData Software ODBC Driver for Epicor Kinetic.
-
Access Couchbase Data from MySQL in Amazon QuickSight
Connect to Couchbase and build visualizations of Couchbase data using a MySQL Connection in Amazon QuickSight.
-
Connect to Oracle HCM Cloud Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle HCM Cloud data.
-
How to connect PolyBase to Tickspot
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Tickspot data.
-
Getting Started with the CData ODBC Driver for PingOne
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for PingOne.
-
Enable the Printful JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Printful data.
-
Establish a Live Connection with SpaceX Data using Tableau Bridge
The CData ODBC Driver for SpaceX enables you to integrate live SpaceX data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to OData Services in DBeaver
Use the CData ODBC Driver to connect to OData services in DBeaver.
-
Design BIRT Reports on Google Ads Data
Provide current Google Ads data to your embedded analytics.
-
Automate Superchat Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Superchat data from PowerShell? This article demonstrates how to utilize the Superchat Cmdlets for tasks like connecting to Superchat data, automating operations, downloading data, and more.
-
Publish Cloudflare-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Cloudflare data.
-
Provide OData Services of RSS Feeds from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for RSS feeds by developing a WCF Service Application.
-
Getting Started with the CData Python Connector for Procore
Learn to install and license the CData Python Connector and configure a connection to live Procore data.
-
Use the CData Software ODBC Driver for SAP Business Warehouse in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Business Warehouse data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Business Warehouse.
-
Integrate Goose with Live Jumpseller Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Jumpseller data from within the local AI agent.
-
Extract, Transform, and Load Oracle Financials Cloud Data in Informatica PowerCenter
Create a simple Workflow for Oracle Financials Cloud data in Informatica PowerCenter.
-
Connect to Basecamp Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Basecamp data.
-
Visualize Azure Data Lake Storage 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 Azure Data Lake Storage data into TIBCO Spotfire.
-
How to Use a Microsoft Access Database to Update Google Campaign Manager 360 Data in Real Time
Update Google Campaign Manager 360 data by creating a linked table in Microsoft Access with the CData Google Campaign Manager 360 ODBC Driver.
-
Connect to ActiveCampaign Data from PowerBuilder via JDBC
This article demonstrates how to access ActiveCampaign data from PowerBuilder using the ActiveCampaign JDBC Driver.
-
Access Live Parquet Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Parquet data into the statistical analysis tools available in SAS JMP. This article shows how to use Parquet data in the Graph Builder and Query Builder.
-
Building Dynamic Web Pages with Google Ads Data Using AngularJS
Create single-page applications with live connectivity to Google Ads using the CData API Server.
-
Use Dash to Build Web Apps on Microsoft OneDrive Data via CData Connect AI
Build interactive Dash web apps on live Microsoft OneDrive data using pandas and the CData Connect AI Python SDK.
-
Connect to Jira Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Jira and the Script function in FileMaker Pro to connect to Jira and work with Jira data in your FileMaker application.
-
Query Live SAP Hybris C4C Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SAP Hybris C4C data directly from the development environment.
-
Use Azure AI Foundry to Talk to Your Notion 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 Notion data for you.