community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More
SOLVED

How to setup a secure connection with AWS MySQL (RDS)

Alteryx Certified Partner

I would like to setup a secure connection with a MySQL database hosted in RDS from Amazon Web Services. 

 

AWS provides only one PEM file (see: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html#MySQL.Concepts.SSLSupport) but the MySQL ODBC connecter in Alteryx provides 6 input options and the one PEM file provided by AWS does not work with it.

 

I did found on stackoverflow (http://stackoverflow.com/questions/5880503/mysql-connection-using-odbc-5-1-with-ssl) the followoing remark:

 

Only fill out the fields:

  • 'SSL Key' (c:\path_to\client-key.pem)
  • 'SSL Certificate' (c:\path_to\client-cert.pem)
  • 'SSL Certificate Authority' (c:\path_to\ca-cert.pem)

 

 

Has anyone experience with this / done it? Any suggestions how to do it?

 

Thanks for any help!

 

Cheers,

 

Hans

Alteryx Certified Partner
Alteryx Certified Partner

Hi Hans,

 

I have tested on our own environment and the following works in regards to connecting - remember the "Verify SSL certificate" checkbox. Please let me know if it works for you.

 

Skærmbillede 2016-02-09 kl. 17.51.30.png

 

Best regards,

Daniel

Highlighted
Alteryx Certified Partner

Hi Daniel, thanks, this works indeed! (took me some time to find the time to test it ;-).

 

Cheers,

 

Hans 

Meteor

Hi Daniel,

 

i tried your approach but it was not working. i have only RSA private key to connect to the server. please let me known what to do and also let me know how to get SSL certificate Authority file. but i can connect from MYSQL Work bench using Standard TCP/IP over SSH connection method. i did not see that type of method in Mysql ODBC connector. how to get that, please help

 

Capture1.PNG

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi,

 

I am not sure the ODBC driver for MySQL support what you are trying to do - is this a RDS instance on AWS?

 

When you connect via SSH you basically connect to the server running the MySQL DB and then do a connection to localhost.

 

Best,

Daniel

Meteor

i did not get what to you told, Can you please elaborate. i need to connect to AWS RDS MYSQL DB instance from Alteryx, let me know how to do that

Alteryx Certified Partner
Alteryx Certified Partner

Hi,

 

Okay - I do not understand why you wan't to create the connection over SSH. When you create a RDS instance of MySQL you get a username and password.

 

Best,

Daniel

Meteor

yes i have the db instance name and username and password for that DB instance. but how to connect to Alteryx with those ? we need to create a connection first rite between the AWS and Alteryx

Alteryx Certified Partner
Alteryx Certified Partner

Hi,

 

Please try with the configuration in this thread that is marked as a solution.

 

If that does not work please provide a screenshot of the configuration as well as the error message.

 

Daniel

Labels