# \#salesforce **URL:** https://community.cdata.com/tag/salesforce/12.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [I'm trying to update to OAuth and I'm getting this error](https://community.cdata.com/t/im-trying-to-update-to-oauth-and-im-getting-this-error/1327)
**Author:** [@jmorgan](https://community.cdata.com/u/jmorgan)\ **Replies:** 1\ **Last updated:** [September 11, 2026, 4:56pm UTC](https://community.cdata.com/t/im-trying-to-update-to-oauth-and-im-getting-this-error/1327 "2026-09-11T16:56:00Z")
\--- Starting SF\_Replicate for Account V965613:21:34: Parameters: SALESFORCEDEV Account Version: V965613:21:38: Running DBAmpAZ.exe.13:21:38: DBAmpAZ 22.0.9670.0 Copyright c 2023 CData Software, Inc.13:21:38: Warning: Co… --- ## [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 … --- ## [DBAmp RefreshAll Job Intermittent Failures After Hyperforce Migration](https://community.cdata.com/t/dbamp-refreshall-job-intermittent-failures-after-hyperforce-migration/1303)
**Author:** [@david.oraz](https://community.cdata.com/u/david.oraz)\ **Replies:** 0\ **Last updated:** [June 15, 2026, 10:19pm UTC](https://community.cdata.com/t/dbamp-refreshall-job-intermittent-failures-after-hyperforce-migration/1303 "2026-06-15T22:19:21Z")
We are experiencing intermittent failures with DBAmp RefreshAll jobs across random tables following our Hyperforce migration. We engaged DBAmp Support, and their analysis indicates that the HTTP callouts are occasionall… --- ## [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… --- ## [Sync incremental update error](https://community.cdata.com/t/sync-incremental-update-error/1259)
**Author:** [@CRuybal](https://community.cdata.com/u/CRuybal)\ **Replies:** 0\ **Last updated:** [January 9, 2026, 8:36pm UTC](https://community.cdata.com/t/sync-incremental-update-error/1259 "2026-01-09T20:36:33Z")
Hi, I’m trying to use Sync to replicate data from Salesforce into a Postgres database. I have a full load working, and every night it truncates then reloads the tables. I’m having a lot of problems setting up another … --- ## [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)
**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")
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… --- ## [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… --- ## [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)
**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")
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… --- ## [dbamp linked service failure pulling data from salesforce to sql](https://community.cdata.com/t/dbamp-linked-service-failure-pulling-data-from-salesforce-to-sql/1216)
**Author:** [@johnmiller](https://community.cdata.com/u/johnmiller)\ **Replies:** 2\ **Last updated:** [October 24, 2025, 7:47pm UTC](https://community.cdata.com/t/dbamp-linked-service-failure-pulling-data-from-salesforce-to-sql/1216 "2025-10-24T19:47:36Z")
version: 4.1.6.0 Description: All of my sql jobs pulling variations of sf\_refresh are failing as of 10/11/2025. Currently not bring any data down in our production environment ERROR: 10/11/2025 5:02:02 AM Log … --- ## [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… --- ## [🚨IF YOU USE API Access Control: Salesforce change may stop DBAmp on Nov 4, 2025 🚨](https://community.cdata.com/t/if-you-use-api-access-control-salesforce-change-may-stop-dbamp-on-nov-4-2025/1224)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [October 21, 2025, 1:26pm UTC](https://community.cdata.com/t/if-you-use-api-access-control-salesforce-change-may-stop-dbamp-on-nov-4-2025/1224 "2025-10-21T13:26:33Z")
TL&DR Salesforce announced on Wednesday, Oct 15, 2025 that it’s deprecating the “Use Any API Client” permission within API Access Control. If your Salesforce org has API Access Control enabled, only allow-listed Connecte… --- ## [DBAmp linked server Error 5103 after Salesforce Winter 2026 release applied to our test org](https://community.cdata.com/t/dbamp-linked-server-error-5103-after-salesforce-winter-2026-release-applied-to-our-test-org/1184)
**Author:** [@nrapoza](https://community.cdata.com/u/nrapoza)\ **Replies:** 16\ **Last updated:** [October 7, 2025, 4:00pm UTC](https://community.cdata.com/t/dbamp-linked-server-error-5103-after-salesforce-winter-2026-release-applied-to-our-test-org/1184 "2025-10-07T16:00:57Z")
We are on DBAmp version 4.1.8. We have a SQL Server Agent job running daily on our test org. After Salesforce Winter ‘26 was applied to the org, we started getting the following failure message. How can we resolve th… --- ## [Migrate from Microsoft Access’ Retired Salesforce Connector with CData](https://community.cdata.com/t/migrate-from-microsoft-access-retired-salesforce-connector-with-cdata/1211)
**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")
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… --- ## [Query Regarding Restrictions on Fetching Campaign Records for Salesforce Marketing Cloud via CData](https://community.cdata.com/t/query-regarding-restrictions-on-fetching-campaign-records-for-salesforce-marketing-cloud-via-cdata/1142)
**Author:** [@kalpeshpawar](https://community.cdata.com/u/kalpeshpawar)\ **Replies:** 1\ **Last updated:** [July 30, 2025, 1:18pm UTC](https://community.cdata.com/t/query-regarding-restrictions-on-fetching-campaign-records-for-salesforce-marketing-cloud-via-cdata/1142 "2025-07-30T13:18:09Z")
We would like to inquire if there are any specific restrictions or limitations when fetching records for “campaigns” specifically from Salesforce Marketing Cloud (SFMC) using CData connectors/drivers. --- ## [Error Fetching Campaigns Entity from Salesforce Marketing Cloud Connector - "\[10000\] A general error occurred while trying to retrieve campaigns](https://community.cdata.com/t/error-fetching-campaigns-entity-from-salesforce-marketing-cloud-connector-10000-a-general-error-occurred-while-trying-to-retrieve-campaigns/1139)
**Author:** [@kalpeshpawar](https://community.cdata.com/u/kalpeshpawar)\ **Replies:** 1\ **Last updated:** [July 30, 2025, 1:09pm UTC](https://community.cdata.com/t/error-fetching-campaigns-entity-from-salesforce-marketing-cloud-connector-10000-a-general-error-occurred-while-trying-to-retrieve-campaigns/1139 "2025-07-30T13:09:37Z")
We are currently using a GCP application integration to connect to Salesforce Marketing Cloud. Our goal is to fetch a list of the Campaigns entity. However, when attempting to list or retrieve data for the Campaigns ent… --- ## [Authenticate and Call Salesforce REST APIs with Postman](https://community.cdata.com/t/authenticate-and-call-salesforce-rest-apis-with-postman/1146)
**Author:** [@Anusha\_M\_B](https://community.cdata.com/u/Anusha_M_B)\ **Replies:** 0\ **Last updated:** [July 30, 2025, 11:11am UTC](https://community.cdata.com/t/authenticate-and-call-salesforce-rest-apis-with-postman/1146 "2025-07-30T11:11:33Z")
Hey CData Community! Looking for a simple and safe way to test Salesforce APIs? Our latest article shows you how to connect with OAuth 2.0, set up Postman, and make REST calls to view or update Salesforce data quickly … --- ## [How to Easily Set Up OAuth Authentication in Salesforce](https://community.cdata.com/t/how-to-easily-set-up-oauth-authentication-in-salesforce/1140)
**Author:** [@Anusha\_M\_B](https://community.cdata.com/u/Anusha_M_B)\ **Replies:** 0\ **Last updated:** [July 25, 2025, 11:29am UTC](https://community.cdata.com/t/how-to-easily-set-up-oauth-authentication-in-salesforce/1140 "2025-07-25T11:29:56Z")
Hey CData Community! Trying to get OAuth working in Salesforce? This easy guide shows you how to set it up step by step, so you can securely connect your applications without any confusion. Check out the article: How t… --- ## [Replicate Salesforce Data to SAP Datasphere with CData Sync](https://community.cdata.com/t/replicate-salesforce-data-to-sap-datasphere-with-cdata-sync/1113)
**Author:** [@user1](https://community.cdata.com/u/user1)\ **Replies:** 0\ **Last updated:** [June 17, 2025, 3:39pm UTC](https://community.cdata.com/t/replicate-salesforce-data-to-sap-datasphere-with-cdata-sync/1113 "2025-06-17T15:39:23Z")
Hey CData Community! Looking to bring your Salesforce data into SAP Datasphere without the headaches? Our latest post, Replicate Salesforce Data to SAP Datasphere with CData Sync, walks you through the full setup — from… --- ## [Question on running DBAmp remotely](https://community.cdata.com/t/question-on-running-dbamp-remotely/1097)
**Author:** [@arijit1001](https://community.cdata.com/u/arijit1001)\ **Replies:** 1\ **Last updated:** [June 13, 2025, 1:18pm UTC](https://community.cdata.com/t/question-on-running-dbamp-remotely/1097 "2025-06-13T13:18:03Z")
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… --- ## [MALFORMED\_QUERY: Implementation restriction: ContentDocumentLink requires a filter by a single Id on ContentDocumentId or LinkedEntityId using the equals operator or multiple Id's using the IN operator.](https://community.cdata.com/t/malformed-query-implementation-restriction-contentdocumentlink-requires-a-filter-by-a-single-id-on-contentdocumentid-or-linkedentityid-using-the-equals-operator-or-multiple-ids-using-the-in-operator/1053)
**Author:** [@Ismete\_M](https://community.cdata.com/u/Ismete_M)\ **Replies:** 0\ **Last updated:** [March 13, 2025, 3:31pm UTC](https://community.cdata.com/t/malformed-query-implementation-restriction-contentdocumentlink-requires-a-filter-by-a-single-id-on-contentdocumentid-or-linkedentityid-using-the-equals-operator-or-multiple-ids-using-the-in-operator/1053 "2025-03-13T15:31:36Z")
When trying to get ContentDocumentLink records with the following query example: SELECT \* FROM ContentDocumentLink Salesforce returns the following error: MALFORMED\_QUERY: Implementation restriction: ContentDocumentLi… --- ## [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 DBAmp Q3 2024 release is here!](https://community.cdata.com/t/cdata-dbamp-q3-2024-release-is-here/883)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [August 13, 2024, 8:43pm UTC](https://community.cdata.com/t/cdata-dbamp-q3-2024-release-is-here/883 "2024-08-13T20:43:28Z")
:rocket: Exciting News from the CData DBAmp Team! The CData DBAmp Q3 2024 release is here, ushering in groundbreaking enhancements to supercharge your Salesforce data integration. :magnifying\_glass\_tilted\_left: What… --- ## [Getting Errors during replication](https://community.cdata.com/t/getting-errors-during-replication/732)
**Author:** [@Peter\_Boelke](https://community.cdata.com/u/Peter_Boelke)\ **Replies:** 4\ **Last updated:** [July 29, 2024, 5:48am UTC](https://community.cdata.com/t/getting-errors-during-replication/732 "2024-07-29T05:48:21Z")
Hi, since two weeks we are getting error when replicating all of our salesforce objects. The error does occur randomly not specific to an object. See error example message: --- Starting SF\_Replicate for ContentWorksp… --- ## [DBAmp - Mirror of data fails when object has a lower case character after initial double underscore \_\_](https://community.cdata.com/t/dbamp-mirror-of-data-fails-when-object-has-a-lower-case-character-after-initial-double-underscore/782)
**Author:** [@Alastair\_Bacon](https://community.cdata.com/u/Alastair_Bacon)\ **Replies:** 1\ **Last updated:** [June 13, 2024, 3:48pm UTC](https://community.cdata.com/t/dbamp-mirror-of-data-fails-when-object-has-a-lower-case-character-after-initial-double-underscore/782 "2024-06-13T15:48:52Z")
When trying to mirror a salesforce object using the following: EXEC SF\_Mirror ‘SFPROD’, ‘c2g\_\_codaBankAccount\_\_c’; I get a failure as follow: --- Starting SF\_Mirror for c2g\_\_codaBankAccount\_\_c V8774 11:34:52: Paramet… --- ## [Upsert Salesforce Data using External Id in SSIS](https://community.cdata.com/t/upsert-salesforce-data-using-external-id-in-ssis/657)
**Author:** [@Andrew\_H](https://community.cdata.com/u/Andrew_H)\ **Replies:** 0\ **Last updated:** [March 11, 2024, 2:27pm UTC](https://community.cdata.com/t/upsert-salesforce-data-using-external-id-in-ssis/657 "2024-03-11T14:27:03Z")
First, set up the data source. A Salesforce source is used in this example, but any source will work for this process. Drag a Derived Column transformation component from the Data Flow Transformations section of … --- ## [Support for Salesforce Non Profit Cloud](https://community.cdata.com/t/support-for-salesforce-non-profit-cloud/655)
**Author:** [@CarlRayer](https://community.cdata.com/u/CarlRayer)\ **Replies:** 1\ **Last updated:** [March 8, 2024, 6:09am UTC](https://community.cdata.com/t/support-for-salesforce-non-profit-cloud/655 "2024-03-08T06:09:37Z")
Hi Is support for the new objects in Salesforce’s Non Profit Cloud (NPC) built into the latest version of dbamp; this would be for objects like GiftTransaction, etc? If not, is there a timeline to provide support? Man… --- ## [Salesforce driver - json data](https://community.cdata.com/t/salesforce-driver-json-data/606)
**Author:** [@carmel.ron](https://community.cdata.com/u/carmel.ron)\ **Replies:** 1\ **Last updated:** [January 26, 2024, 11:13pm UTC](https://community.cdata.com/t/salesforce-driver-json-data/606 "2024-01-26T23:13:42Z")
I upgraded the Salesforce JDBC driver from version 21 to 23. There is a difference in behavior between the 2 versions : I execute this query and get different results: SELECT User.Name FROM User On version 23: {… --- ## [DBAmp Error – “QUERY\_TIMEOUT: Your query request was running for too long.”](https://community.cdata.com/t/dbamp-error-query-timeout-your-query-request-was-running-for-too-long/559)
**Author:** [@DylanO](https://community.cdata.com/u/DylanO)\ **Replies:** 0\ **Last updated:** [December 11, 2023, 10:41pm UTC](https://community.cdata.com/t/dbamp-error-query-timeout-your-query-request-was-running-for-too-long/559 "2023-12-11T22:41:05Z")
This error indicates that the request from your query took too long and timed out on Salesforce’s servers. This timeout limitation is set by Salesforce, so the only solution is to improve the speed of your query. If you… --- ## [DBAmp: ‘EXCEEDED\_ID\_LIMIT: EntityDefinition does not support queryMore(), use LIMIT to restrict the results to a single batch’ when executing a SELECT \* FROM \[(linked\_server\_name)\_Fields\] system view](https://community.cdata.com/t/dbamp-exceeded-id-limit-entitydefinition-does-not-support-querymore-use-limit-to-restrict-the-results-to-a-single-batch-when-executing-a-select-from-linked-server-name-fields-system-view/553)
**Author:** [@Ismete\_M](https://community.cdata.com/u/Ismete_M)\ **Replies:** 0\ **Last updated:** [December 6, 2023, 10:30pm UTC](https://community.cdata.com/t/dbamp-exceeded-id-limit-entitydefinition-does-not-support-querymore-use-limit-to-restrict-the-results-to-a-single-batch-when-executing-a-select-from-linked-server-name-fields-system-view/553 "2023-12-06T22:30:48Z")
Getting the following error after executing: SELECT \* FROM \[\\_Fields\]: “EXCEEDED\_ID\_LIMIT: EntityDefinition does not support queryMore(), use LIMIT to restrict the results to a single batch” This… --- ## [DBAmp: “MISSING\_ARGUMENT:(External ID field name) not specified:--" error when performing Upsert operation with SF\_TableLoader using an External ID](https://community.cdata.com/t/dbamp-missing-argument-external-id-field-name-not-specified-error-when-performing-upsert-operation-with-sf-tableloader-using-an-external-id/547)
**Author:** [@Ismete\_M](https://community.cdata.com/u/Ismete_M)\ **Replies:** 0\ **Last updated:** [December 1, 2023, 9:25pm UTC](https://community.cdata.com/t/dbamp-missing-argument-external-id-field-name-not-specified-error-when-performing-upsert-operation-with-sf-tableloader-using-an-external-id/547 "2023-12-01T21:25:11Z")
This error is thrown by Salesforce itself when attempting to Upsert an input table that does not always contain a value for the External ID field(in this case External\_ID\_\_c as shown in the example below). When performin… [Next page](https://community.cdata.com/tag/salesforce/12.md?match_all_tags=true&page=1&tags%5B%5D=salesforce)