Questions tagged [dbamp]

(Paid) SQL Server tool used to extract data from Salesforce orgs into a database, usually ready for further integrations. Site:

Filter by
Sorted by
Tagged with
0 votes
1 answer

Update created date from Data Loader or DBAmp [duplicate]

I'm migrating data over from another CRM. The person who did it didn't populate the correct Created Dates for our contacts, so another field was created that does have the correct created date. Am I ...
jdids's user avatar
  • 243
0 votes
1 answer

Loading Encrypted Records

I have been looking to see what other people have experienced regarding loading records into an environment with encryption enabled. If I were to use a tool such as DBamp, to load records into an an ...
TestMcTesterson's user avatar
0 votes
0 answers

requirement to directly call sql stored procedure from salesforce

I have a requirement to directly call sql stored procedure from salesforce but those stored procedure are not exposed as a service. I found a tool called DBAmp which states it can be achieved but is ...
Debarun Sengupta's user avatar
0 votes
1 answer

Datetime in WHERE clause

I am facing issue with Datetime column in WHERE clause. Below two queries are giving different counts. SELECT COUNT(CallTime_c) FROM SF...TableName WHERE CallDateTime > '09-13-2018 09:01:00' and ...
Mahesh's user avatar
  • 1
0 votes
1 answer

Trying to export field accessibility metadata for all object fields

I'm trying to find a way to export the field accessibility metadata for all object fields. It appears like I should be able to do this with my linked objects within my SQL server database using dbamp ...
Michael Buck's user avatar
2 votes
1 answer

Can't Use _Queryall in DBAMP for custom object

I am using DBAMP connection to Query custom objects in Salesforce from SQL database. I want to query deleted records and when i use the _queryall suffix for standard objects i get that. Howwever if i ...
Moshe's user avatar
  • 21
1 vote
1 answer

Can I UPSERT on Id using DBAmp?

I know I can upsert on an external Id in DBAmp. The DBAmp documentation makes a lot of reference to specifying the external Id in an upsert call, but no reference to making an upsert based on the ...
Dominic's user avatar
  • 3,618
2 votes
1 answer

Roll-up Summary fields not Recalc on import

We use DBAmp to import records from another system. Everything works fine except for when creating a new record. The record does not roll-up via the summary field on it's parent. Any ideas or other ...
dphil's user avatar
  • 6,145