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
-
Build CData Connect Cloud-Connected Dashboards in Redash
Use CData Software Connect Server to create a virtual SQL Server Database for CData Connect Cloud and build visualizations and dashbaords from CData Connect Cloud in Redash.
-
Validate CouchDB with QuerySurge
Access and validate Apache CouchDB in QuerySurge using the CData JDBC Driver.
-
Connect to MYOB AccountRight from a Connection Pool in Jetty
The MYOB AccountRight JDBC Driver supports connection pooling: This article shows how to connect faster to MYOB AccountRight from Web apps in Jetty.
-
Connect to MailChimp from HeidiSQL
Use CData Connect Cloud to connect to and query live MailChimp from HeidiSQL.
-
Connect to Hive in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apache Hive in the Denodo Virtual DataPort Administrator.
-
How to use SQLAlchemy ORM to access Acumatica in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Acumatica ERP.
-
Publish Reports with Google Directory in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Directory.
-
Connect to DB2 as an External Source in Dremio
Use the CData JDBC Driver to connect to DB2 as an External Source in Dremio.
-
Build Dashboards with Google Cloud Storage in Dundas BI
Create dynamic dashboards and perform analytics based on Google Cloud Storage in Dundas BI.
-
Deploy the ADO.NET Provider for Greenplum on an SSRS Report Server
Connect to Pivotal GreenPlum 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.
-
How to create Visio diagrams from Excel Online
Automatically update Microsoft Excel Online with the changes you make to Visio master shapes.
-
Access Live Google Calendar in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Calendar from your Google Sheets.
-
Use Dash to Build to Web Apps on Dynamics NAV
Create Python applications that use pandas and Dash to build Dynamics NAV-connected web apps.
-
Create Acumatica Dashboards in Bold BI
Use CData Software Connect Server to create a virtual SQL Server Database for Acumatica ERP to build custom dashboards in Bold BI.
-
Automated Continuous Google Directory Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Directory replication to Google Cloud SQL.
-
How to connect to Authorize.Net from IntelliJ
Integrate connectivity to Authorize.Net with wizards in IntelliJ.
-
How to connect to Greenplum from IntelliJ
Integrate connectivity to Pivotal GreenPlum with wizards in IntelliJ.
-
Integrate with Authorize.Net using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Authorize.Net to a JSON file on disk.
-
Integrate Live Teradata into Custom Business Apps Built in Power Apps
Use CData Software Connect Server to create a virtual SQL Server Database for Teradata and integrate live Teradata into apps built in Microsoft Power Apps.
-
Edit and Search External Impala Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of Apache Impala to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Impala objects that you can access from apps and the dashboard.
-
Perform Batch Operations with Tableau CRM Analytics in Apache NiFi
Connect to Tableau CRM Analytics and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Use the CData ODBC Driver for Blackbaud FE NXT in Microsoft Power Query
You can use the CData Blackbaud FE NXT ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Blackbaud FE NXT into Microsoft Power Query.
-
DataBind Controls to Cosmos DB in C++Builder
DataBind to Azure Cosmos DB in C++Builder with standard components and controls.
-
Automated Continuous Airtable Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Airtable replication to PostgreSQL.
-
Write a Simple Go Application to work with DB2 on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to IBM DB2.
-
Build Cassandra-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Cassandra.
-
Create Datasets from Salesforce Marketing in Domo Workbench and Build Visualizations of Salesforce Marketing in Domo
Use the CData Software ODBC Driver for Salesforce Marketing to create datasets from Salesforce Marketing Cloud in Domo Workbench and then build visualizations in the Domo service.
-
Build a Simple VCL Application for Salesloft
How to build a simple VCL Application to view Salesloft in RAD Studio using the CData ODBC Driver for Salesloft.
-
Access Dynamics 365 Business Central as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Dynamics 365 Business Central from your Oracle system.
-
How to connect to Typeform from Google Apps Script
Use CData Software Connect Server to access Typeform in Google Apps Script.
-
Integrate SQL Server into Power Automate Desktop using CData Connect
CData Connect for SQL Server enables you to integrate Microsoft SQL Server into workflows built using Microsoft Power Automate Desktop.
-
Connect to Access in RapidMiner
Integrate Microsoft Access with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Dynamics 365 Business Central Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to delimited files (CSV/TSV).
-
How to publish and share Sugar CRM dashboards with Tableau Server
The CData ODBC driver for Sugar CRM enables you integrate Sugar CRM into Tableau dashboards.
-
How to update Act CRM from Excel
This article explains how to transfer data from Excel to Act CRM using the Excel Add-In for Act CRM.
-
Analyze SAP ByDesign in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Business ByDesign in Microsoft R Open.
-
A PostgreSQL Interface for Active Directory using the CData ODBC Driver
Use the SQL Gateway and Active Directory ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Microsoft Project Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Project replication to Azure Synapse.
-
Use the CData ODBC Driver for BigCommerce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for BigCommerce to connect to BigCommerce from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring BigCommerce in Excel.
-
Analyze Oracle HCM Cloud in Looker
Use CData Connect Cloud to connect to Oracle HCM Cloud from Looker and build custom apps using live Oracle HCM Cloud.
-
Build Google Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Ads.
-
Build XML-Connected Dashboards in Redash
Use CData Software Connect Server to create a virtual SQL Server Database for XML Files and build visualizations and dashbaords from XML Files in Redash.
-
Connect to Hive from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Apache Hive, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP Fieldglass
Provide connectivity to SAP Fieldglass through an SAP BusinessObjects universe.
-
View Reports on Real-Time OneNote in Power BI Report Server
Use the CData ODBC Driver for OneNote to visualize Microsoft OneNote in Power BI Desktop and then publish them to Power BI Report Server.
-
Configure the CData JDBC Driver for Twilio in a Connection Pool in Tomcat
Connect to Twilio from a connection pool in Tomcat.
-
Working with ServiceNow in LINQPad
Execute LINQ queries to ServiceNow in LINQPad.
-
Connect to Wave Financial from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Wave Financial to connect to Wave Financial and execute queries in PowerBuilder.
-
DataBind Controls to Airtable in Delphi
DataBind to Airtable in Delphi with standard data access components and controls.
-
How to create Visio diagrams from LinkedIn
Automatically update LinkedIn with the changes you make to Visio master shapes.
-
Connect to Microsoft OneDrive in HULFT Integrate
Connect to Microsoft OneDrive as a JDBC data source in HULFT Integrate
-
Automated Continuous Microsoft Project Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Microsoft Project replication to Apache Cassandra.
-
Build Paylocity Visualizations in Tableau Desktop
Use CData Connect Cloud to connect to live Paylocity and build visualizations in Tableau.
-
Integrate with AlloyDB in JReport Designer
Create charts and reports based on Google AlloyDB in JReport Designer.
-
Build Interactive Dashboards from Authorize.Net in Amazon QuickSight
Create a virtual SQL Server database for Authorize.Net in CData Software Connect Server and import Authorize.Net into Amazon QuickSight SPICE to build interactive dashboards.
-
Provide OData Services of Elasticsearch from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Elasticsearch by developing a WCF Service Application.
-
How to load JSON data into Elasticsearch via Logstash
Introducing a simple method to load JSON data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Snapchat Ads in Excel 365 Online (Excel for the web)
Connect to Snapchat Ads from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Automated Continuous SAP HANA Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP HANA replication to Vertica.
-
Replicate Vertica to Multiple Databases
Replicate Vertica to disparate databases with a point-and-click configuration.
-
Integrate FHIR into Automated Tasks with Power Automate
Use CData Connect Cloud to connect to FHIR and integrate live FHIR into your Power Automate tasks.
-
Access Live Google Search Results in Google Sheets via Connect Cloud
Use CData Connect Cloud to gain access to live Google Search from your Google Sheets.
-
How to Connect the Power BI Service to Facebook Ads: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
How to import Act-On into Apache Solr
Use the CData Software JDBC Driver for Act-On in Data Import Handler and create an automated import of Act-On to Apache Solr Enterprise Search platform.
-
Seamlessly Bring Odoo into Retool Using CData Connect Cloud
Integrate Odoo data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
-
Connect to WordPress in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for WordPress in Airbyte.
-
How to Work with OData Services in ETL Validator JDBC
Connect to OData from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate Oracle SCM Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle SCM replication to Azure Data Lake.
-
Integrate with eBay in SnapLogic
Use CData Connect Cloud to connect to and integrate with live eBay in SnapLogic.
-
Access Xero from MySQL in PHP
Connect to Xero through the standard MySQL libraries in PHP.
-
How to Access Google Analytics Using Entity Framework
This article shows how to access Google Analytics using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Query Live SurveyMonkey Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SurveyMonkey data in natural language using Python.
-
Connect to Active Directory in CloverDX (formerly CloverETL)
Transfer Active Directory using the visual workflow in the CloverDX data integration tool.
-
Connect to Real-Time Phoenix Data in Power Apps Using Dataflows to Build Custom Applications
-