Results 1 to 10 of 10

Thread: Salesforce Integration Example Nodes

  1. #1
    Contributor
    Join Date
    Jan 2013
    Location
    Boston, MA
    Posts
    15

    Default Salesforce Integration Example Nodes

    **Nodes released into this community are prototypes. They have gone through a minimum set of tests; therefore, we cannot guarantee that they will work as designed nor are they supported by any existing maintenance contracts.**

    The library nodes in the attached sfdc.brg file allow users to read from and write to their Salesforce instance from within an LAE graph. This allows Salesforce data to be used in the same way Excel, CSV, database, etc. data is used (i.e. acquired, transformed, correlated, and published).

    Attachments:
    • sfdc.brg - the library file containing the nodes
    • sfdc_icons.zip - the new icons for the SFDC library
    • Sales Commission Reconciliation.zip - a sample graph and data using the SFDC nodes

    Requirements:

    Installation instructions:
    1. Download the three files attached to this post
    2. Copy the sfdc.brg file to your brain library directory. This will either be in C:\Program Files (x86)\Lavastorm\LAE 4.6\lib\brain\brg or, alternatively, in any directory listed in BRE under Tools -> Preferences -> Search Paths
    3. Open the sfdc_icons.zip file and extract its contents. The contents should be placed the lib/brain/bre directory which is a sub directory of the Lavastorm home directory on your PC. The Lavastorm home directory is either C:\Program Files (x86)\Lavastorm or C:\Program Files\Lavastorm therefore the files should be unzipped into C:\Program Files (x86)\Lavastorm\LAE 4.6\lib\brain\bre or C:\Program Files\Lavastorm\LAE 4.6\lib\brain\bre
    4. Open BRE, go to the Graph menu and select Edit Base Libraries
    5. Create a new entry, enter sfdc, and click OK
    6. Four new categories will appear, each with a name beginning with "_SFDC"
    7. Optionally, for an example on how to use these nodes, the Sales Commission Reconciliation.zip file should be unzipped and the Sales Commission Reconciliation.brg opened in BRE
    8. This graph contains an pre-built example of a sales commission verification graph and requires only that the graph parameters be filled in appropriately. Note: You must enter your own Salesforce.com API credentials in the graph parameters.
    Attached Files Attached Files

  2. #2

    Default Facing difficulties in executing the sales commission reconciliation file

    Quote Originally Posted by pdespot View Post
    **Nodes released into this community are prototypes. They have gone through a minimum set of tests; therefore, we cannot guarantee that they will work as designed nor are they supported by any existing maintenance contracts.**

    The library nodes in the attached sfdc.brg file allow users to read from and write to their Salesforce instance from within an LAE graph. This allows Salesforce data to be used in the same way Excel, CSV, database, etc. data is used (i.e. acquired, transformed, correlated, and published).

    Attachments:
    • sfdc.brg - the library file containing the nodes
    • sfdc_icons.zip - the new icons for the SFDC library
    • Sales Commission Reconciliation.zip - a sample graph and data using the SFDC nodes

    Requirements:

    Installation instructions:
    1. Download the three files attached to this post
    2. Copy the sfdc.brg file to your brain library directory. This will either be in C:\Program Files (x86)\Lavastorm\LAE 4.6\lib\brain\brg or, alternatively, in any directory listed in BRE under Tools -> Preferences -> Search Paths
    3. Open the sfdc_icons.zip file and extract its contents. The contents should be placed the lib/brain/bre directory which is a sub directory of the Lavastorm home directory on your PC. The Lavastorm home directory is either C:\Program Files (x86)\Lavastorm or C:\Program Files\Lavastorm therefore the files should be unzipped into C:\Program Files (x86)\Lavastorm\LAE 4.6\lib\brain\bre or C:\Program Files\Lavastorm\LAE 4.6\lib\brain\bre
    4. Open BRE, go to the Graph menu and select Edit Base Libraries
    5. Create a new entry, enter sfdc, and click OK
    6. Four new categories will appear, each with a name beginning with "_SFDC"
    7. Optionally, for an example on how to use these nodes, the Sales Commission Reconciliation.zip file should be unzipped and the Sales Commission Reconciliation.brg opened in BRE
    8. This graph contains an pre-built example of a sales commission verification graph and requires only that the graph parameters be filled in appropriately. Note: You must enter your own Salesforce.com API credentials in the graph parameters.


    Hi,

    I have two questions regarding this:

    1. What should be the sfSecurityToken Parameter for SFDC login node?
    2. If I set the sfUseToken parameter to false and run, I am getting an XML error.
    I have attached the error log here.

    Please reply me on what should be done to run the node properly asap.SFDC-Error Log - SFDC Login -3.txt

  3. #3

    Default

    Hi,

    Are you attempting to connect to your own Salesforce.com instance or sandbox? If so, you will need to grant API access to the user you are attempting to connect with. See the following link for instructions (# "User Profile and Permission Sets Configuration section")

    http://www.salesforce.com/us/develop...s_security.htm

    Thanks

  4. #4

    Default

    Quote Originally Posted by johnpelz View Post
    Hi,

    Are you attempting to connect to your own Salesforce.com instance or sandbox? If so, you will need to grant API access to the user you are attempting to connect with. See the following link for instructions (# "User Profile and Permission Sets Configuration section")

    http://www.salesforce.com/us/develop...s_security.htm

    Thanks
    Hi,

    Thanks a lot for your quick reply.

    I am not attempting to connect to a sandbox.
    I have registered to SFDC chatter created for my organisation and I'm logging in there using my Userid and password. I dot have a token.

    Can you tell me what should I do in that case?

  5. #5

    Default

    Hi,

    While connecting to the object, I am receiving connection refused error. Details of error below.


    -- Errors for Create_Job_2
    -- Errors for Create_new_Job
    2015-12-23 06:05:30.961; DEBUG: Node created. Duration: (11)
    id: 9 chain: 8 group: 0
    javaDetail: com.lavastorm.brain.execution.java.node.NodeWrappe r.nodeCreate(NodeWrapper.java@486)

    2015-12-23 06:05:30.964; DEBUG: Setting up node
    id: 10 chain: 9 group: 0
    javaDetail: com.lavastorm.brain.execution.java.node.NodeWrappe r.nodeSetup(NodeWrapper.java@493)

    2015-12-23 06:05:31.039; DEBUG: Node setup. Duration (75).
    id: 11 chain: 10 group: 0
    javaDetail: com.lavastorm.brain.execution.java.node.NodeWrappe r.nodeSetup(NodeWrapper.java@517)

    2015-12-23 06:05:31.040; DEBUG: Running node
    id: 12 chain: 11 group: 0
    javaDetail: com.lavastorm.brain.execution.java.node.NodeWrappe r.nodeProcess(NodeWrapper.java@524)

    2015-12-23 06:08:40.872; ERROR: A connection error occurred for POST request to https://cs42.salesforce.com/services/async/29.0/job. See exception detail.
    id: 13 chain: 0 group: 0
    javaExceptionDetail: org.apache.http.conn.HttpHostConnectException: 'Connection to https://cs42.salesforce.com refused';
    stack trace:
    org.apache.http.impl.conn.DefaultClientConnectionO perator.openConnection(DefaultClientConnectionOper ator.java@190)
    org.apache.http.impl.conn.ManagedClientConnectionI mpl.open(ManagedClientConnectionImpl.java@294)
    org.apache.http.impl.client.DefaultRequestDirector .tryConnect(DefaultRequestDirector.java@643)
    org.apache.http.impl.client.DefaultRequestDirector .execute(DefaultRequestDirector.java@479)
    org.apache.http.impl.client.AbstractHttpClient.exe cute(AbstractHttpClient.java@906)
    org.apache.http.impl.client.AbstractHttpClient.exe cute(AbstractHttpClient.java@805)
    com.lavastorm.brain.node.http.HttpNode.executeRequ est(HttpNode.java@973)
    com.lavastorm.brain.node.http.HttpNode.processAll( HttpNode.java@1540)
    com.lavastorm.brain.execution.java.node.NodeWrappe r.nodeProcess(NodeWrapper.java@527)
    com.lavastorm.brain.execution.java.node.NodeWrappe r.run(NodeWrapper.java@769)
    com.lavastorm.brain.execution.java.node.NodeWrappe r.main(NodeWrapper.java@1466)
    javaDetail: com.lavastorm.brain.node.http.HttpNode.executeRequ est(HttpNode.java@982)
    dataDetail:
    response(out) row: 0
    columns: ['Call_Result', 'com.lavastorm.lang.UnicodeString'], ['StatusCode', 'java.lang.Integer'], ['StatusMessage', 'java.lang.String'], ['baseURL', 'java.lang.String'], ['resourcesURL', 'java.lang.String'], ['objectURL', 'java.lang.String'], ['userId', 'java.lang.String'], ['bulkURL', 'java.lang.String'], ['header', 'java.lang.String']
    out1(in) row: 1
    columns: ['baseURL', 'java.lang.String'], ['resourcesURL', 'java.lang.String'], ['objectURL', 'java.lang.String'], ['userId', 'java.lang.String'], ['bulkURL', 'java.lang.String'], ['header', 'java.lang.String']
    records:
    [https://cs42.salesforce.com/services/, https://cs42.salesforce.com/services/data/v29.0/.xml, https://cs42.salesforce.com/services.../sobjects/.xml, 00556000000UwfIAAS, https://cs42.salesforce.com/services/async/29.0/job, X-SFDC-Session: 00D560000008ky7!AQ4AQCYW64p0q6Dpy9shfOg_K2smGC4vy9 bnxW2ugx7tqYPO_Jm_lYT2IeL4RzrvNoGf7zjMWxNfPtNf7QfZ 8sMnhfD2PywW
    Content-Type: application/xml]

    2015-12-23 06:08:40.878; ERROR: Unexpected exception in processing.
    id: 14 chain: 0 group: 0
    javaExceptionDetail: com.lavastorm.brain.node.NodeFailedException: 'null';
    stack trace:
    com.lavastorm.brain.node.AbstractNode.fail(Abstrac tNode.java@289)
    com.lavastorm.brain.node.http.HttpNode.executeRequ est(HttpNode.java@983)
    com.lavastorm.brain.node.http.HttpNode.processAll( HttpNode.java@1540)
    com.lavastorm.brain.execution.java.node.NodeWrappe r.nodeProcess(NodeWrapper.java@527)
    com.lavastorm.brain.execution.java.node.NodeWrappe r.run(NodeWrapper.java@769)
    com.lavastorm.brain.execution.java.node.NodeWrappe r.main(NodeWrapper.java@1466)
    javaDetail: com.lavastorm.brain.node.http.HttpNode.processAll( HttpNode.java@1567)
    dataDetail:
    response(out) row: 0
    columns: ['Call_Result', 'com.lavastorm.lang.UnicodeString'], ['StatusCode', 'java.lang.Integer'], ['StatusMessage', 'java.lang.String'], ['baseURL', 'java.lang.String'], ['resourcesURL', 'java.lang.String'], ['objectURL', 'java.lang.String'], ['userId', 'java.lang.String'], ['bulkURL', 'java.lang.String'], ['header', 'java.lang.String']
    out1(in) row: 1
    columns: ['baseURL', 'java.lang.String'], ['resourcesURL', 'java.lang.String'], ['objectURL', 'java.lang.String'], ['userId', 'java.lang.String'], ['bulkURL', 'java.lang.String'], ['header', 'java.lang.String']
    records:
    [https://cs42.salesforce.com/services/, https://cs42.salesforce.com/services/data/v29.0/.xml, https://cs42.salesforce.com/services.../sobjects/.xml, 00556000000UwfIAAS, https://cs42.salesforce.com/services/async/29.0/job, X-SFDC-Session: 00D560000008ky7!AQ4AQCYW64p0q6Dpy9shfOg_K2smGC4vy9 bnxW2ugx7tqYPO_Jm_lYT2IeL4RzrvNoGf7zjMWxNfPtNf7QfZ 8sMnhfD2PywW
    Content-Type: application/xml]

    2015-12-23 06:08:40.879; DEBUG: Cleaning up node
    id: 15 chain: 12 group: 0
    javaDetail: com.lavastorm.brain.execution.java.node.NodeWrappe r.nodeCleanup(NodeWrapper.java@554)

    2015-12-23 06:08:40.880; DEBUG: Node cleaned up. Duration (1)
    id: 17 chain: 16 group: 0
    javaDetail: com.lavastorm.brain.execution.java.node.NodeWrappe r.nodeCleanup(NodeWrapper.java@584)

    2015-12-23 06:08:40.880; DEBUG: Destroying node
    id: 18 chain: 17 group: 0
    javaDetail: com.lavastorm.brain.execution.java.node.NodeWrappe r.nodeDestroy(NodeWrapper.java@591)

    2015-12-23 06:08:40.881; DEBUG: Node destroyed. duration (1)
    id: 19 chain: 18 group: 0
    javaDetail: com.lavastorm.brain.execution.java.node.NodeWrappe r.nodeDestroy(NodeWrapper.java@608)

    2015-12-23 06:08:40.882; ERROR: Node failed.
    id: 20 chain: 19 group: 0
    javaDetail: com.lavastorm.brain.execution.java.node.NodeWrappe r.run(NodeWrapper.java@799)
    What can be the issue? Is there anything that need to be done from Lavastorm end? I am using LAE 4.6
    Also I am connecting to Salesforce Sandbox.

  6. #6

    Default

    The problem was solved, but the issue could not be identified. We changed the Salesforce Sandbox and it worked. There was no changes needed to be done from Lavastorm end.

  7. #7
    Lavastorm Employee
    Join Date
    Nov 2012
    Location
    Warrington, UK
    Posts
    244

    Default

    Hi,

    FYI the Lavastorm application now ships with a number of improved and fully supported nodes for integration with Salesforce. These nodes are available for use with LAE 6.1 and LAE 6.0.

    The new nodes are:

    Lavastorm Get for Salesforce (in the Acquisition category)
    Lavastorm Update for Salesforce (in the Publishing category)
    Lavastorm Metadata for Salesforce (in the Metadata and Structure category)


    The latest release of LAL for your version of Lavastorm can be downloaded from the Lavastorm website: http://www.lavastorm.com/lavastorm-installers/

    Note, the above link redirects you to the downloads page that is currently hosted on Salesforce here: http://na3.salesforce.com/_ui/selfse...0150000000s09A


    Best regards,
    Adrian
    Last edited by awilliams1024; 03-10-2016 at 10:58 AM.

  8. #8

    Default

    Can anyone describe how to specify, say, TLS 1.2 with the new Salesforce nodes?

  9. #9
    Lavastorm Employee
    Join Date
    Nov 2012
    Location
    Warrington, UK
    Posts
    244

    Default

    The existing versions of the Salesforce nodes do not support TLS 1.2.
    The next release of the Lavastorm Analytic Libraries (LAL 6.1.47.0) will include enhancements to the Salesforce nodes to allow them to utilize TLS 1.2.
    LAL 6.1.47.0 is due to be released later this month.

    Regards,
    Adrian

  10. #10
    Lavastorm Employee
    Join Date
    Nov 2012
    Location
    Warrington, UK
    Posts
    244

    Default

    The latest release of LAL for Lavastorm 6.1.x (LAL 6.1.47.0) can now be downloaded from the Lavastorm website: http://www.lavastorm.com/lavastorm-installers/

    Note, the above link redirects you to the downloads page that is currently hosted on Salesforce here: http://na3.salesforce.com/_ui/selfse...0150000000s09A

    (follow the 'Download Lavastorm Analytic Library' link on the page).

    The enhanced Salseforce nodes also have a new property that enables you to optionally specify the URL of the Salesforce instance you want to connect to, e.g. a Salesforce sandbox instance. By default, the node uses the URL of the Salesforce login server (https://login.salesforce.com) which redirects the connection to the relevant (production) instance associated with your credentials.

    Regards,
    Adrian

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •