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/

Filter by
Sorted by
Tagged with
0
votes
1answer
27 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 ...
0
votes
0answers
32 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 ...
0
votes
1answer
513 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 ...
0
votes
1answer
256 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
1answer
114 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 ...
1
vote
1answer
526 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 ...
2
votes
1answer
598 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 ...