CData DBAmp

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 the joins).For example the 2 queries should produce the same results both return the same values.  They do not because the order returned is different even when the values are the same.    select top(5) account.id from [salesforce].cdata.salesforce.account order by account.id COLLATE        SQL_Latin1_General_CP1_CI_AS asc;    select top(5) cast(account.id as nchar(18)) from [salesforce].cdata.salesforce.account order by cast(account.id as nchar(18)) COLLATE SQL_Latin1_General_CP1_CI_AS asc; If I change the query to do a case sensitive ordering like so, then the results match.  select top(5) account.id from [salesforce].cdata.salesforce.account order by account.id COLLATE      SQL_La

version: 4.1.6.0Description: 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 AMLog        Job History (SF_Refresh Salesforce - ChargentBase__Gateway__c)Step ID        1Server        AZSQL02Job Name        SF_Refresh Salesforce - ChargentBase__Gateway__cStep Name        1Duration        00:00:00Sql Severity    16Sql Message ID    0Operator Emailed    Operator Net sent    Operator Paged    Retries Attempted    1MessageExecuted as user: NT SERVICE\SQLSERVERAGENT. --- Ending SF_Refresh. Operation FAILED. [SQLSTATE 42000] (Error 50000)  --- Starting SF_Refresh for ChargentBase__Gateway__c V4.1.4 [SQLSTATE 01000] (Error 0)  05:02:02: Using Schema Error Action of yes [SQLSTATE 01000] (Error 0)  OLE DB provider "DBAmp.DBAmp" for linked server "Salesforc

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 me this error. this didnt happen in my old dbamp version. ideas onf ix?                select *                --  select count(*)FROM [MATCHFORCE].[CData].[Salesforce].[Application__c_QueryAll]WHERE [LastModifiedDate] <   dateadd(second,-1,(dateadd(day, datediff(day, 2, getdate()),0)))                AND [LastModifiedDate] > datead

Getting the below error in Prod OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE_LS" returned message "Error 5103 : Error: Zipped response from salesforce was missing valid zip header.". [SQLSTATE 01000]

 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 this? OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" returned message "Error 5103 : Error: Zipped response from salesforce was missing valid zip header.".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE". 

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 call sf_replicate directly on v.22.  The CMDEXEC looks like this on 4.1.8:  '"C:\Program Files\DBAmp\DBAmpNet2.exe" replicate pkchunk,batchsize(25000) Account MyServerName  MyDatabase SALESFORCE'Will the call have to look something like this on v.22? "C:\Program Files\CData\CData DBAmp\bin\DBAmpAZ.exe" MirrorCopy Account MyServerName MyDataBase SALESFORCE pkchunk,batchsize(25000)  

We’ve recently upgraded to the latest version of dbamp. Since doing so we are constantly seeing the following error on one of sf objects when we bring it down to SQL via the “exec sf_refresh” command. Executing the query "DECLARE @IncludeArchiveDeleted  BIT, @Table VARCHA..." failed with the following error: "Cannot fetch a row from OLE DB provider "MSOLEDBSQL" for linked server "SalesForce_ls".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.   We only get this error on this one particular object. Task is probably the largest object in salesforce whose data we bring down locally to our SQL environment. Any help would be very much appreciated. Thanks and have a great day.  Running DBAMP 22.0.8991.0 version

When attempting to use SF_Metadata to retrieve metadata from CustomField, the MetadataXML column is never populating. The Member and Id columns are populating when I use the List operation, and executing the proc with the Retrieve operation appears to succeed, but the MetadataXML column remains NULL.CustomObject and the other tooling objects I’ve worked with have worked fine.This behavior is not confined to a single org. I have confirmed it against three orgs so far.I’ve tried querying CustomField directly in a query using the four-part object identifier, but I get an errorMsg 7314, Level 16, State 1, Line 1The OLE DB provider "MSOLEDBSQL" for linked server "<linked server name here>" does not contain the table ""CData"."Salesforce"."CustomField"". The table either does not exist or the current user does not have permissions on that table.I am able to successfully query the CustomField object in the

Hi, since a month we are getting this error:08:06:39: Using the Salesforce SOAP API. [SQLSTATE 01000]08:06:39: Create AuraDefinitionInfo_Previous20250630080639716 with new structure. [SQLSTATE 01000]08:06:40: Error System.Web.Services.Protocols.SoapException: EXCEEDED_ID_LIMIT: AuraDefinitionInfo does not support queryMore(), use LIMIT to restrict the results to a single batch [SQLSTATE 01000]at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) [SQLSTATE 01000]at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) [SQLSTATE 01000]at DBAmpAZ.sforce.SforceService.query(String queryString) [SQLSTATE 01000]at afo220A.iA.s() [SQLSTATE 01000]08:06:40: Drop if it exists. [SQLSTATE 01000]08:06:40: Error: Unable to drop the table. [SQLSTATE 01000]08:06:40:

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 dbamp remotely - to a on-prem SQL server virtual machine. We will create a Azure SQL managed instance where data will be stored. - DBInstanceDbAmp will be configured as linked server  in a on premise virtual machine with SQL server installed. - DBAmpServer I have two questions:Can we run DBAmp from DBAmpServer to move the data from DBInstance to Salesforce? The article DBAmp - Running DBAmp Remotely (cdata.com) mentions the other way around, but we need a bi-direction data transfer between DBInstance and Salesforce. The article mentions that a subset of stored procedures will be av

Hi, We recently renewed our license for another year, i have applied it to all dev and Test SQL servers, and the offline node in Prod, but our online node in prod gets the below error.  Can you please advise what to do to resolve this??  We only have a couple of days before our current license expires.ThanksAndrew

I just noticed the EOL announcement for  CData DBAmp versions prior to v22 on this page.  My organization is still on version 4.1.8. I’m interpreting this announcement to mean that version 4.1.8 will continue to work as long as we have a valid license key.  So it will still be running on say, 1/31/2025.  Is this correct? I keep getting surprised by these announcements.  Besides coming to the CDATA site and browsing around, how can I stay up to date on important news?I WILL be talking to my manager about upgrading to the most current version ASAP, but we will need time for lots of testing.

soql passed through dbamp to salesforce using openquery syntax selects from Contact and includes select from child table.    See query below.For the ID specified in the query there are 13 records in the child table which match that ID.  Only 2 records are returned. Would like to know why.  Is this a DBAmp bug?  I did just install the latest DBAmp version.  22.0.8991.0Any other possible explanation? SELECT * FROM  OPENQUERY(SALESFORCE, '  SELECT ID, Email, CLSA_Date_Completed__c, Client_Identifies_Race__c, Latino_Hispanic__c, ExpECM__Race__c, Religious_Spiritual_Affiliation__c, ExpECM__Preferred_Language__c, Secondary_Language_Spoken__c, SACWIS_Case_ID__c, SACWIS_Person_ID__c, Primary_Insurance_Company_HMO__c,  npe01__HomeEmail__c,Preferred_Method_of_Contact__c,Primary_Policy_including_MA__c, Primary_Phone__c, Primary_Phone_is_Mobile__c, Secondary_Phone__c, Secondary_Phone_is_Mobile__c, (SELECT ExpECM__Main_Client__c, Name FR

I have a SQL agent job running SF_Mirror for a single object every 15min. When the job runs I can see the DBAmpAZ.exe process restart and I get CPU spikes to 80-100% for the duration of the run.  The job generally runs in about 30 sec.Is there anything I can do to cap its CPU usage, or anything I can look at changing to prevent it from spiking that high? 

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 it up in DBAmp v_59109. 

is DBAmp v_50109 supported on SQL Server 2022 with Windows OS 2022? The linked server is not working on it. Same is working fine on SQL Server 2016.

 🚀 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.  🔍 What's New?  Enhanced System Tables and Procedures: Dive into our newly added tables—SF_SysSFPicklistTable, SF_SysSFFieldsTable, and SF_SysSFObjectsTable—designed to simplify and streamline your data interactions. 🌟  Merge Capabilities: The introduction of the SF_Merge function now makes consolidating Salesforce records a breeze. 🔄  Security Upgrades: Tailor your security settings with advanced SSL configurations, ensuring your data transfers are safer than ever. 🔒  Improved Data Handling: Robust enhancements to SF_Replicate mean bigger data transfers with better efficiency. 📊  💬 End-of-Li

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 ContentWorkspaceDoc V8641 [SQLSTATE 01000]16:21:52: Parameters: [LS_SALESFORCE_PROD] ContentWorkspaceDoc Version: V8641 [SQLSTATE 01000]16:22:20: Running DBAmpAZ.exe. [SQLSTATE 01000]16:22:20: DBAmpAZ 22.0.8642.0 Copyright © 2023 CData Software, Inc. [SQLSTATE 01000]16:22:20: Using options specified in Options parameter: soap [SQLSTATE 01000]16:22:36: Error: Unable to open a connection to SQL Server. [SQLSTATE 01000]16:22:36: System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) ---> System [SQLSTATE 01000].ComponentModel.Win32Excepti

Hello,I will really appreciate your help with below question related to version upgrade.Our team is planning to upgrade DBAmp version from  4.1.8.to V2022.While going thorugh release notes ,came across with statement:“Using DBAmp with SSIS has been removed. We recommend you use the CData SSIS product.” Does it means that,We will not be able to execute DBAmp  SQL server stored procedures through SSIS packages that we have installed on our side that we are using currently?  If yes,what we can use,do we need to buy some new product. Thanks You  

Hello,I will really appreciate your help with below question related to version upgrade.Our team is planning to upgrade DBAmp version from  4.1.8.to V2022.While going thorugh release notes ,came across with statement:“Using DBAmp with SSIS has been removed. We recommend you use the CData SSIS product.” Does it means that,We will not be able to execute DBAmp  SQL server stored procedures through SSIS packages that we have installed on our side that we are using currently?  If yes,what we can use,do we need to buy some new product. Thanks You  

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 V877411:34:52: Parameters: SFPROD c2g__codaBankAccount__c  Version: V877411:34:52: Running DBAmpAZ.exe.11:34:52: DBAmpAZ 22.0.8775.0 Copyright © 2023 CData Software, Inc.11:34:52: Obtaining Connection Props11:34:52: Obtaining User Information11:34:53: Using settings from Registry.11:34:53: Retrying describeSObject call to Salesforce.11:34:53: Retrying describeSObject call to Salesforce.11:34:53: Retrying describeSObject call to Salesforce.11:34:53: System.Web.Services.Protocols.SoapException: INVALID_TYPE: sObject type 'c2g__c' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate

🚀 Exciting News from the DBAmp Team! The CData DBAmp Winter 2024 Release is here, bringing groundbreaking enhancements to your experience!  🔍 What's New?  Significantly improved OpenQuery Performance: We've optimized the TDS daemon process, ensuring a 50% boost in efficiency for OpenQuery operations! 📈  Refined internal operations: With smarter processing of SMP request packets and timely SMP scheduling thread notifications, say goodbye to waiting times. ⏱️  Enhanced system alignment: The execution times in SSMS are now closely synced with the Salesforce driver method. 🔄  💡 Why This Matters?  Experience unparalleled efficiency and reliability with CData DBAmp.   Our commitment to quality and customer satisfaction shines through in every update.   👉 Don't miss out on the latest advancements that CData DBAmp has to offer. Download the newest version and take adv

If we configure DBAmp to use a remote server (e.g. Azure managed SQL), does all data flow through the server where DBAmp is installed?  And if so, what is the transport-layer security between the DBAmp-server and the remote server?

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 dbamp remotely - DBAmp - Running DBAmp Remotely (cdata.com)Client have created 2 servers one where data will be stored - dbSeverTwo where dbamp will be configured as linked server - dbampServerData Scenario - Data will be storing in Ddrive so I am using SSIS to push the data into SQL server I have created package and deploying that package to both dbserver and dbamp ServerSo my question is in the article it says to create remote database  “Salesforce Backups” in remote server instance to hold the salesforce data but can’t we store the same data in dbamp server? Is there any security concern or limitation if we