Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m happy

Using an ARRAY

Can you do something like similar to this in the same instance...(ignore the syntax)

array = recordset.GetRows....... FROM SQL.TABLE WHERE PURCHASE_PAID = TRUE AND BATCHED = FALSE

UPDATE SF.TABLE SET PURCHASE_COLUMN = TRUE WHERE SFID = (SELECT ID FROM SQL.TABLE WHERE ID = array)

UPDATE SQL.TABLE SET BATCHED = TRUE WHERE ID = array
1 person has
this question
+1
Reply
  • UPDATE SF.TABLE SET PURCHASE_COLUMN = TRUE WHERE SFID = (SELECT ID FROM SQL.TABLE WHERE ID = array)

    While this might be technically possible, it would not be a scalable use of the salesforce.com api. The issue is that you are not taking advantage of the batch capability of the api.

    A better approach would be to replace this update with the concept of a local Update table. The code would write the Id and desired data values to a local table. Think of the local table as a queue of updates to be pushed to salesforce.com.

    Then using the DBAmp sf_bulkops stored procedure, the updates in the local table would get pushed up to salesforce.com. The advantage is that the sf_bulkops would batch together the update requests and therefore take advantage of the batch capability of the salesforce.com api.

    Remember that each salesforce.com org can only execute so many api calls in a 24 hour period. This design minimizes the number of api calls required for the integration task.

    If you need more detailed information, please consult the DBAmp Installation Guide on sf_bulkops.

    As always, you can send an email to support@forceamp.com to discuss a specific scenario.

    Bill
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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