• Nishna
  • NEWBIE
  • 25 Points
  • Member since 2010

  • Chatter
    Feed
  • 1
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 4
    Questions
  • 3
    Replies

Hey

 

I am using PHP to connect to Salesforce API and connection is established successfully. I have done the Insertion n Query part over Standard and Custom Objects.

 

I need some code to create a Custom Object in Salesforce via PHP Script.

If anyone can help,.....

Hello, 

 

I have to transfer data from a CSV file to SFDC through Oracle Data Integrator.

I have used the doc from

 www.artofbi.com/?dl_id=1 to set up the connection between file and SFDC.

The problem I'm actually facing is that, I do have the new objects  thats are being created in SFDC for each record in the csv filebut the data from the file are not transferred  to the newly created object in SFDC.

 

IKM File to Salesforce(Upsert) has been used in the ODI interface to load data from file to Salesforce.

The doc artofbi recommends ApexDataLoader as well as sforceDataloader.

 

Is sforceDataLoader no longer compatible with salesforce??

 

Any advice would be of great help.

 

Regards,

Nishna

  • January 13, 2011
  • Like
  • 0

Hello, Im trying to import objects from a sandbox to ODI, using RKM Salesforce.com.

I have succesfully imported objects from salesforce application. However, with sandbox I'm having the following error when trying to import its objects in ODI:

 

 

org.apache.bsf.BSFException: exception from Jython:
Traceback (innermost last):
  File "<string>", line 12, in ?
  File "<string>", line 236, in login
AxisFault
 faultCode: INVALID_LOGIN
 faultSubcode:
 faultString: INVALID_LOGIN: Invalid username, password, security token; or user locked out.
 faultActor:
 faultNode:
 faultDetail:
{urn:fault.enterprise.soap.sforce.com}LoginFault:<ns1:exceptionCode>INVALID_LOGIN</ns1:exceptionCode><ns1:exceptionMessage>Invalid username, password, security token; or user locked out.</ns1:exceptionMessage>
INVALID_LOGIN: Invalid username, password, security token; or user locked out.

 


The reason for such an error, might be that ODI is trying to log into https://login.salesforce.com/ with the sandbox credentials.
Can anyone please advice on how to load sandbox objects into ODI.


Thanks.
Regds,
Nishna

 

  • January 12, 2011
  • Like
  • 0

Hello,

 

Im trying to import objects from a sandbox to ODI, using RKM Salesforce.com.

 

I have succesfully imported objects from salesforce application. However, with sandbox I'm having the following error when trying to import its objects in ODI:

 


 

org.apache.bsf.BSFException: exception from Jython:
Traceback (innermost last):
  File "<string>", line 12, in ?
  File "<string>", line 236, in login
AxisFault
 faultCode: INVALID_LOGIN
 faultSubcode: 
 faultString: INVALID_LOGIN: Invalid username, password, security token; or user locked out.
 faultActor: 
 faultNode: 
 faultDetail: 
{urn:fault.enterprise.soap.sforce.com}LoginFault:<ns1:exceptionCode>INVALID_LOGIN</ns1:exceptionCode><ns1:exceptionMessage>Invalid username, password, security token; or user locked out.</ns1:exceptionMessage>
INVALID_LOGIN: Invalid username, password, security token; or user locked out.

The reason for such an error, might be that ODI is trying to log into https://login.salesforce.com/ with the sandbox credentials.
Can anyone please advice on how to load sandbox objects into ODI.
Thanks.
Regds,
Nishna

 


 


  • January 11, 2011
  • Like
  • 0

Hello, I have to execute a Batch API, created in Salesforce , in ODI.

 

I've been through several forum but could not find much on this.

Can this be done through an ODI procedure (using Salesforce.com as technology), calling the apex class??

 

Or does this need to be done through web services in ODI?

 

Any help would be highly appreciated.

 

Regds,

Nishna

  • December 22, 2010
  • Like
  • 0

Hey

 

I am using PHP to connect to Salesforce API and connection is established successfully. I have done the Insertion n Query part over Standard and Custom Objects.

 

I need some code to create a Custom Object in Salesforce via PHP Script.

If anyone can help,.....

Hello, Im trying to import objects from a sandbox to ODI, using RKM Salesforce.com.

I have succesfully imported objects from salesforce application. However, with sandbox I'm having the following error when trying to import its objects in ODI:

 

 

org.apache.bsf.BSFException: exception from Jython:
Traceback (innermost last):
  File "<string>", line 12, in ?
  File "<string>", line 236, in login
AxisFault
 faultCode: INVALID_LOGIN
 faultSubcode:
 faultString: INVALID_LOGIN: Invalid username, password, security token; or user locked out.
 faultActor:
 faultNode:
 faultDetail:
{urn:fault.enterprise.soap.sforce.com}LoginFault:<ns1:exceptionCode>INVALID_LOGIN</ns1:exceptionCode><ns1:exceptionMessage>Invalid username, password, security token; or user locked out.</ns1:exceptionMessage>
INVALID_LOGIN: Invalid username, password, security token; or user locked out.

 


The reason for such an error, might be that ODI is trying to log into https://login.salesforce.com/ with the sandbox credentials.
Can anyone please advice on how to load sandbox objects into ODI.


Thanks.
Regds,
Nishna

 

  • January 12, 2011
  • Like
  • 0

Hello, I have to execute a Batch API, created in Salesforce , in ODI.

 

I've been through several forum but could not find much on this.

Can this be done through an ODI procedure (using Salesforce.com as technology), calling the apex class??

 

Or does this need to be done through web services in ODI?

 

Any help would be highly appreciated.

 

Regds,

Nishna

  • December 22, 2010
  • Like
  • 0