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
-
Visualize Live SAP Business One in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live SAP Business One into custom reports in Power BI.
-
DataBind Charts to Google Analytics
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Analytics 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.
-
A PostgreSQL Interface for Avalara AvaTax using the CData ODBC Driver
Use the SQL Gateway and Avalara AvaTax ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Power BI Reports on Real-Time ConstantContact
Use the CData ODBC Driver for ConstantContact to visualize ConstantContact in Power BI Desktop.
-
Connect to Dynamics NAV in Google Apps Script via SQL Gateway
Use the ODBC Driver for Dynamics NAV and the SQL Gateway to access Microsoft Dynamics NAV from Google Apps Script.
-
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.
-
Create Data Visualizations Based On eBay in Mode
Use CData Connect Cloud to connect to eBay from Mode and build visualizations using live
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho CRM
Provide connectivity to Zoho CRM through an SAP BusinessObjects universe.
-
Creating SAP HANA-Connected Applications in Unqork
You can use CData Connect Cloud to feed SAP HANA to Unqork and build custom business apps.
-
Query Google Calendars, Contacts, and Documents from PowerShell
Are you looking for a quick and easy way to access Google Drive and other Google Apps from PowerShell? The CData Google Apps Data Provider provides an easy-to-use ADO.NET interface that you can take advantage of from your PowerShell scripts. The provider simplifies authentication and interaction with Google Apps. Simply use the included .NET objects in your PowerShell scripts to connect to your Google Apps accounts and synchronize, automate, download, and more!
-
Create Informatica Mappings From/To an ODBC Data Source for Spark
Create an ODBC connection to Spark in Informatica and browse and transfer Apache Spark SQL.
-
Connect to Klaviyo as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Klaviyo.
-
Access Jira Assets from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Jira Assets from HeidiSQL.
-
How to import SAP ByDesign into Apache Solr
Use the CData Software JDBC Driver for SAP ByDesign in Data Import Handler and create an automated import of SAP Business ByDesign to Apache Solr Enterprise Search platform.
-
Explore Geographical Relationships in ServiceNow with Power Map
Create data visualizations with ServiceNow in Power Map.
-
Create Snapchat Ads-Connected Dashboards in Grafana
Connect to Snapchat Ads via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Snapchat Ads.
-
Visualize Zuora in Sisense
Create an ElastiCube in Sisense app with access to Zuora.
-
Configure the CData JDBC Driver for Facebook in a Connection Pool in Tomcat
Connect to Facebook from a connection pool in Tomcat.
-
Connect to Bing Ads from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Bing Ads using standard SQL.
-
How to work with SAP Netweaver Gateway in Apache Spark using SQL
Access and process SAP Netweaver Gateway in Apache Spark using the CData Software JDBC Driver.
-
How to Query Aha in MySQL Workbench
Execute MySQL queries against live Aha! from MySQL Workbench.
-
View Reports on Real-Time QuickBooks Online in Power BI Report Server
Use the CData ODBC Driver for QuickBooks Online to visualize QuickBooks Online in Power BI Desktop and then publish them to Power BI Report Server.
-
Seamlessly Bring Zoho Creator into Retool Using CData Connect Cloud
Integrate Zoho Creator data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
-
Automate CouchDB Replication to Couchbase
Use CData Sync to Customize and automate Apache CouchDB replication to Couchbase.
-
Bind Live Email Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Email data
-
Analyze Paylocity in R via JDBC
Use standard R functions and the development environment of your choice to analyze Paylocity with the CData JDBC Driver for Paylocity.
-
Work with Google Sheets in FoxPro
Load Google Sheets into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Oracle HCM Cloud-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live Oracle HCM Cloud and build Oracle HCM Cloud-connected web apps with Axios.
-
Automate Monday.com Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Monday.com from PowerShell? This article demonstrates how to utilize the Monday.com Cmdlets for tasks like connecting to Monday.com, automating operations, downloading data, and more.
-
Import Real-Time CSV via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use CSV/TSV Files in ColdFusion.
-
Build Data Flows from Amazon Marketplace to SQL Server using SSIS
Easily back up Amazon Marketplace to SQL Server using the SSIS components for Amazon Marketplace.
-
Automated Continuous JotForm Replication to Amazon S3
Use CData Sync for automated, continuous, customizable JotForm replication to Amazon S3.
-
Automated Continuous HDFS Replication to SingleStore
Use CData Sync for automated, continuous, customizable HDFS replication to SingleStore.
-
Connect to SingleStore in Google Apps Script via Connect Cloud
Use CData Connect Cloud to access SingleStore in Google Apps Script.
-
Connect to Dynamics 365 Business Central in RapidMiner
Integrate Dynamics 365 Business Central with standard components and data source configuration wizards in RapidMiner Studio.
-
Use CData Connect Cloud to Access Paylocity in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Paylocity in the Power Pivot business intelligence tool.
-
Analyze Live MariaDB in SAS Viya
Use CData Connect Cloud to connect to MariaDB from SAS Viya and deploy self-service analytics using live MariaDB.
-
Use the CData Software JDBC Driver for Shopify in MicroStrategy
Connect to Shopify in MicroStrategy Developer using the CData Software JDBC Driver for Shopify.
-
How to connect to Teradata with Squirrel SQL client
Connect to Teradata and execute queries in the Squirrel SQL Client.
-
How to Connect to SAS xpt in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAS XPORT. Leverage the pyodbc module for ODBC in Python.
-
Access Live Instagram Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Instagram data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Stream Jira Service Management into Apache Kafka Topics
Access and stream Atlassian Jira Service Management in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Data Flows from SAP ByDesign to SQL Server using SSIS
Easily back up SAP Business ByDesign to SQL Server using the SSIS components for SAP ByDesign.
-
Visualize Salesloft in Sisense
Create an ElastiCube in Sisense app with access to Salesloft.
-
Integrate Okta in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Okta from Informatica Cloud.
-
Automated Continuous SurveyMonkey Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Google Cloud SQL.
-
Automate Smartsheet Replication to Azure Synapse
Use CData Sync to customize and automate Smartsheet replication to Azure Synapse.
-
Build Dashboards with Redshift in DBxtra
Create dynamic dashboards and perform analytics based on Amazon Redshift in DBxtra.
-
Analyze Yahoo! Japan Data Solution in Cognos Analytics
Use CData Connect Cloud to connect to Yahoo! Japan Data Solution from Cognos Analytics and analyze live Yahoo! Japan Data Solution.
-
How to Easily Query MailChimp in OpenOffice Base
-
