# \#odbc **URL:** https://community.cdata.com/tag/odbc/45.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [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)
**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")
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 “… --- ## [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)
**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")
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… --- ## [Use SQL to Copy Column Values with CData Drivers](https://community.cdata.com/t/use-sql-to-copy-column-values-with-cdata-drivers/1170)
**Author:** [@Mohsin](https://community.cdata.com/u/Mohsin)\ **Replies:** 0\ **Last updated:** [August 21, 2025, 8:37am UTC](https://community.cdata.com/t/use-sql-to-copy-column-values-with-cdata-drivers/1170 "2025-08-21T08:37:44Z")
Need to update one column with values from another? You can do it directly with CData Drivers using standard SQL. We show how to run an UPDATE statement against live SaaS and database sources—no exports, no workarounds.… --- ## [Issue with CData QuickBooks ODBC Driver after Purchase](https://community.cdata.com/t/issue-with-cdata-quickbooks-odbc-driver-after-purchase/1162)
**Author:** [@apachecoo110](https://community.cdata.com/u/apachecoo110)\ **Replies:** 1\ **Last updated:** [August 12, 2025, 5:30pm UTC](https://community.cdata.com/t/issue-with-cdata-quickbooks-odbc-driver-after-purchase/1162 "2025-08-12T17:30:34Z")
Hello everyone, I recently purchased the CData QuickBooks ODBC Driver (Desktop version, $499/year) for one desktop and one data source (QuickBooks), as shown in the attached image. When trying to use it in Navicat Prem… --- ## [Issue with CData QuickBooks ODBC Driver after Purchase](https://community.cdata.com/t/issue-with-cdata-quickbooks-odbc-driver-after-purchase/1161)
**Author:** [@apachecoo110](https://community.cdata.com/u/apachecoo110)\ **Replies:** 2\ **Last updated:** [August 11, 2025, 4:59pm UTC](https://community.cdata.com/t/issue-with-cdata-quickbooks-odbc-driver-after-purchase/1161 "2025-08-11T16:59:14Z")
Hello everyone, I recently purchased the CData QuickBooks ODBC Driver (Desktop version, $499/year) for one desktop and one data source (QuickBooks), as shown in the attached image. When trying to use it in Navicat Prem… --- ## [Authenticate and Access Zoom API with OAuth and Postman](https://community.cdata.com/t/authenticate-and-access-zoom-api-with-oauth-and-postman/1138)
**Author:** [@Anusha\_M\_B](https://community.cdata.com/u/Anusha_M_B)\ **Replies:** 0\ **Last updated:** [July 25, 2025, 5:41am UTC](https://community.cdata.com/t/authenticate-and-access-zoom-api-with-oauth-and-postman/1138 "2025-07-25T05:41:46Z")
Hey CData Community! If you’re working with the Zoom API and need a secure way to test endpoints, this quick guide is for you. It covers setting up OAuth credentials, making API calls in Postman, and connecting via CDat… --- ## ["ORA-02070: database xxx does not support some function in this context" error when trying to update tables via Oracle through dg4odbc](https://community.cdata.com/t/ora-02070-database-xxx-does-not-support-some-function-in-this-context-error-when-trying-to-update-tables-via-oracle-through-dg4odbc/1100)
**Author:** [@gauravr](https://community.cdata.com/u/gauravr)\ **Replies:** 1\ **Last updated:** [May 28, 2025, 7:13pm UTC](https://community.cdata.com/t/ora-02070-database-xxx-does-not-support-some-function-in-this-context-error-when-trying-to-update-tables-via-oracle-through-dg4odbc/1100 "2025-05-28T19:13:39Z")
When connected to my data source as a Remote Oracle Database via the ODBC Driver, I run into the following error when trying to perform inserts or updates into my database: Error ORA-02070: database xxx does not suppo… --- ## [Is my laptop powerful enough to run multiple CData ODBC drivers for concurrent API connections?](https://community.cdata.com/t/is-my-laptop-powerful-enough-to-run-multiple-cdata-odbc-drivers-for-concurrent-api-connections/1090)
**Author:** [@daniellemorriss](https://community.cdata.com/u/daniellemorriss)\ **Replies:** 1\ **Last updated:** [May 15, 2025, 11:28pm UTC](https://community.cdata.com/t/is-my-laptop-powerful-enough-to-run-multiple-cdata-odbc-drivers-for-concurrent-api-connections/1090 "2025-05-15T23:28:11Z")
Hi everyone, I’m currently working on a project that involves connecting to several cloud APIs (like Salesforce, HubSpot, and Google Analytics) using CData ODBC drivers. I’m running everything locally from my Windows 11… --- ## [3 Ways to Integrate External Data Sources with FileMaker via CData ODBC Drivers](https://community.cdata.com/t/3-ways-to-integrate-external-data-sources-with-filemaker-via-cdata-odbc-drivers/1087)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [May 8, 2025, 5:55am UTC](https://community.cdata.com/t/3-ways-to-integrate-external-data-sources-with-filemaker-via-cdata-odbc-drivers/1087 "2025-05-08T05:55:22Z")
Hey CData Community! Ready to supercharge your FileMaker apps? Say hello to a world “beyond the file\*”\* with CData ODBC Drivers! Whether you’re taming spreadsheets, poking into cloud platforms, or cracking open database… --- ## [3 Ways to Integrate External Data Sources with FileMaker via CData ODBC Drivers](https://community.cdata.com/t/3-ways-to-integrate-external-data-sources-with-filemaker-via-cdata-odbc-drivers/1086)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [May 8, 2025, 5:51am UTC](https://community.cdata.com/t/3-ways-to-integrate-external-data-sources-with-filemaker-via-cdata-odbc-drivers/1086 "2025-05-08T05:51:50Z")
Hey CData Community! Ready to supercharge your FileMaker apps? Say hello to a world “beyond the file\*”\* with CData ODBC Drivers! Whether you’re taming spreadsheets, poking into cloud platforms, or cracking open database… --- ## [Optimize Microsoft Access with SQL Pass-Through Queries](https://community.cdata.com/t/optimize-microsoft-access-with-sql-pass-through-queries/1038)
**Author:** [@Mohsin](https://community.cdata.com/u/Mohsin)\ **Replies:** 0\ **Last updated:** [March 10, 2025, 8:02am UTC](https://community.cdata.com/t/optimize-microsoft-access-with-sql-pass-through-queries/1038 "2025-03-10T08:02:53Z")
Looking to enhance performance in Microsoft Access? Learn how SQL pass-through queries can help you execute SQL directly on external databases, reducing bottlenecks and improving efficiency. Go beyond the native capabil… --- ## [Optimizing DTM Buffer Size and Default Buffer Block Size in Informatica PowerCenter for batch writes](https://community.cdata.com/t/optimizing-dtm-buffer-size-and-default-buffer-block-size-in-informatica-powercenter-for-batch-writes/1031)
**Author:** [@Orges\_Muzhaqi](https://community.cdata.com/u/Orges_Muzhaqi)\ **Replies:** 0\ **Last updated:** [February 27, 2025, 10:49pm UTC](https://community.cdata.com/t/optimizing-dtm-buffer-size-and-default-buffer-block-size-in-informatica-powercenter-for-batch-writes/1031 "2025-02-27T22:49:46Z")
When using CData drivers alongside various tools, it is crucial to consider the configurations and properties of these tools, as they may override the drivers’ settings. In Informatica PowerCenter, two key memory setting… --- ## [Missing Transactions in Power BI Data Model with QuickBooks Online Connector](https://community.cdata.com/t/missing-transactions-in-power-bi-data-model-with-quickbooks-online-connector/943)
**Author:** [@Shakil](https://community.cdata.com/u/Shakil)\ **Replies:** 2\ **Last updated:** [November 20, 2024, 6:01pm UTC](https://community.cdata.com/t/missing-transactions-in-power-bi-data-model-with-quickbooks-online-connector/943 "2024-11-20T18:01:59Z")
I created a Power BI data model using the QuickBooks Online connector and successfully built some basic reports. However, I noticed that certain transactions are missing from the data. I queried all available tables but … --- ## [Using Dataverse ODBC - how to query choicelabels?](https://community.cdata.com/t/using-dataverse-odbc-how-to-query-choicelabels/915)
**Author:** [@DaveJones4](https://community.cdata.com/u/DaveJones4)\ **Replies:** 8\ **Last updated:** [October 11, 2024, 1:57pm UTC](https://community.cdata.com/t/using-dataverse-odbc-how-to-query-choicelabels/915 "2024-10-11T13:57:32Z")
Using the ODBC driver, I am trying to query ChoiceLabels - this simple query works in SSMS but not using the ODBC driver in my reporting application: select \* from choicelabels The odbc driver returns: A table cou… --- ## [Visual getting started guide for JDBC ODBC driver](https://community.cdata.com/t/visual-getting-started-guide-for-jdbc-odbc-driver/904)
**Author:** [@Jdotcee](https://community.cdata.com/u/Jdotcee)\ **Replies:** 2\ **Last updated:** [September 24, 2024, 3:24pm UTC](https://community.cdata.com/t/visual-getting-started-guide-for-jdbc-odbc-driver/904 "2024-09-24T15:24:48Z")
Do we have a visual JDBC ODBC bridge getting started guide? Unfortunately, I’m a visual learner and I can’t find visual resources on how to set it up on my device. I’m using Microsoft Server --- ## [ODBC SSAS (SQL Server Analysis Services) Tabular: “\[DataSource.Error\] ODBC: ERROR \[IM002\] \[Microsoft\]\[ODBC Driver Manager\] Data source name not found and no default driver specified.”](https://community.cdata.com/t/odbc-ssas-sql-server-analysis-services-tabular-datasource-error-odbc-error-im002-microsoft-odbc-driver-manager-data-source-name-not-found-and-no-default-driver-specified/889)
**Author:** [@Florjan\_C](https://community.cdata.com/u/Florjan_C)\ **Replies:** 0\ **Last updated:** [August 23, 2024, 7:36pm UTC](https://community.cdata.com/t/odbc-ssas-sql-server-analysis-services-tabular-datasource-error-odbc-error-im002-microsoft-odbc-driver-manager-data-source-name-not-found-and-no-default-driver-specified/889 "2024-08-23T19:36:16Z")
“ODBC: ERROR \[IM002\] \[Microsoft\]\[ODBC Driver Manager\] Data source name not found and no default driver specified” error means that the Data Source Name (DSN) specified in the connection configuration is not being found i… --- ## [How can I set up Tableau Bridge with a CData ODBC Drivers?](https://community.cdata.com/t/how-can-i-set-up-tableau-bridge-with-a-cdata-odbc-drivers/873)
**Author:** [@James\_T](https://community.cdata.com/u/James_T)\ **Replies:** 1\ **Last updated:** [July 24, 2024, 3:40pm UTC](https://community.cdata.com/t/how-can-i-set-up-tableau-bridge-with-a-cdata-odbc-drivers/873 "2024-07-24T15:40:01Z")
I found out that I need Tableau Bridge in order to “bridge” my CData ODBC driver with Tableau Cloud. Do you have any instructions you can share? --- ## [Error: 'Unable to create data source with driver 'DriverType=ODBC;Platform=64', Keyword not supported: 'DRIVER'.'.](https://community.cdata.com/t/error-unable-to-create-data-source-with-driver-drivertype-odbc-platform-64-keyword-not-supported-driver/796)
**Author:** [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\ **Replies:** 1\ **Last updated:** [June 21, 2024, 4:04pm UTC](https://community.cdata.com/t/error-unable-to-create-data-source-with-driver-drivertype-odbc-platform-64-keyword-not-supported-driver/796 "2024-06-21T16:04:06Z")
I’m using the Dynamics365 ODBC Driver with SQL Gateway to create a Linked Server. When I try creating a Service within SQL Gateway using a new System DSN, I run into this error of Error: ‘Unable to create data source … --- ## [Executing a table trigger](https://community.cdata.com/t/executing-a-table-trigger/755)
**Author:** [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\ **Replies:** 0\ **Last updated:** [June 7, 2024, 9:41pm UTC](https://community.cdata.com/t/executing-a-table-trigger/755 "2024-06-07T21:41:22Z")
With SQL Gateway, we can expose our ODBC data sources as if they were MySQL or SQL Server databases. This allows us to create a Linked Server for any ODBC data source and work with our data as if it were a SQL Server ins… --- ## [How to Query System Tables from a Linked Server](https://community.cdata.com/t/how-to-query-system-tables-from-a-linked-server/754)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [June 7, 2024, 9:14pm UTC](https://community.cdata.com/t/how-to-query-system-tables-from-a-linked-server/754 "2024-06-07T21:14:20Z")
When you create a linked server in SSMS, the System Tables are not available in the table/view listing, but they can still be accessed and queried. To query the System Tables, you will be using the OPENQUERY call, lik… --- ## [How to Execute Stored Procedures from a Linked Server](https://community.cdata.com/t/how-to-execute-stored-procedures-from-a-linked-server/750)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [June 6, 2024, 7:46pm UTC](https://community.cdata.com/t/how-to-execute-stored-procedures-from-a-linked-server/750 "2024-06-06T19:46:42Z")
To execute Stored Procedures, you will first need to enable RPC and RPC Out in the settings for the Linked Server. You can access the settings by right clicking your created Linked Server in SSMS and going to the propert… --- ## [Edit Generated Schema Files](https://community.cdata.com/t/edit-generated-schema-files/747)
**Author:** [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\ **Replies:** 0\ **Last updated:** [June 5, 2024, 7:59pm UTC](https://community.cdata.com/t/edit-generated-schema-files/747 "2024-06-05T19:59:21Z")
In this article, I will outline how to edit a newly generated schema file using our Connectors. This article will use our QuickBooks Online Power BI Connector as an example; however, this walkthrough is applicable to any… --- ## [CData ODBC Scheduled Refresh](https://community.cdata.com/t/cdata-odbc-scheduled-refresh/740)
**Author:** [@Abdul](https://community.cdata.com/u/Abdul)\ **Replies:** 2\ **Last updated:** [June 4, 2024, 9:57am UTC](https://community.cdata.com/t/cdata-odbc-scheduled-refresh/740 "2024-06-04T09:57:18Z")
I am using CData Connector (ODBC) with PowerBI to access my data (Zoho CRM). Is there a way to configure a scheduled refresh? Is this even something that can help me? --- ## [“\[INVALID\_PARAMETER\] Invalid search query” error when trying to query NetSuite tables](https://community.cdata.com/t/invalid-parameter-invalid-search-query-error-when-trying-to-query-netsuite-tables/741)
**Author:** [@DylanO](https://community.cdata.com/u/DylanO)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 7:19pm UTC](https://community.cdata.com/t/invalid-parameter-invalid-search-query-error-when-trying-to-query-netsuite-tables/741 "2024-06-03T19:19:10Z")
When using any of our NetSuite connectors, you may see the following error when trying to query a table: \[INVALID\_PARAMETER\] Invalid search query. Detailed unprocessed description follows. Search error occurred: Field ‘\<… --- ## [SAP Data Services Designer displays blank table and column names](https://community.cdata.com/t/sap-data-services-designer-displays-blank-table-and-column-names/663)
**Author:** [@Orges\_Muzhaqi](https://community.cdata.com/u/Orges_Muzhaqi)\ **Replies:** 0\ **Last updated:** [March 12, 2024, 5:12pm UTC](https://community.cdata.com/t/sap-data-services-designer-displays-blank-table-and-column-names/663 "2024-03-12T17:12:09Z")
While successfully connecting a provider to SAP Data Services Designer using our CData ODBC Drivers, an issue arises where the table and column names appear blank. This anomaly stems from the tool. The V23 version … --- ## [odbc error hy000 using PowerBI](https://community.cdata.com/t/odbc-error-hy000-using-powerbi/631)
**Author:** [@garybray](https://community.cdata.com/u/garybray)\ **Replies:** 5\ **Last updated:** [February 15, 2024, 10:04pm UTC](https://community.cdata.com/t/odbc-error-hy000-using-powerbi/631 "2024-02-15T22:04:05Z")
Have a user that gets the following error when trying to refresh the data & import more data using PowerBI. How can I remedy this for her? --- ## [Cdata: PowerBI + Sage Intacct Performance](https://community.cdata.com/t/cdata-powerbi-sage-intacct-performance/605)
**Author:** [@taranr\_sockeye](https://community.cdata.com/u/taranr_sockeye)\ **Replies:** 4\ **Last updated:** [February 5, 2024, 8:24pm UTC](https://community.cdata.com/t/cdata-powerbi-sage-intacct-performance/605 "2024-02-05T20:24:14Z")
Hi! Two pronged question. What’s typical performance that should be expected with Cdata’s Sage Intacct / Power BI connector? \[I’m getting about 250k rows loaded from a large data set in an hour\] Are there any tr… --- ## [transactionStatus table not loading CData Sync](https://community.cdata.com/t/transactionstatus-table-not-loading-cdata-sync/622)
**Author:** [@aniruddhmaitra](https://community.cdata.com/u/aniruddhmaitra)\ **Replies:** 2\ **Last updated:** [February 1, 2024, 7:55am UTC](https://community.cdata.com/t/transactionstatus-table-not-loading-cdata-sync/622 "2024-02-01T07:55:28Z")
Hi! I am working with a client who uses NetSuite ERP. We are trying to get Sales reports for them, which we are doing by using the transaction table from SuiteQL schema. We also need the transactions’ status, for which… --- ## [Attribute id is required by quickbooksadodesktopupdate](https://community.cdata.com/t/attribute-id-is-required-by-quickbooksadodesktopupdate/602)
**Author:** [@Kevin](https://community.cdata.com/u/Kevin)\ **Replies:** 1\ **Last updated:** [January 22, 2024, 11:27pm UTC](https://community.cdata.com/t/attribute-id-is-required-by-quickbooksadodesktopupdate/602 "2024-01-22T23:27:03Z")
Quickbooks - ODBC call is failing when trying to update a column using a Passthrough query in MS Access. It appears to only fail when there are multiple records to update. Works fine with a single record. SQL string l… --- ## [Get data from a sub folder of a shared mailbox in Exchange](https://community.cdata.com/t/get-data-from-a-sub-folder-of-a-shared-mailbox-in-exchange/603)
**Author:** [@RichardGardner](https://community.cdata.com/u/RichardGardner)\ **Replies:** 1\ **Last updated:** [January 22, 2024, 8:05pm UTC](https://community.cdata.com/t/get-data-from-a-sub-folder-of-a-shared-mailbox-in-exchange/603 "2024-01-22T20:05:42Z")
Im trying to design a select query to get the email items in a Inbox subfolder of a shared mailbox when using the Exchange ODBC driver (Exchange online/Office 365). I can get to the shared folder inbox but not query the … [Next page](https://community.cdata.com/tag/odbc/45.md?match_all_tags=true&page=1&tags%5B%5D=odbc)