Skip to main content

CData DBAmp

Share product questions and get support for CData DBAmp

  • 35 Topics
  • 44 Replies
35 Topics
T
Tim WeigelApprentice
asked in CData DBAmp
Unable to get MetadataXML from CustomField via SF_Metadata

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 org via SOQL through Inspector and Workbench to retrieve metadata. I’ve done a fa

281
D
P
Peter_BoelkeApprentice
asked in CData DBAmp
Error when retrieving AuraDefinition

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: System.InvalidOperationException: ExecuteReader: Connection property has not been ini

473
Ethem Q
A
arijit1001Apprentice
asked in CData DBAmp
Question on running 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 - 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 available. Can you confirm if that subset includes all SPs needed to transfer data between SQL tables and Salesforce standard & custom objects as well as extracting error logs to DBInstance fro

261
D
A
andrew.wilsonApprentice
asked in CData DBAmp
DBAMP - Unable to apply new license to server

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

1171
Ethem Q
N
nrapozaApprentice
asked in CData DBAmp
DBAmp upgrades and licensing questions

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.

1181
Ethem Q
H
HRMillerApprentice
asked in CData DBAmp
SOQL passed via DBAmp to Salesforce using openquery does not return all rows.

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 FROM ExpECM__Case_Records__r)FROM ContactWHERE ID = ''0031U00001

00
H
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? 

480
T
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. 

861
Ethem Q
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.

471
Ethem Q
A
Anonymous
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

1390
A
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

3554
P
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  

931
D
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  

921
D
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

1981
A
A
Anonymous
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

2051
H
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?

981
D
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? 

2212
D
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

881
D
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.

1853
D
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”.

4712
D
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

3852
S
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(

7281
D
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

2051
D
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

1081
Ankit Singh
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.

1011
E
CData Foundations 2025

Badge winners

Show all badges
Terms and ConditionsCookie settings