# \#sql-server **URL:** https://community.cdata.com/tag/sql-server/190.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [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… --- ## [SQL Server Database and User Creation For A SQL Server user with Least Privilege Acces](https://community.cdata.com/t/sql-server-database-and-user-creation-for-a-sql-server-user-with-least-privilege-acces/1305)
**Author:** [@michaeld](https://community.cdata.com/u/michaeld)\ **Replies:** 0\ **Last updated:** [June 18, 2026, 8:51pm UTC](https://community.cdata.com/t/sql-server-database-and-user-creation-for-a-sql-server-user-with-least-privilege-acces/1305 "2026-06-18T20:51:49Z")
The Following Scripts can be used to create a SQL Server Database and SQL Server user with Minimum permissions. Executive summary This design follows least privilege, clear ownership boundaries, and containment. The… --- ## [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… --- ## [How to enable CData SQL Server Connections as Destination Connections for Jobs within CData Sync](https://community.cdata.com/t/how-to-enable-cdata-sql-server-connections-as-destination-connections-for-jobs-within-cdata-sync/1249)
**Author:** [@matthewr](https://community.cdata.com/u/matthewr)\ **Replies:** 1\ **Last updated:** [December 4, 2025, 8:53pm UTC](https://community.cdata.com/t/how-to-enable-cdata-sql-server-connections-as-destination-connections-for-jobs-within-cdata-sync/1249 "2025-12-04T20:53:22Z")
When configuring a replication Job after creating a Connection to your SQL Server database, you may initially find that you are unable to utilize this Connection as a Destination. The Connection appears as intended when… --- ## [Using Claude Projects to Work Effectively with Dynamic Data Models with CData Connect AI](https://community.cdata.com/t/using-claude-projects-to-work-effectively-with-dynamic-data-models-with-cdata-connect-ai/1248)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [December 4, 2025, 10:38am UTC](https://community.cdata.com/t/using-claude-projects-to-work-effectively-with-dynamic-data-models-with-cdata-connect-ai/1248 "2025-12-04T10:38:06Z")
Hey CData Community! Tired of Claude guessing your schema wrong? Give it a brain upgrade with Claude Projects + CData Connect AI. We put together a quick guide on teaching Claude your database layout so it stops hallu… --- ## [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… --- ## [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… --- ## [CData Virtuality Cloud Agent: Simplifying Hybrid Data Connectivity](https://community.cdata.com/t/cdata-virtuality-cloud-agent-simplifying-hybrid-data-connectivity/1207)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [October 1, 2025, 11:06am UTC](https://community.cdata.com/t/cdata-virtuality-cloud-agent-simplifying-hybrid-data-connectivity/1207 "2025-10-01T11:06:30Z")
Hey CData Community! Got cloud apps that need to talk to on-prem data? CData Virtuality’s Cloud Agent is your secure, no-firewall-hacks-needed bridge between cloud deployments and private networks. Whether it’s SQL Ser… --- ## [Using CMDEXEC with SF\_Mirror when xp\_cmdshell is restricted](https://community.cdata.com/t/using-cmdexec-with-sf-mirror-when-xp-cmdshell-is-restricted/1205)
**Author:** [@nrapoza](https://community.cdata.com/u/nrapoza)\ **Replies:** 1\ **Last updated:** [September 26, 2025, 4:42pm UTC](https://community.cdata.com/t/using-cmdexec-with-sf-mirror-when-xp-cmdshell-is-restricted/1205 "2025-09-26T16:42:42Z")
We are upgrading from DBAMP v.4.1.8 to v.22. Because we are restricted from using xp\_cmdshell, most of our SQL Server Agent jobs run sf\_replicate. If I’m understanding the documentation correctly, we won’t be able to c… --- ## [SSIS with CData SSIS Components for Gmail fails when run on SQL server when run with proxy account](https://community.cdata.com/t/ssis-with-cdata-ssis-components-for-gmail-fails-when-run-on-sql-server-when-run-with-proxy-account/1096)
**Author:** [@GritKit](https://community.cdata.com/u/GritKit)\ **Replies:** 2\ **Last updated:** [May 28, 2025, 8:50pm UTC](https://community.cdata.com/t/ssis-with-cdata-ssis-components-for-gmail-fails-when-run-on-sql-server-when-run-with-proxy-account/1096 "2025-05-28T20:50:49Z")
The SSIS package runs fine on my local computer, but it fails with the following errors when run on the SQL Server. Here is our setup: Google API Client ID + Client Secret have been generated using service acco… --- ## [MSSQL to Snowflake CDC Load Task failing](https://community.cdata.com/t/mssql-to-snowflake-cdc-load-task-failing/990)
**Author:** [@sooryaprakash\_parthibanf3](https://community.cdata.com/u/sooryaprakash_parthibanf3)\ **Replies:** 1\ **Last updated:** [January 24, 2025, 7:14pm UTC](https://community.cdata.com/t/mssql-to-snowflake-cdc-load-task-failing/990 "2025-01-24T19:14:41Z")
Hi all, Our team is using CData Sync to extract and load data from SQL Server to Snowflake. The source MSSQL table is CDC-enabled, and we have created a CData Job with Change Data Capture enabled. We started testing the… --- ## [Cdata Sync SQL Server Permissions for data loads](https://community.cdata.com/t/cdata-sync-sql-server-permissions-for-data-loads/991)
**Author:** [@Marcus\_S](https://community.cdata.com/u/Marcus_S)\ **Replies:** 1\ **Last updated:** [January 9, 2025, 10:31pm UTC](https://community.cdata.com/t/cdata-sync-sql-server-permissions-for-data-loads/991 "2025-01-09T22:31:22Z")
Hey All, I am trying to adhere to the principle of least permissions. I created a SQL Server Authenticated Login for cdata to use as a service account to SQL Server. I’m not sure what permissions it needs at the databas… --- ## [Suggestions in how to load tables over 15 millions rows using CData Sync](https://community.cdata.com/t/suggestions-in-how-to-load-tables-over-15-millions-rows-using-cdata-sync/970)
**Author:** [@marodsal](https://community.cdata.com/u/marodsal)\ **Replies:** 1\ **Last updated:** [December 18, 2024, 11:56am UTC](https://community.cdata.com/t/suggestions-in-how-to-load-tables-over-15-millions-rows-using-cdata-sync/970 "2024-12-18T11:56:55Z")
What are the suggestion in how to load tables over 15 millions rows using CData Sync? The data source is ServiceNow and the destination is SQL Server. I changed the sync.exe.config to \ **Author:** [@Jackolas](https://community.cdata.com/u/Jackolas)\ **Replies:** 2\ **Last updated:** [November 6, 2024, 6:57am UTC](https://community.cdata.com/t/cdata-sync-add-semicolons-in-a-transformations-sql-script-with-sql-server-as-target/932 "2024-11-06T06:57:29Z") I’m trying to do a transformation after a dataload to a SQL server. The query used is: (the query is tested and works on the SQL server) MERGE INTO \[S\_Material\_Data\] AS tgtUSING ( SELECT HASHBYTES('SHA2\_256', mat.MatNr… --- ## [Migrating the application database to SQL Server](https://community.cdata.com/t/migrating-the-application-database-to-sql-server/803)
**Author:** [@mikelucito](https://community.cdata.com/u/mikelucito)\ **Replies:** 1\ **Last updated:** [July 8, 2024, 6:47pm UTC](https://community.cdata.com/t/migrating-the-application-database-to-sql-server/803 "2024-07-08T18:47:13Z")
Hi, Our CData installation started as a proof of concept using the default built-in application database. CData is now a critical part of our data infrastructure and we’d like to migrate the application database to a … --- ## [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… --- ## [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… --- ## [CDC/CT - Resynchronize from Date](https://community.cdata.com/t/cdc-ct-resynchronize-from-date/583)
**Author:** [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Replies:** 5\ **Last updated:** [January 12, 2024, 12:58pm UTC](https://community.cdata.com/t/cdc-ct-resynchronize-from-date/583 "2024-01-12T12:58:27Z")
I’ve been using Sync to pull from MS SQL Server, from a couple of different sources that have either CDC or Change Tracking enabled. Occasionally, there is some kind of hiccup where things get out of sync. There are ch… --- ## [CData Sync: Using Transformations to JOIN Data After Replications (in SQL Server)](https://community.cdata.com/t/cdata-sync-using-transformations-to-join-data-after-replications-in-sql-server/429)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [October 3, 2023, 1:55pm UTC](https://community.cdata.com/t/cdata-sync-using-transformations-to-join-data-after-replications-in-sql-server/429 "2023-10-03T13:55:19Z")
Data transformations are often the most complex and costly part of an ETL and ELT process. They can vary from simple data conversions to extremely complex data aggregating techniques. Enterprises use data warehouses to a… --- ## [SSIS server migration – SSIS components connection managers not preserved](https://community.cdata.com/t/ssis-server-migration-ssis-components-connection-managers-not-preserved/373)
**Author:** [@Rodrigo\_de\_Albuquerque](https://community.cdata.com/u/Rodrigo_de_Albuquerque)\ **Replies:** 0\ **Last updated:** [September 1, 2023, 5:42pm UTC](https://community.cdata.com/t/ssis-server-migration-ssis-components-connection-managers-not-preserved/373 "2023-09-01T17:42:50Z")
If you are looking into migrating your SSIS workflows and packages to new servers running other SQL Server editions (e.g., say migrating from a server running SQL Server 2016 to one running 2019) and these packages use o… --- ## [Slowness & Latency Using SageIntacct ODBC Driver](https://community.cdata.com/t/slowness-latency-using-sageintacct-odbc-driver/369)
**Author:** [@lwhieldon](https://community.cdata.com/u/lwhieldon)\ **Replies:** 0\ **Last updated:** [August 30, 2023, 7:09pm UTC](https://community.cdata.com/t/slowness-latency-using-sageintacct-odbc-driver/369 "2023-08-30T19:09:24Z")
I have deployed CDATA Sage Intacct ODBC Driver on an Azure Virtual Machine that also hosts a SQL Server for which we want to copy data from Sage Intacct to table(s) on SQL Server. I have set up my environment 2 ways desc… --- ## [User Defined Views missing from linked server](https://community.cdata.com/t/user-defined-views-missing-from-linked-server/261)
**Author:** [@Elizabeth\_G](https://community.cdata.com/u/Elizabeth_G)\ **Replies:** 0\ **Last updated:** [July 14, 2023, 2:37pm UTC](https://community.cdata.com/t/user-defined-views-missing-from-linked-server/261 "2023-07-14T14:37:19Z")
Due to the way that the catalog and schema are used in a linked server, only one schema can be accessed at a time. As User Defined Views are also stored in a different schema, which by default is named UserViews, they ar… --- ## [SQL Server connector " Unable to retrieve columns "](https://community.cdata.com/t/sql-server-connector-unable-to-retrieve-columns/239)
**Author:** [@russell-jerseypost](https://community.cdata.com/u/russell-jerseypost)\ **Replies:** 1\ **Last updated:** [July 10, 2023, 4:15pm UTC](https://community.cdata.com/t/sql-server-connector-unable-to-retrieve-columns/239 "2023-07-10T16:15:08Z")
I’m seeing this in my logs \[2023-07-10T16:25:14.617\] \[Info\] \[DRIVER\] 2023-07-10T16:25:14.617+01:00 2 \[45|Q-Id\] \[META|Schema\] Executing column schema query: \[Shipment\]\[2023-07-10T16:25:14.617\] \[Info\] \[DRIVER\] 2023-07-1…