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
-
Connect to Coinbase from a Connection Pool in WebLogic
Use the CData JDBC Driver for Coinbase to connect to Coinbase from Web applications running on WebLogic.
-
PowerShell Scripting to Replicate Cosmos DB to MySQL
Write a simple PowerShell script to replicate Azure Cosmos DB to a MySQL database.
-
Automated Continuous Airtable Replication to SQLite
Use CData Sync for automated, continuous, customizable Airtable replication to SQLite.
-
Automated Continuous SAP ByDesign Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Oracle.
-
How to load Greenhouse data into Elasticsearch via Logstash
Introducing a simple method to load Greenhouse data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Work with Sage Cloud Accounting in FoxPro
Load Sage Business Cloud Accounting into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Invoiced in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Invoiced into TIBCO Spotfire.
-
Query, Visualize, and Share live Sugar CRM in Redash
Use CData Connect Cloud to connect to live Sugar CRM in Redash for querying, visualizing, and sharing.
-
Analyze Impala with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Impala from Power Pivot. You will use the Table Import Wizard to load Apache Impala. You can visually build the import query or use any SQL supported by the driver.
-
A PostgreSQL Interface for JDBC-ODBC Bridge (MySQL Remoting via JDBC)
Use the Remoting features of the JDBC-ODBC Bridge JDBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze Invoiced in Alteryx Designer (ODBC)
Build workflows to access live Invoiced for self-service data analytics.
-
Integrate with Azure Data Lake Storage using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Data Lake Storage to a JSON file on disk.
-
Automate CouchDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apache CouchDB from PowerShell? This article demonstrates how to utilize the CouchDB Cmdlets for tasks like connecting to Apache CouchDB, automating operations, downloading data, and more.
-
Integrate Microsoft Planner into Power Automate Desktop using CData Connect
CData Connect for Microsoft Planner enables you to integrate Microsoft Planner into workflows built using Microsoft Power Automate Desktop.
-
Create a Data Access Object for Access using JDBI
A brief overview of creating a SQL Object API for Microsoft Access in JDBI.
-
Create Data Visualizations Based On Power BI XMLA in Mode
Use CData Connect Cloud to connect to Power BI XMLA from Mode and build visualizations using live
-
Connect to Airtable in Ruby
Connect to Airtable in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Zendesk Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zendesk replication to SQL Server.
-
Connect to Blackbaud FE NXT as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Blackbaud FE NXT.
-
How to Connect DBeaver to Neo4J via a JDBC Driver
Manage Neo4J with visual tools in DBeaver like the query browser.
-
Replicate Multiple Act CRM Accounts via the CData Sync CLI
Replicate multiple Act CRM accounts to one or many databases.
-
Access Live OneNote in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft OneNote from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Load CockroachDB to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load CockroachDB to a database.
-
Provide OData Services of SingleStore from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SingleStore by developing a WCF Service Application.
-
Build DocuSign-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for DocuSign and create custom apps in Mendix.
-
How to integrate Metabase with Couchbase
Use CData Connect Cloud to connect to live Couchbase and create an interactive dashboard in Metabase from Couchbase.
-
Automated Continuous Confluence Replication to MongoDB
Use CData Sync for automated, continuous, customizable Confluence replication to MongoDB.
-
Integrate Raisers Edge NXT into Power Automate Desktop using CData Connect
CData Connect for Raisers Edge NXT enables you to integrate Raisers Edge NXT into workflows built using Microsoft Power Automate Desktop.
-
Build QuickBooks Time-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to QuickBooks Time from Zoho Analytics and import live QuickBooks Time.
-
How to Visualize SAS Data Sets Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAS Data Sets in Python.
-
Use JayDeBeApi to access Excel Online in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Excel Online.
-
Process & Analyze Dynamics NAV in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Dynamics NAV .
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Instagram
Provide connectivity to Instagram through an SAP BusinessObjects universe.
-
Model, Search, and Visualize Live Google Contacts in ThoughtSpot
Use CData Connect Cloud to connect to live Google Contacts for modeling, searching, and visualizing.
-
Query Azure Table in MySQL Workbench
Create a virtual MySQL database for Azure Table Storage in CData Software Connect (or Connect Server) and work with live Azure Table Storage in MySQL Workbench.
-
Easily Integrate Zuora in Lazarus Pascal IDE
Learn how to easily integrate live Zuora in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create a Data Access Object for Shippo using JDBI
A brief overview of creating a SQL Object API for Shippo in JDBI.
-
Replicate SingleStore to Multiple Databases
Replicate SingleStore to disparate databases with a point-and-click configuration.
-
Replicate SendGrid from PowerShell
Write a quick PowerShell script to query SendGrid. Use connectivity to the live data to replicate SendGrid to SQL Server.
-
Analyze Google Spanner in Looker
Use CData Connect Cloud to connect to Google Spanner from Looker and build custom apps using live Google Spanner.
-
Automated Continuous ServiceNow Replication to Databricks
Use CData Sync for automated, continuous, customizable ServiceNow replication to Databricks.
-
Automated Continuous Google Ad Manager Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Apache Cassandra.
-
Use JayDeBeApi to access Redshift in Python
Use standard Python scripting and the development environment of your choice to access live Amazon Redshift.
-
Use JayDeBeApi to access IBM Cloud Data Engine in Python
Use standard Python scripting and the development environment of your choice to access live IBM Cloud Data Engine.
-
A PostgreSQL Interface for Microsoft Project (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft Project JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Live Parquet in Power Automate Desktop via ODBC
The CData ODBC Driver for Parquet enables you to integrate Apache Parquet into workflows built using Microsoft Power Automate Desktop.
-
Replicate SAP to Multiple Databases via the CData Sync CLI
Replicate SAP ERP/NetWeaver to disparate databases with a single configuration.
-
Visualize Oracle Service Cloud in Tableau
The CData ODBC driver for Oracle Service Cloud enables you integrate Oracle Service Cloud into Tableau dashboards.
-
Bridge IBM Informix Connectivity with Apache NiFi
Access and process IBM Informix in Apache NiFi using the CData JDBC Driver.
-
Access Authorize.Net in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Authorize.Net.
-
Create Dynamics 365 Business Central Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Adobe Analytics in SpagoBI
Create reports featuring live Adobe Analytics in SpagoBI Studio. Host Adobe Analytics reports on SpagoBI Server.
-
Automate Clio Replication to Azure Synapse
Use CData Sync to customize and automate Clio replication to Azure Synapse.
-
Extract, Transform, and Load SAP BusinessObjects BI in Informatica PowerCenter
Create a simple Workflow for SAP BusinessObjects BI in Informatica PowerCenter.
-
Use the CData Software JDBC Driver for Reckon in MicroStrategy Web
Connect to Reckon in MicroStrategy Web using the CData Software JDBC Driver for Reckon.
-
Automated Continuous SAP Netweaver Gateway Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to MongoDB.
-
Connect to Azure Data Catalog in Ruby
Connect to Azure Data Catalog in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Azure Active Directory through External Services in Salesforce
Use CData Connect Cloud to securely connect Salesforce External Services with Azure Active Directory using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Deploy the ADO.NET Provider for Azure Table on an SSRS Report Server
Connect to Azure Table Storage 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.
-
Query Zenefits in ColdFusion
Write standard ColdFusion data access code to connect to Zenefits.
-
Use the CData Software ODBC Driver for QuickBooks Time in MicroStrategy
Connect to QuickBooks Time in MicroStrategy Developer using the CData Software ODBC Driver for QuickBooks Time.
-
Visualize REST in Tableau Desktop (through CData Connect)
Create a virtual SQL Server database for REST in CData Software Connect (or Connect Server) and build visualizations from live REST in Tableau Desktop.
-
Provide OData Services of PayPal from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for PayPal by developing a WCF Service Application.
-
Create Google Campaign Manager 360-Connected Applications in Appsmith
Connect to Google Campaign Manager 360 via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Google Campaign Manager 360.
-
Use JayDeBeApi to access ConstantContact in Python
Use standard Python scripting and the development environment of your choice to access live ConstantContact.
-
A PostgreSQL Interface for Google Data Catalog using the CData ODBC Driver
Use the SQL Gateway and Google Data Catalog ODBC Driver to create a PostgreSQL entry-point for data access.
-
LINQ to Pipedrive
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 Pipedrive Data Provider.
-
Visualize Printful in Sisense
Create an ElastiCube in Sisense app with access to Printful.
-
How to Visualize Jira Assets Data in Python with pandas
Use pandas and other modules to analyze and visualize live Jira Assets in Python.
-
Connect to Dynamics CRM from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Dynamics CRM using standard SQL.
-
Visualize Bitbucket in Sisense
Create an ElastiCube in Sisense app with access to Bitbucket.
-
How to Seamlessly Import Dynamics CRM Data into IBM SPSS Modeler
Integrate Dynamics CRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Dashboards with SharePoint Excel Services in DBxtra
Create dynamic dashboards and perform analytics based on SharePoint Excel Services in DBxtra.
-
Create Azure Active Directory Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Dashboards with Snowflake in DBxtra
Create dynamic dashboards and perform analytics based on Snowflake in DBxtra.
-
How to create Redshift federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Amazon Redshift in MySQL .
-
Automated Continuous Certinia Replication to MongoDB
Use CData Sync for automated, continuous, customizable Certinia replication to MongoDB.
-
Import Oracle HCM Cloud into FileMaker Pro
Create reports that integrate Oracle HCM Cloud in Filemaker Pro.
-
Access Live SharePoint in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft SharePoint from your Google Sheets.
-
Publish QuickBooks Online-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live QuickBooks Online.
-
Use the CData Software JDBC Driver for Outreach.io in MicroStrategy Desktop
Connect to Outreach.io in MicroStrategy Desktop using the CData Software JDBC Driver for Outreach.io.
-
Build Apps with Live HubSpot in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live HubSpot into the Adalo platform and build custom mobile and web applications with real-time HubSpot.
-
Perform Batch Operations with SharePoint Excel Services in Apache NiFi
Connect to SharePoint Excel Services and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Shippo
Use CData Power BI Connectors to visualize Shippo in Power BI.
-
Import Salesforce Data Cloud into FileMaker Pro
Create reports that integrate Salesforce Data Cloud in Filemaker Pro.
-
Explore Geographical Relationships in Sage 300 with Power Map
Create data visualizations with Sage 300 in Power Map.
-
Build FHIR-Connected Apps in Bubble
Use CData Connect Cloud to create an OData feed for FHIR and create custom apps in Bubble.
-
Create Dynamic BigCommerce Grids Using the Infragistics XamDataGrid
Learn how you can connect BigCommerce to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Live Cosmos DB into Custom Business Apps Built in Power Apps
Use CData Connect Cloud to connect to Azure Cosmos DB and integrate live Azure Cosmos DB into apps built in Microsoft Power Apps.
-
Deploy the ADO.NET Provider for Twitter Ads on an SSRS Report Server
Connect to Twitter Ads 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.
-
Build Automated Dynamics CRM-Connected Workflows in Zapier
Use CData Connect Cloud to connect to live Microsoft Dynamics CRM and build automated workflows in Zapier.
-
Box Reporting in OBIEE with the Box JDBC Driver
Deploy the Box JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Natively Connect to Salesforce Pardot in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesforce Pardot. Leverage the native support for ODBC in PHP.
-
Build Dashboards with Access in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Access in DBxtra.
-
Create Data Visualizations in Cognos BI with Parquet
Access Apache Parquet as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Access Zoom Using Entity Framework
This article shows how to access Zoom using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live ShipStation in Google Sheets via Connect Cloud
Use CData Connect Cloud to gain access to live ShipStation from your Google Sheets.
-
Load FTP to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load FTP Servers to a database.
-
Use CData Connect Cloud to Access GMO MakeShop in Microsoft Power Pivot
Use CData Connect Cloud to connect to live GMO MakeShop in the Power Pivot business intelligence tool.
-
Provide OData Services of Splunk from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Splunk by developing a WCF Service Application.