CData DBAmp

Share product questions and get support for CData DBAmp

  • 21 Topics
  • 28 Replies

21 Topics

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

1
H
2 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?

1
D
4 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? 

2
D
5 months 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

1
D
5 months 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.

3
D
5 months 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”.

2
D
8 months 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

2
S
8 months 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(

1
D
9 months 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

1
D
9 months 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

1
Ankit Singh
10 months 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.

1
E
10 months 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.

3
D
11 months 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?

1
D
11 months 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?

1
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

1
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.

1
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?

1
E
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp

I upgraded and now my stored procedures don't work

I upgraded to v22, and followed the instructions to set up a new linked server. Querying it works fine, but I can’t use the stored procedures. I get something like this every time:--- Starting SF_Replicate for account V5.1.811:34:36: Parameters: salesforce2022 account  Version: V5.1.811:34:36: DBAmpAZ 5.1.8.0 Copyright c 2021 CData Software, Inc.11:34:36: Using options specified in Options parameter: soap11:34:40: Retrying11:34:40: Retrying11:34:40: Retrying11:34:40: Error: Unable to retrieve settings from Registry.11:34:40: System.Data.SqlClient.SqlException (0x80131904): The OLE DB provider "MSOLEDBSQL" for linked server "salesforce2022" does not contain the table "sys_sfsession". The table either does not exist or the current user does not have permissions on that table.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateO

1
D
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp

Do I have to name the database salesforce backups?

When I went through the directions here, https://cdn.cdata.com/help/AFH/dbampd/Installation_Upgrading.html it says to create a database for the stored procedures called salesforce backups. That doesn’t fit our naming conventions - is there a way around that?

1
D
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp

I installed the new DBAmp and the provider is missing

After I installed this new DBAmp v22, I tried to remake the linked server I had before, but the DBAmp.DBAmp provider wasn’t in the list. How do I get the provider?

1
D
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp

DBAmp commands failing with timeout errors

Whenever I try to do anything with the linked server, I either get an error about the OLE DB provider returning a message that the “Login timeout expired” or “TCP Provider: The wait operation timed out.” Sometimes it also says "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible.” I can’t do anything with DBAmp, how do I fix this?

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

Badge winners

Show all badges
Terms and ConditionsCookie settings