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 Jira Assets Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import Coinbase into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Coinbase. In this article, you will use the OData format to import Coinbase into Microsoft Power Query.
-
Automated Continuous Tableau CRM Analytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to Azure SQL Database.
-
Connect to xBase in NetBeans
Connect to xBase in NetBeans with the data source configuration wizard.
-
How to connect SharePoint with ShipStation through external lists
Provide ShipStation to SharePoint users as an external list.
-
Use the CData Software ODBC Driver for GraphQL in MicroStrategy
Connect to GraphQL in MicroStrategy Developer using the CData Software ODBC Driver for GraphQL.
-
Automated Continuous MySQL Replication to IBM DB2
Use CData Sync for automated, continuous, customizable MySQL replication to IBM DB2.
-
Connect to and Query Raisers Edge NXT in QlikView over ODBC
Create data visualizations with Raisers Edge NXT in QlikView.
-
Analyze LinkedIn Ads in Looker
Use CData Connect Cloud to connect to LinkedIn Ads from Looker and build custom apps using live LinkedIn Ads.
-
Analyze Dynamics 365 Business Central in Looker
Use CData Connect Cloud to connect to Dynamics 365 Business Central from Looker and build custom apps using live Dynamics 365 Business Central.
-
How to Query Live Salesforce Data Cloud in Claude Desktop
Connect to and query live Salesforce Data Cloud in Claude Desktop using the CData MCP Server.
-
Choosing the Best Method to Connect Hive to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apache Hive from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software ODBC Driver for MariaDB in MicroStrategy Desktop
Connect to MariaDB in MicroStrategy Desktop using the CData Software ODBC Driver for MariaDB.
-
Build Oracle HCM Cloud-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to Oracle HCM Cloud from Zoho Analytics and import live Oracle HCM Cloud.
-
Build Airtable-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Airtable.
-
Create Epicor Kinetic-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to Epicor Kinetic from Klipfolio and build custom visualizations using live Epicor Kinetic.
-
How to connect to Dynamics NAV from Spring Boot
Connect to Dynamics NAV in a Spring Boot Application using CData JDBC Dynamics NAV Driver
-
Connect to Zuora in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Zuora and connect to Zuora in Akorbi Digital RunMyProcess.
-
SAP Concur Reporting in OBIEE with the SAP Concur JDBC Driver
Deploy the SAP Concur JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live SAP HANA in Excel (Desktop) via Connect Cloud
Use CData Connect Cloud to gain access to live SAP HANA from your Excel spreadsheets.
-
Integrate Backlog into Power Automate Desktop using CData Connect
CData Connect for Backlog enables you to integrate Backlog into workflows built using Microsoft Power Automate Desktop.
-
How to Seamlessly Import Azure Active Directory Data into IBM SPSS Modeler
Integrate Azure Active Directory data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Bind Live SAP Hybris C4C Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Hybris C4C data
-
Automated Continuous Zoom Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoom replication to IBM DB2.
-
Load Google Cloud Storage to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Cloud Storage to a database.
-
Automated Continuous Twitter Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Twitter replication to Amazon Redshift.
-
Using the CData Software ODBC Driver for SQL Analysis Services in PyCharm
Connect to SQL Analysis Services as an ODBC data source in PyCharm using the CData Software ODBC Driver for SQL Analysis Services.
-
Build Semantic Layer Views for Oracle Service Cloud in APOS Live Data Gateway
Use the CData Connector for Oracle Service Cloud in APOS Live Data Gateway to build Semantic Layer Views for Oracle Service Cloud.
-
How to import Square into Apache Solr
Use the CData Software JDBC Driver for Square in Data Import Handler and create an automated import of Square to Apache Solr Enterprise Search platform.
-
Automated Continuous Zoho Creator Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Apache Cassandra.
-
Build Automated Workflows with Live BigQuery in Workato
Use CData Connect Cloud to connect to live Google BigQuery and build automated workflows in Workato.
-
How to create an RPA flow for Adobe Target in UiPath Studio
Use the Adobe Target ODBC Driver to create workflows that access real-time Adobe Target without any coding.
-
Connect to Sage 300 in DBeaver
Use the CData ODBC Driver to connect to Sage 300 in DBeaver.
-
Query SAP BusinessObjects BI in ColdFusion
Write standard ColdFusion data access code to connect to SAP BusinessObjects BI.
-
Visualize Dropbox in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Dropbox into TIBCO Spotfire.
-
Build Dashboards with Dynamics CRM in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Dynamics CRM in DBxtra.
-
Connect to Clio in DBeaver
Use the CData ODBC Driver to connect to Clio in DBeaver.
-
Extract, Transform, and Load Exact Online in Informatica PowerCenter
Create a simple Workflow for Exact Online in Informatica PowerCenter.
-
Create Informatica Mappings From/To a JDBC Data Source for Email
Create Email data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Easily Integrate JotForm in Lazarus Pascal IDE
Learn how to easily integrate live JotForm in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Access Facebook Ads Using Entity Framework
This article shows how to access Facebook Ads using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData ODBC Driver for Salesforce in Microsoft Power Query
You can use the CData Salesforce ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Salesforce & Force.com into Microsoft Power Query.
-
Import SAP Business One Using Azure Data Factory
Use CData Connect Cloud to connect to SAP Business One from Azure Data Factory and import live SAP Business One.
-
Create Oracle SCM-Connected Nintex Workflows
Use CData Connect Cloud to connect to Oracle SCM from Nintex Workflow Cloud and build custom workflows using live Oracle SCM.
-
View Reports on Real-Time SAS xpt in Power BI Report Server
Use the CData ODBC Driver for SAS xpt to visualize SAS XPORT in Power BI Desktop and then publish them to Power BI Report Server.
-
Migrating data from SurveyMonkey to Google BigQuery using CData SSIS Components.
Easily push SurveyMonkey to Google BigQuery using the CData SSIS Tasks for SurveyMonkey and Google BigQuery.
-
Easily Integrate Drip in Lazarus Pascal IDE
Learn how to easily integrate live Drip in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Edit and Search LinkedIn Ads External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of LinkedIn Ads to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create LinkedIn Ads objects that you can access from apps and the dashboard.
-
Access Jira in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Atlassian Jira.
-
Publish Reports with MarkLogic in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MarkLogic.
-
Connect to BCart as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live BCart.
-
Create Dynamic SAP Ariba Procurement Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Ariba Procurement to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Dynamics 365 in CloverDX (formerly CloverETL)
Transfer Microsoft Dynamics 365 using the visual workflow in the CloverDX data integration tool.
-
Query, Visualize, and Share live Freshdesk in Redash
Use CData Connect Cloud to connect to live Freshdesk in Redash for querying, visualizing, and sharing.
-
Connect and Query Live Confluence Data in Databricks with CData Connect Cloud
Use CData Connect Cloud to integrate live Atlassian Confluence into Databricks
-
DataBind Controls to Adobe Analytics in Delphi
DataBind to Adobe Analytics in Delphi with standard data access components and controls.
-
Connect to MarkLogic in the Denodo Platform
Use CData driver technologies to create a virtual data source for MarkLogic in the Denodo Virtual DataPort Administrator.
-
Connect to Kintone in Ruby
Connect to Kintone in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Email using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Email entities in PHP by modeling them as objects.
-
Connect to MYOB AccountRight in the Denodo Platform
Use CData driver technologies to create a virtual data source for MYOB AccountRight in the Denodo Virtual DataPort Administrator.
-
Migrating data from Microsoft Project to Snowflake using CData SSIS Components.
Easily push Microsoft Project to Snowflake using the CData SSIS Tasks for Microsoft Project and Snowflake.
-
Build Charts with IBM Informix in Clear Analytics
Create dynamic charts and perform analytics based on IBM Informix in Clear Analytics.
-
Access Live Elasticsearch in AWS Lambda (with IntelliJ IDEA)
Connect to live Elasticsearch in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Work with Oracle Service Cloud in ETL Validator JDBC
Connect to Oracle Service Cloud from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect and process SAP Ariba Procurement from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Ariba Procurement.
-
Automated Continuous Square Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Square replication to Google BigQuery.
-
Connect to ConstantContact from PowerBuilder via ADO.NET
This article demonstrates how to access ConstantContact from Appeon PowerBuilder using the CData ADO.NET Provider for ConstantContact.
-
Import Snapchat Ads into the Power BI Service for Visualizations
Use CData Connect Cloud to connect to Snapchat Ads and provide access to live Snapchat Ads for custom reports in the Power BI Service.
-
Connect to Salesforce Marketing in NetBeans
Connect to Salesforce Marketing Cloud in NetBeans with the data source configuration wizard.
-
How to load WooCommerce data into Elasticsearch via Logstash
Introducing a simple method to load WooCommerce data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Raisers Edge NXT as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Raisers Edge NXT from your Oracle system.
-
Integrate with Calendly in JReport Designer
Create charts and reports based on Calendly in JReport Designer.
-
Prepare, Blend, and Analyze QuickBooks Time in Alteryx Designer (Connect Cloud)
Build workflows to access live QuickBooks Time for self-service data analytics.
-
Automated Continuous OData Replication to MySQL
Use CData Sync for automated, continuous, customizable OData replication to MySQL.
-
Build an OLAP Cube in SSAS from Microsoft OneDrive
Establish a connection to Microsoft OneDrive data from SQL Server Analysis Services, and use the Microsoft OneDrive Data Provider to build OLAP cubes for use in analytics and reporting.
-
Provide OData Services of Printful from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Printful by developing a WCF Service Application.
-
Connect Reckon to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Reckon using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Facebook Ads in DBArtisan
Use wizards in DBArtisan to configure Facebook Ads as a data source.
-
Visualize Live Twitter in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Twitter.
-
Analyze Amazon Marketplace in Looker
Use CData Connect Cloud to connect to Amazon Marketplace from Looker and build custom apps using live Amazon Marketplace.
-
DataBind Controls to Twitter Ads in Delphi
DataBind to Twitter Ads in Delphi with standard data access components and controls.
-
How to use SQLAlchemy ORM to access SAP in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP ERP/NetWeaver.
-
How to Connect to & Open Freshdesk in Microsoft Excel
This article uses the CData ODBC driver for Freshdesk to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to FTP Using the Script Function in Claris FileMaker Pro
-