topic Re: Any Way to Pass Custom Connection Object To Talend Job ? in Talend Studio

Any Way to Pass Custom Connection Object To Talend Job ?

SherjeelAmer — Sat, 16 Nov 2024 00:25:06 GMT

Hi,

Hope everyone would be doing good.

Our Team has its own custom connection pool mechanism. Due to security concerns we cant use hardcoded connection information values in context variable files for a talend job.

Instead of using context files to pass hardcoded connection information to talend job, Is there any way to pass custom connection object to talend job ?

I came across this link where we can call talend job from an external java application and pass context information using following code.

Calling a Talend Job from an external Java application

String [] context=new String[] {"--context_param nb_line="+nb_line,"--context_param name="+name};

talendJob.runJob(context);

But this does not serve our purpose. We need to pass our own custom connection object instead of passing just values

Is there any other way to pass custom connection object to talend job?

What if we modify java generated code of talend designer and import our connection pool jar and pass its connection to talend job ? is it possible ? Or if we somehow manage to generate parameterized talend jar file and pass our connection object as parameter.

Kindly share possible solution if any Any body who has same requirement and managed to acheive it.. Any helpful insight would be appreciated

Best Regards,

Re: Any Way to Pass Custom Connection Object To Talend Job ?

Anonymous — Thu, 18 Mar 2021 08:43:06 GMT

Hello,

Could you please elaborate your case with an example with input? Passing Custom Connection Object to talend job via global variable?

Here is TalendHelpCenter: tcontextload component which is modifies dynamically the values of the active context. Let us know if it is what you are looking for.

Best regards

Sabrina

Re: Any Way to Pass Custom Connection Object To Talend Job ?

SherjeelAmer — Thu, 18 Mar 2021 11:21:06 GMT

Hi Sabrina,

Thanks for your reply. We use a separate jar file to get required connection object . We need to find a way to get connection object from that custom jar file and pass it to Talend job instead of getting it from context or 'tcontextload' suggested by you.

Regards,

Re: Any Way to Pass Custom Connection Object To Talend Job ?

Anonymous — Fri, 19 Mar 2021 06:53:13 GMT

Hello,

Could you please elaborate your case with an example with input?

Screenshots will be preferred.

Best regards

Sabrina

Re: Any Way to Pass Custom Connection Object To Talend Job ?

SherjeelAmer — Thu, 25 Mar 2021 11:01:15 GMT

Lets take a very basic example of a job reading a table from Database and writing its data in an output File.The connection information of this rDBInput_1 is set through context variables

We cant give connection information like this. Through context variables as a string.

We have a separate java utitlity custom jar which gives us required db connection.

And we want to find a way to get custom connection object from that jar and pass that connection object to Talend Job so that job uses our passed connection

Re: Any Way to Pass Custom Connection Object To Talend Job ?

RNikolova1624628702 — Wed, 11 Jan 2023 15:55:02 GMT

Hey there! We are facing the same problem. Did you find any solution to this, did you manage to pass a custom connection object?