LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: pdespot

**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:

• Lavastorm 4.6 Professional Plus
• Free Enhanced Analytics Library (LAL)- downloadable from http://www.lavastorm.com/resources/s...alytics-engine
• A Salesforce.com account with API access enabled

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.

Attachments:
sfdc.brg
sfdc_icons.zip
Sales Commission Reconciliation.zip

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Sreya

Originally posted by: pdespot
					


**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:


Lavastorm 4.6 Professional Plus
Free Enhanced Analytics Library (LAL)- downloadable from http://www.lavastorm.com/resources/s...alytics-engine

A Salesforce.com account with API access enabled


Installation instructions:


Download the three files attached to this post
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
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
Open BRE, go to the Graph menu and select Edit Base Libraries
Create a new entry, enter sfdc, and click OK
Four new categories will appear, each with a name beginning with "_SFDC"
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
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

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: johnpelz

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

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Sreya

Originally posted by: johnpelz
					

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?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: abhisek

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.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: abhisek

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.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

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

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: kgarlow

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

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

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

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

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