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
-
DataBind Controls to HBase in C++Builder
DataBind to Apache HBase in C++Builder with standard components and controls.
-
Natively Connect to SuiteCRM in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SuiteCRM. Leverage the native support for ODBC in PHP.
-
Create SSAS Tabular Models from Bullhorn CRM
How to build a SQL Server Analysis Service Tabular Model from Bullhorn CRM using CData drivers.
-
Visualize Live SAP Ariba Procurement of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Ariba Procurement using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Act-On through External Services in Salesforce
Use CData Connect Cloud to securely connect Salesforce External Services with Act-On using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to pipe MailChimp to CSV in PowerShell
Use standard PowerShell cmdlets to access MailChimp tables.
-
Integrate with FTP using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy FTP Servers to a JSON file on disk.
-
Automated Airtable Replication to Teradata
Use CData Sync to Customize and automate Airtable replication to Teradata.
-
Build Charts with Vault CRM in Clear Analytics
Create dynamic charts and perform analytics based on Veeva Vault & Vault CRM in Clear Analytics.
-
Create a Data Access Object for Reckon Accounts Hosted using JDBI
A brief overview of creating a SQL Object API for Reckon Accounts Hosted in JDBI.
-
Connect to Google Search Results 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 Google Search.
-
Access Live Splunk in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Splunk from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate with Paylocity using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Paylocity to a JSON file on disk.
-
Connect to Oracle Sales from Filemaker Pro (Mac)
Use CData Connect Cloud to connect to and query live Oracle Sales from Filemaker Pro on Mac.
-
Access MYOB AccountRight from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MYOB AccountRight from HeidiSQL.
-
How to Work with Google Ads in AWS Glue Jobs Using JDBC
Connect to Google Ads from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Trello 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 Trello.
-
Build Automated Workflows with Live Google Search Results in Workato
Use CData Connect Cloud to connect to live Google Search and build automated workflows in Workato.
-
Build Visualizations of Zoho Inventory in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Inventory in Birst.
-
Automated Continuous LDAP Replication to SQL Server
Use CData Sync for automated, continuous, customizable LDAP replication to SQL Server.
-
Jira Assets Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Jira Assets facts in real time.
-
Build Dashboards with Email in DBxtra
Create dynamic dashboards and perform analytics based on Email in DBxtra.
-
How to Create Power BI Visual Reports with Real-Time xBase
Use CData Power BI Connectors to visualize xBase in Power BI.
-
Automated Continuous SharePoint Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SharePoint replication to AlloyDB.
-
Integrate Blackbaud FE NXT into Automated Tasks with Power Automate
Use CData Connect Cloud to connect to Blackbaud FE NXT and integrate live Blackbaud FE NXT into your Power Automate tasks.
-
Integrate with Live Microsoft Planner in MuleSoft (via CData Connect Cloud)
Use CData Connect Cloud to connect to Microsoft Planner from the MuleSoft Anypoint Platform to integrate live Microsoft Planner into custom reports and dashboards.
-
Build Apps with Live Kintone in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live Kintone into the Adalo platform and build custom mobile and web applications with real-time Kintone.
-
ETL Databricks in Oracle Data Integrator
This article shows how to transfer Databricks into a data warehouse using Oracle Data Integrator.
-
Connect to SAP ByDesign from Crystal Reports
Use CData Connect Cloud to connect to and report on live SAP Business ByDesign from Crystal Reports.
-
Analyze Xero in Looker
Use CData Connect Cloud to connect to Xero from Looker and build custom apps using live Xero Accounting.
-
Build Automated Workflows with Live Trello in Workato
Use CData Connect Cloud to connect to live Trello and build automated workflows in Workato.
-
Analyze Monday.com in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Monday.com and visualize Monday.com in SAP Analytics Cloud.
-
Import Real-Time Gmail via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Gmail in ColdFusion.
-
Publish CouchDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apache CouchDB.
-
Connect to SAP Concur as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live SAP Concur.
-
How to connect to Azure Active Directory from IntelliJ
Integrate connectivity to Azure Active Directory with wizards in IntelliJ.
-
A PostgreSQL Interface for WooCommerce (MySQL Remoting via JDBC)
Use the Remoting features of the WooCommerce JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to pipe Oracle SCM to CSV in PowerShell
Use standard PowerShell cmdlets to access Oracle SCM tables.
-
Connect to Klipfolio in RazorSQL
Connect to Klipfolio from wizards and query Klipfolio from the GUI in the RazorSQL database management tool.
-
Use Claude to Talk to Your eBay via CData Connect Cloud
Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your eBay for you.
-
Use Biml to Build SSIS Tasks to Replicate Printful to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Printful to SQL Server.
-
Creating Instagram-Connected Applications in Unqork
You can use CData Connect Cloud to feed Instagram to Unqork and build custom business apps.
-
Natively Connect to Dynamics 365 in PHP
The CData ODBC driver for Dynamics 365 enables you to create PHP applications with connectivity to Microsoft Dynamics 365. Leverage the native support for ODBC in PHP.
-
How to Use a Microsoft Access Database to Update Sage Cloud Accounting in Real Time
Update Sage Cloud Accounting data by creating a linked table in Microsoft Access with the CData Sage Cloud Accounting ODBC Driver.
-
Connect to Live Redshift in MicroStrategy through CData Connect Cloud
Create a live connection to Redshift in CData Connect Cloud and connect to your Amazon Redshift from MicroStrategy.
-
How to work with Reckon in Apache Spark using SQL
Access and process Reckon in Apache Spark using the CData Software JDBC Driver.
-
Access Phoenix 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 Apache Phoenix.
-
Import QuickBooks Time Using Azure Data Factory
Use CData Connect Cloud to connect to QuickBooks Time from Azure Data Factory and import live QuickBooks Time.
-
Object-Relational Mapping (ORM) with Bing Ads 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 Bing Ads into a Java-based ORM framework, Hibernate.
-
How to load SAP HANA XS Advanced data into Elasticsearch via Logstash
Introducing a simple method to load SAP HANA XS Advanced data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze JSON Services in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of JSON and visualize the live Services in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Work with Salesforce in AWS Glue Jobs Using JDBC
Connect to Salesforce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Airtable in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Airtable into the statistical analysis tools available in SAS JMP. This article shows how to use Airtable in the Graph Builder and Query Builder.
-
Analyze Paylocity in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Paylocity in Microsoft R Open.
-
Excel Spreadsheet Automation on Authorize.Net with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Build Azure Analysis Services-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Azure Analysis Services and build web apps with connectivity to live Azure Analysis Services.
-
Integrate Google Cloud Storage with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Cloud Storage with External Services.
-
How to connect to Oracle with Squirrel SQL client
Connect to Oracle Database and execute queries in the Squirrel SQL Client.
-
Analyze Google Analytics in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Google Analytics and visualize Google Analytics in SAP Analytics Cloud.
-
Build MVC Applications with Connectivity to Pipedrive
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Pipedrive from an ASP.NET MVC application.
-
Replicate Salesforce to Multiple Databases
Replicate Salesforce & Force.com to disparate databases with a point-and-click configuration.
-
Visualize Google Directory from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Directory.
-
Connect to and Visualize Live Microsoft Project in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Project.
-
DataBind Controls to SFTP in C++Builder
DataBind to SFTP in C++Builder with standard components and controls.
-
A PostgreSQL Interface for Klaviyo (MySQL Remoting via JDBC)
Use the Remoting features of the Klaviyo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for Smartsheet in Microsoft Power Query
You can use the CData Smartsheet ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Smartsheet into Microsoft Power Query.
-
How to Seamlessly Import QuickBooks Online Data into IBM SPSS Modeler
Integrate QuickBooks Online data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Rapidly Develop SAP SuccessFactors-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 Smartsheet 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 WordPress in the Denodo Platform
Use CData driver technologies to create a virtual data source for WordPress in the Denodo Virtual DataPort Administrator.
-
Natively Connect to JotForm in PHP
The CData ODBC driver for JotForm enables you to create PHP applications with connectivity to JotForm. Leverage the native support for ODBC in PHP.
-
Add SAP HANA XS Advanced to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP HANA XS Advanced with the Informatica Enterprise Data Catalog to classify and organize data.
-
Model DocuSign Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and DocuSign, enabling the direct import of real-time DocuSign.
-
Replicate Multiple GraphQL Accounts
Replicate multiple GraphQL accounts to one or many databases.
-
Process & Analyze Salesloft in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Salesloft .
-
Connect to GitHub from Filemaker Pro (Mac)
Use CData Connect Cloud to connect to and query live GitHub from Filemaker Pro on Mac.
-
Use the CData Software JDBC Driver for Active Directory in MicroStrategy
Connect to Active Directory in MicroStrategy Developer using the CData Software JDBC Driver for Active Directory.
-
How to integrate Metabase with SAP Concur
Use CData Connect Cloud to connect to live SAP Concur and create an interactive dashboard in Metabase from SAP Concur.
-
Establish a Live Connection with Snowflake using Tableau Bridge
The CData ODBC Driver for Snowflake enables you to integrate live Snowflake into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Sage Intacct-Connected Business Apps in AppSheet
Connect to Sage Intacct via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Sage Intacct.
-
Access Asana from MySQL in PHP
Connect to Asana through the standard MySQL libraries in PHP.
-
How to Connect to Drip in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Drip. Leverage the pyodbc module for ODBC in Python.
-
How to Access Live GraphQL in Power Automate Desktop via ODBC
The CData ODBC Driver for GraphQL enables you to integrate GraphQL into workflows built using Microsoft Power Automate Desktop.
-
Query Greenhouse through ODBC in Node.js
Use node-odbc to execute SQL queries against Greenhouse from Node.js.
-
Create Data Visualizations Based On WooCommerce in Mode
Use CData Connect Cloud to connect to WooCommerce from Mode and build visualizations using live
-
Bind Live GraphQL Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live GraphQL data
-
Create Informatica Mappings From/To an ODBC Data Source for HDFS
Create an ODBC connection to HDFS in Informatica and browse and transfer Apache HDFS.
-
Import Real-Time Teradata via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Teradata in ColdFusion.
-
Connect to Instagram from HeidiSQL
Use CData Connect Cloud to connect to and query live Instagram from HeidiSQL.
-
Create Reports from Amazon S3 in Looker Studio
Use CData Connect Cloud to gain access to live Amazon S3 and create custom reports in Looker Studio.
-
Visualize Live SAP Ariba Source in the Power BI Service
Use CData Connect Cloud to connect to live SAP Ariba Source and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous SharePoint Excel Services Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to IBM DB2.
-
Automated Continuous Power BI XMLA Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Apache Kafka.
-
Use Biml to Build SSIS Tasks to Replicate Calendly to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Calendly to SQL Server.
-
How to import Google Sheets into Apache Solr
Use the CData Software JDBC Driver for Google Sheets in Data Import Handler and create an automated import of Google Sheets to Apache Solr Enterprise Search platform.
-
Migrating data from Coinbase to Databricks using CData SSIS Components.
Easily push Coinbase to Databricks using the CData SSIS Tasks for Coinbase and Databricks.
-
Build Data Flows from SQL Server to SFTP through SSIS
Easily push SQL Server data to SFTP using the CData SSIS Tasks for SFTP.
-
Connect and Visualize Live Act CRM Data in Databricks Lakehouse Federation with CData Connect Cloud
Use CData Connect Cloud to integrate live Act CRM into the Databricks platform and create visualization dashboards with real-time Act CRM.
-
Build LDAP-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to LDAP and build web apps with connectivity to live LDAP.
-
Automated Continuous FHIR Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable FHIR replication to Azure SQL Database.
