[resolved] Talend Job as a WEB SERVICE

[Anonymous]

I have created a JOB in Talend .
Now I want to call this job as a WEB SERVICE from my .NET(MVC) project. How can I do that?
My job needs 1 excel file for its input , So are there any Component that takes input for web service ?

[Anonymous]

Hi,
You can use  TalendHelpCenter:tWebServiceInput to c all the defined method from the invoked Web service, and returns the class as defined, based on the given parameters.
Here is a KB article about: TalendHelpCenter:Calling a Web service in Talend Studio
Best regards
Sabrina

[Anonymous]

hi ,
First of all thanks for reply. But I would like to explain my requirement in detailed manner:
I have attached the screenshot of created Job.
Now as u can see, this job requires 1 Excel file and 2 tables from database as a Input and It is mapping those to MSSQL server database.

I want to deploy it as a Web Service. So that I can call it from my MVC(.net) application.

I followed steps from following link:

https://www.talendforge.org/tutorials/tutorial.php?idTuto=38

As per above mentioned link I build this job as Web Service(Axis web service)(WAR) and also deployed it on TOMCAT server.
But I am unable to see anything. In what way I can achieve this??


Thanks,
Abhijit.

[Anonymous]

Hi,
Can you successfully deploy your job(.war)in Tomcat webapp and call the job from browser?
The tutorial link you provided is out of date. Could you please have a look at online document about:TalendHelpCenter:How to build Jobs?
Best regards
Sabrina

[Anonymous]

hi,
Thanks for reply. I referred the document you mentioned.
As per that I have build my job as a Axis web service successfully.
I am trying to deploy it over tomcat server , but when I try to run it in browser I am getting the following error:-


HTTP Status 500 - Servlet.init() for servlet AxisServlet threw exception

I have attached the error screenshot.

I tried integrating axis 2 with tomcat server.
I tried increasing heap size for tomcat applications.
I tried deploying it over WILDFLY server.
Nothing worked for me.

Could you please help me with this.
Thanks in advance.
Error Screenshot:

[vapukov]

may be You need check Talend Studio for ESB?
If You install it and import DEMO project - it will include examples very close to what You try to do

[Anonymous]

hi,
Now I am able to get this job done. Issue was resolved by-

Replacing the relevant JAR files:-
1>axis.jar
2>wsdl4j-1.6.2.jar


Now I can run it as a Web Service.

Thanks you all.