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 Zoho Creator as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoho Creator.
-
Automated Continuous Act-On Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Act-On replication to Apache Cassandra.
-
Connect to Avalara AvaTax from a Connection Pool in WebLogic
Use the CData JDBC Driver for Avalara AvaTax to connect to Avalara AvaTax from Web applications running on WebLogic.
-
Prepare, Blend, and Analyze Oracle Sales in Alteryx Designer (ODBC)
Build workflows to access live Oracle Sales for self-service data analytics.
-
Integrate PCA Sales into Automated Tasks with Power Automate
Use CData Connect Cloud to connect to PCA Sales and integrate live PCA Sales into your Power Automate tasks.
-
Access Live Trello in AWS Lambda
Connect to live Trello in AWS Lambda using the CData JDBC Driver.
-
Connect to Redis in Google Apps Script via Connect Cloud
Use CData Connect Cloud to access Redis in Google Apps Script.
-
How to create Visio diagrams from SingleStore
Automatically update SingleStore with the changes you make to Visio master shapes.
-
Working with Gmail in LINQPad
Execute LINQ queries to Gmail in LINQPad.
-
Use the CData Software JDBC Driver for Zoho Inventory in MicroStrategy Desktop
Connect to Zoho Inventory in MicroStrategy Desktop using the CData Software JDBC Driver for Zoho Inventory.
-
Build Automated Veeva Vault-Connected Workflows in Zapier
Use CData Connect Cloud to connect to live Veeva Vault & Vault CRM and build automated workflows in Zapier.
-
How to Visualize JotForm Data in Python with pandas
Use pandas and other modules to analyze and visualize live JotForm in Python.
-
Operational Reporting on Zoho Creator from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zoho Creator.
-
How to connect to SAP ByDesign from IntelliJ
Integrate connectivity to SAP Business ByDesign with wizards in IntelliJ.
-
Analyze HubSpot in R via JDBC
Use standard R functions and the development environment of your choice to analyze HubSpot with the CData JDBC Driver for HubSpot.
-
Operational Reporting on Twitter from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Twitter.
-
Connect to Facebook Ads from a Connection Pool in JBoss
Integrate Facebook Ads into Java servlets: Use the Management Console in JBoss to install the Facebook Ads JDBC Driver.
-
Using the CData Software ODBC Driver for YouTube Analytics in PyCharm
Connect to YouTube Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for YouTube Analytics.
-
Visualize Twitter from Tableau
Use the Tableau Desktop business intelligence tool to connect to Twitter.
-
Build Bing Search-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Bing Search and build web apps with connectivity to live Bing Search.
-
DataBind Wijmo Grid to SAP SuccessFactors
Provide real-time SAP SuccessFactors to interactive controls.
-
Automate Unbounce Replication to Couchbase
Use CData Sync to Customize and automate Unbounce replication to Couchbase.
-
How to Query Reckon in MySQL Workbench
Execute MySQL queries against live Reckon from MySQL Workbench.
-
Connect to Impala from HeidiSQL
Use CData Connect Cloud to connect to and query live Apache Impala from HeidiSQL.
-
Import Google Data Catalog into the Power BI Service for Visualizations
Use CData Software Connect Server to create an OData feed for Google Data Catalog and create custom reports in the Power BI Service.
-
Integrate Google Contacts with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Contacts with External Services.
-
Create Act-On-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to Act-On from OutSystems and build custom enterprise apps using live Act-On.
-
Easily Integrate Azure Data Lake Storage in Lazarus Pascal IDE
Learn how to easily integrate live Azure Data Lake Storage in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Kintone in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software ODBC Driver for Adobe Commerce in MicroStrategy
Connect to Adobe Commerce in MicroStrategy Developer using the CData Software ODBC Driver for Adobe Commerce.
-
Using the CData Software ODBC Driver for IBM Cloud Data Engine in PyCharm
Connect to IBM Cloud Data Engine as an ODBC data source in PyCharm using the CData Software ODBC Driver for IBM Cloud Data Engine.
-
Use the CData Software JDBC Driver for Coinbase in MicroStrategy Desktop
Connect to Coinbase in MicroStrategy Desktop using the CData Software JDBC Driver for Coinbase.
-
How to work with SAP HANA XS Advanced in Apache Spark using SQL
Access and process SAP HANA XS Advanced in Apache Spark using the CData Software JDBC Driver.
-
How to connect to WooCommerce from IntelliJ
Integrate connectivity to WooCommerce with wizards in IntelliJ.
-
Connect to Raisers Edge NXT as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Raisers Edge NXT.
-
How to Build Dynamic React Apps with Azure Synapse
Use the CData Connect and React to Build Dynamic Web Apps with Live Azure Synapse .
-
Integrate with SAP Hybris C4C in SnapLogic
Use CData Connect Cloud to connect to and integrate with live SAP Hybris C4C in SnapLogic.
-
Create NetSuite-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to NetSuite from Klipfolio and build custom visualizations using live NetSuite CRM & ERP.
-
Build Semantic Layer Views for BigQuery in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Google BigQuery.
-
How to connect to Zuora from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Zuora and work with Zuora in Microsoft Excel on Mac OS X.
-
Automated Continuous Basecamp Replication to Snowflake
Use CData Sync for automated, continuous, customizable Basecamp replication to Snowflake.
-
Integrate Live BigQuery into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to BigQuery from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google BigQuery.
-
Query Sage Cloud Accounting in MySQL Workbench
Create a virtual MySQL database for Sage Business Cloud Accounting in CData Software Connect (or Connect Server) and work with live Sage Business Cloud Accounting in MySQL Workbench.
-
DataBind Wijmo Grid to Amazon S3
Provide real-time Amazon S3 to interactive controls.
-
Build Semantic Layer Views for MarkLogic in APOS Live Data Gateway
Use the CData Connector for MarkLogic in APOS Live Data Gateway to build Semantic Layer Views for MarkLogic.
-
Enable the ConstantContact JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ConstantContact.
-
Analyze Google Spanner in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Spanner with the CData JDBC Driver for Google Spanner.
-
Connect to Authorize.Net in Jaspersoft Studio
Execute SQL to remote Authorize.Net in Jaspersoft Studio.
-
Easily Integrate Twitter Ads in Lazarus Pascal IDE
Learn how to easily integrate live Twitter Ads in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create JSON Dashboards in Bold BI
Use CData Software Connect Server to create a virtual SQL Server Database for JSON to build custom dashboards in Bold BI.
-
PowerShell Scripting to Replicate Calendly to MySQL
Write a simple PowerShell script to replicate Calendly to a MySQL database.
-
Automated Continuous Zoho CRM Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Databricks.
-
Build Semantic Layer Views for eBay in APOS Live Data Gateway
Use the CData Connector for eBay in APOS Live Data Gateway to build Semantic Layer Views for eBay.
-
Natively Connect to Dynamics GP in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Dynamics GP. Leverage the native support for ODBC in PHP.
-
How to Build Dynamic React Apps with Dynamics 365 Business Central
Use the CData Connect and React to Build Dynamic Web Apps with Live Dynamics 365 Business Central .
-
Add Salesforce to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Salesforce with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect to Wave Financial with Squirrel SQL client
Connect to Wave Financial and execute queries in the Squirrel SQL Client.
-
Automated Continuous Epicor Kinetic Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Microsoft Access.
-
Import Real-Time Redshift via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Amazon Redshift in ColdFusion.
-
Connect to Acumatica from a Connection Pool in WebLogic
Use the CData JDBC Driver for Acumatica to connect to Acumatica ERP from Web applications running on WebLogic.
-
How to connect to Databricks in DBVisualizer
Integrate Databricks with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Quickbase-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live Quickbase and build Quickbase-connected web apps with Axios.
-
Use CData Connect Cloud to Access Outreach.io in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Outreach.io in the Power Pivot business intelligence tool.
-
Create Reports with Google Calendar in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Calendar.
-
Automated Continuous Sage Cloud Accounting Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to SingleStore.
-
Stream Cloudant into Apache Kafka Topics
Access and stream IBM Cloudant in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Azure Data Catalog Replication to Vertica
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Vertica.
-
How to Connect to Cloudant in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to IBM Cloudant. Leverage the pyodbc module for ODBC in Python.
-
A PostgreSQL Interface for Google Campaign Manager 360 using the CData ODBC Driver
Use the SQL Gateway and Google Campaign Manager 360 ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Live WooCommerce in SAS Viya
Use CData Connect Cloud to connect to WooCommerce from SAS Viya and deploy self-service analytics using live WooCommerce.
-
How to use SQLAlchemy ORM to access Azure Analysis Services in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Analysis Services.
-
Access Live GitHub in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate GitHub into the statistical analysis tools available in SAS JMP. This article shows how to use GitHub in the Graph Builder and Query Builder.
-
Process & Analyze GitHub in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live GitHub .
-
Create Zoho Books Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zoho Books data access from reports, embedded analytics, and more.
-
Connect to SendGrid in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for SendGrid in Airbyte.
-
Visualize Cassandra in Sisense
Create an ElastiCube in Sisense app with access to Apache Cassandra.
-
Integrate with Box in JReport Designer
Create charts and reports based on Box in JReport Designer.
-
DataBind Charts to Zoom
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoom 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.
-
Connect to SAS xpt from a Connection Pool in JBoss
Integrate SAS XPORT into Java servlets: Use the Management Console in JBoss to install the SAS xpt JDBC Driver.
-
Automated Continuous Drip Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Drip replication to Google Cloud SQL.
-
How to connect and process Zenefits from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zenefits
-
How to create an RPA flow for CouchDB in UiPath Studio
Use the CouchDB ODBC Driver to create workflows that access real-time Apache CouchDB without any coding.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Salesforce Marketing
Provide connectivity to Salesforce Marketing Cloud through an SAP BusinessObjects universe.
-
Integrate ActiveCampaign in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ActiveCampaign from Informatica Cloud.
-
How to Connect the Power BI Service to Microsoft Exchange: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Integrate with Live Google Analytics in MuleSoft (via CData Connect Cloud)
Use CData Connect Cloud to connect to Google Analytics from the MuleSoft Anypoint Platform to integrate live Google Analytics into custom reports and dashboards.
-
Manage Tableau CRM Analytics in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Tableau CRM Analytics.
-
Connect to Wave Financial as an External Source in Dremio
Use the CData JDBC Driver to connect to Wave Financial as an External Source in Dremio.
-
Connect to Sage Intacct in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Sage Intacct and connect to Sage Intacct in Akorbi Digital RunMyProcess.
-
Query SuiteCRM as a MySQL Database in Node.js
Execute MySQL queries against SuiteCRM from Node.js.
-
Access IBM Cloud Object Storage in PHP through Connect Server
Connect to IBM Cloud Object Storage through the standard SQL Server libraries in PHP.
-
A PostgreSQL Interface for Snowflake using the CData ODBC Driver
Use the SQL Gateway and Snowflake ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to SuiteCRM from Google Apps Script
Use CData Software Connect Server to access SuiteCRM in Google Apps Script.
-
Bidirectional Access to Jira from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Atlassian Jira in Filemaker Pro for Mac or Windows.
-
Import Zuora Using Azure Data Factory
Use CData Connect Cloud to connect to Zuora from Azure Data Factory and import live Zuora.
-
Automated Continuous Microsoft Planner Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to MongoDB.
-
Automated Continuous Smartsheet Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Smartsheet replication to AlloyDB.
-
Prepare, Blend, and Analyze Redshift in Alteryx Designer (ODBC)
Build workflows to access live Amazon Redshift for self-service data analytics.
-
Add Pipedrive to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Pipedrive with the Informatica Enterprise Data Catalog to classify and organize data.
-
ETL AlloyDB in Oracle Data Integrator
This article shows how to transfer Google AlloyDB into a data warehouse using Oracle Data Integrator.