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
-
Prepare, Blend, and Analyze Sugar CRM in Alteryx Designer (Connect Cloud)
Build workflows to access live Sugar CRM for self-service data analytics.
-
DataBind Controls to MariaDB in Delphi
DataBind to MariaDB in Delphi with standard data access components and controls.
-
Build Visualizations of Pipedrive in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pipedrive in Birst.
-
Validate Azure Data Lake Storage with QuerySurge
Access and validate Azure Data Lake Storage in QuerySurge using the CData JDBC Driver.
-
Author and Share Power BI Reports on Real-Time SAP ByDesign
Use the CData ODBC Driver for SAP ByDesign to visualize SAP Business ByDesign in Power BI Desktop and then upload to the Power BI service.
-
How to create Visio diagrams from IBM Cloud Data Engine
Automatically update IBM Cloud Data Engine with the changes you make to Visio master shapes.
-
Analyze GraphQL with Power Pivot
This article walks you through the process of using the CData ODBC Driver for GraphQL from Power Pivot. You will use the Table Import Wizard to load GraphQL. You can visually build the import query or use any SQL supported by the driver.
-
Build Pipelines with Live Google Ads in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to Google Ads from Google Cloud Data Fusion, enabling the integration of live Google Ads into the building and management of effective data pipelines.
-
Write a Simple Go Application to work with IBM Cloud Data Engine on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to IBM Cloud Data Engine.
-
How to Connect the Power BI Service to Snowflake: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Create Dashboards and Visualize Live Google Directory in Geckoboard
Use CData Connect Cloud to connect to live Google Directory and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Analyze Gmail in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of Gmail and visualize live Gmail in Infragistics Reveal.
-
Build Apps with Live Yahoo! Japan Data Solution in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live Yahoo! Japan Data Solution into the Adalo platform and build custom mobile and web applications with real-time Yahoo! Japan Data Solution.
-
LINQ to Splunk
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 Splunk Data Provider.
-
Connect to Clio in RapidMiner
Integrate Clio with standard components and data source configuration wizards in RapidMiner Studio.
-
Publish Reports with Aha in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Aha!.
-
Replicate SAP Hybris C4C to Multiple Databases via the CData Sync CLI
Replicate SAP Hybris C4C to disparate databases with a single configuration.
-
Visualize Office 365 in Tableau
The CData ODBC driver for Office 365 enables you integrate Microsoft Office 365 into Tableau dashboards.
-
A PostgreSQL Interface for Amazon S3 (MySQL Remoting via JDBC)
Use the Remoting features of the Amazon S3 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous SAP Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP replication to Amazon S3.
-
Publish Facebook Ads-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Facebook Ads.
-
Integrate with REST using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy REST to a JSON file on disk.
-
Use the CData Software ODBC Driver for QuickBooks Online in MicroStrategy Web
Connect to QuickBooks Online in MicroStrategy Web using the CData Software ODBC Driver for QuickBooks Online.
-
Create Data Visualizations in Cognos BI with ActiveCampaign
Access ActiveCampaign as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Viewing BigQuery in RAD Studio Data Explorer
How to view Google BigQuery in RAD Studio Data Explorer using the CData ODBC Driver for BigQuery.
-
Build an OLAP Cube in SSAS from Jira Service Management
Establish a connection to Atlassian Jira Service Management data from SQL Server Analysis Services, and use the Jira Service Management Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Printful from PowerBuilder via JDBC
This article demonstrates how to access Printful from PowerBuilder using the Printful JDBC Driver.
-
Integrate with Zoho Books in SnapLogic
Use CData Connect Cloud to connect to and integrate with live Zoho Books in SnapLogic.
-
Use JayDeBeApi to access CockroachDB in Python
Use standard Python scripting and the development environment of your choice to access live CockroachDB.
-
Automate MYOB AccountRight Replication to SAP HANA
Use CData Sync to customize and automate MYOB AccountRight replication to SAP HANA.
-
Automate Google Cloud Storage Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Cloud Storage from PowerShell? This article demonstrates how to utilize the Google Cloud Storage Cmdlets for tasks like connecting to Google Cloud Storage, automating operations, downloading data, and more.
-
Automate EventBrite Replication to Azure Synapse
Use CData Sync to customize and automate Eventbrite replication to Azure Synapse.
-
Automated Continuous WordPress Replication to MySQL
Use CData Sync for automated, continuous, customizable WordPress replication to MySQL.
-
Validate Dynamics 365 with QuerySurge
Access and validate Microsoft Dynamics 365 in QuerySurge using the CData JDBC Driver.
-
Create Data Visualizations Based On Sage 200 in Mode
Use CData Connect Cloud to connect to Sage 200 from Mode and build visualizations using live
-
Publish Crystal Reports on IBM Cloud Data Engine
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date IBM Cloud Data Engine.
-
Create a Data Access Object for Active Directory using JDBI
A brief overview of creating a SQL Object API for Active Directory in JDBI.
-
Analyze Acumatica with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Acumatica from Power Pivot. You will use the Table Import Wizard to load Acumatica ERP. You can visually build the import query or use any SQL supported by the driver.
-
Query Procore as a SQL Server in Node.js
Execute SQL Server queries against Procore from Node.js.
-
Automated Continuous GitHub Replication to Databricks
Use CData Sync for automated, continuous, customizable GitHub replication to Databricks.
-
Seamlessly Bring Twilio into Retool Using CData Connect Cloud
Integrate Twilio data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
-
Back Up Amazon DynamoDB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Amazon DynamoDB. In this article, we will employ an SSIS workflow to populate a database with Amazon DynamoDB data.
-
Publish Snowflake-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Snowflake.
-
How to load Microsoft Teams data into Elasticsearch via Logstash
Introducing a simple method to load Microsoft Teams data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Reports with Oracle SCM in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle SCM.
-
Configure the CData JDBC Driver for Calendly in a Connection Pool in Tomcat
Connect to Calendly from a connection pool in Tomcat.
-
Connect to Active Directory from Crystal Reports
Use CData Connect Cloud to connect to and report on live Active Directory from Crystal Reports.
-
Manage Zoho CRM in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoho CRM.
-
Use Biml to Build SSIS Tasks to Replicate FHIR to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate FHIR to SQL Server.
-
DataBind Dynamics CRM to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Dynamics CRM with the DevExpress Windows Forms and Web controls to provide Microsoft Dynamics CRM to a chart.
-
Integrate Amazon Athena into Power Automate Desktop using CData Connect
CData Connect for Amazon Athena enables you to integrate Amazon Athena into workflows built using Microsoft Power Automate Desktop.
-
How to connect to Tally from Spring Boot
Connect to Tally in a Spring Boot Application using CData JDBC Tally Driver
-
Feed Amazon Athena into FineReport
How to set Amazon Athena as a JDBC data source in FineReport.
-
Analyze Live Google Ads in SAS Viya
Use CData Connect Cloud to connect to Google Ads from SAS Viya and deploy self-service analytics using live Google Ads.
-
Build Pipelines with Live Yahoo! Japan Data Solution in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to Yahoo! Japan Data Solution from Google Cloud Data Fusion, enabling the integration of live Yahoo! Japan Data Solution into the building and management of effective data pipelines.
-
Automated Continuous Zoho Inventory Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Google BigQuery.
-
Use the CData Software ODBC Driver for ServiceNow in SAS for Real-Time Reporting and Analytics
Connect to real-time ServiceNow in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ServiceNow.
-
Publish Crystal Reports on IBM Cloud Object Storage
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date IBM Cloud Object Storage.
-
Feed Drift into FineReport
How to set Drift as a JDBC data source in FineReport.
-
Natively Connect to Calendly in PHP
The CData ODBC driver for Calendly enables you to create PHP applications with connectivity to Calendly. Leverage the native support for ODBC in PHP.
-
Create Informatica Mappings From/To a JDBC Data Source for Basecamp
Create Basecamp data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access IBM Informix in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for IBM Informix.
-
PowerShell Scripting to Replicate HCL Domino to MySQL
Write a simple PowerShell script to replicate HCL Domino to a MySQL database.
-
Connect to Freshdesk in Ruby
Connect to Freshdesk in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to MySQL in CloverDX (formerly CloverETL)
Transfer MySQL using the visual workflow in the CloverDX data integration tool.
-
Connect to XML from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time XML Files using standard SQL.
-
Build Pipelines with Live Stripe in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to Stripe from Google Cloud Data Fusion, enabling the integration of live Stripe into the building and management of effective data pipelines.
-
Build MVC Applications with Connectivity to SAP Ariba Procurement
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Ariba Procurement from an ASP.NET MVC application.
-
Automated Continuous Salesforce Marketing Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to PostgreSQL.
-
A PostgreSQL Interface for BambooHR (MySQL Remoting via JDBC)
Use the Remoting features of the BambooHR JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Semantic Layer Views for Asana in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Asana.
-
Connect to Live Microsoft Project in PostGresSQL Interface through CData Connect Cloud
Create a live connection to Microsoft Project in CData Connect Cloud and connect to your Microsoft Project from PostgreSQL.
-
Integrate Live Instagram into Blue Prism for Intelligent Robotic Process Automation (RPA)
-