Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Can JOIN be performed remotely in Salesforce via DbAmp?

When retrieving data from Salesforce via DbAmp, is there a way to force join operations remotely (on Salesforce side) rather than in Sql Server? We analysed the execution plan of queries with join in it and it seems always perform join locally in Sql Server.
2 people have
this question
+1
Reply
  • Yes, joins can be pushed to the salesforce back-end by using the OPENQUERY clause and DBAmp's full SOQL support.

    There is extensive documentation on the SOQL support in Chapter 2 of the DBAMp manual. Note that you must be using DBAmp version 2.13.2 or higher. If you need to upgrade DBAmp, follow the instructions at www.forceamp.com/upgrade.htm

    NOTE: SOQL does not have the same syntax as SQL. When using OPENQUERY, you must write the query using SOQL constructs. Contact DBAmp support if you need help "converting" .
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned