Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
tale103108
Contributor III
Contributor III

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.
Labels (3)
2 Replies
Anonymous
Not applicable

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
tale103108
Contributor III
Contributor III
Author

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.