tAmazonMysqlConnection -- how to use with Amazon cert bundle

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.
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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch