Model Context Protocol (MCP) finally gives AI models a way to access the business data needed to make them really useful at work. CData MCP Servers have the depth and performance to make sure AI has access to all of the answers.
Try them now for free →CData Software - Knowledge Base
Recent Articles
-
Excel Spreadsheet Automation on eBay Analytics with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to Connect the Power BI Service to Certinia: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Connect to OneNote from a Connection Pool in Jetty
The OneNote JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft OneNote from Web apps in Jetty.
-
Analyze Active Directory in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Active Directory and visualize Active Directory in SAP Analytics Cloud.
-
Connect to SAP BusinessObjects BI in HULFT Integrate
Connect to SAP BusinessObjects BI as a JDBC data source in HULFT Integrate
-
How to Query SAP Fieldglass in MySQL Workbench
Execute MySQL queries against live SAP Fieldglass from MySQL Workbench.
-
How to Work with Wave Financial in ETL Validator JDBC
Connect to Wave Financial from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect and process Smartsheet from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Smartsheet.
-
Analyze Zoho Creator in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zoho Creator in Microsoft R Open.
-
Query Oracle HCM Cloud using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle HCM Cloud entities in PHP by modeling them as objects.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for BigCommerce
Provide connectivity to BigCommerce through an SAP BusinessObjects universe.
-
Visualize Dynamics 365 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 Dynamics 365 into TIBCO Spotfire.
-
Create Dashboards and Visualize Live Microsoft Teams in Geckoboard
Use CData Connect Cloud to connect to live Microsoft Teams and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Active Directory Replication to Teradata
Use CData Sync to Customize and automate Active Directory replication to Teradata.
-
How to Connect to Live Twitter Ads in n8n Workflows and Agents (via CData Connect Cloud)
Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your Twitter Ads for you.
-
Todoist Reporting in OBIEE with the Todoist JDBC Driver
Deploy the Todoist JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Power BI XMLA in ColdFusion
Write standard ColdFusion data access code to connect to Power BI XMLA.
-
Build Visualizations of Marketo in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Marketo in Birst.
-
Connect to Oracle Financials Cloud in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for Oracle Financials Cloud in Airbyte.
-
Viewing Zoho CRM in RAD Studio Data Explorer
How to view Zoho CRM in RAD Studio Data Explorer using the CData ODBC Driver for Zoho CRM.
-
Building Dynamic Web Pages with Xero Using AngularJS
Create single-page applications with live connectivity to Xero using the CData API Server.
-
View Reports on Real-Time Facebook in Power BI Report Server
Use the CData ODBC Driver for Facebook to visualize Facebook in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate Bing Ads Replication to Couchbase
Use CData Sync to Customize and automate Bing Ads replication to Couchbase.
-
How to Work with SAP Ariba Source in AWS Glue Jobs Using JDBC
Connect to SAP Ariba Source from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Bind Live Clio Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Clio data
-
Access Live SAP Hybris C4C in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Hybris C4C from your Google Sheets.
-
Create Google Cloud Storage Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Cloud Storage data access from reports, embedded analytics, and more.
-
Bidirectional Access to xBase from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate xBase in Filemaker Pro for Mac or Windows.
-
Visualize Instagram in Tableau
The CData ODBC driver for Instagram enables you integrate Instagram into Tableau dashboards.
-
Import CouchDB into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache CouchDB. In this article, you will use the OData format to import Apache CouchDB into Microsoft Power Query.
-
Excel Spreadsheet Automation on Google Drive with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect to Oracle HCM Cloud from PowerBuilder via JDBC
This article demonstrates how to access Oracle HCM Cloud from PowerBuilder using the Oracle HCM Cloud JDBC Driver.
-
Provide OData Services of Snowflake from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Snowflake by developing a WCF Service Application.
-
How to connect to Klipfolio in DBVisualizer
Integrate Klipfolio with visual data analysis tools and data connection wizards in DBVisualizer
-
Extract, Transform, and Load HubDB in Informatica PowerCenter
Create a simple Workflow for HubDB in Informatica PowerCenter.
-
Migrating data from YouTube Analytics to Snowflake using CData SSIS Components.
Easily push YouTube Analytics to Snowflake using the CData SSIS Tasks for YouTube Analytics and Snowflake.
-
Build MVC Applications with Connectivity to EventBrite
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access EventBrite from an ASP.NET MVC application.
-
Prepare, Blend, and Analyze Todoist in Alteryx Designer (ODBC)
Build workflows to access live Todoist for self-service data analytics.
-
Use JayDeBeApi to access Adobe Target in Python
Use standard Python scripting and the development environment of your choice to access live Adobe Target.
-
Access Live Smartsheet in Coginiti Pro
Connect to and query live Smartsheet from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize SAP BusinessObjects BI in TIBCO Spotfire through OData
Integrate SAP BusinessObjects BI into dashboards in TIBCO Spotfire.
-
LINQ to Sage Intacct
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 Sage Intacct Data Provider.
-
Deploy the ADO.NET Provider for QuickBooks Time on an SSRS Report Server
Connect to QuickBooks Time 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.
-
Explore Geographical Relationships in Paylocity with Power Map
Create data visualizations with Paylocity in Power Map.
-
Create Google Data Catalog Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automate Zoom Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Zoom and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connecting to Azure Cosmos DB with MongoDB Drivers
Set up an Azure Cosmos DB account using the MongoDB API and connect using any CData Software Driver for MongoDB.
-
Connect Active Directory to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Active Directory using the CData Python MCP Server.
-
Build Data Flows from SQL Server to Adobe Commerce through SSIS
Easily push SQL Server data to Adobe Commerce using the CData SSIS Tasks for Adobe Commerce.
-
Visualize Live RSS Feeds of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live RSS Feeds using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Write a Simple Go Application to work with Power BI XMLA on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Power BI XMLA.
-
Integrate Live Greenplum into Custom Business Apps Built in Power Apps
Use CData Connect Cloud to connect to Pivotal GreenPlum and integrate live Pivotal GreenPlum into apps built in Microsoft Power Apps.
-
How to Access Live Greenplum in Power Automate Desktop via ODBC
The CData ODBC Driver for Greenplum enables you to integrate Pivotal GreenPlum into workflows built using Microsoft Power Automate Desktop.
-
Replicate Multiple Google Campaign Manager 360 Accounts via the CData Sync CLI
Replicate multiple Google Campaign Manager 360 accounts to one or many databases.
-
Analyze Twilio in R via JDBC
Use standard R functions and the development environment of your choice to analyze Twilio with the CData JDBC Driver for Twilio.
-
Prepare, Blend, and Analyze Facebook Ads in Alteryx Designer (Connect Cloud)
Build workflows to access live Facebook Ads for self-service data analytics.
-
Connect to Sage Intacct as an External Data Source using PolyBase
Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Sage Intacct.
-
Visualize CockroachDB in Sisense
Create an ElastiCube in Sisense app with access to CockroachDB.
-
Integrate Raisers Edge NXT into Automated Tasks with Power Automate
Use CData Connect Cloud to connect to Raisers Edge NXT and integrate live Raisers Edge NXT into your Power Automate tasks.
-
Query Twitter Ads using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Twitter Ads entities in PHP by modeling them as objects.
-
Visualize Printify in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Printify into TIBCO Spotfire.
-
Automated Continuous GitHub Replication to SQL Server
Use CData Sync for automated, continuous, customizable GitHub replication to SQL Server.
-
Build Apps with Live Marketo in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live Marketo into the Adalo platform and build custom mobile and web applications with real-time Marketo.
-
Visualize Live SurveyMonkey in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SurveyMonkey.
-
How to connect Amazon QuickSight to SAP Ariba Procurement
Create a connection to SAP Ariba Procurement in CData Connect Cloud and insert SAP Ariba Procurement into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous SAP BusinessObjects BI Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Google BigQuery.
-
Connect to Oracle HCM Cloud in RapidMiner
Integrate Oracle HCM Cloud with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze WordPress in Cognos Analytics
Use CData Connect Cloud to connect to WordPress from Cognos Analytics and analyze live WordPress.
-
Build Apps with Live MariaDB in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live MariaDB into the Adalo platform and build custom mobile and web applications with real-time MariaDB.
-
Model Jira Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Jira, enabling the direct import of real-time Atlassian Jira.
-
Connect to and Query Zoho Creator in QlikView over ODBC
Create data visualizations with Zoho Creator in QlikView.
-
Choosing the Best Method to Connect Elasticsearch to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Elasticsearch from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate ClickUp in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ClickUp from Informatica Cloud.
-
Build HCL Domino Visualizations in Tableau Desktop
Use CData Connect Cloud to connect to live HCL Domino and build visualizations in Tableau.
-
Connect to Dynamics 365 in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect Adobe Target to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Adobe Target using the CData Python MCP Server.
-
Integrate Live Square into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Square from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Square.
-
Automated Continuous Act-On Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Act-On replication to Google Cloud SQL.
-
View Reports on Real-Time Splunk in Power BI Report Server
Use the CData ODBC Driver for Splunk to visualize Splunk in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect DBeaver to Avro via a JDBC Driver
Manage Apache Avro with visual tools in DBeaver like the query browser.
-
Visualize Azure DevOps in Tableau
The CData ODBC driver for Azure DevOps enables you integrate Azure DevOps into Tableau dashboards.
-
Access Live Aha in AWS Lambda (with IntelliJ IDEA)
Connect to live Aha! in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Import Zoho Projects into the Power BI Service for Visualizations
Use CData Connect Cloud to connect to Zoho Projects and provide access to live Zoho Projects for custom reports in the Power BI Service.
-
Automated Continuous Procore Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Procore replication to PostgreSQL.
-
How to integrate Metabase with Microsoft Planner
Use CData Connect Cloud to connect to live Microsoft Planner and create an interactive dashboard in Metabase from Microsoft Planner.
-
Connect to Zoho Projects as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoho Projects.
-
Connect to Trello from PowerBuilder via JDBC
This article demonstrates how to access Trello from PowerBuilder using the Trello JDBC Driver.
-
How to connect SharePoint with FTP through external lists
Provide FTP Servers to SharePoint users as an external list.
-
Connect to Asana as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Asana.
-
Building Dynamic Web Pages with Zoom Using AngularJS
Create single-page applications with live connectivity to Zoom using the CData API Server.
-
Replicate Shopify in Heroku for Use in Salesforce Connect
Replicate Shopify to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use CData Connect Cloud to Access Workday in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Workday in the Power Pivot business intelligence tool.
-
Import Real-Time Freshdesk via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Freshdesk in ColdFusion.
-
Natively Connect to EventBrite in PHP
The CData ODBC driver for EventBrite enables you to create PHP applications with connectivity to Eventbrite. Leverage the native support for ODBC in PHP.
-
Create a Data Access Object for NetSuite using JDBI
A brief overview of creating a SQL Object API for NetSuite CRM & ERP in JDBI.
-
Build Semantic Layer Views for Twilio in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Twilio.
-
Build Apps with Live Google Drive in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live Google Drive into the Adalo platform and build custom mobile and web applications with real-time Google Drive.
-
Connect to Zendesk from a Connection Pool in JBoss
Integrate Zendesk into Java servlets: Use the Management Console in JBoss to install the Zendesk JDBC Driver.
-
Configure the CData JDBC Driver for Pinterest in a Connection Pool in Tomcat
Connect to Pinterest from a connection pool in Tomcat.
-
Access Live Google Drive in Excel 365 Online (Excel for the web)
Connect to Google Drive from Excel 365 Online (Excel for the web) with CData Connect Cloud.