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 ShipStation-Connected Nintex Workflows
Use CData Connect Cloud to connect to ShipStation from Nintex Workflow Cloud and build custom workflows using live ShipStation.
-
Build a PostgreSQL Interface for Clio using the CData JDBC Driver
Use the Remoting features of the Clio JDBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for Aha using the CData ODBC Driver
Use the SQL Gateway and Aha ODBC Driver to create a PostgreSQL entry-point for data access.
-
Consume SingleStore OData Feeds in PowerBuilder
This article demonstrates how to consume SingleStore as OData feeds from PowerBuilder using the API Server.
-
Build Charts with Wave Financial in Clear Analytics
Create dynamic charts and perform analytics based on Wave Financial in Clear Analytics.
-
Use the CData ODBC Driver for Airtable from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Airtable to connect to Airtable from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Airtable in Excel.
-
Integrate with Kintone in JReport Designer
Create charts and reports based on Kintone in JReport Designer.
-
Visualize Live Klipfolio of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Klipfolio using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
A PostgreSQL Interface for Airtable (MySQL Remoting via JDBC)
Use the Remoting features of the Airtable JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to SAP Business One in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Business One. Leverage the pyodbc module for ODBC in Python.
-
Back Up Cvent to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Cvent. In this article, we will employ an SSIS workflow to populate a database with Cvent data.
-
How to Work with Azure DevOps in AWS Glue Jobs Using JDBC
Connect to Azure DevOps from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create MYOB AccountRight-Connected Business Apps in AppSheet
Connect to MYOB AccountRight via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to MYOB AccountRight.
-
Integrate with Quickbase using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Quickbase to a JSON file on disk.
-
How to Build an ETL App for PingOne in Python with CData
Create ETL applications and real-time data pipelines for PingOne in Python with petl.
-
How to integrate Metabase with Oracle Eloqua
Use CData Connect Cloud to connect to live Oracle Eloqua and create an interactive dashboard in Metabase from Oracle Eloqua.
-
Migrating data from Sage 50 UK to Databricks using CData SSIS Components.
Easily push Sage 50 UK to Databricks using the CData SSIS Tasks for Sage 50 UK and Databricks.
-
Create Power BI Reports on Real-Time Google Spanner
Use the CData ODBC Driver for Google Spanner to visualize Google Spanner in Power BI Desktop.
-
Visualize QuickBooks in TIBCO Spotfire through OData
Integrate QuickBooks Desktop into dashboards in TIBCO Spotfire.
-
Automate Tableau CRM Analytics Replication to Azure Data Lake
Use CData Sync to customize and automate Tableau CRM Analytics replication to Azure Data Lake.
-
Trigger Oracle Eloqua IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Natively Connect to Freshdesk in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Freshdesk. Leverage the native support for ODBC in PHP.
-
Prepare, Blend, and Analyze Raisers Edge NXT in Alteryx Designer (Connect Cloud)
Build workflows to access live Raisers Edge NXT for self-service data analytics.
-
Automated Continuous Coinbase Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Coinbase replication to Microsoft Access.
-
Connect to Excel Online from a Connection Pool in JBoss
Integrate Microsoft Excel Online into Java servlets: Use the Management Console in JBoss to install the Excel Online JDBC Driver.
-
Create Dashboards and Visualize Live MongoDB in Geckoboard
Use CData Connect Cloud to connect to live MongoDB and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Enable the Microsoft Dataverse JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Dataverse (CDS).
-
Automate Coinbase Replication to Azure Data Lake
Use CData Sync to customize and automate Coinbase replication to Azure Data Lake.
-
Query SAP ByDesign from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP Business ByDesign and perform CRUD operations on SAP ByDesign from Node.js.
-
Automated Continuous Twitter Ads Replication to Snowflake
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Snowflake.
-
How to Build an ETL App for Microsoft Exchange in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Exchange in Python with petl.
-
Build Visualizations of BigQuery in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google BigQuery in Birst.
-
Building Dynamic Web Pages with SAS Data Sets Using AngularJS
Create single-page applications with live connectivity to SAS Data Sets using the CData API Server.
-
Connect to Sage 300 from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sage 300 to connect to Sage 300 from Web applications running on WebLogic.
-
Publish Crystal Reports on Oracle Eloqua
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle Eloqua.
-
LINQ to LinkedIn 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 LinkedIn Ads Data Provider.
-
Publish Reports with Parquet in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Parquet.
-
Deploy the ADO.NET Provider for Authorize.Net on an SSRS Report Server
Connect to Authorize.Net 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.
-
Work with Cvent in FoxPro
Load Cvent into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for Facebook Ads in MicroStrategy Desktop
Connect to Facebook Ads in MicroStrategy Desktop using the CData Software ODBC Driver for Facebook Ads.
-
Choosing the Best Method to Connect Teradata to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Teradata from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous TaxJar Replication to SQLite
Use CData Sync for automated, continuous, customizable TaxJar replication to SQLite.
-
Migrating data from Dropbox to Databricks using CData SSIS Components.
Easily push Dropbox to Databricks using the CData SSIS Tasks for Dropbox and Databricks.
-
Visualize API in TIBCO Spotfire through OData
Integrate API into dashboards in TIBCO Spotfire.
-
Consume Reckon Accounts Hosted OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Reckon Accounts Hosted feeds that reflect any changes in SAP Lumira.
-
Visualize Live Certinia of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Certinia using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Pinterest Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Pinterest replication to PostgreSQL.
-
Automated Continuous Amazon S3 Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Amazon S3 replication to AlloyDB.
-
Easily Integrate Jira Service Management in Lazarus Pascal IDE
Learn how to easily integrate live Atlassian Jira Service Management in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Basecamp Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Basecamp replication to Apache Cassandra.
-
Bind Live Cloudant Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Cloudant data
-
Visualize eBay Analytics in TIBCO Spotfire through OData
Integrate eBay Analytics into dashboards in TIBCO Spotfire.
-
Connect to Oracle from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle Database, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Import Zendesk into the Power BI Service for Visualizations
Use CData Connect Cloud to connect to Zendesk and provide access to live Zendesk for custom reports in the Power BI Service.
-
Publish Reports with Splunk in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Splunk.
-
Use the CData ODBC Driver for HDFS in Microsoft Power Query
You can use the CData HDFS ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache HDFS into Microsoft Power Query.
-
Visualize Live Dynamics CRM in the Power BI Service
Use CData Connect Cloud to connect to live Microsoft Dynamics CRM and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Amazon DynamoDB Replication to Oracle
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Oracle.
-
Establish a Live Connection with Sugar CRM using Tableau Bridge
The CData ODBC Driver for Sugar CRM enables you to integrate live Sugar CRM into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Sage 200 in Pentaho Data Integration
Build ETL pipelines based on Sage 200 in the Pentaho Data Integration tool.
-
Automate Shopify Replication to Couchbase
Use CData Sync to Customize and automate Shopify replication to Couchbase.
-
Connect to Kafka from a Connection Pool in JBoss
Integrate Apache Kafka into Java servlets: Use the Management Console in JBoss to install the Kafka JDBC Driver.
-
Connect to Authorize.Net in CloverDX (formerly CloverETL)
Transfer Authorize.Net using the visual workflow in the CloverDX data integration tool.
-
Operational Reporting on Salesforce Data Cloud from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Salesforce Data Cloud.
-
Build Power BI XMLA-Connected Apps in Choreo
Use CData Connect Cloud to connect to Power BI XMLA from Choreo and build custom apps using live Power BI XMLA.
-
ETL SuiteCRM in Oracle Data Integrator
This article shows how to transfer SuiteCRM into a data warehouse using Oracle Data Integrator.
-
How to connect to Facebook Ads in DBVisualizer
Integrate Facebook Ads with visual data analysis tools and data connection wizards in DBVisualizer
-
Provide OData Services of Confluence from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Atlassian Confluence by developing a WCF Service Application.
-
Establish a Live Connection with CouchDB using Tableau Bridge
The CData ODBC Driver for CouchDB enables you to integrate live Apache CouchDB into Tableau Cloud dashboards using the Tableau Bridge.
-
Query Active Directory through ODBC in Node.js
Use node-odbc to execute SQL queries against Active Directory from Node.js.
-
Connect to BambooHR in Google Apps Script via SQL Gateway
Use the ODBC Driver for BambooHR and the SQL Gateway to access BambooHR from Google Apps Script.
-
Connect to Jira Assets in HULFT Integrate
Connect to Jira Assets as a JDBC data source in HULFT Integrate
-
Build ActiveCampaign-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ActiveCampaign and build web apps with connectivity to live ActiveCampaign.
-
How to create an RPA flow for Microsoft Dataverse in UiPath Studio
Use the Microsoft Dataverse ODBC Driver to create workflows that access real-time Microsoft Dataverse (CDS) without any coding.
-
Load SAP Netweaver Gateway to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Netweaver Gateway to a database.
-
Connect and Query Live YouTube Analytics Data in Databricks with CData Connect Cloud
Use CData Connect Cloud to integrate live YouTube Analytics into Databricks
-
Access Live Redshift in AWS Lambda (with IntelliJ IDEA)
Connect to live Amazon Redshift in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to HubDB as an External Source in Dremio
Use the CData JDBC Driver to connect to HubDB as an External Source in Dremio.
-
Automated Continuous CSV Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable CSV replication to PostgreSQL.
-
Create Salesforce Data Cloud Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesforce Data Cloud data access from reports, embedded analytics, and more.
-
Provide OData Services of HarperDB from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for HarperDB by developing a WCF Service Application.
-
Integrating Dynamics 365 Business Central in Talend Cloud Data Management Platform
-