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
-
DataBind Controls to SAP in C++Builder
DataBind to SAP ERP/NetWeaver in C++Builder with standard components and controls.
-
Work with Oracle Sales in FoxPro
Load Oracle Sales into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Live Workday in the Power BI Service
Use CData Connect Cloud to connect to live Workday and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect PolyBase to Exact Online
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Exact Online.
-
Analyze SAP HANA in Cognos Analytics
Use CData Connect Cloud to connect to SAP HANA from Cognos Analytics and analyze live SAP HANA.
-
Build Semantic Layer Views for Harvest in APOS Live Data Gateway
Use the CData Connector for Harvest in APOS Live Data Gateway to build Semantic Layer Views for Harvest.
-
Automated Continuous Calendly Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Calendly replication to Google BigQuery.
-
Publish MailChimp-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MailChimp.
-
Create Apps from SAP in Qlik Sense Cloud
Use the CData Connect Server to create an OData API for SAP ERP/NetWeaver and build apps from live SAP ERP/NetWeaver in Qlik Sense Cloud.
-
How to integrate Metabase with Epicor Kinetic
Use CData Connect Cloud to connect to live Epicor Kinetic and create an interactive dashboard in Metabase from Epicor Kinetic.
-
Connect to Typeform as an External Source in Dremio
Use the CData JDBC Driver to connect to Typeform as an External Source in Dremio.
-
Connect to NetSuite in Ruby
Connect to NetSuite CRM & ERP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to and Query WooCommerce in QlikView over ODBC
Create data visualizations with WooCommerce in QlikView.
-
Connecting to Amazon DocumentDB with MongoDB Drivers
Set up an Amazon DocumentDB cluster and connect using any CData Software Driver for MongoDB.
-
Analyze Tableau CRM Analytics in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Tableau CRM Analytics and visualize Tableau CRM Analytics in SAP Analytics Cloud.
-
A PostgreSQL Interface for Acumatica (MySQL Remoting via JDBC)
Use the Remoting features of the Acumatica JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Azure Data Lake Storage 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 Azure Data Lake Storage.
-
Object-Relational Mapping (ORM) with SAP BusinessObjects BI 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 SAP BusinessObjects BI into a Java-based ORM framework, Hibernate.
-
How to connect to Azure Table from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Azure Table and work with Azure Table Storage in Microsoft Excel on Mac OS X.
-
Connect to Airtable in DBeaver
Use the CData ODBC Driver to connect to Airtable in DBeaver.
-
Analyze Redshift in R via JDBC
Use standard R functions and the development environment of your choice to analyze Amazon Redshift with the CData JDBC Driver for Redshift.
-
Analyze Live Blackbaud FE NXT in SAS Viya
Use CData Connect Cloud to connect to Blackbaud FE NXT from SAS Viya and deploy self-service analytics using live Blackbaud FE NXT.
-
Use the CData Software JDBC Driver for PostgreSQL in MicroStrategy Desktop
Connect to PostgreSQL in MicroStrategy Desktop using the CData Software JDBC Driver for PostgreSQL.
-
Edit and Search External Typeform Objects in Salesforce Connect
Use CData Connect Server to securely provide OData feeds of Typeform to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Typeform objects that you can access from apps and the dashboard.
-
Connect to Slack in DBeaver
Use the CData ODBC Driver to connect to Slack in DBeaver.
-
Visualize Live SAP Netweaver Gateway in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Netweaver Gateway.
-
Connect to QuickBooks Online in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for QuickBooks Online in Airbyte.
-
Use the CData Software JDBC Driver for TigerGraph in MicroStrategy
Connect to TigerGraph in MicroStrategy Developer using the CData Software JDBC Driver for TigerGraph.
-
Prepare, Blend, and Analyze CockroachDB in Alteryx Designer (ODBC)
Build workflows to access live CockroachDB for self-service data analytics.
-
Visualize Live Redshift in the Power BI Service
Use CData Connect Cloud to connect to live Amazon Redshift and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live Cvent of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Cvent using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Slack in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Slack in Microsoft R Open.
-
Model, Search, and Visualize Live SAP BusinessObjects BI in ThoughtSpot
Use CData Connect Cloud to connect to live SAP BusinessObjects BI for modeling, searching, and visualizing.
-
Integrate Act-On into Power Automate Desktop using CData Connect
CData Connect for Act-On enables you to integrate Act-On into workflows built using Microsoft Power Automate Desktop.
-
Visualize SAP Hybris C4C in Sisense
Create an ElastiCube in Sisense app with access to SAP Hybris C4C.
-
Automated Continuous Sage 50 UK Replication to SQLite
Use CData Sync for automated, continuous, customizable Sage 50 UK replication to SQLite.
-
Query Oracle Sales in ColdFusion
Write standard ColdFusion data access code to connect to Oracle Sales.
-
Build a PostgreSQL Interface for JotForm using the CData JDBC Driver
Use the Remoting features of the JotForm JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Google Contacts using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Contacts to a JSON file on disk.
-
Connect to REST in JRuby
Create a simple JRuby app with access to live REST.
-
Automated Continuous Marketo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Marketo replication to SingleStore.
-
Query Highrise through ODBC in Node.js
Use node-odbc to execute SQL queries against Highrise CRM from Node.js.
-
Create a Data Access Object for Procore using JDBI
A brief overview of creating a SQL Object API for Procore in JDBI.
-
Connect to Okta in Jaspersoft Studio
Execute SQL to remote Okta in Jaspersoft Studio.
-
How to create an RPA flow for Salesforce in UiPath Studio
Use the Salesforce ODBC Driver to create workflows that access real-time Salesforce & Force.com without any coding.
-
Automated Continuous SAP Ariba Source Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Apache Cassandra.
-
Access Exact Online as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Exact Online from your Oracle system.
-
Integrate Slack in Pentaho Data Integration
Build ETL pipelines based on Slack in the Pentaho Data Integration tool.
-
Create Sage 300 Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous HubSpot Replication to SQL Server
Use CData Sync for automated, continuous, customizable HubSpot replication to SQL Server.
-
How to Query Live Workday Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Workday data in natural language using Python.
-
Build Microsoft Planner Visualizations in Tableau Cloud
Use CData Connect Cloud to connect to live Microsoft Planner and build visualizations in Tableau Cloud.
-
Import BigQuery into FileMaker Pro
Create reports that integrate Google BigQuery in Filemaker Pro.
-
How to connect to SingleStore from IntelliJ
Integrate connectivity to SingleStore with wizards in IntelliJ.
-
Connect to Azure Analysis Services in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for Azure Analysis Services in Airbyte.
-
How to Work with Smartsheet in AWS Glue Jobs Using JDBC
Connect to Smartsheet from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Excel Spreadsheet Automation on Oracle Sales with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect to SAP ByDesign in JRuby
Create a simple JRuby app with access to live SAP Business ByDesign.
-
Publish Reports with HCL Domino in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HCL Domino.
-
DocuSign Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on DocuSign facts in real time.
-
Integrate with Google Drive using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Drive to a JSON file on disk.
-
Query EventBrite as a SQL Server in Node.js
Execute SQL Server queries against Eventbrite from Node.js.
-
Automated Continuous Sage 50 UK Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sage 50 UK replication to AlloyDB.
-
Viewing Smartsheet in RAD Studio Data Explorer
How to view Smartsheet in RAD Studio Data Explorer using the CData ODBC Driver for Smartsheet.
-
Publish Unbounce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Unbounce.
-
Visualize Amazon Athena from Tableau
Use the Tableau Desktop business intelligence tool to connect to Amazon Athena.
-
Use the CData Software ODBC Driver for Databricks in SAS for Real-Time Reporting and Analytics
Connect to real-time Databricks in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Databricks.
-
Automated Continuous DocuSign Replication to IBM DB2
Use CData Sync for automated, continuous, customizable DocuSign replication to IBM DB2.
-
How to connect to QuickBooks Time from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for QuickBooks Time and work with QuickBooks Time in Microsoft Excel on Mac OS X.
-
Automated Continuous Oracle HCM Cloud Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Vertica.
-
Build Semantic Layer Views for Google Cloud Storage in APOS Live Data Gateway
Use the CData Connector for Google Cloud Storage in APOS Live Data Gateway to build Semantic Layer Views for Google Cloud Storage.
-
How to connect and process Sage 300 from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sage 300
-
Use Biml to Build SSIS Tasks to Replicate EnterpriseDB to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate EnterpriseDB to SQL Server.
-
Integrate Live HDFS into Custom Business Apps Built in Power Apps
Use CData Software Connect Server to create a virtual SQL Server Database for Apache HDFS and integrate live Apache HDFS into apps built in Microsoft Power Apps.
-
Edit and Search External Marketo Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of Marketo to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Marketo objects that you can access from apps and the dashboard.
-
Build Semantic Layer Views for SAP Fieldglass in APOS Live Data Gateway
Use the CData Connector for SAP Fieldglass in APOS Live Data Gateway to build Semantic Layer Views for SAP Fieldglass.
-
Bidirectional Access to Amazon DynamoDB from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Amazon DynamoDB in Filemaker Pro for Mac or Windows.
-
How to connect PolyBase to Microsoft OneDrive
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft OneDrive.
-
Provide OData Services of Zoho CRM from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoho CRM by developing a WCF Service Application.
-
How to create Visio diagrams from Snowflake
Automatically update Snowflake with the changes you make to Visio master shapes.
-
Query Power BI XMLA as a SQL Server Database in Node.js
Execute SQL Server queries against Power BI XMLA from Node.js.
-
Import Bing Search Results Using Azure Data Factory
Use CData Connect Cloud to connect to Bing Search Results from Azure Data Factory and import live Bing Search.
-
Replicate WordPress to Multiple Databases
Replicate WordPress to disparate databases with a point-and-click configuration.
-
How to Access Live SAS Data Sets in Power Automate Desktop via ODBC
The CData ODBC Driver for SAS Data Sets enables you to integrate SAS Data Sets into workflows built using Microsoft Power Automate Desktop.
-
Create Snowflake-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to Snowflake from OutSystems and build custom enterprise apps using live Snowflake.
-
Publish Crystal Reports on SharePoint
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft SharePoint.
-
Visualize Live Adobe Commerce in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live Adobe Commerce into custom reports in Power BI.
-
Build a Simple VCL Application for QuickBooks
How to build a simple VCL Application to view QuickBooks Desktop in RAD Studio using the CData ODBC Driver for QuickBooks.
-
Integrate with live Microsoft Project in Jitterbit
Use CData Connect Cloud to connect to and integrate live Microsoft Project in Jitterbit.
-
Connect to ActiveCampaign in SpagoBI
Create reports featuring live ActiveCampaign in SpagoBI Studio. Host ActiveCampaign reports on SpagoBI Server.
-
Replicate Aha to Multiple Databases via the CData Sync CLI
Replicate Aha! to disparate databases with a single configuration.
-
Integrate SAS xpt with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAS xpt with External Services.
-
Use the CData Software ODBC Driver for Redshift in MicroStrategy Desktop
Connect to Amazon Redshift in MicroStrategy Desktop using the CData Software ODBC Driver for Redshift.
-
Automated Continuous Google Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Ads replication to SQL Server.
-
Create Dynamic Zuora Grids Using the Infragistics XamDataGrid
Learn how you can connect Zuora to Infragistics XamDataGrid to build dynamic grids.
-
Import SAP Hybris C4C into FileMaker Pro
Create reports that integrate SAP Hybris C4C in Filemaker Pro.
-
Connect to Typeform in Aqua Data Studio
Access Typeform from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Publish Reports with Typeform in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Typeform.
-
Create Cloudant-Connected Nintex Workflows
Use CData Connect Cloud to connect to Cloudant from Nintex Workflow Cloud and build custom workflows using live IBM Cloudant.
-
DataBind Wijmo Grid to Reckon
Provide real-time Reckon to interactive controls.