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
-
Analyze Salesforce Pardot in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of Salesforce Pardot and visualize live Salesforce Pardot in Infragistics Reveal.
-
Connect to EnterpriseDB in HULFT Integrate
Connect to EnterpriseDB as a JDBC data source in HULFT Integrate
-
Connect to SFTP from Asprova with CData Software ODBC Driver for SFTP
This article shows how to connect faster to SFTP data from Asprova.
-
Integrate Live PCA Sales into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to PCA Sales from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live PCA Sales.
-
How to Work with Sage Cloud Accounting in AWS Glue Jobs Using JDBC
Connect to Sage Cloud Accounting from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate with MailChimp using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MailChimp to a JSON file on disk.
-
Publish HBase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apache HBase.
-
Connect to SAP Concur in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Concur in the Denodo Virtual DataPort Administrator.
-
Connect to Procore as an External Source in Dremio
Use the CData JDBC Driver to connect to Procore as an External Source in Dremio.
-
Automated BambooHR Replication to Teradata
Use CData Sync to Customize and automate BambooHR replication to Teradata.
-
Object-Relational Mapping (ORM) with Wave Financial 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 Wave Financial into a Java-based ORM framework, Hibernate.
-
Access Live Amazon DynamoDB in AWS Lambda
Connect to live Amazon DynamoDB in AWS Lambda using the CData JDBC Driver.
-
Integrate Zoom with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zoom with External Services.
-
A PostgreSQL Interface for Amazon Marketplace using the CData ODBC Driver
Use the SQL Gateway and Amazon Marketplace ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Charts with Azure Active Directory in Clear Analytics
Create dynamic charts and perform analytics based on Azure Active Directory in Clear Analytics.
-
Connect to ActiveCampaign as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ActiveCampaign.
-
Use the Connect Server to Access Dynamics GP in Microsoft Power Pivot
Use the Connect Server to connect to live Microsoft Dynamics GP in the Power Pivot business intelligence tool.
-
Visualize Live OneNote in the Power BI Service
Use CData Connect Cloud to connect to live Microsoft OneNote and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Author and Share Power BI Reports on Real-Time Sage 50 UK
Use the CData ODBC Driver for Sage 50 UK to visualize Sage 50 UK in Power BI Desktop and then upload to the Power BI service.
-
Model, Search, and Visualize Live Zuora in ThoughtSpot
Use CData Connect Cloud to connect to live Zuora for modeling, searching, and visualizing.
-
Automated Continuous Aha Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Aha! replication to OneLake in Microsoft Fabric.
-
Create Excel Online Dashboards in Bold BI
Use CData Software Connect Server to create a virtual SQL Server Database for Microsoft Excel Online to build custom dashboards in Bold BI.
-
Build Bing Search-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live Bing Search and build Bing Search-connected web apps with Axios.
-
Natively Connect to Airtable in PHP
The CData ODBC driver for Airtable enables you to create PHP applications with connectivity to Airtable. Leverage the native support for ODBC in PHP.
-
Access Live Twilio in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Twilio to create a Twilio source in TIBCO Data Virtualization Studio and gain access to live Twilio from your TDV Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Airtable
Provide connectivity to Airtable through an SAP BusinessObjects universe.
-
Automated OData Services Replication to Teradata
Use CData Sync to Customize and automate OData replication to Teradata.
-
Natively Connect to Clio in PHP
The CData ODBC driver for Clio enables you to create PHP applications with connectivity to Clio. Leverage the native support for ODBC in PHP.
-
How to integrate SAP Fieldglass with Apache Airflow
Access and process SAP Fieldglass in Apache Airflow using the CData JDBC Driver.
-
Access Live Slack in AWS Lambda
Connect to live Slack in AWS Lambda using the CData JDBC Driver.
-
Process & Analyze HarperDB in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live HarperDB .
-
Build Dashboards with Active Directory in DBxtra
Create dynamic dashboards and perform analytics based on Active Directory in DBxtra.
-
Connect to YouTube Analytics through External Services in Salesforce
Use CData Connect Cloud to securely connect Salesforce External Services with YouTube Analytics using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use the Connect Server to Access ClickUp in Microsoft Power Pivot
Use the Connect Server to connect to live ClickUp in the Power Pivot business intelligence tool.
-
Enable the Box JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Box.
-
Process & Analyze Phoenix in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Phoenix .
-
Viewing SAP BusinessObjects BI in RAD Studio Data Explorer
How to view SAP BusinessObjects BI in RAD Studio Data Explorer using the CData ODBC Driver for SAP BusinessObjects BI.
-
Query Pipedrive as a SQL Server in Node.js
Execute SQL Server queries against Pipedrive from Node.js.
-
Visualize Salesforce in Tableau
The CData ODBC driver for Salesforce enables you integrate Salesforce & Force.com into Tableau dashboards.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Bing Search
Provide connectivity to Bing Search through an SAP BusinessObjects universe.
-
Automated Microsoft Planner Replication to Teradata
Use CData Sync to Customize and automate Microsoft Planner replication to Teradata.
-
Visualize Oracle Sales in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Oracle Sales into TIBCO Spotfire.
-
How to connect to Splunk from Spring Boot
Connect to Splunk in a Spring Boot Application using CData JDBC Splunk Driver
-
How to Query IBM Informix in MySQL Workbench
Execute MySQL queries against live IBM Informix from MySQL Workbench.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Concur
Create SAP Concur data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Oracle Financials Cloud in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle Financials Cloud into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle Financials Cloud in the Graph Builder and Query Builder.
-
Visualize Slack from Tableau
Use the Tableau Desktop business intelligence tool to connect to Slack.
-
Import Calendly into FileMaker Pro
Create reports that integrate Calendly in Filemaker Pro.
-
Build an OLAP Cube in SSAS from SharePoint
Establish a connection to Microsoft SharePoint data from SQL Server Analysis Services, and use the SharePoint Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create MailChimp-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to MailChimp from Klipfolio and build custom visualizations using live MailChimp.
-
Build SharePoint Excel Services-Connected Dashboards in Redash
Use CData Software Connect Server to create a virtual SQL Server Database for SharePoint Excel Services and build visualizations and dashbaords from SharePoint Excel Services in Redash.
-
Connect to Amazon Marketplace in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Aha in Ruby
Connect to Aha! in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
DataBind Controls to eBay Analytics in C++Builder
DataBind to eBay Analytics in C++Builder with standard components and controls.
-
Replicate Vertica to Multiple Databases via the CData Sync CLI
Replicate Vertica to disparate databases with a single configuration.
-
Use the CData Software ODBC Driver for Amazon Athena in MicroStrategy Web
Connect to Amazon Athena in MicroStrategy Web using the CData Software ODBC Driver for Amazon Athena.
-
How to connect to Google Ad Manager from Spring Boot
Connect to Google Ad Manager in a Spring Boot Application using CData JDBC Google Ad Manager Driver
-
Design BIRT Reports on Amazon Marketplace
Provide current Amazon Marketplace to your embedded analytics.
-
Connect to YouTube Analytics in RazorSQL
Connect to YouTube Analytics from wizards and query YouTube Analytics from the GUI in the RazorSQL database management tool.
-
Automate Amazon S3 Replication to Azure Data Lake
Use CData Sync to customize and automate Amazon S3 replication to Azure Data Lake.
-
Integrate with Google Cloud Storage in JReport Designer
Create charts and reports based on Google Cloud Storage in JReport Designer.
-
Create a Data Access Object for Twitter Ads using JDBI
A brief overview of creating a SQL Object API for Twitter Ads in JDBI.
-
Build Stripe-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Stripe and build web apps with connectivity to live Stripe.
-
Stream Veeva Vault into Apache Kafka Topics
Access and stream Veeva Vault & Vault CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Explore Geographical Relationships in Salesforce with Power Map
Create data visualizations with Salesforce & Force.com in Power Map.
-
Build MYOB AccountRight Visualizations in Tableau Cloud
Use CData Connect Cloud to connect to live MYOB AccountRight and build visualizations in Tableau Cloud.
-
Query Greenplum through ODBC in Node.js
Use node-odbc to execute SQL queries against Pivotal GreenPlum from Node.js.
-
Automated Continuous MYOB AccountRight Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to delimited files (CSV/TSV).
-
Automate AlloyDB Replication to SAP HANA
Use CData Sync to customize and automate Google AlloyDB replication to SAP HANA.
-
Use the CData ODBC Driver for PayPal in Microsoft Power Query
You can use the CData PayPal ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PayPal into Microsoft Power Query.
-
Replicate Sage 50 UK to Multiple Databases
Replicate Sage 50 UK to disparate databases with a point-and-click configuration.
-
Use Biml to Build SSIS Tasks to Replicate HarperDB to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate HarperDB to SQL Server.
-
Connect to Cloudant from Filemaker Pro (Mac)
Use CData Connect Cloud to connect to and query live IBM Cloudant from Filemaker Pro on Mac.
-
Seamlessly Bring MariaDB into Retool Using CData Connect Cloud
Integrate MariaDB data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
-
Dynamics 365 Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Dynamics 365 through CData Connect Cloud using different applications and tools.
-
Automated Continuous Oracle Service Cloud Replication to MongoDB
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to MongoDB.
-
Create Dashboards and Visualize Live Dynamics CRM in Geckoboard
Use CData Connect Cloud to connect to live Microsoft Dynamics CRM and create dashboards for real-time monitoring and visualization in Geckoboard.
-
A PostgreSQL Interface for Unbounce using the CData ODBC Driver
Use the SQL Gateway and Unbounce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Establish a Live Connection with SAP ByDesign using Tableau Bridge
The CData ODBC Driver for SAP ByDesign enables you to integrate live SAP Business ByDesign into Tableau Cloud dashboards using the Tableau Bridge.
-
Build MVC Applications with Connectivity to Cosmos DB
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Cosmos DB from an ASP.NET MVC application.
-
How to Query Live SAP Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP ERP/NetWeaver data in natural language using Python.
-
Access Live QuickBooks Time in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live QuickBooks Time from your Excel spreadsheets.
-
Use Dash to Build to Web Apps on Azure Analysis Services
Create Python applications that use pandas and Dash to build Azure Analysis Services-connected web apps.
-
Use the CData ODBC Driver for Jira Assets from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Jira Assets to connect to Jira Assets from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Jira Assets in Excel.
-
Connect to Facebook Ads in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Facebook Ads and connect to Facebook Ads in Akorbi Digital RunMyProcess.
-
Connect to Live Jira Service Management in MicroStrategy through CData Connect Cloud
Create a live connection to Jira Service Management in CData Connect Cloud and connect to your Atlassian Jira Service Management from MicroStrategy.
-
Import Real-Time HarperDB via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use HarperDB in ColdFusion.
-
Model Google Drive Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Google Drive, enabling the direct import of real-time Google Drive.
-
Add Adobe Commerce to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Adobe Commerce with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Work with Klipfolio in ETL Validator JDBC
Connect to Klipfolio from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to FHIR as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for FHIR.
-
Use the CData ODBC Driver for ShipStation in Microsoft Power Query
You can use the CData ShipStation ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ShipStation into Microsoft Power Query.
-
Connect to MySQL through SSH Using the Built-In Client
A detailed overview of the SQL Gateway, its function, and its features.
-
Build Semantic Layer Views for ActiveCampaign in APOS Live Data Gateway
Use the CData Connector for ActiveCampaign in APOS Live Data Gateway to build Semantic Layer Views for ActiveCampaign.
-
Automated xBase Replication to Teradata
Use CData Sync to Customize and automate xBase replication to Teradata.
-
Connect to SAP Netweaver Gateway in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Netweaver Gateway in the Denodo Virtual DataPort Administrator.
-
Analyze MariaDB in R via JDBC
Use standard R functions and the development environment of your choice to analyze MariaDB with the CData JDBC Driver for MariaDB.
-
Feed Twitter Ads into FineReport
How to set Twitter Ads as a JDBC data source in FineReport.
-
How to Connect to & Open Zoho CRM in Microsoft Excel
This article uses the CData ODBC driver for Zoho CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to and Visualize Live Twilio in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Twilio.