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 a Data Access Object for Salesforce Pardot using JDBI
A brief overview of creating a SQL Object API for Salesforce Pardot in JDBI.
-
Automate Azure Synapse Replication to SAP HANA
Use CData Sync to customize and automate Azure Synapse replication to SAP HANA.
-
Automate Bullhorn CRM Replication to Azure Data Lake
Use CData Sync to customize and automate Bullhorn CRM replication to Azure Data Lake.
-
How to connect to YouTube Analytics from IntelliJ
Integrate connectivity to YouTube Analytics with wizards in IntelliJ.
-
How to integrate Shopify with Apache Airflow
Access and process Shopify in Apache Airflow using the CData JDBC Driver.
-
Use the CData ODBC Driver for MySQL in Microsoft Power Query
You can use the CData MySQL ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MySQL into Microsoft Power Query.
-
Integrate ActiveCampaign into Power Automate Desktop using CData Connect
CData Connect for ActiveCampaign enables you to integrate ActiveCampaign into workflows built using Microsoft Power Automate Desktop.
-
Publish Clio-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Clio.
-
Integrate PayPal with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PayPal with External Services.
-
Replicate REST from PowerShell
Write a quick PowerShell script to query REST. Use connectivity to the live data to replicate REST to SQL Server.
-
Import Real-Time Klaviyo via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Klaviyo in ColdFusion.
-
Automated Continuous SAP Business One Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP Business One replication to Google Cloud SQL.
-
Analyze Oracle Service Cloud in Infragistics Reveal
Use the CData API Server to create an OData API on top of Oracle Service Cloud and visualize live Oracle Service Cloud in Ingragistics Reveal.
-
Integrate Real-Time Access to RSS in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to RSS Feeds in real time.
-
Automated Continuous FHIR Replication to Vertica
Use CData Sync for automated, continuous, customizable FHIR replication to Vertica.
-
Access Live Azure Table in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Azure Table to create a Azure Table Storage source in TIBCO Data Virtualization Studio and gain access to live Azure Table Storage from your TDV Server.
-
Connect to Office 365 in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Migrating data from Twitter Ads to Google BigQuery using CData SSIS Components.
Easily push Twitter Ads to Google BigQuery using the CData SSIS Tasks for Twitter Ads and Google BigQuery.
-
Access Live Act-On in Coginiti Pro
Connect to and query live Act-On from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Act CRM in DBArtisan
Use wizards in DBArtisan to configure Act CRM as a data source.
-
Load ADP to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ADP to a database.
-
Build a Simple VCL Application for Google Analytics
How to build a simple VCL Application to view Google Analytics in RAD Studio using the CData ODBC Driver for Google Analytics.
-
Build a PostgreSQL Interface for HBase using the CData JDBC Driver
Use the Remoting features of the HBase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Square Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Square replication to delimited files (CSV/TSV).
-
Query Act-On as a MySQL Database in Node.js
Execute MySQL queries against Act-On from Node.js.
-
Create Salesforce-Connected Nintex Workflows
Use CData Connect Cloud to connect to Salesforce from Nintex Workflow Cloud and build custom workflows using live Salesforce & Force.com.
-
Manage Google Campaign Manager 360 in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Campaign Manager 360.
-
Connect to BambooHR from Asprova with CData Software ODBC Driver for BambooHR
This article shows how to connect faster to BambooHR data from Asprova.
-
Automated Continuous Excel Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Excel replication to Amazon Redshift.
-
Back Up SAP Fieldglass to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Fieldglass. In this article, we will employ an SSIS workflow to populate a database with SAP Fieldglass data.
-
Work with HCL Domino in FoxPro
Load HCL Domino into a FoxPro database. This article includes full code and a walk-through of the process.
-
Design BIRT Reports on BambooHR
Provide current BambooHR to your embedded analytics.
-
Replicate PingOne from PowerShell
Write a quick PowerShell script to query PingOne. Use connectivity to the live data to replicate PingOne to SQL Server.
-
Visualize Asana in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Asana into TIBCO Spotfire.
-
Connect to GMO MakeShop through External Services in Salesforce
Use CData Connect Cloud to securely connect Salesforce External Services with GMO MakeShop using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build PayPal-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live PayPal and build PayPal-connected web apps with Axios.
-
Automated Continuous Microsoft Exchange Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to IBM DB2.
-
How to create Visio diagrams from SAP SuccessFactors
Automatically update SAP SuccessFactors with the changes you make to Visio master shapes.
-
Analyze MongoDB in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of MongoDB and visualize live MongoDB in Infragistics Reveal.
-
How to load PayPal data into Elasticsearch via Logstash
Introducing a simple method to load PayPal data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Elasticsearch 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 Elasticsearch.
-
Build Data Flows from SQL Server to WooCommerce through SSIS
Easily push SQL Server data to WooCommerce using the CData SSIS Tasks for WooCommerce.
-
How to Seamlessly Import Power BI XMLA Data into IBM SPSS Modeler
Integrate Power BI XMLA data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automate Facebook Ads Replication to Couchbase
Use CData Sync to Customize and automate Facebook Ads replication to Couchbase.
-
Build Semantic Layer Views for ADP in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for ADP.
-
Build LinkedIn-Connected Apps in Bubble
Use CData Connect Cloud to create an OData feed for LinkedIn and create custom apps in Bubble.
-
Integrate OneNote into Power Automate Desktop using CData Connect
CData Connect for OneNote enables you to integrate Microsoft OneNote into workflows built using Microsoft Power Automate Desktop.
-
Establish a Live Connection with Jira Assets using Tableau Bridge
The CData ODBC Driver for Jira Assets enables you to integrate live Jira Assets into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Databricks in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build MVC Applications with Connectivity to Email
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Email from an ASP.NET MVC application.
-
Query MYOB AccountRight as a MySQL Database in Node.js
Execute MySQL queries against MYOB AccountRight from Node.js.
-
How to Connect to & Open Amazon S3 in Microsoft Excel
This article uses the CData ODBC driver for Amazon S3 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Data Flows from Facebook Ads to SQL Server using SSIS
Easily back up Facebook Ads to SQL Server using the SSIS components for Facebook Ads.
-
Connect to MariaDB 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 MariaDB.
-
Automate SAP Replication to Couchbase
Use CData Sync to Customize and automate SAP ERP/NetWeaver replication to Couchbase.
-
Connect to Reckon Accounts Hosted in Ruby
Connect to Reckon Accounts Hosted in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect MongoDB to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MongoDB using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze Oracle Sales with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle Sales from Power Pivot. You will use the Table Import Wizard to load Oracle Sales. You can visually build the import query or use any SQL supported by the driver.
-
Feed Jira Assets into FineReport
How to set Jira Assets as a JDBC data source in FineReport.
-
How to connect SharePoint with CockroachDB through external lists
Provide CockroachDB to SharePoint users as an external list.
-
Create Dashboards and Visualize Live Airtable in Geckoboard
Use CData Connect Cloud to connect to live Airtable and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Data Visualizations Based On Sage Cloud Accounting in Mode
Use CData Connect Cloud to connect to Sage Cloud Accounting from Mode and build visualizations using live
-
Automate MongoDB Replication to Azure Data Lake
Use CData Sync to customize and automate MongoDB replication to Azure Data Lake.
-
Query Oracle SCM in ColdFusion
Write standard ColdFusion data access code to connect to Oracle SCM.
-
Analyze Instagram in Cognos Analytics
Use CData Connect Cloud to connect to Instagram from Cognos Analytics and analyze live Instagram.
-
Consume Excel OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Excel feeds that reflect any changes in SAP Lumira.
-
Connect to Presto as an External Source in Dremio
Use the CData JDBC Driver to connect to Presto as an External Source in Dremio.
-
Connect to Twilio in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for Twilio in Airbyte.
-
How to integrate Cloudant with Apache Airflow
Access and process IBM Cloudant in Apache Airflow using the CData JDBC Driver.
-
Publish Reports with Active Directory in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Active Directory.
-
Integrate Bing Ads with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Bing Ads with External Services.
-
Automated Continuous Splunk Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Splunk replication to Apache Kafka.
-
Build AI/ML Models with Live GraphQL Data using Dataiku
-