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
-
Use the CData ODBC Driver for Clio from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Clio to connect to Clio from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Clio in Excel.
-
How to Use a Microsoft Access Database to Update Quickbase in Real Time
Update Quickbase data by creating a linked table in Microsoft Access with the CData Quickbase ODBC Driver.
-
Visualize Live JotForm in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live JotForm.
-
Connect to Facebook from a Connection Pool in JBoss
Integrate Facebook into Java servlets: Use the Management Console in JBoss to install the Facebook JDBC Driver.
-
Query Wave Financial in ColdFusion
Write standard ColdFusion data access code to connect to Wave Financial.
-
Stream Dropbox into Apache Kafka Topics
Access and stream Dropbox in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Live LDAP Objects in the Power BI Service
Use CData Software Connect Server to create a virtual SQL Server database for LDAP and create custom reports in the Power BI Service.
-
Create NetSuite-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to NetSuite from OutSystems and build custom enterprise apps using live NetSuite CRM & ERP.
-
Publish Reports with Authorize.Net in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Authorize.Net.
-
SAP SuccessFactors Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP SuccessFactors through CData Connect Cloud using different applications and tools.
-
Access Live SurveyMonkey in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SurveyMonkey from your Excel spreadsheets.
-
CData Virtuality 4.8 Release Notes: Resource Governor, Timezone Support for Jobs, New connectors, and More
Read the release notes for CData Virtuality 4.8, including the new Resource Governor, timezone support for jobs, new connectors, and a lot more.
-
Use the CData Software ODBC Driver for Microsoft OneDrive in MicroStrategy Desktop
Connect to Microsoft OneDrive in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft OneDrive.
-
Natively Connect to OneNote in PHP
The CData ODBC driver for OneNote enables you to create PHP applications with connectivity to Microsoft OneNote. Leverage the native support for ODBC in PHP.
-
Use the CData SSIS Components to Insert New or Update Existing Greenplum Records from SQL Server
Easily push SQL Server data to Greenplum using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Greenplum or update existing records with data from a SQL Server database.
-
Connect to Cassandra from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Cassandra from Appeon PowerBuilder using the CData ADO.NET Provider for Cassandra.
-
Automated Continuous Shippo Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Shippo replication to OneLake in Microsoft Fabric.
-
Provide OData Services of Smartsheet from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Smartsheet by developing a WCF Service Application.
-
Connect to Yahoo! Japan Data Solution from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Yahoo! Japan Data Solution, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Salesloft from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Salesloft using standard SQL.
-
Create Dashboards and Visualize Live Office 365 in Geckoboard
Use CData Connect Cloud to connect to live Microsoft Office 365 and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Seamlessly Bring Paylocity into Retool Using CData Connect Cloud
Integrate Paylocity data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
-
How to Work with ADP in ETL Validator JDBC
Connect to ADP from ETL Validator jobs using the CData Software JDBC Driver.
-
Establish a Live Connection with SAP BusinessObjects BI using Tableau Bridge
The CData ODBC Driver for SAP BusinessObjects BI enables you to integrate live SAP BusinessObjects BI into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze Adobe Commerce with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Adobe Commerce from Power Pivot. You will use the Table Import Wizard to load Adobe Commerce. You can visually build the import query or use any SQL supported by the driver.
-
Create Dynamic Twilio Grids Using the Infragistics XamDataGrid
Learn how you can connect Twilio to Infragistics XamDataGrid to build dynamic grids.
-
DataBind Charts to GraphQL
Use the standard ADO.NET procedures for databinding to provide bidirectional access to GraphQL from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to Connect DBeaver to Twilio via a JDBC Driver
Manage Twilio with visual tools in DBeaver like the query browser.
-
Access Live Quickbase in AWS Lambda (with IntelliJ IDEA)
Connect to live Quickbase in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Sage 200 in PHP through Connect Server
Connect to Sage 200 through the standard SQL Server libraries in PHP.
-
How to Visualize Couchbase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Couchbase in Python.
-
Automated Continuous Reckon Accounts Hosted Replication to MySQL
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to MySQL.
-
Use the CData Software JDBC Driver for Cvent in MicroStrategy Web
Connect to Cvent in MicroStrategy Web using the CData Software JDBC Driver for Cvent.
-
Build a PostgreSQL Interface for GraphQL using the CData JDBC Driver
Use the Remoting features of the GraphQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build a Simple VCL Application for Highrise
How to build a simple VCL Application to view Highrise CRM in RAD Studio using the CData ODBC Driver for Highrise.
-
Connect to Shippo as an External Source in Dremio
Use the CData JDBC Driver to connect to Shippo as an External Source in Dremio.
-
Import Real-Time Salesforce Pardot via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesforce Pardot in ColdFusion.
-
Access Gmail from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Gmail from HeidiSQL.
-
Connect to Bullhorn CRM from a Connection Pool in Jetty
The Bullhorn CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Bullhorn CRM from Web apps in Jetty.
-
Visualize Live REST in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live REST.
-
Visualize Email in Sisense
Create an ElastiCube in Sisense app with access to Email.
-
Build a Simple VCL Application for TigerGraph
How to build a simple VCL Application to view TigerGraph in RAD Studio using the CData ODBC Driver for TigerGraph.
-
Automated Continuous Spark Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Spark replication to delimited files (CSV/TSV).
-
Query Adobe Commerce as a MySQL Database in Node.js
Execute MySQL queries against Adobe Commerce from Node.js.
-
Publish Reports with TaxJar in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date TaxJar.
-
Connect to Azure Analysis Services in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Azure Analysis Services and connect to Azure Analysis Services in Akorbi Digital RunMyProcess.
-
Author and Share Power BI Reports on Real-Time Spark
Use the CData ODBC Driver for Spark to visualize Apache Spark SQL in Power BI Desktop and then upload to the Power BI service.
-
Connect to Bitbucket in HULFT Integrate
Connect to Bitbucket as a JDBC data source in HULFT Integrate
-
Automated Continuous Todoist Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Todoist replication to Google BigQuery.
-
Visualize TaxJar in TIBCO Spotfire through OData
Integrate TaxJar into dashboards in TIBCO Spotfire.
-
Connect to Coinbase in Ruby
Connect to Coinbase in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Semantic Layer Views for Raisers Edge NXT in APOS Live Data Gateway
Use the CData Connector for Raisers Edge NXT in APOS Live Data Gateway to build Semantic Layer Views for Raisers Edge NXT.
-
Create Salesforce Pardot-Connected Business Apps in AppSheet
Connect to Salesforce Pardot via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Salesforce Pardot.
-
Publish Sage Cloud Accounting-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sage Business Cloud Accounting.
-
How to work with Shippo in Apache Spark using SQL
Access and process Shippo in Apache Spark using the CData Software JDBC Driver.
-
Visualize Live Snapchat Ads in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Snapchat Ads.
-
Configure the CData JDBC Driver for Sybase IQ in a Connection Pool in Tomcat
Connect to Sybase IQ from a connection pool in Tomcat.
-
Automate Oracle Eloqua Replication to Couchbase
Use CData Sync to Customize and automate Oracle Eloqua replication to Couchbase.
-
Automated Continuous ConstantContact Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ConstantContact replication to Apache Kafka.
-
Connect to Microsoft Exchange in Aqua Data Studio
Access Microsoft Exchange from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Rapidly Develop CSV-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Create a Data Access Object for SharePoint Excel Services using JDBI
A brief overview of creating a SQL Object API for SharePoint Excel Services in JDBI.
-
Automated Continuous Parquet Replication to SingleStore
Use CData Sync for automated, continuous, customizable Parquet replication to SingleStore.
-
Access Live Google Spanner in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Spanner from your Google Sheets.
-
Create Datasets from Excel in Domo Workbench and Build Visualizations of Excel in Domo
Use the CData Software ODBC Driver for Excel to create datasets from Microsoft Excel in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Oracle Sales from HeidiSQL
Use CData Connect Cloud to connect to and query live Oracle Sales from HeidiSQL.
-
Connect to Google Ad Manager in RazorSQL
Connect to Google Ad Manager from wizards and query Google Ad Manager from the GUI in the RazorSQL database management tool.
-
Automated Continuous Workday Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Workday replication to PostgreSQL.
-
Back Up Shippo to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Shippo. In this article, we will employ an SSIS workflow to populate a database with Shippo data.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP BusinessObjects BI
Create an ODBC connection to SAP BusinessObjects BI in Informatica and browse and transfer SAP BusinessObjects BI.
-
Automated Continuous SharePoint Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SharePoint replication to delimited files (CSV/TSV).
-
How to connect to Azure Data Catalog from IntelliJ
Integrate connectivity to Azure Data Catalog with wizards in IntelliJ.
-
Working with Oracle Financials Cloud in LINQPad
Execute LINQ queries to Oracle Financials Cloud in LINQPad.
-
Automated Continuous Sage 50 UK Replication to Databricks
Use CData Sync for automated, continuous, customizable Sage 50 UK replication to Databricks.
-
Build SAP SuccessFactors-Connected Apps in Bubble
Use CData Connect Cloud to create an OData feed for SAP SuccessFactors and create custom apps in Bubble.
-
Integrate Salesforce into Power Automate Desktop using CData Connect
CData Connect for Salesforce enables you to integrate Salesforce & Force.com into workflows built using Microsoft Power Automate Desktop.
-
Visualize Greenhouse in Tableau
The CData ODBC driver for Greenhouse enables you integrate Greenhouse into Tableau dashboards.
-
How to connect and process Avalara AvaTax from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Avalara AvaTax
-
Build Harvest Visualizations in Tableau Cloud
Use CData Software Connect Server to create a virtual SQL Server Database for Harvest and build visualizations in Tableau Cloud.
-
How to integrate SharePoint Excel Services with Apache Airflow
Access and process SharePoint Excel Services in Apache Airflow using the CData JDBC Driver.
-
Query SQL Server in DataGrip
Create a Data Source for SQL Server in DataGrip and use SQL to query live Microsoft SQL Server.
-
Easily Integrate Azure Data Catalog in Lazarus Pascal IDE
Learn how to easily integrate live Azure Data Catalog in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Real-Time Access to Typeform in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Typeform in real time.
-
Visualize Live Azure Data Lake Storage in the Power BI Service
Use CData Connect Cloud to connect to live Azure Data Lake Storage and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Build Dynamic React Apps with Adobe Commerce
Use the CData Connect and React to Build Dynamic Web Apps with Live Adobe Commerce .
-
Automated Continuous Airtable Replication to MySQL
Use CData Sync for automated, continuous, customizable Airtable replication to MySQL.
-
Access Live Google Ad Manager in Coginiti Pro
Connect to and query live Google Ad Manager from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to Parquet in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache Parquet. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software ODBC Driver for EnterpriseDB in MicroStrategy
Connect to EnterpriseDB in MicroStrategy Developer using the CData Software ODBC Driver for EnterpriseDB.
-
Automated Continuous SAP Ariba Procurement Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to delimited files (CSV/TSV).
-
How to Connect to CouchDB in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache CouchDB. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Couchbase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Couchbase replication to Apache Cassandra.
-
Use Dash to Build to Web Apps on IBM Informix
Create Python applications that use pandas and Dash to build IBM Informix-connected web apps.
-
How to use SQLAlchemy ORM to access Elasticsearch in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Elasticsearch.
-
Visualize Confluence in TIBCO Spotfire through ADO.NET
Integrate Atlassian Confluence into dashboards in TIBCO Spotfire.
-
Replicate Facebook Ads to Multiple Databases
Replicate Facebook Ads to disparate databases with a point-and-click configuration.
-
Connect to Typeform in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
eBay Reporting in OBIEE with the eBay JDBC Driver
Deploy the eBay JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Google Campaign Manager 360 Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to MongoDB.
-
Create Data Visualizations in Cognos BI with Google Directory
Access Google Directory as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.