# CData Drivers

**URL:** https://community.cdata.com/c/live-connectivity/cdata-drivers/35.md

[Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md)

---

## [About the CData Drivers category](https://community.cdata.com/t/about-the-cdata-drivers-category/1465)

<div class="topic-metadata">

**Author:** [@system](https://community.cdata.com/u/system)\
**Replies:** 0\
**Last updated:** [October 21, 2026, 3:35pm UTC](https://community.cdata.com/t/about-the-cdata-drivers-category/1465 "2026-10-21T15:35:18Z")

</div>

Share product questions and get support for CData Drivers & Connectors

---

## [MSIX vs Zipped Version of Claude Desktop on Windows - caused Cdata MCP failures](https://community.cdata.com/t/msix-vs-zipped-version-of-claude-desktop-on-windows-caused-cdata-mcp-failures/1340)

<div class="topic-metadata">

**Author:** [@njoffe](https://community.cdata.com/u/njoffe)\
**Replies:** 2\
**Last updated:** [November 11, 2026, 7:52pm UTC](https://community.cdata.com/t/msix-vs-zipped-version-of-claude-desktop-on-windows-caused-cdata-mcp-failures/1340 "2026-11-11T19:52:08Z")

</div>

I installed the CDataSoftware/cdata-jdbc-mcp-server from Github and attempted to query an excel spreadsheet on my Windows 11 laptop. At one point, I had installed the MSIX version of Claude. Then later, installed the zi…

---

## [Can not get data in Power BI using SuiteCRM Sys](https://community.cdata.com/t/can-not-get-data-in-power-bi-using-suitecrm-sys/1337)

<div class="topic-metadata">

**Author:** [@KaziMahmud](https://community.cdata.com/u/KaziMahmud)\
**Replies:** 3\
**Last updated:** [October 9, 2026, 11:07am UTC](https://community.cdata.com/t/can-not-get-data-in-power-bi-using-suitecrm-sys/1337 "2026-10-09T11:07:55Z")

</div>

I’m using CData SuiteCRM. Previously the connection was established and could bring in data to Power BI, as well as refresh on Power BI service. But after setting the following for Caching, the tables cannot be found fr…

---

## [Fetch Multiple Related Tables in One API Call Using OData $expand in CData API Server](https://community.cdata.com/t/fetch-multiple-related-tables-in-one-api-call-using-odata-expand-in-cdata-api-server/1332)

<div class="topic-metadata">

**Author:** [@Somya](https://community.cdata.com/u/Somya)\
**Replies:** 0\
**Last updated:** [October 6, 2026, 4:47am UTC](https://community.cdata.com/t/fetch-multiple-related-tables-in-one-api-call-using-odata-expand-in-cdata-api-server/1332 "2026-10-06T04:47:28Z")

</div>

Pulling a customer, their orders, and the products in each order often takes three or four separate API calls per screen. The result is slower load times and client-side code that’s hard to maintain. With CData API Serve…

---

## [Access Live Salesforce Data in AWS Batch with CData JDBC Drivers](https://community.cdata.com/t/access-live-salesforce-data-in-aws-batch-with-cdata-jdbc-drivers/1310)

<div class="topic-metadata">

**Author:** [@Mohsin](https://community.cdata.com/u/Mohsin)\
**Replies:** 0\
**Last updated:** [June 30, 2026, 4:31pm UTC](https://community.cdata.com/t/access-live-salesforce-data-in-aws-batch-with-cdata-jdbc-drivers/1310 "2026-06-30T16:31:22Z")

</div>

Run scheduled Java workloads on AWS Batch without managing servers. This guide shows how to query live Salesforce data using the CData JDBC Driver, package your application with Docker, deploy it to Amazon ECR, schedule …

---

## [APIServer to query another table before calling procedure](https://community.cdata.com/t/apiserver-to-query-another-table-before-calling-procedure/1300)

<div class="topic-metadata">

**Author:** [@erdem](https://community.cdata.com/u/erdem)\
**Replies:** 1\
**Last updated:** [June 19, 2026, 5:53pm UTC](https://community.cdata.com/t/apiserver-to-query-another-table-before-calling-procedure/1300 "2026-06-19T17:53:28Z")

</div>

Using CData APIServer™ 2026 - 26.1.9585.0 I created an API which connects to an Oracle stored procedure and another API which connects to Azure AD. I am trying to modify incoming request before calling the stored proced…

---

## [Cannot Access Data in Sheet from SSIS Smartsheet Connector](https://community.cdata.com/t/cannot-access-data-in-sheet-from-ssis-smartsheet-connector/1302)

<div class="topic-metadata">

**Author:** [@Breadcrumb](https://community.cdata.com/u/Breadcrumb)\
**Replies:** 1\
**Last updated:** [June 15, 2026, 10:00pm UTC](https://community.cdata.com/t/cannot-access-data-in-sheet-from-ssis-smartsheet-connector/1302 "2026-06-15T22:00:10Z")

</div>

Hello, I have a particular SSIS Package that loads data from a Smartsheet into a SQL Server table via an OLE DB Destination component. This is a very standard setup at my org, and this exact package had been chugging al…

---

## [How to Connect API Data sources to Power BI using CData API Driver](https://community.cdata.com/t/how-to-connect-api-data-sources-to-power-bi-using-cdata-api-driver/1298)

<div class="topic-metadata">

**Author:** [@Anusha\_M\_B](https://community.cdata.com/u/Anusha_M_B)\
**Replies:** 0\
**Last updated:** [June 2, 2026, 10:10am UTC](https://community.cdata.com/t/how-to-connect-api-data-sources-to-power-bi-using-cdata-api-driver/1298 "2026-06-02T10:10:22Z")

</div>

Skip the custom connector. The CData API Driver pulls REST API data directly into Power BI in a few steps. For more information, refer to: How to Connect API Data Sources to Power BI Using CData API Driver

---

## [TDV用のCDataドライバーのサポート受付について](https://community.cdata.com/t/tdv-cdata/1297)

<div class="topic-metadata">

**Author:** [@TOMOKAZU\_MASAGO](https://community.cdata.com/u/TOMOKAZU_MASAGO)\
**Replies:** 1\
**Last updated:** [June 2, 2026, 7:16am UTC](https://community.cdata.com/t/tdv-cdata/1297 "2026-06-02T07:16:04Z")

</div>

ジャパンシステム株式会社 真砂と申します。 弊社は国内総代理店であるNTTドコモビジネスX社の代理店としてお客様へTDVを購入していただいております。 TDVではいくつかのドライバをサポートしている旨、ガイドなどに記載されていますが、一般的なjdbcドライバなどは製品元へ問い合わせするものであり、ドライバの使用についてはユーザ(お客様)の都合によるためお客様より各ドライバのベンダー様へ問い合わせるものと認識しております。 CDat…

---

## [CData API Server V25 on AWS](https://community.cdata.com/t/cdata-api-server-v25-on-aws/1296)

<div class="topic-metadata">

**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\
**Replies:** 0\
**Last updated:** [May 26, 2026, 9:29am UTC](https://community.cdata.com/t/cdata-api-server-v25-on-aws/1296 "2026-05-26T09:29:49Z")

</div>

Hey CData Community! We recently put together a step-by-step guide for deploying CData API Server V25 in a production-grade high-availability setup on AWS, covering the full stack: dual EC2 instances sharing an RDS conf…

---

## [How to Keep Microsoft Access Working After the Salesforce Connector Discontinuation](https://community.cdata.com/t/how-to-keep-microsoft-access-working-after-the-salesforce-connector-discontinuation/1284)

<div class="topic-metadata">

**Author:** [@Somya](https://community.cdata.com/u/Somya)\
**Replies:** 0\
**Last updated:** [April 14, 2026, 4:51am UTC](https://community.cdata.com/t/how-to-keep-microsoft-access-working-after-the-salesforce-connector-discontinuation/1284 "2026-04-14T04:51:20Z")

</div>

Microsoft is retiring the built-in Salesforce connector in Access, which may disrupt existing workflows and break live connections to Salesforce data. To maintain connectivity, teams can switch to ODBC-based solutions l…

---

## [How to Keep Microsoft Access Working After an ERP Cloud Migration](https://community.cdata.com/t/how-to-keep-microsoft-access-working-after-an-erp-cloud-migration/1281)

<div class="topic-metadata">

**Author:** [@Somya](https://community.cdata.com/u/Somya)\
**Replies:** 0\
**Last updated:** [March 30, 2026, 10:42am UTC](https://community.cdata.com/t/how-to-keep-microsoft-access-working-after-an-erp-cloud-migration/1281 "2026-03-30T10:42:08Z")

</div>

Migrating to cloud ERPs like Acumatica, NetSuite, or Business Central often removes direct SQL access, disrupting Microsoft Access-based workflows many finance teams rely on. Since SaaS ERPs use API-only architectures, …

---

## [Resolving NetSuite Schema Replication Failures in Microsoft Fabric using CData](https://community.cdata.com/t/resolving-netsuite-schema-replication-failures-in-microsoft-fabric-using-cdata/1274)

<div class="topic-metadata">

**Author:** [@Anusha\_M\_B](https://community.cdata.com/u/Anusha_M_B)\
**Replies:** 0\
**Last updated:** [March 20, 2026, 4:31am UTC](https://community.cdata.com/t/resolving-netsuite-schema-replication-failures-in-microsoft-fabric-using-cdata/1274 "2026-03-20T04:31:37Z")

</div>

Tired of broken NetSuite schema replication in Microsoft Fabric? Learn how the CData JDBC Driver solves connector limitations and ensures accurate, complete data replication. Read the full guide: Resolving NetSuite Sch…

---

## [Creating Linked Servers in AWS RDS for SQL Server (Without the SSMS UI)](https://community.cdata.com/t/creating-linked-servers-in-aws-rds-for-sql-server-without-the-ssms-ui/1258)

<div class="topic-metadata">

**Author:** [@Mohsin](https://community.cdata.com/u/Mohsin)\
**Replies:** 0\
**Last updated:** [January 9, 2026, 11:30am UTC](https://community.cdata.com/t/creating-linked-servers-in-aws-rds-for-sql-server-without-the-ssms-ui/1258 "2026-01-09T11:30:25Z")

</div>

AWS RDS for SQL Server simplifies backups, patching, and high availability, but its managed model restricts certain administrative actions — including creating linked servers through the SSMS UI. If you see errors like “…

---

## [How to Use an External ID to Perform an UPSERT Operation against Salesforce](https://community.cdata.com/t/how-to-use-an-external-id-to-perform-an-upsert-operation-against-salesforce/1252)

<div class="topic-metadata">

**Author:** [@Somya](https://community.cdata.com/u/Somya)\
**Replies:** 0\
**Last updated:** [December 11, 2025, 4:57am UTC](https://community.cdata.com/t/how-to-use-an-external-id-to-perform-an-upsert-operation-against-salesforce/1252 "2025-12-11T04:57:09Z")

</div>

The CData Salesforce connectivity solutions make it easy to synchronize data with Salesforce by enabling seamless UPSERT operations using External IDs. An External ID allows you to match records from your source system w…

---

## [Understanding Dynamics 365 & Dataverse API Limits](https://community.cdata.com/t/understanding-dynamics-365-dataverse-api-limits/1244)

<div class="topic-metadata">

**Author:** [@Mohsin](https://community.cdata.com/u/Mohsin)\
**Replies:** 0\
**Last updated:** [December 2, 2025, 2:22pm UTC](https://community.cdata.com/t/understanding-dynamics-365-dataverse-api-limits/1244 "2025-12-02T14:22:45Z")

</div>

API limits in Microsoft Dynamics 365 and Dataverse directly affect integration performance, throughput, and reliability. To help teams plan and optimize usage, we published a clear breakdown of daily request allocations,…

---

## [How to Retrieve More Than 5000 Records in CData SharePoint Drivers](https://community.cdata.com/t/how-to-retrieve-more-than-5000-records-in-cdata-sharepoint-drivers/1241)

<div class="topic-metadata">

**Author:** [@Anusha\_M\_B](https://community.cdata.com/u/Anusha_M_B)\
**Replies:** 0\
**Last updated:** [November 27, 2025, 5:59am UTC](https://community.cdata.com/t/how-to-retrieve-more-than-5000-records-in-cdata-sharepoint-drivers/1241 "2025-11-27T05:59:11Z")

</div>

Hey CData Community! Struggling with SharePoint’s 5,000-item limit? Our latest article shows how to easily bypass this threshold using CData SharePoint Drivers. Discover simple steps to access larger datasets smoothly a…

---

## [Make API Requests with a Custom Shopify Admin API Token Using the CData Shopify JDBC Driver](https://community.cdata.com/t/make-api-requests-with-a-custom-shopify-admin-api-token-using-the-cdata-shopify-jdbc-driver/1235)

<div class="topic-metadata">

**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\
**Replies:** 0\
**Last updated:** [November 9, 2025, 4:03am UTC](https://community.cdata.com/t/make-api-requests-with-a-custom-shopify-admin-api-token-using-the-cdata-shopify-jdbc-driver/1235 "2025-11-09T04:03:06Z")

</div>

Hey CData Community! Accessing your Shopify data just got simpler! Our latest guide walks you through generating a custom Admin API token and connecting seamlessly with CData Shopify JDBC Driver, enabling smooth, SQL-s…

---

## [How to Update Salesforce Records from Excel with CDATAUPDATE: Excel Add-In for Salesforce](https://community.cdata.com/t/how-to-update-salesforce-records-from-excel-with-cdataupdate-excel-add-in-for-salesforce/1233)

<div class="topic-metadata">

**Author:** [@Yazhini\_Gopalakrishnan](https://community.cdata.com/u/Yazhini_Gopalakrishnan)\
**Replies:** 0\
**Last updated:** [November 7, 2025, 12:57pm UTC](https://community.cdata.com/t/how-to-update-salesforce-records-from-excel-with-cdataupdate-excel-add-in-for-salesforce/1233 "2025-11-07T12:57:31Z")

</div>

Hey CData community, If you’re working with live data in Salesforce and want to harness the full power of Excel to update records — you’re going to like this. With the CData Excel Add-In for Salesforce, the article show…

---

## [How to Manage Multiple Attachments in Kintone Using the CData Kintone JDBC Driver](https://community.cdata.com/t/how-to-manage-multiple-attachments-in-kintone-using-the-cdata-kintone-jdbc-driver/1231)

<div class="topic-metadata">

**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\
**Replies:** 0\
**Last updated:** [November 6, 2025, 5:01am UTC](https://community.cdata.com/t/how-to-manage-multiple-attachments-in-kintone-using-the-cdata-kintone-jdbc-driver/1231 "2025-11-06T05:01:41Z")

</div>

Hey CData Community! Ever found yourself wrestling with attachments in Kintone and thought, “there’s gotta be an easier way”? Good news: we just dropped a guide on how to bulk upload/delete/manage multiple files in Kin…

---

## [How to Retrieve Salesforce Formula Fields in Tableau](https://community.cdata.com/t/how-to-retrieve-salesforce-formula-fields-in-tableau/1230)

<div class="topic-metadata">

**Author:** [@Somya](https://community.cdata.com/u/Somya)\
**Replies:** 0\
**Last updated:** [November 5, 2025, 6:30am UTC](https://community.cdata.com/t/how-to-retrieve-salesforce-formula-fields-in-tableau/1230 "2025-11-05T06:30:04Z")

</div>

The CData Tableau Connector for Salesforce enables you to access, visualize, and analyze live Salesforce data directly within Tableau without complex setup or manual exports. Using the connector’s dynamic capabilities, y…

---

## [Bulk Import Tasks from Excel to MS Planner: Excel Add-In for MS Planner](https://community.cdata.com/t/bulk-import-tasks-from-excel-to-ms-planner-excel-add-in-for-ms-planner/1229)

<div class="topic-metadata">

**Author:** [@Yazhini\_Gopalakrishnan](https://community.cdata.com/u/Yazhini_Gopalakrishnan)\
**Replies:** 0\
**Last updated:** [October 31, 2025, 11:29am UTC](https://community.cdata.com/t/bulk-import-tasks-from-excel-to-ms-planner-excel-add-in-for-ms-planner/1229 "2025-10-31T11:29:07Z")

</div>

Hey CData Community :waving\_hand: If you are managing lots of tasks in Microsoft Planner and find the manual entry process cumbersome, you will definitely want to check out this workflow. With the CData Excel Add-In for…

---

## [ADO.NET Provider for Snowflake does not show tables/views in Analysis Services Data Source View dialog](https://community.cdata.com/t/ado-net-provider-for-snowflake-does-not-show-tables-views-in-analysis-services-data-source-view-dialog/1219)

<div class="topic-metadata">

**Author:** [@kde84](https://community.cdata.com/u/kde84)\
**Replies:** 1\
**Last updated:** [October 21, 2025, 1:45pm UTC](https://community.cdata.com/t/ado-net-provider-for-snowflake-does-not-show-tables-views-in-analysis-services-data-source-view-dialog/1219 "2025-10-21T13:45:40Z")

</div>

I am test driving the ADO.NET provider for Snowflake to connect to data in Snowflake from Analysis Services in Multidimensional Mode. I follow the descriptions in the article. Connection to Snowflake succeeds but wh…

---

## [Dynamically Retrieve Data Based on Cell Values with the CData Excel Add-in: CData Excel Formulas](https://community.cdata.com/t/dynamically-retrieve-data-based-on-cell-values-with-the-cdata-excel-add-in-cdata-excel-formulas/1222)

<div class="topic-metadata">

**Author:** [@Somya](https://community.cdata.com/u/Somya)\
**Replies:** 0\
**Last updated:** [October 17, 2025, 1:04pm UTC](https://community.cdata.com/t/dynamically-retrieve-data-based-on-cell-values-with-the-cdata-excel-add-in-cdata-excel-formulas/1222 "2025-10-17T13:04:45Z")

</div>

The CData Excel Add-in empowers you to access, query, and manipulate live data directly from Excel without complex scripting or manual imports. Using CData Excel Functions, you can dynamically retrieve data from any supp…

---

## [Connecting to Cloud Storage Platforms Using the CData Access Driver](https://community.cdata.com/t/connecting-to-cloud-storage-platforms-using-the-cdata-access-driver/1221)

<div class="topic-metadata">

**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\
**Replies:** 0\
**Last updated:** [October 17, 2025, 1:17am UTC](https://community.cdata.com/t/connecting-to-cloud-storage-platforms-using-the-cdata-access-driver/1221 "2025-10-17T01:17:22Z")

</div>

Hey CData Community, You can now stop juggling “.accdb” files between desktops, emails, and USB drives! The CData Access Drivers & Connectors (v24.3+) now let you connect directly to Access databases stored in Google Dr…

---

## [Using ThreadID in CData Driver Logs to Debug Multi-Threaded Operations](https://community.cdata.com/t/using-threadid-in-cdata-driver-logs-to-debug-multi-threaded-operations/1218)

<div class="topic-metadata">

**Author:** [@Mohsin](https://community.cdata.com/u/Mohsin)\
**Replies:** 0\
**Last updated:** [October 14, 2025, 2:34pm UTC](https://community.cdata.com/t/using-threadid-in-cdata-driver-logs-to-debug-multi-threaded-operations/1218 "2025-10-14T14:34:10Z")

</div>

CData Drivers now include a ThreadID in their log output, making it easier to trace operations across multiple threads in complex or concurrent workloads. Each log line includes a fixed-width ThreadID, helping you identi…

---

## [Migrate from Microsoft Access’ Retired Salesforce Connector with CData](https://community.cdata.com/t/migrate-from-microsoft-access-retired-salesforce-connector-with-cdata/1211)

<div class="topic-metadata">

**Author:** [@user1](https://community.cdata.com/u/user1)\
**Replies:** 0\
**Last updated:** [October 3, 2025, 3:18pm UTC](https://community.cdata.com/t/migrate-from-microsoft-access-retired-salesforce-connector-with-cdata/1211 "2025-10-03T15:18:38Z")

</div>

Hey CData Community! Microsoft Access has announced the retiring of its built-in Salesforce ODBC driver in October 2025 (https://techcommunity.microsoft.com/blog/AccessBlog/access-announces-removal-of-salesforce-odbc-dr…

---

## [Securely Connect to PostgreSQL via SSH with the CData ODBC Driver (No PuTTY Needed)](https://community.cdata.com/t/securely-connect-to-postgresql-via-ssh-with-the-cdata-odbc-driver-no-putty-needed/1209)

<div class="topic-metadata">

**Author:** [@Mohsin](https://community.cdata.com/u/Mohsin)\
**Replies:** 0\
**Last updated:** [October 1, 2025, 12:37pm UTC](https://community.cdata.com/t/securely-connect-to-postgresql-via-ssh-with-the-cdata-odbc-driver-no-putty-needed/1209 "2025-10-01T12:37:53Z")

</div>

Accessing PostgreSQL databases hosted in the cloud (like Amazon RDS or Azure) often requires routing through an SSH server, which can be tricky with manual port forwarding and tools like PuTTY. With the CData PostgreSQL…

---

## [Connect Go Applications to Web APIs Using net/http and CData API Server](https://community.cdata.com/t/connect-go-applications-to-web-apis-using-net-http-and-cdata-api-server/1208)

<div class="topic-metadata">

**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\
**Replies:** 0\
**Last updated:** [October 1, 2025, 11:10am UTC](https://community.cdata.com/t/connect-go-applications-to-web-apis-using-net-http-and-cdata-api-server/1208 "2025-10-01T11:10:45Z")

</div>

Hey CData Community! If you’re a fan of Go (Golang) and you’ve been wishing your apps could tap into real-time data without building complex connectors or wrestling with custom drivers, your wish just came true. We’ve …

---

## [How to send messages to a specific channel in MS Teams using SQL via CData Drivers.](https://community.cdata.com/t/how-to-send-messages-to-a-specific-channel-in-ms-teams-using-sql-via-cdata-drivers/1200)

<div class="topic-metadata">

**Author:** [@Somya](https://community.cdata.com/u/Somya)\
**Replies:** 0\
**Last updated:** [September 24, 2025, 11:17am UTC](https://community.cdata.com/t/how-to-send-messages-to-a-specific-channel-in-ms-teams-using-sql-via-cdata-drivers/1200 "2025-09-24T11:17:39Z")

</div>

CData Microsoft Teams Drivers make it easy to integrate Microsoft Teams data into your applications without heavy coding. By exposing Teams APIs through familiar SQL interfaces (ODBC, JDBC, ADO.NET), you can query Teams …

[Next page](https://community.cdata.com/c/live-connectivity/cdata-drivers/35.md?page=1)
