# Live Connectivity **URL:** https://community.cdata.com/c/live-connectivity/9.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [About the Live Connectivity category](https://community.cdata.com/t/about-the-live-connectivity-category/1439)
**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-live-connectivity-category/1439 "2026-10-21T15:35:16Z")
Ask questions, get answers, and engage in discussions about real-time data connectivity solutions from CData. --- ## [Connecting to a mix of free form text and structured data](https://community.cdata.com/t/connecting-to-a-mix-of-free-form-text-and-structured-data/1338)
**Author:** [@njoffe](https://community.cdata.com/u/njoffe)\ **Replies:** 1\ **Last updated:** [November 12, 2026, 12:13am UTC](https://community.cdata.com/t/connecting-to-a-mix-of-free-form-text-and-structured-data/1338 "2026-11-12T00:13:36Z")
I’m consulting for company that is building a solution to connect and ingest data from company websites and documents. We have found that low cost LLM models are often good enough to answer questions accurately about the… --- ## [How Can We Prevent AI Data Leakage?](https://community.cdata.com/t/how-can-we-prevent-ai-data-leakage/1331)
**Author:** [@rom\_c](https://community.cdata.com/u/rom_c)\ **Replies:** 2\ **Last updated:** [November 11, 2026, 11:57pm UTC](https://community.cdata.com/t/how-can-we-prevent-ai-data-leakage/1331 "2026-11-11T23:57:16Z")
AI tools are becoming part of everyday business workflows, but they can also create new data security concerns. Employees may accidentally share sensitive information such as customer details, credentials, internal docum… --- ## [How Should PII Be Handled in AI Data Pipelines?](https://community.cdata.com/t/how-should-pii-be-handled-in-ai-data-pipelines/1335)
**Author:** [@rom\_c](https://community.cdata.com/u/rom_c)\ **Replies:** 1\ **Last updated:** [November 11, 2026, 8:56pm UTC](https://community.cdata.com/t/how-should-pii-be-handled-in-ai-data-pipelines/1335 "2026-11-11T20:56:37Z")
As businesses connect AI applications with databases, APIs, and other enterprise data sources, how should personally identifiable information (PII) be handled throughout the data pipeline? Sensitive information can appe… --- ## [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)
**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")
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… --- ## [How Should PII Be Handled in AI Data Pipelines?](https://community.cdata.com/t/how-should-pii-be-handled-in-ai-data-pipelines/1336)
**Author:** [@rom\_c](https://community.cdata.com/u/rom_c)\ **Replies:** 5\ **Last updated:** [November 11, 2026, 10:10am UTC](https://community.cdata.com/t/how-should-pii-be-handled-in-ai-data-pipelines/1336 "2026-11-11T10:10:43Z")
As businesses connect AI applications with databases, APIs, and other enterprise data sources, how should personally identifiable information (PII) be handled throughout the data pipeline? Sensitive information can appe… --- ## [Should Sensitive Data Be Anonymized Before Reaching an LLM?](https://community.cdata.com/t/should-sensitive-data-be-anonymized-before-reaching-an-llm/1334)
**Author:** [@rom\_c](https://community.cdata.com/u/rom_c)\ **Replies:** 2\ **Last updated:** [November 11, 2026, 9:59am UTC](https://community.cdata.com/t/should-sensitive-data-be-anonymized-before-reaching-an-llm/1334 "2026-11-11T09:59:56Z")
As more businesses connect AI tools with live databases, documents, APIs, and other enterprise data sources, I think an important question is where privacy protection should happen. If a retrieved record contains names,… --- ## [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)
**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")
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… --- ## [How to Connect CData Connect AI to QuickBooks Desktop Using the Private Cloud Connector](https://community.cdata.com/t/how-to-connect-cdata-connect-ai-to-quickbooks-desktop-using-the-private-cloud-connector/1333)
**Author:** [@Somya](https://community.cdata.com/u/Somya)\ **Replies:** 0\ **Last updated:** [October 6, 2026, 11:08am UTC](https://community.cdata.com/t/how-to-connect-cdata-connect-ai-to-quickbooks-desktop-using-the-private-cloud-connector/1333 "2026-10-06T11:08:45Z")
QuickBooks Desktop runs on a Windows machine inside your network, so cloud AI tools have no direct path to the financial data it holds. CData Connect AI closes that gap with the Private Cloud Connector, a lightweight Doc… --- ## [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)
**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")
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… --- ## [Important Points about Scaling Laws & Emergent Abilities!!](https://community.cdata.com/t/important-points-about-scaling-laws-emergent-abilities/1325)
**Author:** [@soumitradutta](https://community.cdata.com/u/soumitradutta)\ **Replies:** 1\ **Last updated:** [September 8, 2026, 6:23am UTC](https://community.cdata.com/t/important-points-about-scaling-laws-emergent-abilities/1325 "2026-09-08T06:23:20Z")
We should always remember that we are working on Scaling Laws & Emergent Abilities… What are scaling laws in large language models, and how do model size, training data, and computational resources affect performance? Wh… --- ## [Cdata error when querying Quickbooks JournalEntryLineItems](https://community.cdata.com/t/cdata-error-when-querying-quickbooks-journalentrylineitems/1326)
**Author:** [@lesh](https://community.cdata.com/u/lesh)\ **Replies:** 2\ **Last updated:** [September 3, 2026, 6:41pm UTC](https://community.cdata.com/t/cdata-error-when-querying-quickbooks-journalentrylineitems/1326 "2026-09-03T18:41:11Z")
I am encountering this error since yesterday, JournalEntries seems OK but the JournalEntryLineItems returns this error. --- ## [Connecting Google Drive to an AI Document Agent with CData Connect AI](https://community.cdata.com/t/connecting-google-drive-to-an-ai-document-agent-with-cdata-connect-ai/1323)
**Author:** [@Somya](https://community.cdata.com/u/Somya)\ **Replies:** 2\ **Last updated:** [August 24, 2026, 6:49am UTC](https://community.cdata.com/t/connecting-google-drive-to-an-ai-document-agent-with-cdata-connect-ai/1323 "2026-08-24T06:49:53Z")
The CData Connect AI MCP integration lets you build an AI document agent that connects directly to Google Drive, reading actual document contents, reasoning across multiple files, and returning structured answers with so… --- ## [Data Privacy And Security Update](https://community.cdata.com/t/data-privacy-and-security-update/1313)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [July 16, 2026, 7:41am UTC](https://community.cdata.com/t/data-privacy-and-security-update/1313 "2026-07-16T07:41:51Z")
Hey CData Community! CData Connect AI now supports HIPAA-regulated workloads involving PHI, we operate as a business associate for eligible use cases, and a BAA is available. The Data Privacy and Security article has b… --- ## [Connect AI is Now HIPAA Compliant](https://community.cdata.com/t/connect-ai-is-now-hipaa-compliant/1311)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [July 6, 2026, 3:21pm UTC](https://community.cdata.com/t/connect-ai-is-now-hipaa-compliant/1311 "2026-07-06T15:21:53Z")
Health and life sciences teams, this one’s for you. :hospital: CData Connect AI now supports HIPAA-compliant AI workflows. Under a signed Business Associate Agreement (BAA), healthcare covered entities and their busines… --- ## [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)
**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")
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 … --- ## [Error 500 Internal Server Error](https://community.cdata.com/t/error-500-internal-server-error/1309)
**Author:** [@lesh](https://community.cdata.com/u/lesh)\ **Replies:** 1\ **Last updated:** [June 24, 2026, 9:06pm UTC](https://community.cdata.com/t/error-500-internal-server-error/1309 "2026-06-24T21:06:34Z")
Upon logging in to my Connect AI account, I encountered: Error 500 Internal Server Error And my Power BI Cdata connector also can’t connect to Quickbooks. Is this only on my account? --- ## [Connect AI is now free for developers — plus a Python SDK and CLI](https://community.cdata.com/t/connect-ai-is-now-free-for-developers-plus-a-python-sdk-and-cli/1308)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [June 23, 2026, 5:32pm UTC](https://community.cdata.com/t/connect-ai-is-now-free-for-developers-plus-a-python-sdk-and-cli/1308 "2026-06-23T17:32:50Z")
Getting reliable data access underneath an AI application takes longer than it should. Every source has its own auth quirks, API versioning, rate limits, and pagination behavior — and those problems don’t simplify when y… --- ## [APIServer to query another table before calling procedure](https://community.cdata.com/t/apiserver-to-query-another-table-before-calling-procedure/1300)
**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")
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)
**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")
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… --- ## [📉 Reduce Claude token usage by up to 97% with CData Connect AI.](https://community.cdata.com/t/reduce-claude-token-usage-by-up-to-97-with-cdata-connect-ai/1299)
**Author:** [@Mohsin](https://community.cdata.com/u/Mohsin)\ **Replies:** 0\ **Last updated:** [June 5, 2026, 4:56am UTC](https://community.cdata.com/t/reduce-claude-token-usage-by-up-to-97-with-cdata-connect-ai/1299 "2026-06-05T04:56:12Z")
We published a step-by-step replication guide and benchmark kit that shows how Connect AI features like Custom Tools, Workspaces, Derived Views, and Caching dramatically reduce schema discovery overhead and AI costs. T… --- ## [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)
**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")
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)
**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")
ジャパンシステム株式会社 真砂と申します。 弊社は国内総代理店であるNTTドコモビジネスX社の代理店としてお客様へTDVを購入していただいております。 TDVではいくつかのドライバをサポートしている旨、ガイドなどに記載されていますが、一般的なjdbcドライバなどは製品元へ問い合わせするものであり、ドライバの使用についてはユーザ(お客様)の都合によるためお客様より各ドライバのベンダー様へ問い合わせるものと認識しております。 CDat… --- ## [CData API Server V25 on AWS](https://community.cdata.com/t/cdata-api-server-v25-on-aws/1296)
**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")
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… --- ## [Introducing CData Connect AI for ChatGPT](https://community.cdata.com/t/introducing-cdata-connect-ai-for-chatgpt/1293)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [May 11, 2026, 8:22pm UTC](https://community.cdata.com/t/introducing-cdata-connect-ai-for-chatgpt/1293 "2026-05-11T20:22:51Z")
We have an exciting announcement at CData — CData Connect AI is now available in the ChatGPT App Directory. What that means for you: you can now much more easily connect your databases, SaaS apps, data warehouses, and e… --- ## [Soumitra Dutta Oxford-How do I fix syntax issues with CData drivers?](https://community.cdata.com/t/soumitra-dutta-oxford-how-do-i-fix-syntax-issues-with-cdata-drivers/1289)
**Author:** [@soumitradutta26](https://community.cdata.com/u/soumitradutta26)\ **Replies:** 1\ **Last updated:** [May 5, 2026, 8:47pm UTC](https://community.cdata.com/t/soumitra-dutta-oxford-how-do-i-fix-syntax-issues-with-cdata-drivers/1289 "2026-05-05T20:47:29Z")
Hi everyone, I’m Soumitra Dutta, an Oxford-based entrepreneur and photographer. Glad to be here! I’m running into some syntax issues while working with CData drivers and was hoping to get your advice. Some of my queries… --- ## [Connect Spreadsheets can't load primary Google Calendar, how come?](https://community.cdata.com/t/connect-spreadsheets-cant-load-primary-google-calendar-how-come/1282)
**Author:** [@FlorisMK](https://community.cdata.com/u/FlorisMK)\ **Replies:** 1\ **Last updated:** [April 28, 2026, 6:36am UTC](https://community.cdata.com/t/connect-spreadsheets-cant-load-primary-google-calendar-how-come/1282 "2026-04-28T06:36:25Z")
Just discovered CData Connect Spreadsheets when searching for a way to get Google Calendar information into Excel. Looks very good. However, when test-driving the software, I run into an issue. I have a primary calenda… --- ## [Dheeraj Sudan and Meenu Hinduja-How do I fix OAuth token authentication errors when connecting tools like GA4 or APIs?](https://community.cdata.com/t/dheeraj-sudan-and-meenu-hinduja-how-do-i-fix-oauth-token-authentication-errors-when-connecting-tools-like-ga4-or-apis/1285)
**Author:** [@mhindujadheerajsudan](https://community.cdata.com/u/mhindujadheerajsudan)\ **Replies:** 1\ **Last updated:** [April 28, 2026, 6:24am UTC](https://community.cdata.com/t/dheeraj-sudan-and-meenu-hinduja-how-do-i-fix-oauth-token-authentication-errors-when-connecting-tools-like-ga4-or-apis/1285 "2026-04-28T06:24:51Z")
Hi Everyone, I am Dheeraj Sudan , a UK-based software developer. I’m running into OAuth token authentication errors when trying to connect GA4 and a few APIs through CData. I’ve double-checked my client ID, secret, and r… --- ## [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)
**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")
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)
**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")
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, … [Next page](https://community.cdata.com/c/live-connectivity/9.md?page=1)