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 Connect to & Open Amazon Marketplace in Microsoft Excel
This article uses the CData ODBC driver for Amazon Marketplace to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous ShipStation Replication to Vertica
Use CData Sync for automated, continuous, customizable ShipStation replication to Vertica.
-
Build Yahoo! Ads-Connected Apps in Bubble
Use CData Connect Cloud to create an OData feed for Yahoo! Ads and create custom apps in Bubble.
-
Analyze Quickbase in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Quickbase and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Elasticsearch Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Azure SQL Database.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SQL Analysis Services
Provide connectivity to SQL Analysis Services through an SAP BusinessObjects universe.
-
How to connect PolyBase to Google Calendar
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Calendar.
-
How to pipe Reckon to CSV in PowerShell
Use standard PowerShell cmdlets to access Reckon tables.
-
Create Power BI Reports on Real-Time HDFS
Use the CData ODBC Driver for HDFS to visualize Apache HDFS in Power BI Desktop.
-
How to create Box federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Box in MySQL .
-
Using the CData Software ODBC Driver for xBase in PyCharm
Connect to xBase as an ODBC data source in PyCharm using the CData Software ODBC Driver for xBase.
-
Bridge Typeform Connectivity with Apache NiFi
Access and process Typeform in Apache NiFi using the CData JDBC Driver.
-
Connect to Airtable as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Airtable.
-
Manage Azure Active Directory in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Azure Active Directory.
-
How to Connect DBeaver to Certinia via a JDBC Driver
Manage Certinia with visual tools in DBeaver like the query browser.
-
Integrate Live Slack into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Slack from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Slack.
-
Load WordPress to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load WordPress to a database.
-
Connect to Greenplum in NetBeans
Connect to Pivotal GreenPlum in NetBeans with the data source configuration wizard.
-
Trigger MySQL IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Build SendGrid-Connected Apps in Choreo
Use CData Connect Cloud to connect to SendGrid from Choreo and build custom apps using live SendGrid.
-
Connect to Reckon from Filemaker Pro (Mac)
Use CData Connect Cloud to connect to and query live Reckon from Filemaker Pro on Mac.
-
Visualize Avro in TIBCO Spotfire through OData
Integrate Apache Avro into dashboards in TIBCO Spotfire.
-
How to Query CouchDB in MySQL Workbench
Execute MySQL queries against live Apache CouchDB from MySQL Workbench.
-
View Reports on Real-Time SAP HANA XS Advanced in Power BI Report Server
Use the CData ODBC Driver for SAP HANA XS Advanced to visualize SAP HANA XS Advanced in Power BI Desktop and then publish them to Power BI Report Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zendesk
Provide connectivity to Zendesk through an SAP BusinessObjects universe.
-
Access Live Sage 50 UK in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sage 50 UK into the statistical analysis tools available in SAS JMP. This article shows how to use Sage 50 UK in the Graph Builder and Query Builder.
-
Visualize Live SAP Ariba Source of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Ariba Source using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Excel 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 Excel into TIBCO Spotfire.
-
Connect to Tableau CRM Analytics from HeidiSQL
Use CData Connect Cloud to connect to and query live Tableau CRM Analytics from HeidiSQL.
-
Rapidly Develop WordPress-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.
-
How to pipe Zoho Creator to CSV in PowerShell
Use standard PowerShell cmdlets to access Zoho Creator tables.
-
Use Dash to Build to Web Apps on Teradata
Create Python applications that use pandas and Dash to build Teradata-connected web apps.
-
How to load Microsoft Planner data into Elasticsearch via Logstash
Introducing a simple method to load Microsoft Planner data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to create Visio diagrams from Zoho CRM
Automatically update Zoho CRM with the changes you make to Visio master shapes.
-
Access Live Cassandra in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Cassandra from your Google Sheets.
-
Use the CData SSIS Components to Insert New or Update Existing MySQL Records from SQL Server
Easily push SQL Server data to MySQL using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into MySQL or update existing records with data from a SQL Server database.
-
How to connect to Sybase IQ from IntelliJ
Integrate connectivity to Sybase IQ with wizards in IntelliJ.
-
Access Live Google Sheets in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Sheets in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to FHIR as an External Source in Dremio
Use the CData JDBC Driver to connect to FHIR as an External Source in Dremio.
-
Analyze Slack with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Slack from Power Pivot. You will use the Table Import Wizard to load Slack. You can visually build the import query or use any SQL supported by the driver.
-
Feed Bullhorn CRM into FineReport
How to set Bullhorn CRM as a JDBC data source in FineReport.
-
How to work with ADP in Apache Spark using SQL
Access and process ADP in Apache Spark using the CData Software JDBC Driver.
-
Import Real-Time Snowflake via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Snowflake in ColdFusion.
-
DataBind Controls to Microsoft OneDrive in C++Builder
DataBind to Microsoft OneDrive in C++Builder with standard components and controls.
-
ETL Redshift in Oracle Data Integrator
This article shows how to transfer Amazon Redshift into a data warehouse using Oracle Data Integrator.
-
Integrate Live Facebook into Blue Prism for Intelligent Robotic Process Automation (RPA)
-
