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

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