cancel
Showing results for 
Search instead for 
Did you mean: 

Webservice end point in case of SFDC Sandbox in Datastore?

Former Member
0 Kudos

Hi Experts,

I am currently working on BODS 4.1 . I am trying to  create a datastore of Adapter type for SFDC .

I have the user name ,password and passtoken for SFDC sandbox(test.salesforce.com).

what would be the webservice end point ,to be passed in datastore defination as by default it is https://www.salesforce.com/services/Soap/u/21.0

But in case of //test.salesforce.com (Sandbox SFDC) ,waht would be the value of Webservice end point.,as it is not allowing me to create the datastore with default web service end point.

Any help is appreciated.

Thanks & Regards,

Mayank

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member254877
Participant
0 Kudos

Can you try with the below End point:

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

in case if you are unable to create, attaché the error screen shot.

Former Member
0 Kudos

Srinivas -

I'm getting the error "Fault-tolerance-login-failed:There was a communication error when talking to Salesforce.com: password cannot be null!!", but i have already entered the password.

regards

bhargavi

Former Member
0 Kudos

My salesforce connectivity issue has been resolved after i downgraded my Designer from 14.1.2.378 to 14.1.1.210.

http://solveissue.com/note?id=1956235

Bhargavi

Former Member
0 Kudos
Former Member
0 Kudos

Hello -

My salesforce adapter working fine in production, but having problems with QA environment.

I'm using the web service https://test.salesforce.com/services/Soap/u/21.0 and I'm able to create the QA configuration and SalesForce Admin confirmed that they see my successful connectivity messages.

But my problem, when i run the job I don't get the data and get the error in Data Services

Error preparing to read <Query>: <Could not create a new session (Adapter: 'SalesForce').>.

And salesforce adapter has this error

There was a communication error when talking to Salesforce.com: password cannot be null!!

Fault-tolerance-login-failed:There was a communication error when talking to Salesforce.com: password cannot be null!!

My BO DS is 4.0.

I greatly appreciate if anybody can help with this issue.

Regards

Bhargavi

Former Member
0 Kudos

Hey Bhargavi,

Just wondering when you configured the Datastore within BODS and you input the username and password. Did you attach the security token to the password section?

Best Regards,

Matthew Ong

Former Member
0 Kudos

Hello Matthew -

Thank you for your response. Yes i did attach the security token to the password section.

Regards

Bhargavi

Former Member
0 Kudos

Hi Mayank,

Do you have a solution or an update on this problem?

Former Member
0 Kudos

Hi Mayank,

You should have a WSDL url. That should work when creating the datastore.

Arun J

Former Member
0 Kudos

Thanks Arun,

But here we are not using webservices.

The datastore is of "Adapter" type

And when we create a datastore of adapter type for sales force ,by default a webservice end point appears which is https://www.salesforce.com/services/Soap/u/21.0.which works fine with the production box(//login.salesforce.com).

But it seems that the end point is not working in case of Sandbox SFDC (//test.salesforce.com)

Regards,

Mayank Mehta