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
-
Create Confluence-Connected Business Apps in AppSheet
Connect to Confluence via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Atlassian Confluence.
-
Automate Sage Cloud Accounting Replication to Azure Data Lake
Use CData Sync to customize and automate Sage Business Cloud Accounting replication to Azure Data Lake.
-
Visualize Kintone in Tableau
The CData ODBC driver for Kintone enables you integrate Kintone into Tableau dashboards.
-
Back Up WordPress to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for WordPress. In this article, we will employ an SSIS workflow to populate a database with WordPress data.
-
Establish a Live Connection with Oracle Service Cloud using Tableau Bridge
The CData ODBC Driver for Oracle Service Cloud enables you to integrate live Oracle Service Cloud into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Charts with FTP in Clear Analytics
Create dynamic charts and perform analytics based on FTP Servers in Clear Analytics.
-
Explore Geographical Relationships in Square with Power Map
Create data visualizations with Square in Power Map.
-
Connect to Amazon Marketplace in the Denodo Platform
Use CData driver technologies to create a virtual data source for Amazon Marketplace in the Denodo Virtual DataPort Administrator.
-
Build Dashboards with ConstantContact in Dundas BI
Create dynamic dashboards and perform analytics based on ConstantContact in Dundas BI.
-
Access Live Zoho CRM Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Zoho CRM data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use the CData SSIS Components to Insert New or Update Existing Oracle Sales Records from SQL Server
Easily push SQL Server data to Oracle Sales using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Oracle Sales or update existing records with data from a SQL Server database.
-
DataBind Controls to Active Directory in C++Builder
DataBind to Active Directory in C++Builder with standard components and controls.
-
Publish Dropbox-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Dropbox.
-
Automated Salesforce Pardot Replication to Teradata
Use CData Sync to Customize and automate Salesforce Pardot replication to Teradata.
-
Build Azure Data Lake Storage-Connected Apps in Choreo
Use CData Connect Cloud to connect to Azure Data Lake Storage from Choreo and build custom apps using live Azure Data Lake Storage.
-
Stream Microsoft Planner into Apache Kafka Topics
Access and stream Microsoft Planner in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Azure Active Directory from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure Active Directory using standard SQL.
-
Create Informatica Mappings From/To an ODBC Data Source for Oracle
Create an ODBC connection to Oracle in Informatica and browse and transfer Oracle Database.
-
Connect to GraphQL in HULFT Integrate
Connect to GraphQL as a JDBC data source in HULFT Integrate
-
Import Tableau CRM Analytics into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Tableau CRM Analytics. In this article, you will use the OData format to import Tableau CRM Analytics into Microsoft Power Query.
-
Use Dash to Build to Web Apps on SAP HANA
Create Python applications that use pandas and Dash to build SAP HANA-connected web apps.
-
Explore Geographical Relationships in YouTube Analytics with Power Map
Create data visualizations with YouTube Analytics in Power Map.
-
Automate Veeva Vault Replication to SAP HANA
Use CData Sync to customize and automate Veeva Vault & Vault CRM replication to SAP HANA.
-
Replicate Databricks to Multiple Databases
Replicate Databricks to disparate databases with a point-and-click configuration.
-
Build Automated Workflows with Live Freshdesk in Workato
Use CData Connect Cloud to connect to live Freshdesk and build automated workflows in Workato.
-
Prepare, Blend, and Analyze Salesforce Data Cloud in Alteryx Designer (ODBC)
Build workflows to access live Salesforce Data Cloud for self-service data analytics.
-
Connect to FHIR in HULFT Integrate
Connect to FHIR as a JDBC data source in HULFT Integrate
-
Validate Couchbase with QuerySurge
Access and validate Couchbase in QuerySurge using the CData JDBC Driver.
-
Build Semantic Layer Views for Twilio in APOS Live Data Gateway
Use the CData Connector for Twilio in APOS Live Data Gateway to build Semantic Layer Views for Twilio.
-
Connect to OneNote in DBeaver
Use the CData ODBC Driver to connect to Microsoft OneNote in DBeaver.
-
Automated Continuous Salesloft Replication to MongoDB
Use CData Sync for automated, continuous, customizable Salesloft replication to MongoDB.
-
Connect to ActiveCampaign in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for ActiveCampaign in Airbyte.
-
How to connect to Azure Data Catalog in DBVisualizer
Integrate Azure Data Catalog with visual data analysis tools and data connection wizards in DBVisualizer
-
SAP Fieldglass Reporting in OBIEE with the SAP Fieldglass JDBC Driver
Deploy the SAP Fieldglass JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Greenhouse through ODBC in Node.js
Use node-odbc to execute SQL queries against Greenhouse from Node.js.
-
View Reports on Real-Time PayPal in Power BI Report Server
Use the CData ODBC Driver for PayPal to visualize PayPal in Power BI Desktop and then publish them to Power BI Report Server.
-
Query HubSpot from Node.js
Use the OData endpoint of the CData API Server to connect to your HubSpot and perform CRUD operations on HubSpot from Node.js.
-
Automated Continuous Raisers Edge NXT Replication to MongoDB
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to MongoDB.
-
Build Odoo-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Odoo and create custom apps in Mendix.
-
Connect to and Visualize Live YouTube Analytics in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live YouTube Analytics.
-
DataBind Controls to BigCommerce in C++Builder
DataBind to BigCommerce in C++Builder with standard components and controls.
-
Use the CData Software JDBC Driver for PayPal in MicroStrategy
Connect to PayPal in MicroStrategy Developer using the CData Software JDBC Driver for PayPal.
-
Build an OLAP Cube in SSAS from Redis
Establish a connection to Redis data from SQL Server Analysis Services, and use the Redis Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect Amazon QuickSight to Amazon Marketplace
Create a connection to Amazon Marketplace in CData Connect Cloud and insert Amazon Marketplace into Amazon QuickSight SPICE to build interactive dashboards.
-
Publish Phoenix-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apache Phoenix.
-
Access Live Bitbucket in AWS Lambda
Connect to live Bitbucket in AWS Lambda using the CData JDBC Driver.
-
Object-Relational Mapping (ORM) with Printful Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Printful into a Java-based ORM framework, Hibernate.
-
Create BigQuery-Connected Applications in Appsmith
Connect to BigQuery via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Google BigQuery.
-
Visualize Live Adobe Analytics of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Adobe Analytics using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use CData Connect Cloud to Access Bullhorn CRM in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Bullhorn CRM in the Power Pivot business intelligence tool.
-
LINQ to SAP ByDesign
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 SAP ByDesign Data Provider.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Oracle Service Cloud to Power BI dashboards. Simply drag and drop Oracle Service Cloud into data visuals on the Power BI canvas.
-
Use Biml to Build SSIS Tasks to Replicate SAP SuccessFactors to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP SuccessFactors to SQL Server.
-
Object-Relational Mapping (ORM) with SAP ByDesign Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP Business ByDesign into a Java-based ORM framework, Hibernate.
-
Connect to Slack from a Connection Pool in Jetty
The Slack JDBC Driver supports connection pooling: This article shows how to connect faster to Slack from Web apps in Jetty.
-
Work with Impala in FoxPro
Load Apache Impala into a FoxPro database. This article includes full code and a walk-through of the process.
-
Load Google Sheets to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Sheets to a database.
-
Operational Reporting on Google Data Catalog from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Data Catalog.
-
Publish Crystal Reports on OneNote
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft OneNote.
-
Use the CData API Server to Access WooCommerce in Microsoft PowerPivot
Use the CData API Server to connect to live WooCommerce in the Power Pivot business intelligence tool.
-
Publish Reports with Bullhorn CRM in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bullhorn CRM.
-
Connect to Live Cassandra in MicroStrategy through CData Connect Cloud
Create a live connection to Cassandra in CData Connect Cloud and connect to your Apache Cassandra from MicroStrategy.
-
Automated Continuous HBase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable HBase replication to Google BigQuery.
-
Automated Google Ad Manager Replication to Teradata
Use CData Sync to Customize and automate Google Ad Manager replication to Teradata.
-
Query IBM Cloud Object Storage through ODBC in Node.js
Use node-odbc to execute SQL queries against IBM Cloud Object Storage from Node.js.
-
Connect to Zoho Inventory in JRuby
Create a simple JRuby app with access to live Zoho Inventory.
-
How to work with Bing Ads in Apache Spark using SQL
Access and process Bing Ads in Apache Spark using the CData Software JDBC Driver.
-
Connect to Adobe Commerce in JRuby
Create a simple JRuby app with access to live Adobe Commerce.
-
Query Google Cloud Storage from Node.js
Use the OData endpoint of the CData API Server to connect to your Google Cloud Storage and perform CRUD operations on Google Cloud Storage from Node.js.
-
Edit and Search External Twitter Ads Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of Twitter Ads to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Twitter Ads objects that you can access from apps and the dashboard.
-
Automated Continuous SuiteCRM Replication to MySQL
Use CData Sync for automated, continuous, customizable SuiteCRM replication to MySQL.
-
Create SSAS Tabular Models from GitHub
How to build a SQL Server Analysis Service Tabular Model from GitHub using CData drivers.
-
Automated Continuous Marketo Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Marketo replication to Apache Cassandra.
-
Automated Continuous Dynamics 365 Business Central Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Apache Cassandra.
-
Use Biml to Build SSIS Tasks to Replicate Dropbox to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Dropbox to SQL Server.
-
LINQ to Sybase IQ
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 Sybase IQ Data Provider.
-
How to Use a Microsoft Access Database to Update PostgreSQL in Real Time
Update PostgreSQL data by creating a linked table in Microsoft Access with the CData PostgreSQL ODBC Driver.
-
How to connect to Microsoft Exchange in DBVisualizer
Integrate Microsoft Exchange with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Dynamics CRM from MySQL in PHP
Connect to Dynamics CRM through the standard MySQL libraries in PHP.
-
Access BigCommerce from MySQL in PHP
Connect to BigCommerce through the standard MySQL libraries in PHP.
-
Add Azure Synapse to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Azure Synapse with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to GitHub in SpagoBI
Create reports featuring live GitHub in SpagoBI Studio. Host GitHub reports on SpagoBI Server.
-
How to Build an ETL App for SendGrid in Python with CData
Create ETL applications and real-time data pipelines for SendGrid in Python with petl.
-
Visualize Live EventBrite of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Eventbrite using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Build an ETL App for ServiceNow in Python with CData
Create ETL applications and real-time data pipelines for ServiceNow in Python with petl.
-
Build Google Sheets-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to Google Sheets from Zoho Analytics and import live Google Sheets.
-
Working with FTP in LINQPad
Execute LINQ queries to FTP Servers in LINQPad.
-
Create Power BI Reports on Real-Time Invoiced
Use the CData ODBC Driver for Invoiced to visualize Invoiced in Power BI Desktop.
-
How to integrate Metabase with Azure Active Directory
Use CData Connect Cloud to connect to live Azure Active Directory and create an interactive dashboard in Metabase from Azure Active Directory.
-
How to Connect DBeaver to SAS Data Sets via a JDBC Driver
Manage SAS Data Sets with visual tools in DBeaver like the query browser.
-
Integrate Square into Power Automate Desktop using CData Connect
CData Connect for Square enables you to integrate Square into workflows built using Microsoft Power Automate Desktop.
-
DataBind SendGrid to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for SendGrid with the DevExpress Windows Forms and Web controls to provide SendGrid to a chart.
-
How to publish and share SAP dashboards with Tableau Server
The CData ODBC driver for SAP enables you integrate SAP ERP/NetWeaver into Tableau dashboards.
-
Deploy the ADO.NET Provider for LDAP on an SSRS Report Server
Connect to LDAP 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 Query TigerGraph in MySQL Workbench
Execute MySQL queries against live TigerGraph from MySQL Workbench.
-
Automated Continuous Presto Replication to Vertica
Use CData Sync for automated, continuous, customizable Presto replication to Vertica.
-
Back Up SAP Netweaver Gateway to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Netweaver Gateway. In this article, we will employ an SSIS workflow to populate a database with SAP Netweaver Gateway data.
-
How to Query Live Box Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Box data in natural language using Python.
-
Import and Visualize Pipedrive in Power View
Create data visualizations based on Pipedrive in Excel.
-
Import Real-Time Cloudant via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use IBM Cloudant in ColdFusion.