# \#sql **URL:** https://community.cdata.com/tag/sql/34.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 “… --- ## [dbQuery with multiple statements](https://community.cdata.com/t/dbquery-with-multiple-statements/1247)
**Author:** [@Travis](https://community.cdata.com/u/Travis)\ **Replies:** 1\ **Last updated:** [December 24, 2025, 12:16pm UTC](https://community.cdata.com/t/dbquery-with-multiple-statements/1247 "2025-12-24T12:16:48Z")
How can I get this Sql Server dbQuery to work? The INSERT is completing fine, but I need to get the inserted identity PK and Arc is not picking it up. \ insert into table (...) values (...); se… --- ## [SQLServerV2: This connector type has been removed and will no longer function](https://community.cdata.com/t/sqlserverv2-this-connector-type-has-been-removed-and-will-no-longer-function/1239)
**Author:** [@James\_B](https://community.cdata.com/u/James_B)\ **Replies:** 0\ **Last updated:** [November 21, 2025, 8:40pm UTC](https://community.cdata.com/t/sqlserverv2-this-connector-type-has-been-removed-and-will-no-longer-function/1239 "2025-11-21T20:40:04Z")
Why: Different versions of the SQL Server connector were available in different releases of CData Arc, and the V2 release was one that made use of central database connection configurations but referenced the nati… --- ## [TSQL Order by with latest version of DbAmp](https://community.cdata.com/t/tsql-order-by-with-latest-version-of-dbamp/1234)
**Author:** [@MikeLawrenceNbf](https://community.cdata.com/u/MikeLawrenceNbf)\ **Replies:** 0\ **Last updated:** [November 7, 2025, 9:06pm UTC](https://community.cdata.com/t/tsql-order-by-with-latest-version-of-dbamp/1234 "2025-11-07T21:06:59Z")
Greetings, I sent a detailed example of this to support and I’ll put it here in case it’s something simple. I’m running into a lot of issue with dbamp and ordering by the account name. (both directly and also in t… --- ## [couple issue. just upgraded to latest version dbamp. Getting unspecified error when trying to bring dow 6k records from application object in salesforce using the linked server directly.](https://community.cdata.com/t/couple-issue-just-upgraded-to-latest-version-dbamp-getting-unspecified-error-when-trying-to-bring-dow-6k-records-from-application-object-in-salesforce-using-the-linked-server-directly/1223)
**Author:** [@johnmiller](https://community.cdata.com/u/johnmiller)\ **Replies:** 1\ **Last updated:** [October 24, 2025, 7:44pm UTC](https://community.cdata.com/t/couple-issue-just-upgraded-to-latest-version-dbamp-getting-unspecified-error-when-trying-to-bring-dow-6k-records-from-application-object-in-salesforce-using-the-linked-server-directly/1223 "2025-10-24T19:44:31Z")
i get error when trying to pull down application data that changed in last 4 days. I’m querying the linked server directly like this . it seems like i’m hitting some threshold and when it’s over a certain amount it gives… --- ## [Build AI-Ready Workflows with SQL Server 2025 and CData Sync](https://community.cdata.com/t/build-ai-ready-workflows-with-sql-server-2025-and-cdata-sync/1214)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [October 9, 2025, 5:47pm UTC](https://community.cdata.com/t/build-ai-ready-workflows-with-sql-server-2025-and-cdata-sync/1214 "2025-10-09T17:47:03Z")
Hey CData Community! Microsoft’s SQL Server 2025 brings AI into the heart of the database with new native vector support, enabling you to store, search, and analyze embeddings directly inside SQL Server. When paired wit… --- ## [Stability in Azure SQL Database connection - Connection open failed: \[500\] Unable to connect to](https://community.cdata.com/t/stability-in-azure-sql-database-connection-connection-open-failed-500-unable-to-connect-to/1147)
**Author:** [@PeterVader](https://community.cdata.com/u/PeterVader)\ **Replies:** 2\ **Last updated:** [July 31, 2025, 6:52am UTC](https://community.cdata.com/t/stability-in-azure-sql-database-connection-connection-open-failed-500-unable-to-connect-to/1147 "2025-07-31T06:52:27Z")
Error: Hi everyone, New to the community, within our team we are responsible for a ARC server (CData Arc™ 2024 - 24.3.9159.0) and I am running into the following issue: “Connection open failed: \[500\] Unable to connect… --- ## [unable to update lookup column in dynamic crm 365 with cdata python connector](https://community.cdata.com/t/unable-to-update-lookup-column-in-dynamic-crm-365-with-cdata-python-connector/1135)
**Author:** [@phuvi2132](https://community.cdata.com/u/phuvi2132)\ **Replies:** 3\ **Last updated:** [July 24, 2025, 1:33pm UTC](https://community.cdata.com/t/unable-to-update-lookup-column-in-dynamic-crm-365-with-cdata-python-connector/1135 "2025-07-24T13:33:31Z")
import cdata.dynamics365 as mod conn\_str = ( ‘OrganizationUrl=https://dddddd.crm4.dynamics.com;’ “OAuthSettingsLocation=/home/ddddddv.txt;” ‘InitiateOAuth=REFRESH;’ ‘Edition=Sales;’ ‘IncludeLook… --- ## [Fuzzy String Matching in SQL: Using Levenshtein Similarity in CData Virtuality](https://community.cdata.com/t/fuzzy-string-matching-in-sql-using-levenshtein-similarity-in-cdata-virtuality/1132)
**Author:** [@Marijan](https://community.cdata.com/u/Marijan)\ **Replies:** 0\ **Last updated:** [July 18, 2025, 9:49am UTC](https://community.cdata.com/t/fuzzy-string-matching-in-sql-using-levenshtein-similarity-in-cdata-virtuality/1132 "2025-07-18T09:49:25Z")
Use case Compare strings that look similar but aren’t exactly the same — such as customer names, addresses, or product titles — in SQL queries. We are happy to announce that the development of built in functions to calc… --- ## [Choosing the Right BigQuery Insert Operation for Your Use Case with CData](https://community.cdata.com/t/choosing-the-right-bigquery-insert-operation-for-your-use-case-with-cdata/1088)
**Author:** [@Mohsin](https://community.cdata.com/u/Mohsin)\ **Replies:** 0\ **Last updated:** [May 9, 2025, 4:15pm UTC](https://community.cdata.com/t/choosing-the-right-bigquery-insert-operation-for-your-use-case-with-cdata/1088 "2025-05-09T16:15:56Z")
When inserting data into BigQuery, choosing the right method is critical for performance, cost, and data freshness. Our latest article dives deep into the three main insert options supported by the CData BigQuery Driver: … --- ## [Sync – “\[0\] Failed to cache row \[XXXX\] null"](https://community.cdata.com/t/sync-0-failed-to-cache-row-xxxx-null/1064)
**Author:** [@Jackolas](https://community.cdata.com/u/Jackolas)\ **Replies:** 1\ **Last updated:** [March 26, 2025, 9:48am UTC](https://community.cdata.com/t/sync-0-failed-to-cache-row-xxxx-null/1064 "2025-03-26T09:48:52Z")
Since the update to Sync version 25.1.9207 we are getting some strange errors from different tasks. All these tasks worked without problems before the update. So far i have not found any difference (except for the t… --- ## [Use CData Connect AI to connect to live data in Appsmith applications](https://community.cdata.com/t/use-cdata-connect-ai-to-connect-to-live-data-in-appsmith-applications/1056)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [March 17, 2025, 9:55pm UTC](https://community.cdata.com/t/use-cdata-connect-ai-to-connect-to-live-data-in-appsmith-applications/1056 "2025-03-17T21:55:40Z")
CData Connect AI offers a pure cloud-to-cloud interface for your data, enabling the creation of business applications directly from live data within Appsmith. In Connect AI , you can create connections from 300+ sources,… --- ## [Power automate Limitations on CDATA Cloud](https://community.cdata.com/t/power-automate-limitations-on-cdata-cloud/1052)
**Author:** [@muthuEOL](https://community.cdata.com/u/muthuEOL)\ **Replies:** 1\ **Last updated:** [March 14, 2025, 8:18pm UTC](https://community.cdata.com/t/power-automate-limitations-on-cdata-cloud/1052 "2025-03-14T20:18:09Z")
I am currently working on a Power Automate flow that fetches transaction line data from Exact Online using the CDATA Cloud connector. The goal is to group the data based on GLAccountCode while retrieving the minimum (Lea… --- ## [Can the CDATA JDBC Driver be used to retrieve the table(s) and view(s) names from the SAP HANA DB focused on the SAP modules or archive objects?](https://community.cdata.com/t/can-the-cdata-jdbc-driver-be-used-to-retrieve-the-table-s-and-view-s-names-from-the-sap-hana-db-focused-on-the-sap-modules-or-archive-objects/1036)
**Author:** [@ashish.pancholi](https://community.cdata.com/u/ashish.pancholi)\ **Replies:** 1\ **Last updated:** [March 11, 2025, 1:22pm UTC](https://community.cdata.com/t/can-the-cdata-jdbc-driver-be-used-to-retrieve-the-table-s-and-view-s-names-from-the-sap-hana-db-focused-on-the-sap-modules-or-archive-objects/1036 "2025-03-11T13:22:02Z")
Hi CDATA Team, There are many tables, views, and other database objects in the SAP application database. I wanted to check if the CDATA JDBC Driver aids in obtaining the filtered list based on SAP modules or an archive … --- ## [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… --- ## [CDATA to Exactonline Query](https://community.cdata.com/t/cdata-to-exactonline-query/1024)
**Author:** [@muthuEOL](https://community.cdata.com/u/muthuEOL)\ **Replies:** 1\ **Last updated:** [February 20, 2025, 8:57pm UTC](https://community.cdata.com/t/cdata-to-exactonline-query/1024 "2025-02-20T20:57:52Z")
Hi Team, I am trying to run this query in CDATA through powerautomate but its not producing any results but with some other divisons it producing results strange issue.please guide me on this SELECT GLAccountCode,MIN… --- ## [Issues Connecting to SQL Server with CData ADO.NET Provider - Need Help with Authentication Setup!](https://community.cdata.com/t/issues-connecting-to-sql-server-with-cdata-ado-net-provider-need-help-with-authentication-setup/940)
**Author:** [@marcellosalas](https://community.cdata.com/u/marcellosalas)\ **Replies:** 1\ **Last updated:** [November 13, 2024, 10:05am UTC](https://community.cdata.com/t/issues-connecting-to-sql-server-with-cdata-ado-net-provider-need-help-with-authentication-setup/940 "2024-11-13T10:05:48Z")
Hello everyone, I am working on setting up a connection between my SQL Server database and a C# application using the CData ADO.NET provider for SQL Server but I am running into some authentication issues. I would like … --- ## [Dataverse ODBC Driver - How to select dynamic fields](https://community.cdata.com/t/dataverse-odbc-driver-how-to-select-dynamic-fields/934)
**Author:** [@DaveJones4](https://community.cdata.com/u/DaveJones4)\ **Replies:** 4\ **Last updated:** [November 11, 2024, 6:11am UTC](https://community.cdata.com/t/dataverse-odbc-driver-how-to-select-dynamic-fields/934 "2024-11-11T06:11:38Z")
Hi, I’m confused on how to select the dynamic fields. When I look in the driver ui, I can see the dynamic fields like “createdbyname” which are populated based on the values in “createdby” - but if I try to query using \`… --- ## [Setup Two DBAmp Linked Server in SQL Server 2022](https://community.cdata.com/t/setup-two-dbamp-linked-server-in-sql-server-2022/912)
**Author:** [@pmaharjan](https://community.cdata.com/u/pmaharjan)\ **Replies:** 1\ **Last updated:** [October 8, 2024, 9:50pm UTC](https://community.cdata.com/t/setup-two-dbamp-linked-server-in-sql-server-2022/912 "2024-10-08T21:50:27Z")
Is it possible to create DBAmp linked server for two salesforce instance in single SQL server with latest DBAmp setup? Seems like there is no option to configure two product key in DBAmp Config2. There was option to set … --- ## [The SQL Error Number is 102, State is 1, Severity is 15, Error is 'Incorrect syntax near 'f8a8d2f'.', Server name is AWDAPPINDB3, Line number is 1.The Token Type is 170](https://community.cdata.com/t/the-sql-error-number-is-102-state-is-1-severity-is-15-error-is-incorrect-syntax-near-f8a8d2f-server-name-is-awdappindb3-line-number-is-1-the-token-type-is-170/898)
**Author:** [@loisine.ann.mendoza](https://community.cdata.com/u/loisine.ann.mendoza)\ **Replies:** 8\ **Last updated:** [September 16, 2024, 4:45pm UTC](https://community.cdata.com/t/the-sql-error-number-is-102-state-is-1-severity-is-15-error-is-incorrect-syntax-near-f8a8d2f-server-name-is-awdappindb3-line-number-is-1-the-token-type-is-170/898 "2024-09-16T16:45:58Z")
:45:17.636-06:00 1 \[42|Q-Id\] \[META|Schema\] Executed column schema query: \[App\_History\] Success: 4 results (268 ms) 2024-09-10T21:45:17.636-06:00 2 \[42|Q-Id\] \[EXEC|Messag\] Executed query: \[SELECT \*, IsPseudoColumn… --- ## [Name Tool ID# not found inside D at \[1:97\]](https://community.cdata.com/t/name-tool-id-not-found-inside-d-at-1-97/900)
**Author:** [@loisine.ann.mendoza](https://community.cdata.com/u/loisine.ann.mendoza)\ **Replies:** 4\ **Last updated:** [September 16, 2024, 2:39pm UTC](https://community.cdata.com/t/name-tool-id-not-found-inside-d-at-1-97/900 "2024-09-16T14:39:17Z")
2024-09-10T00:52:03.708-06:00 1 \[6|Q-Id\] \[SQL |Cache \] Cache failed: \[500\] Could not execute the specified command: Name Tool ID# not found inside D at \[1:97\] 2024-09-10T00:52:03.708-06:00 0 \[6|Q-Id\] \[… --- ## [CData Sync error when creating a source connection to SQL Server](https://community.cdata.com/t/cdata-sync-error-when-creating-a-source-connection-to-sql-server/897)
**Author:** [@ella.evio](https://community.cdata.com/u/ella.evio)\ **Replies:** 3\ **Last updated:** [September 10, 2024, 10:11am UTC](https://community.cdata.com/t/cdata-sync-error-when-creating-a-source-connection-to-sql-server/897 "2024-09-10T10:11:49Z")
I’m encountering an error in CData Sync when I try to create and test a source connection. The complete error message is Connection open failed: \[500\] Failed to login ‘SERVERNAME’, Cannot open database ‘DBNAME’ requested… --- ## [How do I use ArcESB to retrieve data from restful API using a webhook, then take that data and import it into SQL Server Management Studio?](https://community.cdata.com/t/how-do-i-use-arcesb-to-retrieve-data-from-restful-api-using-a-webhook-then-take-that-data-and-import-it-into-sql-server-management-studio/815)
**Author:** [@thebank987](https://community.cdata.com/u/thebank987)\ **Replies:** 1\ **Last updated:** [July 8, 2024, 6:14am UTC](https://community.cdata.com/t/how-do-i-use-arcesb-to-retrieve-data-from-restful-api-using-a-webhook-then-take-that-data-and-import-it-into-sql-server-management-studio/815 "2024-07-08T06:14:19Z")
I have a project where I need to retrieve data from a RESTful API. I have already created my request script and tested it in POSTMan. I would like to retrieve data from the RESTful API’s response, input the data into SQ… --- ## [Sync – An SQL data change is not permitted for a read-only connection, user or database.](https://community.cdata.com/t/sync-an-sql-data-change-is-not-permitted-for-a-read-only-connection-user-or-database/797)
**Author:** [@Omar](https://community.cdata.com/u/Omar)\ **Replies:** 0\ **Last updated:** [June 21, 2024, 9:06pm UTC](https://community.cdata.com/t/sync-an-sql-data-change-is-not-permitted-for-a-read-only-connection-user-or-database/797 "2024-06-21T21:06:13Z")
This error can indicate one of the following: The disk that Sync is trying to store data on is full Sync does not have permissions to write to the Derby database or SQLite database that it uses to store Sync inform… --- ## [Unable to schedule the CData SSIS job in sql server Agent job.](https://community.cdata.com/t/unable-to-schedule-the-cdata-ssis-job-in-sql-server-agent-job/703)
**Author:** [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Replies:** 1\ **Last updated:** [April 26, 2024, 10:32pm UTC](https://community.cdata.com/t/unable-to-schedule-the-cdata-ssis-job-in-sql-server-agent-job/703 "2024-04-26T22:32:12Z")
Hi Ethem Q, i have created the ssis package using the CData workday drivers. package is running smoothly when it is in SSIS compailor. and i am trying to schedule this package as agent job in sql server, it is failing w… --- ## [System error: No such host is known when attempting to connect to a named instance of SQL Server (SERVERNAME\\INSTANCE)](https://community.cdata.com/t/system-error-no-such-host-is-known-when-attempting-to-connect-to-a-named-instance-of-sql-server-servername-instance/691)
**Author:** [@James\_B](https://community.cdata.com/u/James_B)\ **Replies:** 0\ **Last updated:** [April 9, 2024, 3:30pm UTC](https://community.cdata.com/t/system-error-no-such-host-is-known-when-attempting-to-connect-to-a-named-instance-of-sql-server-servername-instance/691 "2024-04-09T15:30:28Z")
When creating a new SQL Server connection in CData Arc and setting the Server to the named instance form SERVERNAME\\INSTANCE, an error is encountered: Cause: CData Arc will attempt to resolve the Server value int… --- ## [How to replicate the Lookup behavior of earlier versions of CData Arc (releases prior to 2023)](https://community.cdata.com/t/how-to-replicate-the-lookup-behavior-of-earlier-versions-of-cdata-arc-releases-prior-to-2023/645)
**Author:** [@James\_B](https://community.cdata.com/u/James_B)\ **Replies:** 0\ **Last updated:** [February 28, 2024, 6:31pm UTC](https://community.cdata.com/t/how-to-replicate-the-lookup-behavior-of-earlier-versions-of-cdata-arc-releases-prior-to-2023/645 "2024-02-28T18:31:33Z")
In earlier releases of CData Arc the Lookup connector / Lookup action of Database connectors had a fairly simple interface to it. You can configure a single query to select a single column from a table in a database, and… --- ## [Sync pre/post Events - reuse existing db Connection info](https://community.cdata.com/t/sync-pre-post-events-reuse-existing-db-connection-info/584)
**Author:** [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Replies:** 2\ **Last updated:** [December 27, 2023, 6:45am UTC](https://community.cdata.com/t/sync-pre-post-events-reuse-existing-db-connection-info/584 "2023-12-27T06:45:30Z")
You can use post-job Events to run some arbitrary SQL (like a stored procedure) at the end of your Job. The documentation says you have to make your own connection, as below. But I’d really rather not embed cleartext c… --- ## [Issue with CDATA Sync Job Using Incremental Replication Despite Removal](https://community.cdata.com/t/issue-with-cdata-sync-job-using-incremental-replication-despite-removal/536)
**Author:** [@Satyendra](https://community.cdata.com/u/Satyendra)\ **Replies:** 3\ **Last updated:** [November 27, 2023, 1:57pm UTC](https://community.cdata.com/t/issue-with-cdata-sync-job-using-incremental-replication-despite-removal/536 "2023-11-27T13:57:20Z")
Hello CDATA Community, I hope this message finds you well. I am currently facing an issue with the CDATA Sync tool and would appreciate any insights or assistance from the community. Problem Description: I have configu… --- ## [Installing Dbamp Remotely](https://community.cdata.com/t/installing-dbamp-remotely/454)
**Author:** [@Srilatha](https://community.cdata.com/u/Srilatha)\ **Replies:** 2\ **Last updated:** [November 10, 2023, 7:01pm UTC](https://community.cdata.com/t/installing-dbamp-remotely/454 "2023-11-10T19:01:38Z")
Hi Everyone, I have a scenario to use Azure Managed SQL Instances and these are not supported for DBAmp because they do not allow the installation of 3rd-party linked servers on the Instance. So I am trying to install d… [Next page](https://community.cdata.com/tag/sql/34.md?match_all_tags=true&page=1&tags%5B%5D=sql)