topic Re: Using an external file in the cloud in Talend Studio

Using an external file in the cloud

RVeitch_84 — Fri, 15 Nov 2024 22:39:48 GMT

Looking for some help in configuring an external resource file in Talend cloud so my job can access it.

Here is the summary, I have a job that runs fine locally using Studio and a wallet file saved locally on my C:\ drive.

I need to now run this job in the cloud, I have added the file in the Management console but need help in defining that in my job.

Here is the context variable that I am using locally which works fine:

javax.net.ssl.trustStoreType=SSO&javax.net.ssl.keyStoreType=SSO&javax.net.ssl.trustStore=C:/Talend/wallet_nsaw_sb/cwallet.sso&javax.net.ssl.keyStore=C:/Talend/wallet_nsaw_sb/cwallet.sso

And here is my external resource file that I uploaded to the management console.

So now I am trying to understand on how to set the cloud file, ADW_wallet_sb in my string.

javax.net.ssl.trustStoreType=SSO&javax.net.ssl.keyStoreType=SSO&javax.net.ssl.trustStore=???&javax.net.ssl.keyStore=???

Thanks

for any help.

Re: Using an external file in the cloud

Anonymous — Thu, 11 Aug 2022 03:51:22 GMT

To use an resource file in TMC, you should define the name of context variable in studio like this:

resource_file_resourceName

eg:

resource_file_adw_wallet_sb

Then, you can use the context variable in the filed like:

"javax.net.ssl.trustStoreType=SSO&javax.net.ssl.keyStoreType=SSO&javax.net.ssl.trustStore="+context.resource_file_adw_wallet_sb+"&javax.net.ssl.keyStore="+context.resource_file_adw_wallet_sb

Regards

Shong

Re: Using an external file in the cloud

RVeitch_84 — Thu, 11 Aug 2022 12:31:53 GMT

Shong

Thanks for the quick reply, I tried the format that you suggested and still have the error.

See my db connection :

Re: Using an external file in the cloud

Anonymous — Fri, 12 Aug 2022 01:50:23 GMT

Make sure the Job works fine in studio, before you publish it to Talend Cloud. Maybe the error is caused by the char '-' in resource name, try to rename the resource and context variable without '-'.

Let me know if it works.

Regards

Shong

Re: Using an external file in the cloud

RVeitch_84 — Fri, 12 Aug 2022 15:33:31 GMT

I'm testing in Studio, and I tried renaming the resouce without the "_" and I still have the same error.

See my DB connection:

I added a tJava at the start of the job to print out the context.wallet. this is what I got?

resource file = C:\Talend-Studio-20211109_1610-V8.0.1\workspace\.repositories\1347947789\main\TALENDJOBS\poms\jobs\process\Netsuite\Square\cloud_square_payments_adw_1.0\src\main\ext-resources\talendjobs\cloud_square_payments_adw_1_0\resources\cwallet_0.1.sso

Let me know if you have any other questions.

Re: Using an external file in the cloud

Anonymous — Fri, 12 Aug 2022 17:15:39 GMT

@Robert Veitch , the context variable should follow the format: resource_file_resourceName, eg: resource_file_wallet

It is a compilation error, open the Job code and see which lines has the error.

Re: Using an external file in the cloud

RVeitch_84 — Fri, 12 Aug 2022 17:20:31 GMT

java.util.Properties atnParamsPrope_tDBConnection_1 = new java.util.Properties();

atnParamsPrope_tDBConnection_1.put("user", dbUser_tDBConnection_1);

atnParamsPrope_tDBConnection_1.put("password", dbPwd_tDBConnection_1);

if ("javax.net.ssl.keyStoreType=SSO&javax.net.ssl.keyStore=" + context.wallet != null

&& !"\"\"".equals("javax.net.ssl.keyStoreType=SSO&javax.net.ssl.keyStore=" + context.wallet)

&& !"".equals("javax.net.ssl.keyStoreType=SSO&javax.net.ssl.keyStore=" + context.wallet)) {

atnParamsPrope_tDBConnection_1.load(

new java.io.ByteArrayInputStream("javax.net.ssl.keyStoreType=SSO&javax.net.ssl.keyStore="

+ context.wallet.replace("&", "\n").getBytes()));

}

conn_tDBConnection_1 = java.sql.DriverManager.getConnection(url_tDBConnection_1,

atnParamsPrope_tDBConnection_1);

log.debug("tDBConnection_1 - Connection to '" + url_tDBConnection_1 + "' has succeeded.");