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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
tale103108
Contributor III
Contributor III

Connection to Amazon RDS with tAmazonsqlConnection fails -- how to use tSetKeystore with AWS cert

Talend Open Studio 6.3
Windows 10
JDK 1.8.0.111
MySQL 5.6
-------------
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.

 

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.

 

Thank you.

 

Labels (5)
3 Replies
vapukov
Master II
Master II

tale103108
Contributor III
Contributor III
Author

Your input was helpful.

However, I am using the tAmazonMySQLConnection component.  And I used the keytool to store my AWS cert in the Java cert file jseecacerts under my JRE folder %JRE_HOME%\lib\security

 

0683p000009LsCg.png

tale103108
Contributor III
Contributor III
Author

Here is a related issue -- sounds like I am not the only one having problems.

 

https://community.talend.com/t5/Design-and-Development/Unable-to-connect-using-tAmazonMySqlConnectio...