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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.