Home / server / Questions / 201231
Accepted
MattB
Asked: 2010-11-13 08:46:59 +0800 CST

Possible to connect securely to remote MySQL using SSIS?

  • 772

I've downloaded an ADO.NET and ODBC connector from the MySQL website. I'd like to access a remote MySQL server from within BIDS with the goal of importing the remote data and populating a local SQL Server database.

While it looks like making the connection is relatively easy, does anyone know if it's possible to connect securely so that data is encrypted?

mysql ssis

1 Answers

  1. Best Answer

    Is deploying an SSL Certificate an option?

    http://www.connectionstrings.com/mysql#p31

    Using SSL

    Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;User=myUsername; Password=myPassword;sslca=c:\cacert.pem;sslcert=c:\client-cert.pem;sslkey=c:\client-key.pem;sslverify=1;Option=3;

    Also, Matthew Flaschen suggests an option here: link

    • 1