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
-
How to create Visio diagrams from Acumatica
Automatically update Acumatica ERP with the changes you make to Visio master shapes.
-
Visualize Acumatica in Sisense
Create an ElastiCube in Sisense app with access to Acumatica ERP.
-
Connect to Splunk from a Connection Pool in Jetty
The Splunk JDBC Driver supports connection pooling: This article shows how to connect faster to Splunk from Web apps in Jetty.
-
Analyze Splunk in R via JDBC
Use standard R functions and the development environment of your choice to analyze Splunk with the CData JDBC Driver for Splunk.
-
Replicate Greenhouse from PowerShell
Write a quick PowerShell script to query Greenhouse. Use connectivity to the live data to replicate Greenhouse to SQL Server.
-
Creating Google Calendar-Connected Applications in Unqork
You can use CData Connect Cloud to feed Google Calendar to Unqork and build custom business apps.
-
Automated Continuous Zuora Replication to SingleStore
Use CData Sync for automated, continuous, customizable Zuora replication to SingleStore.
-
Use the CData Software JDBC Driver for Google Ads in MicroStrategy Desktop
Connect to Google Ads in MicroStrategy Desktop using the CData Software JDBC Driver for Google Ads.
-
Use the CData ODBC Driver for JotForm in Microsoft Power Query
You can use the CData JotForm ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import JotForm into Microsoft Power Query.
-
Access SingleStore as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SingleStore from your Oracle system.
-
Stream IBM Cloud Data Engine into Apache Kafka Topics
Access and stream IBM Cloud Data Engine in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData Software JDBC Driver for Cvent in MicroStrategy
Connect to Cvent in MicroStrategy Developer using the CData Software JDBC Driver for Cvent.
-
How to connect to Bullhorn CRM from Spring Boot
Connect to Bullhorn CRM in a Spring Boot Application using CData JDBC Bullhorn CRM Driver
-
Automated Continuous SAS xpt Replication to Oracle
Use CData Sync for automated, continuous, customizable SAS xpt replication to Oracle.
-
Model Smaregi Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Smaregi, enabling the direct import of real-time Smaregi.
-
Visualize SAP Netweaver Gateway in TIBCO Spotfire through OData
Integrate SAP Netweaver Gateway into dashboards in TIBCO Spotfire.
-
Create ActiveCampaign-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to ActiveCampaign from OutSystems and build custom enterprise apps using live ActiveCampaign.
-
DataBind Controls to Oracle SCM in Delphi
DataBind to Oracle SCM in Delphi with standard data access components and controls.
-
Automated Continuous Freshdesk Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Freshdesk replication to Amazon S3.
-
Bridge Aha Connectivity with Apache NiFi
Access and process Aha! in Apache NiFi using the CData JDBC Driver.
-
Connect to Tableau CRM Analytics in SpagoBI
Create reports featuring live Tableau CRM Analytics in SpagoBI Studio. Host Tableau CRM Analytics reports on SpagoBI Server.
-
Analyze Live BigQuery in SAS Viya
Use CData Connect Cloud to connect to Google BigQuery from SAS Viya and deploy self-service analytics using live Google BigQuery.
-
How to connect to WooCommerce in DBVisualizer
Integrate WooCommerce with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Dynamics 365 Business Central to Multiple Databases
Replicate Dynamics 365 Business Central to disparate databases with a point-and-click configuration.
-
Visualize Microsoft Teams in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Teams into TIBCO Spotfire.
-
Automated Continuous Zoho Creator Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Databricks.
-
How to import Spark into Apache Solr
Use the CData Software JDBC Driver for Spark in Data Import Handler and create an automated import of Apache Spark SQL to Apache Solr Enterprise Search platform.
-
Build a PostgreSQL Interface for Zoho CRM using the CData JDBC Driver
Use the Remoting features of the Zoho CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect the Power BI Service to eBay: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Deploy the ADO.NET Provider for Outreach.io on an SSRS Report Server
Connect to Outreach.io 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 TaxJar federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for TaxJar in MySQL .
-
Publish Reports with SFTP in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SFTP.
-
How to import Dynamics NAV into Apache Solr
Use the CData Software JDBC Driver for Dynamics NAV in Data Import Handler and create an automated import of Microsoft Dynamics NAV to Apache Solr Enterprise Search platform.
-
Connect to Monday.com from PowerBuilder via ADO.NET
This article demonstrates how to access Monday.com from Appeon PowerBuilder using the CData ADO.NET Provider for Monday.com.
-
Access Live Adobe Analytics in Google Sheets via Connect Cloud
Use CData Connect Cloud to gain access to live Adobe Analytics from your Google Sheets.
-
Integrate Cloudant in the Pentaho Report Designer
Publish reports based on IBM Cloudant in the Pentaho BI tool.
-
How to work with Azure DevOps in Apache Spark using SQL
Access and process Azure DevOps in Apache Spark using the CData Software JDBC Driver.
-
How to connect and process ClickUp from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ClickUp
-
Connect to SAP ByDesign in Jaspersoft Studio
Execute SQL to remote SAP Business ByDesign in Jaspersoft Studio.
-
Work with Live Zendesk in Power Query
Use CData Connect Cloud to connect to Zendesk and work with live Zendesk in Microsoft Power Query.
-
Automated Continuous Act CRM Replication to Databricks
Use CData Sync for automated, continuous, customizable Act CRM replication to Databricks.
-
Build Zoho Books-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to Zoho Books from Zoho Analytics and import live Zoho Books.
-
Connect to Snapchat Ads in Ruby
Connect to Snapchat Ads in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Import HarperDB into Microsoft Power Query
The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access HarperDB. In this article, you will use the OData format to import HarperDB into Microsoft Power Query.
-
Connect to Azure Active Directory from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Azure Active Directory to connect to Azure Active Directory and execute queries in PowerBuilder.
-
Stream HDFS into Apache Kafka Topics
Access and stream Apache HDFS in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData Software JDBC Driver for SAS Data Sets in MicroStrategy Desktop
Connect to SAS Data Sets in MicroStrategy Desktop using the CData Software JDBC Driver for SAS Data Sets.
-
Automated Continuous EventBrite Replication to SQL Server
Use CData Sync for automated, continuous, customizable EventBrite replication to SQL Server.
-
Replicate SAP Netweaver Gateway for Use in Salesforce Connect
Replicate SAP Netweaver Gateway to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Query EventBrite in MySQL Workbench
Execute MySQL queries against live Eventbrite from MySQL Workbench.
-
Import Jira into FileMaker Pro
Create reports that integrate Atlassian Jira in Filemaker Pro.
-
Integrate with Live MySQL in MuleSoft (via CData Connect Cloud)
Use CData Connect Cloud to connect to MySQL from the MuleSoft Anypoint Platform to integrate live MySQL into custom reports and dashboards.
-
Model, Search, and Visualize Live AlloyDB in ThoughtSpot
Use CData Connect Cloud to connect to live Google AlloyDB for modeling, searching, and visualizing.
-
Visualize Zoho Creator in TIBCO Spotfire through OData
Integrate Zoho Creator into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for SAP Netweaver Gateway in MicroStrategy
Connect to SAP Netweaver Gateway in MicroStrategy Developer using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
Query PingOne in ColdFusion
Write standard ColdFusion data access code to connect to PingOne.
-
Import Real-Time SAS xpt via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAS XPORT in ColdFusion.
-
Replicate Multiple Avalara AvaTax Accounts
Replicate multiple Avalara AvaTax accounts to one or many databases.
-
Use the CData Software JDBC Driver for Salesforce Marketing in MicroStrategy Web
Connect to Salesforce Marketing Cloud in MicroStrategy Web using the CData Software JDBC Driver for Salesforce Marketing.
-
Create Google Ads 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 Bing Ads in Aqua Data Studio
Access Bing Ads from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Natively Connect to ADP in PHP
The CData ODBC driver for ADP enables you to create PHP applications with connectivity to ADP. Leverage the native support for ODBC in PHP.
-
Automated Continuous SAP Netweaver Gateway Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to PostgreSQL.
-
Analyze IBM Cloud Object Storage with Power Pivot
This article walks you through the process of using the CData ODBC Driver for IBM Cloud Object Storage from Power Pivot. You will use the Table Import Wizard to load IBM Cloud Object Storage. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Cvent in NetBeans
Connect to Cvent in NetBeans with the data source configuration wizard.
-
Using the CData Software ODBC Driver for Zoho Inventory in PyCharm
Connect to Zoho Inventory as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoho Inventory.
-
Explore Geographical Relationships in Snapchat Ads with Power Map
Create data visualizations with Snapchat Ads in Power Map.
-
Visualize Live IBM Informix in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live IBM Informix.
-
Access Highrise from MySQL in PHP
Connect to Highrise through the standard MySQL libraries in PHP.
-
Using AngularJS to Build Dynamic Web Pages with Paylocity
Use the CData Connect Server to create Paylocity OData feeds and build single-page applications with live Paylocity.
-
Use the CData SSIS Components to Insert New or Update Existing LinkedIn Records from SQL Server
Easily push SQL Server data to LinkedIn using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into LinkedIn or update existing records with data from a SQL Server database.
-
Use the CData Software JDBC Driver for Active Directory in MicroStrategy Web
Connect to Active Directory in MicroStrategy Web using the CData Software JDBC Driver for Active Directory.
-
Prepare, Blend, and Analyze Xero in Alteryx Designer (ODBC)
Build workflows to access live Xero Accounting for self-service data analytics.
-
Import Sybase IQ into the Power BI Service for Visualizations
Use CData Software Connect Server to create an OData feed for Sybase IQ and create custom reports in the Power BI Service.
-
Integrate with Active Directory using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Active Directory to a JSON file on disk.
-
Automated Continuous Procore Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Procore replication to AlloyDB.
-
How to Visualize Pinterest Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pinterest in Python.
-
Visualize Google Data Catalog in Tableau
The CData ODBC driver for Google Data Catalog enables you integrate Google Data Catalog into Tableau dashboards.
-
How to Access HDFS Using Entity Framework
This article shows how to access Apache HDFS using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Import Aha into FileMaker Pro
Create reports that integrate Aha! in Filemaker Pro.
-
Automated Continuous HBase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable HBase replication to Google BigQuery.
-
Connect to Office 365 in RazorSQL
Connect to Office 365 from wizards and query Microsoft Office 365 from the GUI in the RazorSQL database management tool.
-
Connect to Sage Cloud Accounting in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Sage Cloud Accounting and connect to Sage Business Cloud Accounting in Akorbi Digital RunMyProcess.
-
Access Live Dynamics CRM in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Dynamics CRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Microsoft Project in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft Project.
-
Bridge SAP SuccessFactors Connectivity with Apache NiFi
Access and process SAP SuccessFactors in Apache NiFi using the CData JDBC Driver.
-
How to use SQLAlchemy ORM to access Twitter in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Twitter.
-
Integrate Act CRM into Automated Tasks with Power Automate
Use CData Connect Cloud to connect to Act CRM and integrate live Act CRM into your Power Automate tasks.
-
Viewing ADP in RAD Studio Data Explorer
How to view ADP in RAD Studio Data Explorer using the CData ODBC Driver for ADP.
-
Build Dashboards with MarkLogic in Dundas BI
Create dynamic dashboards and perform analytics based on MarkLogic in Dundas BI.
-
How to connect PolyBase to Certinia
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Certinia.
-
How to create Kintone federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Kintone in MySQL .
-
Visualize Live LDAP Objects in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LDAP.
-
Integrate Live Avalara AvaTax into Blue Prism for Intelligent Robotic Process Automation (RPA)
-