How to give input to jar file and get output and store them in database

[Anonymous]

HI ,

I need to give data from Database to Jar file which will output and we need to store that output to database again.How can we do it?

[Anonymous]

Hello,

Could you please give us more information about your requirement? Here is online document about:TalendHelpCenter:Creating an user routine and call it in a Job.

Feel free to let us know if it is what you are looking for?

Best regards

Sabrina

[Anonymous]

Issue here is i created the user routine and added external jar file but the external jar file need to use property file which is available.How can we deal with it?

[ashok5]

Use DB input component to read the data from Database (preferably row component ex: toraclerow) and pass it your jar file using using tjavarow/tjava flex via input methods defined in the jar files to pass the data and then use the output method to extracts the data from the jar then pass it on to a DB output component.

Flow

toraclerowinput--> Tjavarow or tjavaflex --> toracleoutput.

you may need to use additional component depending on how your jar file accepts/returns data.

Thanks

Ashok

[nara1]

this will work

tLibraryLoad --onComponenetOk-->tOracleInput--->tJavaFlex--->tOracleOutput