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
-
Visualize EventBrite in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Eventbrite into TIBCO Spotfire.
-
Access Dynamics 365 from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dynamics 365 from HeidiSQL.
-
Design BIRT Reports on Sage 50 UK
Provide current Sage 50 UK to your embedded analytics.
-
Provide OData Services of Square from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Square by developing a WCF Service Application.
-
Connect to Azure Data Lake Storage from AWS Glue
Use CData Connect Cloud to gain access to live Azure Data Lake Storage from your AWS Glue jobs.
-
Connect to REST from PowerBuilder via JDBC
This article demonstrates how to access REST from PowerBuilder using the REST JDBC Driver.
-
Sybase IQ Reporting in OBIEE with the Sybase IQ JDBC Driver
Deploy the Sybase IQ JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect to SAP Business One from IntelliJ
Integrate connectivity to SAP Business One with wizards in IntelliJ.
-
Use the CData Software ODBC Driver for XML in MicroStrategy Web
Connect to XML Files in MicroStrategy Web using the CData Software ODBC Driver for XML.
-
Build Data Flows from SQL Server to Oracle Service Cloud through SSIS
Easily push SQL Server data to Oracle Service Cloud using the CData SSIS Tasks for Oracle Service Cloud.
-
Automated Continuous Excel Online Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Excel Online replication to delimited files (CSV/TSV).
-
Rapidly Develop Salesforce Marketing-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
How to integrate Zendesk with Apache Airflow
Access and process Zendesk in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous FHIR Replication to IBM DB2
Use CData Sync for automated, continuous, customizable FHIR replication to IBM DB2.
-
Connect to Phoenix in RazorSQL
Connect to Phoenix from wizards and query Apache Phoenix from the GUI in the RazorSQL database management tool.
-
DataBind Controls to Coinbase in Delphi
DataBind to Coinbase in Delphi with standard data access components and controls.
-
Connect to Exact Online from a Connection Pool in Jetty
The Exact Online JDBC Driver supports connection pooling: This article shows how to connect faster to Exact Online from Web apps in Jetty.
-
Connect to Microsoft OneDrive in RapidMiner
Integrate Microsoft OneDrive with standard components and data source configuration wizards in RapidMiner Studio.
-
Object-Relational Mapping (ORM) with PayPal 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 PayPal into a Java-based ORM framework, Hibernate.
-
Using the CData Software ODBC Driver for SAP Hybris C4C in PyCharm
Connect to SAP Hybris C4C as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Hybris C4C.
-
Connect to SAS Data Sets in SpagoBI
Create reports featuring live SAS Data Sets in SpagoBI Studio. Host SAS Data Sets reports on SpagoBI Server.
-
How to connect Amazon QuickSight to BigCommerce
Create a connection to BigCommerce in CData Connect Cloud and insert BigCommerce into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous NetSuite Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable NetSuite replication to Amazon Redshift.
-
Automated Continuous Sage Cloud Accounting Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Google Cloud SQL.
-
Replicate Google Calendar from PowerShell
Write a quick PowerShell script to query Google Calendar. Use connectivity to the live data to replicate Google Calendar to SQL Server.
-
Azure Analysis Services Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Azure Analysis Services facts in real time.
-
Create Acumatica Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Acumatica data access from reports, embedded analytics, and more.
-
Automated Continuous Procore Replication to SQLite
Use CData Sync for automated, continuous, customizable Procore replication to SQLite.
-
How to Create Power BI Visual Reports with Real-Time Drip
Use CData Power BI Connectors to visualize Drip in Power BI.
-
Create a Data Access Object for Drip using JDBI
A brief overview of creating a SQL Object API for Drip in JDBI.
-
Automated Continuous Oracle Eloqua Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Apache Kafka.
-
Bridge Pinterest Connectivity with Apache NiFi
Access and process Pinterest in Apache NiFi using the CData JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Cvent to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Cvent to SQL Server.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
How to connect to Vault CRM from IntelliJ
Integrate connectivity to Veeva Vault & Vault CRM with wizards in IntelliJ.
-
How to Seamlessly Import Microsoft Dataverse Data into IBM SPSS Modeler
Integrate Microsoft Dataverse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Seamlessly Bring Databricks into Retool Using CData Connect Cloud
Integrate Databricks data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
-
Build an OLAP Cube in SSAS from SuiteCRM
Establish a connection to SuiteCRM data from SQL Server Analysis Services, and use the SuiteCRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software ODBC Driver for Calendly in MicroStrategy Web
Connect to Calendly in MicroStrategy Web using the CData Software ODBC Driver for Calendly.
-
Analyze Bitbucket in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Bitbucket in Microsoft R Open.
-
Back Up YouTube Analytics to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for YouTube Analytics. In this article, we will employ an SSIS workflow to populate a database with YouTube Analytics data.
-
Build Azure DevOps-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live Azure DevOps and build Azure DevOps-connected web apps with Axios.
-
Connect to Live ShipStation in PostGresSQL Interface through CData Connect Cloud
Create a live connection to ShipStation in CData Connect Cloud and connect to your ShipStation from PostgreSQL.
-
Edit and Search External Cloudant Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of IBM Cloudant to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Cloudant objects that you can access from apps and the dashboard.
-
Automated Continuous Confluence Replication to Databricks
Use CData Sync for automated, continuous, customizable Confluence replication to Databricks.
-
Connect to and Visualize Live TaxJar in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live TaxJar.
-
Build Airtable-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Airtable.
-
Configure the CData JDBC Driver for Zoho CRM in a Connection Pool in Tomcat
Connect to Zoho CRM from a connection pool in Tomcat.
-
Automated Continuous SharePoint Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SharePoint replication to delimited files (CSV/TSV).
-
Visualize Stripe from Tableau
Use the Tableau Desktop business intelligence tool to connect to Stripe.
-
Build Pipelines with Live Snapchat Ads in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to Snapchat Ads from Google Cloud Data Fusion, enabling the integration of live Snapchat Ads into the building and management of effective data pipelines.
-
Use JayDeBeApi to access ActiveCampaign in Python
Use standard Python scripting and the development environment of your choice to access live ActiveCampaign.
-
Analyze Cassandra in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of Apache Cassandra and visualize live Apache Cassandra in Infragistics Reveal.
-
Prepare, Blend, and Analyze Epicor Kinetic in Alteryx Designer (Connect Cloud)
Build workflows to access live Epicor Kinetic for self-service data analytics.
-
Analyze GMO MakeShop in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of GMO MakeShop and visualize live GMO MakeShop in Infragistics Reveal.
-
Connect Zuora to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zuora using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Sales
Provide connectivity to Oracle Sales through an SAP BusinessObjects universe.
-
Migrating data from Bitbucket to Snowflake using CData SSIS Components.
Easily push Bitbucket to Snowflake using the CData SSIS Tasks for Bitbucket and Snowflake.
-
Manage Paylocity in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Paylocity.
-
Create Data Visualizations Based On Oracle SCM in Mode
Use CData Connect Cloud to connect to Oracle SCM from Mode and build visualizations using live
-
Automated Continuous Dynamics NAV Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Apache Cassandra.
-
Integrate Zoom in Pentaho Data Integration
Build ETL pipelines based on Zoom in the Pentaho Data Integration tool.
-
Analyze Excel Online in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Microsoft Excel Online and visualize Microsoft Excel Online in SAP Analytics Cloud.
-
DataBind Controls to Dynamics 365 in Delphi
DataBind to Microsoft Dynamics 365 in Delphi with standard data access components and controls.
-
Operational Reporting on Spark from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache Spark SQL.
-
How to connect to BigCommerce from Spring Boot
Connect to BigCommerce in a Spring Boot Application using CData JDBC BigCommerce Driver
-
Connect to Procore from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Procore to connect to Procore and execute queries in PowerBuilder.
-
Connect to Reckon Accounts Hosted in NetBeans
Connect to Reckon Accounts Hosted in NetBeans with the data source configuration wizard.
-
Connect Facebook to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Facebook using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize SAP in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SAP ERP/NetWeaver into TIBCO Spotfire.
-
Creating Freshdesk-Connected Applications in Unqork
You can use CData Connect Cloud to feed Freshdesk to Unqork and build custom business apps.
-
Automate Certinia Replication to Azure Data Lake
Use CData Sync to customize and automate Certinia replication to Azure Data Lake.
-
Connect to Real-Time Outreach.io Data in Power Apps Using Dataflows to Build Custom Applications
-