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
-
Build an MVC Application with Connectivity to QuickBooks
CData ADO.NET Providers can be used from many tools and IDEs. In this article we show how to connect to QuickBooks from an MVC project using the CData ADO.NET Provider for QuickBooks. Although this article uses the QuickBooks Data Provider, the same process can be used with any of the CData ADO.NET Providers.
-
How to load Aha data into Elasticsearch via Logstash
Introducing a simple method to load Aha data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect Jira Service Management to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Atlassian Jira Service Management using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Edit and Search Spark External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Apache Spark SQL to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Spark objects that you can access from apps and the dashboard.
-
Build Oracle Service Cloud-Connected Apps in Bubble
Use CData Connect Cloud to create an OData feed for Oracle Service Cloud and create custom apps in Bubble.
-
Prepare, Blend, and Analyze Azure Active Directory in Alteryx Designer (ODBC)
Build workflows to access live Azure Active Directory for self-service data analytics.
-
Connect to Greenplum as an External Source in Dremio
Use the CData JDBC Driver to connect to Greenplum as an External Source in Dremio.
-
Access Live SQL Analysis Services in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for SQL Analysis Services to create a SQL Analysis Services source in TIBCO Data Virtualization Studio and gain access to live SQL Analysis Services from your TDV Server.
-
Validate HDFS with QuerySurge
Access and validate Apache HDFS in QuerySurge using the CData JDBC Driver.
-
Automated Continuous DocuSign Replication to MySQL
Use CData Sync for automated, continuous, customizable DocuSign replication to MySQL.
-
DataBind Controls to Couchbase in Delphi
DataBind to Couchbase in Delphi with standard data access components and controls.
-
Connect to IBM Informix in DBArtisan
Use wizards in DBArtisan to configure IBM Informix as a data source.
-
Extend Google Sheets with WordPress
Make calls to the API Server from Google Apps Script.
-
Visualize Live Vault CRM in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Veeva Vault & Vault CRM.
-
Analyze Sybase in Infragistics Reveal
Use the CData API Server to create an OData API on top of Sybase and visualize live Sybase in Ingragistics Reveal.
-
Visualize Excel Online from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Excel Online.
-
Back Up ConstantContact to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for ConstantContact. In this article, we will employ an SSIS workflow to populate a database with ConstantContact data.
-
How to Connect to Oracle in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle Database. Leverage the pyodbc module for ODBC in Python.
-
Access Live Trello in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Trello from your Google Sheets.
-
QuickBooks Time Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on QuickBooks Time facts in real time.
-
Create Apps from Oracle Eloqua in Qlik Sense Cloud
Use CData Connect Cloud to connect to Oracle Eloqua and build apps from live Oracle Eloqua in Qlik Sense Cloud.
-
Publish Crystal Reports on Microsoft Teams
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Teams.
-
Connect to Adobe Analytics from a Connection Pool in JBoss
Integrate Adobe Analytics into Java servlets: Use the Management Console in JBoss to install the Adobe Analytics JDBC Driver.
-
Build Google Spanner-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Google Spanner and create custom apps in Mendix.
-
Build Visualizations of CockroachDB in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of CockroachDB in Birst.
-
Migrating data from SharePoint Excel Services to Snowflake using CData SSIS Components.
Easily push SharePoint Excel Services to Snowflake using the CData SSIS Tasks for SharePoint Excel Services and Snowflake.
-
Connect to SharePoint from a Connection Pool in WebLogic
Use the CData JDBC Driver for SharePoint to connect to Microsoft SharePoint from Web applications running on WebLogic.
-
Integrate OData Services in the Pentaho Report Designer
Publish reports based on OData in the Pentaho BI tool.
-
Automated Continuous Raisers Edge NXT Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Azure SQL Database.
-
Connect to Redshift in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Redshift and connect to Amazon Redshift in Akorbi Digital RunMyProcess.
-
Connect to Snowflake in ACL Analytics
Connect to Snowflake via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Snowflake.
-
Integrate Real-Time Access to Smartsheet in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Smartsheet in real time.
-
Use Biml to Build SSIS Tasks to Replicate Impala to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache Impala to SQL Server.
-
How to connect Amazon QuickSight to Slack
Create a connection to Slack in CData Connect Cloud and insert Slack into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Multiple Monday.com Accounts
Replicate multiple Monday.com accounts to one or many databases.
-
How to Connect DBeaver to Kafka via a JDBC Driver
Manage Apache Kafka with visual tools in DBeaver like the query browser.
-
Automated Continuous MongoDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable MongoDB replication to SingleStore.
-
LINQ to Google Ads
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 Google Ads Data Provider.
-
Edit and Search External SingleStore Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of SingleStore to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SingleStore objects that you can access from apps and the dashboard.
-
Access HBase from MySQL in Amazon QuickSight
Connect to HBase and build visualizations of Apache HBase using a MySQL Connection in Amazon QuickSight.
-
Connect to Zoho Creator in Ruby
Connect to Zoho Creator in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use Biml to Build SSIS Tasks to Replicate Coinbase to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Coinbase to SQL Server.
-
Creating Smaregi-Connected Applications in Unqork
You can use CData Connect Cloud to feed Smaregi to Unqork and build custom business apps.
-
Design BIRT Reports on IBM Informix
Provide current IBM Informix to your embedded analytics.
-
How to Work with Instagram in ETL Validator JDBC
Connect to Instagram from ETL Validator jobs using the CData Software JDBC Driver.
-
Query QuickBooks from Node.js
Use the OData endpoint of the CData API Server to connect to your QuickBooks Desktop and perform CRUD operations on QuickBooks from Node.js.
-
Extend Google Sheets with Typeform
Make calls to the API Server from Google Apps Script.
-
Provide OData Services of Sybase IQ from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sybase IQ by developing a WCF Service Application.
-
Analyze Power BI XMLA with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Power BI XMLA from Power Pivot. You will use the Table Import Wizard to load Power BI XMLA. You can visually build the import query or use any SQL supported by the driver.
-
Design BIRT Reports on Redis
Provide current Redis to your embedded analytics.
-
Design BIRT Reports on Clio
Provide current Clio to your embedded analytics.
-
How to Connect the Power BI Service to QuickBooks Online: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
How to Easily Query Cvent in OpenOffice Base
-
