November 29, 2012 at 7:42 am
Hi All,
I want to use a SSIS package to grab data from an external suppliers mySQL database.
I have read access to the tables I require. My Question is if a run this package on my production server does it propose a security risk?
Many thanks
December 12, 2012 at 9:39 am
Security risk mostly depends on what your package does. If you can provide more details on what does your package do and why do you think it can be a security risk, we can provide a better feedback.
December 13, 2012 at 1:16 am
It might. The package will need access to the external database, so ports probably will have to be opened. And you're transfering data over the network, so there might be some risk there.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2012 at 2:03 am
I think it should be fine, i get the data from a MySql database belonging to an external supplier. We have only allowed the connection from their IP so shouldn't be a problem?
December 13, 2012 at 11:20 pm
Connection from their IP? I thought you said you were connecting to a remote MySQL server. From a network security perspective only an outgoing connection from the server running your SSIS package to the server running MySQL should be necessary to allow.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
December 14, 2012 at 6:21 am
opc.three (12/13/2012)
Connection from their IP? I thought you said you were connecting to a remote MySQL server. From a network security perspective only an outgoing connection from the server running your SSIS package to the server running MySQL should be necessary to allow.
Apologies, typed that last comment in a rush. You a correct there is only the allowed outgoing connection from our server to their IP through the fire wall.
December 14, 2012 at 8:23 am
bugg (12/14/2012)
opc.three (12/13/2012)
Connection from their IP? I thought you said you were connecting to a remote MySQL server. From a network security perspective only an outgoing connection from the server running your SSIS package to the server running MySQL should be necessary to allow.Apologies, typed that last comment in a rush. You a correct there is only the allowed outgoing connection from our server to their IP through the fire wall.
Sounds good. I was just making sure you did not open any unnecessary access points into your network for the data pull. Cheers.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply