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
-
Connect to SendGrid in Ruby
Connect to SendGrid in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Using AngularJS to Build Dynamic Web Pages with Tally
Use the CData Connect Server to create Tally OData feeds and build single-page applications with live Tally ERP.
-
Edit and Search External ClickUp Objects in Salesforce Connect
Use CData Connect Server to securely provide OData feeds of ClickUp to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ClickUp objects that you can access from apps and the dashboard.
-
How to Use a Microsoft Access Database to Update OneNote in Real Time
Update OneNote data by creating a linked table in Microsoft Access with the CData OneNote ODBC Driver.
-
Build MVC Applications with Connectivity to Spark
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Spark from an ASP.NET MVC application.
-
Connect to Power BI XMLA in RazorSQL
Connect to Power BI XMLA from wizards and query Power BI XMLA from the GUI in the RazorSQL database management tool.
-
Access SFTP from MySQL in PHP
Connect to SFTP through the standard MySQL libraries in PHP.
-
Integrate Tally in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Tally ERP from Informatica Cloud.
-
How to connect Amazon QuickSight to Stripe
Create a connection to Stripe in CData Connect Cloud and insert Stripe into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData Software ODBC Driver for Cosmos DB in MicroStrategy
Connect to Azure Cosmos DB in MicroStrategy Developer using the CData Software ODBC Driver for Cosmos DB.
-
How to Access Live Okta in Power Automate Desktop via ODBC
The CData ODBC Driver for Okta enables you to integrate Okta into workflows built using Microsoft Power Automate Desktop.
-
Visualize Klipfolio from Tableau
Use the Tableau Desktop business intelligence tool to connect to Klipfolio.
-
Build a PostgreSQL Interface for SuiteCRM using the CData JDBC Driver
Use the Remoting features of the SuiteCRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Choosing the Best Method to Connect OData to SQL Server: 5 Options Explained
Discover multiple ways to connect and use OData from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Wijmo Grid to Dynamics 365
Provide real-time Microsoft Dynamics 365 to interactive controls.
-
Zoho Creator Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Zoho Creator through CData Connect Cloud using different applications and tools.
-
Create SSAS Tabular Models from MongoDB
How to build a SQL Server Analysis Service Tabular Model from MongoDB using CData drivers.
-
Create Dynamics CRM-Connected Dashboards in Grafana
Connect to Dynamics CRM via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Microsoft Dynamics CRM.
-
Build an OLAP Cube in SSAS from Cvent
Establish a connection to Cvent data from SQL Server Analysis Services, and use the Cvent Data Provider to build OLAP cubes for use in analytics and reporting.
-
Prepare, Blend, and Analyze HCL Domino in Alteryx Designer (Connect Cloud)
Build workflows to access live HCL Domino for self-service data analytics.
-
Automated Continuous Basecamp Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Basecamp replication to Google Cloud SQL.
-
How to Query Live Bitbucket Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Bitbucket data in natural language using Python.
-
Connect to SAP Ariba Procurement 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 SAP Ariba Procurement.
-
Build Semantic Layer Views for Hive in APOS Live Data Gateway
Use the CData Connector for Hive in APOS Live Data Gateway to build Semantic Layer Views for Apache Hive.
-
Create Apps from LinkedIn Ads in Qlik Sense Cloud
Use CData Connect Cloud to connect to LinkedIn Ads and build apps from live LinkedIn Ads in Qlik Sense Cloud.
-
Automated Continuous CockroachDB Replication to Vertica
Use CData Sync for automated, continuous, customizable CockroachDB replication to Vertica.
-
Natively Connect to Microsoft Teams in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Teams. Leverage the native support for ODBC in PHP.
-
Create Data Visualizations in Cognos BI with YouTube Analytics
Access YouTube Analytics as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Working with Kintone in LINQPad
Execute LINQ queries to Kintone in LINQPad.
-
Easily Integrate Amazon Athena in Lazarus Pascal IDE
Learn how to easily integrate live Amazon Athena in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build SurveyMonkey-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for SurveyMonkey and create custom apps in Mendix.
-
DataBind Wijmo Grid to Google Data Catalog
Provide real-time Google Data Catalog to interactive controls.
-
How to connect to Oracle HCM Cloud with Squirrel SQL client
Connect to Oracle HCM Cloud and execute queries in the Squirrel SQL Client.
-
Prepare, Blend, and Analyze Dynamics CRM in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Dynamics CRM for self-service data analytics.
-
Connect to BigQuery in Google Apps Script via Connect Cloud
Use CData Connect Cloud to access Google BigQuery in Google Apps Script.
-
How to connect to SFTP from Google Apps Script
Use CData Software Connect Server to access SFTP in Google Apps Script.
-
Import and Visualize Act CRM in Power View
Create data visualizations based on Act CRM in Excel.
-
Automated Continuous Dynamics CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Apache Kafka.
-
Integrate Google Cloud Storage with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Cloud Storage with External Services.
-
Integrate with Live Yahoo! Japan Data Solution in MuleSoft (via CData Connect Cloud)
Use CData Connect Cloud to connect to Yahoo! Japan Data Solution from the MuleSoft Anypoint Platform to integrate live Yahoo! Japan Data Solution into custom reports and dashboards.
-
Visualize Act-On in Sisense
Create an ElastiCube in Sisense app with access to Act-On.
-
How to create an RPA flow for SAP Fieldglass in UiPath Studio
Use the SAP Fieldglass ODBC Driver to create workflows that access real-time SAP Fieldglass without any coding.
-
Automated Continuous ShipStation Replication to Databricks
Use CData Sync for automated, continuous, customizable ShipStation replication to Databricks.
-
Build Confluence-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Atlassian Confluence and build web apps with connectivity to live Atlassian Confluence.
-
How to pipe Shippo to CSV in PowerShell
Use standard PowerShell cmdlets to access Shippo tables.
-
Bridge Outreach.io Connectivity with Apache NiFi
Access and process Outreach.io in Apache NiFi using the CData JDBC Driver.
-
Connect to QuickBooks Data from PowerBuilder
This article demonstrates how to access QuickBooks data from PowerBuilder using the CData ADO.NET Provider for QuickBooks.
-
How to load FTP data into Elasticsearch via Logstash
Introducing a simple method to load FTP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze AlloyDB in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Google AlloyDB and visualize Google AlloyDB in SAP Analytics Cloud.
-
Process & Analyze Email in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Email .
-
Use CData Connect Cloud to Access Office 365 in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Microsoft Office 365 in the Power Pivot business intelligence tool.
-
How to Work with SQL Server in AWS Glue Jobs Using JDBC
Connect to SQL Server from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Data Visualizations Based On Yahoo! Japan Data Solution in Mode
Use CData Connect Cloud to connect to Yahoo! Japan Data Solution from Mode and build visualizations using live
-
Automate HubSpot Replication to SAP HANA
Use CData Sync to customize and automate HubSpot replication to SAP HANA.
-
Automate Google Spanner Replication to Couchbase
Use CData Sync to Customize and automate Google Spanner replication to Couchbase.
-
Establish a Live Connection with Dynamics GP using Tableau Bridge
The CData ODBC Driver for Dynamics GP enables you to integrate live Microsoft Dynamics GP into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate Google Sheets to Multiple Databases via the CData Sync CLI
Replicate Google Sheets to disparate databases with a single configuration.
-
Automate SharePoint Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft SharePoint replication to Azure Data Lake.
-
Integrate Jira Assets with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Jira Assets with External Services.
-
How to publish and share eBay dashboards with Tableau Server
The CData ODBC driver for eBay enables you integrate eBay into Tableau dashboards.
-
Validate SharePoint with QuerySurge
Access and validate Microsoft SharePoint in QuerySurge using the CData JDBC Driver.
-
Provide OData Services of OneNote from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft OneNote by developing a WCF Service Application.
-
Connect to Dynamics CRM in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous ShipStation Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ShipStation replication to delimited files (CSV/TSV).
-
Salesforce Pardot Reporting in OBIEE with the Salesforce Pardot JDBC Driver
Deploy the Salesforce Pardot JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create SingleStore-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to SingleStore from OutSystems and build custom enterprise apps using live SingleStore.
-
Query SAP SuccessFactors in ColdFusion
Write standard ColdFusion data access code to connect to SAP SuccessFactors.
-
Analyze SAP HANA with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP HANA from Power Pivot. You will use the Table Import Wizard to load SAP HANA. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Live Confluence in MicroStrategy through CData Connect Cloud
Create a live connection to Confluence in CData Connect Cloud and connect to your Atlassian Confluence from MicroStrategy.
-
Automated Continuous Google Spanner Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Spanner replication to PostgreSQL.
-
How to Query Stripe in MySQL Workbench
Execute MySQL queries against live Stripe from MySQL Workbench.
-
How to Seamlessly Import SQL Server Data into IBM SPSS Modeler
Integrate SQL Server data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Feed MYOB AccountRight into FineReport
How to set MYOB AccountRight as a JDBC data source in FineReport.
-
Automated Continuous Square Replication to Vertica
Use CData Sync for automated, continuous, customizable Square replication to Vertica.
-
Slack Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Slack through CData Connect Cloud using different applications and tools.
-
Publish OData-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live OData.
-
Connect to QuickBooks Time in HULFT Integrate
Connect to QuickBooks Time as a JDBC data source in HULFT Integrate
-
DataBind Controls to OneNote in C++Builder
DataBind to Microsoft OneNote in C++Builder with standard components and controls.
-
Access Live SAP Business One in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP Business One into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Business One in the Graph Builder and Query Builder.
-
Connect to Impala in DBArtisan
Use wizards in DBArtisan to configure Apache Impala as a data source.
-
How to Connect DBeaver to Zoho Projects via a JDBC Driver
Manage Zoho Projects with visual tools in DBeaver like the query browser.
-
Build Automated Workflows with Live Dynamics 365 Business Central in Workato
Use CData Connect Cloud to connect to live Dynamics 365 Business Central and build automated workflows in Workato.
-
Configure the CData JDBC Driver for Acumatica in a Connection Pool in Tomcat
Connect to Acumatica ERP from a connection pool in Tomcat.
-
DataBind Google Drive to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Google Drive with the DevExpress Windows Forms and Web controls to provide Google Drive to a chart.
-
Use Dash to Build to Web Apps on Invoiced
Create Python applications that use pandas and Dash to build Invoiced-connected web apps.
-
Build Data Flows from Google Ads to SQL Server using SSIS
Easily back up Google Ads to SQL Server using the SSIS components for Google Ads.
-
Integrate Live Neo4J into Custom Business Apps Built in Power Apps
Use CData Software Connect Server to create a virtual SQL Server Database for Neo4J and integrate live Neo4J into apps built in Microsoft Power Apps.
-
Replicate Couchbase from PowerShell
Write a quick PowerShell script to query Couchbase. Use connectivity to the live data to replicate Couchbase to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Printify
Provide connectivity to Printify through an SAP BusinessObjects universe.
-
Visualize Google Search Results from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Search.
-
Access Google Campaign Manager 360 as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Campaign Manager 360 from your Oracle system.
-
How to Connect the Power BI Service to SFTP: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
LINQ to SAP Fieldglass
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 Fieldglass Data Provider.
-
Model Bing Search Results Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Bing Search, enabling the direct import of real-time Bing Search.
-
Create Dynamic Excel Grids Using the Infragistics XamDataGrid
Learn how you can connect Excel to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData ODBC Driver for Microsoft OneDrive from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft OneDrive to connect to Microsoft OneDrive from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft OneDrive in Excel.
-
Connect to WordPress in the Denodo Platform
Use CData driver technologies to create a virtual data source for WordPress in the Denodo Virtual DataPort Administrator.
-
Build Oracle Financials Cloud-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle Financials Cloud.
-
Connect to Bing Ads in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Bing Ads and connect to Bing Ads in Akorbi Digital RunMyProcess.
-
Build Automated Workflows with Live ShipStation in Workato
Use CData Connect Cloud to connect to live ShipStation and build automated workflows in Workato.