Skip to main content

CData DBAmp

Share product questions and get support for CData DBAmp

  • 29 Topics
  • 37 Replies
29 Topics
T
TnerbApprentice
asked in CData DBAmp
DBAmpAZ.exe (SF_Mirror) high CPU

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? 

150
T
23 days ago
P
pmaharjanApprentice
asked in CData DBAmp
Setup Two DBAmp Linked Server in SQL Server 2022

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. 

361
Ethem Q
1 month ago
P
pmaharjanApprentice
asked in CData DBAmp
Salesforce Linked Server on SQL Server 2022, Windows OS 2022

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.

251
Ethem Q
1 month ago
John
JohnCommunity Manager
posted in CData DBAmp
CData DBAmp Q3 2024 release is here!

 🚀 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-Life Reminder: As a friendly heads-up, support for DBAmp versions prior to v22 will end on December 31, 2024. Be sure to upgrade to continue receiving support and new features! 💬 We're thrilled to invite you to join th

710
John
3 months ago
P
Peter_BoelkeApprentice
asked in CData DBAmp
Getting Errors during replication

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.Win32Exception (0x80004005): The wait operation timed out [SQLSTATE 01000]at System.Da

1954
P
3 months ago
J
jitendrappApprentice
asked in CData DBAmp
DBAmp upgrade with SSIS

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  

631
D
3 months ago
J
jitendrappApprentice
asked in CData DBAmp
DBAmp upgrade to V2022 with SSIS

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  

671
D
3 months ago
A
Alastair BaconApprentice
asked in CData DBAmp
DBAmp - Mirror of data fails when object has a lower case character after initial double underscore __

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 names.   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMe

1101
A
5 months ago
John
JohnCommunity Manager
posted in CData DBAmp
CData DBAmp Winter 2024 Release is here!

🚀 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 advantage of a free trial today. Your feedback is what drives our innovation – be a part of our community and share you

1691
H
9 months ago
N
NeilHApprentice
asked in CData DBAmp
Data transport when using DBAmp remotely

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?

841
D
11 months ago
S
SrilathaApprentice
asked in CData DBAmp
Installing Dbamp Remotely

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 store Salesforce data in dbamp server? 

1742
D
1 year ago
M
MichaelsApprentice
asked in CData DBAmp
Salesforce Custom Address Fields Requirements and Limitations

Hi,We have a client who is interested in using the new Salesforce custom address fields. (https://help.salesforce.com/s/articleView?id=sf.fields_caf_requirements.htm&type=5) . Because it looks like data can only be imported using Bulk Api 2.0 does anyone know if DBAmp can support import into these new fields? Thanks!Eve

631
D
1 year ago
D
DLIApprentice
asked in CData DBAmp
Bad performance of DBAmp V22

Why DBAmp V22 SF_MirrorAll takes much more time (couple hours) than V5.1.9 SF_RefreshAll? even I skipped many tables, like %History, %Share... Also there are many error messages: Error occurred creating primary key for table.

1413
D
1 year ago
B
bdempseyApprentice
asked in CData DBAmp
DBAmp 2022 Fails to Update License if not installed on C: Drive (with workaround)

My DBAMP version is 22.0.8354.0I have DMAMP installed on a non OS Drive.   M:\Program Files\Cdata\CData DBAmpTrying to upgrade the license using the Config Utility.  Help → Licensing ->Update LicenseGetting following error.  The keys.reg file does not exist on my installation. Work Around Create the folder + File the error was complaining about. It can be an empty text file.“c:\CData\CData DBAmp\keys.reg”Re-Run the Update License command and seems to work fine now. Question Is this fixed in a later version of dbamp?  I am aware I dont have the most recent “patch”.

3472
D
1 year ago
S
shreyApprentice
asked in CData DBAmp
Upgraded DBAmp and the SOQL queries don't work

We upgraded DBAMp version on our SQL Server.Followed the instructions and created a new Linked Server. Stored procedures are running fine, but when I execute a SOQL query; we get the following error An invalid schema or catalog was specified for the provider "MSOLEDBSQL" for linked server "SalesForce". Example SOQL queriesSelect * from SalesForce...user__cSelect * from SalesForce...Account

2892
S
1 year ago
S
shreyApprentice
asked in CData DBAmp
DBamp Stored procedures failing after upgrade to V2022: Unable to retrieve settings from sys_connection_props.

We upgraded to DBAmp V22 version. Have upgraded the Stored Procedures.Regular SOQL queries work from the SQL server, but when try using SF_REPLICATE or SF_REFRESH we get the following error. --- Starting SF_Replicate for Account V830409:56:45: Parameters: SALESFORCE Account  Version: V830409:56:45: DBAmpAZ 22.0.8304.0 Copyright c 2021 CData Software, Inc.09:56:45: Using options specified in Options parameter: soap09:56:45: Obtaining Connection Props09:56:46: Error: Unable to retrieve settings from sys_connection_props.09:56:46: System.Data.SqlClient.SqlException (0x80131904): Cannot get the column information from OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)   at System.Data.SqlClient.TdsParser.TryRun(

5281
D
1 year ago
A
andrew.wilsonApprentice
asked in CData DBAmp
DBAmp v2022 Collation issues

Hi, We are migrating to new SQL 2022 servers.  I have installed v2022 of DBAmp on our new dev server, we use SF_Replication/SF_Refresh, changing to SF_Mirror is not yet on the table.  My default server collation is Latin1_General_CI_AS, and the DBAmp replicant also becomes this collation.  This is the exact same setup we run in production, with version 5.1.8.0 of dbamp.   Both environments, current prod and new dev have “Collation Compatible” and “Use Remote Collation” set to true.I have run a full SF_Replicate, and when i start to run the daily SF_Refresh i am getting the below error:--- Starting SF_Refresh for Contact V830416:12:31: Using Schema Error Action of subsetdelete16:12:37: Local table created at: 2023-05-17 16:29:0016:12:37: Using last run time of 2023-05-17 16:29:00Msg 468, Level 16, State 9, Line 1Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.--- Ending SF_Refresh. Operation FAILED.Msg 500

1721
D
1 year ago
A
AndreQApprentice
asked in CData DBAmp
Weekly SF_ReplicateAll failing

There are a host of errors, mostly “Error occurred creating primary key for table.” in tables AppDefinition, AuraDefinitionBundleInfo, AuraDefinitionInfo, FormulaFunction, FormulaFunctionAllowedType, FormulaFunctionAllowedType and other. but also “Using FullCopy because the FieldChangeSnapshot table does not exist.”threw a SOAP error: Error System.Web.Services.Protocols.SoapException: EXTERNAL_OBJECT_UNSUPPORTED_EXCEPTION: Enter a valid ParentID.    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)   at DBAmpAZ.sforce.SforceService.query(String queryString)    at afo220l.Uh.w() Should I wipe out all the tables and start again? Please advise.RegardsAndre

881
Ankit Singh
1 year ago
B
bdempseyApprentice
asked in CData DBAmp
DBAMP Patches and Hotfix Plans

Is there a patch / hotfix official release schedule for DBAMP? There must be some fixes since the official V2022 release.  I did get some Hotfix patches but was wondering if I am to expect an official 2023 or 2022.1 release. I currently have to restart the windows service each night to prevent crashes.

861
E
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp
I can't run any command using bulkapi!

Whenever I try to use the bulkapi, or pkchunk, or even just use SF_Mirror on a large table, it says that SF_Mirror fails. The message output looks like this:--- Starting SF_Mirror for Account V830410:53:19: Parameters: salesforce2022 Account bulkapi Version: V830410:53:19: DBAmpAZ 22.0.8304.0 Copyright c 2021 CData Software, Inc.10:53:19: Using options specified in Options parameter: bulkapi10:53:19: Obtaining Connection Props10:53:28: Obtaining User Information10:53:31: Using settings from Registry.10:53:33: Error: DBAmpWork directory does not exist.10:53:33: DBAmpAZ Operation FAILED.10:53:33: Error: MirrorCopy program was unsuccessful.10:53:33: Error: Command string is C:\"Program Files"\CData\"CData DBAmp"\bin\DBAmpAZ.exe MirrorCopy "Account"  "DL-7KVJRL3"  "salesforce_backups2022"  "salesforce2022"  "bulkapi"--- Ending SF_Mirror. Operation FAILED.Msg 50000, Level 16, State 1, Procedure sf_mirror, Line 173 [Batch Start Line 1]--- Ending SF_Mirror. Operation FAILED.

3093
D
1 year ago
T
tc_1Apprentice
asked in CData DBAmp
Replacement for Replicate_KAV

I’ve upgraded to the CData version of DBAMP, and I see that there is no longer a separate procedure for replicating the KnowledgeBase.  Is there a replacement process for this sync?

311
D
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp
SF_Refresh tells me that I've exceeded ID limit

When I run SF_Refresh on one of my tables, I get the error "EXCEEDED_ID_LIMIT: there are '600000' or more records deleted in the specified time period" and it won’t complete. How can I run SF_Refresh on that table?

3211
D
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp
Replicating fails for my big tables

When I run SF_Replicate on my tables with lots of fields, like Account and Case, it fails. SF_Mirror also fails, and I can’t run SF_Refresh because there’s been a field added so it just tries to run SF_Replicate anyway. The message output looks like this:--- Starting SF_Replicate for Account V5.1.812:58:41: Parameters: Salesforce Account  Version: V5.1.812:58:41: DBAmpAZ 5.1.8.0 Copyright c 2021 CData Software, Inc.12:58:41: Using options specified in Options parameter: soap12:58:42: Using settings from Registry.12:58:42: Using FullCopy to replicate the Account table.12:58:42: Server: DL-7KVJRL3, Database: olddbamp, Linked Server: Salesforce12:58:42: Using the Salesforce SOAP API.12:58:43: Opening SQL Server rowset12:58:43: Error: Commit failed.Source: Microsoft SQL Server Native Client 11.0Description: The statement has been terminated.Source: Microsoft SQL Server Native Client 11.0Description: Cannot create a row of size 8107 which is greater than the allowable maximum row size of 80

2571
D
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp
New standard fields not showing up

Salesforce added a couple new fields to the Contact and Lead objects, GenderIdentity and Pronouns. I can find them in Data Loader and in Workbench, but DBAmp is not bringing them down. How do I get DBAmp to find those new fields? I have DBAmp v22, if that makes a difference.

4431
D
1 year ago
E
Elizabeth GEmployee
asked in CData DBAmp
Will enabling MFA affect DBAmp?

My organization is trying to enable MFA in Salesforce. Will this affect DBAmp's ability to function?

491
E
1 year ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Show all badges
Terms and ConditionsCookie settings