topic tAmazonMysqlConnection -- how to use with Amazon cert bundle in Talend Studio

tAmazonMysqlConnection -- how to use with Amazon cert bundle

tale103108 — Fri, 17 Mar 2017 14:35:04 GMT

Talend Open Studio 6.3
Windows 7
JDK 1.8.0.111
MySQL 5.5
-------------
I need an example of how to use the tAmazonMysqlConnection component with an Amazon cert bundle. I don't see anywhere in the component where you can specify the cert or cert location. I do know you have to add to the "Additional JDBC Parameters" the following:
useSSL=true
How is a connection accomplished using the tAmazonMysqlConnection component with a Amazon cert bundle? Where do you specify the cert bundle location?
Please provide images if possible.
Thank you.

Re: tAmazonMysqlConnection -- how to use with Amazon cert bundle

Anonymous — Mon, 20 Mar 2017 03:31:44 GMT

Hi,
Here is a TalendHelpCenter:tSetKeystore which submits authentication data of a truststore with or without keystore to validation for the SSL connection.
Best regards
Sabrina

Re: tAmazonMysqlConnection -- how to use with Amazon cert bundle

tale103108 — Tue, 04 Apr 2017 16:41:20 GMT

What I need to do is create a connection similar to the following (file names anonymized):

mysql -h myinstance.c9akciq32.rds-us-east-1.amazonaws.com
--ssl-ca= rds-combined-ca-bundle.pem --ssl-verify-server-cert

The key mentioned above is a public key available from Amazon RDS.