Questions tagged [dbamp]
(Paid) SQL Server tool used to extract data from Salesforce orgs into a database, usually ready for further integrations. Site: https://forceamp.com/
8
questions
0
votes
1
answer
3k
views
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 ...
- 243
0
votes
1
answer
86
views
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 ...
- 381
0
votes
0
answers
223
views
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 ...
- 325
0
votes
1
answer
2k
views
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 ...
- 1
0
votes
1
answer
472
views
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 ...
2
votes
1
answer
186
views
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 ...
- 21
1
vote
1
answer
713
views
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 ...
- 3,618
2
votes
1
answer
993
views
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 ...
- 6,145