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
-
Access Bing Search Results from MySQL in PHP
Connect to Bing Search through the standard MySQL libraries in PHP.
-
PowerShell Scripting to Replicate Oracle HCM Cloud to MySQL
Write a simple PowerShell script to replicate Oracle HCM Cloud to a MySQL database.
-
Back Up Authorize.Net to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Authorize.Net. In this article, we will employ an SSIS workflow to populate a database with Authorize.Net data.
-
View Reports on Real-Time OData Services in Power BI Report Server
Use the CData ODBC Driver for OData to visualize OData in Power BI Desktop and then publish them to Power BI Report Server.
-
Natively Connect to Raisers Edge NXT in PHP
The CData ODBC driver for Raisers Edge NXT enables you to create PHP applications with connectivity to Raisers Edge NXT. Leverage the native support for ODBC in PHP.
-
Connect to Amazon Athena in RazorSQL
Connect to Amazon Athena from wizards and query Amazon Athena from the GUI in the RazorSQL database management tool.
-
Connect to Google Ads from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Ads, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live HubSpot in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to HubSpot from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Oracle Sales in PHP through Connect Server
Connect to Oracle Sales through the standard SQL Server libraries in PHP.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Harvest
Provide connectivity to Harvest through an SAP BusinessObjects universe.
-
How to Access Live Cloudant in Power Automate Desktop via ODBC
The CData ODBC Driver for Cloudant enables you to integrate IBM Cloudant into workflows built using Microsoft Power Automate Desktop.
-
ETL Paylocity in Oracle Data Integrator
This article shows how to transfer Paylocity into a data warehouse using Oracle Data Integrator.
-
Using AngularJS to Build Dynamic Web Pages with ADP
Use the CData Connect Server to create ADP OData feeds and build single-page applications with live ADP.
-
Build Apps with Live MailChimp in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live MailChimp into the Adalo platform and build custom mobile and web applications with real-time MailChimp.
-
Access Live OData Services in Excel (Desktop) via Connect Cloud
Use CData Connect Cloud to gain access to live OData from your Excel spreadsheets.
-
Integrate with Microsoft Exchange in JReport Designer
Create charts and reports based on Microsoft Exchange in JReport Designer.
-
Analyze SAP in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP ERP/NetWeaver in Microsoft R Open.
-
Prepare, Blend, and Analyze Excel in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Excel for self-service data analytics.
-
Write a Simple Go Application to work with Trello on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Trello.
-
Connect to and Query Shippo in QlikView over ODBC
Create data visualizations with Shippo in QlikView.
-
How to Build an ETL App for Calendly in Python with CData
Create ETL applications and real-time data pipelines for Calendly in Python with petl.
-
Visualize HCL Domino in Tableau
The CData ODBC driver for HCL Domino enables you integrate HCL Domino into Tableau dashboards.
-
How to integrate QuickBooks with Apache Airflow
Access and process QuickBooks Desktop in Apache Airflow using the CData JDBC Driver.
-
Create Todoist Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Todoist data access from reports, embedded analytics, and more.
-
Enable the Active Directory JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Active Directory.
-
Connect to Parquet from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Apache Parquet using standard SQL.
-
Prepare, Blend, and Analyze Asana in Alteryx Designer (ODBC)
Build workflows to access live Asana for self-service data analytics.
-
Create Apps from Drip in Qlik Sense Cloud
Use the CData Connect Server to create an OData API for Drip and build apps from live Drip in Qlik Sense Cloud.
-
Model Odoo Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Odoo, enabling the direct import of real-time Odoo ERP.
-
Access Azure DevOps from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Azure DevOps from HeidiSQL.
-
Connect to Live Excel Online in PostGresSQL Interface through CData Connect Cloud
Create a live connection to Excel Online in CData Connect Cloud and connect to your Microsoft Excel Online from PostgreSQL.
-
Connect to Zuora in CloverDX (formerly CloverETL)
Transfer Zuora using the visual workflow in the CloverDX data integration tool.
-
ETL OneNote in Oracle Data Integrator
This article shows how to transfer Microsoft OneNote into a data warehouse using Oracle Data Integrator.
-
Rapidly Develop Klaviyo-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 an SAP BusinessObjects Universe on the CData ODBC Driver for SFTP
Provide connectivity to SFTP through an SAP BusinessObjects universe.
-
Integrate with live BCart in Jitterbit
Use CData Connect Cloud to connect to and integrate live BCart in Jitterbit.
-
Build Semantic Layer Views for Avro in APOS Live Data Gateway
Use the CData Connector for Avro in APOS Live Data Gateway to build Semantic Layer Views for Apache Avro.
-
How to import Facebook into Apache Solr
Use the CData Software JDBC Driver for Facebook in Data Import Handler and create an automated import of Facebook to Apache Solr Enterprise Search platform.
-
Bidirectional Access to eBay Analytics from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate eBay Analytics in Filemaker Pro for Mac or Windows.
-
How to Connect to & Open BigQuery in Microsoft Excel
This article uses the CData ODBC driver for BigQuery to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Oracle Eloqua in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Using AngularJS to Build Dynamic Web Pages with Epicor Kinetic
Use the CData Connect Server to create Epicor Kinetic OData feeds and build single-page applications with live Epicor Kinetic.
-
Automated Continuous EventBrite Replication to MongoDB
Use CData Sync for automated, continuous, customizable EventBrite replication to MongoDB.
-
Bidirectional Access to NetSuite from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate NetSuite CRM & ERP in Filemaker Pro for Mac or Windows.
-
Automated Continuous Hive Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Hive replication to Amazon S3.
-
Use the CData ODBC Driver for Google Contacts from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Contacts to connect to Google Contacts from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Contacts in Excel.
-
Use the CData Software ODBC Driver for Printify in MicroStrategy
Connect to Printify in MicroStrategy Developer using the CData Software ODBC Driver for Printify.
-
Query BambooHR as a MySQL Database in Node.js
Execute MySQL queries against BambooHR from Node.js.
-
Automated Continuous Dynamics 365 Business Central Replication to MongoDB
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to MongoDB.
-
Connect to Twilio in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for Twilio in Airbyte.
-
Connect to Real-Time SAS xpt Data in Power Apps Using Dataflows to Build Custom Applications
-
