Salesforce.com connection problem with BODS 4.1

[Former Member]

Hi,

We are trying to connect to Salesforce.com via the Saleforce adapter of Business Objects Data Services 4.1 (14.1.1.0). 

After configuring the adapter, we created a datastore, but we are unable to see the tables. 

We checked the proxy and are able to connect to the webservice via SOAPui on the server.

We also tried different end-points:

https://test.salesforce.com/services/Soap/u/21.0

https://test.salesforce.com/services/Soap/u/28.0

This is the error we get in the logs:

29/05/13 9:11:46 There was a communication error when talking to Salesforce.com: Connection timed out: connect

29/05/13 9:11:46 Error browsing root nodes. Xml generated so far: []. com.acta.adapter.salesforce.exceptions.CommunicationFailureException: There was a communication error when talking to Salesforce.com: Connection timed out: connect

at com.acta.adapter.salesforce.SForceMetadata.describeGlobal(SForceMetadata.java:47)

at com.acta.adapter.salesforce.metadata.SForceBrowsing.getRootNodes(SForceBrowsing.java:70)

at com.acta.adapter.sdk.AdapterRunnerImpl.processBrowseRoot(AdapterRunnerImpl.java:2304)

at com.acta.adapter.sdk.AdapterServiceDataListener.handleBrokerMessage(AdapterServiceDataListener.java:104)

at com.acta.brokerclient.BrokerClient.handleMessage(BrokerClient.java:448)

at com.acta.brokerclient.BrokerClient.access$100(BrokerClient.java:53)

at com.acta.brokerclient.BrokerClient$MessageHandler.run(BrokerClient.java:1600)

at com.acta.brokerclient.ThreadPool$PoolThread.run(ThreadPool.java:100)

Any help is appreciated.

Tom

[Former Member]

We found the issue.

Not only test.salesforce.com, but all communications to *.salesforce.com must be whitelisted.