Six Stars

tAmazonMysqlConnection -- how to use with Amazon cert bundle

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.
2 REPLIES
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

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

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.