function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
NishnaNishna 

Can a Batch API from SFDC be called in ODI?

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

a_ja_j

Hello,

 

I don't know much about this field but...

Look at the following documentation: http://www.artofbi.com/?dl_id=1

 

Check out the following links as well, maybe you'll get some useful resources out of them:

http://john-goodwin.blogspot.com/2009/04/odi-series-web-services.html

http://gerardnico.com/doc/odi/webhelp/en/usermanual/agent/execute_ws.htm

 

Hopefully you'll be able to get your way around, one way or another.

 

regards,

asish
NishnaNishna

Hello,

 

Thanks for the reply.

I have tried the steps as in the pdf ArtOfBI_ODI10g_SalesForce_Integration_Deep_Dive.pdf, but cannot reverse an object from salesforce.

The process of reversing fails withthe following error in the step 'Reverse Engineer Core':

org.apache.bsf.BSFException: exception from Jython:
Traceback (innermost last):
  File "<string>", line 12, in ?
  File "<string>", line 230, in login
java.lang.NoClassDefFoundError: Could not initialize class com.sforce.soap.partner.SoapBindingStub


From the other links, application servers like axis2 or tom cat have been mentionned. Using RKM salesforce.com, is an application server required?

 

Thanks for any advice.

 

Regds,

Nishna 
a_ja_j

Nissna,

 

See the points below for your error:

 

1. The error you mentioned seems to be a Login Error, kindly make sure that you have installed ODI PATCH 10.3.5.5 since as per the PDF it's a pre-requisite. Check out this link:

https://community.altiusconsulting.com/blogs/graemeord/archive/2010/01/04/oracle-data-integrator-10-1-3-5-5-patch-available.aspx 

Look for Bug 8636504 and check if the details are similar.

 

2. If the above is not the case, have a look at this page where the author describes the execution of successful reverse engineering:

http://john-goodwin.blogspot.com/2008/09/odi-series-4-enter-designer.html , though through an application server, you still might find it helpful.

 

3. Please make sure that something known as 'DataStore' is unlocked when carrying out the process.

 

 

As to your question, the other links are for alternative solutions. If you are following the PDF, make sure that you have followed the steps as per required and installed the required software with the proper versioning that have been mentioned. My guess is no additional software other than mentioned will be required. 

 

 

My technical skill are limited here, I hope these points provide you with some clearer insight.

 

 

regards,

asish