topic [resolved] Talend Job as a WEB SERVICE in Installing and Upgrading

[resolved] Talend Job as a WEB SERVICE

Anonymous — Fri, 18 Nov 2016 11:37:02 GMT

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 ?

Re: [resolved] Talend Job as a WEB SERVICE

Anonymous — Mon, 21 Nov 2016 07:39:20 GMT

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

Re: [resolved] Talend Job as a WEB SERVICE

Anonymous — Tue, 22 Nov 2016 09:26:47 GMT

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.

Re: [resolved] Talend Job as a WEB SERVICE

Anonymous — Wed, 23 Nov 2016 09:01:07 GMT

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

Re: [resolved] Talend Job as a WEB SERVICE

Anonymous — Fri, 25 Nov 2016 09:41:37 GMT

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:

Re: [resolved] Talend Job as a WEB SERVICE

vapukov — Fri, 25 Nov 2016 09:49:07 GMT

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

Re: [resolved] Talend Job as a WEB SERVICE

Anonymous — Wed, 07 Dec 2016 06:46:30 GMT

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.