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 Power BI Visual Reports with Real-Time Microsoft Exchange
Use CData Power BI Connectors to visualize Microsoft Exchange in Power BI.
-
Build Automated Workflows with Live ServiceNow in Workato
Use CData Connect Cloud to connect to live ServiceNow and build automated workflows in Workato.
-
Integrate Bing Search Results into Power Automate Desktop using CData Connect
CData Connect for Bing Search Results enables you to integrate Bing Search into workflows built using Microsoft Power Automate Desktop.
-
Import Zoom into Microsoft Power Query
The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Zoom. In this article, you will use the OData format to import Zoom into Microsoft Power Query.
-
Access Workday from MySQL in Amazon QuickSight
Connect to Workday and build visualizations of Workday using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous REST Replication to Databricks
Use CData Sync for automated, continuous, customizable REST replication to Databricks.
-
Explore Geographical Relationships in Bitbucket with Power Map
Create data visualizations with Bitbucket in Power Map.
-
Integrate Live Box into Custom Business Apps Built in Power Apps
Use CData Software Connect Server to create a virtual SQL Server Database for Box and integrate live Box into apps built in Microsoft Power Apps.
-
Automate Outreach.io Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Outreach.io from PowerShell? This article demonstrates how to utilize the Outreach.io Cmdlets for tasks like connecting to Outreach.io, automating operations, downloading data, and more.
-
Automated Continuous SAP Ariba Source Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to SQLite.
-
Connect to Bitbucket in Aqua Data Studio
Access Bitbucket from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Avro in PHP through Connect Server
Connect to Avro through the standard SQL Server libraries in PHP.
-
Automated Continuous Azure DevOps Replication to Snowflake
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Snowflake.
-
Build Semantic Layer Views for ClickUp in APOS Live Data Gateway
Use the CData Connector for ClickUp in APOS Live Data Gateway to build Semantic Layer Views for ClickUp.
-
How to load Adobe Commerce data into Elasticsearch via Logstash
Introducing a simple method to load Adobe Commerce data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Interactive Dashboards from Email in Amazon QuickSight
Create a virtual SQL Server database for Email in CData Software Connect Server and import Email into Amazon QuickSight SPICE to build interactive dashboards.
-
Natively Connect to Adobe Commerce in PHP
The CData ODBC driver for Adobe Commerce enables you to create PHP applications with connectivity to Adobe Commerce. Leverage the native support for ODBC in PHP.
-
Integrate with Zuora in JReport Designer
Create charts and reports based on Zuora in JReport Designer.
-
View Reports on Real-Time Splunk in Power BI Report Server
Use the CData ODBC Driver for Splunk to visualize Splunk in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate Xero Replication to Azure Synapse
Use CData Sync to customize and automate Xero Accounting replication to Azure Synapse.
-
Connect to Azure Table in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for Azure Table Storage in Airbyte.
-
Create Dynamic SAP Fieldglass Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Fieldglass to Infragistics XamDataGrid to build dynamic grids.
-
JDBC-ODBC Bridge Reporting in OBIEE with the JDBC-ODBC Bridge JDBC Driver
Deploy the JDBC-ODBC Bridge JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Informatica Mappings From/To a JDBC Data Source for Zoho Projects
Create Zoho Projects data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect and process Sugar CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sugar CRM
-
Automated Continuous Oracle Service Cloud Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to SQLite.
-
Create Reports from Avalara AvaTax in Looker Studio
Use CData Connect Cloud to gain access to live Avalara AvaTax and create custom reports in Looker Studio.
-
Automated Continuous AlloyDB Replication to MySQL
Use CData Sync for automated, continuous, customizable AlloyDB replication to MySQL.
-
Integrate Live QuickBooks Time into Custom Business Apps Built in Power Apps
Use CData Connect Cloud to connect to QuickBooks Time and integrate live QuickBooks Time into apps built in Microsoft Power Apps.
-
Working with Google Campaign Manager 360 in LINQPad
Execute LINQ queries to Google Campaign Manager 360 in LINQPad.
-
Oracle Financials Cloud Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Oracle Financials Cloud facts in real time.
-
Build Sage Intacct-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sage Intacct and build web apps with connectivity to live Sage Intacct.
-
Create Dynamics GP-Connected Nintex Workflows
Use CData Software Connect Server to connect to Dynamics GP from Nintex Workflow Cloud and build custom workflows using live Microsoft Dynamics GP.
-
Analyze HarperDB in R via JDBC
Use standard R functions and the development environment of your choice to analyze HarperDB with the CData JDBC Driver for HarperDB.
-
Automated Continuous Avalara AvaTax Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Google BigQuery.
-
DataBind Charts to eBay
Use the standard ADO.NET procedures for databinding to provide bidirectional access to eBay 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.
-
How to Access Live JotForm in Power Automate Desktop via ODBC
The CData ODBC Driver for JotForm enables you to integrate JotForm into workflows built using Microsoft Power Automate Desktop.
-
Access Live MailChimp in Excel (Desktop) via Connect Cloud
Use CData Connect Cloud to gain access to live MailChimp from your Excel spreadsheets.
-
Connect to Bing Search Results as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Bing Search.
-
Extract, Transform, and Load Pinterest in Informatica PowerCenter
Create a simple Workflow for Pinterest in Informatica PowerCenter.
-
Access Live Exact Online in Excel 365 Online (Excel for the web)
Connect to Exact Online from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Analyze Hive in Cognos Analytics
Use CData Connect Cloud to connect to Hive from Cognos Analytics and analyze live Apache Hive.
-
How to Connect the Power BI Service to Microsoft Project: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Integrate Highrise in Pentaho Data Integration
Build ETL pipelines based on Highrise CRM in the Pentaho Data Integration tool.
-
Import Zoho Creator into the Power BI Service for Visualizations
Use CData Connect Cloud to connect to Zoho Creator and provide access to live Zoho Creator for custom reports in the Power BI Service.
-
Operational Reporting on Databricks from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Databricks.
-
LINQ to Okta
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Okta Data Provider.
-
Deploy the ADO.NET Provider for Facebook on an SSRS Report Server
Connect to Facebook 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.
-
Connect to Bitbucket in DBArtisan
Use wizards in DBArtisan to configure Bitbucket as a data source.
-
Create Apps from Shopify in Qlik Sense Cloud
Use CData Connect Cloud to connect to Shopify and build apps from live Shopify in Qlik Sense Cloud.
-
Build Dashboards with Shippo in Dundas BI
Create dynamic dashboards and perform analytics based on Shippo in Dundas BI.
-
Connect to Azure DevOps in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Databricks in Jaspersoft Studio
Execute SQL to remote Databricks in Jaspersoft Studio.
-
Use the CData Software JDBC Driver for Amazon S3 in MicroStrategy Desktop
Connect to Amazon S3 in MicroStrategy Desktop using the CData Software JDBC Driver for Amazon S3.
-
Build MVC Applications with Connectivity to CSV
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CSV from an ASP.NET MVC application.
-
Automated Continuous DocuSign Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable DocuSign replication to PostgreSQL.
-
Create Zoho Books-Connected Applications in Appsmith
Connect to Zoho Books via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Zoho Books.
-
How to Build Dynamic React Apps with SAS Data Sets
Use the CData Connect and React to Build Dynamic Web Apps with Live SAS Data Sets .
-
Integrate Dropbox in the Pentaho Report Designer
Publish reports based on Dropbox in the Pentaho BI tool.
-
Use the CData Software ODBC Driver for Harvest in MicroStrategy Desktop
Connect to Harvest in MicroStrategy Desktop using the CData Software ODBC Driver for Harvest.
-
Connect to Twitter Ads in RapidMiner
Integrate Twitter Ads with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Quickbase in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for Quickbase in Airbyte.
-
Create Datasets from SuiteCRM in Domo Workbench and Build Visualizations of SuiteCRM in Domo
Use the CData Software ODBC Driver for SuiteCRM to create datasets from SuiteCRM in Domo Workbench and then build visualizations in the Domo service.
-
Rapidly Develop MongoDB-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.
-
Connect and Visualize Live Instagram Data in Databricks Lakehouse Federation with CData Connect Cloud
Use CData Connect Cloud to integrate live Instagram into the Databricks platform and create visualization dashboards with real-time Instagram.
-
How to Query Sybase IQ in MySQL Workbench
Execute MySQL queries against live Sybase IQ from MySQL Workbench.
-
Natively Connect to QuickBooks in PHP
The CData ODBC driver for QuickBooks enables you to create PHP applications with connectivity to QuickBooks Desktop. Leverage the native support for ODBC in PHP.
-
Import Real-Time eBay via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use eBay in ColdFusion.
-
Automate Zenefits Replication to Azure Synapse
Use CData Sync to customize and automate Zenefits replication to Azure Synapse.
-
Connect to BigCommerce from a Connection Pool in JBoss
Integrate BigCommerce into Java servlets: Use the Management Console in JBoss to install the BigCommerce JDBC Driver.
-
Connect to BigQuery as an External Data Source using PolyBase
Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Google BigQuery.
-
Use Biml to Build SSIS Tasks to Replicate HBase to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache HBase to SQL Server.
-
Import Real-Time OneNote via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft OneNote in ColdFusion.
-
How to Build an ETL App for Unbounce in Python with CData
Create ETL applications and real-time data pipelines for Unbounce in Python with petl.
-
Easily Integrate LinkedIn in Lazarus Pascal IDE
Learn how to easily integrate live LinkedIn in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Bing Search from a Connection Pool in WebLogic
Use the CData JDBC Driver for Bing Search to connect to Bing Search from Web applications running on WebLogic.
-
Visualize XML from Tableau
Use the Tableau Desktop business intelligence tool to connect to XML Files.
-
Bidirectional Access to Oracle Sales from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Sales in Filemaker Pro for Mac or Windows.
-
Connect to PayPal in Google Apps Script via SQL Gateway
Use the ODBC Driver for PayPal and the SQL Gateway to access PayPal from Google Apps Script.
-
Automate Elasticsearch Replication to Azure Data Lake
Use CData Sync to customize and automate Elasticsearch replication to Azure Data Lake.
-
Connect to Printful in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use Biml to Build SSIS Tasks to Replicate Azure Active Directory to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure Active Directory to SQL Server.
-
How to create an RPA flow for SAP in UiPath Studio
Use the SAP ODBC Driver to create workflows that access real-time SAP ERP/NetWeaver without any coding.
-
Replicate Multiple Smartsheet Accounts
Replicate multiple Smartsheet accounts to one or many databases.
-
Integrate Live Microsoft Exchange into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Microsoft Exchange from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Exchange.
-
Operational Reporting on DocuSign from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote DocuSign.
-
Connect to GMO MakeShop from Crystal Reports
Use CData Connect Cloud to connect to and report on live GMO MakeShop from Crystal Reports.
-
How to Connect DBeaver to Airtable via a JDBC Driver
Manage Airtable with visual tools in DBeaver like the query browser.
-
Connect to Live SAP SuccessFactors in PostGresSQL Interface through CData Connect Cloud
Create a live connection to SAP SuccessFactors in CData Connect Cloud and connect to your SAP SuccessFactors from PostgreSQL.
-
Build Dashboards with Redis in Dundas BI
Create dynamic dashboards and perform analytics based on Redis in Dundas BI.
-
Automate RSS Feeds Replication to Couchbase
Use CData Sync to Customize and automate RSS Feeds replication to Couchbase.
-
Choosing the Best Method to Connect Zendesk to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zendesk from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Teams
Provide connectivity to Microsoft Teams through an SAP BusinessObjects universe.
-
A PostgreSQL Interface for SAS Data Sets (MySQL Remoting via JDBC)
Use the Remoting features of the SAS Data Sets JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build SFTP-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SFTP and build web apps with connectivity to live SFTP.
-
Connect to Access in CloverDX (formerly CloverETL)
Transfer Microsoft Access using the visual workflow in the CloverDX data integration tool.
-
Excel Spreadsheet Automation on EventBrite with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to Query Calendly in MySQL Workbench
Execute MySQL queries against live Calendly from MySQL Workbench.
-
Build eBay Analytics-Connected Dashboards in Redash
Use CData Software Connect Server to create a virtual SQL Server Database for eBay Analytics and build visualizations and dashbaords from eBay Analytics in Redash.
-
Integrate Zoho Books with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zoho Books with External Services.