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
-
Automated Continuous SAS xpt Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAS xpt replication to Amazon S3.
-
Visualize Smartsheet from Tableau
Use the Tableau Desktop business intelligence tool to connect to Smartsheet.
-
Stream Jira Service Management into Apache Kafka Topics
Access and stream Atlassian Jira Service Management in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to xBase in NetBeans
Connect to xBase in NetBeans with the data source configuration wizard.
-
Connect to WooCommerce as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for WooCommerce.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Avro
Provide connectivity to Apache Avro through an SAP BusinessObjects universe.
-
Natively Connect to Procore in PHP
The CData ODBC driver for Procore enables you to create PHP applications with connectivity to Procore. Leverage the native support for ODBC in PHP.
-
Replicate Multiple PostgreSQL Accounts
Replicate multiple PostgreSQL accounts to one or many databases.
-
Integrate YouTube Analytics with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate YouTube Analytics with External Services.
-
DataBind Controls to Monday.com in Delphi
DataBind to Monday.com in Delphi with standard data access components and controls.
-
Access Live Adobe Analytics in Excel 365 Online (Excel for the web)
Connect to Adobe Analytics from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
DataBind Redshift to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Redshift with the DevExpress Windows Forms and Web controls to provide Amazon Redshift to a chart.
-
Connect to Outreach.io in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Outreach.io and connect to Outreach.io in Akorbi Digital RunMyProcess.
-
Access Live SAP Business One in Coginiti Pro
Connect to and query live SAP Business One from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Sybase IQ from MySQL in Amazon QuickSight
Connect to Sybase IQ and build visualizations of Sybase IQ using a MySQL Connection in Amazon QuickSight.
-
Integrate JotForm in the Pentaho Report Designer
Publish reports based on JotForm in the Pentaho BI tool.
-
Connect to Microsoft Exchange in RazorSQL
Connect to Microsoft Exchange from wizards and query Microsoft Exchange from the GUI in the RazorSQL database management tool.
-
Build Data Flows from Odoo to SQL Server using SSIS
Easily back up Odoo ERP to SQL Server using the SSIS components for Odoo.
-
Automated Continuous Twitter Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Twitter replication to IBM DB2.
-
Replicate Facebook Ads for Use in Salesforce Connect
Replicate Facebook Ads to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Automated Workflows with Live Reckon in Workato
Use CData Connect Cloud to connect to live Reckon and build automated workflows in Workato.
-
A PostgreSQL Interface for Sage 200 (MySQL Remoting via JDBC)
Use the Remoting features of the Sage 200 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Google Ads Reporting in OBIEE with the Google Ads JDBC Driver
Deploy the Google Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Dynamics 365 Business Central Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Google Cloud SQL.
-
SAP BusinessObjects BI Reporting in OBIEE with the SAP BusinessObjects BI JDBC Driver
Deploy the SAP BusinessObjects BI JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use Dash to Build to Web Apps on Sage 200
Create Python applications that use pandas and Dash to build Sage 200-connected web apps.
-
Video: Connecting to Google BigQuery Data from Microsoft Excel
This video shows how to use the CData ODBC Driver for Google BigQuery to connect to Google BigQuery. You will create a DSN and then use the Data Connection Wizard in Excel to retrieve BigQuery data.
-
Object-Relational Mapping (ORM) with Google Spanner 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 Google Spanner into a Java-based ORM framework, Hibernate.
-
Analyze Pinterest in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pinterest in Microsoft R Open.
-
How to publish and share Oracle Sales dashboards with Tableau Server
The CData ODBC driver for Oracle Sales enables you integrate Oracle Sales into Tableau dashboards.
-
How to Work with Zenefits in AWS Glue Jobs Using JDBC
Connect to Zenefits from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use JayDeBeApi to access Reckon in Python
Use standard Python scripting and the development environment of your choice to access live Reckon.
-
A PostgreSQL Interface for Zoho Projects (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho Projects JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SharePoint from Asprova with CData Software ODBC Driver for SharePoint
This article shows how to connect faster to SharePoint data from Asprova.
-
Visualize Zuora in Tableau
The CData ODBC driver for Zuora enables you integrate Zuora into Tableau dashboards.
-
Connect to Oracle Sales as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle Sales.
-
Build MVC Applications with Connectivity to JSON Services
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access JSON from an ASP.NET MVC application.
-
Analyze Snapchat Ads in Looker
Use CData Connect Cloud to connect to Snapchat Ads from Looker and build custom apps using live Snapchat Ads.
-
Use the CData SSIS Components to Insert New or Update Existing Facebook Records from SQL Server
Easily push SQL Server data to Facebook using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Facebook or update existing records with data from a SQL Server database.
-
Automated Continuous Marketo Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Marketo replication to OneLake in Microsoft Fabric.
-
Write a Simple Go Application to work with Azure Data Lake Storage on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Data Lake Storage.
-
Replicate Multiple Access Accounts
Replicate multiple Access accounts to one or many databases.
-
How to import JSON Services into Apache Solr
Use the CData Software JDBC Driver for JSON in Data Import Handler and create an automated import of JSON to Apache Solr Enterprise Search platform.
-
Deploy the ADO.NET Provider for Twitter on an SSRS Report Server
Connect to Twitter 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.
-
Use Dash to Build to Web Apps on Microsoft Planner
Create Python applications that use pandas and Dash to build Microsoft Planner-connected web apps.
-
Visualize Azure Data Lake Storage in Sisense
Create an ElastiCube in Sisense app with access to Azure Data Lake Storage.
-
Create Neo4J-Connected Visualizations in Klipfolio
Use CData Software Connect Server to connect to Neo4J from Klipfolio and build custom visualizations using live Neo4J.
-
Create Microsoft Planner-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to Microsoft Planner from Klipfolio and build custom visualizations using live Microsoft Planner.
-
Extract, Transform, and Load Xero in Informatica PowerCenter
Create a simple Workflow for Xero Accounting in Informatica PowerCenter.
-
Create Dynamic SAP Netweaver Gateway Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Netweaver Gateway to Infragistics XamDataGrid to build dynamic grids.
-
Model, Search, and Visualize Live Active Directory in ThoughtSpot
Use CData Connect Cloud to connect to live Active Directory for modeling, searching, and visualizing.
-
Connect to Oracle Financials Cloud in Ruby
Connect to Oracle Financials Cloud in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Validate Sugar CRM with QuerySurge
Access and validate Sugar CRM in QuerySurge using the CData JDBC Driver.
-
Access Live API in Excel (Desktop) via Connect Cloud
Use CData Connect Cloud to gain access to live API from your Excel spreadsheets.
-
How to connect and process Google Sheets from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Sheets
-
Process & Analyze Xero in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Xero .
-
Connect and Visualize Live Dynamics 365 Data in Databricks Lakehouse Federation with CData Connect Cloud
Use CData Connect Cloud to integrate live Microsoft Dynamics 365 into the Databricks platform and create visualization dashboards with real-time Microsoft Dynamics 365.
-
Provide OData Services of Dropbox from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Dropbox by developing a WCF Service Application.
-
How to Work with SAP Netweaver Gateway in AWS Glue Jobs Using JDBC
Connect to SAP Netweaver Gateway from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze Live Google Campaign Manager 360 in SAS Viya
Use CData Connect Cloud to connect to Google Campaign Manager 360 from SAS Viya and deploy self-service analytics using live Google Campaign Manager 360.
-
How to connect and process Oracle Eloqua from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Eloqua
-
Using AngularJS to Build Dynamic Web Pages with SharePoint
Use the CData Connect Server to create SharePoint OData feeds and build single-page applications with live Microsoft SharePoint.
-
Query QuickBooks Time in ColdFusion
Write standard ColdFusion data access code to connect to QuickBooks Time.
-
Use the CData Software ODBC Driver for SAP Ariba Source in MicroStrategy Web
Connect to SAP Ariba Source in MicroStrategy Web using the CData Software ODBC Driver for SAP Ariba Source.
-
Automated Continuous JSON Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable JSON replication to Google BigQuery.
-
Extract, Transform, and Load Azure Table in Informatica PowerCenter
Create a simple Workflow for Azure Table Storage in Informatica PowerCenter.
-
Automated Continuous Parquet Replication to SQLite
Use CData Sync for automated, continuous, customizable Parquet replication to SQLite.
-
Create SAS Data Sets-Connected Visualizations in Klipfolio
Use CData Software Connect Server to connect to SAS Data Sets from Klipfolio and build custom visualizations using live SAS Data Sets.
-
Use the CData Software JDBC Driver for Oracle in MicroStrategy
Connect to Oracle Database in MicroStrategy Developer using the CData Software JDBC Driver for Oracle.
-
Feed ShipStation into FineReport
How to set ShipStation as a JDBC data source in FineReport.
-
Object-Relational Mapping (ORM) with Avro 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 Apache Avro into a Java-based ORM framework, Hibernate.
-
Create Reports with IBM Informix in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date IBM Informix.
-
Create SAS xpt-Connected Business Apps in AppSheet
Use CData Software Connect Server to connect to SAS xpt from AppSheet and build custom business apps using live SAS XPORT.
-
Connect to HubSpot as an External Source in Dremio
Use the CData JDBC Driver to connect to HubSpot as an External Source in Dremio.
-
Connect to Redshift as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Amazon Redshift.
-
Build Semantic Layer Views for Azure Synapse in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Azure Synapse.
-
Access WooCommerce from MySQL in Amazon QuickSight
Connect to WooCommerce and build visualizations of WooCommerce using a MySQL Connection in Amazon QuickSight.
-
Connect to HCL Domino in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for HCL Domino in Airbyte.
-
Replicate Klipfolio from PowerShell
Write a quick PowerShell script to query Klipfolio. Use connectivity to the live data to replicate Klipfolio to SQL Server.
-
How to integrate ConstantContact with Apache Airflow
Access and process ConstantContact in Apache Airflow using the CData JDBC Driver.
-
Analyze SAP Hybris C4C in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of SAP Hybris C4C and visualize SAP Hybris C4C in SAP Analytics Cloud.
-
Analyze Live Google Search Results in SAS Viya
Use CData Connect Cloud to connect to Google Search from SAS Viya and deploy self-service analytics using live Google Search.
-
Query Smartsheet as a SQL Server Database in Node.js
Execute SQL Server queries against Smartsheet from Node.js.
-
Provide OData Services of Cassandra from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apache Cassandra by developing a WCF Service Application.
-
How to Query Live Acumatica Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Acumatica ERP data in natural language using Python.
-
How to Easily Query Amazon S3 in OpenOffice Base
-