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
-
Connect to Oracle in ACL Analytics
Connect to Oracle Database via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Oracle Database.
-
How to Work with Sage Cloud Accounting in AWS Glue Jobs Using JDBC
Connect to Sage Cloud Accounting from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to PayPal in NetBeans
Connect to PayPal in NetBeans with the data source configuration wizard.
-
Import Real-Time CockroachDB via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use CockroachDB in ColdFusion.
-
How to publish and share Dynamics NAV dashboards with Tableau Server
The CData ODBC driver for Dynamics NAV enables you integrate Microsoft Dynamics NAV into Tableau dashboards.
-
Automated Continuous Kafka Replication to Oracle
Use CData Sync for automated, continuous, customizable Kafka replication to Oracle.
-
Create Informatica Mappings From/To an ODBC Data Source for Raisers Edge NXT
Create an ODBC connection to Raisers Edge NXT in Informatica and browse and transfer Raisers Edge NXT.
-
Use the CData Software JDBC Driver for Hive in MicroStrategy Desktop
Connect to Apache Hive in MicroStrategy Desktop using the CData Software JDBC Driver for Hive.
-
Easily Integrate Drift in Lazarus Pascal IDE
Learn how to easily integrate live Drift in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Reports with FTP in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FTP Servers.
-
Create Dynamics 365 Business Central-Connected Nintex Workflows
Use CData Connect Cloud to connect to Dynamics 365 Business Central from Nintex Workflow Cloud and build custom workflows using live Dynamics 365 Business Central.
-
How to Use a Microsoft Access Database to Update Paylocity in Real Time
Update Paylocity data by creating a linked table in Microsoft Access with the CData Paylocity ODBC Driver.
-
Automate OData Services Replication to Azure Data Lake
Use CData Sync to customize and automate OData replication to Azure Data Lake.
-
Build SAP Business One-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to SAP Business One from Zoho Analytics and import live SAP Business One.
-
Process & Analyze Sage 200 in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sage 200 .
-
Query Avro from Node.js
Use the OData endpoint of the CData API Server to connect to your Apache Avro and perform CRUD operations on Avro from Node.js.
-
Validate Redshift with QuerySurge
Access and validate Amazon Redshift in QuerySurge using the CData JDBC Driver.
-
LINQ to Slack
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 Slack Data Provider.
-
Choosing the Best Method to Connect Klipfolio to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Klipfolio from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to Live Oracle in n8n Workflows and Agents (via CData Connect Cloud)
Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your Oracle Database for you.
-
Model Excel Online Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Excel Online, enabling the direct import of real-time Microsoft Excel Online.
-
Load PostgreSQL to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PostgreSQL to a database.
-
Bidirectional Access to HCL Domino from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate HCL Domino in Filemaker Pro for Mac or Windows.
-
Create SSAS Tabular Models from Amazon DynamoDB
How to build a SQL Server Analysis Service Tabular Model from Amazon DynamoDB using CData drivers.
-
Enable the Kafka JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache Kafka.
-
Access Live SAP Ariba Source in Excel 365 Online (Excel for the web)
Connect to SAP Ariba Source from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Connect and Query Live Quickbase Data in Databricks with CData Connect Cloud
Use CData Connect Cloud to integrate live Quickbase into Databricks
-
Prepare, Blend, and Analyze Square in Alteryx Designer (Connect Cloud)
Build workflows to access live Square for self-service data analytics.
-
Connect to Redis from AWS Glue
Use CData Connect Cloud to gain access to live Redis from your AWS Glue jobs.
-
Connect Twilio to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Twilio using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize Live Sage Cloud Accounting in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sage Business Cloud Accounting.
-
Connect to Live Zuora in PostGresSQL Interface through CData Connect Cloud
Create a live connection to Zuora in CData Connect Cloud and connect to your Zuora from PostgreSQL.
-
Query ActiveCampaign in DataGrip
Create a Data Source for ActiveCampaign in DataGrip and use SQL to query live ActiveCampaign.
-
Connect to Google Spanner from a Connection Pool in Jetty
The Google Spanner JDBC Driver supports connection pooling: This article shows how to connect faster to Google Spanner from Web apps in Jetty.
-
Add Blackbaud FE NXT to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Blackbaud FE NXT with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to & Open NetSuite in Microsoft Excel
This article uses the CData ODBC driver for NetSuite to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Provide OData Services of SAP HANA from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP HANA by developing a WCF Service Application.
-
Connect to Vault CRM from Crystal Reports
Use CData Connect Cloud to connect to and report on live Veeva Vault & Vault CRM from Crystal Reports.
-
How to Easily Query Sage 200 in OpenOffice Base
-
