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
-
Workday: How to Access Live Data from the WQL for a Workday Report
CData
-
Access Live Microsoft Planner in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Planner from your Google Sheets.
-
Design BIRT Reports on Redshift
Provide current Amazon Redshift to your embedded analytics.
-
Migrating data from Facebook Ads to Snowflake using CData SSIS Components.
Easily push Facebook Ads to Snowflake using the CData SSIS Tasks for Facebook Ads and Snowflake.
-
How to Access Live Google Data Catalog in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Data Catalog enables you to integrate Google Data Catalog into workflows built using Microsoft Power Automate Desktop.
-
How to Connect the Power BI Service to Salesforce: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Build a PostgreSQL Interface for Odoo using the CData JDBC Driver
Use the Remoting features of the Odoo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate SAP Concur into Power Automate Desktop using CData Connect
CData Connect for SAP Concur enables you to integrate SAP Concur into workflows built using Microsoft Power Automate Desktop.
-
Object-Relational Mapping (ORM) with JSON Services 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 JSON into a Java-based ORM framework, Hibernate.
-
Integrate Live Adobe Commerce into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Adobe Commerce from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Adobe Commerce.
-
Access Live MongoDB in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MongoDB from your Excel spreadsheets.
-
Choosing the Best Method to Connect ActiveCampaign to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ActiveCampaign from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect SharePoint with Highrise through external lists
Provide Highrise CRM to SharePoint users as an external list.
-
How to Seamlessly Import MariaDB Data into IBM SPSS Modeler
Integrate MariaDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to and Query Trello in QlikView over ODBC
Create data visualizations with Trello in QlikView.
-
Viewing Zenefits in RAD Studio Data Explorer
How to view Zenefits in RAD Studio Data Explorer using the CData ODBC Driver for Zenefits.
-
Automated Continuous SAP Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP replication to Amazon S3.
-
Connect and Visualize Live ServiceNow Data in Databricks Lakehouse Federation with CData Connect Cloud
Use CData Connect Cloud to integrate live ServiceNow into the Databricks platform and create visualization dashboards with real-time ServiceNow.
-
Natively Connect to Amazon S3 in PHP
The CData ODBC driver for Amazon S3 enables you to create PHP applications with connectivity to Amazon S3. Leverage the native support for ODBC in PHP.
-
Connect to Cloudant in DBArtisan
Use wizards in DBArtisan to configure IBM Cloudant as a data source.
-
Build Semantic Layer Views for Exact Online in APOS Live Data Gateway
Use the CData Connector for Exact Online in APOS Live Data Gateway to build Semantic Layer Views for Exact Online.
-
Create Informatica Mappings From/To an ODBC Data Source for Redshift
Create an ODBC connection to Redshift in Informatica and browse and transfer Amazon Redshift.
-
Working with RSS Feeds in LINQPad
Execute LINQ queries to RSS Feeds in LINQPad.
-
Create Datasets from SAP HANA XS Advanced in Domo Workbench and Build Visualizations of SAP HANA XS Advanced in Domo
Use the CData Software ODBC Driver for SAP HANA XS Advanced to create datasets from SAP HANA XS Advanced in Domo Workbench and then build visualizations in the Domo service.
-
Publish Crystal Reports on Email
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Email.
-
Automated Continuous Box Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Box replication to Apache Kafka.
-
Connect to DocuSign in SpagoBI
Create reports featuring live DocuSign in SpagoBI Studio. Host DocuSign reports on SpagoBI Server.
-
Analyze Live ADP in SAS Viya
Use CData Connect Cloud to connect to ADP from SAS Viya and deploy self-service analytics using live ADP.
-
Integrate Live Azure Synapse into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Azure Synapse from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Synapse.
-
Connect to Live Databricks in MicroStrategy through CData Connect Cloud
Create a live connection to Databricks in CData Connect Cloud and connect to your Databricks from MicroStrategy.
-
Create SSAS Tabular Models from Epicor Kinetic
How to build a SQL Server Analysis Service Tabular Model from Epicor Kinetic using CData drivers.
-
Build Visualizations of WordPress in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of WordPress in Birst.
-
Connect to Office 365 in RazorSQL
Connect to Office 365 from wizards and query Microsoft Office 365 from the GUI in the RazorSQL database management tool.
-
Connect to Certinia in DBeaver
Use the CData ODBC Driver to connect to Certinia in DBeaver.
-
Visualize Kintone in TIBCO Spotfire through ADO.NET
Integrate Kintone into dashboards in TIBCO Spotfire.
-
Automated Continuous NetSuite Replication to MySQL
Use CData Sync for automated, continuous, customizable NetSuite replication to MySQL.
-
Automated Continuous SAP Hybris C4C Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Databricks.
-
Visualize xBase from Tableau
Use the Tableau Desktop business intelligence tool to connect to xBase.
-
Use the CData ODBC Driver for Avro in Microsoft Power Query
You can use the CData Avro ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Avro into Microsoft Power Query.
-
Connect to Azure Analysis Services from Crystal Reports
Use CData Connect Cloud to connect to and report on live Azure Analysis Services from Crystal Reports.
-
Visualize Google Campaign Manager 360 in TIBCO Spotfire through ADO.NET
Integrate Google Campaign Manager 360 into dashboards in TIBCO Spotfire.
-
Automated Continuous FHIR Replication to SQL Server
Use CData Sync for automated, continuous, customizable FHIR replication to SQL Server.
-
Publish Crystal Reports on ADP
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ADP.
-
Enable the Oracle Service Cloud JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle Service Cloud.
-
Integrate with Okta in JReport Designer
Create charts and reports based on Okta in JReport Designer.
-
Connect to Pinterest in Ruby
Connect to Pinterest in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect the Power BI Service to Salesforce Data Cloud: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Visualize Microsoft Exchange in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Exchange into TIBCO Spotfire.
-
Import ADP into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access ADP. In this article, you will use the OData format to import ADP into Microsoft Power Query.
-
Build Data Flows from HDFS to SQL Server using SSIS
Easily back up Apache HDFS to SQL Server using the SSIS components for HDFS.
-
ETL Highrise in Oracle Data Integrator
This article shows how to transfer Highrise CRM into a data warehouse using Oracle Data Integrator.
-
Migrating data from WordPress to Google BigQuery using CData SSIS Components.
Easily push WordPress to Google BigQuery using the CData SSIS Tasks for WordPress and Google BigQuery.
-
Access Live Snowflake in Coginiti Pro
Connect to and query live Snowflake from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect to HBase with Squirrel SQL client
Connect to Apache HBase and execute queries in the Squirrel SQL Client.
-
Automated Continuous Oracle HCM Cloud Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to SQL Server.
-
Import Facebook Ads Using Azure Data Factory
Use CData Connect Cloud to connect to Facebook Ads from Azure Data Factory and import live Facebook Ads.
-
Automated Continuous Parquet Replication to SingleStore
Use CData Sync for automated, continuous, customizable Parquet replication to SingleStore.
-
View Reports on Real-Time Tally in Power BI Report Server
Use the CData ODBC Driver for Tally to visualize Tally ERP in Power BI Desktop and then publish them to Power BI Report Server.
-
Back Up CSV/TSV Files to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for CSV. In this article, we will employ an SSIS workflow to populate a database with CSV/TSV Files data.
-
Configure the CData JDBC Driver for Monday.com in a Connection Pool in Tomcat
Connect to Monday.com from a connection pool in Tomcat.
-
Access Live LinkedIn Ads in Coginiti Pro
Connect to and query live LinkedIn Ads from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build MVC Applications with Connectivity to Google Directory
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Directory from an ASP.NET MVC application.
-
Access Cassandra as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache Cassandra from your Oracle system.
-
Access Live Hive in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Apache Hive from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to connect to Google Drive from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Google Drive and work with Google Drive in Microsoft Excel on Mac OS X.
-
How to Work with Klipfolio in AWS Glue Jobs Using JDBC
Connect to Klipfolio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query Google Directory in DataGrip
Create a Data Source for Google Directory in DataGrip and use SQL to query live Google Directory.
-
Use the CData ODBC Driver for Klipfolio in Microsoft Power Query
You can use the CData Klipfolio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Klipfolio into Microsoft Power Query.
-
Connect to Veeva Vault from HeidiSQL
Use CData Connect Cloud to connect to and query live Veeva Vault & Vault CRM from HeidiSQL.
-
Integrating Harvest in Talend Cloud Data Management Platform
-